Step 2: Update Your Aggregate Plan Using Overtime In the plan produced in Step 1, the production rate did not meet the total demand. If you were able to use overtime to meet the shortfall, what would your aggregate plan look like? Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan. Continue to Step 3: Update Your Aggregate Plan Using Outsourcing Step 3: Update Your Aggregate Plan Using Outsourcing Edit View History Bookmarks Window 10 Help erau.instructure.com My Shelf | Brytewave eR... V Operations Management... c E 7.3 - Problems: Graphica... the production must be taken into consideration to keep the total cost of production as low as possible. APA Citation Generator (... option. You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best This chart provides the variables and cost for each variable. Variables Cost $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 Inventory carrying cost Subcontracting cost Average pay rate Overtime pay rate Labor-hours needed to produce one unit Units per day produced 50 Beginning inventory 0 Planned ending inventory 0 $30 Lost sales per unit This chart provides the demand for the product and the number of production days per month. Months January February March April May June Demand 1300 800 600 1500 1300 1300 Production Days 22 18 21 21 22 20 Complete the steps in each section and then submit your assignment for grading. Submit one spreadsheet containing a tab for each Expand All Collapse All Step 1: Prepare Your Aggregate Plan step. 12 70 FEB 25 J @ A B W X