Assignment 4: Solve the following problem and upload the solutions file (Word, PDF) on the Moodle (due date: Monday Nov. 28 at 5:00 pm). Question 1: Formulate the following problem. (Don't try to solve it). (30%) 900 1100 Supply 1400 - 1000 Demand 1000 - 1200 Question 2: The three blood banks 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 bank to each hospital is shown in the table on this page. Also given are the biweekly number of containers of blood available at each bank 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 optimal solutions in your word or PDF file) (70%) You should upload one word or pdf file and one excel file. Table for Question 2 TO FROM HOSPITAL 1 HOSPITAL 2 HOSPITAL 3 HOSPITAL 4 SUPPLY BANK 1 $8 $1 $16 50 BANK 2 12 8 80 BANK 3 14 10 7 120 DEMAND 90 70 40 50