Given the projected demands for the next sixmonths, prepare aggregate plan must wind upwith no units in ending inventory in Period 6.Regular time capacity is 150 units per month.Overtime cost is $20 per unit, backorder cost is$30 per unit, inventory holding cost is $10 perunit based on maximum, subcontracting cost is$40 per unit, regular time cost of $20 per unit,and beginning inventory is 10.Month 1 2 3 45 6Forecast 150 170 140 160 130 160a. Prepare an aggregate plan with inventory andbacklog allowed. Overtime and subcontractingare not allowed.b. Prepare an aggregate plan if the managementdecided to switch to chase strategy. They onlyallow backlog if absolutely needed. Regularproduction capacity is now 160.

The projected demands for the next six months - Month 1 2 3 4 5 6 Forecast 150 170 140 160 130…

Answered: Given the projected demands for the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned order
An end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?
9. Which level of capacity management process involves stating the capacity requirements to satisfy the total demand, period by period, for product groups. a. master scheduling b. short-term scheduling c. aggregate planning
Which the following is a measure of the reserve capacity, a process has to handle among in unexpected increases in demand a. Capacity cushion b. Capacity bottleneck c. Capacity limit d. Capacity Planning
VT Company produces lawn movers and leaf blowers. The company must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 150 engines per month. Regular output has a cost of RM55 per engine. The beginning inventory is zero engines. Overtime has a cost of RM80 per engine. Month 2 3 4 7 8 Total Forecast 125 135 140 120 125 125 135 135 1,040 Develop an aggregate plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. Explain your plan.
Can you show the work using excel
The Donald Fertilizer Company produces industrial chemi-cal fertilizers. The projected manufacturing requirements (inthousands of gallons) for the next four quarters are 90, 60,90, and 140, respectively. A level workforce is desired, relyingonly on anticipation inventory as a supply option. Stock-outs and backorders are to be avoided, as are overtime andundertime.a. Determine the quarterly production rate required to meettotal demand for the year, and minimize the anticipationinventory that would be left over at the end of the year.Beginning inventory is 0.b. Specify the anticipation inventory that will be produced.c. Suppose that the requirements for the next four quartersare revised to 60, 90, 140, and 90, respectively. If total de-mand is the same, what level of production rate is needednow, using the same strategy as part (a)?
____ range capacity planning requires adjustments to eliminate variations between planned and actual output a. Short b. Long c. Intermediate d. Medium
Calculate MPS for all periods

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS