Question: Microsoft Excel 14.0 Sensitivity Report Decision Variable Cells Final Value Reduced Cost Allowable Increase Objective Coefficient 35 30 Allowable Decrease 1E+30 IE+30 0 0 0

Microsoft Excel 14.0 Sensitivity Report Decision Variable Cells Final Value Reduced Cost Allowable Increase Objective Coefficient 35 30 Allowable Decrease 1E+30 IE+30 0 0 0 8 -8 0 450 0 0 40 2 9 750 0 1E+30 32 37 0 300 0 5 400 0 40 1E+30 8 Cell Name $B$11 Cleveland to Boston $C$11 Cleveland to Richmond $D$11 Cleveland to Atlanta $E$11 Cleveland to St. Louis $B$12 Detroit to Boston $C$12 Detroit to Richmond SDS12 Detroit to Atlanta SE$12 Detroit to St. Louis SBS13 Greensboro to Boston SC$13 Greensboro to Richmond SD$13 Greensboro to Atlanta SES13 Greensboro to St. Louis Constraints 300 0 42 0 2 0 -9 25 9 1E+30 400 0 40 1E+30 5 0 -28 15 28 0 -25 20 25 9 1E+30 1E+30 1E+30 0 -12 28 Final Value 1100 Shadow Price Constraint R.H. Side Cell SB$15 Allowable Increase 0 Allowable Decrease 400 1100 Name amt supplied to Boston amt supplied to Richmond amt supplied to Atlanta $C$15 SD$15 0 35 45 40 400 750 400 750 300 450 0 1E+30 1E+30 JE+30 SC$13 Greensboro to Richmond 0 -28 15 28 SD$13 Greensboro to Atlanta 0 -25 20 25 $E$13 Greensboro to St. Louis 0 -12 28 9 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $B$15 amt supplied to Boston 1100 35 1100 0 $C$15 amt supplied to Richmond 400 45 400 0 $D$15 amt supplied to Atlanta 750 40 750 SES15amt supplied to St. Louis 750 32 750 SG$11 Cleveland amt used 1200 0 1200 1E+30 SG$12 Detroit amt used 1000 2 1000 450 SG$13 Greensboro amt used 800 5 800 300 How much product is moved optimally from Greensboro to Boston? From Greensboro to Richmond? a. 40010 b. 80019 c. 300 800 d. 0400 Allowable Decrease 400 300 450 750 0 0 0 0 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

QUESTION 102 How much reduction in transportation cost could you expect from taking Boston's product demand down to this minimum level? a $25,000 b. $14,000 c. $10,000 d. S10,500 Final Value Reduced...

What is the cost of this transportation plan? a. $97,700 b. $113,700 c. $135,200 d. $102,300 Final Value Keduced Cost Allowable Increase Objective Coefficient 35 30 Allowable Decrease 1E+30 1E+30 0 0...

Variable Cells Final Value Reduced Cost Allowable Increase Cel $B$10 $C$10 Name X Y Objective Coefficient 20 10 Allowable Decrease 12 ? 8.2 5.5 1E+30 15 ? 40 Constraints Shadow Final Value 180 Price...

Help with Questions AutoSave . Off Questions Search X File Home Insert Draw Design Layout References Mailings Review View Help Move are Comments Size 1) A company can decide how many additional labor...

help with the 3 following questions please: Questions Search Insert Draw Design Layout References Mailings Review View Help 1) A company can decide how many additional labor hours to acquire for a...

each convection heater has a profit of $9.5, while each thermal heater has a profit of $15 and looking at the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell...

Question 3 My Hobby Shop is the leading manufactures in toy industry. They specialize in model car and model plane for toy collectors. A special circuit that runs the power board of the model cars...

Consider the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Chow Chow 96 0 2.25 0.35 0.3 SD$4 Tomato 192...

Part I Nanuq Australia is looking for new opportunity to invest up to 4 million dollars for one year in international shares, CO2 futures, gold and Australian governmental bonds. The projected annual...

A fertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from...

The relevant range is indispensable in cost behavior analysis. Is this true? Why or why not?

Refer to Auditing in Action on Roll Forward Procedures featuring Shadow Company. Assume that Shadow has a significant amount of cash held in an interest-bearing bank account, and that the auditors...

Which of the following is a commonly used approach to equity valuation option a discounted cash flow method option B economic value value added method option C price to book a PB ratio method option...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...