Given the following product tree (the quantities are shown between brackets in the next page):AB(3)D(1)The following data for A, B, C and D is known:StockSafety StockLot SizeLead Time102013050D400The master production schedule calls for production of 15 A in period 1,5 in period 2, 15 in period 3, 10in period 4, and 15 in period 5.There is a scheduled receipt of 20 A in period 1, 50 B in period 2 and 90 C in period 2.1. Calculate the MRP-explosion.2. Compare between MRP and ERP.2.

Given information Stock Safety Stock Lot size Lead Time A 10 0 20 1 B 30 0 50 2 C 0…

Answered: Given the following product tree (the…

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

B). A company wants to develop a level production plan for a family of products. The opening inventory is 100 units, and an increase to 150 units is expected by the end of the plan. The demand for each period is given in what follows. How much should the company produce each period? What will be the ending inventories in each period? All periods have the same number of working days. Period 1 4 6. Total Forecast Demand | 100 120| 130 140 120 | 110 Planned Production Planned 100 Inventory C). For the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 15 inventory is 9000 units. units per day, and the desired ending Month 1 2 3 4 Total Working Days 20 24 12 19 Forecast Demand 28,000 27,500 28,500 28,500 Planned Production Planned Inventory 11,250
Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 125 units. The following is the BOM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 4 B Hanger subassembly 2 D Hanger casting 4 E Ceramic knob 1 C Rivet head screw 3 F Metal tong 4 G Plastic cap 2 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 22 15 75 24 202 139 1,000 95 What are the Net Requirements for X, A, B, and C respectively?
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model. Suppose that there are currently 100 Disney-car toys in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Disney-car-toys. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65, 20, 51, 0, 0 respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Disney-car toys, what is the level of projected inventory in week 3? O a. 63 O b. 74 O c. 2 O d. None is correct O e. 132 OUS PAGE NEXT PAGE X MAG241C 1500R 144 SURVED ED LED GAMING MONITOR Frm Gaming A
A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model. Suppose that there are currently 100 Disney-car toys in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Disney-car-toys. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65, 20, 51, 0, O respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Disney-car toys, what is the level of projected inventory in week 3? O a. 132 O b. 2 None is correct d. 74 e. 63
A Las Vegas supermarket bakery must decide how many wedding cakes to prepare for the upcoming weekend. Cakes cost $33 each to make, and they sell for $60 each. Unsold cakes are reducedto half-price on Monday, and typically one-third of those are sold. Any that remain are donated toa nearby senior center. Analysis of recent demand resulted in the following table:Demand 0 1 2 3Probability .15 .35 .30 .20How many cakes should be prepared to maximize expected profit?a. Use the ratio method.b. Use the tabular method
A manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheet
. Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production plan is based on months. There are 4 weeks in this month. Opening inventory is 2000 dozen, and it is planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follow. The lot size for both models is 1000 dozen. Calculate the production plan and the MPS for each item.
Suppose we are formulating a Master Production Schedule (MPS) for an item. The lot-size policy for this item calls for a fixed quantity of 300 units. Lead time for this item is three weeks. Week O inventory for this item is 400 units. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item.... Week 1 2 3 4 5 6 Forecast 120 120 100 100 100 120 Booked 115 121 71 0 0 0 When the master schedule is complete. what will be the Projected On-Hand in Week 4?
Electro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.

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