Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of concentrate each week. The company has just received orders of 10 tons from Miami for the coming week, 15 tons for Orlando, and 10 tons for Tallahassee. The cost per ton for supplying each of the distributors from each of the processing plants is shown in the following table.
Miami
Orlando
Tallahassee
Eustis
$260
$220
$290
Clemont
$230
$240
$310
The model has been done and after solving the problem, sensitivity analysis is given in below table:
Adjustable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$C$10
Eustis Miami
0
50
260
1E+30
50
$D$10
Eustis Orlando
10
0
220
20
0
$E$10
Eustis Tallahassee
10
0
290
0
310
$C$11
Clermont Miami
10
0
230
50
230
$D$11
Clermont Orlando
5
0
240
0
20
$E$11
Clermont Tallahassee
0
0
310
1E+30
0
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$C$12
Shipped Miami
10
230
10
5
10
$D$12
Shipped Orlando
15
240
15
5
5
$E$12
Shipped Tallahassee
10
310
10
5
5
$F$10
Eustis Used
20
-20
20
5
5
$F$11
Clermont Used
15
0
20
1E+30
5
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Business Analysis With Microsoft Excel
Authors: Conrad Carlberg
3rd Edition
0789736640, 9780789736642
