c. Use overtime up to 750 cases per period and inventory to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter " O " wherever required.) b. Use a combination of overtime ( 500 cases per period maximum), inventory, and subcontracting ( 500 cases per period maximum) to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter " 0 " wherever required.) a. Use level production. Supplement using overtime as needed, (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter " 0 " wherever required.) Nowjuice, Inc., produces Shakewell e fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Use the following information to develop aggregate plans. Click here for the Excel Data File 1. Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Note: Backlogs are not allowed? . Use level production. Supplement using overtime as needed. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter " 0 " wherever required.) 2. Which plan has the lowest total cost? First Second Third All plans are equal \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Period & May & Jun & Jul & Aug & Sep & Oct & Total \\ \hline Forecast & 4,000 & 4,800 & 5.600 & 7,200 & 6,400 & 5,000 & 33,000 \\ \hline Output & & & & & & & . \\ \hline Regular & & & & & & & \\ \hline Overtime & & & & & & & \\ \hline Subcontract & & & + & & & & \\ \hline Output - Forecast & & & & + & & & \\ \hline inventory & & & & & & & \\ \hline Beginning & & & & & 4 & & \\ \hline Ending & & & & & & & \\ \hline Average & & & & & & & \\ \hline Backlog & & & & & & & \\ \hline Costs: & & & & & & & \\ \hline Regular & & & & & & & \\ \hline Overtime & & & & & & & \\ \hline Subcontract & & & & - & & & \\ \hline Inventory & & & & & & & \\ \hline Back orders & & & & & & & \\ \hline Total & & & & & & & \\ \hline \end{tabular}