Question

In: Operations Management

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 currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. 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, $110 for each temp; layoff, $220 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. In each quarter, produce to the full output of your regular workforce, even if that results in excess production. In Winter and Spring, use overtime only if needed to meet the production required in that quarter. Do not use overtime to build excess inventory in prior seasons expressly for the purpose of reducing the number of temp workers in Summer. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round up "Number of temp workers, Workers hired and Workers laid off" to the next whole number and all other answers to the nearest whole number.)

Solutions

Expert Solution

Fall Winter Spring Summer
Forecast 10,000 8,000 7,000 12,000
Beginning inventory 500 -2,300 0 200
Production required 9,500 10,300 7,000 11,800
Production hours required 19,000 20,600 14,000 23,600
Production hours available1 14,400 14,400 14,400 14,400
Overtime hours 0 6,200 0 0
Temp workers2 0 0 0 20
Temp worker hours available 0 0 0 9,600
Total hours available 14,400 20,600 14,400 24,000
Actual production 7,200 10,300 7,200 12,000
Ending inventory -2,300 0 200 200
Workers hired 0 0 0 20
Workers laid off 0 0 0 20
Fall Winter Spring Summer
Straight time $72,000 $72,000 $72,000 $120,000
Overtime $0 $49,600 $0 $0
Inventory $0 $0 $1,000 $1,000
Backorder $23,000 $0 $0 $0
Hiring $0 $0 $0 $2,200
Layoff $0 $0 $0 $4,400
Total $95,000 $121,600 $73,000 $127,600
Annual cost $417,200

Calculations:

------------------


Related Solutions

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,300; winter, 8,200; spring, 6,800; summer, 12,300. Inventory at the beginning of fall is 515 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on...
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,300; winter, 7,600; spring, 6,600; summer, 12,300. Inventory at the beginning of fall is 515 units. At the beginning of fall you currently have 35 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on...
A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes:...
A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $7 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (15 pts) Month                   Forecast 270 310 280 350 310 6.280...
Ina works in a juice firm and has to develop the production plan for the lemon...
Ina works in a juice firm and has to develop the production plan for the lemon and the orange juice concentrates. The fruits (lemon and orange) that she needs to make the juice are not the bottleneck but Ina is concerned about the other main ingredients that go into making the juice: a water-based solution, sugar, and a vitamin mix. Checking with the ERP system tells her that she has 10.3 metric tons of the water solution, 2.92 metric tons...
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% . Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost...
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will...
A production manager needs to develop a production schedule to meet the following demand: Period 1...
A production manager needs to develop a production schedule to meet the following demand: Period 1 2 3 4 5 6 Demand 600 600 800 1000 1200 600 Productions costs are as follows: (a) regular time: $3 per unit. (b) over-time: $5 per unit. (c) subcontract: $7 per unit. (d) Inventory carrying cost = $2 per unit per period (e) Back-order costs = $5 per unit per period. Suppose some workers have retired, and the regular production rate can be...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table. Circuit September October November December IC341 650 875 790 1100 IC256 900 350 1200 1300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 integrated circuits to be stored. Holding costs for both types is $0.05 per unit per month. Because workers are...
What systems are used to forecast sales, develop production schedules, and select inventory dates that minimize...
What systems are used to forecast sales, develop production schedules, and select inventory dates that minimize costs.
develop a teaching plan for an 18 years old patient whose BMI is 30 about healthy...
develop a teaching plan for an 18 years old patient whose BMI is 30 about healthy diet that must be included in his daily base. your report must be hand writing and pickup a picture and attach it here.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT