Just answer question 2 please

A B C D E 1 2 3 4 Demand Labour hours per employee Number of employees Labor productivity Last Year 1500 160 P 2.344 This Year 1875 160 N 2.344 crates per month hours per month employees crates per labour hour 5 6 7 8 Labor productivity = Outpur / Labour hours 9 10 11 12 13 14 15 Last Year This year Labor productivity = Demand / 160P Labor productivity = Demand / 160N 2.344 = 1500/160P 2.344 = 1875/160N P = 1500/(160*2.344) N = 1875/(160*2.344) 3.999573379 4.999466724 Additional employees to add 1 B D E 1 2 Last Year This Year 3 1500 160 =C3*1.25 =C4 4 Demand Labour hours per employee Number of employees Labor productivity crates per month hours per month employees crates per labour hour 5 P N 6 2.344 =C6 7 8 Labor productivity = Outpur / Labour hours 9 10 11 12 13 14 15 Last Year This year Labor productivity = Demand / 160P Labor productivity = Demand / 160N 2.344 = 1500/160P 2.344 = 1875/160N P = 1500/(160*2.344) N = 1875/(160* 2.344) =1500/(160*2.344) =1875/(160*2.344) Additional employees to add =ROUND(D14-C14,0) Question 2 (10 points) Based on the conditions given in Question 1, your team at your warehouse work 160 hours per month and are paid $15 per hour. To perform a consolidating work using mechanical equipment, it cost you $0.35 per job and the electricity bill averages $500 per month. Assuming you have five workers and that your warehouse processes 2000 crates per months, compute the multi-factor productivity (round your final answer to three decimals). Question 1 (10 points) Imagine you are an entrepreneur running your own freight forwarding and consolidated warehousing start-up in Mississauga. Last year demand for your services was 1500 crates per months. Your operations team forecasts that this year the demand for your services will grow by 25%. You are aware that our warehouse does not have enough room to place more crates. But the operations team suggests that it is possible to increase freight capacity if you arrange the crates and equipment at the warehouse differently. However, based on your extensive experience, you immediately figure that this may require additional labor-hours, though it would allow the warehouse to meet the 25% rise in demand without expanding the warehouse. Each employee works 160 hours per month. Last year, labor productivity was 2.344 crates per laborhour. To meet this year's demand, how many employees should you add to last year's workforce, if you target the same labor productivity? (keep decimals in your intermediate calculations but round your final answer to zero decimals)