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 110 workers on January 31. You are given the following demand forecast: February, 81,920; March, 70,400; April, 100,040; May, 40,040. 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, $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

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 110 workers on January 31. You are given the following demand forecast: February, 81,920; March, 70,400; April, 100,040; May, 40,040. 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, $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

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Develop a production plan and calculate the annual cost for a firm whose demand forecast is: fall, 10,100; winter, 8,100; spring, 7,100; summer, 12,100. Inventory at the beginning of fall is 505 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 if overtime is necessary to prevent stock-outs 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; regular 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…
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 if overtime is necessary to prevent stock-outs 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; over time, $8 per hour. Assume that productivity is 0.5 units per worker hour, with eight hours per day and 60 days per season. (Answer in Appendix D)
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=17751775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=1775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month by…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=1775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month by…
Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 11,000; winter, 8,000; spring, 6,000; summer, 13,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 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. a. What is the total cost for this plan?
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,700 June 2,100 March 1,700 July 1,900 April 1,700 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement=18001800 units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,100 February 1,700 June 2,100 March 1,600 July 1,700 April 1,900 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. Evaluate the following plans D and E. Plan D: Keep the current workforce stable at producing 1,600 units per month. In addition to the regular production, another 20% of the normal production units can be produced in overtime at an additional cost of $50 per unit. A warehouse now constrains the maximum allowable inventory on hand to 600 units or less. Note: Do not produce in overtime if production or inventory are adequate to cover demand.…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,300 February 1,700 June 2,100 March 1,600 July 1,900 April 1,700 August 1,300 Her operations manager is considering a new plan, which begins in January with 200units on hand and ends with zero inventory. Stockout cost of lost sales is $125per unit. Inventory holding cost is $25per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,300units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75per unit. Subcontracting capacity is limited to 1,000units per month. Evaluate this plan by computing the costs for January through August. Part 2 In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by…
Refer to the data in Problem 6, If backorders are allowed, Costs Productiondetermine the total cost of a plan if overtime is limited to Regular Time $ 40.00 per unit Regular 60040 units per month and subcontracting is limited to Overtime $ 60.00 per unit Overtime 4020 units per month. Backordering costs are $30 per unit. Subcontracting $ 80.00 per unit Subcontracting 20Holding $ 10.00 per unit per monthBack Order $ 30.00 per unitMonth Forecast1 5702 6003 6304 6505 6706 690Totals
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. Also, evaluate the cost of the schedule. Use the example in the chapter as a guide (Plan 1). The monthly forecasts for Product X for January, February, and March are 1,000, 1,500, and 1,200, 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 500 units. Manufacturing cost is $200 per unit, storage cost is $3 per unit per month (based on expected end-of-month levels), standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of backorder is $10 per unit per month, marginal cost of subcontracting is $10 per unit, hiring and training cost is $200 per worker, layoff cost is $300 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 50 workers and that they work…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 requirement= The average monthly demand (Enter your response as a whole number.)