The president'of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as followsJanuaryFebruary1,4501,600May2,3002,2001,900JuneMarch1,7001,700JulyAprilAugust1,300Her 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-lime costs. Evaluate the foilowing planThis exercise contains only Plan EPlan E Keep the current workforce, which is producing 1,600 units per month, and subcontract to meet the rest of the demand Subcontract cost is $75 per unit.Plan EProductionSubcontractEndingInventoryMonthO December1 JanuaryDemand(Units)(Units)2001,4501,6002 February1,6001,6003 March1,7001,6004 April1,7001,6005 May2,3001,6006 June7 July8 August2,2001,6001,9001,6001,3001,600The total subcontracting 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 cost, excluding normal time labor costs, for Plan E = S (Enter your response as a whole number.)

Given: Subcontracted cost per unit = 75 Inventory holding cost per unit = 20

Answered: The total subcontracting cost = sO…

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

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…
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
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.
evelop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 9,700; winter, 8,000; spring, 7,000; summer, 11,700. Inventory at the beginning of fall is 485 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, $80 for each temp; layoff, $160 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…
Planners for a company that makes several models of skateboards are about toprepare the aggregate plan that will cover six periods. They now want toevaluate a plan that calls for a steady rate of regular output, mainly usinginventory to absorb the uneven demand but allowing some backlog. Overtimeand subcontracting are not used because they want a steady output. They intendto start with zero inventory on hand in the first period. Prepare an aggregate planand determine its cost using the following information. Assume a level of outputrate of 300 units per period with regular time. Note that the planned endinginventory is zero. There are 15 workers, and each can produce 20 units per Period 1 2 3 4 5 6 Total Forecast 200 200 300 400 500 200 1800 Cost Information:Regular time = $2 per skateboardOvertime = $3 per skateboardSubcontract = $6 per skateboardInventory = $1 per skateboard per period on average inventoryBack orders = $5 per skateboard per period
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…
A. Planners for a company that makes several models of skateboards are about toprepare the aggregate plan that will cover six periods. They now want toevaluate a plan that calls for a steady rate of regular output, mainly usinginventory to absorb the uneven demand but allowing some backlog. Overtimeand subcontracting are not used because they want a steady output. They intendto start with zero inventory on hand in the first period. Prepare an aggregate planand determine its cost using the following information. Assume a level of outputrate of 300 units per period with regular time. Note that the planned endinginventory is zero. There are 15 workers, and each can produce 20 units perperiod. Period 1 2 3 4 5 6 TotalForecast 200 200 300 400 500 200 1800 Cost Information:Regular time = $2 per skateboardOvertime = $3 per skateboardSubcontract = $6 per skateboardInventory = $1 per skateboard per period on…

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

The total subcontracting cost = sO (Entor your response as a whole number) The total inventory holding cost for January through August = S (Enter your response as a whole number) The total cost, excluding normal time labor costs, for Plan E = S (Enter your respornse as a whole number.)