Page 20 - Management Accounts Design Feb 2017 v7

Key Performance 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