Question 1 We assume thatOne end item needs 2 units L, 1 unit C and 3 units K.One unit L needs 2 units B and 3 units J.One unit C needs 2 units G and 2 units B.One unit K needs 4 units H and 2 units B.Two orders of 40 units and 60 units will be sent at the week 8 and 9. The manager knows that15 units of B are scheduled to arrive at the beginning of week 4; 10 units of C are scheduled toarrive at the beginning of week 2. Only the component B should be ordered by lot and the lotsize is 30. Use tables to make MRPS for end products and components.ItemLead timeAmount on handEnd item1L2C3K3BJGI GH2|N33210152030305

Find the Calculation methods below: Net requirements = Gross requirements - (previous period…

Answered: Question 1 We assume that • One end…

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

Problem 21-16 (Algo) One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 20, 50, 30, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 50, 100, and 90, respectively, to be purchased. B has scheduled receipts of 20 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 20 units in Period 1, 10 units in Period 2, 55 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)
4. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts. If 22 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave the cells blank, whenever zero…
5. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts. If 22 units of A are required in Week 10: a. Draw the low-level-code bill-of-materials here.
6. One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts.If 50 units of A are required in week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned-order releases for all components. (Leave the cells blank, whenever zero (0) is required.)
5. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts. If 22 units of A are required in Week 10: a. Draw the low-level-code bill-of-materials here. b. Develop an MRP table in excel.
Item STUVWX>N Y 2. The demand for assembly S is 100 units and it is due in Week 15. Each unit of S requires one unit of T and 0.5 units of U. Each unit of T requires one unit of V, two units of W, and one unit of X. Finally, each unit of U requires 0.5 units of Y and three units of Z. Z Item S T U V W X Y Z a) Calculate the planned orders for all the items. b) Use time phasing to determine an overall schedule. S OH Gross Requirements Inv 100 20 20 10 30 30 15 25 10 2 1 1 1 2 2 1 Lead Time Due Date (weeks) (week) 15 1 T W (2) X Net Requirements Release Date U (0.5) Y (0.5) Planned Order Z (3) Lot Size Policy L4L X10 X5 Min 50 F100 X50 F100 Min 100
b) Prepare a master schedule based on the following information: Week: 1 2 3 5 Forecast 120 100 150 Orders 70 90 60 Initial inventory=100 Batch size = 200 4 80 30 80 20 6 100 10 7 120 0 8 110 0
A factory has just received an order for 95 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. Lead Time On Hand Scheduled Item Order Direct (weeks) Inventory receipts Policy Components End item 15 lot for lot A(3), B(2) A 2 10 33 at week 3 lot for lot C(1), D(4) B. 2 20 15 at week 4 lot for lot D(2) min. of 500 lot for lot 100 20 Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component Care needed in the "planned order release". Input should be an exact number.
A factory has just received an order for 95 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. Lead Time On Hand Scheduled Direct Item Order Policy (weeks) Inventory receipts Components End item lot for lot A(3), B(2) 2 15 10 52 at week 3 lot for lot C(5), D(3) 20 60 at week 4 lot for lot D(3) 100 min. of 500 1 12 lot for lot Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component D are needed in the "planned order release" Input should be an exact number.
aw 11 Assume you are the manager of Assembly, Inc. You have just received an order for 29 units of an industrial robot, which is to be delivered at the start of week 7 of your schedule. Using the following information, determine how many units of subassembly G to order and the timing of those orders, given that subassembly G must be ordered in multiples of 80 units and all other components are ordered lot-for-lot. Assume that the components are used only for this particular robot. Item Robot B C E F G H Lead Time (weeks) On Hand 2 1 1 NM NA 2 2 Click here for the Excel Data File 5 20 4 8 15 10 Subassembly G order quantity (in units) Order subassembly G at start of week Search Components B, G, C(3) E, F G(2), H کا < Prev 19 of 19 Next W 9
Briefly define or explain each of these terms:a. Master schedule
Situation: The Hawkins Supply company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates. Question: The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?

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