Explore BrainMass

Calculating expected time of production

A time was set at 0.20 hour per unit based on the 50th unit produced. If the task has a 90 percent learning curve, what would be the expected time of the 100th, 200th, and 400th units?

Work needs to be shown in Excel.

Solution Preview

Please refer attached file for better clarity of formulas.

We know that Y=Kx^n
We are given that Y=0.20 for 50th unit. We should first find the time required to complete first unit.
Where Y=time required ...

Solution Summary

Solution describes the steps to calculate expected time to produce certain items.