Answer the following questions on this sheet using the childcare budget sheets: 1. Does the setup of the components/categories on these budget sheets help you to see the financial status of the childcare centers? Explain your answer. 2. Which category/component listed on both sheets is more important to keep track of from month to month? Explain. 3. Are there other categories/components that you would add/identify to at least one of these budget sheets? Explain your answer. 4. Do either of these budget sheets account for emergency situations? Explain. 5. What line items/components would you consider for cutting expenses on the "Felton Family Preschool Monthly Budget?" Explain. 6. Are there revenue possibilities not being explored/listed on either budget sheet? Explain. 7. Are there expense categories missing on the "Sample Child Care Center Budget?" Explain.dows Go to Settings to activate 8. Are these balanced budgets? Explain. Source: From JACK, The Business of Child Care, 1E. O Cengage Learning. 1 2 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 29 31 32 33 34 35 36 INCOME Tuition Fund-Raising County Grant Other 37 TOTAL INCOME Allow. Rent Janitor 26 27 Insurance Liability Accident Directors. Ins. Supplies Utilities EXPENSE Payroll Expense Salaries- Staff Payroll Taxes Worker's Comp Staff Benefits Health Ins. Dental Ins Education Capital Improvement TOTAL EXPENSES SURPLUS (DEFICIT) D "Reasonable" Budget A3 344,235 3,500 27,000 2,000 376,735 270,000 24,300 13,500 27,250 4,000 875 4,800 6,000 2,914 1,575 944 15,000 2,835 2,000 375,993 742 E 27,708 22,759 25,000 28,000 30,000 292 292 292 2,250 2,250 2,250 167 167 167 2,048 September October November December January February 1,138 2,271 333 73 400 500 243 131 79 1,250 236 0 F (3,753) 30,708 32,708 23,793 20,690 1,190 G 2,141 1,862 2,271 333 73 Felton Family Preschool Monthly Budget 400 500 243 131 79 1,250 236 0 1,034 2,271 333 73 400 500 243 131 79 1,250 236 1,000 31,461 32,640 30,102 (1,932) 2,606 H 30,000 30,000 30,000 292 292 292 2,250 2,250 2,250 167 167 167 32,708 23,793 2,141 1,190 2,271 333 73 400 500 243 131 79 1,250 236 O 32,640 68 32,708 32,708 23,793 20,690 2,141 1,862 1,190 J 243 131 79 1,250 236 2,271 2,271 333 333 73 400 400 500 500 O 1,034 68 73 243 131 79 1,250 236 0 32,640 29,102 3,606 K March 1,955 32,708 32,708 32,708 21,724 22,759 22,759 2,271 333 73 400 500 30,000 30,000 30,000 27,078 27,078 292 292 292 292 292 2,250 2,250 2,250 2,250 2,250 167 167 167 167 167 243 131 L 1,086 1,138 1,138 79 1,250 236 April May 1,000 31,282 M 2,048 2,048 2,271 2,271 333 333 73 400 500 243 131 79 1,250 236 O 31,461 73 400 500 243 131 79 1,250 236 O 31,461 N 1,427 1,247 1,247 June O July 1,955 2,141 29,787 29,787 29,787 1,086 1,190 243 131 21,724 23,793 21,724 2,271 2,271 333 333 73 400 500 79 O (495) 73 400 500 243 131 1,250 1.250 236 236 79 p August 0 27,078 292 2,250 167 1,955 1,086 2,271 333 73 400 500 243 131 79 1,250 236 0 30,282 32,640 30,282 (2,854) (495) SPREADSHEET HYPOTHETICAL BUDGET BY MONTH CREATED ON DIRECTOR'S RESOURCE 5-4 06 Chapter 5 INCOME Tuition Infants (8 x $160 51) Toddlers (12 $150 51) Preschoolers (51 x $135 x 51) Total Gross Tuition: Discounts Vacancy (3%) Total Discounts: Other Income Application Fees (30 x $20) Interest on Account Fund-Raisers Grant Award (Literacy Program) Total Other Income: Total Income: EXPENSES Personnel DIRECTOR'S RESOURCE 5-1 SAMPLE CHILD CARE CENTER BUDGET - Director Head Teachers (5) Teachers (5) Assistants (10 part-time) Substitutes Secretary Custodian Cook FICA, Workers' Comp., Unemploy., and Insurance Total Personnel: Rent Utilities and Telephone Advertising Food Office Supplies Custodial Supplies Classroom Equipment and Supplies C.P.A. Fees Insurance Licenses Staff Development/Training Teachers' Petty Cash Total Nonpersonnel: Total: TeachSource Digital Download $65,280 91,800 351,135 600 600 1,000 2,500 30,000 135,000 100,000 46,800 2,000 8,000 7,000 8,000 62,500 Handling Financial Matters 31,000 17,465 1,000 35,000 1,000 700 5,200 1,000 3,500 500 1,500 504 508,215 4,700 $497,669 $399,300 98,369 $497,669 87