| Income Statement |
| Ventura Hills |
| For the month ended 31 December 2019 |
| | | 2 | 3 |
| | Jan-20 | Dec-19 | Nov-19 | Oct-19 | Sep-19 | Aug-19 | Jul-19 | Jun-19 | May-19 | Apr-19 | Mar-19 | Feb-19 | Total |
| Revenue |
| Operating Revenue |
| Other Income |
| Employee Meals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $13.93 | $88.07 | $0.00 | $0.00 | $0.00 | $0.00 | $102.00 |
| Late Fee AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total Other Income | -$838.25 | -$91.40 | -$126.75 | $0.00 | $0.00 | $0.00 | $13.93 | $88.07 | $0.00 | $0.00 | $0.00 | $0.00 | -$954.40 |
| Total Operating Revenue | -$838.25 | -$91.40 | -$126.75 | $0.00 | $0.00 | $0.00 | $13.93 | $88.07 | $0.00 | $0.00 | $0.00 | $0.00 | -$954.40 |
| Room & Board AL |
| *Room & Board - AL |
| Respite Care AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,250.00 | $2,250.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,500.00 |
| Room & Board AL | $140,129.78 | $136,413.32 | $137,678.40 | $136,396.62 | $126,981.36 | $141,255.80 | $142,149.70 | $143,232.10 | $144,730.62 | $146,857.03 | $152,268.59 | $133,997.42 | $1,682,090.74 |
| Total *Room & Board - AL | $140,129.78 | $136,413.32 | $137,678.40 | $136,396.62 | $126,981.36 | $141,255.80 | $144,399.70 | $145,482.10 | $144,730.62 | $146,857.03 | $152,268.59 | $133,997.42 | $1,686,590.74 |
| Additional Services - AL |
| Additional Care Services AL | $0.00 | $0.00 | $54.00 | $0.00 | $0.00 | $0.00 | $17,105.38 | $26,544.59 | $29,157.06 | $32,077.40 | $36,700.67 | -$2,357.86 | $139,281.24 |
| Additional Resident AL | $1,000.00 | $800.00 | $1,800.00 | $1,800.00 | $1,800.00 | $104.92 | $1,938.36 | $840.00 | $840.00 | $0.00 | $0.00 | $181.50 | $11,104.78 |
| Additonal Meals / Tray Svc AL | $0.00 | $0.00 | $300.00 | $300.00 | $310.00 | $320.00 | $320.00 | $310.00 | $50.00 | $280.00 | $0.00 | $0.00 | $2,190.00 |
| Beauty Salon Contra AL | $0.00 | $0.00 | -$62.00 | -$364.00 | -$577.00 | -$313.00 | -$507.75 | -$618.00 | -$425.00 | $0.00 | $0.00 | $0.00 | -$2,866.75 |
| Beauty Salon AL | $0.00 | $0.00 | $10,331.50 | $9,420.00 | $10,093.50 | $9,897.00 | $494.00 | $533.00 | $985.00 | $477.00 | $0.00 | $0.00 | $42,231.00 |
| Care Level 1 AL | $2,636.93 | $3,159.00 | $3,821.17 | $4,912.00 | $4,666.10 | $3,612.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,271.23 | $26,078.43 |
| Care Level 2 AL | $8,087.00 | $8,087.00 | $8,025.00 | $8,107.91 | $9,077.81 | $8,568.00 | | | | | | | $49,952.72 |
| Care Level 3 AL | $2,361.29 | $1,800.00 | $72.79 | $732.05 | $623.85 | $835.33 | | | | | | | $6,425.31 |
| Community Fees AL | $0.00 | $6,250.00 | $1,000.00 | $3,500.00 | $0.00 | $2,000.00 | $0.00 | $4,000.00 | $750.00 | $6,250.00 | $1,000.00 | $0.00 | $24,750.00 |
| Guest Meals AL | $0.00 | $0.00 | $240.00 | $0.00 | $132.00 | $180.00 | $216.00 | $0.00 | $100.00 | $130.00 | $10.00 | $0.00 | $1,008.00 |
| Guest Suite AL | $0.00 | $0.00 | $625.00 | | $0.00 | $0.00 | | | | | | | $625.00 |
| Housekeeping AL | $204.00 | $204.00 | $204.00 | $204.00 | $204.00 | $279.00 | $0.00 | $0.00 | $54.00 | $73.00 | $0.00 | $0.00 | $1,426.00 |
| Medication Fee AL | $7,985.62 | $9,229.65 | $9,871.96 | $11,300.63 | $10,650.49 | $13,800.33 | $12,458.00 | $450.00 | $450.00 | $60.00 | $0.00 | $0.00 | $76,256.68 |
| Miscellaneous Resident Charge (AL) | -$2,767.99 | -$3,674.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$6,441.11 |
| Pendant Fee AL | $359.10 | $383.77 | $510.00 | $348.00 | $499.53 | $347.00 | $347.00 | $347.00 | $549.00 | $403.07 | $378.40 | $0.00 | $4,471.87 |
| Pet Fee AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $800.00 | $800.00 | $0.00 | $0.00 | $1,600.00 |
| Rate Lock Fees AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,695.00 | $0.00 | $0.00 | $1,695.00 |
| Total Additional Services - AL | $19,865.95 | $26,528.33 | $36,793.42 | $40,260.59 | $37,480.28 | $39,630.58 | $32,370.99 | $32,407.59 | $33,310.06 | $42,245.47 | $38,089.07 | $1,094.87 | $380,077.20 |
| Concessions - AL |
| Concession - Rent AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$9,868.12 | -$7,489.80 | -$10,959.12 | -$14,498.27 | -$14,735.87 | $0.00 | -$57,551.18 |
| Concessions - Additional Resident AL | -$200.00 | $0.00 | -$9,573.82 | -$9,595.00 | -$9,618.12 | -$9,618.12 | | | | | | | -$38,605.06 |
| Concessions - Care Services AL | -$3,795.00 | -$4,254.68 | -$750.00 | -$250.00 | -$250.00 | -$250.00 | | | | | | | -$9,549.68 |
| Concessions - Rent AL | $7,235.87 | $5,183.93 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$5,833.87 | $6,585.93 |
| Total Concessions - AL | $3,240.87 | $929.25 | -$10,323.82 | -$9,845.00 | -$9,868.12 | -$9,868.12 | -$9,868.12 | -$7,489.80 | -$10,959.12 | -$14,498.27 | -$14,735.87 | -$5,833.87 | -$99,119.99 |
| Total Room & Board AL | $163,236.60 | $163,870.90 | $164,148.00 | $166,812.21 | $154,593.52 | $171,018.26 | $166,902.57 | $170,399.89 | $167,081.56 | $174,604.23 | $175,621.79 | $129,258.42 | $1,967,547.95 |
| Room & Board MC |
| *Room & Board - MC |
| Room & Board MC | $13,432.37 | $5,995.00 | $4,995.00 | $4,995.00 | $3,439.18 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $32,856.55 |
| Total *Room & Board - MC | $13,432.37 | $5,995.00 | $4,995.00 | $4,995.00 | $3,439.18 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $32,856.55 |
| Total Room & Board MC | $27,027.17 | $9,223.00 | $4,995.00 | $4,995.00 | $3,439.18 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $49,679.35 |
| Total Revenue | $189,425.52 | $173,002.50 | $169,016.25 | $171,807.21 | $158,032.70 | $171,018.26 | $166,916.50 | $170,487.96 | $167,081.56 | $174,604.23 | $175,621.79 | $129,258.42 | $2,016,272.90 |
| Gross Profit | $189,425.52 | $173,002.50 | $169,016.25 | $171,807.21 | $158,032.70 | $171,018.26 | $166,916.50 | $170,487.96 | $167,081.56 | $174,604.23 | $175,621.79 | $129,258.42 | $2,016,272.90 |
| Operating Expenses |
| Administration -A- Payroll |
| Business Office Director | $2,310.02 | $4,611.41 | $4,457.42 | $4,613.27 | $4,457.52 | $4,426.13 | $3,506.71 | $4,597.68 | $4,002.83 | $4,539.13 | $6,566.61 | $1,104.52 | $49,193.25 |
| Employee Benefits- Admin | $277.11 | $904.84 | $833.30 | $861.74 | $833.95 | $487.96 | $861.74 | $833.64 | $861.11 | $833.34 | $861.11 | $138.89 | $8,588.73 |
| Employee Recruiting - Admin | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $238.00 | $0.00 | $0.00 | $7,800.00 | $0.00 | $8,038.00 |
| Employee Uniforms - Admin | $98.52 | $0.00 | $190.12 | $235.87 | $0.00 | $395.27 | $363.32 | $299.95 | $485.92 | $16.69 | $755.61 | $71.01 | $2,912.28 |
| Employment Screenings - Admin | $395.90 | $486.90 | $690.52 | $1,871.89 | $198.00 | $288.52 | $416.57 | $405.44 | $498.82 | $988.26 | $495.00 | $0.00 | $6,735.82 |
| Executive Director | $12,175.01 | $8,076.92 | $12,115.38 | $10,099.16 | $6,660.90 | $6,761.42 | $6,661.43 | $6,760.90 | $6,661.43 | $6,810.90 | $6,661.42 | $0.00 | $89,444.87 |
| Executive Director Bonus | $0.00 | $0.00 | $0.00 | $0.00 | $1,700.00 | $0.00 | $0.00 | $0.00 | $150.00 | $0.00 | $0.00 | $0.00 | $1,850.00 |
| Executive Director Taxes / Benefits | $1,955.84 | $819.91 | $1,309.23 | $1,459.31 | $976.16 | $802.42 | $792.14 | $803.63 | $808.55 | $791.46 | $889.24 | $0.00 | $11,407.89 |
| Holiday Pay - Admin | $247.88 | $395.08 | $321.48 | $0.00 | $68.26 | $68.26 | $298.52 | $49.24 | $341.61 | $0.00 | $0.00 | $0.00 | $1,790.33 |
| Overtime - Admin | $131.78 | $0.00 | $0.00 | $0.00 | $0.00 | $13.95 | $34.57 | $79.83 | $35.77 | $3.20 | $35.33 | $1.14 | $335.57 |
| Payroll Service Fee | $2,431.66 | $2,597.82 | $2,662.16 | $2,666.95 | $2,386.29 | $2,691.41 | $2,899.30 | $2,813.91 | $2,868.49 | $2,790.76 | $3,746.19 | $1,579.48 | $32,134.42 |
| Payroll Taxes - Admin | $611.02 | $690.77 | $518.48 | $544.15 | $518.93 | $545.00 | $548.23 | $548.20 | $1,805.87 | $3,589.02 | $1,075.51 | $187.10 | $11,182.28 |
| PTO/Sick Leave Wages - Admin | $819.57 | $807.27 | $290.48 | $277.22 | $291.51 | $583.20 | $1,182.09 | $47.68 | $614.99 | $91.30 | $397.37 | $91.32 | $5,494.00 |
| Receptionist/Concierge | $1,791.31 | $1,980.55 | $1,708.22 | $2,222.53 | $1,966.14 | $2,032.47 | $2,144.52 | $2,185.79 | $2,172.11 | $2,077.47 | $3,084.99 | $546.67 | $23,912.77 |
| Salaries & Wages - Hourly - Admin | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Workers Comp - Admin | $2,452.83 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $1,129.58 | $14,878.21 |
| Total Administration -A- Payroll | $25,698.45 | $22,501.05 | $26,226.37 | $25,981.67 | $21,187.24 | $20,225.59 | $20,838.72 | $20,793.47 | $22,437.08 | $23,661.11 | $33,497.96 | $4,849.71 | $267,898.42 |
| Administration -B- Operating Expenses |
| Bad Debt Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $141.73 | $141.73 |
| Bank Fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $31.17 | $0.00 | $31.17 |
| Cell Phones Directors/Managers | $0.00 | $105.00 | $70.00 | $70.00 | $87.50 | $87.50 | $140.00 | $105.00 | $35.00 | $128.94 | $100.00 | $0.00 | $928.94 |
| Computer Software Maintenace | $1,159.96 | $1,075.02 | $706.94 | $1,032.38 | $1,054.20 | $3,280.27 | $137.84 | $768.48 | $874.20 | $982.54 | $1,726.14 | $1,109.90 | $13,907.87 |
| Copier Lease | $1,704.07 | $1,321.31 | $1,897.91 | $954.70 | $1,466.90 | $451.62 | $519.35 | $514.32 | $617.72 | $726.15 | $1,330.89 | $664.71 | $12,169.65 |
| Copier Maintenance & Overages | $0.00 | $0.00 | $0.00 | $186.40 | $0.00 | $0.00 | $749.91 | $0.00 | $947.92 | $787.38 | $2,161.13 | $0.00 | $4,832.74 |
| Dues & Subscriptions - Admin | $0.00 | $0.00 | $1,040.03 | $1,084.29 | $1,117.49 | $1,125.90 | $1,319.91 | $1,324.47 | $316.13 | $1,892.39 | $5.00 | $106.92 | $9,332.53 |
| Employee Appreciation - Admin | $0.00 | $67.57 | $89.18 | $24.67 | $0.00 | $11.44 | $0.00 | $29.60 | $324.20 | $0.00 | $82.18 | $212.82 | $841.66 |
| Flowers - Admin | $0.00 | $0.00 | $0.00 | $48.49 | $0.00 | $0.00 | | | | | | | $48.49 |
| Food-Admin | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $10.42 | | | | | | | $10.42 |
| Interest / Finance Charges | $76.77 | $0.00 | $0.00 | $0.00 | $216.34 | $0.00 | $0.00 | $82.23 | $82.23 | $82.23 | $82.23 | $82.23 | $704.26 |
| Internet | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $103.86 | $103.86 |
| IT Email Services | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $144.54 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $176.13 | $320.67 |
| Licenses & Permits Admin | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $709.25 | $372.49 | $0.00 | $0.00 | $1,081.74 |
| Management Company Travel | $454.32 | $4,715.67 | $3,851.63 | $3,461.48 | $1,694.42 | $0.00 | $2,360.09 | $0.00 | $0.00 | $0.00 | $12,000.00 | $5,271.88 | $33,809.49 |
| Meals & Entertainment - Admin | $442.38 | $352.47 | $199.45 | $344.56 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $130.06 | $1,468.92 |
| Office Supplies - Admin | $38.11 | $0.00 | $114.53 | $633.94 | $301.68 | $735.27 | $558.68 | $877.64 | $1,281.97 | $676.51 | $632.29 | $0.00 | $5,850.62 |
| Postage & Delivery | $105.14 | $64.27 | $164.06 | $44.28 | $247.61 | $196.23 | $249.27 | $178.84 | $486.35 | $230.34 | $175.29 | $473.96 | $2,615.64 |
| Postage Meter - Lease Equip | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $391.28 | $32.00 | $290.59 | $0.00 | $713.87 |
| Professional Fees Accounting | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$2,844.67 | $0.00 | $0.00 | $336.43 | $336.43 | $350.93 | $1,820.88 | $0.00 |
| Professional Fees Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $525.00 | $0.00 | $0.00 | -$87.08 | $437.92 |
| Resident Relations | $0.00 | $0.00 | $0.00 | $0.00 | $49.77 | $86.59 | $0.00 | $0.00 | $86.02 | $0.00 | $0.00 | $16.17 | $238.55 |
| Training and Meetings - Admin | $0.00 | $0.00 | $0.00 | $425.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,105.20 | $0.00 | $0.00 | $4,530.20 |
| Total Administration -B- Operating Expenses | $3,980.75 | $7,701.31 | $8,133.73 | $8,310.19 | $6,235.91 | $3,285.11 | $6,035.05 | $3,880.58 | $7,013.70 | $10,352.60 | $18,967.84 | $10,224.17 | $94,120.94 |
| Assisted Living -A- Payroll |
| Bonuses - AL | $0.00 | $0.00 | $0.00 | -$32.14 | $82.14 | $0.00 | $1,476.79 | $1,148.21 | $0.00 | $71.43 | $203.57 | $0.00 | $2,950.00 |
| Employee Benefits Other - AL | $429.11 | $656.80 | $483.22 | $497.18 | $486.95 | -$107.93 | $470.50 | $676.75 | $1,174.44 | $1,062.24 | $2,338.12 | $610.22 | $8,777.60 |
| Employee Medical Insurance - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,474.61 | $5,474.61 |
| Employee Recruiting - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $68.30 | $68.30 |
| Employment Screenings - AL | $21.58 | $35.84 | $20.10 | $98.09 | $0.00 | $31.94 | $23.31 | $56.29 | $79.54 | $82.12 | $0.00 | $0.00 | $448.81 |
| Health Services Director - AL | $5,051.50 | $6,389.40 | $576.92 | -$1,368.55 | $4,680.09 | $4,663.20 | $4,882.83 | $5,034.88 | $5,017.99 | $4,088.74 | $4,440.11 | $1,790.61 | $45,247.72 |
| Holiday Pay - AL | $3,315.15 | $3,976.32 | $2,120.42 | $0.00 | $548.92 | $548.93 | $2,133.89 | $351.96 | $1,827.29 | $0.00 | $0.00 | $0.00 | $14,822.88 |
| Overtime - AL | $4,462.74 | $4,410.28 | $5,912.54 | $8,226.31 | $6,568.87 | $3,408.36 | $4,013.03 | $3,214.03 | $3,372.76 | $2,851.42 | $8,789.35 | $983.85 | $56,213.54 |
| Payroll Taxes - AL | $4,934.65 | $4,966.10 | $4,334.74 | $3,835.40 | $3,332.15 | $3,537.52 | $4,060.80 | $4,678.00 | $3,992.34 | $2,464.54 | $6,152.82 | $3,056.43 | $49,345.49 |
| PTO/Sick Leave Wages - AL | $1,166.79 | $1,092.86 | $332.51 | $976.05 | $1,067.99 | $1,182.22 | $470.21 | $1,837.03 | $1,147.95 | $796.10 | $1,222.57 | -$13,430.91 | -$2,138.63 |
| Retirement Employee Matching - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$40.65 | -$40.65 |
| Salaries & Wages AL CNA/Res Assistant | $14,654.02 | $16,247.52 | $20,227.02 | $16,334.90 | $17,984.23 | $20,948.53 | $20,352.24 | $22,706.13 | $23,140.85 | $20,619.35 | $27,333.54 | $4,491.15 | $225,039.48 |
| Salaries & Wages AL LPN | $2,936.37 | $4,651.23 | $5,048.78 | $1,243.54 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,952.44 | $1,752.34 | $18,584.70 |
| Salaries & Wages AL Med Tech | $13,462.75 | $14,418.72 | $13,969.32 | $18,424.09 | $8,042.61 | $8,302.91 | $10,263.29 | $13,125.08 | $9,084.53 | $7,236.05 | $12,442.57 | $2,735.04 | $131,506.96 |
| Workers Comp - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $295.66 | $295.66 |
| Total Assisted Living -A- Payroll | $50,434.66 | $56,845.07 | $53,025.57 | $48,234.87 | $42,793.95 | $42,515.68 | $48,146.89 | $52,828.36 | $48,837.69 | $39,271.99 | $65,875.09 | $7,786.65 | $556,596.47 |
| Assisted Living -B- Operating Expenses |
| Consultants - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $380.77 | $0.00 | $0.00 | $380.77 |
| Contract Labor - AL | $0.00 | $0.00 | $0.00 | $0.00 | $8,494.05 | $0.00 | $9,217.92 | $20,377.88 | $18,394.84 | $30,830.85 | $4,386.33 | $0.00 | $91,701.87 |
| Dues & Subscriptions - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $105.00 | $0.00 | $100.00 | $93.95 | $298.95 |
| EMAR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $789.22 | $789.22 | $0.00 | $0.00 | $1,578.44 |
| Equipment Lease - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,208.41 | $1,208.41 |
| Hazardous Waste Disposal - AL | $110.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $50.00 | $0.00 | -$282.13 | -$122.13 |
| Licenses & Permits AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Medical Supplies | $265.72 | $557.56 | $181.13 | $0.00 | $202.60 | $0.00 | $6.50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,213.51 |
| Mileage - AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $206.48 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $206.48 |
| Supplies - Medical/ Charged to Residents AL | $120.64 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.88 | $0.00 | $122.52 |
| Wellness Supplies | $0.00 | $0.00 | $0.00 | $0.00 | $362.25 | $87.93 | $232.76 | $167.19 | $150.82 | $1,312.33 | $417.98 | $55.11 | $2,786.37 |
| Total Assisted Living -B- Operating Expenses | $496.36 | $557.56 | $181.13 | $0.00 | $9,058.90 | $87.93 | $9,663.66 | $20,545.07 | $19,439.88 | $33,363.17 | $4,906.19 | $1,075.34 | $99,375.19 |
| Dining -A- Payroll |
| Cooks | $8,012.61 | $8,771.56 | $9,911.03 | $8,098.68 | $8,141.08 | $7,625.18 | $7,808.64 | $8,033.81 | $8,509.29 | $8,808.61 | $13,489.72 | $2,784.80 | $99,995.01 |
| Dining Room Waitstaff | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $486.24 | $486.24 |
| Director of Dining Service | $4,253.20 | $4,260.90 | $4,113.95 | $5,544.89 | $5,366.01 | $5,366.02 | $4,042.41 | $4,775.76 | $5,291.52 | $5,209.71 | $7,328.33 | $868.29 | $56,420.99 |
| Employee Benefits Other - Dining | $966.37 | $1,932.53 | $2,069.74 | $1,868.45 | $2,866.20 | $1,428.30 | $2,602.83 | $2,550.72 | $2,669.10 | $2,584.83 | $2,670.41 | $430.71 | $24,640.19 |
| Employee Uniforms - Dining | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $465.36 | $465.36 |
| Employment Screenings - Dining | $2.20 | $2.18 | $15.57 | $13.69 | $0.00 | $1.10 | $13.12 | $15.62 | $8.02 | $17.31 | $0.00 | $0.00 | $88.81 |
| Holiday Pay - Dining | $1,308.46 | $1,157.51 | $733.80 | $0.00 | $201.04 | $201.05 | $779.00 | $116.13 | $730.76 | $0.00 | $0.00 | $0.00 | $5,227.75 |
| Overtime - Dining | $0.00 | $0.00 | $66.81 | $507.04 | $307.54 | $33.32 | $44.86 | $135.93 | $582.11 | $36.73 | $149.85 | $0.00 | $1,864.19 |
| Payroll Taxes - Dining | $1,528.24 | $1,483.87 | $1,357.76 | $1,212.45 | $1,170.62 | $1,264.69 | $1,386.50 | $1,291.82 | $1,177.17 | $941.64 | $2,324.29 | $418.48 | $15,557.53 |
| PTO/Sick Leave Wages - Dining | $408.26 | $1,738.58 | $1,646.27 | $659.20 | $247.20 | $965.95 | $2,455.68 | $1,377.17 | $0.00 | $167.37 | $975.27 | $255.67 | $10,896.62 |
| Utility Workers | $0.00 | $83.48 | $0.00 | $0.00 | $0.00 | $1,314.15 | $1,548.36 | $1,103.35 | $0.00 | $0.00 | $0.00 | $0.00 | $4,049.34 |
| Total Dining -A- Payroll | $16,479.34 | $19,430.61 | $19,914.93 | $17,904.40 | $18,299.69 | $18,199.76 | $20,681.40 | $19,400.31 | $18,967.97 | $17,766.20 | $26,937.87 | $5,709.55 | $219,692.03 |
| Dining -B- Operating Expenses |
| China | $0.00 | $0.00 | $82.39 | $0.00 | $0.00 | $139.83 | $0.00 | $490.28 | $198.70 | $458.55 | $0.00 | $0.00 | $1,369.75 |
| Contract Services - Menu | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $77.52 | $79.50 | $79.50 | $79.50 | $150.94 | $141.98 | $79.50 | $1,188.44 |
| Dishwasher Chemicals | $276.50 | $227.20 | $195.62 | $93.20 | $491.44 | $493.58 | $250.58 | $910.47 | $0.00 | $608.14 | $222.04 | $129.53 | $3,898.30 |
| Dishwasher Lease | $8,140.92 | $667.27 | $0.00 | $0.00 | $0.00 | $0.00 | $887.10 | $887.10 | $0.00 | $0.00 | $0.00 | $312.88 | $10,895.27 |
| Grease Trap Cleaning | $843.25 | $0.00 | $0.00 | $1,093.25 | $0.00 | $0.00 | $1,255.73 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,192.23 |
| Kitchen Equipment R&M | $0.00 | $148.29 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $97.44 | $245.73 |
| Kitchen Hood Service | $0.00 | $0.00 | $0.00 | $0.00 | $368.05 | $0.00 | | | | | | | $368.05 |
| Kitchen Supplies | $394.25 | $588.08 | $101.60 | $379.80 | $329.39 | $590.55 | $477.48 | $408.93 | $71.44 | $401.23 | $542.76 | $14.37 | $4,299.88 |
| Operating Supplies - Dining | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7.62 | $184.51 | $0.00 | $24.87 | $0.00 | $0.00 | $217.00 |
| Paper & Plastic Supplies - Dining | $205.97 | $186.00 | $113.53 | $64.73 | $40.07 | $144.39 | $425.21 | $145.92 | $0.00 | $242.50 | $353.37 | $0.00 | $1,921.69 |
| Raw Food | $9,042.96 | $9,399.45 | $19,894.40 | $10,656.24 | $9,032.58 | $12,043.78 | $19,440.90 | $18,974.36 | $26,806.77 | $31,868.95 | -$14,057.63 | $6,958.54 | $160,061.30 |
| Supplies - Cleaning - Dining | $0.00 | $0.00 | $0.00 | $415.68 | $377.34 | $915.64 | $1,392.30 | $358.20 | $0.00 | $1,066.30 | $480.71 | $0.00 | $5,006.17 |
| Training and Meetings - Dining | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $267.00 | $0.00 | $0.00 | $267.00 |
| Vendor Rebates - Dining | $0.00 | $0.00 | $0.00 | $0.00 | -$406.81 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$406.81 |
| Total Dining -B- Operating Expenses | $19,039.61 | $11,439.13 | $20,587.51 | $12,802.90 | $10,332.06 | $14,405.29 | $24,216.42 | $22,439.27 | $27,156.41 | $35,088.48 | -$12,316.77 | $7,592.26 | $192,782.57 |
| Housekeeping -A- Payroll |
| Employee Benefits Other - Housekeeping | -$2.05 | $3.94 | $1.35 | $1.39 | $1.35 | $1.21 | $2.79 | $3.04 | $2.49 | $1.69 | $1.75 | $0.28 | $19.23 |
| Employee Uniforms - Housekeeping | $207.74 | $0.00 | $89.92 | $51.70 | $0.00 | $0.00 | | | | | | | $349.36 |
| Employment Screenings - Housekeeping | $0.38 | $0.36 | $2.53 | $2.64 | $0.00 | $0.18 | $1.25 | $0.23 | $1.90 | $4.13 | $0.00 | $0.00 | $13.60 |
| Holiday Pay - Housekeeping | $200.48 | $155.29 | $87.20 | $0.00 | $114.64 | $114.64 | $209.35 | $33.08 | $220.68 | $0.00 | $0.00 | $0.00 | $1,135.36 |
| Housekeepers | $1,821.84 | $2,735.04 | $2,325.67 | $2,626.94 | $2,508.92 | $2,585.11 | $3,200.55 | $3,159.12 | $3,218.20 | $3,271.60 | $3,863.27 | $901.54 | $32,217.80 |
| Payroll Taxes - Housekeeping | $199.81 | $296.27 | $203.36 | $207.20 | $203.83 | $240.11 | $344.11 | $364.37 | $330.28 | $230.86 | $440.09 | $74.53 | $3,134.82 |
| PTO/Sick Leave Wages - Housekeeping | $0.00 | $81.75 | $245.25 | $81.75 | $40.87 | $225.68 | $155.67 | $261.60 | $87.20 | $0.00 | $238.05 | $0.00 | $1,417.82 |
| Total Housekeeping -A- Payroll | $2,428.20 | $3,272.65 | $2,955.28 | $2,971.62 | $2,869.61 | $3,166.93 | $3,913.72 | $3,821.44 | $3,860.75 | $3,508.28 | $4,543.16 | $976.35 | $38,287.99 |
| Housekeeping -B- Operating Expenses |
| Cleaning Supplies - Housekeeping | $399.11 | $610.27 | $38.91 | $236.13 | $94.30 | $300.61 | $762.06 | $0.00 | $0.00 | $245.94 | $578.09 | -$48.34 | $3,217.08 |
| Laundry Supplies | $0.00 | $0.00 | $324.36 | $0.00 | $301.54 | $150.78 | $0.00 | $0.00 | $0.00 | $0.00 | $413.47 | $0.00 | $1,190.15 |
| Operating Supplies - Housekeeping | $0.00 | $0.00 | $0.00 | $1,026.43 | $638.65 | $429.45 | $344.11 | $162.20 | $555.70 | $0.00 | $0.00 | $0.00 | $3,156.54 |
| Paper & Plastic Supplies - Housekeeping | $0.00 | $0.00 | $0.00 | $0.00 | $129.33 | $0.00 | | | | | | | $129.33 |
| Total Housekeeping -B- Operating Expenses | $840.40 | $928.35 | $299.18 | $1,262.56 | $1,163.82 | $880.84 | $1,106.17 | $162.20 | $555.70 | $245.94 | $991.56 | -$48.34 | $8,388.38 |
| Maintenance & Repair -A- Payroll |
| Director of Engineering | $3,124.92 | $3,401.16 | $3,616.18 | $4,138.84 | $3,912.82 | $4,378.97 | $4,089.60 | $3,318.86 | $4,073.14 | $4,011.43 | $6,028.29 | $685.71 | $44,779.92 |
| Employee Appreciation - Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $16.79 | $0.00 | | | | | | | $16.79 |
| Employee Benefits Other - Maintenance | $9.97 | $27.59 | $37.02 | $1.39 | $1.35 | $0.77 | $1.39 | $1.53 | $1.75 | $5.20 | $7.20 | $1.16 | $96.32 |
| Employment Screenings - Maintenance | $0.94 | $0.88 | $6.34 | $29.74 | $0.00 | $0.44 | $2.01 | $0.36 | $11.96 | $10.20 | $0.00 | $0.00 | $62.87 |
| Engineering Tech | $735.69 | $3,382.86 | $2,342.72 | $2,525.13 | $2,349.70 | $1,870.55 | $1,413.89 | $1,293.66 | $3,271.48 | $3,463.81 | $3,150.61 | $914.25 | $26,714.35 |
| Holiday Pay - Maintenance | $358.14 | $357.26 | $289.56 | $0.00 | $84.37 | $84.38 | $178.29 | $40.56 | $349.00 | $0.00 | $0.00 | $0.00 | $1,741.56 |
| Overtime - Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4.44 | $119.50 | $109.69 | $8.48 | $0.00 | $242.11 |
| Payroll Taxes - Maintenance | $633.82 | $613.68 | $575.37 | $605.94 | $585.36 | $552.96 | $458.86 | $448.90 | $629.84 | $485.14 | $1,022.35 | $181.99 | $6,794.21 |
| PTO/Sick Leave Wages - Maintenance | $277.02 | $824.28 | $423.77 | $240.14 | $324.89 | $377.28 | $150.91 | $776.91 | $240.53 | $0.00 | $366.72 | $0.00 | $4,002.45 |
| Total Maintenance & Repair -A- Payroll | $5,140.50 | $8,607.71 | $7,290.96 | $7,541.18 | $7,275.28 | $7,265.35 | $6,294.95 | $5,885.22 | $8,697.20 | $8,085.47 | $10,583.65 | $1,783.11 | $84,450.58 |
| Maintenance & Repair -B- Operating Expenses |
| Building Repairs | $0.00 | $0.00 | $622.35 | $125.83 | $534.71 | $0.00 | $0.00 | $1,687.61 | $9,107.37 | $1,307.20 | $863.88 | $924.37 | $15,173.32 |
| Chemicals - Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $57.35 | $0.00 | $57.35 |
| Common Area Cleaning & Repairs | $0.00 | $0.00 | $0.00 | $71.21 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $197.42 | $0.00 | $0.00 | $268.63 |
| Contract Labor - Maintenance | $0.00 | $389.70 | $0.00 | $1,041.33 | $0.00 | $0.00 | $0.00 | $0.00 | $368.05 | $551.14 | $0.00 | $368.05 | $2,718.27 |
| Dues & Subscriptions - Maintenance | $0.00 | $194.00 | $97.00 | $0.00 | $97.00 | $97.00 | $97.00 | $97.00 | $97.00 | $0.00 | $0.00 | $97.00 | $873.00 |
| Electrical Repair | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $45.84 | $45.84 |
| Emergency Alert / Pendants | $0.00 | $0.00 | $0.00 | $0.00 | $1,505.87 | $1,841.83 | | | | | | | $3,347.70 |
| Exterminating Contract | $1,455.21 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $771.20 | $811.88 | $0.00 | -$150.00 | $2,888.29 |
| Fire Alarm & Fire Sprinkler R&M/Contractsvs | $3,006.87 | $1,633.07 | $2,749.96 | $3,136.00 | $0.00 | $2,350.50 | $2,825.51 | $6,104.10 | $1,445.71 | $4,475.60 | $0.00 | $0.00 | $27,727.32 |
| Fire Extinguisher | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $930.95 | $0.00 | $0.00 | $930.95 |
| Furniture & Equip Non CapX - Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $306.81 | $150.00 | $64.94 | $521.75 |
| General Maintenance Supplies | $717.44 | $486.90 | $484.31 | $948.34 | $2,004.36 | $1,322.29 | $459.00 | $1,067.00 | $1,521.84 | $709.29 | $209.23 | $551.00 | $10,481.00 |
| General R&M | $0.00 | $123.75 | $0.00 | $98.03 | $0.00 | $0.00 | $300.41 | $495.13 | $1,755.17 | $350.73 | $0.00 | $0.00 | $3,123.22 |
| Generator Service | $1,269.80 | $0.00 | $0.00 | $1,409.89 | $0.00 | $0.00 | $0.00 | $948.42 | $0.00 | $0.00 | $0.00 | $0.00 | $3,628.11 |
| Grounds Contract | $176.73 | $2,142.00 | $2,318.73 | $2,484.35 | $2,318.73 | $2,805.87 | $2,498.15 | $2,878.94 | $2,318.73 | $2,805.87 | $7,760.47 | -$1,359.00 | $29,149.57 |
| HVAC Repair | $0.00 | $0.00 | $780.19 | $2,262.38 | $0.00 | $1,437.26 | $0.00 | $2,158.32 | $3,693.09 | $2,493.14 | $876.72 | $0.00 | $13,701.10 |
| HVAC Supplies | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,881.36 | $0.00 | $0.00 | $0.00 | $0.00 | $1,881.36 |
| Landscaping Other (Irrigation) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $779.40 | $222.93 | $0.00 | $1,002.33 |
| Landscaping Seasonal Plants | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $76.51 | $0.00 | $101.28 | $0.00 | $0.00 | $177.79 |
| Licenses & Permits Maintenance | $0.00 | $0.00 | $40.00 | | $0.00 | $0.00 | | | | | | | $40.00 |
| Light Bulbs/Electrical Supplies | $214.43 | $114.84 | $0.00 | $301.35 | $164.23 | $163.17 | $158.08 | $169.89 | $512.20 | $2,383.07 | $1,235.98 | $0.00 | $5,417.24 |
| Maintenace Equipment Repair | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $8.93 | $0.00 | $0.00 | $228.18 | $0.00 | $237.11 |
| Other Maintenance | $0.00 | $37.35 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $421.75 | $97.00 | $0.00 | $556.10 |
| Painting R&M | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $663.49 | $0.00 | $0.00 | $0.00 | $663.49 |
| Plumbing R&M | $2,200.00 | $0.00 | $1,755.00 | $4,220.00 | $385.00 | $0.00 | $2,940.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $11,500.00 |
| Plumbing Supplies | $0.00 | $693.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,600.00 | $0.00 | $166.27 | $0.00 | $4,459.27 |
| Turnover Suites | $0.00 | $0.00 | $0.00 | | $0.00 | $0.00 | $0.00 | -$631.40 | $631.40 | $0.00 | $0.00 | $0.00 | $0.00 |
| Water Softner System - Supplies | $479.14 | $635.63 | $1,172.26 | $404.42 | $546.13 | $531.21 | $464.08 | $530.35 | $367.14 | $411.88 | $411.88 | $644.43 | $6,598.55 |
| Total Maintenance & Repair -B- Operating Expenses | $11,838.35 | $6,773.47 | $10,019.80 | $16,503.13 | $7,556.03 | $10,549.13 | $9,742.23 | $17,472.16 | $26,852.39 | $19,037.41 | $12,279.89 | $1,186.63 | $149,810.62 |
| Marketing -A- Payroll |
| Employee Benefits Other - Marketing | -$267.13 | $302.80 | $271.10 | $504.63 | $488.37 | $291.68 | $503.25 | $489.63 | $508.66 | $492.26 | $508.67 | $82.04 | $4,175.96 |
| Employment Screenings - Marketing | $0.82 | $0.62 | $4.31 | $6.09 | $0.00 | $0.60 | $9.99 | $0.41 | $3.09 | $6.97 | $0.00 | $0.00 | $32.90 |
| Holiday Pay - Marketing | $163.59 | $205.09 | $184.34 | $0.00 | $114.66 | $114.66 | $388.66 | $29.90 | $0.00 | $0.00 | $0.00 | $0.00 | $1,200.90 |
| Marketing Director | $3,886.56 | $3,396.53 | $4,081.39 | $4,081.72 | $4,950.06 | $5,081.73 | $3,370.71 | $4,423.73 | $4,311.74 | $4,825.14 | $6,427.00 | $731.57 | $49,567.88 |
| Move-In Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,546.05 | $2,546.05 |
| Overtime - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $98.49 | $11.70 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $110.19 |
| Payroll Taxes - Marketing | $411.87 | $440.34 | $275.38 | $391.78 | $918.87 | $761.69 | $666.52 | $453.47 | $271.97 | $263.72 | $683.94 | $117.10 | $5,656.65 |
| PTO/Sick Leave Wages - Marketing | $293.10 | $628.58 | -$225.09 | $1,040.94 | $0.00 | $0.00 | $539.84 | $13.17 | $0.00 | $0.00 | $0.00 | $0.00 | $2,290.54 |
| Sales Counselor - Marketing | $0.00 | $0.00 | -$440.91 | $67.55 | $6,514.26 | $3,311.56 | $3,072.18 | $1,036.83 | $0.00 | $0.00 | $0.00 | $359.68 | $13,921.15 |
| Total Marketing -A- Payroll | $4,488.81 | $4,973.96 | $4,150.52 | $6,092.71 | $12,986.22 | $9,660.41 | $8,562.85 | $6,447.14 | $5,095.46 | $5,588.09 | $7,619.61 | $3,836.44 | $79,502.22 |
| Marketing -B- Operating Expenses |
| Advertising | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $416.00 | $225.00 | $0.00 | $0.00 | $995.00 | $258.98 | $1,894.98 |
| Collateral | $768.14 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $168.79 | $0.00 | $1,865.75 | $0.00 | $0.00 | $1,212.97 | $4,015.65 |
| Community Outreach | $0.00 | $37.35 | $0.00 | $0.00 | $0.00 | $260.90 | $178.62 | $244.33 | $451.25 | $0.00 | $0.00 | $0.00 | $1,172.45 |
| Consultants - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,163.24 | $0.00 | $0.00 | $0.00 | $0.00 | $4,163.24 |
| Contract Labor - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,900.00 | $0.00 | $0.00 | $0.00 | $1,900.00 |
| Digital Media | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $10,227.08 | $0.00 | $0.00 | $0.00 | $0.00 | $10,227.08 |
| Direct Mail | $140.66 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,015.80 | $975.00 | $0.00 | $7,631.25 | $10,762.71 |
| Dues & Subscriptions - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $100.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $100.00 |
| E-Mail Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Event Outreach Flyers | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $84.50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $84.50 |
| Events | $133.93 | $0.00 | $134.51 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $223.93 | $114.71 | $0.00 | $607.08 |
| Furniture & Equip Non CapX - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,526.65 | $203.56 | $0.00 | $82.25 | $0.00 | $0.00 | $2,812.46 |
| Leads/CRM | $5,169.95 | $579.57 | $579.57 | $896.57 | $579.57 | $597.00 | $579.57 | $436.00 | $0.00 | $554.15 | $1,130.40 | $218.75 | $11,321.10 |
| Lunch & Learn VA Seminar | $0.00 | $39.65 | $0.00 | $0.00 | $0.00 | $388.60 | | | | | | | $428.25 |
| Marketing Plan Development | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $176.19 | $0.00 | $0.00 | $176.19 |
| Move-In / Resident Gifts | $0.00 | $0.00 | $0.00 | $23.37 | $30.44 | $0.00 | | | | | | | $53.81 |
| Paid Placement Search Marketing | $1,249.86 | $5,735.95 | $5,735.98 | $5,735.98 | $6,110.92 | $6,601.60 | $6,298.63 | $0.00 | $966.87 | $966.87 | $0.00 | $3,093.13 | $42,495.79 |
| Premiums/Giveaways | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $100.66 | | | | | | | $100.66 |
| Print AD Development / Updates | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Prospect Gifts/Meals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $71.60 | | | | | | | $71.60 |
| Public Relations | $0.00 | $0.00 | $199.92 | $19.98 | $0.00 | $0.00 | $0.00 | $104.71 | $21.65 | $0.00 | $0.00 | $0.00 | $346.26 |
| Referral Fees | $0.00 | $0.00 | $2,800.00 | $0.00 | $5,950.00 | $600.00 | $0.00 | $0.00 | $0.00 | $8,000.00 | $0.00 | $2,500.00 | $19,850.00 |
| Social Media Marketing & Oversight | $987.29 | $988.38 | $988.37 | $988.38 | $988.38 | $1,454.00 | $1,363.48 | $0.00 | $635.37 | $2,041.62 | $0.00 | $666.62 | $11,101.89 |
| Supplies - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $41.44 | $7.57 | $880.00 | $412.98 | $0.00 | $0.00 | $1,341.99 |
| Traditional Media | $510.13 | $718.31 | $622.29 | $1,022.76 | $112.53 | $200.00 | $187.55 | $0.00 | $0.00 | $195.00 | $0.00 | $0.00 | $3,568.57 |
| Travel - Marketing | $1,760.63 | $0.00 | $0.00 | $0.00 | $0.00 | $259.60 | $0.00 | $0.00 | $0.00 | $0.00 | $488.57 | $0.00 | $2,508.80 |
| Travel Meals - Marketing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $228.11 | $0.00 | $228.11 |
| Website Hosting | $234.44 | $224.62 | $234.44 | $342.15 | $913.83 | $798.00 | $223.18 | $0.00 | $4,282.81 | $195.31 | $0.00 | $195.31 | $7,644.09 |
| Total Marketing -B- Operating Expenses | $11,383.11 | $8,323.83 | $11,295.08 | $9,029.19 | $14,685.67 | $11,331.96 | $12,168.41 | $15,611.49 | $13,019.50 | $13,823.30 | $2,956.79 | $15,777.01 | $139,405.34 |
| Memory Care -A- Payroll |
| Bonuses - MC | $0.00 | $0.00 | $0.00 | $50.00 | $0.00 | $25.00 | $551.79 | $198.21 | $0.00 | $0.00 | $0.00 | $0.00 | $825.00 |
| Employee Benefits Other - MC | -$203.96 | $214.73 | $9.44 | $11.60 | $14.42 | $5.21 | $12.20 | $34.45 | $313.88 | $466.31 | $1,128.21 | $223.92 | $2,230.41 |
| Employment Screenings - MC | $1.84 | $8.93 | $11.02 | $11.38 | $0.00 | $8.18 | $27.20 | $24.90 | $6.11 | $20.78 | $0.00 | $0.00 | $120.34 |
| Holiday Pay - MC | $1,095.50 | $1,383.76 | $934.87 | $0.00 | $349.95 | $349.96 | $554.40 | $72.87 | $392.84 | $0.00 | $0.00 | $0.00 | $5,134.15 |
| Overtime - MC | $909.30 | $465.19 | $431.73 | $1,224.61 | $788.27 | $1,207.60 | $1,664.67 | $777.09 | $472.72 | $555.25 | $1,569.28 | $311.81 | $10,377.52 |
| Payroll Taxes - MC | $1,123.07 | $1,355.88 | $1,120.68 | $1,249.31 | $968.15 | $1,294.00 | $1,472.87 | $1,120.56 | $898.18 | $742.39 | $1,390.06 | $296.81 | $13,031.96 |
| PTO/Sick Leave Wages - MC | $240.16 | $1,179.84 | $259.01 | $1,175.69 | $258.73 | $594.50 | $0.00 | $162.40 | $126.71 | $300.28 | $656.73 | $201.74 | $5,155.79 |
| Salaries & Wages MC CNA/Res Assistant | $3,610.18 | $3,614.80 | $6,261.40 | $6,412.15 | $5,254.73 | $5,811.45 | $5,857.50 | $4,631.02 | $4,888.60 | $7,584.26 | $7,662.85 | $1,320.79 | $62,909.73 |
| Salaries & Wages MC Med Tech | $4,106.74 | $7,607.67 | $4,510.24 | $4,851.29 | $3,934.20 | $5,815.69 | $6,255.34 | $5,044.90 | $4,026.56 | $2,151.45 | $3,072.58 | $931.49 | $52,308.15 |
| Salary & Wages - MC | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,988.00 | $5,988.00 |
| Total Memory Care -A- Payroll | $10,882.83 | $15,830.80 | $13,538.39 | $14,986.03 | $11,568.45 | $15,111.59 | $16,395.97 | $12,066.40 | $11,125.60 | $11,820.72 | $15,479.71 | $9,274.56 | $158,081.05 |
| Memory Care -B- Operating Expenses |
| Wellness Supplies MC | $125.00 | $0.00 | $129.08 | $0.00 | $132.65 | $209.82 | $162.82 | $168.00 | $234.48 | $360.00 | $4.73 | $0.00 | $1,526.58 |
| Total Memory Care -B- Operating Expenses | $125.00 | $0.00 | $129.08 | $0.00 | $132.65 | $209.82 | $162.82 | $168.00 | $234.48 | $360.00 | $4.73 | $0.00 | $1,526.58 |
| Resident Services -A- Payroll |
| Activities Aid - Lifestyles | $1,382.77 | $2,017.99 | $1,978.36 | $2,118.72 | $1,784.51 | $1,704.02 | $1,960.73 | $1,856.76 | $1,813.25 | $1,973.71 | $2,652.21 | $412.28 | $21,655.31 |
| Director / Manager - Lifestyles | -$156.32 | $5,923.22 | $6,386.94 | $6,002.67 | $6,445.95 | $6,442.74 | $5,901.88 | $6,621.42 | $5,345.72 | $6,261.20 | $9,218.13 | $1,647.36 | $66,040.91 |
| Employee Appreciation - Lifestyles | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $17.32 | $0.00 | $0.00 | $0.00 | $0.00 | $17.32 |
| Employee Benefits Other - Lifestlyes | $516.51 | $1,837.68 | $2,469.05 | $2,551.36 | $2,469.08 | $1,429.90 | $2,551.37 | $2,427.28 | $2,465.03 | $2,385.51 | $2,305.12 | $362.82 | $23,770.71 |
| Employment Screenings - Lifestyles | $0.42 | $1.18 | $8.37 | $8.77 | $0.00 | $0.66 | $3.25 | $0.59 | $4.81 | $10.42 | $0.00 | $0.00 | $38.47 |
| Holiday Pay - Lifestyles | -$697.33 | $1,143.21 | $458.59 | $0.00 | $74.11 | $74.11 | $426.54 | $43.26 | $135.85 | $0.00 | $0.00 | $0.00 | $1,658.34 |
| Payroll Taxes - Lifestyles | -$87.62 | $1,322.71 | $670.81 | $696.47 | $660.22 | $688.18 | $690.91 | $713.53 | $653.40 | $597.52 | $1,334.64 | $226.25 | $8,167.02 |
| PTO/Sick Leave Wages - Lifestlyes | $1,231.07 | $999.85 | -$55.23 | $982.91 | $325.84 | $775.08 | $718.93 | $171.97 | $1,543.14 | $263.37 | $568.73 | $49.03 | $7,574.69 |
| Total Resident Services -A- Payroll | $3,069.79 | $13,245.84 | $11,916.89 | $12,360.90 | $11,759.71 | $11,114.69 | $12,253.61 | $11,852.13 | $11,961.20 | $11,491.73 | $16,078.83 | $2,697.74 | $129,803.06 |
| Resident Services -B- Operating Expenses |
| Contract Entertainment | $233.40 | $0.00 | $60.00 | $115.00 | $115.00 | $125.00 | | | | | | | $648.40 |
| Decorations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $57.98 | $102.44 | $0.00 | $160.42 |
| Food - Lifestyles | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4.48 | $27.79 | $91.34 | $116.78 | $0.00 | $0.00 | $240.39 |
| MC Program Engagement | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $16.34 | $0.00 | $0.00 | $16.34 |
| Office Supplies | $0.00 | $236.95 | $0.00 | $0.00 | $91.66 | $0.00 | | | | | | | $328.61 |
| Operating Supplies | $57.60 | $187.69 | $43.59 | $0.00 | $361.41 | $136.64 | $145.40 | $32.35 | $45.47 | $29.23 | $0.00 | $234.61 | $1,273.99 |
| Resident Activities/Entertainment | $0.00 | $0.00 | $80.00 | $139.74 | $160.00 | $0.00 | $220.00 | $288.94 | $671.91 | $770.62 | $275.76 | $168.01 | $2,774.98 |
| Special Events (Non Marketing) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $30.16 | $483.26 | $1.07 | $0.00 | $514.49 |
| Total Resident Services -B- Operating Expenses | $291.00 | $444.22 | $183.59 | $254.74 | $728.07 | $261.64 | $369.88 | $349.08 | $838.88 | $1,474.21 | $379.27 | $402.62 | $5,977.20 |
| Transportation -A- Payroll |
| Drivers | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $587.97 | $934.06 | $1,153.43 | $1,142.97 | $1,011.59 | $1,705.05 | $260.42 | $6,795.49 |
| Employment Screenings - Transportation | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.38 | $0.07 | $0.68 | $1.47 | $0.00 | $0.00 | $2.60 |
| Payroll Taxes - Transportation | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $63.09 | $100.22 | $123.77 | $105.50 | $65.69 | $182.95 | $17.62 | $658.84 |
| Total Transportation -A- Payroll | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $651.06 | $1,034.66 | $1,277.27 | $1,249.15 | $1,078.75 | $1,888.00 | $278.04 | $7,456.93 |
| Transportation -B- Operating Expenses |
| Vehicle Fuel | $90.00 | $142.77 | $45.00 | $235.55 | $123.85 | $135.58 | $126.15 | $116.35 | $116.85 | $49.55 | $120.65 | $0.00 | $1,302.30 |
| Vehicle Lease - Bus & Van | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,342.80 | $0.00 | $0.00 | $0.00 | $0.00 | $2,342.80 |
| Vehicle Maintenance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $163.03 | $178.62 | $0.00 | $0.00 | $37.13 | $378.78 |
| Vehicle Tag | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $179.25 | $0.00 | $179.25 |
| Total Transportation -B- Operating Expenses | $90.00 | $142.77 | $45.00 | $235.55 | $123.85 | $135.58 | $126.15 | $2,622.18 | $295.47 | $49.55 | $299.90 | $37.13 | $4,203.13 |
| Utilities, Insurance and Other |
| Insurance | | $0.00 | $0.00 |
| Insurance - Auto | $159.83 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | $264.13 | -$901.87 | $1,899.26 |
| Insurance - General/Professional Liability | $3,568.40 | $2,287.28 | $2,287.28 | $8,455.71 | $8,455.71 | $8,455.71 | $8,455.71 | $9,294.99 | $9,294.99 | $9,294.99 | $9,294.99 | $2,979.65 | $82,125.41 |
| Insurance - Property | $3,782.12 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,153.56 | $3,250.77 | $38,568.49 |
| Insurance - Umbrella/Excess | $1,666.84 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $1,080.34 | $13,550.58 |
| Total Insurance | $9,177.19 | $6,785.31 | $6,785.31 | $12,953.74 | $12,953.74 | $12,953.74 | $12,953.74 | $13,793.02 | $13,793.02 | $13,793.02 | $13,793.02 | $6,408.89 | $136,143.74 |
| Management Fees |
| Management Fee | $7,500.00 | $8,301.77 | $7,000.00 | $9,379.00 | -$8,466.44 | $9,019.00 | $667.56 | $8,281.24 | $8,888.43 | $12,000.00 | $15,966.44 | $16,771.80 | $95,308.80 |
| Total Management Fees | $7,500.00 | $8,301.77 | $7,000.00 | $9,379.00 | -$8,466.44 | $9,019.00 | $667.56 | $8,281.24 | $8,888.43 | $12,000.00 | $15,966.44 | $16,771.80 | $95,308.80 |
| Taxes |
| Taxes Real Estate | $17,637.32 | $0.00 | $0.00 | $0.00 | $0.00 | $51.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $17,688.32 |
| Total Taxes | $17,637.32 | $0.00 | $0.00 | $0.00 | $0.00 | $51.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $17,688.32 |
| Utilities |
| Cable TV | $87.88 | $87.88 | $89.34 | $92.06 | $263.64 | $0.00 | $0.00 | $0.00 | $0.00 | $1,127.86 | $985.17 | $1,974.48 | $4,708.31 |
| Electricity | $5,596.90 | $5,844.17 | $6,476.33 | $8,594.56 | -$9,111.89 | $7,707.22 | $15,487.49 | $7,891.50 | $7,970.92 | $7,479.41 | $5,838.30 | -$181.57 | $69,593.34 |
| Gas | $427.46 | $419.14 | $389.65 | $278.80 | $233.00 | $78.53 | $206.16 | $627.93 | $218.66 | $375.25 | $476.13 | -$155.29 | $3,575.42 |
| Telephone & Internet Communications | $535.45 | $3,911.15 | $961.70 | $5,595.90 | $910.35 | $2,402.37 | $542.98 | $3,446.23 | $3,058.90 | $1,466.55 | $2,310.46 | $614.32 | $25,756.36 |
| Trash Removal | $546.40 | $546.40 | $546.40 | $546.40 | $546.40 | $546.40 | $546.40 | $546.40 | $1,092.80 | $0.00 | $0.00 | $0.00 | $5,464.00 |
| Water & Sewer | $6,567.10 | $4,569.93 | $6,802.26 | $6,606.03 | $2,300.70 | $5,607.08 | $3,508.12 | $6,188.02 | $5,000.00 | $4,309.47 | $4,039.88 | -$122.83 | $55,375.76 |
| Total Utilities | $13,761.19 | $15,378.67 | $15,265.68 | $21,713.75 | -$4,857.80 | $16,341.60 | $20,291.15 | $18,700.08 | $17,341.28 | $14,758.54 | $13,649.94 | $2,129.11 | $164,473.19 |
| Total Utilities, Insurance and Other | $48,075.70 | $30,465.75 | $29,050.99 | $44,046.49 | -$370.50 | $38,365.34 | $33,912.45 | $40,774.34 | $40,022.73 | $40,551.56 | $43,409.40 | $25,309.80 | $413,614.05 |
| Total Operating Expenses | $214,782.86 | $211,484.08 | $218,944.00 | $228,518.13 | $178,386.61 | $207,423.70 | $235,626.01 | $258,396.11 | $267,661.24 | $276,618.56 | $254,382.68 | $98,748.77 | $2,650,972.75 |
| Operating Income / (Loss) | -$25,357.34 | -$38,481.58 | -$49,927.75 | -$56,710.92 | -$20,353.91 | -$36,405.44 | -$68,709.51 | -$87,908.15 | -$100,579.68 | -$102,014.33 | -$78,760.89 | $30,509.65 | -$634,699.85 |
| Add-Backs |
| Management Company Travel Expense During Transition | | | | | | | | | | | $12,000.00 | $5,271.88 | $17,271.88 |
| Travel Expense for Department Head Training in Birmingham | | | | | | | | | | $4,105.20 | | | $4,105.20 | <- Executive director and other facility personnel flew to Birmingham for on-site training at manager's corporate office |
| IT Transition Expenses (computer setup, etc.) | | | | | | | -$262.16 | $368.48 | $474.20 | $582.54 | $1,326.14 | $709.90 | $3,199.10 | <- Stabilized IT expenses are $400 per month |
| One-time Marketing Expenses (website setup, initial mailing, etc.) | | | | | | | $4,668.41 | $8,111.49 | $5,519.50 | $6,323.30 | -$4,543.21 | $8,277.01 | $28,356.50 | <- Projected stabilized marketing expenses through year-end 2019 are $7,500 per month. This adjustment eliminates one-time marketing expenses such as web-site development, initial direct mailing, collateral development, etc. |
| Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,406.25 | $8,479.97 | $5,993.70 | $11,011.04 | $8,782.93 | $14,258.79 | $52,932.68 |
| NOI (Excluding Transition Costs) | -$25,357.34 | -$38,481.58 | -$49,927.75 | -$56,710.92 | -$20,353.91 | -$36,405.44 | -$64,303.26 | -$79,428.18 | -$94,585.98 | -$91,003.29 | -$69,977.96 | $44,768.44 | -$581,767.17 |
| Other Income and Expense |
| Unrealized Gain / (Loss) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Non-Operating Income/Expenses |
| Depreciation and Amortization | -$8,475.90 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$22,851.63 | -$259,843.83 |
| Interest Expense | -$16,557.81 | -$18,559.12 | -$18,559.12 | -$18,559.12 | -$18,559.12 | -$18,559.12 | -$18,559.12 | -$111,354.74 | $0.00 | $0.00 | $0.00 | $0.00 | -$239,267.27 | <- monthly interest expense is $18,559. There was a true-up in June for the first 6 months of the year |
| Legal Expense (Acquisition & Licensing) | -$590.95 | | | -$501.67 | $0.00 | -$2,752.50 | $0.00 | $0.00 | -$6,392.44 | $0.00 | $0.00 | $0.00 | -$10,237.56 | <- one-time legal fees related to acquisition and licensing |
| Marketing Cost - Start Up | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Professional Fees - Property Tax Exemption Application | $0.00 | | | $0.00 | $0.00 | $0.00 | -$8,277.23 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$8,277.23 | <- one-time fees related to property tax exemption application |
| Owner Other Expense | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$1,051.29 | -$1,051.29 |
| Start Up Cost | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$17.17 | $0.00 | $0.00 | -$17.17 |
| Vendor Rebates | $593.59 | $0.00 | $392.19 | $478.19 | $0.00 | $0.00 | | | | | | | $1,463.97 |
| Total Non-Operating Income/Expenses | -$25,031.07 | -$41,410.75 | -$41,018.56 | -$41,434.23 | -$41,410.75 | -$44,163.25 | -$49,687.98 | -$134,206.37 | -$29,244.07 | -$22,868.80 | -$22,851.63 | -$23,902.92 | -$517,230.38 |
| Total Other Income and Expense | -$25,031.07 | -$41,675.75 | -$41,084.56 | -$41,434.23 | -$41,410.75 | -$44,163.25 | -$49,687.98 | -$134,206.37 | -$29,244.07 | -$22,868.80 | -$22,851.63 | -$23,902.92 | -$517,561.38 |
| Net Income / (Loss) before Tax | -$50,388.41 | -$80,157.33 | -$91,012.31 | -$98,145.15 | -$61,764.66 | -$80,568.69 | -$118,397.49 | -$222,114.52 | -$129,823.75 | -$124,883.13 | -$101,612.52 | $6,606.73 | -$1,152,261.23 |
| Add-Backs |
| One-time Legal Expenses Related to Acquisition & Licensing | | | | | | | | | $6,392.44 | | | | $6,392.44 |
| One-time Professional Fees Related to Prop. Tax Exemption App. | | | | | | | $8,277.23 | | | | | | $8,277.23 |
| Other Start-Up Costs | | | | | | | | | | $17.17 | | | $17.17 |
| Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $8,277.23 | $0.00 | $6,392.44 | $17.17 | | | $14,686.84 |
| Net Income / (Loss) Excluding Transition Costs | -$50,388.41 | -$80,157.33 | -$91,012.31 | -$98,145.15 | -$61,764.66 | -$80,568.69 | -$105,714.01 | -$213,634.55 | -$117,437.61 | -$113,854.92 | -$92,829.59 | $20,865.52 | -$1,084,641.71 |
Syjdjc
CopyofVenturaHillsT12Jan2020.xls
