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 95 workers on January 31. You are given the following demand forecast: February, 80,256; March, 66,880; April, 100,120; May, 40,120. Productivity is four units per worker hour, eight hours per day, 22 days per month. Assume zero inventory on February 1. Costs are hiring, $44 per new worker; layoff, $64 per worker laid off; inventory holding, $8 per unit-month; straight-time labor, $8 per hour; overtime, $12 per hour; backorder, $16 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 "O" wherever required. Negative values should be indicated by a minus sign. Round your answers to the nearest whole number.)

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 95 workers on January 31. You are given the following demand forecast: February, 80,256; March, 66,880; April, 100,120; May, 40,120. Productivity is four units per worker hour, eight hours per day, 22 days per month. Assume zero inventory on February 1. Costs are hiring, $44 per new worker; layoff, $64 per worker laid off; inventory holding, $8 per unit-month; straight-time labor, $8 per hour; overtime, $12 per hour; backorder, $16 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 "O" wherever required. Negative values should be indicated by a minus sign. Round your answers to the nearest whole number.)

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

The demand information is given below. Month Demand Jan Feb Mar Apr May Jun 1,900 2,900 4,800 5,800 5,800 1,950 A worker can produce 25 units per month. Assume that the beginning inventory in January is 800 units, and the firm desires to have 150 units of inventory at the end of June. a. Use a chase production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". Month Demand Jan 1,900 Feb Mar Apr May Jun 2,900 4,800 5,800 5,800 1,950 Production 1100 2900 4800 5800 5800 2100 Ending inventory 800 0 150 Workforce 44 116 192 232 232 84 b. Use a level production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative…
Prepare a master production schedule with the information given as follows. The forecast for each week of am eight week schedule is 50 units. The MPS rule is to schedule production if the projected on hand inventory would be negative without it. Customer orders are as follows. Production lot size is 75, safety stock is 10 and no beginning on hand inventory. Calculate available to promise (ATP) quantity for each period. Week Customer Orders 1 52 2 35 3 20 4 12 Period Forecast Cust.Ord. SS Proj. OH MPS ATP
The demand information is given below. Month Jan Feb Mar Apr May Jun Demand 1,900 2,800 4,700 5,600 5,600 1,750 A worker can produce 25 units per month. Assume that the beginning inventory in January is 450 units, and the firm desires to have 300 units of inventory at the end of June. Use a chase production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". Month Jan Feb Mar Apr May Jun Demand 1,900 2,800 4,700 5,600 5,600 1,750 Production Ending inventory 450 Workforce Use a level production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". Month Jan Feb Mar…
Consuelo Chua, Inc., is a Columbian disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data. There are 8 hours of production per day. Holding cost Subcontracting Regular-time labor Overtime labor Hiring cost Layoff cost Costs $8/disk drive/Month $80/disk drive Month $12/hour $18/hour (above 8 hours) $40/worker $80/worker 0 June 1 July 2 August 3 September 4 October 5 November 6 Doramhar What will each of the two following strategies cost? a) Vary the workforce so that production approximates demand. Chua had eight workers on board in June. (Enter all responses as whole numbers). Demand* Fill in the table below. (Enter all responses as whole numbers. In the hire/layoff column, use positive numbers for hires-plus signs omitted; negative numbers for layoffs.) 400 500 550 700 800 700 Current workforce (June) Labor-hours/disk drive Workdays/month Beginning Inventory 150 Other Data 20 days Beginning Inventory 150 disk…
The opening backlog is 800 units. Forecast demand is as shown here. Calculate theweekly production for level production if the backlog is to be reduced to 100 units.
Hill is now considering plan C: Keep a stable workforceby maintaining a constant production ra te equal to the averagerequirements and allow varying in ventory levels. Beginning inventory,stockout costs, and holding costs are provided.Plot the demand with a graph that also shows average requirements.Conduct your analysis for January through August.
. If the opening backlog is 450 units, forecast demand is 700 units, and production is800 units, what will be the ending backlog?
Jill wants you to consider a hybrid aggregate plan, usingup to the maximum overtime per employee for any periodwhere demand cannot be satisfi ed with the current regular-timeproduction and the available inventory. Back orders can occur.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources
The planner at a company that makes garden tractors is about to prepare an aggregate production plan that will cover the next 6 months. She has collected the following information: Month Demand Forecast Above the available capacity through permanent workforce 1 1,000 2 1,000 3 2,000 4 3,000 5 4,000 6 1,000 Total: 12,000 Production per month = 20 units per worker Initial inventory = 500 units Desired ending inventory (at the end of month 6) = 0 units Cost: Hire cost = $500 per temporary worker Inventory = $10 per tractor per month Backorder = $150 per tractor per month The optimum aggregate plan is: Month 1 2 3 4 5 6 Total Forecast Demand above regular capacity 1,000 1,000 2,000 3,000 4,000 1,000 12,000 # of temporary workers required 50 50 100 150 200 50 Temp. Workers hired 25 25 50 75 0 0 Temp. workers laid off 0…
2.15 The opening backlog is 900 units. Forecast demand is shown in the following. Calculate the weekly production for level production if the backlog is to be reduced to 200 units. Week 1 2 3 4 5 6 Total Forecast Demand 600 700 700 700 600 500 Planned Production Projected 900 Backlog
Capacity planning requires a demand forecast for an extended period of time into thefuture. What concerns would you have regarding an extended forecast as a capacityplanner?
Plan production for a four-month period (February through May). Given information: 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 workersneeded 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,000; March, 64,000; April, 100,000; May, 40,000. Productivity is four units per worker hour, eight hours per day, 20 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $10 per unit-month; straight-time labor, $10 per hour; overtime, $15 per hour; backorder, $20 per unit.