solve with excel

Production Analysis Problem #12 The Abendigo Division of Block Enterprises has a steady output of 550 units each month for its large marine fire suppression nozzle. At the present time overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month. Unit costs are: Regular output = $20 Overtime = $30 Subcontract - $25 Average Inventory = $10 Abendigo has a forecast for the next six months: Month Forecast 1 540 2 3 540 570 4 590 5 600 6 580 Suppose that backlogs are not allowed. Develop an aggregate plan for the next six months. This problem is to be solved using a computer