Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

25 pts Question 11 The Save the Bay Foundation will be conducting a fund raiser by contacting members (M) and non-members (N) for donations. To

image text in transcribed
image text in transcribed
25 pts Question 11 The "Save the Bay Foundation will be conducting a fund raiser by contacting members (M) and non-members (N) for donations. To determine the best values for M and N, the following LP was formulated and solved in Excel. Excel output is below. MAX 10N + 16M Maximize daily donations st 6N + 4M =0 ... Non-member contact time must be at least 20% of member time NM >= 0 Non-negativity constraints. Objective Cell (Max) Name Max Donations Original Value 0 Final Value 1160 Variable Cells Original Value Name N M Final Value 20 60 0 Constraints Name Relational Time Constraint Volunteer Time Max Contact for Members Cell Value 72 360 Status Not Binding Binding Binding Slack 72 0 60 0 Constraints Final Value 72 360 60 Shadow Price 0 Name Relational Time Constraint Volunteer Time Max Contact for Members Constraint R.H. Side 0 360 60 Allowable Allowable Increase Decrease 72 infinity infinity 72 15 60 1.67 9.33 Constraints Name Relational Time Constraint Volunteer Time Max Contact for Members Final Value 72 360 60 Shadow Price 0 1.67 9.33 Constraint R.H. Side 0 360 60 Allowable Allowable Increase Decrease 72 infinity infinity 72 15 60 How many members (M) should the Foundation contact? How many non-members (N) should the Foundation contact? How many minutes of volunteer time will be used? If 72 members could be contacted daily, how much ADDITIONAL money could be raised? ROUND YOUR ANSWER TO THE NEAREST DOLLAR. ELSE, YOUR ANSWER WILL BE FLAGGED AS INCORRECT. If volunteer time were cut by an hour, how much would donations decrease? ROUND YOUR ANSWER TO THE NEAREST DOLLAR. ELSE, YOUR ANSWER WILL BE FLAGGED AS INCORRECT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction accounting and financial management

Authors: Steven j. Peterson

2nd Edition

135017114, 978-0135017111

More Books

Students also viewed these Accounting questions

Question

Describe the importance of employer branding.

Answered: 1 week ago

Question

Explain corporate sustainability.

Answered: 1 week ago