Staff Pay Scale: Remember that you must staff your center and meet all requirements according to the regulations set out in the Childcare and Early Years Act(ensure you account for Supervisor, Cook, cleaning staff, part-time staff if needed to cover break
Michelle_Michy
attachment_12.xlsxHome>Business & Finance homework help>Accounting homework help>Staff Pay Scale: Remember that you must staff your center and meet all requirements according to the regulations set out in the Childcare and Early Years Act(ensure you account for Supervisor, Cook, cleaning staff, part-time staff if needed to cover break
Sheet1
| No. of Children | |||||||||||||
| Age group | Adult:Child Ratio | No. of Children | No. of Caregivers | ||||||||||
| 0 - 1 | 1 : 3 | 6 | 2 | ||||||||||
| 1 - 2 | 1 : 5 | 10 | 2 | ||||||||||
| 2 - 3 | 1 : 6 | 18 | 3 | ||||||||||
| 3 - 5 | 1 : 8 | 16 | 2 | ||||||||||
| 50 | 9 | ||||||||||||
| Income | Age group | No. of Children | Monthly fee | Parent fees | Subsidy | Total Monthly fees | |||||||
| 0 - 1 | 6 | $ 1,500.00 | $ 7,650.00 | $ 1,350.00 | $ 9,000.00 | ||||||||
| 1 - 2 | 10 | $ 1,350.00 | $ 11,475.00 | $ 2,025.00 | $ 13,500.00 | ||||||||
| 2 - 3 | 18 | $ 1,450.00 | $ 22,185.00 | $ 3,915.00 | $ 26,100.00 | ||||||||
| 3 - 5 | 16 | $ 1,550.00 | $ 21,080.00 | $ 3,720.00 | $ 24,800.00 | ||||||||
| $ 62,390.00 | $ 11,010.00 | $ 73,400.00 | |||||||||||
| Payscale | Title | No. | Rate / Hr | Total Annual Hrs | Annual Total | ||||||||
| Supervisor | 1 | $ 20.00 | 2080 | $ 41,600.00 | |||||||||
| Caregiver Senior-level | 5 | $ 17.00 | 10400 | $ 176,800.00 | |||||||||
| Caregiver Entry-level | 4 | $ 16.00 | 8320 | $ 133,120.00 | |||||||||
| Cook | 2 | $ 15.00 | 4160 | $ 62,400.00 | |||||||||
| Cleaning Staff | 3 | $ 14.50 | 6240 | $ 90,480.00 | |||||||||
| Temporary | 1 | $ 14.00 | 400 | $ 5,600.00 | |||||||||
| $ 510,000.00 | |||||||||||||
| Assumptions | |||||||||||||
| Childcare centre is closed for two months holiday in a year, June and December | |||||||||||||
| Employer contributes 5% to a retirement fund on behalf of employees | |||||||||||||
| Caregivers attend a mandatory one week training twice a year during the holidays | |||||||||||||
| The centre has a capacity of 50 children and it was filled to capacity for the whole year except for January(90%), April(90%) and November (80%) | |||||||||||||
| Income and Expenses Worksheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | |
| Parents Fees | $ 56,151.00 | $ 62,390.00 | $ 62,390.00 | $ 56,151.00 | $ 62,390.00 | $ - 0 | $ 62,390.00 | $ 62,390.00 | $ 62,390.00 | $ 62,390.00 | $ 49,912.00 | $ - 0 | $ 598,944.00 |
| Subsidy | $ 9,909.00 | $ 11,010.00 | $ 11,010.00 | $ 9,909.00 | $ 11,010.00 | $ - 0 | $ 11,010.00 | $ 11,010.00 | $ 11,010.00 | $ 11,010.00 | $ 8,808.00 | $ - 0 | $ 105,696.00 |
| Total Monthly Fees | $ 66,060.00 | $ 73,400.00 | $ 73,400.00 | $ 66,060.00 | $ 73,400.00 | $ - 0 | $ 73,400.00 | $ 73,400.00 | $ 73,400.00 | $ 73,400.00 | $ 58,720.00 | $ - 0 | $ 704,640.00 |
| Expenses | |||||||||||||
| Payroll | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 42,500.00 | $ 510,000.00 |
| Rent | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | $ 48,000.00 |
| Water and Electricity | $ 3,400.00 | $ 3,250.00 | $ 3,900.00 | $ 3,850.00 | $ 3,200.00 | $ 350.00 | $ 3,200.00 | $ 3,450.00 | $ 3,600.00 | $ 3,500.00 | $ 3,200.00 | $ 400.00 | $ 35,300.00 |
| Training | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 1,500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 1,500.00 | $ 3,000.00 |
| Inspections | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 9,000.00 |
| Groceries | $ 4,100.00 | $ 4,200.00 | $ 3,900.00 | $ 3,850.00 | $ 4,000.00 | $ - 0 | $ 4,300.00 | $ 4,100.00 | $ 4,050.00 | $ 3,900.00 | $ 3,650.00 | $ - 0 | $ 40,050.00 |
| Supplies | $ 950.00 | $ 850.00 | $ 1,000.00 | $ 950.00 | $ 800.00 | $ - 0 | $ 1,000.00 | $ 850.00 | $ 950.00 | $ 800.00 | $ 950.00 | $ - 0 | $ 9,100.00 |
| Garbage Collection | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 185.00 | $ 2,220.00 |
| Repairs and Maintenance | $ 300.00 | $ 250.00 | $ 350.00 | $ 300.00 | $ 200.00 | $ 850.00 | $ 250.00 | $ 200.00 | $ 300.00 | $ 350.00 | $ 250.00 | $ 900.00 | $ 4,500.00 |
| Insurance | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 1,300.00 | $ 15,600.00 |
| Telephone | $ 350.00 | $ 450.00 | $ 400.00 | $ 350.00 | $ 400.00 | $ 70.00 | $ 350.00 | $ 400.00 | $ 500.00 | $ 450.00 | $ 400.00 | $ 70.00 | $ 4,190.00 |
| Fuel | $ 1,300.00 | $ 1,400.00 | $ 1,200.00 | $ 1,350.00 | $ 1,300.00 | $ 400.00 | $ 1,600.00 | $ 1,350.00 | $ 1,400.00 | $ 1,200.00 | $ 1,100.00 | $ 450.00 | $ 14,050.00 |
| Retirement fund | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 2,125.00 | $ 25,500.00 |
| TOTAL EXPENSES | $ 720,510.00 | ||||||||||||
| Annual Profit or Loss Statement | |||||||||||||
| Income | |||||||||||||
| Parent Fees | 598,944 | ||||||||||||
| Government Subsidy | 105,696 | ||||||||||||
| Total Income | 704,640 | ||||||||||||
| Expenses | |||||||||||||
| Payroll | 510,000 | ||||||||||||
| Rent | 48,000 | ||||||||||||
| Water and Electricity | 35,300 | ||||||||||||
| Training | 3,000 | ||||||||||||
| Inspections | 9,000 | ||||||||||||
| Groceries | 40,050 | ||||||||||||
| Supplies | 9,100 | ||||||||||||
| Garbage Collection | 2,220 | ||||||||||||
| Repairs and Maintenance | 4,500 | ||||||||||||
| Insurance | 15,600 | ||||||||||||
| Telephone | 4,190 | ||||||||||||
| Fuel | 14,050 | ||||||||||||
| Retirement fund | 25,500 | ||||||||||||
| Total Expenses | 720,510 | ||||||||||||
| Net Profit / (Loss) | (15,870) |
