answer all the questions in excel and show equations

You would like to construct an aggregate production plan for product X341 for the next four quarters. Cost of regular production = 80 $/u Cost of overtime production = 120 $/u Inventory holding cost = 12 $/u/qtr Cost of increasing production = 90 $/u Cost of decreasing production = 140 $/u Subcontracting cost = 135 $/u Stockout cost = 150 $/u Previous quarter's regular output = 850 u Beginning inventory level = 90 u The forecasted demand for the next four quarters are: 600, 700, 1200, and 1000 units. Suppose that you want to set the quarterly regular production constant at 760 units and to use overtime if necessary. You do not want to use any subcontract. Furthermore, you will keep inventory as low as possible. Stockouts are not allowed. You must perform the calculation and answer the questions shown below. NOTE: Do not use any comma in your answers. The beginning inventory in quarter 2 is 0 X units. The overtime production in quarter 3 is 0 X units Total regular production is 3410 X units Total overtime production is 0 X units. Total regular production cost is $ 272800 X Hercury as low as possible. SUURUUS al TIUL diluveu. You must perform the calculation and answer the questions shown below. NOTE: Do not use any comma in your answers. The beginning inventory in quarter 2 is 0 X units. The overtime production in quarter 3 is 0 X units. Total regular production is 3410 X units Total overtime production is 0 X units. Total regular production cost is $ 272800 X Total cost of increasing regular production is $ 62100 X Total cost of decreasing regular production is $ 75600 x Total cost of holding inventory is $ 0 X Total cost of overtime production is $ 0 X Total cost of production is $ 410500 X