Page 24 - Management Accounts Design Feb 2017 v7

Key Perfomance Indicators

1 TOTAL GROSS SALES
JAN FEB MAR APR MAY JUN H YR JUL AUG SEP OCT NOV DEC F YR
2016 Act 1,225 1,207 1,172 1,059 1,112 1,147 6,922 1,190 1,009 1,204 1,142 1,205 688 13,360
2017 Act 1,300
2017 Bud 1,304 1,242 1,428 1,118 1,304 1,366 7,762 1,304 1,056 1,304 1,366 1,366 994 15,151
2 WORKING DAYS
2016 Act 20 21 21 21 20 22 125 21 22 22 21 22 14 247
2017 Act 21 20 23 18 21 22 125 21 17 21 22 22 16 244
3 ADJUSTED GROSS CONTRIBUTION
2016 Act 634 633 648 534 558 603 3,610 617 506 638 580 620 361 6,931
2017 Act 678 0
2017 Bud 734 694 814 613 734 774 4,362 734 573 734 774 774 533 8,484
4 MARGIN % FOR ADJUSTED GROSS CONTRIBUTION AGAINST GROSS SALES
2016 Act 51.8% 52.5% 55.3% 50.4% 50.1% 52.6% 52.1% 51.9% 50.1% 52.9% 50.8% 51.4% 52.4% 51.8%
2017 Act 52.2% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
2017 Bud 56.8% 56.4% 57.5% 55.4% 56.8% 57.2% 56.7% 56.8% 54.9% 56.8% 57.2% 57.2% 54.2% 56.5%
5 TOTAL OVERHEADS (before Interest and Bonuses)
2016 Act 572 572 542 545 559 542 3,332 525 493 503 513 523 244 6,133
2017 Act 514 0
2017 Bud 488 486 492 481 488 490 2,924 488 479 488 490 490 477 5,835
6 OPERATING PROFIT (before interest and Bonuses)
2016 Act 167 167 203 104 124 169 934 197 97 239 171 202 184 2,049
2017 Act 164
2017 Bud 246 208 322 132 246 284 1,438 246 95 246 284 284 57 2,649
7 NET PROFIT
2016 Act 144 142 174 91 108 146 805 169 86 201 114 164 97 1,636
2017 Act 127
2017 Bud 160 191 161 94 111 257 974 96 89 223 258 258 54 1,953
8 GROSS SALES - YTD - CUMULATIVE
2016 Act 1,225 2,432 3,604 4,663 5,776 6,922 6,922 8,112 9,121 10,325 11,467 12,672 13,360 13,360
2017 Act 1,300
2017 Bud 1,304 2,546 3,974 5,092 6,396 7,762 7,762 9,066 10,121 11,425 12,792 14,158 15,151 15,151
9 NET PROFIT - YTD - CUMULATIVE
2016 Act 144 286 460 551 659 805 805 973 1,059 1,260 1,374 1,538 1,635 1,635
2017 Act 127
2017 Bud 160 351 512 606 716 974 974 1,070 1,159 1,382 1,640 1,899 1,953 1,953
10 RETURN ON SALES
2016 Act 11.8% 11.7% 14.8% 8.6% 9.7% 12.7% 11.6% 14.2% 8.5% 16.7% 10.0% 13.6% 14.1% 12.1%
2017 Act 9.8% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
2017 Bud 12.3% 15.3% 11.3% 8.4% 8.5% 18.8% 12.5% 7.4% 8.4% 17.1% 18.9% 18.9% 5.4% 12.9%
11 TOTAL STOCKS
2016 Act 1,502 1,428 1,495 1,508 1,495 1,492 1,492 1,465 1,509 1,480 1,527 1,561 1,614 1,614
2017 Act 1,519
2017 Bud 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614 1,614
12 TRADE DEBTORS (DUE FROM CUSTOMERS)
2016 Act 2,416 2,531 2,675 2,531 2,520 2,617 2,617 2,522 2,422 2,565 2,497 2,680 2,429 2,429
2017 Act 2,501
2017 Bud 2,342 2,707 2,955 2,769 2,660 2,841 2,841 2,873 2,552 2,573 2,819 2,944 2,586 2,586
13 WORKING CAPITAL
2016 Act 2,186 2,092 2,324 2,299 2,032 1,945 1,945 2,271 2,427 2,190 2,049 2,268 2,350 2,350
2017 Act 2,206
14 CASH BALANCES
2016 Act 7,349 7,569 7,512 7,022 7,365 7,578 7,578 7,323 7,584 7,339 7,466 7,387 7,390 7,390
2017 Act 7,390
2017 Bud 7,005 6,725 6,549 6,119 6,285 6,450 6,450 6,350 6,651 6,485 6,554 6,776 7,120 7,120
15 DEBTOR DAYS
2016 Act 71.0 61.0 65.0 66.0 68.0 69.0 69.0 65.0 66.6 68.1 64.0 67.0 69.8 67.1
2017 Act 71.4
2017 Bud 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0 68.0
16 CREDITOR DAYS
2016 Act 56.0 53.0 49.0 54.0 59.0 59.0 59.0 50.0 53.1 56.4 52.0 52.0 51.8 53.5
2017 Act 49.5
2017 Bud 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0 52.0
17 CAPITAL SPEND Y.T.D.
2016 Act 10 55 71 81 196 200 200 240 250 258 298 353 403 403
2017 Act 48
2017 Bud 405 50 33 0 112 33 633 21 50 33 0 50 33 820
18 GROSS SALES CENTURION
2016 Act 1,042 1,026 1,025 951 1,000 1,010 6,054 1,014 900 1,075 963 1,020 612 11,638
2017 Act 1,061 0 0 0 0 0 0 0 0 0 0 0 0 0
2017 Bud 1,142 1,087 1,250 978 1,142 1,196 6,795 1,142 924 1,142 1,196 1,196 870 13,263
19 GROSS SALES RESPIRATORY
2016 Act 183 181 147 108 112 137 868 176 110 129 179 184 76 1,722
2017 Act 239
2017 Bud 162 155 178 139 162 170 967 162 132 162 170 170 124 1,888
20 GROSS SALES TOTAL
2016 Act 1,225 1,207 1,172 1,060 1,112 1,147 6,923 1,190 1,009 1,204 1,142 1,205 688 13,361
2017 Act 1,300 0 0 0 0 0 0 0 0 0 0 0 0 0
2017 Bud 1,304 1,242 1,428 1,118 1,304 1,366 7,762 1,304 1,056 1,304 1,366 1,366 994 15,151
21 UK SALES
2016 Act 518 581 603 538 589 544 3,373 556 606 625 613 642 418 6,833
2017 Act 569
2017 Bud 613 584 671 525 613 642 3,648 613 496 613 642 642 467 7,121
22 EXPORT SALES
2016 Act 708 626 569 522 523 603 3,551 634 403 579 529 563 271 6,530
2017 Act 731 0 0 0 0 0 0 0 0 0 0 0 0 0
2017 Bud 691 658 757 592 691 724 4,114 691 560 691 724 724 527 8,031
23 ORDER INTAKE CENTURION
2016 Act 929 1,081 1,006 1,037 1,008 1,048 6,109 989 901 1,180 980 1,002 635 11,796
2017 Act 999
2017 Bud 1,085 1,127 1,182 1,019 1,154 1,182 6,748 1,087 978 1,154 1,195 1,114 928 6,456
24 ORDER INTAKE RESPIRATORY
2016 Act 133 147 163 99 123 158 823 170 138 147 169 171 134 1,752
2017 Act 205
2017 Bud 81 161 168 145 164 168 888 155 139 164 170 159 132 919
25 ORDER INTAKE
2016 Act 1,062 1,228 1,169 1,136 1,131 1,206 6,932 1,159 1,039 1,327 1,149 1,173 769 13,548
2017 Act 1,204 0 0 0 0 0 0 0 0 0 0 0 0 0
2017 Bud 1,166 1,288 1,350 1,164 1,319 1,350 7,636 1,241 1,117 1,319 1,365 1,272 1,060 7,376
26 ORDER BANK AT START OF MONTH
2016 Act 576 400 398 373 422 419 455 455 402 402 490 457 408 448
2017 Act 448
27 SALES MARGIN CENTURION
2016 Act 584 567 572 530 549 554 3,356 547 489 584 514 560 342 6,391
2017 Act 611
2017 Bud 674 642 738 577 674 706 4,010 674 545 674 706 706 513 7,827
28 SALES MARGIN % CENTURION
2016 Act 43.1% 42.7% 44.0% 43.3% 36.8% 43.0% 42.4% 37.2% 40.6% 36.6% 42.4% 43.9% 41.4% 41.5%
2017 Act 57.6% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
2017 Bud 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0%
29 SALES MARGIN RESPIRATORY
2016 Act 79 77 65 47 41 59 368 66 45 47 76 81 32 714
2017 Act 112
2017 Bud 67 64 74 58 67 71 401 67 55 67 71 71 51 783
30 SALES MARGIN % RESPIRATORY
2016 Act 43.1% 42.7% 44.0% 43.3% 36.8% 43.0% 42.4% 37.2% 40.6% 36.6% 42.4% 43.9% 41.4% 41.5%
2017 Act 46.9% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
2017 Bud 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5% 41.5%
31 NUMBER OF EMPLOYEES (including casuals)
2016 Act 133 133 135 134 131 131 131 131 129 129 130 130 130 130
2017 Act 130
2017 Bud 131 133 136 136 134 135 135 135 135 136 136 136 136 136
32 SALES PER EMPLOYEE
2016 Act 107,763 106,162 101,573 92,552 99,325 102,433 101,644 106,282 91,514 109,200 102,753 108,450 61,947 1,202,427
2017 Act 117,000 0 0 0 0 0 0 0 0 0 0 0 0 0
2017 Bud 116,284 109,084 123,135 96,367 114,110 118,656 674,181 113,262 91,689 112,428 117,782 117,782 85,659 1,306,305