APEC 1201 : Exercise 7
Set your objective to save the maximum Total Lives Saved
Problem 1
Problem 2
Choice
1 point
1 point
Constraint
1 point
1 point
Economics is the study of how to make choices that maximize an objective, subject to constraints. This assignment is an example of an economic choice that does not use money.
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. 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
