J 2PLEASE SOLVE USING EXCEL SOLVER Problem 2 :TRANSHIPMENT PROBLEM500 Production800DenverProductionAtlanta34-52.53-5KansasCity2Louisvill5-5364 4-5465-5FargoDetroitMiamiDallasNewOrleans150 Demand100 Demand150 Demand250 Demand150 Demand

Answered: Problem 2:TRANSHIPMENT PROBLEM 500…

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

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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
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?
Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
Problem 10-05 (Algorithmic) The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $300 per order to cover the expenses of delivering and transferring the fuel to MBC's storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.03 per month, or $0.36 per year; and annual fuel usage is 240,000 gallons. MBC buses operate 300 days a year. What is the optimal order quantity for MBC?Q* = 20,000 How frequently should MBC order to replenish the gasoline supply?fill in the blank orders per year The MBC storage tanks have a capacity of 15,000 gallons. Should MBC consider expending the capacity of its storage tanks?Metropolitan Bus Company the capacity of its storage tanks. What is the reorder point?r = fill in the blank
Problem 10-05 (Algorithmic) The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $225 per order to cover the expenses of delivering and transferring the fuel to MBC's storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.07 per month, or $0.84 per year; and annual fuel usage is 105,000 gallons. MBC buses operate 210 days a year. What is the optimal order quantity for MBC?Q* = __________________ How frequently should MBC order to replenish the gasoline supply?______________orders per year The MBC storage tanks have a capacity of 15,000 gallons. Should MBC consider expending the capacity of its storage tanks?Metropolitan Bus Company does not need to expand the capacity of its storage tanks. What is the reorder point?r = ______________ gallons
Sim-Jo-La Electronics sells a variety of electronic devices including a variety of WIFI SMART camera bulbs. The business began the second quarter (April to June) of 2020 with 15 (V380PRO) camera bulbs at a total cost of $108,750. The following transactions relating to the “V380PRO” camera bulbs were completed during the quarter. April 7 90 bulbs were purchased at a cost of $6,850 each. In addition, the business paid freight charges of $800 cash on each bulb to have the inventory shipped from the point of purchase to their warehouse. April 30 The sales for April were 75 bulbs which yielded total sales revenue of $803,250. (15 of these bulbs were sold on account to longstanding customers of the business) May 6 A new batch of 80 bulbs was purchased at a total cost of $654,800 May 9 Upon inspection of the bulbs purchased on May 6, five (5) of the units were found to be defective and were returned to the supplier. May 31 During the month 62 of the camera…
2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…
Problem 2: Comp-Max Computers assembles computers and computer equipment. It is about to start production of threenew types of computers, called model X, Y, and Z, respectively. Each type will require assembly time, inspection time, and storage space. The availability of each of these resources is limited. Specifically, available assembly time is 400 hours, available inspection time is 300 hours, and available storage space is 500 cubic feet (about 14.2 ms). The amount of each resource required for the different products is reported in the table below. Model X earns a profit of $100 per unit, model Yearns a profit of $125 per unit, and model 2 earns a profit of $200 per unit. Due to some prior agreements with customers, Comp-Max must produce at least 12 model X computers. In addition, management requires that the fraction of total production made up of model 2 computers must not exceed 25%. RESOURCE REQUIREMENTS Assembly time Inspection time Storage space MODEL hrs/unit hrsJunit cu.…
Easyville University awarded scholarships of $50,000.00 each to two students for a bachelor’s degree program. The standard time for degree completion is four years or 8 semesters. Easyville University stipulates that the scholarship amount will be increased or decreased depending on how well the students meet, exceed or fail to meet the standard time (i.e. more money for exceeding standard and less for failing to meet standard). Sam Speedy completed his degree program in three and one half years; while Larry Laggard completed his degree program in five years. Using the Standard Hour Plan, how much scholarship money will be given to: a)Speedy Sam? b) Larry Laggard?
Radiant wants to hire Cargo planes for transporting their goods. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes. In addition, they provided the following cost related information about the two types Cargo planes- WT88 and BH54: Personnel Cost Fuel Cost Maintenance Cost WT88 2000 1000 2000 BH54 2500 1500 1000 Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming: What is the maximum amount Radiant can carry given their budget constraint? Can you solve using solver ? (I did this but I got a wrong answer) Data Personnel Cost Fuel Cost Maintenance Cost Tons WT88 2000 1000 2000 55…
Problem 22-01A a-c The controller of Sunland Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs. TotalElectricity Costs TotalMachine Hours January $2,490 250 February 3,000 320 March 3,530 460 April 4,740 695 May 3,160 450 June 4,900 790 July 4,130 625 August 3,890 590 September 5,170 680 October 4,220 610 November 3,290 320 December 6,410 810 Determine the fixed- and variable-cost components using the high-low method. Fixed-costs $ Variable-costs $ LINK TO TEXT LINK TO TEXT What electricity cost does the cost equation estimate for a level of activity of 460 machine hours? Electricity costs $ By what amount does this differ…
Problem 6. Rylon Corporation manufactures Brute cologne and Chanelle perfume. The raw material needed to manufacture each type of fragrance can be purchased for $60 per pound. Processing 1 pound of raw material requires 1 hour of laboratory time. Each pound of processed raw material yields 3 ounces of Regular Brute cologne and 4 ounces of Regular Chanelle perfume. Regular Brute can be sold for $140 per ounce and Regular Chanelle for $120 per ounce. Rylon also has the option of further processing Regular Brute and Regular Chanelle to produce Luxury Brute, sold at $360 per ounce, and Luxury Chanelle, sold at $280 per ounce. Each ounce of Regular Brute processed further requires an additional 3 hours of laboratory time and a $40 processing cost and yields 1 ounce of Luxury Brute. Each ounce of Regular Chanelle processed further requires an additional 2 hours of laboratory time and a $40 processing cost and yields 1 ounce of Luxury Chanelle. Each year, Rylon has 6000 hours of laboratory…

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

Problem 2:TRANSHIPMENT PROBLEM 500 Production Denver 800 Production Atlanta 3 2 4.5 2.5 3-5 Kansas City 2 Louisvill 5.5 3 6 4 4-5 4 6 5-5 Fargo Detroit Miami Dallas New Orleans 150 Demand 100 Demand 150 Demand 250 Demand 150 Demand