Operations Management: Processes and Supply Chains, Student Value Edition Plus MyLab Operations Management with Pearson eText -- Access Card Package (12th Edition)
12th Edition
ISBN: 9780134855424
Author: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 28P
The bill of materials and the data from the inventory records for product A are shown in Figure 11.46. Assume that the MPS start quantities for A are 100 units in weeks 1, 2, 3, 4, 7, 8, 9, and 10.
Derive an MRP plan for the components going into product A using the data in Table 11.16.
What specific managerial actions are required in week 1? Make sure you address any specific difficulties you encounter in the inventory records.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 70 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below.
Item
D
Data Category
Lot-sizing rule
Lead time
Scheduled receipts
Beginning inventory
Complete the material requirements plan. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
Item: C
Item: D
L4L
1 week
None
155
с
Gross requirements
Scheduled receipts
Projected on-hand inventory 155
Planned receipts
Planned order releases
Item: E
L4L
2 weeks
70 (week 2)
230
Gross requirements
Scheduled receipts
Projected on-hand inventory 230
Planned receipts
Planned order releases
Gross requirements
Scheduled receipts
Projected on-hand inventory
Planned receipts
Planned order releases
160
1
10
10
0
0
1
0
0
0
10
1
0
ܘ ܘ ܘ
E
FOQ = 200
2 weeks
None
160
2
0
0
0
0
NOOOO
2
70
0
ON
2…
An end item’s demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order policy is to produce in lots of 100. The booked customer orders for the item, starting with week 1, are 22, 30, 15, 11, 0, 0, 9, 0, 0, and 0 units. The lead time is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received six orders for this item in the following sequence:Order 1 is for 40 units to be delivered in period 3Order 2 is for 60 units to be delivered in period 4Order 3 is for 70 units to be delivered in period 6Order 4 is for 40 units to be delivered in period 3Order 5 is for 20 units to be delivered in period 5Order 6 is for 115 units to be delivered in period 9Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?
The BOM for product A is shown in Figure 11.40, and datafrom the inventory records are shown in Table 11.9. In theMPS for product A, the MPS start row has 100 units in week 3and 200 in week 6. Develop the material requirements planfor the next 6 weeks for items C, D, and E. a. Develop the material requirements plan for the next6 weeks for items C, D, and E.b. What specific managerial actions are required inweek 1?
Chapter 11 Solutions
Operations Management: Processes and Supply Chains, Student Value Edition Plus MyLab Operations Management with Pearson eText -- Access Card Package (12th Edition)
Ch. 11 - Consider the master flight schedule of a major...Ch. 11 - For an organization of your choice, such as where...Ch. 11 - Consider a service provider that is in the...Ch. 11 - Complete the MPS record in Figure 11.29 for a...Ch. 11 - Complete the MPS record in Figure 11.30 for a...Ch. 11 - Prob. 3PCh. 11 - Figure 11.31 shows a partially completed MPS...Ch. 11 - Tabard Industries forecasted the following demand...Ch. 11 - Figure 11.32 shows a partially completed MPS...Ch. 11 - The forecasted requirements for an electric hand...
Ch. 11 - A forecast of 240 units in January, 320 units in...Ch. 11 - An end items demand forecasts for the next 6 weeks...Ch. 11 - An end items demand forecasts for the next 10...Ch. 11 - Consider the bill of materials (BOM) in Figure...Ch. 11 - Product A is made from components B, C, and D....Ch. 11 - What is the lead time (in weeks) to respond to a...Ch. 11 - Product A is made from components B and C. Item B,...Ch. 11 - Refer to Figure 11.23 and Solved Problem 1. If...Ch. 11 - The partially completed inventory record for the...Ch. 11 - The partially completed inventory record for the...Ch. 11 - The partially completed inventory record for the...Ch. 11 - Figure 11.38 shows a partially completed inventory...Ch. 11 - A partially completed inventory record for the...Ch. 11 - The BOM for product A is shown in Figure 11.40,...Ch. 11 - The BOMs for products A & B and data from the...Ch. 11 - Figure 11.42 illustrates the BOM for product A....Ch. 11 - The following information is available for three...Ch. 11 - Figure 11.44 shows the BOMs for two products, A...Ch. 11 - The BOM for product A is shown in Figure 11.45....Ch. 11 - Refer to Solved Problem 1 (Figure 11.23) for the...Ch. 11 - The bill of materials and the data from the...Ch. 11 - The bill of materials and the data from the...Ch. 11 - The McDuff Credit Union advertises their ability...Ch. 11 - Suppose that the POQ for item B is changed from 3...Ch. 11 - As the on-hand inventory for item C increases from...Ch. 11 - As the fixed order quantity (FOQ) for item D...Ch. 11 - As the lead time for item C changes, what happens...
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
- Figure 1 shows the BOM for product A. Table 1 shows the MPS quantity start dates for product A, and Table 2 contains data from inventory records for items B, C, and D. The production planner wants to determine the material requirements plan for items B, C, and D for the next 8 weeks. What is the planned receipts quantity for item D for week 6? C (3) D (2) 8 (1) D (2) C2) Figure 1. BOM for product A Table 1. MPS quantity start dates for product A Week Product 1 3 70 4. 6. 7. 8. 80 100 70 100 Table 2. Inventory record data Item Data category Lot-sizing rule Lead time Scheduled receipts Beginning inventory Safety stock LAL 2 weeks 100 (week 3) FOQ= 500 1 week 150 (week 1) POQ (P-4) 1 week 500 (week 1) 600 100 200 None 130arrow_forwardhelp please I need it to be done in excelarrow_forwardhello I need help with number 13 please and I need it only in excelarrow_forward
- Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. 14.) A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. From the information shown, generate: a) An indented bell of material for product A. b) Net requirements for each part to produce 10 As in week 8 using lot-for-lot. Figure 14:arrow_forwardWhat will be projected on hand inventory of item S in week6?arrow_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
- Figure shows the BOMs for two products, A and B. Table 1 shows the MPS quantity start date for each one. Table 2 contains data from inventory records for items C, D, and E. There are no safety stock requirements for any of the items.a. Determine the material requirements plan for items C, D, and E for the next 8 weeks.b. What specific managerial actions are required in week 1?c. Suppose that a very important customer places an emergency order for a quantity of product A. To satisfy this order, a new MPS of 200 units of product A is now required in week 5. Determine the changes to the material requirements plan if this order is accepted and note any problems that you detect. MPS Quantity Start Dates Date Product 1 2 3 4 5 6 7 8 A 125 95 150 130 B 80 70 Inventory Record Data Item Data Category C D E Lot-sizing rule L4L POQ 1P = 32 FOQ = 800 Lead time 3 weeks 2 weeks 1 weeks Scheduled receipts 200 (week 2) None 800 (week 1) Beginning…arrow_forwardFigure below shows a partially completed MPS record for ball bearings.a. Develop the MPS for ball bearings.b. Four customer orders arrived in the following sequence:Order Quantity Week Desired1 500 42 400 53 300 14 300 7Assume that you must commit to the orders in the sequence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept?arrow_forwardThe gross requirements for item A are specified for the beginning of weeks 1 through 12 in the table that follows. Item A, Level 0 01 02 03 04 05 06 07 08 09 10 11 12 0 60 0 50 0 70 0 40 0 60 0 50 60 ? ? ? ? ? ? ? ? ? ? ? ???????????? Gross requirements. Projected on hand Planned order release The lead time is 2 weeks. The current on hand inventory, at the beginning of week 1 is 60 units. If the order cost is $80 per order and the inventory cost is $1 per unit per period, and the order quantity is the computed part period (or a multiple of the computed part period) when it is necessary to place an order, what is the total cost for the 12 week period? Answer:arrow_forward
- The BOM for product A is shown in Figure 2, and data from the inventory records are shown in Table 3. In the master production schedule for product A, the MPS start row has 150 units in week 3 and 300 in week 5. Develop the material requirements plan for the next 6 weeks for items B, C, and D.arrow_forwardIn the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank-be certain to enter "0" wherever required.) ITEM 3 Gross requirements On-hand Net requirements Planned order receipt Planned order release Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases WEEK NUMBER 2 3 76 4 48 76 5 72 48 72arrow_forwardPlease Simply fill out the chart answering the questionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY