Assignment 2: Administrative Costs - AU ACC202
iloeja
M2_A2_Discussion_CalculatingRevenue.xlsxSheet1
| Month | Column1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| No of Children-Full-time | 8 | 10 | 12 | 10 | 12 | 14 | 15 | 12 | 15 | 17 | 18 | 15 | |
| No of Children - Part-Time | 2 | 1 | 2 | 5 | 1 | 3 | 5 | 2 | 3 | 5 | 4 | 1 | |
| Total No of Children | 10 | 11 | 14 | 15 | 13 | 17 | 20 | 24 | 18 | 22 | 22 | 16 | |
| Amount Charged ($) | |||||||||||||
| Registration Fee | $25 | ||||||||||||
| Full -Time | $200 | $250 | $300 | $250 | $300 | $350 | $375 | $300 | $375 | $425 | $450 | $375 | |
| Part-Time | $50 | $25 | $50 | $125 | $25 | $75 | $125 | $50 | $75 | $125 | $100 | $25 | |
| Tuition Fee | $36 | $360 | $396 | $504 | $540 | $468 | $612 | $720 | $864 | $648 | $792 | $792 | $576 |
| Total Revenue | $610 | $671 | $854 | $915 | $793 | $1,037 | $1,220 | $1,214 | $1,098 | $1,342 | $1,342 | $976 | |
| Annual Total Revenue | $12,072 |
