Additional Excel

global_river_conservancy_-_copy.zip

Home >Information Systems homework help >Additional Excel

globalRiverConservancy.xlsx

Part A - Demographic Analysis

Global River Conservancy
Survey Demographic Analysis - Contributions
Basic Assumptions:
	Percentage of		Contributions
Income	Households	Average	per		Growth
Level:	Contributing:	Contributions:	Household:		Rates:
$0-$20K	8.10%	$52
$21-$40K	25.37%	$91
$41-$70K	58.00%	$152
$71-$100K	65.10%	$168
Over $100K	55.14%	$177
Estimates of Households: By Income Level
Income
Level:	1990	1995	2000	2005	2010
$0-$20K	1181684	1033429	885174
$21-$40K	544895	671640	798355
$41-$70K	103037	352105	601173
$71-$100K	25766	109787	193828
Over $100K	17172	57735	98297
Total
Source: Adapted from U.S. Census Reports 1980,1990,2000
Estimated Environmental Contributions By Income Level
Income
Level:	1990	1995	2000	2005	2010
$0-$20K
$21-$40K
$41-$70K
$71-$100K
Over $100K
Total
Percentage Environmental Contributions By Income Level
Income
Level:	1990	1995	2000	2005	2010
$0-$20K
$21-$40K
$41-$70K
$71-$100K
Over $100K

PART B - Budget Analysis

	Global River Conservancy
	Survey Budget Analysis
Basic Information:
Standard Deviation:			Wage Rate:		/hr
Z(alpha = 0.01):			Office Rent:		/day
Tolerance: +/-			Phone Rental:		/day
Average time per call:		minutes	Days for Survey:
Calling Shift:		hrs	Training Costs:		/person
Sample size calculations
based on above estimates :		n =
Call calculations:
	Number of	Percent of	Regional	Regional	Number of
Region	Households	Total	Sample size	Response Rate	Calls
A	156315			0.35
B	84253			0.31
C	101999			0.32
D	132564			0.26
E	126324			0.33
Totals:
Budget Calculations:
	Cost per	Regional	Call Time by
Region	Call	Call Costs	Region (hrs)
A	$1.05
B	$1.34
C	$1.42
D	$1.44
E	$1.37
Totals:
		Shifts Required:
		Employees/Phones Required:
Expenses:
	Wages:
	Training:
	Calls:
	Phone Rent:
	Office Rent:
	Misc. Supplies
	Total Expenses:

PART C - Survey Analysis

Global River Conservancy
Survey Data Analysis
Total Survey Sample Size:
* Frequency Distribution for Radio Responses *
					Cumulative
			Radio¥	Frequency	Frequency
$0			43
$1	to	$50	139
$51	to	$100	253
$101	to	$500	96
More Than		$500	28
		Total Radio Responses =
		Median Donation for Radio =			Percent of Total Sample =
* Frequency Distribution for Newspaper Responses *
					Cumulative
			Newspaper¥	Frequency	Frequency
$0			62
$1	to	$50	165
$51	to	$100	338
$101	to	$500	127
More Than		$500	46
		Total Newspaper Responses =
		Median Donation for Newspaper =			Percent of Total Sample =
* Frequency Distribution for Cable TV Responses *
					Cumulative
			Cable TV¥	Frequency	Frequency
$0			62
$1	to	$50	171
$51	to	$100	344
$101	to	$500	117
More Than		$500	47
		Total Cable TV responses =
		Median Donation for Cable TV =			Percent of Total Sample =
* Frequency Distribution for Direct Mail Responses *
			Direct		Cumulative
			Mail¥	Frequency	Frequency
$0			71
$1	to	$50	186
$51	to	$100	362
$101	to	$500	127
More Than		$500	45
		Total Direct Mail Responses =
		Median Donation for Direct Mail =			Percent of Total Sample =
* Frequency Distribution for Telemarketing Responses *
			Tele-		Cumulative
			Marketing¥	Frequency	Frequency
$0			89
$1	to	$50	193
$51	to	$100	348
$101	to	$500	102
More Than		$500	38
		Total Telemarketing Responses =
		Median Donation for Telemarketing =			Percent of Total Sample =
* Expected Proceeds Calculations *
Target Households =			601172
	Cost per	Median	Households	Gross	Expected	Net
	1000	Donation	Reached	Proceeds	Cost	Proceeds
Radio	$6.79
Newspaper	$7.65
Cable TV	$7.38
Direct Mail	$4.50
Telemarketing	$4.75
¥ Individual media for which responses to the donation question
have been tabulated for each frequency distribution.