Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity. Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is MONTH FORECAST DEMAND January 550 February 750 March 850 April 550 May 350 June 250 July 150 August 150 September 250 October 650 November 750 December 830 Manufacturing cost is $200 per server, equally divided between materials and labor. Inventory storage cost is  $4 per unit per month and is assigned based on the ending inventory level. A shortage of servers results in lost sales and is estimated to cost an overall $21 per unit short. The inventory on hand at the beginning of the planning period is 200 units. Eight labor hours are required per DVD player. The workday is seven hours. Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 23 working days each month except July, when the plant closes down for three weeks' vacation (leaving eight working days). Assume that total annual production capacity is greater than or equal to total annual demand (i.e., compute workforce level based on annual demand and annual capacity).

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

Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity.

Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is

MONTH FORECAST DEMAND
January 550
February 750
March 850
April 550
May 350
June 250
July 150
August 150
September 250
October 650
November 750
December 830

Manufacturing cost is $200 per server, equally divided between materials and labor. Inventory storage cost is  $4 per unit per month and is assigned based on the ending inventory level. A shortage of servers results in lost sales and is estimated to cost an overall $21 per unit short.

The inventory on hand at the beginning of the planning period is 200 units. Eight labor hours are required per DVD player. The workday is seven hours.

Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 23 working days each month except July, when the plant closes down for three weeks' vacation (leaving eight working days). Assume that total annual production capacity is greater than or equal to total annual demand (i.e., compute workforce level based on annual demand and annual capacity).

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Introduction to Forecasting
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.