$($i$)$ Instructions

Use linear programming in Excel to solve these problems.

Assignment Submission & Scoring

Assignment Submission

For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes you submit or change the answer.

Assignment Scoring

Your last submission is used for your score.

$[0/10$ Points$]$

MY NOTES

ASWQUANT$137.$E$\mathrm{.}011.$

$$

$$

Solve the following linear program using the graphical solution procedure.

Max$5A+5B$

$s.t.$

$1A100$

$1B80$

$2A+4B380$

$A,B0$

$(A,B)=(,)$

$$ Need Help?

$2.$ Points$]$

ASWQUANT$137.$E$\mathrm{.}033.$

$$

Consider the following linear programming problem.

Min $2A+3B$

$s.t.$

$,1A+4B21$

$,2A+1B7$

$,3A+1\mathrm{.}5B21$

$,-2A+6B0$

$,A,B0$

$($a$)$ Find the optimal solution using the graphical solution procedure and the value of the objective function.

$($b$)$ Determine the amount of slack or surplus for each constraint.

slack for $1A+4B21$

surplus for $2A+1B7$

slack for $3A+1\mathrm{.}5B21$

surplus for $-2A+6B0$

$($c$)$ Suppose the objective function is changed to max $8A+3B.$ Find the optimal solution and the value of the objective funct

$at(A,B)=(,)$