WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero. How many total units will be produced in quarter 1 for delivery in quarter 1?  How many units in total will be used to fill back orders over the four quarters? What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one?

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
Question
  • WSS company makes weatherproof surveillance systems for parking lots. Demand estimates for the next four quarters are 25, 9, 13, and 17 units. Prepare an aggregate plan that uses inventory, regular time, and over time, and backorders. Subcontracting is not allowed. The regular time capacity is 15 units for quarters 1 and 2, 18 units for quarters 3 and 4. Overtime capacity is 3 units per quarter. The regular time cost is $2000 per unit, while the overtime cost is $3000 per unit. Backorder costs $300 per unit per quarter; inventory holding costs $100 per unit per quarter. The beginning inventory is zero.
  • How many total units will be produced in quarter 1 for delivery in quarter 1? 
  • How many units in total will be used to fill back orders over the four quarters?
  • What is the cost to produce one unit in Quarter 4 using overtime to fill a back order in quarter one? 
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Aggregate planning
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
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.