Problem 8 13 Shoney Video Concepts produces a line of videodisc players to be linked to personal computers for video games Videodiscs have much faster access time than tape With such a computer video link, the game becomes a very realistic experience In a simple driving game where the joystick steers the vehicle, for example, rather than seeing computer graphics on the screen, the player is actually viewing a segment of a videodisc shot from a real moving vehicle Depending on the action of the player (hitting a guard rail, for example), the disc moves virtually instantaneously to that segment and the player becomes part of an actual accident of real vehicles (staged, of course) 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 this is not the lowest cost alternative The forecast for the next 12 months is MONTH FORECAST DEMAND MONTH FORECAST DEMAND January 590 July 170 February 790 August 190 March 890 September 290 April 590 October 690 May 390 November 790 June 270 December 810 Manufacturing cost is $200 per set, equally divided between materials and labor Inventory storage cost is $5 per month A shortage of sets results in lost sales and is estimated to cost an overall $22 per unit short The inventory on hand at the beginning of the planning period is 200 units Ten labor hours are required per videodisc player The workday is eight 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) (Leave no cells blank be certain to enter 0 wherever required Indicate monthly shortages using a negative ending inventory level Round up the number of workers to the next whole number and round down your monthly production rates to the next lower whole number ) January February March April May June July August September October November December Total Forecast 590 790 890 590 390 270 170 190 290 690 790 810 Beginning inventory Available production Ending inventory Costs Total Lost sales Inventory Total

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 28, 2024

Problem 8-13 Shoney Video Concepts produces a line of videodisc players to be linked to personal computers for video games. Videodiscs have much faster access

Problem 8-13

Shoney Video Concepts produces a line of videodisc players to be linked to personal computers for video games. Videodiscs have much faster access time than tape. With such a computer/video link, the game becomes a very realistic experience. In a simple driving game where the joystick steers the vehicle, for example, rather than seeing computer graphics on the screen, the player is actually viewing a segment of a videodisc shot from a real moving vehicle. Depending on the action of the player (hitting a guard rail, for example), the disc moves virtually instantaneously to that segment and the player becomes part of an actual accident of real vehicles (staged, of course).

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 this is not the lowest-cost alternative. The forecast for the next 12 months is

MONTH	FORECAST DEMAND	MONTH	FORECAST DEMAND
January	590	July	170
February	790	August	190
March	890	September	290
April	590	October	690
May	390	November	790
June	270	December	810

Manufacturing cost is $200 per set, equally divided between materials and labor. Inventory storage cost is $5 per month. A shortage of sets results in lost sales and is estimated to cost an overall $22 per unit short.

The inventory on hand at the beginning of the planning period is 200 units. Ten labor hours are required per videodisc player. The workday is eight 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). (Leave no cells blank - be certain to enter "0" wherever required. Indicate monthly shortages using a negative ending inventory level. Round up the "number of workers" to the next whole number and round down your "monthly production rates" to the next lower whole number.)

January

February

March

April

May

June

July

August

September

October

November

December