Question

Develop a production plan and calculate the annual cost for a firm whose demand forecast is...

Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you have 30 workers. It is not possible to hire any additional workers until next Summer, at which time temporary workers will be hired at the beginning of Summer and laid off at the end of Summer. Therefore, no hiring or laying off is possible in the Fall, Winter or Spring. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring only if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. (Round up "Number of temp workers" to the next whole number and all other answers to the nearest whole number. Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.)


Fall Winter Spring Summer
  Forecast 10,000     8,000     7,000     12,000     
  Beginning inventory                      
  Production required                     
  Production hours required                      
  Production hours available                     
  Overtime hours                     
  Temp workers                     
  Temp worker hours available                     
  Total hours available                     
  Actual production                     
  Ending inventory                     
  Workers hired                      
  Workers laid off                     


Fall Winter Spring Summer
  Straight time $        $       $       $      
  Overtime                         
  Inventory                         
  Backorder                         
  Hiring                           
  Layoff                         
  Total $        $       $       $      
  Annual cost $      

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
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...
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...
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...
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...
QUESTION 2: Kafue Steel has recorded the monthly forecast for one of its products, mild steel...
QUESTION 2: Kafue Steel has recorded the monthly forecast for one of its products, mild steel grade AISI 1023 rods, for January, February, March and April as 1000, 1500, 1200, and 1400, 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, 21 in March and 21 in April. Beginning inventory is 500 units. Manufacturing cost is K1,000,000 per unit, storage cost...
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...
In order to effectively address the seasonal variation appearing in the annual demand of its products,a...
In order to effectively address the seasonal variation appearing in the annual demand of its products,a bicycle manufacturer starts an aggregate planning.A planning hori- zon of 6 months is used. The (aggregate) demand forecast for the next six months along the number of working days are given below: Month Demand Forcast Number of Working Days Jan 1800 22 Feb 1500 19 Mar 1100 21 apr 900 21 may 1100 22 june 1600 20 If the manufacturer operates 300 days a...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore,...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore, a manufacturer of soft drinks. Your company makes three types of soft drinks: regular, diet, and super-caffeinated. Fortunately, all three types are made using the same production process, and the costs related to switching between the three types are so minimal that they can be ignored. Thus, you can treat your problem as an aggregate planning exercise where the planning unit is cases of...
Cost data Regular time labor cost per hour $10.00 Overtime labor cost per hour $15.00 Hiring...
Cost data Regular time labor cost per hour $10.00 Overtime labor cost per hour $15.00 Hiring cost per employee $84.00 Firing cost per employee $100.00 Inventory holding cost per unit per period $20.00 Shortage cost per unit per period                                                 $600.00 Material cost per unit $450.00 Capacity data Beginning workforce (employees)                                                    200 Beginning inventory (units) 400 Labor standard per unit (hours) 6 Regular time hours available per period per employee 160 Overtime hours available per period per employee 32 Demand data November 6000...