| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | 2023/24 Budgeted | 2023/24 Actuals | ||||||
2 | Revenue | Expense | Total | Revenue | Expense | Total | Notes | |
3 | Student Fee Revenue | |||||||
4 | 1st Installment - October 2023 | $ 250,000.00 | $ 250,000.00 | $ - | ||||
5 | 2nd Installment - January 2024 | $ 30,159.85 | $ 30,159.85 | $ - | ||||
6 | 3rd Installment - April 2024 | $ 569.75 | $ - | $ - | ||||
7 | $ 280,729.60 | $ 280,159.85 | 5350 expected students * $48.39 student fees | |||||
8 | Student Fee Obligations | |||||||
9 | Engineering Design Team Council Fee | $ (10,966.00) | $ - | $ - | 5350 expected students * $2 donation | |||
10 | Carryover from EDTC 21/22 | $ 3,512.72 | $ (3,512.72) | $ 3,512.72 | $ (1,036.53) | EDTF HV Supply for Formula Electric + General Carryover | ||
11 | Carryover from EDTC 22/23 | $ 10,654.00 | $ (10,654.00) | $ 10,654.00 | $ (11,657.15) | Need to pay EDTC 22/23 | ||
12 | $ (10,966.00) | $ 1,473.04 | ||||||
13 | Club Funding | 4300 expected upper year students | ||||||
14 | First Year Budget | $ (6,000.00) | $ - | $ (7,298.09) | Increased FYC Budget | |||
15 | Tier 1 Base Funding | $ (26,388.00) | $ - | $ (26,388.00) | $6 per student in each department | |||
16 | Tier 1 Performance Funding | $ (18,691.50) | $ - | $ (18,188.04) | $4.25 per student into pool, distributed evenly to 12 departments | |||
17 | Tier 2 Base Funding | $ - | $ - | $ - | $3 per student in each department - no T2 clubs 22/23 | |||
18 | Tier 2 Performance Funding | $ - | $ - | $ - | $2.85 per student into pool - no T2 clubs 22/23 | |||
19 | Event Funding | $ (15,393.00) | $ - | $ (11,157.64) | $3.50 per student into pool, distributed evenly to 12 departments | |||
20 | Event Funding Carryover | $ 21,169.38 | $ (21,169.38) | $ - | $ - | Event Funding locked with certain departments from previous year | ||
21 | Club Support Fund | $ 4,000.00 | $ (4,000.00) | $ - | $ (120.00) | Recommend moving away from club benefit fund | ||
22 | Ex-Officio Initiatives Fund | $ (1,800.00) | $ - | $ (474.80) | Minimum $200 per club, up to $400 per club (currently 9 Ex-Officios) | |||
23 | $ (68,272.50) | $ (63,626.57) | ||||||
24 | Executives | |||||||
25 | President | $ - | $ (30,855.86) | $ (30,855.86) | $ 86.10 | $ (28,872.39) | $ (28,786.29) | |
26 | VP Academic | $ - | $ (8,096.90) | $ (8,096.90) | $ 705.60 | $ (6,298.39) | $ (5,592.79) | |
27 | VP Administration | $ - | $ (1,500.00) | $ (1,500.00) | $ - | $ (1,219.25) | $ (1,219.25) | |
28 | VP Communications | $ 5,657.50 | $ (45,104.78) | $ (39,447.28) | $ 6,555.00 | $ (45,346.06) | $ (38,791.06) | |
29 | VP External | $ 6,500.00 | $ (3,700.00) | $ 2,800.00 | $ 3,500.00 | $ (2,260.01) | $ 1,239.99 | |
30 | VP Finance | $ 99,700.00 | $ (40,708.19) | $ 58,991.81 | $ 95,670.57 | $ (36,972.12) | $ 58,698.45 | |
31 | VP Spirit | $ 28,557.71 | $ (122,049.71) | $ (93,492.00) | $ 32,001.61 | $ (106,295.48) | $ (74,293.87) | |
32 | VP Student Life | $ 19,370.27 | $ (34,087.80) | $ (14,717.53) | $ 26,226.04 | $ (34,545.00) | $ (8,318.96) | |
33 | $ (126,317.76) | $ (97,063.78) | ||||||
34 | Conferences | |||||||
35 | CFES Western Engineering Competition | $ (6,041.21) | $ - | $ (6,044.07) | 10 Representatives to Winnipeg | |||
36 | CFES Canadian Engineering Competition | $ - | $ - | $ - | 6 Representatives to Calgary | |||
37 | CFES Presidents' Meeting | $ (750.06) | $ - | $ (752.06) | 2 Representatives to Ottawa, $250 delegate fee, 50%PAF | |||
38 | CFES CDE | $ - | $ (4,713.11) | $ - | $ (3,468.13) | 4 Representatives to Waterloo, 50% PAF, $250 delegate fee, $100 per delegate | ||
39 | CFES CELC | $ - | $ (6,619.45) | $ - | $ (5,569.36) | 3 Representatives to St Johns, 50% PAF, $250 delegate fee, $150 per non-representative delegate | ||
40 | CFES CSE | $ - | $ - | $ - | $ - | 4 Representatives to Toronto, 50% PAF, $250 delegate fee, $100 per delegate | ||
41 | EGBC AGM | $ (302.61) | $ - | $ (302.61) | 2021/2022 value (held in Whistler this year) | |||
42 | WESST EM | $ (3,397.55) | $ - | $ (3,052.70) | 8 execs to Saskatoon, $350 delegate fee | |||
43 | WESST AGMR | $ - | $ (3,153.64) | $ - | $ (3,837.20) | 6 representatives to London, $350 delegate fee, $100 per non-representative delegate | ||
44 | Conferences Patches | $ (100.00) | $ - | $ - | ||||
45 | $ (25,077.63) | $ (23,026.13) | ||||||
46 | ESC | |||||||
47 | ESC Capital Purchases Fund | $ (5,000.00) | $ - | $ - | Value in policy | |||
48 | ESC Capital Purchases | $ (44,594.48) | $ - | $ (6,643.17) | Upstairs nook + furnitures + fridges + Pool Refelt + Upstairs study area (more tables/chairs) + garden patio furniture + interior wall decor (photo frames/printing of photos)+ Carpet Cleaning | |||
49 | ESC Maintenance | $ - | $ (12,034.90) | $ - | $ (1,808.06) | Currently has all other ESC budget lines in it (Maintenance, bookings software, cleaning supplies, new signs, bar, new paint coat, carpet cleaning) | ||
50 | ESC Post-Event Janitorial | $ (1,234.00) | $ - | $ (1,114.81) | Budgeted for 4 hours of ESC cleaning for each program club, used to keep ESC clean after club events + 650 for post EUS event cleaning (octoberfEUSt, Red Knight, Caroling) | |||
51 | ESC Rental Revenue | $ 2,490.00 | $ 2,260.00 | $ - | Based on past data | |||
52 | ESC Equipment Revenue | $ 50.00 | $ - | $ - | ||||
53 | $ (60,323.38) | |||||||
54 | Board Expenses | |||||||
55 | Council Gift Fund | $ 2,600.00 | $ (4,175.00) | $ 2,600.00 | $ (4,175.00) | $45 for 35 council members + 22/23 Gift Carryover ($2600) | ||
56 | Council Meeting Food | $ (4,620.00) | $ - | $ (4,652.38) | 35 people, $12 per head, 5 councils per term + 1 summer council | |||
57 | Video Conferencing | $ (400.00) | $ - | $ (122.45) | ||||
58 | Council Social | $ (1,500.00) | $ - | $ (1,247.65) | $250 per term | |||
59 | Council Placards | $ - | $ - | $ - | One-time purchase | |||
60 | ACT Food | $ (2,400.00) | $ - | $ (1,318.25) | In person | |||
61 | $ (10,495.00) | $ (8,915.73) | ||||||
62 | Affiliations | |||||||
63 | CFES Dues | $ (4,145.70) | $ - | $ (4,145.70) | 5350 students * $0.65 per student - pay upcoming year fees (2023/24) | |||
64 | $ (4,145.70) | $ (4,145.70) | ||||||
65 | Red Sales | |||||||
66 | Inventory/Sales | $ 50,000.00 | $ (48,364.25) | $ 47,134.53 | $ (58,179.98) | Reduced inventory purchases for this year | ||
67 | Administrative Costs | $ (1,000.00) | $ - | $ (952.14) | Card readers, etc. | |||
68 | Promotions & Advertisements | $ - | $ - | $ - | Coupons, etc. | |||
69 | Square Processing Fee | $ (600.00) | $ - | $ (557.97) | ||||
70 | Capital Expenditure | $ (1,200.00) | $ - | $ (306.45) | For front-facing upgrades, stock room upgrades | |||
71 | $ (1,164.25) | $ (12,862.01) | ||||||
72 | Eatery | |||||||
73 | Licensing | $ (87.50) | $ - | $ (87.50) | Food Safe for 2 people and 8 months of Food Service Permit | |||
74 | Supplies | $ (2,500.00) | $ - | $ (2,283.53) | Cups, Paper Sleeves, etc | |||
75 | Additional Equipment | $ (4,000.00) | $ - | $ (760.31) | Major appliance upgrades | |||
76 | Promotion | $ (106.50) | $ - | $ (106.50) | Signage to raise awareness, prizes, sales | |||
77 | Square Processing Fee | $ (1,200.00) | $ - | $ (1,331.64) | Increased from $600 from 2019 recommendation | |||
78 | Eatery Volunteer Food Benefits | $ (3,200.00) | $ - | $ (3,096.25) | Was tracked in food revenue 2018/19. Ended up being $2000 | |||
79 | Food and Drink | $ 53,000.00 | $ (45,000.00) | $ 62,767.84 | $ (57,835.39) | 2018/19 actuals rounded. Can adjust food prices to break even | ||
80 | $ (3,094.00) | $ (2,733.28) | ||||||
81 | Subsidies | |||||||
82 | Discounted Reds | $ (7,150.00) | $ - | $ (6,890.00) | Makes 110 Reds cost $110 instead of $175 | |||
83 | Earned Patches | $ (3,000.00) | $ - | $ (2,633.06) | Moved to make prices of merchandise more afforadable | |||
84 | Eatery Sandwich Subsidy | $ 5,000.00 | $ (9,000.00) | $ - | $ (11,710.00) | Subsidizes ~1600 sandwiches cost $5 | ||
85 | $ (14,150.00) | $ (21,233.06) | ||||||
86 | Miscellaneous | |||||||
87 | Donation from Evangelos | $ 500.00 | $ - | $ - | ||||
88 | $ 500.00 | $ - | ||||||
89 | Contingency (as approved by VP Finance) | |||||||
90 | Contingency | $ (11,000.00) | $ - | $ (11,000.00) | $7k + $4k allocated for potential new fund | |||
91 | Surplus In | $ 55,701.54 | $ 55,701.54 | $ - | Distributed elsewhere in budget | |||
92 | Surplus Out | $ (5,376.25) | $ - | $ (1,387.99) | CELC 22/23 fees, Red Knight 23 Liquor, Interfaculty PP Ball | |||
93 | $ 39,325.29 | $ 43,313.55 | ||||||
94 | Carryover | |||||||
95 | AGM and EUS Survey Prizes 2021/22 | $ 3,650.00 | $ (3,650.00) | $ 3,650.00 | $ (3,650.00) | From 2021/22 budget, to be distributed this year | ||
96 | $ - | $ - | ||||||
97 | Totals | |||||||
98 | Budget Net | $ 652,842.72 | $ (656,294.05) | $ (3,451.33) | $ 633,185.40 | $ (549,151.26) | $ 84,034.14 | Plan to run a slight surplus or net-zero budget |