A factory has just received an order for 95 units of an end item, which are to be shipped at the startof week 8. Relevant information of the end item and the components is as follows.Lead Time On HandScheduledDirectItemOrder Policy(weeks)InventoryreceiptsComponentsEnd itemlot for lotA(3), B(2)2151052 at week 3lot for lotC(5), D(3)2060 at week 4lot for lotD(3)100min. of 500112lot for lotDevelop the material requirements plan (please print out an empty MRP table to work with), anddetermine how many units of component D are needed in the "planned order release"Input should be an exact number.

Planned Order Release of Component D = 762 Formula Used : Projected available Balance =…

Answered: A factory has just received an order…

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 partially completed inventory record for the motor subassembly is shown in Figure.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?
Refer again to Problems( Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan. ). In addition to100 units of S, there is also a demand for 20 units of U, which isa component of S. The 20 units of U are…
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 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?
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…
A large St. Louis feed mill, Robert Orwig Processing,prepares its 6-month aggregate plan by forecasting demand for50-pound bags of cattle feed as follows: Ja nuary, 1,000 bags;February, I ,200; March, I ,250; April, 1,450; May, I ,400; and June,I ,400. The feed mill plans to begin the new year with no inventoryleft over from the previous year, and backorders a re not permitted.It projects that capacity (during regular hours) for p roducingbags of feed will remain constant at 800 until the end of April, andthen increase to 1,100 bags per month when a planned expansionis completed on May I. Overtime capacity is set at 300 bags permonth until the expansion, at which time it will increase to 400bags per month. A friendly competitor in Sioux City, Iowa, is a lsoavailable as a backup source to meet demand but can provideonly 500 bags total during the 6-month period. Develop a 6-monthproduction plan for the feed mill using the transportation method.
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
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)?
Ripeka, the warehouse manager at Hine would like to update the company’s inventory locator system so that the picking operation can be streamlined. While conceptually simple to do, she knows that there will be several steps to the update process that will have to be carefully managed. She needs to complete upgrade and train her staff in operating the new system before the busy season, which is only 4 months away. She identifies the various activities, expected time duration, predecessors and costs, as shown in the table. Identify the project cost. Ripeka is interested to complete the project three weeks early before starting the busy season. How much additional cost the project will incur for completing the project three weeks early?
Ripeka, the warehouse manager at Hine would like to update the company’s inventory locator system so that the picking operation can be streamlined. While conceptually simple to do, she knows that there will be several steps to the update process that will have to be carefully managed. She needs to complete upgrade and train her staff in operating the new system before the busy season, which is only 4 months away. She identifies the various activities, expected time duration, predecessors and costs, as shown in the table. Draw the AON Network, and then determine the critical path. [Show your workings, using the grid network.] Identify the project duration – is this project feasible within the required timeframe?
The MRP Department has a problem. Its computer “died” just as it spit out the following information: Planned order release for item J27 = 640 units in week 2. The firm has been able toreconstruct all the information they lost except the master schedule for end item 565. The firm isfortunate because J27 is used only in 565s. Given the following product structure tree and associated inventory status record information, determine what master schedule entry for 565 wasexploded into the material requirements plan that killed the computer.
WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1? How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?

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