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.

QUARTERS SALES FORECAST

Spring $110,500$

Summer $105,000$

Fall $135,000$

Winter $180,000$

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