Figure 1 shows the BOMS for two products, A and B. Table 1 shows the MPS quantity start datefor each product; and Table 2 contains data from inventory records for items C, D, and E. Thereare no safety stock requirements for any of the items. The production planner wants to determinthe material requirements plan for items C, D, and E for the next 8 weeks. What is the plannedreceipts quantity for item E for week 8?E(4)DAFigure 1. BOMS for products A and BTable 1. MPS quantity start dates for products A and BWeekРroduct235A1002008565505075Table 2. Inventory record dataData categoryYLot-sizing ruleLead timeScheduled receiptsBeginning inventoryL4L2 weeks200 (week 3)200ItemDFOQ = 2001 weekPOQ (P=2)1 weekNoneNone200co

In POQ technique we procure for a given set of duration when there is a procurement order needs to…

Answered: Figure 1 shows the BOMS for two…

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

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…
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)?
The BOM for product A is shown in Figure 11.40, and datafrom the inventory records are shown in Table 11.9. In theMPS for product A, the MPS start row has 100 units in week 3and 200 in week 6. Develop the material requirements planfor the next 6 weeks for items C, D, and E. a. Develop the material requirements plan for the next6 weeks for items C, D, and E.b. What specific managerial actions are required inweek 1?
Given the following partial product tree, explode, offset, and determine the gross andnet requirements for components H, I, J, and K. There are other components, but theyare not connected to this problem. The quantities required are shown in parentheses.The master production schedule calls for the completion of 60 Hs in week 3 and 80 inweek 5. There is a scheduled receipt of 120 Is in week 2. There are 400 Js and 400 Ksavailable. All lot sizes are lot-for-lot
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. Also, evaluate the cost of the schedule. Use the example in the chapter as a guide (Plan 1). The monthly forecasts for Product X for January, February, and March are 1,000, 1,500, and 1,200, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 500 units. Manufacturing cost is $200 per unit, storage cost is $3 per unit per month (based on expected end-of-month levels), standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of backorder is $10 per unit per month, marginal cost of subcontracting is $10 per unit, hiring and training cost is $200 per worker, layoff cost is $300 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 50 workers and that they work…
Prepare a Master Production Schedule (MPS) for an Agri-Chemical company in Malawi given the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory.
An end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.
Prepare a Master Production Schedule (MPS) for an Agri-Chemical company given the following information: The forecast for each week of an eightweek schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units
The BOM for product A is shown in Figure 11.45. The MPS forproduct A calls for 120 units to be started in weeks 2, 4, 5, and8. Table 11.14 shows data from the inventory records.a. Develop the material requirements plan for the next8 weeks for each item.b. What specific managerial actions are required in week 1?Make sure you address any specific difficulties youencounter in the inventory records.
Prepare a Master Schedule like that shown in Figure 11.11 given the following information:The forecast for each week of an eight-week schedule is 50 units. The MPS tule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week 1.2.3.4Customer Orders 52.35.20.12Use a production lot size of 75 units and no beginning inventory.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 3 clamps. The base is assembled from 2 clamps and 2 housings. Each clamp has 1 handle and 2 castings. Each housing has 1 bearing and 2 shafts. There is no inventory on hand. This exercise contains only parts b and c. The product structure is as follows: Bracket Base(1) Clamp(2) Handle(1) Casting(2) Spring(1) Housing(2) Shaft(2) Clamp(3) Bearing(1) Handle(1) Casting(2) b) Determine the gross quantities needed of each item if you are to assemble 50 brackets. Base: ? Spring: ? Clamp: ? Housing: ? Handle: ? Casting: ? Bearing: ? Shaft: ?

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