aw11Assume you are the manager of Assembly, Inc. You have just received an order for 29 units of an industrial robot, which is to bedelivered at the start of week 7 of your schedule. Using the following information, determine how many units of subassembly G toorder and the timing of those orders, given that subassembly G must be ordered in multiples of 80 units and all other components areordered lot-for-lot. Assume that the components are used only for this particular robot.ItemRobotBCEFGHLead Time (weeks) On Hand211NM NA22Click here for the Excel Data File520481510Subassembly G order quantity (in units)Order subassembly G at start of weekSearchComponentsB, G, C(3)E, FG(2), Hکا< Prev19 of 19NextW9

Answered: Assume you are the manager of Assembly,…

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

If the the Net Requirement for a product for a particular time period in a MRP problem is 101 and the organization uses an ordering policy of Lot-for-Lot, what would be the Planned Order Receipt?
Draw the first order plus time delay system, with its transfer function?
Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively. Item B has a scheduled receipt of 10 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) lot sizing is used for Items A and B. Item C requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 100 and 50, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 30 in Period 2, 30 in Period 5, and 40 in Period 8. Find the planned-order releases for all items
Courtney Kamauf schedules production of a popularRustic Coffee Table at Kamauf Enterprises, Inc. The table requires a top, four legs, 1 8 gallon of stain, 1 16 gallon of glue, 2 short braces betweenthe legs and 2 long braces between the legs, and a brass cap that goeson the bottom of each leg. She has 100 gallons of glue in inventory,but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are pur-chased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for each item. Schedule the order releases necessary to pro-duce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8.
Consider the bill of material for product P and the data given in the following table. The master schedule requirements for P are 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order. Use a blank matrix to solve for the MRP requirements. Q(2) S(3) R(3) Quantity on Hand 5. Scheduled reccipts Item Lead Time 15 20 in week 2 R. S. 25 15 in week 1 Given the following information, how many R's should be ordered? O 180 O 330 O 360 O 165 O 225 -/2/2
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.)
Scheduling is a key to Supply Chain Management. It pertains to establishing the timing of the use of specific resources of an organization. AS an example manufacturers must schedule production, which means developing schedules for workers, equipment, purchases, maintenance and so on. Give the scheduling components for one University and discuss the in detail each requirement. Which do you feel as a student fall short in the scheduling process and why?
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancing
How does Material Requirement Planning help organizations balance inventory carrying costs with the risk of stockouts and production delays?
3. Item Z has a lead time of two weeks; A, B, C and D take one week each and E takes 3 weeks. Fifty units of Z are required in period 10. Assume that there is currently no inventory on hand of any of these items. Consider the following Bill of material and develop an MRP schedule for A, B, C, D and E showing gross and net requirements and order releases and order receipt dates. Assume Lot-for-lot ordering. C(3) A(2) Z D(4) E(2) B(4) Level 0 1 2 3
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 15, 55, 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.)
Materials requirement planning (MRP) is used to manage inventory in the upper echelon of the supply chain. True False

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