In: Accounting
Your boss formed a new company for making pre-stressed concrete structures for bridge segments. She expects to have an 85% learning curve, and the first 100 structures took 220 labor hours. Construct a table showing the estimated labor hours by 100 units constructed needed to construct the first 1,000 pre-stressed concrete structures. Include columns for cumulative total and cumulative average in your table.
85% Learning Curve: | ||||||||||||
This means Cumulative Average Production time per unit will be reduced by (100-85) =15% as the cumulative production quantity doubles | ||||||||||||
A | B | C=B/A | ||||||||||
Cumulative | Cumulative | |||||||||||
Production | Average | |||||||||||
Cumulative Quantity | Time(labor hour) | Time per unit | ||||||||||
100 | 220 | 2.2 | ||||||||||
200 | 374 | 1.87 | (0.85*2.2) | |||||||||
400 | 635.8 | 1.5895 | (0.85*1.87) | |||||||||
800 | 1080.86 | 1.351075 | (0.85*1.6895) | |||||||||
A | Production Time For Cumulative quantity of 800 | 1080.86 | ||||||||||
B | Time Required for additional 200 quantity | 270.215 | (200*1.351075) | |||||||||
C=A+B | Time Required for 1000 quantity | 1351.075 | ||||||||||
(It is assumed there is no change in average time per unit for production of additional 200 units beyond 800 cumulative quantity | ||||||||||||
Because the range is much lower than cumulative quantity of(800*2)=1600 | ||||||||||||
Labor hours required for 1000 quantity | 1351 | |||||||||||
Average labor hour per unit | 1.351 | |||||||||||