OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
7th Edition
ISBN: 9780077835439
Author: Roger G Schroeder, M. Johnny Rungtusanatham, Susan Meyer Goldstein
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 15, Problem 1P
The following information is given for a particular part. Using a lead time of two weeks, complete the table. Use L4L with On hand = 80 and SS=0.
| Week | |||||
| 1 | 2 | 3 | 4 | 5 | |
| Gross requirement | 100 | 400 | 300 | ||
| 50 | |||||
| Projected ending inventory | 80 | ||||
| Net requirement | |||||
| Planned order recipts | |||||
| Planned order | |||||
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Complete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
Order Policy: 100 units
Lead Time: 2 weeks
Quantity
on Hand: 80
Week
1
2
3
4
5
6
7
8
9
10
Forecast
25
25
35
45
25
20
45
55
Customer orders
25
30
7
11
(booked)
Projected on-hand
inventory
MPS quantity
14.26. Calculate the available-to-promise row in the following matrix:
Period
On Hand = 100
1
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
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
Chapter 15 Solutions
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
Ch. 15.7 - Prob. 1OLCh. 15 - Prob. 1DQCh. 15 - Prob. 2DQCh. 15 - With regard to inventory management, discuss the...Ch. 15 - Prob. 4DQCh. 15 - How much safety stock should be carried in a MRP...Ch. 15 - Prob. 6DQCh. 15 - Prob. 7DQCh. 15 - Prob. 8DQCh. 15 - Prob. 9DQ
Ch. 15 - Describe how MRP? concepts could be used for the...Ch. 15 - How are MRP and ERP related?Ch. 15 - The following information is given for a...Ch. 15 - eXcel The Old Hickory Furniture Company...Ch. 15 - Product A consists of subassemblies B and C....Ch. 15 - eXcel The BOM for product A given below Part on...Ch. 15 - The master scheduler in the ABC Widget Company is...Ch. 15 - A firm makes a basic scissors consisting of three...Ch. 15 - Prob. 7PCh. 15 - Prob. 8PCh. 15 - A small toy robot is assembled from sis parts: a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- 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 0arrow_forwardShown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Quantity on Hand: 400 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 550 300 350 500 2 250 350 0 0 3 450 250 50 500 4 450 200 100 500 Order Policy: 500 units Lead Time: 1 week Week 5 250 150 350 500 6 400 100 450 500 7 200 50 250 0 8 250 100 To o 9 450 50 50 10 450 150 100 500 500arrow_forwardShown below is a partially completed MPS record for ball bearings. Part 2 a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Quantity on Hand: 400 Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 350 350 450 250 300 250 350 400 350 Customer orders (booked) 300 350 250 300 150 150 150 150 100 50 Projected on-hand inventory enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here MPS quantity 500 enter your response here enter your response here enter your response here enter your…arrow_forward
- Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…arrow_forwardComplete 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 410arrow_forwardEconomic Order Quantity. Clearly outline the math progression and explain the need for this.arrow_forward
- Fill the following MRP record and determine the planned order releases for item X225 for each week. ITEM: X225 Lot Size: Multiple of 50 Description: Lead Time: 2 weeks Week 1 2 3 4 5 6 7 8 Gross requirements 60 90 40 55 65 90 70 80 Scheduled receipts 100 50 Projected on Hand 15 Net requirements Planned order receipts Planned order releasesarrow_forwardDiscuss why order-point systems aren’t compatible with MRParrow_forwardThe table given below shows a partially completed MPS record for product A. What is the remaining ATP inventory (discrete) for week 7 after the company receives a 20 units of customer order for week 6? Order policy: 60 units Lead time: 1 week Item: A Quantity on hand: 30 Week 3 30 7. 34 11 4. Forecast requirements Customer orders (booked) Projected on-hand inventory MPS quantity MPS start ATP inventory 22 24 18 27 36 28 26 12 24 O a 59 Ob. 29 OcO Od. 49 Oe. 39arrow_forward
- 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 Order Policy: 60 units Lead Time: 1 week Quantity on Hand: 40 Week 1 4 5 6 7 8 Forecast 20 18 28 28 21 33 36 41 Customer orders 17 19 7 11 11 (booked) Projected on-hand inventory MPS quantity LO 3.arrow_forwardGiven the following MRP matrix: LLC: 0 ITEM: X LOT SIZE: MIN 100 Gross Requirements Gross Scheduled Receipts Projected on Hand Net Requirements Net Planned Order Receipts Planned Order Releases Shown smaller: ITEM: X LOT SIZE: MIN 100 Requirements Scheduled Receipts Projected on Hand Requirements Planned Order Receipts Planned Order Releases Answer: LLC: 0 LT: 2 LT: 2 30 PERIOD 1 2 100 PERIOD 50 1 20 10 100 20 2 30 100 50 100 100 30 3 If the ordering cost is $176 and the carrying cost is $1 per unit per period, what is the total inventory related cost for periods 1 through 7? Give answer to 2 decimal WITHOUT the $ symbol. 50 80 20 20 30 50 50 60 80 80 100 30 10 30 80 30 70 90 10 100 100 7 30 10 4 100 100 50 30 5 60 70 6 80 90 30 10 100 100 7 80 10arrow_forwardAssume 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 6arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
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
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.
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY