Suppose we are formulating a Master Production Schedule (MPS) for an item. Week O projected on-hand is 83 units. The lot-size policy for this item calls for L4L ordering. Lead time for this item is oneweek. There are no safety stock requirements.Here are the demand forecast and the booked orders for this item .Week23456Forecast604545454560Booked59483010What will be the order size of the first MPS Start Quantity that is needed?

MPS L4L is done when on hand inventory is lower than the maximum value of forecasted demand and…

Answered: Suppose we are formulating a Master…

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 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
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 ond. Which lot-sizing method resulted in the lowest cost for the 12 periods?
Demand for a power steering gear assembly is given by Period 1 2 3 4 5 6 7 8 9 10 Gear 14 12 12 13 5 90 20 20 20 20 Currently there are 50 parts on hand. The lot-sizing rule is, again, fixed order period using two periods. Lead time is three periods. Determine the planned order release schedule for the gear. Suppose each gear assembly requires two pinions. Currently there are 100 pinions on hand, the lot-sizing rule is lot-for-lot, and the lead time is one period. Determine the gross requirement and then the planned order release schedule for pinions.
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
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.
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 ona. Silver–Meal.
A firm has the following gross requirements for Item F. If ordering costs are $60 per order and carrying costs are $0.50 per period. If Mult. 60 lot sizing is used, the planned order releases is Group of answer choices 60 in period 2 and 80 in period 3 120 in period 2 and 60 in period 3 80 in period 1 and 0 in period 3 0 in period 1 and 40 in period 3
Prepare 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 500
It is Monday morning, and you have just arrived at work. Complete the followingMRP record as it would appear Monday morning. Lead time is 2 weeks, and the lotsize is 100. During the week, the following events occur. Enter them in the MRP record.a. The planned order for 100 in week 1 is released.b. Thirty of the scheduled receipts for week 1 are scrapped.c. An order for 30 is received for delivery in week 3.d. An order for 50 is received for delivery in week 6.e. The gross requirements of 70 in week 1 are issued.
A initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release
Anticipated demands for a five-period planning horizon are 14, 3, 0, 26, 15. Current starting inventory is four units, and the inventory manager would like to have eight units on hand at the end of the planning horizon. Assume that h = 1 and K = 30. Find the optimal production schedule. (Hint: Modify the first and the last period’s demands to account for starting and ending inventories.)
Prepare a master schedule. The forecast foreach week of an eight-week schedule is 50 units. The MPS rule is to schedule production if theprojected on-hand inventory would be negative without it. Customer orders (committed) are asfollows.Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory

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