Question: I need a help solving this problem by EXCEL SOLVER! Thank you! 27. The United Charities annual fund-raising drive is scheduled to take place next

I need a help solving this problem by EXCEL SOLVER!

Thank you!

I need a help solving this problem by EXCEL

27. The United Charities annual fund-raising drive is scheduled to take place next week. Donations are collected during the day and night, by telephone, and through personal contact. The average donation resulting from each type of contact is as follows: Phone Day Night $2 3 Personal $4 7 The charity group has enough donated gasoline and cars to make at most 300 personal contacts during one day and night combined. The volunteer minutes required to conduct each type of interview are as follows: Phone (min.) Day Night 6 5 Personal (min.) 15 12 The charity has 20 volunteer hours available each day and 40 volunteer hours available each night. The chairperson of the fund-raising drive wants to know how many different types of con- tacts to schedule in a 24-hour period (i.e., 1 day and 1 night) to maximize total donations. a. Formulate a linear programming model for this problem. b. Solve the model by using the computer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!