B. The model in (A) was solved using Solver and part of the Solver output is shown below. Useit to answer the questions that follow.Adjustable CellsOriginalValueCellNameFinal Value$C$4 Koforidua Sunyani$D$4 Koforidua Cape Coast$E$4 Koforidua Ho$¢$5 Accra Sunyani$D$5 Accra Cape Coast$E$5 Accra Ho$C$6 Kumasi Sunyani$D$6 Kumasi Cape CoastŞE$6 Kumasi Ho80800.10106060100100b) As a management, science student the MD of the company seeks your expert advice onways in which to determine the optimal transportation rule.c)Advise the MD, providing detailed explanation using the table above. Write your answerin a form of a report to the MD.d) Using practical examples from the field of business compare and contrast the concept ofbalance and unbalance transportation problem. Illustrate your understanding of theseconcepts by discussing and explaining possible four reasons for balance or unbalancetransportation problem using a practical case in industry.

Introduction: The given problem involves a transportation model that has been solved using Solver, a…

Answered: b) As a management, science student the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section: Chapter Questions

Problem 67P

See similar textbooks

Similar questions

Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?
Chapter 6. Solve the following Linear Program using the Solver method and answer the questions given below (round to two decimal places): Maximize 12A + 15B s.t. 3A + 7B <= 250 5A + 2B <= 200 B <= 25 A, B >= 0 a. The optimal value of A is 31.03 and the optimal value of B is 22.41. b. The maximized function yields a solution of 708.62. Chapter 7. For the problem you solved in Q1, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions: The range for Variable A is from ????? to ????? The range for Variable B is from ????? to ????? The range for Constraint 1 is from ????? to ????? The range for Constraint 2 is from ????? to ????? The range for Constraint 3 is from ????? to ?????
1. Explain your observations about the optimal solution returned by the Solver. 2. If the company has budget to increase the total capacity by 1,000 units, at which plant would you recommend them to expand? What would be total cost savings (i.e., potentially more reduction in the total costs) with this expansion? Refer to the sensitivity report and explain your answer. (Copy and paste the constraints section of the sensitivity report here.) 3. Suppose that the Atlanta plant had to reduce capacity by 1,000 units to repair and renovate. How much would this cause the total (optimized) transportation costs to increase? Refer to the sensitivity report and explain your answer. All i need is help with explaing these answers using the sensitivy reports and answer reports.
Given this linear programming model, solve the model and then answer the questions that follow.Maximize Z = 12x1 + 18x2 + 15x3 where x1 = the quantity of product 1 to make, etc.Subject toMachine 5x1 + 4x2 + 3x3 ≤ 160 minutes Labor 4x1 + 10x2 + 4x3 ≤ 288 hoursMaterials 2x1 + 2x2 + 4x3 ≤ 200 poundsProduct 2 x2 ≤ 16 units x1, x2, x3 ≥ 0 a. Are any constraints binding? If so, which one(s)?
Analyze algebraically what special case in simplex application is present in each of the LP model below. Give an explanation to support your answer. a) Maximize z = 4x1 + 2x2 Subject to: 2x1 - x2 ≤ 2 3x1 - 4x2 ≤ 8 x1, x2 ≥ 0b) Maximize z = 3x1 + 2x2 Subject to: 4x1 - x2 ≤ 8 4x1 + 3x2 ≤ 12 4x1 + x2 ≤ 8 x1, x2 ≥ 0
The board of directors of General Wheels Company is considering seven large capital investments. Each investment can be made only once. These investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table. Investment Opportunity 1 2 3 4 5 6 7 Estimated Profit ($million) 17 10 15 19 7 13 9 Capital Required for Investment Opportunity ($million) Capital Available ($million) 1 2 3 4 5 6 7 Capital 43 28 34 48 17 32 23 100 The total amount of capital available for these investments is $100 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 3 and 4. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. There are no such restrictions on investment opportunities 5, 6, and 7. The objective is to select the combination of capital investments that will maximize the total estimated long-run…
Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a) What will happen to the optimal solution if the unit profit on x increase by 300? b) what will happen happen to the optimal solution if the unit profit on y decreases by 230? c) What will happen to the optimal solution if the unit profit on both x and y change to 700? d) Complete the sensitivity report with upper and lower limit. 1. The JAV Company manufactures two types of lamps; Special lamp and regular lamp. Each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machine, The company's machine are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from…
Please help with correct answers in details: step by step Q1 The optimal solution of this linear programming problem is at the intersection of constraints 1 and 2. Max 3x1 + x2 s.t. 4x1 + x2 ≤ 400 4x1 + 3x2 ≤ 600 x1 + 2x2 ≤ 300 x1, x2 ≥ 0 Over what range can the coefficient of x1 vary before the current solution is no longer optimal? (Round your answers to two decimal places.) ______ to ______? Over what range can the coefficient of x2 vary before the current solution is no longer optimal? (Round your answers to two decimal places.) _______ to _______? Compute the dual value for the first constraint. _______ Compute the dual value for the second constraint. _______ Compute the dual value for the third constraint. _______
The model was solved using solver and part of the results is provided in the table below. Use it to answer the questions that follow. Use it to answer the questions that follow. Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$10 X1 4 0 10 6 4 $B$11 X2 4 0 12 2.666667 4 $B$12 X3 4 0 12 2.666667 4 Constraints Cell Name Final Value Shadow Price Constraint R.H Side Allowable Increase Allowable Decrease $B$5 Manufacturing Usage 20 3.6 20 6.6666667 10 $B$6 Assembly Usage 20 1.6 20 6.666667 10 $B$7 Testing Usage 20 1.6 20 6.666667 10 Determine the optimal solution to the problem. (a) Which resource constraint(s) are binding? Give a reason. (b) If the company could increase manufacturing hours by 10 hours per week or increase the assembly hours by…
Is my solution correct and did I fully answer the questions? (see attachment for my solution) Question: There are three factories on Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1,500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $2,500 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $3,000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.50 ton. The state wants to reduce the amount of P1 in the river by at least 125 tons and the amount of P2 by at least 175 tons. a. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Are the LP assumptions…
The new Chief Operating Officer (COO) of Lee Ching Chemical Company, MaxChing, has found that the firm has been dumping its toxic waste into the local riverfor the last four years and falsifying information to officials about the amounts ofalleged cancer-causing materials in the waste. The plant overseer claims there is noevidence that the waste will cause cancer. Besides, within a hundred kilometersdownriver, there are only a few fishing villages. If the company had to treat thesubstance to neutralize its potentially harmful effects and transport it to a legaldumpsite, the operating costs of the company would rise to a level that could renderthe company uncompetitive. When the organization loses its competitive advantage,five thousand local workers can become unemployed and the economy of that towncould collapse. Question: If you were the COO, what would you do? Why?
Using the Solver Function in Excel to calculate the following: The main challenge is to allocate no more than 140 hours available for play among tables with different pot sizes. Tables with low pot sizes do not generate as much money as those withhigh pot sizes, however the low pot size tables have a greater frequency of play and the hourly expenses are lower because they do not require as much service. The low pot size tables also have a higher house intake (the percentage that the casino takesfrom the players) compared to the high pot tables. There are also restrictions on how manyhours can be allocated to each table. Donald has set a maximum restriction on the number oftables for each pot size for maintenance and security reasons. He has also set a minimum restriction on the number of tables in order to satisfy customer demand. In addition, he has set minimum and maximum restrictions on the number of hours that should be allocated to each table for similar reasons. Given the…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS