Please give EXCEL solution

Question

Hint Given by professor

1. (10 points) Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below. Cost of regular production is $7 per unit, the cost of producing the same unit on overtime is $10, the cost of subcontracting is $13 per unit, and the cost of carrying a unit in inventorv from one month to the next is $4 Ine Iavor contract at the plant prohibits both overtime and subcontracting output to exceed 400 units in any five month window. The plant capacity is 1000 units per month produced using two shifts, regardless of the number of days in a month. By policy, management wants to avoid stockouts. Give an algebraic formulation of the aggregate planning problem using linear programming. Develop an aggregate plan using Solver. State the plan by completing the above table and state the total cost of the plan along with the costs of regular production, overtime production, subcontracting and inventory carrying