$1)$ Given the data provided in Table $8-2$ and Table $8-3$ in the textbook for Red Tomato Tools, use the Excel model to determine the $$optimal$$ aggregate plan for the planning horizon. 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? Which aggregate planning strategy is employed here?

Cost: $$422,740$

Revenue: $$640,000$

Profit: $$217,260$