A manufacturer of industrial seafood processing equipment wants you to develop an aggregate plan for the four quarters of the upcoming year using the following data on demand and capacity. Demand for 4 quarters are as follows - Q1 300, Q2 750, Q3 1250, Q4 450. Regular time capacity for Q1 is 400, Q2 500, Q3 750, Q4 400. Overtime capacity for Q1 is 80, Q2 80, Q3 160, Q4 80. Subcontracting capacity is 100 each quarter. Initial inventory is 150. Regular time cost is $1.50/unit. Overtime cost is $2.50/unit. Subcontracting cost is $3.50/unit. Carrying cost is 0.75/unit/quarter. No back ordering is allowed. Find the optimal plan using the transportation method. What is the cost of the plan? [Select] Does any regular time capacity go unused throughout the four period plan? If so, how much? [Select] What there may need to hold units over during the 4 period plan? If so, how many and what

A manufacturer of industrial seafood processing equipment wants you to develop an aggregate plan for the four quarters of the upcoming year using the following data on demand and capacity. Demand for 4 quarters are as follows - Q1 300, Q2 750, Q3 1250, Q4 450. Regular time capacity for Q1 is 400, Q2 500, Q3 750, Q4 400. Overtime capacity for Q1 is 80, Q2 80, Q3 160, Q4 80. Subcontracting capacity is 100 each quarter. Initial inventory is 150. Regular time cost is $1.50/unit. Overtime cost is $2.50/unit. Subcontracting cost is $3.50/unit. Carrying cost is 0.75/unit/quarter. No back ordering is allowed. Find the optimal plan using the transportation method. What is the cost of the plan? [Select] Does any regular time capacity go unused throughout the four period plan? If so, how much? [Select] What there may need to hold units over during the 4 period plan? If so, how many and what

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

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…
Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period).
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
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…
Dwayne Cole, owner of Florida firm that manufactures display cabinets, develops an 8-month aggregate plan. Demand and capacity (in units) are forecast as follows: Сараcity Jan Feb Mar Apr Маy Jun Jul Aug Source (Units) Regular 235 255 290 300 300 290 300 290 Time 30 19 Overtime 20 Subcontract 12 24 26 24 30 28 30 16 15 17 17 19 20 Demand 255 294 321 301 330 320 345 340 The cost of production each unit is $1000 on regular time, $1300 on overtime, and $1800 on a subcontract. Inventory carrying cost is $200 per unit per month. There is no beginning or ending inventory in stock, and no backorders are permitted from period to period. Let the production workforce vary by using regular time first, then overtime and then subcontracting. a) Set up a production plan that minimizes cost by producing exactly what the demand in each month. This plan allows no backorders or inventory. What is this plan's cost? b) Through better planning, regular time production can be set at exactly the same amount,…
Jose Martinez of El Paso has developed a polished stainless steel tortilla machine that makes it a "showpiece" for display in Mexican restaurants. His forecast of capacity and demand follows: Demand Capacity Regular time Overtime 1 140 140 20 2 170 150 40 Month 3 130 150 20 Costs Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Inventory holding cost per unit per month 4 230 Subcontracting: 90 units available over the 5-month period Beginning inventory: 0 units Ending inventory required: 10 units Assume that backorders are not permitted. Using the transportation method, the total cost of the optimal plan is $ (enter your response as a whole number). 150 20 $90 $115 $128 $4 5 240 160 20
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…
The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: month production days demand(in hundred of cases) April 14 75 May 20 100 June 24 200 July 26 140 August 20 100 September 18 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty’s production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and…
degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 1 (IN 000s) 33 15 46 4 5 7 Plastic Demand for plastic sprinklers Percentage of capacity used Machine requirements Labor requirements Bronze YEARLY DEMAND 2 (IN 000s) 45 16 55 9 5 11 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require three operators and can produce up to 11,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires three operators and can produce up to 180,000 sprinklers. Three bronze machines and only one injection molding machine are available. Demand for bronze sprinklers Percentage of capacity used Machine requirements Labor requirements What are the capacity requirements for the next four years? (Assume that there is no…
Spectrum Hair Salon is considering expanding itsbusiness, as it is experiencing a large growth. Th e question iswhether it should expand with a bigger facility than needed,hoping that demand will catch up, or with a small facility,knowing that it will need to reconsider expanding in three years.Th e management at Spectrum has estimated the followingchances for demand:• Th e likelihood of demand being high is 0.70.• Th e likelihood of demand being low is 0.30.Estimated profi ts for each alternative are as follows:• Large expansion has an estimated profi tability of either$100,000 or $70,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $50,000, assuming thatdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If thebusiness expands at this point, the profi tability is expected tobe $90,000. If it does not expand further, the profi tability isexpected to be $60,000.
Spectrum Hair Salon is considering expanding itsbusiness, as it is experiencing a large growth. Th e question iswhether it should expand with a bigger facility than needed,hoping that demand will catch up, or with a small facility,knowing that it will need to reconsider expanding in three years.Th e management at Spectrum has estimated the followingchances for demand:• Th e likelihood of demand being high is 0.70.• Th e likelihood of demand being low is 0.30.Estimated profi ts for each alternative are as follows:• Large expansion has an estimated profi tability of either$100,000 or $70,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $50,000, assuming thatdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If thebusiness expands at this point, the profi tability is expected tobe $90,000. If it does not expand further, the profi tability isexpected to be $60,000.Draw 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?