Please upload excel file and show the formulas. Thanks!

Opening Inv: 10,000

Ending Inv 4,000

Data

COGS $35.00

Beginning work force 65 employees Hiring cost $350 per employee

Work Hours per month 160 Firing cost $600 per worker

Carrying costs 32% per year Work Standard 2 hours per piece

Labor rate $24

Level Strategy

Datal COGS $35.00 Beginning work force 65 employees Work Hours per month 160 Carrying costs 32% per year Labor rate $24 Hiring cost $350 per employee Firing cost $600 per worker Work Standard 2 hours per piece B) ABC Company wishes to investigate a Level strategy and reduce their current inventory of 10,000 units of finished goods in stock to 4,000 by the end of March. Level Month Invento Invento Hire or H/F cost Payroll Total Forecas t Sales Product ion Plan # of workers Fire ry ry Cost $ July 5460 5340 August Sept 5200 Using the same data above, what is the total cost of this plan for the 3 months? (6 marks)