If you could show the work/math that would be really helpful

Current Situation: Wes and Steve have begun to sell their bottled hot sauce to area markets. They have prepared a forecast of expected demand for the bottles for the next 6 periods as shown below. Given this information and the data re: capacities and costs, complete the 2 required aggregate plans on the next pages and answer the Qs shown. Period 1 2 4 5 6 Forecast 400 450 200 300 450 300 Maximum regular production = 300 units/period Maximum overtime = 40 units/period Maximum Subcontracting = 150/period Beginning inventory = 0 Ending inventory (in period 6) = 0 Regular time cost = $10 Overtime cost = $15 Sub-contract cost = $25 Inventory holding costs are $2/average unit/period Backorders cost of $20/unit/period Important Notes: . . You must write neatly and NOT in red ink. You are not permitted to cross out answers, use white-out or start over. If I cannot read your work, you will receive zero points. Round to 2 decimal points if necessary. CARRY THROUGH ERRORS COUNT and points will be deducted! Double check your work. Instructions: Print this and next page, reproduce by hand or complete via computer. Complete each of the plans and provide answers on the next page on the line provided ONLY. When completed: Take a photo of THIS AND NEXT PAGE ONLY save file and upload via the corresponding Assignment link in Canvas by the due date. Remember: No.HEIC files are permitted. LEVEL PLAN (10 pts) Periods 1 2 3 4 5 6 TOTAL Forecast 400 450 200 300 450 300 Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average |Backlog Costs: Output: Regular Overtime Subcontract Inventory Back orders Total Continue to Next Page CHASE PLAN (10 pts) Period 1 2 3 4 5 6 TOTAL Forecast 400 450 200 300 450 300 putput Regular Overtimel Subcontract) putput - Forecast Inventory Beginning Ending) Average Backlog Costs: putput: Regular Overtime Subcontract Inventory Back orders Total (1 pt) 1. Which plan is better from a cost standpoint? 2. Which plan is better for employees? Why? (1 pt) 3. For each plan, how would service/quality be jeopardized (be very brief with your response)? (2 pts) Level: Chase: 4. If demand was to increase over time, what SPECIFIC STRATEGY action must Wes and Steve undertake to ensure profitability, cost effectiveness and quality for their business? (FYI be specific when stating how; there is only one correct answer to this Q) (1 pt)