The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:JanuaryFebruaryMarchAprilMonth0 December1 January2 February3 March4 April5 May6 June7 July8 AugustDemand1,4001,5001,6001,8002,1002,3001,4001,5001,6001,800Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $65 per unit. Inventory holding cost is $25 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 allowableinventory on hand to 600 units or less.Note: Do not produce in overtime if production or inventory are adequate to cover demand.1,8001,400Production(Units)1,6001,600MayJune1,6001,6001,6001,6001,6001,600JulyAugust2,1002,3001,8001,400Plan DO.T.EndingProduction (Units) Inventory200Stockouts (Units)

Aggregate planning is a technique to plan the forecast for different families of products and…

Answered: The president of Hill Enterprises,…

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

Problem 9a: Jones Surgicenter uses 90,000 bags of IV solution annually. The optimal safety stock (which is on hand initially) is 1,000 bags. Each bag costs the center $1.50, inventory carrying costs are 20 percent, and the cost of placing an order with the supplier is $15. Problem 9b: Continuing with the previous question, what is the total inventory cost, TIC? Do not include the dollar sign in your answer.
Zan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zan has years of food processing experience, and Angela has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per bag of lettuce. They think a largely manual process will have monthly fixed costs of $40,000 and variable costs of $2.00 per bag. A more mechanized process will have fixed costs of $72,000 per month with variable costs of $1.25 per bag. They expect to sell the shredded lettuce for $3.00 per bag. a) The break-even quantity in units for the manual process = enter your response here bags (round your response to the nearest whole number). b) The revenue…
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: May 2,100 January February 1,450 1,700 1,700 June 2,300 July 1,900 March April 1,700 August 1,300 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 $65 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the following plan. This exercise contains only Plan E. Plan 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. Month 10 December 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August Demand 1,450 1,700 1,700 1,700 2,100 2,300 1,900 1,300 Production (Units) 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 Plan E Ending Subcontract (Units) Inventory 200 The total subcontracting cost = $ (Enter your response as…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,120 February 4,220 March 3,920 April 4,320 May 4,920 June 4,620 July 5,220 August 4,820 September 5,320 October 5,620 November 6,220 December 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
An X product is composed of A, B, C items. The aggregate plan for February and some of the information are provided as follows. Prepare the master production schedule.
Please help me answer this question. Please provide solution/computation.
Id-6c An aggregate plan provides justification for: Select one: a. the budget amount requested b. demand for individual products c. demand for product families d. the demand for the parts of each product and. number of customers
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?
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 940, 1,520, and 1,230, 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 570 units. Manufacturing cost is $170 per unit, storage cost is $5 per unit per month, standard pay rate is $8 per hour, overtime rate is $12 per hour, cost of stock-out is $9 per unit per month, marginal cost of subcontracting is $8 per unit, hiring and training cost is $160 per worker, layoff cost is $260 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 44 workers and that they work 8 hours per day. (Leave the cells blank, whenever zero (0) is required. Input all values as positive values. Round up "Workers Required"…
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…

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