Page 13 - Prosper Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 13
Baltimore Properties I, LLC
Prosper on Fayette
Budget Comparison Report
Managed by RISE Residential
As of January 31, 2022
Prior MTD Prior YTD Current
Month to Date 01/31/2022 01/31/2021 Year to Date 01/31/2022 01/31/2021 Fiscal Year
Actual Budget Variance Actual Variance Actual Budget Variance Actual Variance Budget
CONTROLLABLE EXPENSES
PAYROLL OFFICE
861 2,080 1,219 0 (861) 6091 - Community Assistants 5,550 12,480 6,930 0 (5,550) 24,960
3,894 3,863 (31) 0 (3,894) 6093 - Leasing Manager Payroll 23,362 23,175 (187) 0 (23,362) 46,350
6,534 6,470 (64) 0 (6,534) 6330 - General Manager 39,458 38,825 (633) 0 (39,458) 77,650
5,715 5,200 (515) 0 (5,715) 6335 - Leasing Salaries 33,514 31,200 (2,314) 0 (33,515) 62,400
0 0 0 0 0 6338 - Property Bonuses 4,820 5,965 1,145 0 (4,820) 17,895
1,150 1,000 (150) 0 (1,150) 6339 - Leasing Bonuses 4,901 3,250 (1,651) 0 (4,901) 7,500
18,154 18,613 459 0 (18,154) TOTAL PAYROLL OFFICE 111,605 114,895 3,290 0 (111,605) 236,755
PAYROLL MAINTENANCE
3,745 3,814 69 0 (3,744) 6510 - Maintenance Salaries 9,664 22,880 13,216 0 (9,664) 45,760
5,041 5,000 (42) 0 (5,042) 6511 - Maintenance Supervisor 30,166 30,000 (166) 0 (30,166) 60,000
8,786 8,814 27 0 (8,786) TOTAL PAYROLL MAINTENANCE 39,830 52,880 13,050 0 (39,830) 105,760
PAYROLL RELATED EXPENSES
806 26 (780) 0 (806) 6711 - State Unemployment Tax 1,381 1,514 132 0 (1,381) 1,935
178 6 (171) 0 (177) 6712 - Federal Unemployment 287 349 63 0 (286) 446
2,428 2,098 (330) 0 (2,429) 6713 - Employer Portion of FICA 12,471 12,835 363 0 (12,472) 26,202
289 293 4 0 (289) 6722 - Workers Compensation 1,481 1,795 315 0 (1,480) 3,665
1,160 1,622 462 0 (1,159) 6723 - Health Insurance Expense 6,426 9,728 3,302 0 (6,427) 19,457
18 60 42 0 (18) 6724 - Dental & Vision Insurance 409 361 (48) 0 (409) 721
22 222 200 0 (22) 6725 - Long/Short Term Disability 22 1,359 1,337 0 (22) 2,774
60 0 (60) 0 (60) 6726 - Life Insurance 342 0 (342) 0 (342) 0
197 118 (78) 0 (197) 6730 - 401k Contributions Expense 1,338 710 (628) 0 (1,338) 1,420
121 91 (31) 0 (121) 6108 - Payroll Fees 655 542 (113) 0 (656) 1,085
5,279 4,536 (742) 0 (5,279) TOTAL PAYROLL RELATED EXP. 24,812 29,193 4,381 0 (24,812) 57,705
32,219 31,963 (256) 0 (32,219) TOTAL PAYROLL 176,247 196,968 20,721 0 (176,247) 400,220
GENERAL & ADMINISTRATIVE
23 240 217 0 (23) 6116 - Recruiting & Hiring 609 240 (368) 0 (608) 240
4,686 4,700 14 0 (4,686) 6228 - General Cleaning 21,448 28,200 6,751 0 (21,448) 56,400
Page 6