Arizona Instruments produces bar code scanners for consumers and other manufacturers on a produce to stock basis. The production planner is developing an MPS for scanners for the next 12 weeks. The product is built in a fixed order quantity of 125 units, and there are 110 units in beginning inventory. The demand forecasts for the next 12 weeks, including customer orders promised to customers for delivery in that time period, is shown on the shown on the next slide. Customer Orders Forecast Demand Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 50 50 50 50 75 75 75 75 50 50 50 50 Customer order 35 25 25 20 0 15 0 0 10 0 0 10 Determine the MPS and Available to Promise (ATP)
Arizona Instruments produces bar code scanners for consumers and other manufacturers on a produce to stock basis. The production planner is developing an MPS for scanners for the next 12 weeks. The product is built in a fixed order quantity of 125 units, and there are 110 units in beginning inventory. The demand forecasts for the next 12 weeks, including customer orders promised to customers for delivery in that time period, is shown on the shown on the next slide. Customer Orders Forecast Demand Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 50 50 50 50 75 75 75 75 50 50 50 50 Customer order 35 25 25 20 0 15 0 0 10 0 0 10 Determine the MPS and Available to Promise (ATP)
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
Arizona Instruments produces bar code scanners
for consumers and other manufacturers on a
produce to stock basis. The production planner
is developing an MPS for scanners for the next
12 weeks.
The product is built in a fixed
order quantity
of 125 units, and there are 110 units in beginning
inventory. The demand forecasts for the next 12
weeks, including customer orders promised to
customers for delivery in that time period, is
shown on the shown on the next slide.
Customer Orders
| Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast | 50 | 50 | 50 | 50 | 75 | 75 | 75 | 75 | 50 | 50 | 50 | 50 |
| Customer order | 35 | 25 | 25 | 20 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 10 |
Determine the MPS and Available to Promise (ATP)
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 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.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.