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

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…
Aggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate plan that will cover 6 months. Assuming that the company identified the following forecast for the next 6 months: Period Jan Feb March April May June Forecast 270000 275000 245000 255000 335000 270000 They now want to evaluate a plan that calls for a steady rate of regular output (250000 boxes/month). Mainly using inventory, regular time and overtime, and backorders. They intend to start with zero inventory on hand in the first period. The maximum amount of overtime output per period is 30,000 box per month. The regular production cost per box is 30 LE while the overtime cost per box is 35 LE. The holding cost is 5 LE per box per month and the backorder cost is 10 LE per box per month. Then, prepare a master schedule to identify the available to promise amounts, knowing that the policy calls for a fixed order quantity of 350000 units, and currently there are 276000 units in inventory. 5…
A forecast of 240 units in January, 320 units in February, and 240 units in March has been approved for the seismic-sensory product family manufactured at the Rockport facility of Maryland Automated, Inc. Three products, A, B, and C, comprise this family. The product mix ratio for products A, B, and C for the past 2 years has been 35 percent, 40 percent,and 25 percent, respectively. Management believes that the monthly forecast requirements are evenly spread over the 4 weeks of each month. Currently, 10 units of product C are on hand. The company produces product C in lots of 40, and the lead time is 2 weeks. A production quantity of 40 units from the previous period is scheduled to arrive in week 1. Thecompany has accepted orders of 25, 12, 8, 10, 2, and 3 units of product C in weeks 1 through 6, respectively. Prepare a prospective MPS for product C and calculate the availableto-promise inventory quantities.
please help me with Question 3 thanks! Demand forecasts for 2021 are as follows: Month Demand Jan 140,000 Feb 78,900 Mar 85,800 Apr 89,100 May 123,600 Jun 136,350 Jul 120,450 Aug 106,950 Sep 121,950 Oct 135,750 Nov 87,000 Dec 93,300 Each worker can produce 900 products per month and is paid $1500 per month. Assume that at the end of last year, the company has 100 employees working on the production line. Hiring and layoff (firing) decisions are made at the beginning of each month, and associated costs are charged at that time. It costs the company $400 to hire and $800 to lay off a worker. The company incurs holding cost for the amount of ending inventory in each month, and incurs backorder cost at the end of each month for any unfilled orders. The company incurs $2 per month for holding one unit in inventory and $4 per unit backorder. 1 Prepare a level aggregate plan. Under this level aggregate plan, how…
Eight Glasses A Day: The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgianna is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown, Month May June July Aug Sep Oct Total Forecast 50 60 70 90 80 70 420 Production manager Mark Mercer, has developed the following information. (Note: Costs are in thousands of dollars). Regular production cost: $1 per tankload Regular production capacity: 60 tankloads Overtime production cost: $1.6 per tankload Subcontracting cost: $1.8 per tankload Holding cost: $2 per tankload per month Back ordering cost: $5 per month per tankload Beginning inventory: 0 units Among the strategies being considered are: 1. Level production supplemented by up to 10 tank loads a month from overtime 2. A…
Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.
The forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50, and 30 units. The marketing department has booked orders totaling 20, 25, 10, and 20 units for delivery in the first (current), second, third, and fourth weeks. Currently, 30 hand drills are in stock. The policy is to order in lots of 60 units. Lead time is one week.a. Develop the MPS record for the hand drills.b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order?
Jose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants. He needs to develop a 5-month aggregate plan. His forecast of capacity and demand follows: Month 1 2 3 4 5 Demand 150 160 130 200 210 Regular capacity 150 150 150 150 150 Overtime capacity 20 20 10 10 10 Subcontracting: 100 units available over the 5-month period (NOT 100 units each month) Beginning inventory: 0 units Ending inventory required at the last month (i.e. month 5): 20 units. Costs Regular-time cost per unit $100 Overtime cost per unit $125 Subcontracting cost per unit $135 Inventory holding cost per unit per month $3 Assume that backorders are not permitted. a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method). b) State the corresponding…
1. Develop an aggregate plan for the following forecast Period 3 4 5 6 7 Total 1 2 8 Forecast 190 230 260 280 210 170 160 260 180 1,940 There are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. There is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. Backlog cost is P10.00 per unit per period. Will the present workforce able to produce the forecast? b. What is the total cost of the plan? a.
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?
Forecast Data is given within problem. Cost Data is attached Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: LOADING... Click the icon to view the demand forecast. LOADING... Click the icon to view the cost data. John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: • Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B: a level strategy. • Plan C: a level strategy that produces 1,000 cases per quarter and meets the forecast demand with inventory and subcontracting. Part 2 a) Which strategy is the lowest-cost plan? Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). Hiring and Layoff Plan Quarter Forecast Production Hire (Units) Layoff (Units)…
Deb Bishop Health and Beauty Products has developeda new shampoo, and you need to develop its aggregate schedule.The cost accounting department bas supplied you the costsrelevant to the aggregate plan, and the marketing department hasprovided a four-quarter forecast. All are shown as follows: Your job is to develop an aggregate plan for the next four quarters.a) First, try hiring and layoffs (to meet the forecast) as necessary.b) Then try a plan that holds employment steady.c) Which is the more economical plan for Deb Bishop Healthand Beauty Products?

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