Figure 1 shows the BOM for product A. Table 1 shows the MPS quantity start dates for productA, and Table 2 contains data from inventory records for items B, C, and D. The production plannerwants 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 ATable 1. MPS quantity start dates for product AWeekProduct13704.6.7.8.8010070100Table 2. Inventory record dataItemData categoryLot-sizing ruleLead timeScheduled receiptsBeginning inventorySafety stockLAL2 weeks100 (week 3)FOQ= 5001 week150 (week 1)POQ (P-4)1 week500 (week 1)600100200None130

Note: For a given week Scheduled receipt and Beginning inventory are treated differently. But once…

Answered: Figure 1 shows the BOM for product A.…

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 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…
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
. Consider the bill of materials (BOM) in Figure 11.33.a. How many immediate parents (one level above) doesitem I have? How many immediate parents does item Ehave?b. How many unique components does product A have at alllevels?c. Which of the components are purchased items?d. How many intermediate items does product A have at alllevels?e. Given the lead times (LT) in weeks noted on Figure 11.33,how far in advance of shipment must a purchasecommitment be for any of the purchased items identifiedin part (c)?
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.
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
Prepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 1000 1000 1200 1200 1500 1500 1800 1800 Orders 1060 940 650 400 210 90 20 0 1. Currently there are 1450 units in inventory. Policy calls for a fixed order quantity of 2500 units. 2. Can you receive another order for 500 items in week 1? Why? 3. How many orders can be received in each period without altering the plan. 4. If there are 2500 items in stock, what would be the answer of questions 2 and 3?
A factory has just received an order for 100 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Item Lead Time (weeks) On Hand Inventory Scheduled receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) A 3 20 54 at week 3 lot for lot D(2) B 2 10 68 at week 4 lot for lot D(5) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
What will be projected on hand inventory of item S in week6?
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
1. Speedy, Inc. is a company that produces automotive electrical components. AI5I is a common part for all its products. Consider the following grass requirements and inventory data for AISI part: Week 3 6 7 Grass requirements 40 30 30 70 20 Inventory Data: Lead time Beginning inventorry Scheduled receipts Holding cost Setup cost 1 week 40 $2.50/unit/week S150 Based on the L4L. lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A15I part. Item: A151 Week 5 Lot size: L4L 1 2 4 7 8 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases (ii) Based on the FOQ - 57 units lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A151 part. Item: A151 Lot size: FOQ 57 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts |Planned Order Releases Week 1 2 4 5 7 8
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 9. Subscripts indicate quantity required for each parent. Assumelot-for-lot ordering. c) Develop a net material requirements plan for F (enter your responses as whole numbers). Week Lead Time Item 2 3 4 5 6 7 8 9 (weeks) F Gross req Insert answer insert answer 2 On hand insert answer insert answer Net req insert answer insert answer Order receipt insert answer insert answer Order release insert answer insert answer
What are the net requirements of each item in the MPS? Item Net Requirements X A B C D E F G

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