Question

In: Operations Management

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 occur. There are 100 workers on January 31. You are given the following demand forecast: February, 80,640; March, 67,200; April, 100,280; May, 40,280. Productivity is four units per worker hour, eight hours per day, 21 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $11 per unit-month; straight-time labor, $12 per hour; overtime, $18 per hour; backorder, $22 per unit.

Develop a production plan and calculate the total cost of this plan. Note: Assume any layoffs occur at beginning of next month. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your answers to the nearest whole number.)

February

March

April

May

Forecast

80,640

67,200

100,280

40,280

Beginning inventory

Production required

Production hours required

Regular workforce

Regular production

Overtime hours

Overtime production

Total production

Ending inventory

Ending backorders

Workers hired

Workers laid off

sheet is drawn here

February

March

April

May

Straight time

Overtime

Inventory

Backorder

Hiring

Layoff

Total

Total cost

sheet is drawn here

Solutions

Expert Solution

Feb Mar Apr May
Forecast 80,640 67,200 100,280 40,280
Beginning inventory 0 0 0 -13,080
Production required 80,640 67,200 100,280 53,360
Production hours required 20,160 16,800 25,070 13,340
Regular workforce 120 100 100 100
Regular production 80,640 67,200 67,200 67,200
Overtime hours 0 0 5,000 0
Overtime production 0 0 20,000 0
Total production 80,640 67,200 87,200 67,200
Ending inventory 0 0 0 13,840
Ending backorders 0 0 13,080 0
Workers hired 20 0 0 0
Workers laid off 0 20 0 0
Feb Mar Apr May
Straight time 241,920 201,600 201,600 201,600
Overtime 0 0 90,000 0
Inventory 0 0 0 152,240
Backorder 0 0 287,760 0
Hiring 1,000 0 0 0
Layoff 0 1,400 0 0
Total 242,920 203,000 579,360 353,840
Total cost 1,379,120

Calculations:


Related Solutions

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...
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...
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...
Problem 8-8 Plan production for a four-month period: February through May. For February and March, you...
Problem 8-8 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,...
For the 12 month period February 2018 through January 2019, the number of degree days that...
For the 12 month period February 2018 through January 2019, the number of degree days that accrued for the Amherst, MA area was 5903. Many houses in New England heat with oil. Suppose a reasonable-size house required a total of 1400 gallons of oil for that recent entire 12- month period. Suppose also that heating oil is priced at $2.90 per gallon. A. What was the total cost to purchase the oil to heat the house for the entire year?...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July 543 August 550 September 546 October 540 November 535 December 529 Predict naïve forecast of patient days for February and June. Predict the patient days for January, using a four-period moving average. Predict the patient days for January, using the six-period moving average. Plot the actual data and the results of the four period and the six-period moving averages. Which is a better predictor?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT