could you show step by step please with excel

Problem 1: Maxim Trailers (MT) manufacturers small snowmobile and camping trailers in Ontario. The demand for the camping trailers occurs between January and June of each year (mostly in Apr and May). Aggregate demand in units) beyond the regular capacity is: Jan 465 Feb 540 Mar 705 Apr 1020 May 1,140 Jun 630 MT can hire temporary workers to meet the above requirements. Each temporary worker can produce 15 units per month. Hiring/training cost is approx. $1,200 per temp worker. Inventory holding cost per camping trailer per month is $30, charged to average inventory level during a month. Before January, MT had no camping trailers on hand, and it desires 180 extra units in inventory at the end of June. Any shortage during a period is backordered at the cost of $200 per camping trailer per month [15 Marks) a) Develop a level aggregate plan and calculate the total cost b) Develop a chase aggregate plan and calculate the total cost c) Can you improve the chase plan? How? [Note: 180 extra units at the end of June are also desired with the chase strategy.]