Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmLEARN, Learning Curve

Business Formulas

mmLEARN, Learning Curve

Category: Project Management

The learning curve theory states that the time needed to produce a successive unit should be smaller than the time needed to produce the previous unit. Comparing learning curves for different productions may highlight economical implications impacting on the cost of production, the effectiveness of production processes, and ultimately on the profit of organizations.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

LC = Learning curve
T1 = Time to produce the first unit
LR = Learning rate, time needed to produce a unit every time the production doubles
Ln = Natural logarithm

Syntax

mmLEARN(Time_First_Units, Learning_Rate, Units)

Time_First_Units Time to produce the first unit of the input data
Learning_Rate Time to produce a unit every time the production doubles
Units Number of produced units

Example

See example file Business Formulas.xls, sheet mmLEARN.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmPERTSD
  • mmPERTT
  • mmPERTVAR
  • mmCAGR
  • mmGROWTH
  • mmINTERPOLE
  • mmRANGE
  • mmRELATIVE
  • mmSHARE
Related MM4XL software tools
  • Quality Analyst
Source
Nancy C. Weida and Ronny Richardson and Andrew Vazsonyi, 2001, Operations Analysis using Microsoft Excel
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: