Use a production lot size of 78 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.) June July

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
icon
Related questions
Question
please answer within 30 minutes.
Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 75 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 Orders
1
55
2
36
3
12
4
2
Use a production lot size of 78 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) in any periods where ATP
should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.)
June
July
1
2
3
4
5
6
7
8
Forecast
75
75
75
Customer Orders
12
0
Projected On-Hand Inventory
MPS
ATP
75
55
75
36
2
75
0
75
0
75
0
Transcribed Image Text:Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 75 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 Orders 1 55 2 36 3 12 4 2 Use a production lot size of 78 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.) June July 1 2 3 4 5 6 7 8 Forecast 75 75 75 Customer Orders 12 0 Projected On-Hand Inventory MPS ATP 75 55 75 36 2 75 0 75 0 75 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
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