Question $1$: Formulate the following problem. $($Don$\text{'}$t try to sobe it$).(30\%)$

Question $2$:

The three blood barks in Franklin County are coordinated through a central office that facilitates

blood delivery to four hospitals in the region. The cost to ship a standard container of blood from

each bark to each hospital is shown in the table on this page. Also given are the biweekly number

of containers of blood avalable at each bark and the biweekly number of containers needed at

each hospital. How many shipments should be made biweekly from each blood bank to each

hospital so that total shipment costs are minimized? Model the problem and solve it using excel

solver. $($You must upload the excel file, and report the op timal solutions in your PDF file$)$

$(70\%)$

You should upload one word or pdf file and one excel file.

Table for Question $2$