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,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 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. 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,300 7,600 6,600 12,300
Beginning inventory 515 -1,385 0 1,800
Production required 9,785 8,985 6,600 10,500
Production hours required 19,570 17,970 13,200 21,000
Production hours available1 16,800 16,800 16,800 16,800
Overtime hours 0 1,170 0 0
Temp workers2 0 0 0 12
Temp worker hours available 0 0 0 5,760
Total hours available 16,800 17,970 16,800 22,560
Actual production 8,400 8,985 8,400 11,280
Ending inventory -1,385 0 1,800 780
Workers hired 0 0 0 12
Workers laid off 0 0 0 12
Fall Winter Spring Summer
Straight time $84,000 $84,000 $84,000 $112,800
Overtime $0 $9,360 $0 $0
Inventory $0 $0 $9,000 $3,900
Backorder $13,850 $0 $0 $0
Hiring $0 $0 $0 $1,200
Layoff $0 $0 $0 $2,400
Total $97,850 $93,360 $93,000 $120,300
Annual cost $404,510

Calculations:

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****


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,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...
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