Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Adaytum by Month

 | ( Refresh 3 views for your relevant CC or Region )
 | 2002 Plan
 | Adaytum
 | Value USD | Total Cost | EEL European Govt Affairs | Budget 2002
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Total Salaries & Wages
 | Total Travel and Entertainment
 | Total Office Costs
 | Total Consultancy Costs
 | Total Occupancy
 | Total Legal & Audit
 | Total Other GA
 | Communications Costs
 | Taxes Other Than Income |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL G&A
 | 2001 Forecast
 | Adaytum
 | Forecast | EEL European Govt Affairs | Consolidated
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full year | Adjustments | Adjust 2001
 | Salaries & Wages | 273488.65 | 192916.37 | 245887.86 | 393754.8 | 200296.5 | 141506.58 | 186815 | 196041.46 | 296101.6416666667 | 315828.4416666667 | 315828.4416666667 | 315828.4416666667 | 3074294.186666667
 | Travel & Entertainment | 9454.2 | 27605.9 | 45642.43 | 43687.84 | 26480.92 | 36771.96 | 50547.97 | 17189.09 | 198765 | 198765 | 198765 | 198765 | 1052440.31
 | Office Expenses | 8038.87 | 1827.13 | 7785.33 | 1301.98 | 832.91 | 930.78 | 4894.48 | 9519.27 | 4996 | 4996 | 4996 | 4996 | 55114.75
 | Consultancy | 78986.15 | 133337.02 | 78023.71 | 152519.09 | 34053.13 | 40057.25 | 197684.55 | 123224.59 | 125582 | 125582 | 125582 | 125582 | 1340213.49
 | Audit & Legal | 22098.37 | 11431.29 | 181549.67 | 7912.5 | 3700.14 | 41142.71 | 15036.74 | 328993.15 | 615583 | 615583 | 615583 | 615583 | 3074196.57
 | Occupancy Costs | 17385.79 | -20806.34 | 28152.91 | 23128.98 | 11680.23 | 27933.11 | 20941.08 | 0 | 5000 | 5000 | 5000 | 5000 | 128415.76
 | General & Admin | 5361.69 | 12875.81 | 6736.32 | 84356.66 | 7075.33 | -1111.92 | 26177 | 14867.98 | 16060 | 16060 | 16060 | 16060 | 220578.87
 | Communications | 2649.07 | 2145.18 | 2792.03 | 281.1 | 5017.08 | 2704.37 | 5398.28 | 5834.36 | 10093 | 10093 | 10093 | 10093 | 67193.47
 | 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 | 695669.9 | 1272180.641666667 | 1291907.441666667 | 1291907.441666667 | 1291907.441666667 | 9012447.406666666
 | 2001 Plan |  |  |  |  |  |  |  |  |  |  |  | Monthly Adjustment (000's)
 | Adaytum
 | Budget | EEL European Govt Affairs | Consolidated
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full year
 | Salaries & Wages | 430587.6865671641 | 435790.7649253731 | 435790.7649253731 | 435790.7649253731 | 435790.7649253731 | 435790.7649253731 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 446891.5111940298 | 5290890.578358209
 | Travel & Entertainment | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 166170.1492537308 | 166168.6567164178 | 166168.6567164178 | 1994029.850746266
 | Office Expenses | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 3731.34328358209 | 44776.11940298508
 | Consultancy | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 106326.8656716418 | 1275922.388059702
 | Audit & Legal | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 371277.611940298 | 4455331.343283576
 | Occupancy Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | General & Admin | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 25498.50746268664 | 25497.01492537314 | 25497.01492537314 | 305970.1492537317
 | Communications | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 11194.0298507463 | 134328.3582089556
 | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL G&A | 1114786.19402985 | 1119986.287313432 | 1119986.287313432 | 1119989.272388059 | 1119986.287313432 | 1119986.287313432 | 1131090.018656716 | 1131087.033582089 | 1131087.033582089 | 1131090.018656716 | 1131087.033582089 | 1131087.033582089 | 13501248.78731342