Question: rin Value Recucea Cost 0 Uojecte Coefficient 35 ATTOWGore Increase ATOWIore Decrease 0 0 1E+30 1E+30 0 -8 30 8 450 0 40 2 0

rin Value Recucea Cost 0 Uojecte Coefficient 35 ATTOWGore Increase ATOWIore Decrease 0 0 1E+30 1E+30 0 -8 30 8 450 0 40 2 0 0 32 9 0 0 750 300 400 300 37 40 Cell Name SBS11 Cleveland to Boston SCS11 Cleveland to Richmond SD$11 Cleveland to Atlanta SES11 Cleveland to St. Louis $B$12 Detroit to Boston SC$12 Detroit to Richmond SD$12 Detroit to Atlanta SES12 Detroit to St. Louis SBS13 Greensboro to Boston SC$13 Greensboro to Richmond SD$13 Greensboro to Atlanta SES13 Greensboro to St. Louis Constraints 1E+30 5 1E+30 0 0 8 2 0 -9 42 25 40 9 0 400 0 0 -28 -25 -12 IE+30 28 25 15 20 28 0 1E+30 5 1E+30 1E+30 1E+30 0 9 Shadow Price 35 Constraint R.H. Side 1100 Allowable Increase 0 45 0 Cell SB$15 $C$15 SD$15 SES15 SGS11 SGS12 SGS13 Final Value 1100 400 750 750 1200 1000 800 Allowable Decrease 400 300 450 750 Name amt supplied to Boston amt supplied to Richmond amt supplied to Atlanta ant supplied to St. Louis Cleveland amt used Detroit Amt used Greensboro amt used 0 40 32 0 400 750 750 1200 1000 800 0 0 1E+30 450 300 0 2 5 What is the cost of this transportation plan? a. $97,700 b. $113,700 c. $135,200 d. $102,300

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!

undefined A small shipping company sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their...

MG305 Case Study Writing Assignment You are the Plant Manager at Incline Electronics which produces three different products in a plant that is open 40 hours per week. Each product requires the...

Harmanjeet Kauf.001 Siraz 5) Answer the following questions using the sensitivity report shown below: (12 min) a) Report the optimal solution and the optimal value of the objective function. what is...

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...

Suppose you had a trucking friend who absolutely needed the business of moving product from Greensboro to St. Louis. What would his unit transportation cost have to be in order to cause SOLVER to...

Assume the following is the sensitivity analysis report for the Stone Age Surfboards manufacturing problem. The analysis report you developed to answer the previous questions could be different from...

An appliance company operates 3 production plants in the United States. After production, they ship the appliances to 4 regions of the country (North, South, East and West). The table below...

Dual Price is the same as Shadow Price. Constraint Current Value is the same as Constraint R.H.Side Variable (Opt.) Value is the same as Variable Final Value Objective Coefficient Current Value is...

LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in various...

PROBLEM 3: (13 marks) An insurance company has three secretaries, A, B, and C that each is capable of processing four different types of insurance claims. The amount of time required by each...

For the power amplifier of Fig. 12.37, calculate: a. Po(ac). b. Pi(dc). c. %(. d. Power dissipated by both output transistors. tVce (+40 V) Ri 100 0 100 F - 18 V.rms Rs 100 8 02 100 F 1(X) -VEE (40...

5. Binz Company provides cleaning services and sells garbage bins to office clients. On June 1st, Binz delivered 100 garbage bins to a client, and also entered into a 5-year contract for Binz to...

Households are Not a common provider of funds when a bank obtains funds through

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...