Excel Solver Set Up Problem

Need help on homework. Can you go through the process on how I can get the answer? Thank you!

In the sheet "Solver Set Up" you are running a blood donation clinic. You have six cities that have provided you with a donated supply of blood. You need to choose where to send them. Set your objective to save the maximum Total Lives Saved The number of units supplied by each city is fixed. Tell Solver to find the answer by changing the cells of where the donations are allocated. Mathematically, you are constrained by the fact that you cannot allocate more blood in total to cities than has been supplied in total. Note, we don't want to rule out the possibility that all blood will be allocated to one city, so don't add extra constraints about where these units may end up. Note: We did not cover the differences in the algorythm methods of solving these problems, we will stick with the default GRG Nonlinear method. Problem 1: Set up the inputs of "Solver" using the guidelines above. Keep the initial allocations blank as the first seed value. Use the Answer Report feature to show your answer. Rename the report sheet "Allocation Report 1." Problem 2: Use the same specifications for the objective, constraints, and choice varaibles. Change the initial allocations to a reasonable seed value. Use the Answer Report feature to show your answer. Rename the report sheet "Allocation Report 2". You may need to try a few different seed values to find the solution, but as a hint, you should able to save at least 150,000 lives. 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 Problem 1 Problem 2 Choice 1 point 1 point Constraint 1 point 1 point Objective 1 point 1 point Seed Values 1 point 1 point Blood Donation Allocation Problem Donations Supplied Donations Allocated City A-burgh 375,000 B-port 46,000 C-polis 190,000 D-view 120,000 E-ville 228,000 F-wick 41,000 Total 1,000,000 Total Lives Saved In the sheet "Solver Set Up" you are running a blood donation clinic. You have six cities that have provided you with a donated supply of blood. You need to choose where to send them. Set your objective to save the maximum Total Lives Saved The number of units supplied by each city is fixed. Tell Solver to find the answer by changing the cells of where the donations are allocated. Mathematically, you are constrained by the fact that you cannot allocate more blood in total to cities than has been supplied in total. Note, we don't want to rule out the possibility that all blood will be allocated to one city, so don't add extra constraints about where these units may end up. Note: We did not cover the differences in the algorythm methods of solving these problems, we will stick with the default GRG Nonlinear method. Problem 1: Set up the inputs of "Solver" using the guidelines above. Keep the initial allocations blank as the first seed value. Use the Answer Report feature to show your answer. Rename the report sheet "Allocation Report 1." Problem 2: Use the same specifications for the objective, constraints, and choice varaibles. Change the initial allocations to a reasonable seed value. Use the Answer Report feature to show your answer. Rename the report sheet "Allocation Report 2". You may need to try a few different seed values to find the solution, but as a hint, you should able to save at least 150,000 lives. 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 Problem 1 Problem 2 Choice 1 point 1 point Constraint 1 point 1 point Objective 1 point 1 point Seed Values 1 point 1 point Blood Donation Allocation Problem Donations Supplied Donations Allocated City A-burgh 375,000 B-port 46,000 C-polis 190,000 D-view 120,000 E-ville 228,000 F-wick 41,000 Total 1,000,000 Total Lives Saved