Luther’s company has just received an order for 1,200 of its Flying Z machines. The customer wants 350 of them next year, 400 the year after, and the balance in the third year. Luther estimates that after one year of production, the average worker with this one year of experience can produce 12 machines per year. However, new workers are 25% less productive in the first year. He has 25 workers with at least one year of experience to work on the first year’s order. He will need to hire new workers for any production that exceeds what these workers can produce. To further complicate matters, he believes 10% of his current experienced workforce will turnover at the end of the first year and the number of workers from his current workforce should remain steady after that. His history also shows that only 75% of new hires stay after their first year. Given these facts, how many total people should Luther plan to hire over the duration of this order? Please solve in excel. Group of answer choices a. 19 b. 36 c. 45 d. 22
Luther’s company has just received an order for 1,200 of its Flying Z machines. The customer wants 350 of them next year, 400 the year after, and the balance in the third year. Luther estimates that after one year of production, the average worker with this one year of experience can produce 12 machines per year. However, new workers are 25% less productive in the first year. He has 25 workers with at least one year of experience to work on the first year’s order. He will need to hire new workers for any production that exceeds what these workers can produce. To further complicate matters, he believes 10% of his current experienced workforce will turnover at the end of the first year and the number of workers from his current workforce should remain steady after that. His history also shows that only 75% of new hires stay after their first year. Given these facts, how many total people should Luther plan to hire over the duration of this order? Please solve in excel.
Group of answer choices
a. 19
b. 36
c. 45
d. 22
Step by step
Solved in 4 steps with 2 images
