Spreadsheet: richard_shapiro__32388__Europen Govt Affairs Waterfall
Sheet: YTD Actuals 

European Govt July YTD Summary
Adaytum
Forecast | EEL European Govt Affairs | Consolidated
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
Salaries & Wages | 273488.65 | 192916.37 | 245887.86 | 393754.8 | 200296.5 | 141506.58 | 186815 | 296101.6416666667 | 296101.6416666667 | 315828.4416666667 | 315828.4416666667 | 315828.4416666667 | 1634665.76
Employee Entertainment & Meals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1991 | 1991 | 1991 | 1991 | 1991 | 0
Travel Costs & Hotel Accommodation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 196774 | 196774 | 196774 | 196774 | 196774 | 0
Client Entertainment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travel & Entertainment | 9454.2 | 27605.9 | 45642.43 | 43687.84 | 26480.92 | 36771.96 | 50547.97 | 0 | 0 | 0 | 0 | 0 | 240191.22
Travel & Entertainment | 9454.2 | 27605.9 | 45642.43 | 43687.84 | 26480.92 | 36771.96 | 50547.97 | 198765 | 198765 | 198765 | 198765 | 198765 | 240191.22
Computer Maintenance Contracts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Computer Software and Licences | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Computer Hardware < 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office Postage & Couriers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stationery & Printing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4996 | 4996 | 4996 | 4996 | 4996 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office/Plant Maintenance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office Cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Security Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Health & Safety Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office Expenses | 8038.87 | 1827.13 | 7785.33 | 1301.98 | 832.91 | 930.78 | 4894.48 | 0 | 0 | 0 | 0 | 0 | 25611.48
Office Expenses | 8038.87 | 1827.13 | 7785.33 | 1301.98 | 832.91 | 930.78 | 4894.48 | 4996 | 4996 | 4996 | 4996 | 4996 | 25611.48
Outside Consultancy Services - Tax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Outside Consulting - Advert, Marketing, Reg Affair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Outside Consultancy Services - IT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Outside Consultancy Services - Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee Recruitment Fees and Incentive Payments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18242 | 18242 | 18242 | 18242 | 18242 | 0
Other Outside Services | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 107340 | 107340 | 107340 | 107340 | 107340 | 0
Consultancy | 78986.15 | 133337.02 | 78023.71 | 152519.09 | 34053.13 | 40057.25 | 197684.55 | 0 | 0 | 0 | 0 | 0 | 714660.9
Consultancy | 78986.15 | 133337.02 | 78023.71 | 152519.09 | 34053.13 | 40057.25 | 197684.55 | 125582 | 125582 | 125582 | 125582 | 125582 | 714660.9
Outside Consultancy Services - Audit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Outside Consultancy Services - Accounting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Outside Consultancy Services - Legal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 615583 | 615583 | 615583 | 615583 | 615583 | 0
Audit & Legal | 22098.37 | 11431.29 | 181549.67 | 7912.5 | 3700.14 | 41142.71 | 15036.74 | 0 | 0 | 0 | 0 | 0 | 282871.42
Audit & Legal | 22098.37 | 11431.29 | 181549.67 | 7912.5 | 3700.14 | 41142.71 | 15036.74 | 615583 | 615583 | 615583 | 615583 | 615583 | 282871.42
Office Utilities and Council Rates | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office Rental Costs (Not Personal Rental) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 0
Occupancy Costs | 17385.79 | -20806.34 | 28152.91 | 23128.98 | 11680.23 | 27933.11 | 20941.08 | 0 | 0 | 0 | 0 | 0 | 108415.76
Occupancy Costs | 17385.79 | -20806.34 | 28152.91 | 23128.98 | 11680.23 | 27933.11 | 20941.08 | 5000 | 5000 | 5000 | 5000 | 5000 | 108415.76
Employee Club Membership | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Subscriptions & Memberships | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Books, Publications & Data Services | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2240 | 2240 | 2240 | 2240 | 2240 | 0
Conferences | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6019 | 6019 | 6019 | 6019 | 6019 | 0
Training Courses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Advertising | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Business Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7801 | 7801 | 7801 | 7801 | 7801 | 0
General & Admin | 5361.69 | 12875.81 | 6736.32 | 84356.66 | 7075.33 | -1111.92 | 26177 | 0 | 0 | 0 | 0 | 0 | 141470.89
General & Admin | 5361.69 | 12875.81 | 6736.32 | 84356.66 | 7075.33 | -1111.92 | 26177 | 16060 | 16060 | 16060 | 16060 | 16060 | 141470.89
Office Phones & Faxes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Office Mobile Phones | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10093 | 10093 | 10093 | 10093 | 10093 | 0
Communications | 2649.07 | 2145.18 | 2792.03 | 281.1 | 5017.08 | 2704.37 | 5398.28 | 0 | 0 | 0 | 0 | 0 | 20987.11
Communications | 2649.07 | 2145.18 | 2792.03 | 281.1 | 5017.08 | 2704.37 | 5398.28 | 10093 | 10093 | 10093 | 10093 | 10093 | 20987.11
Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL G&A | 417462.79 | 361332.36 | 596570.26 | 706942.95 | 289136.24 | 289934.84 | 507495.1 | 1272180.641666667 | 1272180.641666667 | 1291907.441666667 | 1291907.441666667 | 1291907.441666667 | 3168874.54
 | Adaytum
 | EEL European Govt Affairs | Forecast
Average per employee / per month
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Monthly Actual Headcount | 20 | 19 | 20 | 18 | 20 | 21 | 21 | 24 | 24 | 26 | 26 | 26
Run Rate SWB
[NAME]
Run Rate Office Expenses
Run Rate Consultancy
Run Rate Audit & Legal
[NAME] Occupancy
Run Rate General & Admin
Run Rate Communications
Per Person / Per Month
Calculated Average SWB
Calculated Average T&E
Calculated Average Office Expenses
Calculated Average Consultancy
Calculated Average Audit & Legal
Calculated Average Occupancy
Calculated Average General & Admin
Calculated Average Communications
Need to account for any inland revenue payments on top of these average per person above.