An end product is being produced in a large manufacturing plant. The bill of material diagram is as follows: END ITEM O (2) C (4) n U (3) E (4) P (3) E (4) F (5) D (4) E (4) N (2)" lead time is given in weeks. The MPS schedule for this end product for the following four weeks, ten weeks from now is as follows: Week 10 10 Week 11 14 Week 12 19 Week 13 The fixed order cost is $100 for all the units, and the holding cost is SO.6/unit/week for all the units. Assuming the silver meal lot production for all the componěnts, determine the planned order releases for component P.

An end product is being produced in a large manufacturing plant. The bill of material diagram is as follows: END ITEM O (2) C (4) n U (3) E (4) P (3) E (4) F (5) D (4) E (4) N (2)" lead time is given in weeks. The MPS schedule for this end product for the following four weeks, ten weeks from now is as follows: Week 10 10 Week 11 14 Week 12 19 Week 13 The fixed order cost is $100 for all the units, and the holding cost is SO.6/unit/week for all the units. Assuming the silver meal lot production for all the componěnts, determine the planned order releases for component P.

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

. 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)?
Table B shows a partially completed MPS record for ball Develop the MPS for ball Four customer orders arrived in the following sequences (Table B). Table A Order Quantity Week desired 1 500 4 2 400 5 3 300 1 4 300 7 Assume 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? Table B Item: Ball bearings Quantity on hand: 400 Order policy: 500 units Lead time: 1 week Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 300 400 450 300 350 200 300 450 400 Customer order booked 300 350 250 250 200 150 100 100 100 100 Projected on-hand inventory MPS quantity 500 MPS start Available to promise (ATP)
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. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 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. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3
Figure shows a partially completed MPS record for 2 inch pneumatic control valves. Suppose that you receive the following orders at right for the valves (shown in the order of their arrival). As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment?Order Amount (Units) Week Requested1 15 22 30 53 25 34 75 7
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
What are the net requirements of each item in the MPS? Item Net Requirements X A B C D E F G
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.
You need to schedule 10 units of product Alpha for delivery in 6 weeks. Three units of D and 2 units of F are required for each Alpha. The lead time for Alpha is 1 week. Lead time for D is 1 week, and lead time for F is 2 weeks. a) Complete the product structure. Alpha D(2) D(3)
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
1. A company that produces golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times and quantities on hand is shown in the following table. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree. b) Determine the low level codes for all the components. c) Develop a material requirements plan that will provide 200 golf carts by week 8 assuming lot for lot ordering.
1. A company that produces golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times and quantities on hand is shown in the following table. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree.
4. One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here. d. Develop an MRP table in excel.