Question: .uIIVerizon LTE 12:34 pM cheggcom a 25% E} This chart provides the variables and cost for each variable. Variables Cost Inventory carrying cost $6 per

.uIIVerizon LTE 12:34 pM cheggcom a 25% E} This chart provides the variables and cost for each variable. Variables Cost Inventory carrying cost $6 per unit per month Subcontracting cost $25 per unit Average pay rate Overtime pay rate Laborhours needed to produce one unit Units per day produced Beginning inventory Planned ending inventory Lost sales per unit $12.50 per hour (8 ho $18 per hour (above 8 1.5 hours per unit 10 O 0 $100 This chart provides the demand for the product and the number of producti Months January February March April May June Demand 1200 800 600 1500 1400 1300 You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option. 1. 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. 2. 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? 3. Instead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of paying overtime. .ul Verizon LTE 12:35 PM E 23%EJ' chegg.com Months Demand January 1200 February 800 March 600 April 1500 May 1400 June 1300 You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option. 1. 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. 2. 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? 3. Instead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of paying overtime. 4. On a fourth tab of the spreadsheet, summarize your cost and determine which of the three options produces the lowest overall cost. Please include the formula, please. Show transcribed image text Expert Answer Ramiakhar

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

same picture. It just shows all 4 questions .uIIVerizon LTE 12:34 pM ? cheggcom a 25% E} This chart provides the variables and cost for each variable. Variables Cost Inventory carrying cost $6 per...

Both are the same with all 4 questions showing .uIIVerizon LTE 12:34 pM ? cheggcom a 25% E} This chart provides the variables and cost for each variable. Variables Cost Inventory carrying cost $6...

Variables Cost Inventory carrying cost $7 per unit per month Subcontracting cost $25 per unit Average pay rate $12 per hour (8 hours per day) Overtime pay rate $18 per hour (above 8 hours per day)...

For the following monthly demand forecast develop an aggregate plan when 38 units per day is produced and unmet demand is backordered. 38 units per day is produced and overtime is when needed. Month...

Variables Cost Inventory carrying cost $6 per unit per month Subcontracting cost $25 per unit Average pay rate $12.50 per hour (8 hours per day) Overtime pay rate $18 per hour (above 8 hours per day)...

1. After completing the Aggregate Planning Template for the data provided in the template (name the worksheet DEMO), make a copy of that worksheet (in the same excel file) and name that worksheet...

In the Module Overview, we stated that an "aggregate plan will include the quantity and timing of production for the intermediate future (typically 3-18 months ahead). Some factors such as demand,...

I believe i have done something wrong. Could you please assist me with this? Thank you. Aggregate Plan Aggregate Planning Lost sales Cumulative Demand and Production Demand and Production by Period...

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...

$ Scenario In the Module Overview, we stated that an "aggregate plan will include the quantity and timing of production for the intermediate future (typically 3-18 months ahead)." Some factors such...

Suppose you deposit $300 at the beginning of each month in a savings account that pays interest at the rate of 6% per year, with monthly compounding. How long will it take you to accumulate $25,000...

Ruths Chris Steakhouse is the largest upscale steakhouse company in the United States, based on total company- and franchisee-owned restaurants. The companys menu features a broad selection of...

1 7 . Gekko Properties is considering purchasing Teldar Properties. Gekko's analysts project that the merger will result in incremental after - tax cash flows of $ 2 million, $ 4 million, $ 5...

The following is the adjusted trial balance of Sierra Company. (Click on the Graded Worksheet Tab below.) Sierra Company Adjusted Trial Balance December 31 Account Title Debit Credit Cash $15,000...