Bb6. a. 120 units of end item Z are needed at the beginning of week 7. On hand balances: Z = 40, A 70, B = 100, and C = 30 units. There is ascheduled receipt of 20 units of C in week 4. Lead times are 2 weeks for Z and B, and 1 week for other items. Lot-for-lot ordering isused for all items. The product structure tree is shown below:A(2)ZC(3)Prepare a material requirements plan for component C:We will need to prepare material plans for Z, A, B, and C.D(2)E(2)B(4)C(2) C(3) & C(2) LT=1Lot size: Lot-for-LotGross requirementsScheduled receiptsProjected on handNet requirementsPlanned-order receiptsPlanned-order releasesBeg. Inv.003050 x001003050 x002X Answer is complete but not entirely correct.030003903440030390 X390 X270 X427020270 X270 x270 X050000006000007000

Answered: a. 120 units of end item Z are needed…

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

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z,70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units ofcomponent C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and areexpected to arrive in week 4. Lead times are two weeks for E and C, and one week for the othercomponents. Assume lot-for-lot ordering except for D, where multiples of 40 must be used.
Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. A has a lead time of 1 week, B,C AND E have a lead time of 2 weeks and D and F have a lead time of 3 weeks. Assume we are using L4L. question: If 100 units of A are required in Week 10, develop the MRP schedule, specifying when items are to be ordered and recieved. There are currently no units of inventory on hand.
A partially completed inventory record for the motor sub-assembly is shown in Figure 11.39.a. Complete the last three rows of the record by using theL4L rule.b. Complete the last three rows of the record by using thePOQ rule with P = 2. c. Complete the last three rows of the record by using thePOQ rule with P = 2.d. If it costs the company $1 to hold a unit in inventory fromone week to the next, and the cost to release an order is$50, which of the lot sizing rules used above will providethe lowest inventory holding + order release cost?
A table is assembled using three components, as shown in the accompanying product structure tree.The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units atthe beginning of day 5, and 200 units at the beginning of day 7. Receipts of 100 wood sections arescheduled at the beginning of day 2. There are 120 legs on hand. There are 60 braces on hand. Leadtimes (in days) for all items are shown in the following table. Prepare a material requirements planusing lot-for-lot ordering.
A partially completed inventory record for the motor sub-assembly is shown in Figure 11.39. a. Complete the last three rows of the record by using the L4L rule. b. Complete the last three rows of the record by using the POQ rule with P = 2. c. Complete the last three rows of the record by using the POQ rule with P = 2. d. If it costs the company $1 to hold a unit in inventory from one week to the next, and the cost to release an order is $50, which of the lot sizing rules used above will provide the lowest inventory holding + order release cost?
Product A is made of 3 units of B and 2 units of C. Each B is made up of 2 units of D and 3 units of E. Each E is made of 3 units of F and 1 unit of G. C is made of 1 unit of D and 4 units of E. Lead times for all item are 1 week except for B. The lead time for B is 3 weeks. 100 units of A are needed at the start of week 9. There are currently 32 units of B on hand, 212 units of E on hand, 75 units of F which are currently in production will be completed at the start of week 3. Assume 20 units safety stock for all components. Except for C&F which has an FOQ of 80, all components are Lot for lot. Create BOM and MRP.
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times:a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times: a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the startof week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are inproduction and will be completed by the start of week 2. Lot-for-lot ordering will be used for all items.
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)?
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for items A, B, and F; lots of size 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 2, 50 units of E in week 1, and also 50 units of F in week 1. There are no other scheduled receipts. If 30 units ofA are required in week 8, use the low-level-coded bill-of-materials to find the necessaryplanned-order releases for all components.
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.

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