kindly solve this problem using linear programming and solve it in solver excel. please make sure that the answer pictures are clear in the excel sheet and state the answer below each picture. Also, state the answer of each question clearly. Many thanks.

A company faces the aggregate planning problem shown in the table below. Cost of regular production is $8 per unit, the cost of producing the same unit on overtime is $15, the cost of subcontracting is $12 per unit, and the cost of carying a unit in inventory from one month to the next is $6 January February MarchApril 700 May 300 800 400 100 orecast 1200 egi nning Invento Regular Time vertime Subcontracting g Inventory The labor contract at the plant prohibits both overtime and subcontracting output to exceed 400 units in any five month window. The plant capacity is 20 units per day produced using two shifts and the plant runs seven days a week By policy, management wants to avoid stockouts A) What is the optimal total cost of the aggregate plan developed? B) How many units are produced using overtime in the optimal aggregate plan developed? C) How many months does the regular time outpur exceed plant capacity in the optimal solution? D) Without actually solving the aggregate planning problem, it is safe to conclude that in the optimal solution. Why 1) the total ending inventory will exceed the number of units made using overtime. 2) the number of units made using subcontracting will exeeed the number of units made using overtime 3) the number of units made using regular time will exceed the forecast 4) the number of units made using subcontracting will exceed the number of units made using regular time