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) B (1) D (2) C2) D (2) Figure 1. BOM for product A Table 1. MPS quantity start dates for product A Week Product 1 3 70 4. A 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) %3D 200 600 100 None 130 a 1860 Ob. 1320 O c. 340

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) B (1) D (2) C2) D (2) Figure 1. BOM for product A Table 1. MPS quantity start dates for product A Week Product 1 3 70 4. A 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) %3D 200 600 100 None 130 a 1860 Ob. 1320 O c. 340

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

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 130
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…
a) Given the product structure and master production scheduleshown in Figure 14.12, develop a gross requirements plan forall items.b) G iven the product structure, master production schedule, andinven tory status shown in Figure 14.12, develop a net requirementsplan (planned order release) for all items.
Figure 1 shows the BOMS for two products, A and B. Table 1 shows the MPS quantity start date for each product; and Table 2 contains data from inventory records for items C, D, and E. There are no safety stock requirements for any of the items. The production planner wants to determin the material requirements plan for items C, D, and E for the next 8 weeks. What is the planned receipts quantity for item E for week 8? E(4) DA Figure 1. BOMS for products A and B Table 1. MPS quantity start dates for products A and B Week Рroduct 2 3 5 A 100 200 85 65 50 50 75 Table 2. Inventory record data Data categoryY Lot-sizing rule Lead time Scheduled receipts Beginning inventory L4L 2 weeks 200 (week 3) 200 Item D FOQ = 200 1 week POQ (P=2) 1 week None None 200 co
The 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. 39
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
The 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:
Given the product structure, master productionschedule, and inventory status in Figure 14.13, and assuming therequirements for each BOM item is I:a) develop a gross requirements plan for Item C;b) develop a net requirements plan for Item C.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 1 housing. Each clamp has 1 handle and 2 castings. Each housing has 1 bearing and 2 shafts. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Spring Subscript left parenthesis 2 right parenthesisSpring(2) II Housing Subscript left parenthesis 1 right parenthesisHousing(1) III Casting Subscript left parenthesis 2 right parenthesisCasting(2) IV Shaft Subscript left parenthesis 2 right parenthesisShaft(2) Bracket Base(1) Clamp(1) Handle(1) Clamp(4) Bearing(1) Handle(1) Casting(2) IIIIIIIV Part 3 b) Determine the…
You have just been notified that the lead time forcomponent G of product A ( You are product pla nner for product A (in Problem(A part structure, lead time (weeks), and on-handquantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8using lot-for-lot. IP).) The field service manager, Mark Moon,has just called and told you that the requirements for B and Fshould each be increased by I 0 units for his repair requi rements inthe field.a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I 0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants his 10 units ofB and F in week 6 and the 10 production…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 2 housings. Each clamp has 1 handle and 1 casting. Each housing has 2 bearings and 1 shaft. There is no inventory on hand. A. Design a product structure noting the quantities for each item and show the low-level coding. B. Determine the gross quantities needed of each item if you are to assemble 50 brackets. C. Compute the net quantities if there are 25 of the base and 100 of the clamp in stock.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 3 clamps. The base is assembled from 2 clamp and 1 housing. Each clamp has 1 handle and 1 casting. Each housing has 2 bearing and 2 shaft. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Bracket II Spring Subscript left parenthesis 1 right parenthesis III Clamp Subscript left parenthesis 3 right parenthesis IV Bearing Subscript left parenthesis 2 right