(c)2017 Second Wind Productions, LLC
Here Here we we have have our our fee feeds dsto tock ck prob proble lem m agai again, n, exc excep eptt now now we we hav have e ad with an added requirements for Iron in the feed. Caution: The numb have previousl encountered. encountered. !nfortuna !nfortunatel tel,, because because of its high "ber "ber content, content, this new supp suppleme leme needed b the beef cattle, hence the negative value as shown. Con for this de"cienc. $ini $inish sh "lli "lling ng in the the matr matric ices es at the the righ right, t, main mainta tain inin ing g the the sam same e form form Then "ll in the solutions in the green%shaded cells along Column &. C )*+.-. Then answer this question as indicated: hat percenta percentage ge of the the "nal "nal mix will be /ust "ller "ller materi material0 al0 This mu *nswer Here
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
ed a fourth material, a Dietary Supplement , along ers shown here are similar, but not the same, as we 4i
t has the e#ect of removing some of the protein equentl, the others materials have to compensate
tting of values as displaed in the table below. aution: 'ou must onl use these four cells (see
5ob 7ietar 5up
st be calculated in 1xcel2 ou ma tpe in a 3
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
estone (4Corn (Can 6eal (5lement (7-
Calcium
)rotein
$iber
Iron
38.0%
0.0%
0.0%
0.0%
0.5% 0.2% 0.0%
11.0% 44.6% -10.0%
2.1% 8.2% 80.0%
0.2% 12.0% 20.0%
1.2%
15.0%
3.7%
4.1%
8&9 4 C 5 7
859 +.; <.3; +.3; 3.3;
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
=accoon Cit has four water puri"cation facilities available to it: )(l resulting puri"cation levels are shown at the right. Clearl, the slo sewage processed at each plant ++ million gallons of sewage must be processed per time period, wi used for irrigation purposes, with the rest being diverted to anothe time period set aside in the citEs budget for this activit. There mu 5ince )3 has been so troublesome with respect to its purit levels, 5till we need to keep it in our model so that we can utiliFe all > of o Here are the constraints that ou are to use in our model: )+ G ) G )> @ ++ 3.D)3 G +?.)+ G .) G >+.D)> @ ADD.D (A3;-)3 G (D;-)+ G (;-) G (A;-)> @ (+;-()3 G )+ G ) G ) ) @ )> ased on our results, what is the "nal cost to =accoon Cit each ti in our answer below *nswer Here
You fnish the below, i 8C9
8=9
)3
)+
)
)>
0.0 1!.0 -0.11 0.0
1.0 26.5 -0.02 0.0
1.0 33.5 0.03 1.0
1.0 42.0 0.06 -1.0
(c)2017 Second Wind Productions, LLC
22 "800 0 0
(c)2017 Second Wind Productions, LLC
nt-3%)(lant->. Their costs to process each million (31?- gallons of sew e of the curve indicates diminishing returns on spending additional fun
h a minimum average qualit (purit- level of A; being required (most facilit that produces potable water for their underground facilities-. st be an equal amount of sewage processed in )lants and >. it management has elected to not use it for sewage processing in the r equation constraints.
>-
e period0 Calculate this in the free space below right (see )*+.-2 incl
cluding shading in the matrices 8&9
859
)3 )+ ) )>
3.7 !.0 6.5 6.5
25.7 "72!.6 "70.4
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
ge and their s. ) i @ volume of of the eBuent is here is ADD,DDD per
)lant
CostJ31? gal
)urit
P1
"1!,000
81%
P2 P3
"26,500 "33,500
!0% !5%
P4
"42,000
!8%
Totals
$800,000
92
foreseeable future.
)urit
ude appropriate units
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
(c)2017 Second Wind Productions, LLC
