B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|
1 | ACUI - Regional Budget - FY13 Summary Page | ||||||||
2 | This page combines all budget proposals for the region. Any updates to regional programs will automatically roll-up in to the summary on this page. Please do not change or alter text or expense categories on this page. Any changes or updates should be made to the olive green cells on the original program/event or budget tab. If you have questions, please contact your RD. | ||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
8 | |||||||||
9 | |||||||||
18 | |||||||||
19 | Summary of Profit/Loss: | ||||||||
20 | This worksheet will calculate the profit/loss for all events in the region. | Acct Code | Totals | Budgeted | Actual | ||||
21 | N/A | Total income | $71,160.00 | $83,665.00 | |||||
22 | N/A | Total expenses | $77,723.25 | $15,378.11 | |||||
23 | Total profit (or loss) | ($6,563.25) | $68,286.89 | ||||||
24 | |||||||||
25 | |||||||||
26 | |||||||||
27 | |||||||||
28 | Expenses: | ||||||||
29 | Acct Code | Occupancy & Facility Expenses - Site or Location Fees | Budgeted | Actual | |||||
30 | 6510 | Room and hall rental fees | $800.00 | $0.00 | |||||
31 | 6520 | Site staff | $0.00 | $0.00 | |||||
32 | 7000 | Equipment Rental or Purchase | $0.00 | $0.00 | |||||
33 | 6520 | Other - Occupancy/Facility Expense | $0.00 | $0.00 | |||||
34 | Totals | $800.00 | $0.00 | ||||||
35 | |||||||||
36 | Acct Code | Meals, Refreshment and Travel Expenses | Budgeted | Actual | |||||
37 | 7510 | Program Related Meals/Food/Beverage | $31,440.00 | $127.50 | |||||
38 | 8520 | Travel Related Meals/Food/Beverage | $2,500.00 | $1,741.99 | |||||
39 | 8510 | Travel Lodging | $13,083.25 | $2,102.00 | |||||
40 | 8500 | Travel Related Transportation | $4,500.00 | $4,364.22 | |||||
41 | 9000 | Misc Expense: | $0.00 | $0.00 | |||||
42 | Totals | $51,523.25 | $8,335.71 | ||||||
43 | |||||||||
44 | Acct Code | Publicity and Advertising | Budgeted | Actual | |||||
45 | 7700 | Printing and Photocopying | $1,250.00 | $539.00 | |||||
46 | 8000 | Postage or Shipping | $750.00 | $436.22 | |||||
47 | 8100 | Phone or long distance charges | $0.00 | $0.00 | |||||
48 | 9000 | Ads (newspaper, web, magazine, etc) | $0.00 | $0.00 | |||||
49 | 7400 | Stationary or Supplies | $0.00 | $115.48 | |||||
50 | 9000 | Miscellaneous Publicity/Marketing Expense | $0.00 | $0.00 | |||||
51 | Totals | $2,000.00 | $1,090.70 | ||||||
52 | |||||||||
53 | Acct Code | Supplies, Program Materials | Budgeted | Actual | |||||
54 | 7400 | Office Supplies or Materials | $0.00 | $0.00 | |||||
55 | 7410 | Party Supplies/Balloons/Materials | $100.00 | $0.00 | |||||
56 | 7410 | Misc Program Materials | $500.00 | $37.40 | |||||
57 | Totals | $600.00 | $37.40 | ||||||
58 | |||||||||
59 | Acct Code | Programming Expenses | Budgeted | Actual | |||||
60 | 7520 | Program Enterntainment/Peformers | $3,500.00 | $800.00 | |||||
61 | 7500 | Speaker Fees/Honorariums | $6,400.00 | $2,800.00 | |||||
62 | 8450 | Contract and Services Fees | $0.00 | $0.00 | |||||
63 | 7000 | Lighting/Sound Equipment Rental | $0.00 | $0.00 | |||||
64 | 7010 | General Equipment Rental | $0.00 | $0.00 | |||||
65 | 9000 | Misc Program Expense | $800.00 | $0.00 | |||||
66 | Totals | $10,700.00 | $3,600.00 | ||||||
67 | |||||||||
68 | Acct Code | Prizes, Gifts, Awards and Recognitions | Budgeted | Actual | |||||
69 | 7610 | Awards or Recognitions | $4,325.00 | $1,953.60 | |||||
70 | 9200 | Scholarship Expense | $500.00 | $125.00 | |||||
71 | 7600 | Gifts | $400.00 | $160.70 | |||||
72 | 9000 | Misc Awards Expense | $0.00 | $0.00 | |||||
73 | Totals | $5,225.00 | $2,239.30 | ||||||
74 | |||||||||
75 | Acct Code | Miscellaneous Expenses | Budgeted | Actual | |||||
76 | 9400 | Credit Card Transaction Fees (3% of all cc transactions) | $3,000.00 | $0.00 | |||||
77 | 9000 | Miscellaneous Expense | $3,875.00 | $75.00 | |||||
78 | 9000 | Miscellaneous Expense | $0.00 | $0.00 | |||||
79 | Totals | $6,875.00 | $75.00 | ||||||
80 | |||||||||
81 | Total Expenses | $77,723.25 | $15,378.11 | ||||||
82 | |||||||||
83 | INCOME AND REVENUE | ||||||||
84 | Acct Code | Registration Fees | |||||||
85 | 5100 | Budgeted | Actual | ||||||
86 | $31,710.00 | $34,220.00 | |||||||
87 | $4,680.00 | $4,125.00 | |||||||
88 | $2,650.00 | $3,320.00 | |||||||
89 | $39,040.00 | $41,665.00 | |||||||
90 | |||||||||
91 | Acct Code | Corporate Sponsorships | |||||||
92 | 5300 | Budgeted | Actual | ||||||
93 | $1,000.00 | $2,000.00 | |||||||
94 | $0.00 | $0.00 | |||||||
95 | $0.00 | $0.00 | |||||||
96 | $1,000.00 | $2,000.00 | |||||||
97 | |||||||||
98 | Acct Code | Scholarship Contributions | |||||||
99 | 5350 | Budgeted | Actual | ||||||
100 | $5,000.00 | $0.00 | |||||||
101 | $0.00 | $0.00 | |||||||
102 | $0.00 | $0.00 | |||||||
103 | $5,000.00 | $0.00 | |||||||
104 | |||||||||
105 | Acct Code | Other Income | |||||||
106 | 5900 | Budgeted | Actual | ||||||
107 | $7,800.00 | $16,900.00 | |||||||
108 | $18,150.00 | $23,100.00 |