PennWest Assembly

Parameters

Production Time $($Hours$)$ Time Available

Operation Standard Deluxe Hours

Cutting

Assembly

Finishing

Packaging

Profit per Unit

Model

Standard Deluxe

Widgets Produced $0\mathrm{.}000000\mathrm{.}00000$

Total Profit $$0\mathrm{.}00$

Department Hours Used Hours Available

Cutting $00$

Assembly $00$

Finishing $00$

Packaging $00$

A B C D

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

PennWest Shipping

Parameters

Shipping Cost$/$Unit Destination

Origin Buffalo Cleveland Baltimore New York Supply

Edinboro

Clarion

California

Demand

Model

Total Cost $$0\mathrm{.}00$

Destination

Origin Buffalo Cleveland Baltimore New York Total

Edinboro $00000$

Clarion $00000$

California $00000$

Total $0000$

Question $5(27$ points$)$

Listen

Ed$-$Buff $$1$ Ed$-$Clev $$1$ Ed$-$ Balt $$2\mathrm{.}25$ Ed$-$NY $$4\mathrm{.}5$

Clar$-$Buff $$1\mathrm{.}5$ Clar$-$Clev $$1\mathrm{.}25$ Clar$-$Balt $$2\mathrm{.}75$ Clar$-$NY $$4$

Cal$-$Buff $$2$ Cal$-$Clev $$1\mathrm{.}5$ Cal $-$ Balt $$3$ Cal$-$NY $$4\mathrm{.}5$

Question $5$ options:

Use the shipping tab in the Excel file for this question. Supply of units at Edinboro, Clarion, and California is $2000$ units. Buffalo's demand is $2000$ units,Cleveland's demand is $1500$ units, Baltimore's demand is $500$ units. and New York's demand is $2000$ units. The shipping costs between locations are in the chart above. You want to minimize shipping costs. Construct a linear program and answer the following questions.

list the values entered in the following cells

b$5$

c$5$

d$5$

e$5$

f$5$

b$6$

c$6$

d$6$

e$6$

f$6$

b$7$

c$7$

d$7$

e$7$

f$7$

b$8$

c$8$

d$8$

e$8$

In solver, what is the set objective cell?

in solver, what are the variable cells?

what is the total cost?

List all non$-$zero amount of items shipped. List the origin, destination, and amount. City abbreviations are fine