Question

Shoney Video Concepts produces a line of videodisc players to be linked to personal computers for...

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 605     July 205
  February 805     August 205
  March 905     September 305
  April 605     October 705
  May 405     November 805
  June 305     December 905


     Manufacturing cost is $220 per set, equally divided between materials and labor. Inventory storage cost is $6 per unit per month and is assigned based on the ending inventory level. A shortage of sets results in lost sales and is estimated to cost an overall $23 per unit short.

    The inventory on hand at the beginning of the planning period is 220 units. Twelve labor hours are required per videodisc player. The workday is nine hours. No backorders exist, meaning any unmet demand in one month is not carried over to the next month.

Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days each month except July, when the plant closes down for three weeks' vacation (leaving six 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 "Available production" values to the nearest whole number.)


     January      February     March      April      May      June      July      August    September    October     November     December Total
  Forecast 605 805 905 605 405 305 205 205 305 705 805 905
  Beginning inventory   
  Available production
  Ending inventory   
                                         
  Costs                                     Total
  Lost sales
  Inventory
  
  Total
  

Homework Answers

Answer #1

Solution :

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Trexoid Inc. makes a popular video game console. Demand varies each month, with highest demand coming...
Trexoid Inc. makes a popular video game console. Demand varies each month, with highest demand coming in the last quarter of the year. Regular production costs are $250 per unit and inventory carrying cost is $3 per unit per quarter. Overtime production cost is $280 per unit. Assume that the 20 current Trexoid employees can produce a total of 30,000 units per quarter in regular production and can work enough overtime hours to produce the amount required if a chase...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing...
Aggregate Planning A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest “Squeaky Clean” IV stand, which eliminates all oils and germs left behind by users. Though IVP sells these stands all year long, they sell the most during the summer months, when end-of-fiscal year purchases are at a peak. The demand over the next 12 months is shown in...
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months...
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months is 13,400 units, and desired ending inventory level at the end of the 12th month is 1,000 units, what is the cost of production per month if a level strategy is used  and per unit cost of production is $32? (round to the nearest integer)
for the following data, calculate the number of workers required for level production and the resulting...
for the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 14 units per day, and thee desired ending inventory is 9000 units. Month May June Jul Aug Total Working Days 20 24 12 19 ________ Forecast Demand 2800 27500 28500 28500 _________ Planned Production ____-___ ______ ______ ______ _________ Planned Inventory 11,500 ______ ______ _______ _________
The? S&OP team at Kansas? Furniture, has received estimates of demand requirements as shown in the...
The? S&OP team at Kansas? Furniture, has received estimates of demand requirements as shown in the table. Assuming? one-time stockout costs for lost sales of ?$125 per? unit, inventory carrying costs of ?$30 per unit per? month, and zero beginning and ending? inventory, evaluate these two plans on an incremental cost? basis: Plan? A: Produce at a steady rate? (equal to minimum? requirements) of 1,000 units per month and subcontract additional units at a ?$65 per unit premium cost. Subcontracting...
Develop a production schedule to produce the exact production requirements by varying the workforce size for...
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 950, 1,510, and 1,220, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 550 units. Storage cost is $4 per unit per month...
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a...
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,800,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $24 per hour. Quarter Demand 1 7,500,000 2 8,300,000 3 15,000,000 4 12,500,000 Current workforce 300 workers Average output per worker 25,000 jeans per quarter Inventory...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For...
Question 4: Aggregate Planning Plan production for a four month period: June through to September. For June and July you should produce to exact demand forecast. For August and September you should use overtime and inventory with a stable workforce. Stable means the number of workers needed for July will be held constant through September. However the Ministry of Labour regulations put a maximum of 5000 hours of overtime labour per month in August and September (Zero overtime in June...