You would like to construct an aggregate production plan for product CT34 for the four quarters of next year. Cost of regular production 70 $/u Cost of overtime production - 95 $/ Inventory holding cost $/u/qtr Cost of increasing production 80 $/u Cost of decreasing production 110 $/ The regular production for the last quarter of this year 1900 u Inventory level at the end of the last quarter of this year 140 u The forecasted demand for the four quarters of next year are: 2600, 2800, 2200, and 1800 units. You want to use the level production strategy with overtime production when needed. At the moment, you set the level production at 2300 units per quarter. You want to keep inventory as low as possible. Stockouts (shortages) are not allowed. Construct a spreadsheet showing the production plan for next year. Galculate all related costs for the plan. You must submit a report (EXCEL spreadsheets) showing calculation and brief explanation. You must use your name as the file name of your report(e.g., Brown-Stacy-HW1). Only a clean and organized report will get points