Please include excel formulas

Use the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Produce a graph of your plan. The intent is to use a level strategy (or level scheduling) with no overtime, no safety stock, and no subcontractors.

Hint 1 - Consider that it takes 1.5 hours to produce a unit when determining your cost per unit for average and overtime pay.

Hint 2 - To determine regular time production, you need to multiply the units per day produced by the number of production days.

Variables Cost Inventory carrying cost Subcontracting cost Average pay rate Overtime pay rate Labor-hours needed to produce one unit Units per day produced Beginning inventory Planned ending inventory Lost sales per unit $7 per unit per month $25 per unit $12 per hour (8 hours per day) $18 per hour (above 8 hours per day) 1.5 hours per unit 50 0 0 $30 This chart provides the demand for the product and the number of production days per month. Months Demand Production Days 1300 22 800 18 600 21 January February March April May June 1500 1300 1300 21 22 20