Aarondale(AAR)

P&L 2017-YTD 2019

Jan-18 Feb-18 Mar-18 Apr-18 May-18

Fees 85,528 106,518 87,275 89,915 109,402
Other Income - - - - -
Care Staff 28,101 36,671 29,458 30,265 37,174
Agency/Agency Premium 10,510 - 4,115 - 313 - 5,510
Catering 4,300 5,895 4,234 4,808 5,420
Domestic & Laundry 3,083 3,919 2,470 2,930 3,844
Other Staff 6,084 9,377 6,293 7,250 7,772
Holiday Pay 4,419 5,427 4,341 4,542 5,578
Food 4,634 5,957 3,904 5,120 5,952
Incontinence Products 2 - 2 2 - 2 2
Medical Supplies 327 396 461 455 571
Laundry & Cleaning 606 780 696 769 1,041
Waste Disposal 455 786 540 506 597
Uniforms 159 - 14 26 127 117
Linen & Crockery - 116 184 57 -
Activities - 30 14 17 6
Stationery 160 74 349 275 220
Motor & Travel 162 283 138 288 204
Subscriptions & Training - 94 8 6 80 8
Marketing 131 225 403 165 309
Staff Advertising - 43 - - -
Sundry 12 71 49 39 131
Electricity 5,636 5,863 6,099 4,420 3,268
Gas/Oil - - - - -
Postage & Telephone 150 149 97 104 403
Water Rates 934 662 618 821 1,026
Council Tax 106 133 106 112 140
Insurances 596 745 596 596 745
Registration Fees 624 1,290 459 647 3,422
Contracts Maintenance 1,846 2,310 1,844 1,889 2,309
Response Maintenance 164 1,156 458 857 1,811
Gardening 2,160 - - - -
Total Expenses 18,772 21,060 17,051 17,343 22,282
Operating Profit 10,259 28,284 23,742 22,777 21,821

Statistics
Effective Beds 48 48 48 48 48
Ave Occupied Beds 39 38 39 40 39
Occupancy % 81.3% 79.8% 82.2% 82.7% 80.5%
Ave Weekly Fee 548 556 553 566 566
Payroll % of Turnover 66.1% 53.7% 53.3% 55.4% 59.7%
Agency % of Payroll 18.6% -7.2% -0.7% - 8.4%
Expenses % of Turnover 21.9% 19.8% 19.5% 19.3% 20.4%
Operating Profit % 12.0% 26.6% 27.2% 25.3% 19.9%
OP per Effective Bed pa 2,832 6,246 6,554 6,287 4,819
 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 FY 2018
87,664 87,847 107,801 83,131 85,655 104,359 66,105 1,101,200
- - - - - - - -
28,360 27,696 34,957 27,705 26,188 32,445 16,854 355,874
1,839 8,876 4,587 1,316 4,575 20,532 22,651 75,969
4,363 4,400 5,490 4,552 4,395 5,769 4,480 58,107
2,836 2,849 3,341 2,689 2,625 3,248 2,744 36,578
6,885 7,083 7,306 4,899 3,992 5,259 6,726 78,925
4,463 4,463 5,578 4,463 4,463 5,578 4,542 57,856
4,435 4,666 4,073 4,130 4,112 4,971 3,168 55,122
- 0 26 - 3 4 - 2 - 0 4 31
475 564 432 442 730 516 415 5,784
788 868 844 802 683 1,120 923 9,921
730 502 690 466 477 661 451 6,861
76 13 - 30 128 18 55 735
- - 169 - 61 69 55 711
18 7 21 - - 93 15 222
70 220 332 155 75 74 97 2,101
161 168 149 142 20 213 84 2,012
522 6 390 6 6 8 127 1,073
161 269 607 161 161 555 161 3,307
- - - - - - - 43
44 251 41 29 54 19 203 943
1,875 1,670 - 544 2,353 3,392 6,592 5,845 46,468
- - - - - - - -
121 146 155 94 97 129 109 1,755
821 313 1,766 854 1,049 1,129 903 10,896
112 112 140 112 112 140 112 1,437
596 596 523 596 325 745 596 7,257
595 559 759 715 703 726 573 11,074
1,872 1,940 2,312 1,859 1,862 2,327 1,847 24,217
816 73 586 363 179 1,628 - 598 7,493
21 19 - 1,380 - - - 3,580
14,307 12,988 13,443 14,696 14,224 21,733 15,144 203,042
24,611 19,491 33,099 22,812 25,194 9,795 - 7,036 234,849

48 48 48 48 48 48 48 48
39 39 39 38 39 38 29 38
82.1% 81.7% 80.5% 79.7% 80.4% 79.9% 61.2% 79%
556 560 558 543 555 544 563 556
55.6% 63.0% 56.8% 54.9% 54.0% 69.8% 87.7% 60%
3.8% 16.0% 7.5% 2.9% 9.9% 28.2% 39.1% 11.5%
16.3% 14.8% 12.5% 17.7% 16.6% 20.8% 22.9% 18.4%
28.1% 22.2% 30.7% 27.4% 29.4% 9.4% -10.6% 21.3%
6,794 5,380 7,309 6,297 6,955 2,163 - 1,942 58,712
 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19
59,195 70,562 55,987 55,068 68,940 59,092 63,032 100,408
- - 4 - - 4 - -
17,098 22,802 19,444 22,296 29,104 21,908 21,015 32,704
29,405 41,965 14,944 7,428 2,638 4,322 6,453 3,815
4,491 6,140 5,177 4,766 5,868 4,825 4,661 5,810
2,618 6,131 3,880 3,900 5,385 3,390 3,264 5,198
2,583 4,201 8,102 7,262 9,331 10,196 8,476 9,143
4,422 5,431 4,345 4,588 5,634 4,508 4,508 5,634
2,802 3,453 2,814 2,522 3,323 2,528 2,764 4,015
- 3 3 - 2 4 - 1 - 3 9 - 3
650 200 95 239 244 140 507 364
888 952 549 745 801 732 1,015 942
431 626 427 459 655 911 814 940
6 215 105 105 110 156 100 143
37 102 81 - 712 322 - 667
- - - 54 - 93 - 152
356 367 422 479 588 648 437 458
416 421 969 3,763 1,778 1,292 - 1,028 246
13 16 133 493 316 13 13 16
272 195 263 156 194 158 156 195
- - - - - - - -
12 115 12 38 98 54 13 376
4,608 6,282 3,788 4,278 2,816 1,911 1,962 1,705
- - - - - - - -
154 158 87 104 135 119 136 175
168 1,028 415 802 1,002 554 791 778
112 140 112 117 146 117 117 146
605 756 605 605 756 605 605 756
625 716 738 536 884 842 855 871
2,174 2,715 2,169 2,123 2,682 2,188 2,162 2,699
756 2,974 1,370 369 3,250 1,598 4,787 1,420
- - - - - - 41 -
15,081 21,434 15,308 17,990 20,491 14,977 16,255 17,060
- 16,503 - 37,541 - 15,208 - 13,161 - 9,511 - 5,030 - 1,601 21,044

48 48 48 48 48 48 48 48
27 25 25 24 24 25 28 34
56.0% 52.1% 51.6% 50.0% 50.0% 52.2% 57.4% 70.6%
551 564 566 574 575 589 572 592
102.4% 122.8% 99.8% 91.2% 84.1% 83.2% 76.8% 62.1%
48.5% 48.4% 26.7% 14.8% 4.6% 8.8% 13.3% 6.1%
 25.5% 30.4% 27.3% 32.7% 29.7% 25.3% 25.8% 17.0%
-27.9% -53.2% -27.2% -23.9% -13.8% -8.5% -2.5% 21.0%
- 4,556 - 8,290 - 4,198 - 3,633 - 2,100 - 1,389 - 442 4,647
Sep-19 Oct-19 Nov-19 YTD-19
78,071 87,102 109,805 807,261
4 4 - 17
23,490 28,866 36,820 275,547
7,159 1,650 4,288 124,066
4,819 4,644 6,001 57,203
4,957 4,486 5,437 48,646
6,276 5,066 9,565 80,200
4,508 4,508 5,634 53,719
3,305 3,742 4,748 36,015
1 1 4 12
207 428 163 3,235
748 785 1,148 9,306
618 518 533 6,932
239 113 201 1,492
- 601 280 2,801
- 33 53 385
119 63 1,062 4,999
173 180 621 8,830
13 205 1,997 3,226
156 156 195 2,096
- - - -
12 421 284 1,434
1,793 3,475 5,387 38,004
- 105 - 105 -
89 85 172 1,415
1,107 818 1,023 8,487
117 117 146 1,388
605 605 756 7,258
682 818 663 8,232
2,169 2,169 2,693 25,942
820 830 2,487 20,662
- - - 41
12,972 16,268 24,512 192,348
13,895 21,618 17,546 - 24,451

48 48 48 48
33 37 37 29
69.4% 76.4% 77.5% 60%
586 594 590 579
65.6% 56.5% 61.7% 79%
14.0% 3.4% 6.3% 19.4%
16.6% 18.7% 22.3% 23.8%
17.8% 24.8% 16.0% -3.0%
3,835 5,968 3,875 - 6,113