$3)$ Assume the data given in Table $8-2$ and Table $8-3$ in the textbook for Red Tomato Tools, except the costs of hiring and layoff decrease to $$50$ each. Use the Excel model to recommend an $$optimal$$ aggregate plan for the new cost structure. There is a requirement for no stockouts at the end of June and at least $500$ units in inventory. What is the total cost, revenue, and profit for this plan? What differences on the Plan Chart worksheet are apparent with the lower costs of hiring and layoff chart compared to the original cost structure? Which aggregate planning strategy is employed here?

Cost: $415,540$

Revenue: $640,000$

Profit: $224,640$