apec1201_exercise_7

xlsx

School

University of Minnesota-Twin Cities *

*We aren’t endorsed by this school

Course

3012

Subject

Economics

Date

Apr 24, 2024

Type

xlsx

Pages

Uploaded by MinisterAtom7137

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

Objective 1 point 1 point Seed Values 1 point 1 point How long did it take you to complete this assignment? 30 minutes

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Microsoft Excel 16.0 Answer Report Worksheet: [apec1201_exercise_7.xlsx]Solver Set Up Report Created: 4/13/2022 3:20:57 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 0.031 Seconds. Iterations: 0 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Central Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegati Objective Cell (Max) Cell Name Original Value Final Value $D$16 Total Lives Saved Donations Allocated - - Variable Cells Cell Name Original Value Final Value Integer $D$7 A-burgh Donations Allocated - - Contin $D$8 B-port Donations Allocated - - Contin $D$9 C-polis Donations Allocated - - Contin $D$10 D-view Donations Allocated - - Contin $D$11 E-ville Donations Allocated - - Contin $D$12 F-wick Donations Allocated - - Contin Constraints Cell Name Cell Value Formula Status $C$13 Total Donations Supplied 1,000,000 $C$13>=$D$13 Not Binding

tive Slack 1,000,000

Microsoft Excel 16.0 Answer Report Worksheet: [apec1201_exercise_7.xlsx]Solver Set Up Report Created: 4/13/2022 3:38:28 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 0.797 Seconds. Iterations: 24 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Central Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $D$16 Total Lives Saved Donations Allocated 113,401 152,116 Variable Cells Cell Name Original Value Final Value Integer $D$7 A-burgh Donations Allocated 375,000 221,575 Contin $D$8 B-port Donations Allocated 46,000 137,482 Contin $D$9 C-polis Donations Allocated 190,000 311,485 Contin $D$10 D-view Donations Allocated 120,000 246,591 Contin $D$11 E-ville Donations Allocated 228,000 55,624 Contin $D$12 F-wick Donations Allocated 41,000 27,243 Contin Constraints Cell Name Cell Value Formula Status Slack $C$13 Total Donations Supplied 1,000,000 $C$13>=$D$13 Binding -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

City A-burgh 375,000 221,575 B-port 46,000 137,482 C-polis 190,000 311,485 D-view 120,000 246,591 E-ville 228,000 55,624 F-wick 41,000 27,243 Total 1,000,000 1,000,000 Total Lives Saved 152,116 Blood Donation Allocation Problem Donations Supplied Donations Allocated

Related Documents

chapter 1 test.odt

math 240 module 3-3 real estate revised (1).docx

1.3.5 Practice_ Analyzing a Production Possibilities Curve.pdf

Homework 2.docx

DC2-4.pdf

Week 3 Discussion.docx

Week 2 Discussion.docx

Business Brief 4 .pdf

3 - Data Analysis HW (2).docx

Quiz 9.docx

Business Brief 3 .pdf

Copy of Dissecting the Prompt (Comparison LEQ).docx

Recommended textbooks for you

EBK HEALTH ECONOMICS AND POLICY

Economics

ISBN:9781337668279

Author:Henderson

Publisher:YUZU

Economics (MindTap Course List)

Economics

ISBN:9781337617383

Author:Roger A. Arnold

Publisher:Cengage Learning

Microeconomics

Economics

ISBN:9781337617406

Author:Roger A. Arnold

Publisher:Cengage Learning

Macroeconomics

Economics

ISBN:9781337617390

Author:Roger A. Arnold

Publisher:Cengage Learning

Economics Today and Tomorrow, Student Edition

Economics

ISBN:9780078747663

Author:McGraw-Hill

Publisher:Glencoe/McGraw-Hill School Pub Co

MACROECONOMICS FOR TODAY

Economics

ISBN:9781337613057

Author:Tucker

Publisher:CENGAGE L

SEE MORE TEXTBOOKS

Recommended textbooks for you

EBK HEALTH ECONOMICS AND POLICY
Economics
ISBN:9781337668279
Author:Henderson
Publisher:YUZU
Economics (MindTap Course List)
Economics
ISBN:9781337617383
Author:Roger A. Arnold
Publisher:Cengage Learning
Microeconomics
Economics
ISBN:9781337617406
Author:Roger A. Arnold
Publisher:Cengage Learning
Macroeconomics
Economics
ISBN:9781337617390
Author:Roger A. Arnold
Publisher:Cengage Learning
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L