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

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

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!

Consider the cylindrical shaped absorbent material designed to selectively remove solute A from solution. The uptake of solute A through the homogeneous absorbent material is limited by the molecular...

The first and second pictures are the same but it's 4 questions all together .ul Verizon LTE 12:35 PM E 23%EJ' ? chegg.com Months Demand January 1200 February 800 March 600 April 1500 May 1400 June...

scm321 Exercises 1. Skycell, a major European cell phone manufacturer, is making production plans for the coming year. Skycell has worked with its customers (the service providers) to come up with...

Assignment 5 - Aggregate planning End of Chapter question Refer to the book to page 229-231 and start your assignment by doing the end of the chapter qurstions I have attached an excel sheet to help...

Required: 1.Using Excel, prepare the following budgets for the twelve-month period from January 2018 to December 2018.The first worksheet should contain your raw data and assumptions and all future...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

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

You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option. This chart provides the variables and cost for each variable....

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

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

Beta Co. sold 10,000 shares of common stock, which has a par value of $25, for $27 per share. The company also sold 1,000 shares of $100 par value preferred stock for $110. Assume the balance in...

What amount two years from now will be equivalent to $2300 at a date 1 years ago, if 2 money earns 6.25% compounded semiannually during the intervening time?

1. What is meant by the naming convention used by a language?

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