In the sheet "Solver Set Up" you are running a blood donation clinic. You have five cities that have provided you with a donated supply of blood. Your objective is to save the most number of lives. The number of lives saved is calculated by the needs of the patients in that city, and also some percentage of the blood may go bad if it is sent to another city (don't worry about changing this formula, pretend that this is given to you from a specialist who has defined this formula for you).

Use Solver to determine how to allocate blood between these five cities. As the economist, you are told how many units of blood were donated in each city, but you are tasked with choosing where to send these units. Note: Mathematically, you are constrained by the fact that you cannot allocate more blood than has been supplied. Also, be careful when you define your constraints, do not rule out the possability that all blood will be allocated to one city.

Problem 1: Use "Solver" to determine the optimal allocation of blood. Remember to consider seed values, as we discussed in class. Note: We did not cover the differences in the algorythm methods of solving these problems, we will stick with the default GRG Nonlinear method.

To grade this, I am going to open your file, open solver, and see what you used for inputs. I should be able to click "solve" and get and answer without an error. Your grade will be based on your seletion of the following

 

Transcribed Image Text:

... Home Insert Draw Page Layout L2 4 1 2 Total Lives Sava 3 23 24 Poste 25 26 27 28 29 30 31 32 AutoSaver+BS= $ LA p 33 34 35 5 Blood Donations Supplied From City A 6 Blood Donations Supplied From City B 7 Blood Donations Supplied From City C 8 Blogd Donations Supplied From City D 3 Blond Donations Supplied From City F 10 11 12 Total Blood Supplied by Donations. 13 Total Blood Allocated for Objective 14 Remaining Unallocated lood 15 16 36 37 38 35 17 Categury 18 Blood located to City A 19 Blood Allocated to City B 20 Blood Allocated to City 23 Blood Allocated to City D 22 Blood Allocated to City E Calibri (Body) B В 1 U v x✓ fx x A Instructions. 8. 11 B 495,000 55,000 350,000 62,500 37,500 A A av A 1,000,000 Solver Set Up Spending (2,000,000) Formulas Data 17 T + C Review === D E View alb V F Tell me Wran Text v Merge & Center v G apec1201_exercise_6 H 1 General $ % 9 1 K I L V M Cell Conditional Format Formatting as Table Styles V N 0 P Insert v Delete Format v D 27.0. Y Find & Sort & Du Filter Select sv R 5 T Share 4 Ideas U Qa Comments Sensitivity V T W. ... Home Insert Draw Page Layout L2 4 1 2 Total Lives Sava 3 23 24 Poste 25 26 27 28 29 30 31 32 AutoSaver+BS= $ LA p 33 34 35 5 Blood Donations Supplied From City A 6 Blood Donations Supplied From City B 7 Blood Donations Supplied From City C 8 Blogd Donations Supplied From City D 3 Blond Donations Supplied From City F 10 11 12 Total Blood Supplied by Donations. 13 Total Blood Allocated for Objective 14 Remaining Unallocated lood 15 16 36 37 38 35 17 Categury 18 Blood located to City A 19 Blood Allocated to City B 20 Blood Allocated to City 23 Blood Allocated to City D 22 Blood Allocated to City E Calibri (Body) B В 1 U v x✓ fx x A Instructions. 8. 11 B 495,000 55,000 350,000 62,500 37,500 A A av A 1,000,000 Solver Set Up Spending (2,000,000) Formulas Data 17 T + C Review === D E View alb V F Tell me Wran Text v Merge & Center v G apec1201_exercise_6 H 1 General $ % 9 1 K I L V M Cell Conditional Format Formatting as Table Styles V N 0 P Insert v Delete Format v D 27.0. Y Find & Sort & Du Filter Select sv R 5 T Share 4 Ideas U Qa Comments Sensitivity V T W.

Answer rating: 100% (QA)

I can direct you on the most proficient method to set up and involve Solver in Microsoft Succeed for this blood designation enhancement issue If its n... View the full answer