The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:JanuaryFebruaryMarch1,6001,7001,800April1,700Month0 December1 January2 February3 MarchHer operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $70 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the following plansD and E.4 April6 May6 JunePlan 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 $55 per unit. A warehouse now constrains themaximum allowable inventory on hand to 600 units or less.Note: Do not produce in overtime if production or inventory are adequate to cover demand.7 July8 AugustDemand1,5001,7001,8001,7002,1002,1001,8001,500The total overtime production cost-S (Enter your response as a whole number)The total inventory holding cost for January through August (Enter your response as a whole number.)The total stockout cost = $(Enter your response as a whole number.)The total cost, excluding normal time labor costs, for Plan D=$(Enter your response as a whole number.)4 April5 May6 JuneShow Transcribed Text1.6001,6001,6001,6001,6001,6001,6001,600MayJune1,5002 February 1,7003 March1.8001,7002.1002,1001.8001,5007 July8 AugustالأسالThe total subcontracting cost=$. (Enter your response as a whole number)The total inventory holding cost for January through August = $(Enter your response as a whole number.)The total cost, excluding normal time labor costs, for Plan E = $. (Enter your response as a whole number.)August2,1002,1001,8001,500Plan DO.T.EndingProduction(Units) Production (Units) Inventory Stockouts (Units)200Plan E: Keep the current workforce, which is producing 1,800 units per month, and subcontract to meet the rest of the demand. Subcontract cost is $75 per unit. Subcontracting capacity is limited to 500 units per month. The warehouse and overtime constraintsfrom Plan D do not apply to this plan.1,6001,6001.6001,6001,8001.6001.6001,600ProductionEndingMonth Demand (Units) Subcontract (Units) Inventory2000 December1 JanuaryPlan EDe

Aggregate planning is the process by which the company's overall state is planned, developed, and…

Answered: 8 August 1,500 The total overtime…

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

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…
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,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…
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 150 units per month. Overtime capacity is 20 units per month. Overtime cost is $30 per unit, backorder cost is $20 per unit. inventory holding cost is $5 per unit, regular time cost of $20 per unit, and beginning inventory is zero. MONTH FORECAST 1 180 2 170 3 140 4 150 5 130 6 150
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 160 units per month. There are 10 units backlogged from before. Overtime cost is $30 per unit, backorder cost is $20 per unit, inventory holding cost is $5 per unit, regular time cost of $20 per unit, and beginning inventory is zero. Month Forecast 1 180 2 170 3 140 4 150 5 130 6 150 a. Prepare an aggregate plan with inventory and backlog allowed. Overtime and subcontracting are not allowed.b. Prepare an aggregate plan if the management decided to switch to…
Planners for a company that makes several models of skateboards are about to prepare the aggregate plan that will cover six periods. They have assembled the following information. Period 1 2 3 4 5 6 Total Forecast 200 200 300 400 500 200 1,800 Costs Output Regular time=$2 per skateboard Overtime =$3 per skateboard Subcontract =$6 per skateboard Inventory =$1 per skateboard per period on average inventory Back orders =$5 per skateboard per period They now want to evaluate a plan that calls for a steady rate of regular-time output, mainly using inventory to absorb the uneven demand but allowing some backlog. Prepare an aggregate plan and determine its cost using the preceding information.
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…
Table below provides the demand forecast and production day information for an aggregate plan. Assume that no back orders are allowed in this case. Month January February March April May June Demand Forecast 3,000 4,500 3,400 2,500 4,000 3,200 Production Days 22 18 21 21 22 20 The costing information that is used to evaluate the total cost of each plan is as follows:• Inventory carrying cost: $4 per unit per month• Subcontracting cost per unit: $15 per unit• Working hours: 8 hours per day• Average pay rate: $12 per hour ($96 per day per worker)• Labour-hours to produce a unit: 2 hours per unit• Cost of increasing daily production rate (hiring and training): $300 per unit• Cost of decreasing daily production rate (layoffs): $700 per unitUse these information to formulate an aggregate plan. The firm would like to use level strategy: constant workforce for the aggregate planning. The firm chooses the average demand of the…
manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 1000 units per month can be used. Backorders are allowed, and they are charged at the rate of $8 per unit per month. Inventory holding costs are $1 per unit per month based on maximum inventory. Determine the cost of this plan if regular time cost is $20 per unit, beginning inventory is zero, and initial backlog from previous plan is 100. Month Forecast 1 800 2 100 3 1200 4 1100 5 1000 6 900 a. Prepare an aggregate plan.b. Prepare an aggregate plan if the management decided to switch to chase…
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.)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS