Spreadsheet: 482328d1475010455-ranking-based-on-conditions-mock-report
Sheet: Data

 |  |  |  | Contract 1 |  |  | Contract 2 |  |  | Contract 3 |  |  | Contract 4 |  |  | Contract 5
 |  |  |  | Division 1 |  |  | Division 2 |  |  | Division 2 |  |  | Division 1 |  |  | Division 1
 |  |  |  | BU A |  |  | BU B |  |  | BU C |  |  | BU A |  |  | BU D
 |  |  |  | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME]
 |  | Income Statement |  | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's | 000's
 |  | External Revenue |  | 8606 | 9146 | -540 | 8957 | 7971 | 986 | 8460 | 5533 | 2927 | 6054 | 9585 | -3531 | 7141 | 5071 | 2070
 |  | Salaries and Wages |  | 838 | 548 | 290 | 990 | 763 | 227 | 765 | 760 | 5 | 915 | 749 | 166 | 521 | 611 | -90
 |  | Bonus and Commission |  | 570 | 846 | -276 | 971 | 632 | 339 | 884 | 958 | -74 | 741 | 814 | -73 | 919 | 730 | 189
 |  | Pension Charges |  | 607 | 980 | -373 | 715 | 548 | 167 | 697 | 698 | -1 | 619 | 529 | 90 | 990 | 825 | 165
 |  | Overtime |  | 996 | 915 | 81 | 756 | 924 | -168 | 611 | 951 | -340 | 841 | 626 | 215 | 987 | 931 | 56
 |  | Redundancy and Severance |  | 999 | 824 | 175 | 510 | 821 | -311 | 587 | 885 | -298 | 706 | 902 | -196 | 855 | 907 | -52
 |  | Training and Recruitment |  | 967 | 850 | 117 | 790 | 885 | -95 | 569 | 987 | -418 | 936 | 941 | -5 | 862 | 600 | 262
 |  | Other Employee Costs |  | 1000 | 914 | 86 | 996 | 701 | 295 | 723 | 868 | -145 | 738 | 907 | -169 | 586 | 880 | -294
 |  | Agency Staff |  | 683 | 926 | -243 | 784 | 875 | -91 | 635 | 913 | -278 | 633 | 838 | -205 | 601 | 672 | -71
 |  | Employee Costs |  | 6660 | 6803 | -143 | 6512 | 6149 | 363 | 5471 | 7020 | -1549 | 6129 | 6306 | -177 | 6321 | 6156 | 165
 |  | Employee Costs / Revenue % |  | -0.7738786892865442 | -0.7438224360376121 | -0.2648148148148148 | -0.7270291392207212 | -0.7714214025843683 | -0.3681541582150101 | -0.6466903073286052 | -1.26875112958612 | 0.5292107960368978 | -1.012388503468781 | -0.6579029733959312 | -0.05012744265080714 | -0.8851701442375017 | -1.213961743245908 | -0.07971014492753623
 |  | Property and Facilities |  | 919 | 509 | 410 | 517 | 950 | -433 | 880 | 792 | 88 | 914 | 928 | -14 | 764 | 935 | -171
 |  | Power Costs |  | 631 | 959 | -328 | 567 | 706 | -139 | 875 | 786 | 89 | 965 | 713 | 252 | 732 | 804 | -72
 |  | Communications |  | 768 | 951 | -183 | 941 | 706 | 235 | 965 | 600 | 365 | 830 | 695 | 135 | 702 | 935 | -233
 |  | Office Expenses |  | 579 | 740 | -161 | 645 | 649 | -4 | 824 | 569 | 255 | 561 | 585 | -24 | 769 | 597 | 172
 |  | Facility Costs |  | 2897 | 3159 | -262 | 2670 | 3011 | -341 | 3544 | 2747 | 797 | 3270 | 2921 | 349 | 2967 | 3271 | -304
 |  | Facility Costs / Revenue % |  | -0.3366256100395073 | -0.3453968948174065 | -0.4851851851851852 | -0.2980908786424026 | -0.3777443231714967 | 0.345841784989858 | -0.4189125295508274 | -0.4964756913067052 | -0.2722924496071062 | -0.5401387512388504 | -0.3047470005216484 | 0.09883885584820164 | -0.4154880268869906 | -0.6450404259514888 | 0.1468599033816425
 |  | Materials and Consumables |  | 857 | 647 | 210 | 799 | 764 | 35 | 663 | 698 | -35 | 596 | 951 | -355 | 888 | 780 | 108
 |  | Low Value Equipment |  | 802 | 738 | 64 | 860 | 769 | 91 | 891 | 676 | 215 | 528 | 946 | -418 | 556 | 703 | -147
 |  | Computer Expenditure |  | 973 | 579 | 394 | 893 | 914 | -21 | 627 | 667 | -40 | 923 | 956 | -33 | 759 | 943 | -184
 |  | Vehicles |  | 543 | 935 | -392 | 664 | 821 | -157 | 922 | 919 | 3 | 947 | 710 | 237 | 690 | 533 | 157
 |  | Lease Rentals and Hire Costs |  | 946 | 833 | 113 | 542 | 761 | -219 | 750 | 691 | 59 | 509 | 650 | -141 | 887 | 598 | 289
 |  | Equipment Costs |  | 4121 | 3732 | 389 | 3758 | 4029 | -271 | 3853 | 3651 | 202 | 3503 | 4213 | -710 | 3780 | 3557 | 223
 |  | Equipment Costs / Revenue % |  | -0.4788519637462236 | -0.4080472337633939 | 0.7203703703703703 | -0.4195601205760857 | -0.5054572826496048 | 0.2748478701825558 | -0.4554373522458629 | -0.6598590276522682 | -0.06901264092927913 | -0.5786257020151966 | -0.4395409494001044 | -0.2010761823845936 | -0.5293376277832237 | -0.7014395582725301 | -0.1077294685990338
 |  | Sub Contractors |  | 645 | 548 | 97 | 861 | 709 | 152 | 685 | 739 | -54 | 875 | 824 | 51 | 621 | 909 | -288
 |  | Recharges |  | 660 | 671 | -11 | 600 | 533 | 67 | 785 | 642 | 143 | 869 | 843 | 26 | 914 | 950 | -36
 |  | Purchased Services |  | 502 | 592 | -90 | 627 | 787 | -160 | 634 | 695 | -61 | 852 | 875 | -23 | 957 | 835 | 122
 |  | Procured Services |  | 1807 | 1811 | -4 | 2088 | 2029 | 59 | 2104 | 2076 | 28 | 2596 | 2542 | 54 | 2492 | 2694 | -202
 |  | Procured Services / Revenue % |  | -0.2099697885196375 | -0.1980100590422043 | -0.007407407407407408 | -0.233113765769789 | -0.2545477355413374 | -0.05983772819472617 | -0.2486997635933806 | -0.3752033255015362 | -0.009566108643662453 | -0.428807400066072 | -0.2652060511215441 | 0.01529311809685641 | -0.3489707323904215 | -0.531256162492605 | 0.09758454106280193
 |  | Travel and Subsistence |  | 609 | 624 | -15 | 960 | 722 | 238 | 795 | 716 | 79 | 680 | 807 | -127 | 559 | 992 | -433
 |  | Internal Revenue/Costs |  | 956 | 926 | 30 | 602 | 632 | -30 | 611 | 967 | -356 | 943 | 776 | 167 | 582 | 524 | 58
 |  | Profit/Loss on Disposal |  | 802 | 640 | 162 | 587 | 826 | -239 | 655 | 994 | -339 | 624 | 943 | -319 | 960 | 600 | 360
 |  | Sales and Marketing |  | 693 | 958 | -265 | 675 | 555 | 120 | 584 | 608 | -24 | 917 | 865 | 52 | 873 | 950 | -77
 |  | Insurance |  | 554 | 588 | -34 | 563 | 889 | -326 | 707 | 839 | -132 | 797 | 921 | -124 | 868 | 789 | 79
 |  | Finance Income/Expenses |  | 824 | 892 | -68 | 995 | 665 | 330 | 508 | 997 | -489 | 993 | 693 | 300 | 692 | 599 | 93
 |  | Capitalised Costs |  | 536 | 576 | -40 | 772 | 830 | -58 | 883 | 555 | 328 | 551 | 749 | -198 | 534 | 702 | -168
 |  | Depreciation |  | 673 | 789 | -116 | 517 | 576 | -59 | 918 | 903 | 15 | 941 | 773 | 168 | 721 | 775 | -54
 |  | Bid & Phase In Costs Amortisation |  | 557 | 703 | -146 | 801 | 669 | 132 | 977 | 829 | 148 | 602 | 763 | -161 | 509 | 849 | -340
 |  | Impairment |  | 946 | 901 | 45 | 767 | 783 | -16 | 994 | 983 | 11 | 846 | 620 | 226 | 879 | 893 | -14
 |  | Foreign Exchange |  | 515 | 967 | -452 | 678 | 563 | 115 | 823 | 552 | 271 | 566 | 674 | -108 | 968 | 614 | 354
 |  | Bad Debt |  | 557 | 710 | -153 | 778 | 975 | -197 | 694 | 839 | -145 | 735 | 685 | 50 | 644 | 587 | 57
 |  | Asset Amortisation |  | 824 | 749 | 75 | 935 | 519 | 416 | 887 | 526 | 361 | 987 | 633 | 354 | 530 | 871 | -341
 |  | Allocated Indirect Costs |  | 606 | 976 | -370 | 624 | 761 | -137 | 810 | 523 | 287 | 775 | 633 | 142 | 533 | 906 | -373
 |  | Other Direct Costs |  | 722 | 528 | 194 | 672 | 607 | 65 | 712 | 929 | -217 | 581 | 749 | -168 | 933 | 738 | 195
 |  | Other Costs |  | 10374 | 11527 | -1153 | 10926 | 10572 | 354 | 11558 | 11760 | -202 | 11538 | 11284 | 254 | 10785 | 11389 | -604
 |  | Other Costs / Revenue % |  | -1.205438066465257 | -1.260332385742401 | -2.135185185185185 | -1.219828067433292 | -1.326307866014302 | -0.359026369168357 | -1.366193853427896 | -2.125429242725466 | 0.06901264092927913 | -1.905847373637265 | -1.177256129368806 | 0.07193429623336166 | -1.510292676095785 | -2.245908104910274 | 0.2917874396135265
 |  | Trading Profit before OCP |  | 34465 | 36178 | -1713 | 34911 | 33761 | 1150 | 34990 | 32787 | 2203 | 33090 | 36851 | -3761 | 33486 | 32138 | 1348
 |  | Trading Profit Margin before OCP % |  | 4.004764118057169 | 3.955609009403018 | 3.172222222222222 | 3.897621971642291 | 4.235478609961109 | 1.166328600405679 | 4.135933806146572 | 5.925718416772095 | 0.7526477622138709 | 5.465807730426165 | 3.844653103808033 | 1.065137354856981 | 4.689259207393922 | 6.337605994872806 | 0.6512077294685991
 |  | OCP Booking
 |  | OCP Utilisation
 |  | OCP Release
 |  | Trading Profit |  | 34465 | 36178 | -1713 | 34911 | 33761 | 1150 | 34990 | 32787 | 2203 | 33090 | 36851 | -3761 | 33486 | 32138 | 1348
 |  | Trading Profit Margin %
 |  | Check: