Given the following information; develop a spreadsheet in Microsoft Excel to show the

calculation for the total cost if the organization uses the Chase strategy for their production.

Hiring Cost $=$$$150$ per worker

Firing Cost $=$$$500$ per worker

Inventory $/$ carrying cost $=$$$2\mathrm{.}50$ pound per quarter

Regular production cost per unit $=$$$5\mathrm{.}00$

Production per employee $=1,200$ unit per quarter

Beginning work force $=100$ workers