14.26. Calculate the available-to-promise row in the following matrix:PeriodOn Hand = 10012 34 5 6Forecast501005010050100Customer Orders50125751754515Master Production200200ScheduleAvailable-to-Promise

Available to promise (ATP) is a difference between the market production schedule and all actual…

Answered: 14.26. Calculate 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

Can you assist me with Problem 5
16. Complete the following schedule and then answer Problems 16 and 17. Forecast requirements In transit On Hand 1 35 50 Projected available balance 30 Planned Shipments Shipping quantity = 50, Lead time = 1, Safety stock = 25 2 30 Period 3 45 What will the planned shipments be for periods 2, 3, and 4? a) 25 units for each period b) 50 units for periods 2 and 4; zero units for period 3 4 65 c) 50 units for each period d) 100 units in period 2, zero units in period 3, and 50 units in period 4 e) 75 units in period 2, 35 units in period 3, 20 units in period 4 17. What is the projected available balance for period 4? a) 50 units b) 55 units c) 60 units d) 65 units e) 75 units 5 30
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 1 week February Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 60 35 20 0 January 2 70 15 3 18 8 60 90 BID 4 40 0 LE Week 5 45 30 6 45 70 7 55 0 8 50 0
Year Demand History for the Bow Rake: DEMAND Month Year 1 Year 2 Year 3 Year 4 1 55,220 39,875 32,180 62,377 2 57,350 64,128 38,600 66,501 3 15,445 47,653 25,020 31,404 4 27,776 43,050 51,300 36,504 5 21,408 39,359 31,790 16,888 6 17,118 10,317 32,100 18,909 7 18,028 45,194 59,832 35,500 8 19,883 46,530 30,740 51,250 9 15,796 22,105 47,800 34,443 Prepare a graph that shows the four-year demand history for the bow rake. Discuss any apparent trend and seasonal patterns. 2. Which forecasting method might be best for bow rakes for each month of Year 5? Why?
Explain Material Requirements Planning?
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 70 40 ☐☐ January 2 70 65 80 Order Policy: 100 units Lead Time: 1 week February Week 4 40 0 5 45 35 50 70 45 0 8 50 0
Discussion Questions 1. The customer order decoupling point was described as the point at which the demand changed from independent to dependent. Describe what this means and why it is important to managers. 2. Provide examples of make-to-stock, assemble-to-order, and make-to-order products. What advantages are there in moving from make-to-stock to assemble- or make-to- order?
The Bawl Corporation supplies alloy ball bearings to automanufacturers in Detroit. Because of its specialized manu-facturing process, considerable work-in-process and rawmaterials are needed. The current inventory levels are$2,470,000 and $1,566,000, respectively. In addition, fin-ished goods inventory is $1,200,000 and sales (at cost) forthe current year are expected to be about $48 million. Ex-press total inventory asa. Weeks of supplyb. Inventory turns
c4 need urgent in 15 minutes
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.
OQ14

SEE MORE QUESTIONS

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

14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 %3D 2 3 4. 5 6 Forecast 50 100 50 100 50 100 Customer Orders 50 125 75 175 45 15 Master Production 200 200 Schedule Available-to-Promise