Spreadsheet: 219906d1363010239-autopopulate-formula-from-two-columns-of-data-copy3-of-amc-2013-budget-2-
Sheet: Budget

Description | Budgeted | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Actual Totals | Percent
Projected Membership | 220 |  | 67 | 38 |  |  |  |  |  |  |  |  |  | 105 | 0.4772727272727273
Junior Membership | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Projected Income
Member dues (220) | 15400 |  | 4690 | 2660 |  |  |  |  |  |  |  |  |  | 7350 | 0.4772727272727273
Junior member dues | 70 | 100 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Dividend income | 560 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Member - Guest Tournament
Entry Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Sponsors |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Miscellaneous Income |  | 25 |  |  |  |  |  |  |  |  |  |  |  | 25
Carryover | 434 |  |  |  |  |  |  |  |  |  |  |  |  | 434 | 1
 |  | 125 | 4690 | 2660 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Income | 16464 | 125 | 4690 | 2660 |  |  |  |  |  |  |  |  |  | 7809 | 0.4743075801749271
Projected Expenses
Admin supplies | 100 |  | 44 |  |  |  |  |  |  |  |  |  |  | 44 | 0.44
Web site expenses | 250 |  |  | 224.2 |  |  |  |  |  |  |  |  |  | 224.2 | 0.8967999999999999
Miscellaneous expenses | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
WSGA/GHIN expenses | 6160 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Reimbursement |  | 180 |  |  |  |  |  |  |  |  |  |  |  | 180
Payments to individuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Dues/Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tacoma Golf Assn | 200 | 75 |  |  |  |  |  |  |  |  |  |  |  | 75 | 0.375
Donations | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Golf Expenses
Annual pass to Allenmore | 2800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Member golf tournaments | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Awards | 250 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Raffle | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Banquets and Party expenses
Horse Race | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Christmas Party | 2500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Tournaments added money
Spring Shamble | 150 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
The 1, 2, 3 | 150 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Fite / Hendry | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
The Memorial | 150 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Member / Guest | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Club Championship | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
[NAME] | 150 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Shake Em Up | 150 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Senior Club Championship | 250 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Member / Guest Tournament
Green Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tee Prizes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Banquet |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 255 | 44 | 224.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expenses | 15860 | 255 | 44 | 224.2 |  |  |  |  |  |  |  |  |  | 523.2 | 0.03298865069356873
Account Balance: | 7285.8 | #N/A
Contingency Account | 604 |  |  |  |  |  |  |  |  |  |  |  |  | 604
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Description | Budgeted | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Actual Totals | Percent