Please help with excel and show the formulas. Thanks!

ABC Company wishes to compare a Chase and Level strategy and reduce their current inventory of 5,000 units of finished goods in stock to 4,000 by the end of the first period. Use ending inventory to calculate carrying costs

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

Chase

Month	Forecast Sales	Production Plan	Inventory	Inventory Cost $	# of workers	Hire or Fire	H/F cost	Payroll	Total
July	5460
August	5340
Sept	5200

What is the total cost of this plan for the 3 months? (6 marks)