Treasurer's Report6/26/2007 Page 1 Concordia Lutheran Church11:31a June of Fiscal Year 2007 Responsibility: All Fund: 02 - Preschool June Year-to-date Annual Percent of Actual Actual Budget Budget Income Minor: Group 00 Tuition (All-Day) 6,663.79 118,768.83 137,500.00 86.38% Registration (All-Day) 0.00 1,345.00 2,000.00 67.25% Tuition (Part-Day) 1,485.00 10,791.00 12,500.00 86.33% Registration (Part-Day) 0.00 50.00 0.00 0.00% Extended Care 839.90 15,485.25 10,800.00 143.38% Interest Income 3.38 9.38 20.00 46.90% Misc Inc 0.00 0.00 400.00 0.00% Group 00 Total 8,992.07 146,449.46 163,220.00 89.73% Total Income 8,992.07 146,449.46 163,220.00 89.73% Expense Minor: Salary Exp Accrued Salary Exp 0.00 0.00 0.00 0.00% Salary Exp Total 0.00 0.00 0.00 0.00% Minor: All-Day Teacher Salary (All-Day 1) 2,477.91 27,290.03 28,000.00 97.46% Housing (All-Day 1) 0.00 0.00 0.00 0.00% All-Day Teacher Total 2,477.91 27,290.03 28,000.00 97.46% Minor: 2nd All-Day Teacher Salary (All-Day 2) 2,318.28 24,474.91 17,800.00 137.50% 2nd All-Day Teacher Total 2,318.28 24,474.91 17,800.00 137.50% Minor: Aid (All-Day) Salary (All-Day Aide) 1,875.79 22,262.92 15,000.00 148.42% Aid (All-Day) Total 1,875.79 22,262.92 15,000.00 148.42% Minor: Salary (All-Day Subs) Salary (All-Day Subs) 100.08 905.01 1,550.00 58.39% Salary (All-Day Subs) Total 100.08 905.01 1,550.00 58.39% Minor: Part-Day Teacher Salary (Part-Day) 0.00 0.00 0.00 0.00% TSA (Part-Day) 0.00 0.00 0.00 0.00% Housing (Part-Day) 943.52 11,297.22 11,322.00 99.78% Part-Day Teacher Total 943.52 11,297.22 11,322.00 99.78% Minor: Aid (Part-Day) Salary (Part-Day Aide) 0.00 489.21 2,900.00 16.87% Aid (Part-Day) Total 0.00 489.21 2,900.00 16.87% Minor: Salary (Part-Day Subs) Salary (Part-Day Subs) 0.00 170.39 200.00 85.20% Salary (Part-Day Subs) Total 0.00 170.39 200.00 85.20% Minor: Ext Care 1 Salary (Ext Care 1) 195.04 3,775.09 4,750.00 79.48% Ext Care 1 Total 195.04 3,775.09 4,750.00 79.48% Minor: Ext Care 2 Salary (Ext Care 2) 87.43 1,892.55 2,275.00 83.19% Ext Care 2 Total 87.43 1,892.55 2,275.00 83.19% Minor: Ext Care Subs Salary (Ext Care Subs) 0.00 0.00 0.00 0.00% Ext Care Subs Total 0.00 0.00 0.00 0.00% Minor: WBP WBP (All-Day 1) 193.72 2,404.91 2,237.00 107.51% WBP (All-Day 2) 180.21 1,629.57 1,320.00 123.45% WBP (All-Day Aide) 159.61 1,527.42 867.00 176.17% WBP (Part-Day) 0.00 0.00 0.00 0.00% WBP (Part-Day Aide) 0.00 0.00 0.00 0.00% WBP (Ext Care 1) 0.00 0.00 0.00 0.00% WBP Total 533.54 5,561.90 4,424.00 125.72% Minor: Worker Comp Worker Comp (All-Day) 44.70 494.65 412.00 120.06% Worker Comp (Part-Day) 6.22 78.82 95.00 82.97% Worker Comp (Ext Care) 1.87 37.41 46.00 81.33% Worker Comp Total 52.79 610.88 553.00 110.47% Minor: FICA FICA (All-Day) 518.06 5,745.51 4,770.00 120.45% FICA (Part-Day) 0.00 70.29 237.00 29.66% FICA (Ext Care) 21.61 413.77 537.00 77.05% FICA Total 539.67 6,229.57 5,544.00 112.37% Minor: Other Expenses Advertising Exp 100.00 100.00 500.00 20.00% Insurance (All-Day) 0.00 0.00 0.00 0.00% Insurance (Part-Day) 0.00 0.00 0.00 0.00% Insurance (Ext Care) 0.00 0.00 0.00 0.00% Utilities (All-Day) 550.00 6,600.00 6,600.00 100.00% Utilities (Part-Day) 141.67 1,700.04 1,700.00 100.00% Utilities (Ext Care) 141.66 1,699.92 1,700.00 100.00% Admin Reimburse 183.33 2,199.96 2,200.00 100.00% Telephone 0.00 0.00 300.00 0.00% Conferences/Workshops 0.00 105.59 400.00 26.40% Repairs (All-Day) 0.00 55.00 200.00 27.50% Repairs (Part-Day) 0.00 0.00 0.00 0.00% Repairs (Ext Care) 0.00 0.00 0.00 0.00% Equip (All-Day) 0.00 932.12 500.00 186.42% Equip (Part-Day) 0.00 0.00 0.00 0.00% Equip (Ext Care) 0.00 0.00 0.00 0.00% Lunches (All-Day) 1,842.00 21,335.00 24,000.00 88.90% Supplies (All-Day) -25.00 1,442.17 3,000.00 48.07% Supplies (Part-Day) 0.00 130.94 300.00 43.65% Milk (Part-Day) 0.00 0.00 400.00 0.00% Snacks/Supplies (Ext Care 0.00 542.83 1,000.00 54.28% Bank Charges 0.00 0.00 0.00 0.00% Postage 0.00 0.00 0.00 0.00% Other Expenses Total 2,933.66 36,843.57 42,800.00 86.08% Total Expenses 12,057.71 141,803.25 137,118.00 103.42% Income Less Expense -3,065.64 4,646.21 26,102.00 (* = Inactive)