Tabard Industries forecasted the following demand for one of its most profitable products for the next 8 weeks: 120, 120, 120, 100, 100, 100, 80, and 80 units. The booked customer orders for this product, starting in week 1 are: 100, 80, 60, 40, 10, 10, 0, and 0 units. The current on-hand inventory is 150 units, the order quantity is 200 units, and the lead time is one week.a. Develop a MPS for this product.b. The marketing department revised its forecast. Starting with week 1, the new forecasts are: 120, 120, 120, 150, 150, 150, 100, and 100 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces.c. Returning to the original forecasted demand level and the MPS record you developed in part (a), assume that marketing accepted a new customer order for 200 units in week 2, and thereby booked orders in week 2 is now 280 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces.

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...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Tabard Industries forecasted the following demand for one of its most profitable products for the next 8 weeks: 120, 120, 120, 100, 100, 100, 80, and 80 units. The booked customer orders for this product, starting in week 1 are: 100, 80, 60, 40, 10, 10, 0, and 0 units. The current on-hand inventory is 150 units, the order quantity is 200 units, and the lead time is one week.
a. Develop a MPS for this product.
b. The marketing department revised its forecast. Starting with week 1, the new forecasts are: 120, 120, 120, 150, 150, 150, 100, and 100 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces.
c. Returning to the original forecasted demand level and the MPS record you developed in part (a), assume that marketing accepted a new customer order for 200 units in week 2, and thereby booked orders in week 2 is now 280 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Inventory management
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.
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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.