A B с D E FL ד G H J K L M N P R S T U V 1 On Week 3 Forecast 4 2 a) Smell Fresh Customer Orders hand 1 2 20 20 5 3 5 PAB 20 50 30 3222 4 5 6 7 8 Problem 6: Georgia Clay and Gravel was updating the MPS record for one of its products, Smell Fresh Cat Litter. Partially-completed MPS time-phased record is given below. 20 30 30 30 30 30 Week 10 30 50 20 40 10 Item: Smell Fresh On hand 1 6 Available to Promise 7 MPS 50 50 50 50 Forecast 20 8 MPS lot size = 50 9 20 10 On Week hand 2 3 4 5 6 7 8 9 20 53 43 78 30 30 30 30 30 3220 2233 -250 30 10 30 50 6 8 45 12 13 14 PAB 15 11 b) Smell Fresh Forecast Customer Orders Available to Promise 16 MPS 17 MPS lot size=50 18 19 20 21 23 24 222 Orders Projected available balance Available-to-promise MPS MPS Lot Size = 50. 50 20 40 10 50 50 50 a) Complete the MPS time-phased record (the first table on the left). The following events occurred during week 1: • Actual demand during week 1 was 25 units. • Marketing forecasted that 40 units would be needed for week 9. • An order for 10 in week 2 was accepted. • An order for 20 in week 4 was accepted. • An order for 6 in week 3 was accepted. •The MPS in week 1 was produced as planned. b) Update the record below after rolling through time. Complete the second table on the left.
A B с D E FL ד G H J K L M N P R S T U V 1 On Week 3 Forecast 4 2 a) Smell Fresh Customer Orders hand 1 2 20 20 5 3 5 PAB 20 50 30 3222 4 5 6 7 8 Problem 6: Georgia Clay and Gravel was updating the MPS record for one of its products, Smell Fresh Cat Litter. Partially-completed MPS time-phased record is given below. 20 30 30 30 30 30 Week 10 30 50 20 40 10 Item: Smell Fresh On hand 1 6 Available to Promise 7 MPS 50 50 50 50 Forecast 20 8 MPS lot size = 50 9 20 10 On Week hand 2 3 4 5 6 7 8 9 20 53 43 78 30 30 30 30 30 3220 2233 -250 30 10 30 50 6 8 45 12 13 14 PAB 15 11 b) Smell Fresh Forecast Customer Orders Available to Promise 16 MPS 17 MPS lot size=50 18 19 20 21 23 24 222 Orders Projected available balance Available-to-promise MPS MPS Lot Size = 50. 50 20 40 10 50 50 50 a) Complete the MPS time-phased record (the first table on the left). The following events occurred during week 1: • Actual demand during week 1 was 25 units. • Marketing forecasted that 40 units would be needed for week 9. • An order for 10 in week 2 was accepted. • An order for 20 in week 4 was accepted. • An order for 6 in week 3 was accepted. •The MPS in week 1 was produced as planned. b) Update the record below after rolling through time. Complete the second table on the left.
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...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
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
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
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.