This exercise was also contributed by vr$,$ mack wusur un

Ok$$ahoma State University.

You are the Water Resources Manager for Thirstivile

$OK,$ and are working oun the detalls for next year's con$-$

tracts with three different entities to supply water to your

town. Each water source $($A$,$ B$,$ C provides water of differ$-$

ent quality. The quality assessment is aggregated together

in two valties $P1$ and $P2,$ representing a composite of con$-$

taminants, such as THMs$,$ HMAs, and so on$.$ The sources

each have a maximum of water that they can provide

$($measured in thousands of gallons$),$ a minimum that we

must purchase from them, and a per$-$thousand$-$gallon cost.

On the product end, you must procure water such that

you can provide three distinct water products for next

year $($thils is all being done at the aggregate "ciry" level$).$

You must provide drinking water to the city, and then

water to two different wholesale clients $($this is com$-$

monly done by municipalities$).$ The table below shows

requirements for these three products, and the "sales" or

revenue that you get from each customer $($by thousand

gallons, same scale as the earlier cost$).$

For each of the three water products$/$customers$,$

MN is the minimum that we have to provide to each,

MAX is the maximum that we can provide $($it is reasonable

to be provided with a targeted range of product to pro$-$

vide to our customers$),$ the maximum $P1$ and $P2$ weighted

average for the warer blended together for each quality

"category" $($the contaminants$)$ per customer, and the sales

price.

Yes, the second wholesale customer $($WSale $2)$ will take

as much water as you can blend together for them.

Obriously, water from all three sources will need

to be blended together to meet the Thirstiville custom$-$

et requiremenis. There is one more requirement: for

each of the three products $($drinking water and the two

wholesale clients$),$ Source A and Source B both individ$-$

ually $($ye$5,$ separately$)$ must make up at least $2096$ of the

total amount of the production of that particular water

type. We do not have such a requirement for Source C$.$

Create an appropriate L$.$P model that determines

how to meet customer water demand for next year ubile

maximizing profit $($sales less costs$).$ Summarize your

results $($something more than telepathy$-$say, some son.

of table of data beyond the model solution?$)$ It must use

words $(9)$ and indicate how much water we should

promise to buy from our three sources. Integers are not,

required.

Can you please show the solver steps and what the layout would look like on excel please.