Suppose we are formulating a MasterProduction Schedule (MPS) for an item. Thelot-size policy for this item calls for a fixedquantity of 300 units. Lead time for this itemis three weeks. Week O inventory for thisitem is 400 units. There are no safety stockrequirements.Here are the demand forecast and thebooked orders for this item....Week12 3 45 6Forecast 120 120 100 100 100 120Booked 115 121 71 0 0 0When the master schedule is complete. whatwill be the Projected On-Hand in Week 4?

The Master Production Schedule (MPS) is a tool that is used for planning and it is used by…

Answered: Suppose we are formulating a Master…

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

Whats the correct answer please ?
Complete the following master schedule record Click the icon to view the master schedule record Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 60 Week 2 3 4 5 6 7 8 9 Forecasted demand 230 390 280 380 400 290 320 370 Booked orders 220 110 100 140 190 340 155 285 Projected ending inventory Master production schedule 860 840 860 Available to promise 850 410
Should BestLine’s ordering department have been more involved during the project?2. Sarah used expert interviews for this project. Were there more effective methods for gathering therequirements?3. What crucial step(s) did Sarah skip in the requirements process?4. Which downstream activities would likely be affected by her approach? At what point in the projectwould the problems likely emerge?5. Should Sarah have presented the requirements to the ordering manager at this point? Should the orderingmanager have signed off on them?
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancing
3. Item Z has a lead time of two weeks; A, B, C and D take one week each and E takes 3 weeks. Fifty units of Z are required in period 10. Assume that there is currently no inventory on hand of any of these items. Consider the following Bill of material and develop an MRP schedule for A, B, C, D and E showing gross and net requirements and order releases and order receipt dates. Assume Lot-for-lot ordering. C(3) A(2) Z D(4) E(2) B(4) Level 0 1 2 3
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 72 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 21 12 15 45 10 30 100 20 40 150 Use the least total cost lot-sizing method to determine when and for what quantity the first order should be released. Least total cost method indicates that periods units should be ordered to cover the needs for
Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
7
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
Calculate MPS for all periods
snip

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