Spreadsheet: 482328d1475010455-ranking-based-on-conditions-mock-report
Sheet: P&L (2)

 |  |  |  | Contract 1 |  |  | Contract 2 |  |  | Contract 3 |  |  | Contract 4 |  |  | Contract 5
 |  |  |  | Division 1 |  |  | Division 2 |  |  | Division 2 |  |  | Division 1 |  |  | Division 1
 |  |  |  | BU 1 |  |  | BU 2 |  |  | BU 3 |  |  | BU 4 |  |  | BU 5
 |  |  |  | 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
 |  | Salaries and Wages |  | 98 | 63 |  | 98 | 63 |  | 98 | 63 |  | 98 | 63 |  | 98 | 63
 |  | Bonus and Commission |  | 14 | 38 |  | 14 | 38 |  | 14 | 38 |  | 14 | 38 |  | 14 | 38
 |  | Pension Charges |  | 64 | 54 |  | 64 | 54 |  | 64 | 54 |  | 64 | 54 |  | 64 | 54
 |  | Overtime |  | 77 | 79 |  | 77 | 79 |  | 77 | 79 |  | 77 | 79 |  | 77 | 79
 |  | Redundancy and Severance |  | 65 | 59 |  | 65 | 59 |  | 65 | 59 |  | 65 | 59 |  | 65 | 59
 |  | Training and Recruitment |  | 79 | 92 |  | 79 | 92 |  | 79 | 92 |  | 79 | 92 |  | 79 | 92
 |  | Other Employee Costs |  | 58 | 86 |  | 58 | 86 |  | 58 | 86 |  | 58 | 86 |  | 58 | 86
 |  | Agency Staff |  | 12 | 81 |  | 12 | 81 |  | 12 | 81 |  | 12 | 81 |  | 12 | 81
 |  | Employee Costs
 |  | Employee Costs / Revenue %
 |  | Property and Facilities |  | 23 | 35 |  | 23 | 35 |  | 23 | 35 |  | 23 | 35 |  | 23 | 35
 |  | Power Costs |  | 39 | 56 |  | 39 | 56 |  | 39 | 56 |  | 39 | 56 |  | 39 | 56
 |  | Communications |  | 22 | 67 |  | 22 | 67 |  | 22 | 67 |  | 22 | 67 |  | 22 | 67
 |  | Office Expenses |  | 99 | 58 |  | 99 | 58 |  | 99 | 58 |  | 99 | 58 |  | 99 | 58
 |  | Facility Costs
 |  | Facility Costs / Revenue %
 |  | Materials and Consumables |  | 47 | 70 |  | 47 | 70 |  | 47 | 70 |  | 47 | 70 |  | 47 | 70
 |  | Low Value Equipment |  | 31 | 50 |  | 31 | 50 |  | 31 | 50 |  | 31 | 50 |  | 31 | 50
 |  | Computer Expenditure |  | 41 | 67 |  | 41 | 67 |  | 41 | 67 |  | 41 | 67 |  | 41 | 67
 |  | Vehicles |  | 53 | 71 |  | 53 | 71 |  | 53 | 71 |  | 53 | 71 |  | 53 | 71
 |  | Lease Rentals and Hire Costs |  | 80 | 31 |  | 80 | 31 |  | 80 | 31 |  | 80 | 31 |  | 80 | 31
 |  | Equipment Costs
 |  | Equipment Costs / Revenue %
 |  | Sub Contractors |  | 24 | 86 |  | 24 | 86 |  | 24 | 86 |  | 24 | 86 |  | 24 | 86
 |  | Recharges |  | 96 | 73 |  | 96 | 73 |  | 96 | 73 |  | 96 | 73 |  | 96 | 73
 |  | Purchased Services |  | 55 | 49 |  | 55 | 49 |  | 55 | 49 |  | 55 | 49 |  | 55 | 49
 |  | Procured Services
 |  | Procured Services / Revenue %
 |  | Travel and Subsistence |  | 22 | 31 |  | 22 | 31 |  | 22 | 31 |  | 22 | 31 |  | 22 | 31
 |  | Internal Revenue/Costs |  | 65 | 97 |  | 65 | 97 |  | 65 | 97 |  | 65 | 97 |  | 65 | 97
 |  | Profit/Loss on Disposal |  | 10 | 18 |  | 10 | 18 |  | 10 | 18 |  | 10 | 18 |  | 10 | 18
 |  | Sales and Marketing |  | 36 | 11 |  | 36 | 11 |  | 36 | 11 |  | 36 | 11 |  | 36 | 11
 |  | Insurance |  | 17 | 95 |  | 17 | 95 |  | 17 | 95 |  | 17 | 95 |  | 17 | 95
 |  | Finance Income/Expenses |  | 89 | 66 |  | 89 | 66 |  | 89 | 66 |  | 89 | 66 |  | 89 | 66
 |  | Capitalised Costs |  | 32 | 84 |  | 32 | 84 |  | 32 | 84 |  | 32 | 84 |  | 32 | 84
 |  | Depreciation |  | 54 | 39 |  | 54 | 39 |  | 54 | 39 |  | 54 | 39 |  | 54 | 39
 |  | Bid & Phase In Costs Amortisation |  | 87 | 86 |  | 87 | 86 |  | 87 | 86 |  | 87 | 86 |  | 87 | 86
 |  | Impairment |  | 90 | 79 |  | 90 | 79 |  | 90 | 79 |  | 90 | 79 |  | 90 | 79
 |  | Foreign Exchange |  | 75 | 62 |  | 75 | 62 |  | 75 | 62 |  | 75 | 62 |  | 75 | 62
 |  | Bad Debt |  | 73 | 92 |  | 73 | 92 |  | 73 | 92 |  | 73 | 92 |  | 73 | 92
 |  | Asset Amortisation |  | 90 | 14 |  | 90 | 14 |  | 90 | 14 |  | 90 | 14 |  | 90 | 14
 |  | Allocated Indirect Costs |  | 78 | 80 |  | 78 | 80 |  | 78 | 80 |  | 78 | 80 |  | 78 | 80
 |  | Other Direct Costs |  | 96 | 71 |  | 96 | 71 |  | 96 | 71 |  | 96 | 71 |  | 96 | 71
 |  | Other Costs
 |  | Other Costs / Revenue %
 |  | Trading Profit before OCP
 |  | Trading Profit Margin before OCP %
 |  | OCP Booking
 |  | OCP Utilisation
 |  | OCP Release
 |  | Trading Profit
 |  | Trading Profit Margin %
 |  | Check: