I need d) 3.Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. Thecompany purchases natural gas from two companies: Southern Gas and Northwest Gas.Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units;Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the follow-ing quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units.Distribution costs for the counties vary, depending upon the location of the suppliers. Thedistribution costs per unit (in thousands of dollars) are as follows:ТоFromHamiltonButlerClermontSouthern Gas102015Northwest Gas121518a. Develop a network representation of this problem.b. Develop a linear programming model that can be used to determine the plan that willminimize total distribution costs.c. Describe the distribution plan and show the total distribution cost.d. Recent residential and industrial growth in Butler County has the potential for increas-ing demand by as much as 100 units. Which supplier should Tri-County contract withto supply the additional capacity?

Linear programming is a mathematical technique that is also used in operations management…

Answered: a. Develop a network representation of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 30P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
CASE EIGHT GLASSES A DAY (EGAD) The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several "designer" flavors. Marketing manager Georgianna Mercer 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 in the following table (quantities are in tankloads). Month May Jun Jul Aug Sep Oct Total Forecast 50 60 70 90 80 70 420 Production manager Mark Mercer (no relation to Georgianna) has developed the following information. (Costs are in thousands of dollars.) Regular production cost $1 per tankload 60 tankloads Regular production capacity Overtime production cost Subcontracting cost Holding cost Backordering cost Beginning inventory Question $1.6 per tankload $1.8 per tankload $2 per tankload per month Backlogs are not allowed 0 tankloads Among the strategies being considered are…
Problem 11-11 (Static) A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4, and again in period 8, as can be seen from the following forecasts. Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 full-time employees, each of whom produces 10 units of output per period at a cost of $6 per unit. Beginning inventory for period 1 is zero. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager has decided to use part-time workers to assist during seasonal peaks. The cost per unit, including hiring and training, is $11. The output rate is 10 units per worker per period for all workers. A maximum of 10 part-time workers can be used, and the same number of part-time workers…
Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for two independent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions. Output results from the regression analyses were as follows: Driver 1 R squared Intercept X variable (slope) At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information, what is the budgeted amount for Cost Pool A for next month? O A. $3,280 OB. $2,624 O C. $3,464 O D. $3,785 0.46 $551.00 Driver 2 $0.55 0.80 $970.00 $0.33
A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4 and again in period 8, as can be seen from the following forecasts: Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 full-time employees, each of whom can produce 10 units of output per period at a cost of $6 per unit. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager is considering a plan that would involve hiring two people to start working in period 1, one on a temporary basis who would work only through period 5. This would cost $500 in addition to unit production costs. a. What is the rationale for this plan?
Problem: Sales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as follows: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September 15 March 12 October 10 April 14 November 15 May 16 December 17 June 11 January 11 July Required suing a moving average with three periods, determine the demand for vacuum cleaners for next February?
Problem 11-4 (Algo) The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $6.00 a box. The lettuce is sold for $12.00 a box and the dealer that sells old lettuce is willing to pay $1.40 a box. Past history says that tomorrow's demand for lettuce averages 230 boxes with a standard deviation of 33 boxes. How many boxes of lettuce should the supermarket purchase tomorrow? Note: Use Excel's NORM.S.INV() function to find the z value. Round your answer to the nearest whole number. Number of boxes
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
Jerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical products, develops a 4-month aggregate plan. Demand and capacity (in units) are forecast as follows: . Month 1 Month 2 Month 3 Month 4 Labor Regular time 225 265 280 300 Overtime 15 24 26 18 Subcontract 14 15 18 15 Demand 240 304 316 301 The cost of producing each dialysis unit is $875 on regular time, $1,310 on overtime, and $1,600 on a subcontract. Inventory carrying cost is $100 per unit per month. There is to be no beginning or ending inventory in stock and backorders are not permitted. Minimizing cost using the transportation method, the optimal cost is $enter your response here ______ (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,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

SEE MORE TEXTBOOKS

a. Develop a network representation of this problem. b. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. c. Describe the distribution plan and show the total distribution cost.