Last One - Wvinyl Only

completed-excel_global_river_conservancy.xls

Home >Computer Science homework help >Last One - Wvinyl Only

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	$4.21		-11%
$21-$40K	25.37%	$91	$23.09		22.5%
$41-$70K	58.00%	$152	$88.16		66%
$71-$100K	65.10%	$168	$109.37		77%
Over $100K	55.14%	$177	$97.60		70%
Estimates of Households: By Income Level			$322.42
Income
Level:	1990	1995	2000	2005	2010
$0-$20K	1,181,684	1,033,429	885,174	787,805	701,146
$21-$40K	544,895	671,640	798,355	977,985	1,198,031
$41-$70K	103,037	352,105	601,173	997,947	1,656,592
$71-$100K	25,766	109,787	193,828	343,076	607,244
Over $100K	17,172	57,735	98,297	167,105	284,078
Total	1,872,554	2,224,696	2,576,827	3,273,917	4,447,092
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	$4,977,253.01	$4,352,802.95	$3,728,352.89	$3,318,234.07	$2,953,228.32
$21-$40K	$12,579,827.40	$15,505,951.19	$18,431,382.38	$22,578,443.41	$27,658,593.18
$41-$70K	$9,083,741.92	$31,041,576.80	$52,999,411.68	$87,979,023.39	$146,045,178.83
$71-$100K	$2,817,975.89	$12,007,184.62	$21,198,580.70	$37,521,487.85	$66,413,033.49
Over $100K	$1,675,949.42	$5,634,760.18	$9,593,570.95	$16,309,070.61	$27,725,420.04
Total	$31,134,747.63	$68,542,275.74	$105,951,298.60	$167,706,259.33	$270,795,453.85
Percentage Environmental Contributions By Income Level
Income
Level:	1990	1995	2000	2005	2010
$0-$20K	16%	6%	4%	2%	1%
$21-$40K	40%	23%	17%	13%	10%
$41-$70K	29%	45%	50%	52%	54%
$71-$100K	9%	18%	20%	22%	25%
Over $100K	5%	8%	9%	10%	10%

PART B - Budget Analysis


	Global River Conservancy
	Survey Budget Analysis
Basic Information:
Standard Deviation:		$38	Wage Rate:	$17.50	/hr
Z(alpha = 0.01):	2.33		Office Rent:	$220	/day
Tolerance: +/-	$3.25		Phone Rental:	$30	/day
Average time per call:9		minutes	Days for Survey:	5
Calling Shift:	8	hrs	Training Costs:	$23	/person
Sample size calculations
based on above estimates :		n =	742.19
Call calculations:
	Number of	Percent of	Regional	Regional	Number of
Region	Households	Total	Sample size	Response Rate	Calls
A	156315	26%	192.89	0.35	551.11
B	84253	14%	103.97	0.31	335.38
C	101999	17%	125.87	0.32	393.33
D	132564	22%	163.58	0.26	629.16
E	126324	21%	155.88	0.33	472.37
Totals:	601455	1	742	2	2381
Budget Calculations:
	Cost per	Regional	Call Time by
Region	Call	Call Costs	Region (hrs)
A	$1.05	$578.67	82.67
B	$1.34	$449.40	50.31
C	$1.42	$558.53	59.00
D	$1.44	$905.99	94.37
E	$1.37	$647.14	70.86
Totals:	$6.62	$3,139.74	$357.20
		Shifts Required:	45
		Employees/Phones Required:	9
Expenses:
	Wages:	$6,251.04
	Training:	$205
	Calls:	$3,139.74
	Phone Rent:	$150
	Office Rent:	$1,100
	Misc. Supplies	$1,750
	Total Expenses:	$12,596.17

PART B - Budget Analysis

Cost per

Regional

Call Time by

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	0.08	0.08
$1	to	$50	139	0.25	0.33
$51	to	$100	253	0.45	0.78
$101	to	$500	96	0.17	0.95
More Than		$500	28	0.05	1.00
		Total Radio Responses =	559
		Median Donation for Radio =			Percent of Total Sample =
* Frequency Distribution for Newspaper Responses *
					Cumulative
			Newspaper¥	Frequency	Frequency
$0			62	0.08	0.08
$1	to	$50	165	0.22	0.31
$51	to	$100	338	0.46	0.77
$101	to	$500	127	0.17	0.94
More Than		$500	46	0.06	1.00
		Total Newspaper Responses =	738
		Median Donation for Newspaper =			Percent of Total Sample =
* Frequency Distribution for Cable TV Responses *
					Cumulative
			Cable TV¥	Frequency	Frequency
$0			62	0.08	0.08
$1	to	$50	171	0.23	0.31
$51	to	$100	344	0.46	0.78
$101	to	$500	117	0.16	0.94
More Than		$500	47	0.06	1.00
		Total Cable TV responses =	741
		Median Donation for Cable TV =			Percent of Total Sample =
* Frequency Distribution for Direct Mail Responses *
			Direct		Cumulative
			Mail¥	Frequency	Frequency
$0			71	0.09	0.09
$1	to	$50	186	0.24	0.32
$51	to	$100	362	0.46	0.78
$101	to	$500	127	0.16	0.94
More Than		$500	45	0.06	1.00
		Total Direct Mail Responses =	791
		Median Donation for Direct Mail =			Percent of Total Sample =
* Frequency Distribution for Telemarketing Responses *
			Tele-		Cumulative
			Marketing¥	Frequency	Frequency
$0			89	0.12	0.12
$1	to	$50	193	0.25	0.37
$51	to	$100	348	0.45	0.82
$101	to	$500	102	0.13	0.95
More Than		$500	38	0.05	1.00
		Total Telemarketing Responses =	770
		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.