Microsoft Excel 12.0 Answer Report
Worksheet: [SOLUTIONS PLUS CASE formulated.xlsx]MODEL_fomulated
Report Created: 3/18/2012 8:15:22 PM
Target Cell (Min)
Cell
Name
$B$21 Model Santa Ana
Adjustable Cells
Cell
Name
$B$26 Cincinnati Santa Ana
$C$26 Cincinnat

Microsoft Excel 15.0 Answer Report
Worksheet: [Transshipment_ProbLem1_Illustrated (1).xlsx]Transshipment Model
Report Created: 3/22/2016 10:04:44 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
En

TRANSPORTATION PROBLEM
Unit shipping costs
Origins
Atlanta
Destinations
1
2
Dallas
Columbus
3
4
Boston
1 Philadelphia
2.00
6.00
6.00
2.00
2 New Orleans
DEMAND
1.00
2.00
5.00
7.00
1,400
3,200
2,000
1,400
cost min
Number of units shipped (optimal solution)

A
B
C
1
SOLUTIONS PLUS CASE
2
manufacturing
cost
3
Cincinnati
4
Oakland
D
E
F
G
H
I
J
K
L
M
N
O
1.2
1.65
5
6
Destination
Origin
7
Santa Ana
Cincinnati
Oakland
10 Demand
8
9
El Paso Pendelton
Houston
Kansas City LA
0.84
0.83
0.45
0.36
0.22
0.74
0.49
22,418

Dixon Corporation (Risk Analysis Simulation Problem) by Namuun Badrakh
Note: This problem is similar to the risk analysis application of Monte Carlo simulation presented in your textbook.
The PortaComm simulation problem from the book was discussed in in

Richmond Publishing Company is considering publishing an electronic textbook on spreadsheet applications for
The fixed cost of manuscript preparation, textbook design and Web site development is estimated to be $160,00
Variable processing costs are estima

Regis Logistics has three supply locations and ships goods to four distribution centers located in Pittsburgh, Omaha, Kansas
Unit shipping costs, limit on supply and demand for each of the distribution centers are provided below.
Supply Location Pittsburg

Microsoft Excel 15.0 Answer Report
Worksheet: [Book1]LP MODEL
Report Created: 2/22/2016 11:11:50 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0 Seconds.
Iterat

Erlanger Manufacturing
Graphical Sensitivity Analysis
Decision variables (controllable inputs):
x1 - units of product 1 to make
x2 - units of product 2 to make
Objective function:
max 25x1 + 30x2
(max of profit)
slope is -25/30
s.t.
Constraint 1
1.5x1 + 3

Erlanger Manufacturing
Graphical Solution Procedure
Decision variables (controllable inputs):
x1 - units of product 1 to make
x2 - units of product 2 to make
Objective function:
max 25x1 + 30x2
(max of profit)
s.t.
Constraint 1
1.5x1 + 3x2 <= 450 Limit on

A GMC dealer believes that demand for 2015 Sierra models will be normally
distributed with a mean of 210 and standard deviation of 30.
His cost of receiving a Sierra is $26,000, and he sells Sierras $40,000. Half of all the
cars not sold at full price can

Microsoft Excel 12.0 Answer Report
Worksheet: [Erlanger Manufacturing Solution.xlsx]Model
Report Created: 6/28/2010 4:56:32 PM
Target Cell (Max)
Cell
Name
Max Total Profit
(objective function) Product
$B$13 1
Adjustable Cells
Cell
Name
$B$10 units produce

Use the scenario provided in the PowerPoint presentation to develop an Excel model for Jim's Chiropractic Clinic
You will need to work on 4 sheets of the template.
The sheet named Break even point analysis has built-in comments that should help you in cre

Redwood Unlimited is a paper manufacturing company with three plants on the West Coast.
Their products are shipped to a pair of depots (D1 and D2), one in Midwest and one in the South.
At the depots the products are repackaged and sent by truck to 5 regio

Microsoft Excel 12.0 Answer Report
Worksheet: [SOLUTIONS PLUS CASE formulated.xlsx]MODEL_fomulated
Report Created: 3/18/2012 8:15:22 PM
Target Cell (Min)
Cell
Name
$B$21 Model Santa Ana
Adjustable Cells
Cell
Name
$B$26 Cincinnati Santa Ana
$C$26 Cincinnat

The Lakeland Paper Company manufactures paper at three factories (F1, F2 and F3) and ships their products two depots (D
At the depots the products are repackaged and sent to five regional warehouses (W1, W2, W3, W4 and W5) around the co
to replenishment o