| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Budgets | |||||||||||||||||||||||||
2 | Advocacy Group: SSD | |||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | May | June | July | August | September | October | November | December | January | February | March | April | Total | Notes | ||||||||||||
5 | Revenue | |||||||||||||||||||||||||
6 | 5000 | 425 | Student Fees | $ - | $ - | $ 17,500.00 | $ - | $ - | $ 60,500.00 | $ - | $ - | $ - | $ 38,000.00 | $ - | $ - | $ 116,000.00 | Dedicated Student Fees | Based on 2022/23 with no large changes | ||||||||
7 | 5008 | 425 | Advocacy Revenue | $ - | $ - | $ - | $ 2,000.00 | $ - | $ - | $ - | $ 6,500.00 | $ - | $ - | $ - | $ 4,000.00 | $ 12,500.00 | ||||||||||
8 | 5320 | 425 | Miscellaneous Revenue | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Event revenue, Donations, Plot fees, etc | |||||||||
9 | Trust Fund Transfer | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||||||||||
10 | Total Revenue | $ - | $ - | $ 17,500.00 | $ 2,000.00 | $ - | $ 60,500.00 | $ - | $ 6,500.00 | $ - | $ 38,000.00 | $ - | $ 4,000.00 | $ 128,500.00 | 0 | Balancing Tool (s/b zero) | ||||||||||
11 | ||||||||||||||||||||||||||
12 | ||||||||||||||||||||||||||
13 | Cost of Labour | |||||||||||||||||||||||||
14 | 6520 | 425 | Wages | $ 9,449.55 | $ 9,038.70 | $ 8,627.85 | $ 9,449.55 | $ 8,627.85 | $ 9,038.70 | $ 9,038.70 | $ 8,627.85 | $ 9,449.55 | $ 8,800.41 | $ 8,800.41 | $ 9,219.47 | $ 108,168.59 | see chart below | |||||||||
15 | 6530 | 425 | Canada Pension Plan | 544.89 | 520.45 | 496.00 | 544.89 | 496.00 | 520.45 | 520.45 | 496.00 | 544.89 | 506.27 | 506.27 | 531.20 | $ 6,227.78 | ||||||||||
16 | 6540 | 425 | Employment Insurance | 264.59 | 253.08 | 241.58 | 264.59 | 241.58 | 253.08 | 253.08 | 241.58 | 264.59 | 246.41 | 246.41 | 258.15 | $ 3,028.72 | ||||||||||
17 | 6550 | 425 | Insurance (SunLife & BBD) | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 9.93 | $ 119.16 | ||||||||||
18 | 6555 | 425 | Employer Health Tax (1.5%) | 141.74 | 135.58 | 129.42 | 141.74 | 129.42 | 135.58 | 135.58 | 129.42 | 141.74 | 132.01 | 132.01 | 138.29 | $ 1,622.53 | ||||||||||
19 | 6570 | 425 | Workers Compensation | 19.84 | 18.98 | 18.12 | 19.84 | 18.12 | 18.98 | 18.98 | 18.12 | 19.84 | 18.48 | 18.48 | 19.36 | $ 227.15 | ||||||||||
20 | 6620 | 425 | Staff Training | $ 300.00 | $ 300.00 | $ 300.00 | $ 900.00 | Collective agreement - Each term staff member is eligible for $600 over two fiscal years. | ||||||||||||||||||
21 | 6650 | 425 | Staff Discounts | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 1,080.00 | Based on January and February 2023 actuals | |||||||||
22 | Total Labour | $ 10,820.55 | $ 10,066.72 | $ 9,612.90 | $ 10,520.55 | $ 9,912.90 | $ 10,066.72 | $ 10,066.72 | $ 9,612.90 | $ 10,820.55 | $ 9,803.51 | $ 9,803.51 | $ 10,266.41 | $ 121,373.93 | 0.00 | Balancing Tool (s/b zero) | ||||||||||
23 | ||||||||||||||||||||||||||
24 | 7010 | 425 | Building Maintenance | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
25 | 7020 | 425 | Equipment Purchase | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
26 | 7040 | 425 | Equipment Repair/Maintenance | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
27 | 7065 | 425 | Events | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 6,000.00 | ||||||||||
28 | 7075 | 425 | Funding Requests | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 60,000.00 | |||||||||||||||||||
29 | 7085 | 425 | Rental | $ - | ||||||||||||||||||||||
30 | 7115 | 425 | Programs | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 60,000.00 | |||||||||||||||||||
31 | 7205 | 425 | Professional/Consulting Fees | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 6,000.00 | ||||||||||
32 | 7215 | 425 | Honorariums | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 4,200.00 | ||||||||||
33 | 7230 | 425 | Membership/Subscription Fees | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | |||||||||||
34 | 7260 | 425 | Bursaries | $ 3,000.00 | $ 6,000.00 | $ 6,000.00 | $ 15,000.00 | |||||||||||||||||||
35 | 7310 | 425 | Advertising | $ 300.00 | $ 300.00 | $ 300.00 | $ 1,300.00 | $ 1,300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 5,600.00 | ||||||||||
36 | 7320 | 425 | Computer Supplies | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
37 | 7325 | 425 | IT services | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 1,200.00 | ||||||||||
38 | 7340 | 425 | Office Supplies | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
39 | 7360 | 425 | Postage | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
40 | 7390 | 425 | Telephone/Fax | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 84.00 | ||||||||||
41 | 7430 | 425 | Other Sundry Items | $ 1,050.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 750.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 750.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 3,000.00 | ||||||||||
42 | 7510 | 425 | Conferences | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
43 | 7515 | 425 | Donations | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 1,200.00 | ||||||||||
44 | 7520 | 425 | General Travel | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
45 | 7530 | 425 | Special Occasions | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 900.00 | ||||||||||
46 | 7570 | 425 | Meetings | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | ||||||||||
47 | 7610 | 425 | Zap internal charges | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 600.00 | 169784 | |||||||||
48 | Total Expenses | $ 46,532.00 | $ 2,532.00 | $ 2,532.00 | $ 3,532.00 | $ 50,232.00 | $ 2,532.00 | $ 2,532.00 | $ 2,532.00 | $ 49,232.00 | $ 2,532.00 | $ 2,532.00 | $ 2,532.00 | $ 169,184.00 | ||||||||||||
49 | 600 | Balancing Tool (s/b zero) | ||||||||||||||||||||||||
50 | Total | -$ 57,352.55 | -$ 12,598.72 | $ 5,355.10 | -$ 12,052.55 | -$ 60,144.90 | $ 47,901.28 | -$ 12,598.72 | -$ 5,644.90 | -$ 60,052.55 | $ 25,664.49 | -$ 12,335.51 | -$ 8,798.41 | -$ 162,057.93 | ||||||||||||
51 | ||||||||||||||||||||||||||
52 | Trust Balance at start of year | |||||||||||||||||||||||||
53 | 2021 | $ 255,403 | ||||||||||||||||||||||||
54 | 2022 | $ 268,996 | ||||||||||||||||||||||||
55 | 2023 | $ 238,454 | This is a guess | |||||||||||||||||||||||
56 | Projected end of fiscal | $ 76,396.38 | ||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | # of positions | Hrs/week | Rate bf Feb | Rate after Feb | ||||||||||||||||||||||
62 | Coordinators | 3 | 25 | $ 27.39 | $ 27.94 | Note: As the new union contract is not finalized I have | Act Rev to Feb | 127,658.31 | ||||||||||||||||||
63 | Student staff | $ 17.86 | $ 18.22 | estimated a 2% increase. This is a guess. | Est remaining | 9,800.00 | ||||||||||||||||||||
64 | 137,458.31 | |||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | Explanation of Expenses | |||||||||||||||||||||||||
67 | Please provide a brief description of the above expenses starting with building maintenance. | Act Exp to Feb | 143,000.00 | |||||||||||||||||||||||
68 | For example, if you have put a large amount into a specific account, please state what it is for. "Sept amount of $____ is for ____ (event/program/new computer etc) | Est remaining | 25,000.00 | |||||||||||||||||||||||
69 | If you have a standard amount based on a prior year please just state that. "we have entered $___ each month to reflect prior year spending" | 168,000.00 | ||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | Please enter the explanation below | Decrease to trust | (30,541.69) | |||||||||||||||||||||||
72 | 7010 | Building Maintenance | We only spent about $25 on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
73 | 7020 | Equipment Purchase | We didn't spend any on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
74 | 7040 | Equipment Repair/Maintenance | We didn't spend any on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
75 | 7065 | Events | Same as last year - decided in consult with staff | |||||||||||||||||||||||
76 | 7075 | Funding Requests | Same as previous years | |||||||||||||||||||||||
77 | 7115 | Programs | $15,000 per semester for food security and $5,000 for other programming such as games night, strolls, book club etc. | |||||||||||||||||||||||
78 | 7205 | Professional/Consulting Fees | $5,000 per semester for translation as per constitution and $1,000 for other possible fees | |||||||||||||||||||||||
79 | 7215 | Honorariums | We spent about $4025 here last year, so set aside a similar amount | |||||||||||||||||||||||
80 | 7230 | Membership/Subscription Fees | We didn't spend any on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
81 | 7260 | Bursaries | Put aside usual $15,000 a year for CAL-SSD LAP bursary | |||||||||||||||||||||||
82 | 7310 | Advertising | Same monthly budget as last year with extra in August/September for SWAG | |||||||||||||||||||||||
83 | 7320 | Computer Supplies | Same as previous years | |||||||||||||||||||||||
84 | 7325 | IT services | We spent about $1050 here last year, so set aside a similar amount | |||||||||||||||||||||||
85 | 7340 | Office Supplies | We spent about $570 here last year, so set aside a similar amount | |||||||||||||||||||||||
86 | 7360 | Postage | We only spent $50 on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
87 | 7390 | Telephone/Fax | Same as last year- costs us $7 a month | |||||||||||||||||||||||
88 | 7430 | Other Sundry Items | One off $300 for books for the space and $750 a semester for space snacks plus a little aside if needed | |||||||||||||||||||||||
89 | 7510 | Conferences | We only spent about $40 on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
90 | 7515 | Donations | We spent about $1050 here last year, so set aside a similar amount | |||||||||||||||||||||||
91 | 7520 | General Travel | We didn't spend any on this in 2022/23 so just putting a little aside here if needed | |||||||||||||||||||||||
92 | 7530 | Special Occasions | We spent about $680 here last year, so set aside a similar amount | |||||||||||||||||||||||
93 | 7570 | Meetings | We spent about $265 here last year, so set aside a larger amount incase we want more meeting spending (food etc.) | |||||||||||||||||||||||
94 | 7610 | Zap internal charges | We spent about $420 here last year, so set aside a similar amount | |||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||