Spreadsheet: richard_shapiro__32388__Europen Govt Affairs Waterfall
Sheet: 2001 Forecasts

 |  | GOVERNMENT AFFAIRS SUMMARY (USD)
 | Adaytum
 | EEL European Govt Affairs | Consolidated
 |  |  | Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | Jul | Aug | Sep | Q3 | Oct | Nov | Dec | Q4 | Full year |  | Q1 | Q2 | Q3 | Q4 | Full year
 | Original Budget 2001 | Salaries & Wages | 430587.6865671641 | 435790.7649253731 | 435790.7649253731 | 1302169.21641791 | 435790.7649253731 | 435790.7649253731 | 435790.7649253731 | 1307372.294776119 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 1340674.533582089 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 1340674.533582089 | 5290890.578358209
 |  | Travel & Entertainment | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 498507.4626865665 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 498507.4626865665 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 498507.4626865665 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 498507.4626865665 | 1994029.850746266
 |  | Office Expenses | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 11194.02985074627 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 11194.02985074627 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 11194.02985074627 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 11194.02985074627 | 44776.11940298508
 |  | Consultancy | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 318980.5970149254 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 318980.5970149254 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 318980.5970149254 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 318980.5970149254 | 1275922.388059702
 |  | Audit & Legal | 371277.611940298 | 371277.611940298 | 371277.611940298 | 1113832.835820894 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 1113832.835820894 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 1113832.835820894 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 1113832.835820894 | 4455331.343283576
 |  | Occupancy Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | General & Admin | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 76492.53731343291 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 76492.53731343291 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 76492.53731343291 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 76492.53731343291 | 305970.1492537317
 |  | Communications | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 33582.0895522389 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 33582.0895522389 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 33582.0895522389 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 33582.0895522389 | 134328.3582089556
 |  | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL G&A | 1114786.19402985 | 1119986.287313432 | 1119986.287313432 | 3354758.768656714 | 1119989.272388059 | 1119986.287313432 | 1119986.287313432 | 3359961.847014924 | 1131090.018656716 | 1131087.033582089 | 1131087.033582089 | 3393264.085820894 | 1131090.018656716 | 1131087.033582089 | 1131087.033582089 | 3393264.085820894 | 13501248.78731342
 |  |  | Actual | Actual | Actual |  | CE1 | CE1 | CE1 | CE1 | CE1 | CE1 | CE1 | CE1 | CE1 | CE1 | CE1
 | CE1 - End of Q1 | Salaries & Wages | 273488.65 | 192916.37 | 245887.86 | 712292.88 | 286582.25 | 293082.25 | 293082.25 | 872746.75 | 296102.25 | 296102.25 | 296102.25 | 888306.75 | 315828.25 | 315828.25 | 315828.25 | 947484.75 | 3420831.13
 |  | Travel & Entertainment | 9454.2 | 27605.9 | 45642.43 | 82702.53 | 212370 | 212370 | 212370 | 637110 | 212370 | 212370 | 212370 | 637110 | 212370 | 212370 | 212370 | 637110 | 1994032.53
 |  | Office Expenses | 8038.87 | 1827.13 | 7785.33 | 17651.33 | 4014 | 4014 | 4014 | 12042 | 4014 | 4014 | 4014 | 12042 | 4014 | 4014 | 4014 | 12042 | 53777.33
 |  | Consultancy | 78986.15 | 133337.02 | 78023.71 | 290346.88 | 117508.0002 | 117508 | 117508 | 352524.0002 | 117508 | 117508 | 117508 | 352524 | 117508 | 117508 | 117508 | 352524 | 1347918.8802
 |  | Audit & Legal | 22098.37 | 11431.29 | 181549.67 | 215079.33 | 463139 | 463139 | 463139 | 1389417 | 463139 | 463139 | 463139 | 1389417 | 463139 | 463139 | 463139 | 1389417 | 4383330.33
 |  | Occupancy Costs | 17385.79 | -20806.34 | 28152.91 | 24732.36 | 5000 | 5000 | 5000 | 15000 | 5000 | 5000 | 5000 | 15000 | 5000 | 5000 | 5000 | 15000 | 69732.36
 |  | General & Admin | 5361.69 | 12875.81 | 6736.32 | 24973.82 | 23476 | 23476 | 23476 | 70428 | 23476 | 23476 | 23476 | 70428 | 23476 | 23476 | 23476 | 70428 | 236257.82
 |  | Communications | 2649.07 | 2145.18 | 2792.03 | 7586.28 | 11194 | 11194 | 11194 | 33582 | 11194 | 11194 | 11194 | 33582 | 11194 | 11194 | 11194 | 33582 | 108332.28
 |  | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL G&A | 417462.79 | 361332.36 | 596570.26 | 1375365.41 | 1123283.2502 | 1129783.25 | 1129783.25 | 3382849.7502 | 1132803.25 | 1132803.25 | 1132803.25 | 3398409.75 | 1152529.25 | 1152529.25 | 1152529.25 | 3457587.75 | 11614212.6602
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual |  | Actual |  |  |  |  |  |  |  |  |  |  |  | one month |  | 7 months
 | Actuals | Salaries & Wages | 273488.65 | 192916.37 | 245887.86 | 712292.88 | 393754.8 | 200296.5 | 141347 |  | 186815 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Travel & Entertainment | 9454.2 | 27605.9 | 45642.43 | 82702.53 | 43687.84 | 26480.92 | 36772 |  | 50548 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Office Expenses | 8038.87 | 1827.13 | 7785.33 | 17651.33 | 1301.98 | 832.91 | 931 |  | 4894 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Consultancy | 78986.15 | 133337.02 | 78023.71 | 290346.88 | 152519.09 | 34053.13 | 40057 |  | 197685 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Audit & Legal | 22098.37 | 11431.29 | 181549.67 | 215079.33 | 7912.5 | 3700.14 | 41143 |  | 15037 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Occupancy Costs | 17385.79 | -20806.34 | 28152.91 | 24732.36 | 23128.98 | 11680.23 | 27933 |  | 20941 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | General & Admin | 5361.69 | 12875.81 | 6736.32 | 24973.82 | 84356.66 | 7075.33 | -1112 |  | 26177 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Communications | 2649.07 | 2145.18 | 2792.03 | 7586.28 | 281.1 | 5017.08 | 2704 |  | 5398 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  | TOTAL G&A | 417462.79 | 361332.36 | 596570.26 | 1375365.41 | 706942.95 | 289136.24 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual |  | CE2 | CE2 | CE2 | CE2 | CE2 | CE2 | CE2 |  | Full year
 | CE2 -  End of Q2 | Salaries & Wages |  |  |  |  |  |  |  | 887133.55 |  |  |  | 888306.75 |  |  |  | 947484.75
 |  | Travel & Entertainment |  |  |  |  |  |  |  | 282538.76 |  |  |  |  |  |  |  | 637110
 |  | Office Expenses |  |  |  |  |  |  |  | 6148.89 |  |  |  | 12042 |  |  |  | 12042
 |  | Consultancy |  |  |  |  |  |  |  | 304080.22 |  |  |  | 352524 |  |  |  | 352524
 |  | Audit & Legal |  |  |  |  |  |  |  | 474751.64 |  |  |  | 1389417 |  |  |  | 1389417
 |  | Occupancy Costs |  |  |  |  |  |  |  | 39809.21 |  |  |  | 15000 |  |  |  | 15000
 |  | General & Admin |  |  |  |  |  |  |  | 114907.99 |  |  |  | 70428 |  |  |  | 70428
 |  | Communications |  |  |  |  |  |  |  | 16492.18 |  |  |  | 33582 |  |  |  | 33582
 |  | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL G&A
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual |  | Actual | Ave Month | Ave Month | CE2 | Ave Month | Ave Month | Ave Month |  | Full year
 | Full Year F/cast on current run rate. | Salaries & Wages
 |  | Travel & Entertainment
 |  | Office Expenses
 |  | Consultancy
 |  | Audit & Legal
 |  | Occupancy Costs
 |  | General & Admin
 |  | Communications
 |  | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | TOTAL G&A | 417462.79 | 361332.36 | 596570.26 | 1375365.41 | 706942.95 | 289136.24
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual |  | Actual | CE2 | CE2 | CE2 | CE2 | CE2 | CE2 |  | Full year Forecast
 | CE3  - Forecast only | Salaries & Wages |  |  |  |  |  |  |  | 887133.55 |  |  |  |  |  |  |  | 947484.75
 |  | Travel & Entertainment |  |  |  |  |  |  |  | 282538.76 |  |  |  |  |  |  |  | 637110
 |  | Office Expenses |  |  |  |  |  |  |  | 6148.89 |  |  |  |  |  |  |  | 12042
 |  | Consultancy |  |  |  |  |  |  |  | 304080.22 |  |  |  |  |  |  |  | 352524
 |  | Audit & Legal |  |  |  |  |  |  |  | 474751.64 |  |  |  |  |  |  |  | 1389417
 |  | Occupancy Costs |  |  |  |  |  |  |  | 39809.21 |  |  |  |  |  |  |  | 15000
 |  | General & Admin |  |  |  |  |  |  |  | 114907.99 |  |  |  |  |  |  |  | 70428
 |  | Communications |  |  |  |  |  |  |  | 16492.18 |  |  |  |  |  |  |  | 33582
 |  | Taxes Other Than Income |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  | TOTAL G&A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gap to CE2 (Reduction) / Increase