Project 10 - A Second EXCEL Workbook

profileAyse13579
go2007_intro1e_pcpt_c_exl_10_solution.pdf

Taste of Golden Grove

Pot-o-Golden Grove

Golden Mile 5K Run

Total

Quarter 1 176,404.00$        675,352.00$       1,135,301.00$    1,987,057.00$     Quarter 2 156,722.00$        735,748.00$       939,413.00$       1,831,883.00$     Quarter 3 127,855.00$        808,570.00$       905,960.00$       1,842,385.00$     Quarter 4 119,768.00$        786,201.00$       853,888.00$       1,759,857.00$     Total 580,749.00$        3,005,871.00$    3,834,562.00$    7,421,182.00$    

Golden Grove 2007 Population 450,000              Projected 2010 Population 645,000              Percentage Increase 30%

10%

Taste of Golden Grove

Pot-o-Golden Grove

Golden Mile 5K Run

Total

Quarter 1 194,044.40$        742,887.20$       1,248,831.10$    2,185,762.70$     Quarter 2 172,394.20          809,322.80        1,033,354.30     2,015,071.30       Quarter 3 140,640.50          889,427.00        996,556.00        2,026,623.50       Quarter 4 131,744.80          864,821.10        939,276.80        1,935,842.70       Total 638,823.90$        3,306,458.10$    4,218,018.20$    8,163,300.20$    

8%

Taste of Golden Grove

Pot-o-Golden Grove

Golden Mile 5K Run

Total

Quarter 1 190,516.32$        729,380.16$       1,226,125.08$    2,146,021.56$     Quarter 2 169,259.76          794,607.84        1,014,566.04     1,978,433.64       Quarter 3 138,083.40          873,255.60        978,436.80        1,989,775.80       Quarter 4 129,349.44          849,097.08        922,199.04        1,900,645.56       Total 627,208.92$        3,246,340.68$    4,141,326.96$    8,014,876.56$    

Golden Grove  Charity Fundraising 

12/31/07

Projected giving increase

Golden Grove  Charity Fundraising 

Projected

Golden Grove  Charity Fundraising 

Projected

Projected giving increase

10_PCPT_Firstname_Lastname 12/20/2006

Elise
Text Box
Absolute reference cell C20
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight
holly
Highlight

holly
Text Box
10_PCPT_Firstname_Lastname
holly
Text Box
12/20/2006

holly
Text Box
10_PCPT_Firstname_Lastname
holly
Text Box
12/20/2006
holly
Text Box
Date entered and formatted
holly
Text Box
Formula created in D6 and copied from D7 to D9
holly
Line
holly
Line
holly
Text Box
Function used in B10 and copied to C10 and D10
holly
Line
holly
Line
holly
Line
holly
Text Box
Comma Style: B7:B9 Accounting Number Format: B6:D6 and B10:D10

holly
Text Box
10_PCPT_Firstname_Lastname
holly
Text Box
12/20/2006
holly
Text Box
B5:D5 pasted from Taste of Golden Grove sheet
holly
Text Box
Formula created in D6 and copied from D7 to D9
holly
Line
holly
Line
holly
Text Box
Function used in B10 and copied to C10 and D10
holly
Line
holly
Line
holly
Line
holly
Text Box
Comma Style: B7:B9 Accounting Number Format: B6:D6 and B10:D10

holly
Text Box
10_PCPT_Firstname_Lastname
holly
Text Box
12/20/2006
holly
Text Box
B5:D5 pasted from Taste of Golden Grove sheet
holly
Text Box
Formula created in D6 and copied from D7 to D9
holly
Line
holly
Line
holly
Text Box
Function used in B10 and copied to C10 and D10
holly
Line
holly
Line
holly
Line
holly
Text Box
Comma Style: B7:B9 Accounting Number Format: B6:D6 and B10:D10