2021-2022 BSC Final Budget (Board-Approved)

	A	B	C	D	E	F	G	H	I	J	K	N	O	Q	R	X	AB	AC	AE	AF	AJ	AM	AQ	AR	AU	AY	BB	BC	BF	BG
1	Fund	Restrictions	FYE 2019	8/31/2020	3/10/2021	blocks	cols	remainder
2	Scholarship	Must be used for scholarships	$1,945,267.00	$2,131,405.00	$2,430,240.82	350.85	8.77	30.85
3	Operating Reserve	None	$4,466,154.00	$4,479,507.00	$4,693,969.81	677.67	16.94	37.67
4	Capital Improvements	Must be used for capital improvements	$2,747,611.00	$2,750,297.00	$2,875,358.20	415.12	10.38	15.12
5	Growth	Board restricted can be used for any purpose with board approval	$4,038,335.00	$4,560,209.00	$5,081,829.24	733.66	18.34	13.66
6								cols		40
7	Board				$2,081,950.42	300.57	7.51	scale:		$6,926.64
8	Room				$5,090,282.38	734.88	18.37
9	Rent				$2,815,485.86	406.47	10.16
10	Parking				$145,842.41	21.06	0.53
11	Fines & Forfeited Deposits				$0.00	0.00	0.00				Reserves (as of 3/10/2021)
12	Lease Income - 2315 Dwight				$294,807.48	42.56	1.06
13	Miscellaneous				$120,000.00	17.32	0.43
14	Total Revenue				$10,548,368.55	1,522.87	38.07	2.87										operating reserves						capital improvement						growth
15
16	Amortization of Prepaids				$ -	0.00	0.00							scholarships
17	Rent	rent, taxes, fees			$ 117,119.00	16.91	0.42
18	Capital Improvement	capital improvement			$ 1,168,225.00	168.66	4.22
19	Financing	financing			$ 1,408,660.78	203.37	5.08
20	Regular & Prev Maint - Cent.	maintenance			$ 440,000.00	63.52	1.59
21	Regular & Prev Maint - Decent.	maintenance			$ 33,669.00	4.86	0.12
22	Regular & Prev Maint - I.T.	maintenance			$ 120,000.00	17.32	0.43
23	Payroll	payroll			$ 3,458,903.70	499.36	12.48
24	Payroll Taxes & Benefits	rent, taxes, fees			$ 695,924.55	100.47	2.51
25	Food	food			$ 1,088,639.55	157.17	3.93	12.53662407	13.17
26	Gas & Electricity	utilities (variable)			$ 392,504.24	56.67	1.42
27	Water	utilities (variable)			$ 299,999.64	43.31	1.08
28	Garbage	utilities (variable)			$ 188,893.88	27.27	0.68
29	Telephone & Internet	utilities (fixed)			$ 41,000.00	5.92	0.15
30	Insurance	insurance & legal			$ 591,119.04	85.34	2.13
31	Taxes & Licenses	rent, taxes, fees			$ 42,500.00	6.14	0.15
32	Supplies	supplies			$ 150,000.00	21.66	0.54
33	Delivery	food			$ 20,000.00	2.89	0.07
34	Auditing Fees	rent, taxes, fees			$ 60,000.00	8.66	0.22
35	Legal Fees	insurance & legal			$ 40,000.00	5.77	0.14
36	Bad Debts	bad debts and scholarships			$ 240,000.00	34.65	0.87
37	Member Resources	member resources			$ 99,500.00	14.36	0.36
38	Development	development + marketing			$ 72,000.00	10.39	0.26
39	Apartment Internet Fees	utilities (fixed)			$ 50,602.86	7.31	0.18
40	Marketing & Recruitment	development + marketing			$ 14,950.00	2.16	0.05
41	Credit Card & E-Check Fees	rent, taxes, fees			$ 75,000.00	10.83	0.27
42	Board & Committees Develop	board + staff dev			$ 38,420.00	5.55	0.14
43	Contrib. to Scholarships Fund				$ -	0.00	0.00
44	Contrib. to Operating Reserve				$ -	0.00	0.00
45	Staff Development	board + staff dev			$ 40,000.00	5.77	0.14
46	Miscellaneous	misc			$ 30,000.00	4.33	0.11																	Payroll: student staff + unit managers
47	Growth Fund				$ -	0.00	0.00								financing				capital improvement					Payroll: student staff + unit managers				1 square	$6,926.64
48	Consulting	board + staff dev			$ 25,000.00	3.61	0.09
49	Shuumi Land Tax	Shuumi			$ 40,000.00	5.77	0.14
50	Total Expenses				$11,082,631.23	1,600.00	40.00
51											2021-2022 Operating Budget (CFCom Recommendation)
52
53	rent, taxes, fees			8.94%	$990,543.55	143.00	11.95846228	143	x
54	capital improvement			10.54%	$1,168,225.00	168.66	12.9867894	169	x
55	financing			12.71%	$1,408,660.78	203.37	14.26073014	203	x
56	maintenance			5.36%	$593,669.00	85.71	9.257862705	86	x
57	payroll			31.21%	$3,458,903.70	499.36	22.34641116	499	x														Payroll: senior managers
58	food			10.00%	$1,108,639.55	160.05	12.6512586	160	x
59	utilities (variable)			7.95%	$881,397.76	127.25	11.28040055	127	x											food
60	utilities (fixed)			0.83%	$91,602.86	13.22	3.636579359	13	x						rent, taxes, and fees
61	insurance & legal			5.69%	$631,119.04	91.11	9.545401279	91	x
62	supplies			1.35%	$150,000.00	21.66	4.653547804	22	x
63	bad debts and scholarships			2.17%	$240,000.00	34.65	5.886324104	35	x
64	member resources			0.90%	$99,500.00	14.36	3.790094953	14	x
65	development + marketing			0.78%	$86,950.00	12.55	3.543017873	13	x
66	board + staff dev			0.93%	$103,420.00	14.93	3.864032911	15	x															Payroll: other profesional staff
67				0.00%	$0.00	0.00	0
68	misc			0.27%	$30,000.00	4.33	2.081129845	4
69	Shuumi			0.36%	$40,000.00	5.77	2.403081753	6	x					maintenance
70				0.00%	$0.00	0.00	0	1600
71						0.00	0													utilities
72	senior management pay subtotal	$477,023.62			$477,023.62	68.87	8.298669941
73	student staff pay subtotal	486,191.18			$486,191.18	70.19	8.378033451	x
74	unit manager pay subtotal	$ 692,684.39			$ 692,684.39	100.00	10.00014389
75	other staff	$ 1,803,004.51			$ 1,803,004.51	260.30	16.13381067						insurance & legal
76	total member payroll	1,178,875.57			1,178,875.57	170.19	13.0458546
77			not staff:	68.79%	$7,623,727.54											development + marketing		board + staff dev.			supplies
78																development + marketing		board + staff dev.		Shuumi
79
80						1,600.00										Member resources	misc		rent relief (bad debt & scholarships)
81																Member resources
82
83					people per block
84			F/S R/B Rate	$3,852.00	1.79819432	8.990971599	5														50%	60%			75%	84%	90%		100%
85			Summer R Rate	$2,000.00	3.46332226	6.92664452	2					summer '21	Houses								50%	60%			75%	84%	90%		100%
86			Summer R/B Rate	$2,688.00	2.576876682	18.03813677	7
87
88
89
90				$12,178,156.86	1758.161087	43.95402719					2021-2022 Projected Revenue (Board-Approved)
91			houses	$8,850,864.69	29.07127831
92			apartments	$ 2,912,484.70	$420.48	$10.51
93			other	$414,807.48	59.88577569							fall 2021
94			hip	$160,270.34	$23.14
95			summer	$1,824,992.00	5.994312672
96			fall	$3,232,341.00	10.61684797
97			spring	$3,232,341.00	10.61684797
98
99						39.6
100						32.296