Concept explainers
An end item’s demand
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.
- Develop an MPS for this end item.
- 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 3.
Order 2 is for 60 units to be delivered in period 4.
Order 3 is for 70 units to be delivered in period 6.
Order 4 is for 40 units to be delivered in period 3.
Order 5 is for 20 units to be delivered in period 5.
Order 6 is for 115 units to be delivered in period 9.
Assuming 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)?
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
OPERATIONS MANAGEMENT LL PACKAGE
- 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.arrow_forwardThe opening backlog is 800 units. Forecast demand is as shown here. Calculate theweekly production for level production if the backlog is to be reduced to 100 units.arrow_forwardPrepare a disaggregation schedule for the following situation. The forecast for each period is 700 units. The starting inventory is zero. The MPS rule is to schedule production of the projected inventory on hand is negative. The production lot size is 1000 units. The following table shows committed orders. Frozen Period is the first period. Period 1 2 3 4 5 Committed Order 800 500 300 100 500arrow_forward
- Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of Jhave been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5.Note: J must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 unitsof B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J.E a. Prepare a material requirements plan for component J.b. Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releasesthrough week 3 have all been executed. How many more Bs and Js will be on hand in week 6?arrow_forwardWSS 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?arrow_forwardPrepare 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.arrow_forward
- 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: ?arrow_forwardAn end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?arrow_forwardProduct X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the timing of planned release of component Z for the order of 150 units.arrow_forward
- Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the total gross requirement of “A”arrow_forwardPrepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that there were 64 pumps in inventory at the beginning of week 1. A production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever required.)arrow_forwardFigure below shows a partially completed MPS record for ball bearings.a. Develop the MPS for ball bearings.b. Four customer orders arrived in the following sequence:Order Quantity Week Desired1 500 42 400 53 300 14 300 7Assume that you must commit to the orders in the sequence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,