A$1$

: X Vx Microsoft Excel $16\mathrm{.}0$ Answer Report

D

F

G

Solver Engine

Engine: Simplex LP

$7$

Solution Time: $0\mathrm{.}031$ Seconds.

Iterations: $1$ Subproblems: $2$

$9$

Solver Options

$10$

Max Time Unlimited, Iterations Unlimited, Precision $0\mathrm{.}000001$

$11$

$12$

Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance $1\%,$ Assume NonNegative

$13$

$14$ Objective Cell $($Max$)$

$15$

Cell

Name

$16$

SB$$14$

Original Value Final Value

Profit $=$

$67000$

$17$

$18$

$19$

Variable Cells

$20$

Cell

Name

Original Value

Final Value

$21$

$B$$10$

$22$

SB$$11$

Condos $=$

Land $=$

$23$

$0$

Integer

$5$ Integer

$4\mathrm{.}5$ Contin

$24$

$25$

Constraints

$26$

Cell

$27$

$FS$6$

$28$

SFS$7$

Name

Cost per investment Invested

Maint & Upkeep Invested

$29$

$B$$10=$Integer

Cell Value

Formula

Status

Slack

$485000$ $F$$6<=$SH$$6$ Not Binding $15000$

$14000$ SFS$7<=$SH$$7$ Binding

$0$

$30$

What is the original right$-$hand$-$side $($RHS$)$ value for the first constraint as listed above?

$$14,000$

$$500,000$

$$ $$2,000,000$

$$ $$499,000$