Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Adaytum by Month

 | ( Refresh 3 views for your relevant CC or Region )
 | 2002 Plan
 | Adaytum
 | Value USD | Total Cost | Legal | Budget 2002
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Total Salaries & Wages | 359622.4046113845 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981 | 370024.2780300981
 | Total Travel and Entertainment | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230 | 19230
 | Total Office Costs | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935 | 4935
 | Total Consultancy Costs | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755 | 5755
 | Total Legal & Audit | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665 | 1094665
 | Total Occupancy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Other GA | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988 | 35988
 | Communications Costs | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560 | 7560
 | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL G&A
 | 2001
 | Adaytum
 | Forecast | Legal | Consolidated
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full year | Adjustments | Adjust 2001
 | Salaries & Wages | 388675.09 | 636647.69 | 826524.04 | 492377.04 | 582589.91 | 442329.46 | 428255.31 | 471500.97 | 518775.5192809377 | 514275.5192806477 | 547494.5817815121 | 576213.6442820865 | 6425658.774625184
 | Travel & Entertainment | 30908.75 | 41996.41 | 48513.31 | 21046.76 | 39396.1 | 40544.62 | 52515.94 | 18177.28 | 43013 | 43015 | 43015 | 43009 | 465151.17
 | Office Expenses | 6246.33 | 5728.52 | 6241.52 | 3596.19 | 1369.37 | 12575.47 | 3799.4 | 4574.32 | 7461 | 7461 | 7461 | 7461 | 73975.12
 | Consultancy | 11275.56 | 6856.509999999982 | 204442.9 | 12542.66 | 13852.22 | 2100055.16 | 30725.77 | -2084948.48 | 67955 | 29021 | 116622 | 29021 | 537421.3
 | Audit & Legal | 625481.71 | -113961.29 | 881164.18 | 4237568 | 1128961.21 | 877476.6 | 312179.06 | 1954576.17 | 3444522 | 1244522 | 1244522 | 1244522 | 17081533.64
 | Occupancy Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | General & Admin | 2285.5 | 21896.71 | 240910.32 | 38494.91 | 6917.53 | 1713.33 | 16224.89 | 7836.25 | 7878 | 7878 | 7878 | 7876 | 367789.44
 | Communications | 3882.39 | 3476.91 | 5057.9 | 1372.48 | 5841.27 | 5821.83 | 5053.55 | 11379.82 | 3980 | 3980 | 3980 | 3980 | 57806.15
 | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL G&A | 1068755.33 | 602641.4600000005 | 2212854.17 | 4806998.04 | 1778927.61 | 3480516.47 | 848753.92 | 383096.3299999995 | 4093584.519280938 | 1850152.519280648 | 1970972.581781512 | 1912082.644282087 | 25009335.59462519
 | 2001 Plan |  |  |  |  |  |  |  |  |  |  |  | Monthly Adjustment (000's)
 | Adaytum
 | Budget | Legal | Consolidated
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full year
 | Salaries & Wages | 431778.8712686568 | 448482.4888059702 | 561234.3544776123 | 561234.3544776123 | 561234.3544776123 | 580264.2052238809 | 580264.2052238809 | 580264.2052238809 | 580264.2052238809 | 580264.2052238809 | 580264.2052238809 | 580264.2052238809 | 6625813.860074631
 | Travel & Entertainment | 41646.26865671641 | 41646.26865671641 | 41644.77611940301 | 41646.26865671641 | 41646.26865671641 | 41644.77611940301 | 41646.26865671641 | 41646.26865671641 | 41644.77611940301 | 41646.26865671641 | 41646.26865671641 | 41640.29850746271 | 499744.776119403
 | Office Expenses | 7461.686567164175 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 7461.194029850745 | 89534.82089552237
 | Consultancy | 29022.3880597015 | 29020.8955223881 | 29022.3880597015 | 29020.8955223881 | 29022.3880597015 | 29020.8955223881 | 29022.3880597015 | 29020.8955223881 | 29022.3880597015 | 29020.8955223881 | 29022.3880597015 | 29020.8955223881 | 348259.7014925376
 | Audit & Legal |  |  |  |  |  |  |  |  |  |  |  |  | 14934264
 | Occupancy Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | General & Admin | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7877.6119402985 | 7874.62686567164 | 94528.35820895513
 | Communications | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 3900 | 46800
 | Taxes Other Than Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL G&A