Embed
Email

plan

Document Sample

Shared by: xiaoyounan
Categories
Tags
Stats
views:
0
posted:
12/29/2011
language:
pages:
30
12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

Labor









Labor Budget Type:

Fiscal Year Ending 0=NonTech

December 31, 2004 1=Tech

2=Principal (same as Tech)

Data Entry Hours

Hourly 1998 1999 2000 2001 2002 2003 Plan Emp. Tech NonTech

Employee Pay Actual Actual Actual Actual Actual Actual Target PTO PTO PTO Rate Monthly Ins. Cell 401K Tech Tech Indirect Total NonTech Indirect Total

Number Name Position Rate Type Utilizztion Utilizztion Utilizztion Utilizztion Utilizztion Utilization Utilization Standard_Hrs Holiday Vacation Personal WComp Health_Ins Withheld Phone Plan Direct Indirect PTO Tech Indirect PTO NonTech





Principal

59.48 2 61.00% 61.10% 61.40% 48.90% 45.70% 48.30% 50.00% 2080 64 120 0 1.50% 626.96 0.00 0 0 1040 856 184 2080 0 0 0

56.22 2 82.60% 96.60% 91.00% 89.70% 77.70% 88.00% 85.00% 2080 64 120 0 1.50% 888.49 0.00 0 0 1768 128 184 2080 0 0 0

50.77 2 64.50% 67.20% 54.00% 44.10% 33.50% 55.30% 55.00% 2080 64 120 0 1.50% 626.98 0.00 0 0 1144 752 184 2080 0 0 0

Employee:

42.91 1 81.60% 94.20% 95.10% 45.70% 69.00% 74.30% 75.00% 2080 64 120 0 2.00% 626.96 309.98 0 0 1560 336 184 2080 0 0 0

41.40 1 70.90% 59.90% 54.30% 56.50% 60.50% 80.90% 85.00% 2080 64 120 0 2.00% 888.49 0 0 1768 128 184 2080 0 0 0

40.38 1 93.30% 90.40% 94.20% 71.40% 70.30% 63.70% 70.00% 2080 64 120 0 2.00% 888.49 0 0 1456 440 184 2080 0 0 0

36.59 1 89.30% 72.20% 57.50% 48.10% 50.70% 66.00% 70.00% 2080 64 120 0 2.00% 316.98 0 0 1456 440 184 2080 0 0 0

36.54 1 42.10% 73.70% 72.40% 27.70% 41.60% 63.50% 70.00% 2080 64 120 0 2.00% 580.81 263.83 0 0 1456 440 184 2080 0 0 0

33.56 1 79.20% 81.00% 83.60% 48.10% 73.70% 74.10% 75.00% 2080 64 120 0 2.00% 316.98 0 0 1560 336 184 2080 0 0 0

32.81 1 100.00% 72.20% 62.40% 56.60% 47.30% 26.60% 30.00% 2080 64 80 0 0.50% 888.49 0 0 624 1312 144 2080 0 0 0

30.29 1 93.30% 89.20% 92.90% 90.30% 57.20% 90.60% 85.00% 2080 64 120 0 2.00% 580.81 263.83 0 0 1768 128 184 2080 0 0 0

29.86 1 89.70% 100.00% 100.70% 83.10% 41.90% 96.80% 85.00% 2080 64 80 0 2.00% 626.96 309.98 0 0 1768 168 144 2080 0 0 0

29.08 1 89.90% 94.70% 83.20% 85.80% 88.40% 80.10% 85.00% 2080 64 120 0 2.00% 316.98 0 0 1768 128 184 2080 0 0 0

27.26 1 88.80% 85.00% 2080 64 120 0 2.00% 888.49 571.51 0 0 1768 128 184 2080 0 0 0

26.35 1 91.20% 92.40% 88.30% 92.20% 87.40% 91.80% 85.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 1768 128 184 2080 0 0 0

25.75 1 0.00% 0.00% 0.00% 0.00% 0.00% 95.40% 85.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 1768 128 184 2080 0 0 0

25.75 1 64.30% 70.80% 85.90% 48.90% 71.30% 74.20% 75.00% 2080 64 120 0 0.50% 316.98 0 0 1560 336 184 2080 0 0 0

25.44 1 85.50% 87.30% 85.00% 77.20% 66.60% 59.90% 80.00% 2080 64 120 0 0.50% 316.98 0 0 1664 232 184 2080 0 0 0

24.23 1 86.00% 90.60% 80.60% 88.90% 85.80% 66.00% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

24.23 1 88.90% 77.70% 84.20% 66.80% 74.30% 72.00% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

23.17 1 62.40% 63.40% 60.40% 52.20% 63.30% 44.50% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

22.58 1 60.20% 89.70% 72.50% 60.40% 57.20% 78.80% 85.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 1768 128 184 2080 0 0 0

22.44 1 86.00% 90.60% 80.60% 88.90% 85.80% 86.30% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

22.21 1 86.00% 90.60% 80.60% 88.90% 85.80% 58.10% 85.00% 2080 64 80 0 2.00% 316.98 0 0 1768 168 144 2080 0 0 0

21.15 1 0.00% 0.00% 0.00% 0.00% 76.50% 59.50% 85.00% 2080 64 80 0 0.50% 316.98 0.00 0 0 1768 168 144 2080 0 0 0

21.00 1 91.20% 92.40% 94.50% 92.30% 92.00% 92.80% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

21.00 1 91.90% 89.40% 88.90% 90.10% 66.40% 47.20% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

17.26 1 66.90% 66.30% 58.20% 57.10% 50.10% 84.50% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

15.75 1 73.10% 85.00% 2080 64 80 0 0.50% 316.98 0.00 0 0 1768 168 144 2080 0 0 0

15.38 1 90.20% 100.00% 87.40% 88.10% 90.90% 90.30% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

14.70 1 93.80% 78.30% 77.90% 70.40% 61.20% 86.40% 85.00% 2080 64 120 0 0.50% 316.98 0 0 1768 128 184 2080 0 0 0

14.70 1 85.20% 86.80% 73.20% 86.30% 84.60% 88.20% 85.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 1768 128 184 2080 0 0 0

7.50 1 85.00% 2080 64 80 0 0.50% 316.98 0.00 0 0 1768 168 144 2080 0 0 0



36.75 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 0 0 0 0 1896 184 2080

35.38 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 0 0 0 0 1896 184 2080

28.77 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0.00 0 0 0 0 0 0 1896 184 2080

20.50 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0 0 0 0 0 0 1896 184 2080

18.87 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0 0 0 0 0 0 1896 184 2080

18.87 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0 0 0 0 0 0 1896 184 2080

17.93 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 580.81 263.83 0 0 0 0 0 0 1896 184 2080

17.26 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0 0 0 0 0 0 1896 184 2080

15.14 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 120 0 0.50% 316.98 0 0 0 0 0 0 1896 184 2080

9.00 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2080 64 80 0 0.50% 316.98 0 0 0 0 0 0 1936 144 2080

7.35 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 520 8 0 0 0.50% 0.00 0 0 0 0 0 0 512 8 520

7.00 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 520 8 0 0 0.50% 0.00 0 0 0 0 0 0 512 8 520

6.00 0 0.00% 0.00% 520 8 0 0 0.50% 0.00 0 0 0 0 0 0 512 8 520

0 0 0 0 0 0 0









Principal 166.47 63.33% 6240 576 360 0 2142.43 0.00 0 0 3952 1736 552 6240 0 0 0

Employee 1010.09 59.26% 84760 2648 4520 0 16376.69 1982.96 0 0 50232 6888 5280 62400 20536 1824 22360



Total 1176.56 58.00% 60.00% 60.00% 50.10% 47.60% 53.50% 59.54% 91000 3224 4880 0 18519.12 1982.96 0 0 54184 8624 5832 68640 20536 1824 22360

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

Labor









Labor Budget

Fiscal Year Ending

December 31, 2004



Data Entry Dollars

Available Annual Tech Tech Tech Total NonTech NonTech Total Total Bonus Annual Long

Employee Total Total less Base Total Direct Indir Indirect Tech Indir PTO NonTech PTO PTO PTO Total Wages FICA Fed State Workers Health Term

Number Name Available PTO PTO Wage Raises Wages Labor Labor PTO Labor Labor Labor Labor Holiday Vacation Personal PTO Less PTO FICA Medicare &MC Unemp Unemp Comp Ins Disability





Principal

2080 184 1896 123718 0 123718 61859 50915 10944 123718 0 0 0 3807 7138 0 10944 112774 5394 1794 1013 56 15 1856 7524 668

2080 184 1896 116938 0 116938 99397 7196 10344 116938 0 0 0 3598 6746 0 10344 106593 5394 1696 383 56 15 1754 10662 631

2080 184 1896 105602 0 105602 58081 38179 9342 105602 0 0 0 3249 6092 0 9342 96260 5394 1531 346 56 15 1584 7524 570

Employee: 0

2080 184 1896 89253 0 89253 66940 14418 7895 89253 0 0 0 2746 5149 0 7895 81357 5394 1294 259 56 15 1785 3804 482

2080 184 1896 86112 0 86112 73195 5299 7618 86112 0 0 0 2650 4968 0 7618 78494 5339 1249 305 56 15 1722 10662 465

2080 184 1896 83990 0 83990 58793 17767 7430 83990 0 0 0 2584 4846 0 7430 76560 5207 1218 430 56 15 1680 10662 454

2080 184 1896 76107 0 76107 53275 16100 6733 76107 0 0 0 2342 4391 0 6733 69375 4719 1104 896 56 15 1522 3804 411

2080 184 1896 76003 0 76003 53202 16078 6723 76003 0 0 0 2339 4385 0 6723 69280 4712 1102 902 56 15 1520 3804 410

2080 184 1896 69805 0 69805 52354 11276 6175 69805 0 0 0 2148 4027 0 6175 63630 4328 1012 1068 56 15 1396 3804 377

2080 144 1936 68245 0 68245 20473 43047 4725 68245 0 0 0 2100 2625 0 4725 63520 4231 990 1044 56 15 341 10662 369

2080 184 1896 63003 0 63003 53553 3877 5573 63003 0 0 0 1939 3635 0 5573 57430 3906 914 964 56 15 1260 3804 340

2080 144 1936 62109 0 62109 52792 5016 4300 62109 0 0 0 1911 2389 0 4300 57809 3851 901 950 56 15 1242 3804 335

2080 184 1896 60486 0 60486 51413 3722 5351 60486 0 0 0 1861 3490 0 5351 55136 3750 877 925 56 15 1210 3804 327

2080 184 1896 56701 0 56701 48196 3489 5016 56701 0 0 0 1745 3271 0 5016 51685 3515 822 868 56 15 1134 3804 306

2080 184 1896 54808 0 54808 46587 3373 4848 54808 0 0 0 1686 3162 0 4848 49960 3398 795 839 56 15 274 3804 296

2080 184 1896 53560 0 53560 45526 3296 4738 53560 0 0 0 1648 3090 0 4738 48822 3321 777 819 56 15 268 3804 289

2080 184 1896 53560 0 53560 40170 8652 4738 53560 0 0 0 1648 3090 0 4738 48822 3321 777 819 56 15 268 3804 289

2080 184 1896 52915 0 52915 42332 5902 4681 52915 0 0 0 1628 3053 0 4681 48234 3281 767 810 56 15 265 3804 286

2080 184 1896 50398 0 50398 42839 3101 4458 50398 0 0 0 1551 2908 0 4458 45940 3125 731 771 56 15 252 3804 272

2080 184 1896 50398 0 50398 42839 3101 4458 50398 0 0 0 1551 2908 0 4458 45940 3125 731 771 56 15 252 3804 272

2080 184 1896 48194 0 48194 40965 2966 4263 48194 0 0 0 1483 2780 0 4263 43930 2988 699 737 56 15 241 3804 260

2080 184 1896 46966 0 46966 39921 2890 4155 46966 0 0 0 1445 2710 0 4155 42812 2912 681 719 56 15 235 3804 254

2080 184 1896 46675 0 46675 39674 2872 4129 46675 0 0 0 1436 2693 0 4129 42546 2894 677 714 56 15 233 3804 252

2080 144 1936 46197 0 46197 39267 3731 3198 46197 0 0 0 1421 1777 0 3198 42999 2864 670 707 56 15 924 3804 249

2080 144 1936 43992 0 43992 37393 3553 3046 43992 0 0 0 1354 1692 0 3046 40946 2728 638 673 56 15 220 3804 238

2080 184 1896 43680 0 43680 37128 2688 3864 43680 0 0 0 1344 2520 0 3864 39816 2708 633 668 56 15 218 3804 236

2080 184 1896 43680 0 43680 37128 2688 3864 43680 0 0 0 1344 2520 0 3864 39816 2708 633 668 56 15 218 3804 236

2080 184 1896 35901 0 35901 30516 2209 3176 35901 0 0 0 1105 2071 0 3176 32725 2226 521 549 56 15 180 3804 194

2080 144 1936 32760 0 32760 27846 2646 2268 32760 0 0 0 1008 1260 0 2268 30492 2031 475 0 56 15 164 3804 0

2080 184 1896 31990 0 31990 27192 1969 2830 31990 0 0 0 984 1846 0 2830 29160 1983 464 489 56 15 160 3804 173

2080 184 1896 30576 0 30576 25990 1882 2705 30576 0 0 0 941 1764 0 2705 27871 1896 443 468 56 15 153 3804 165

2080 184 1896 30576 0 30576 25990 1882 2705 30576 0 0 0 941 1764 0 2705 27871 1896 443 468 56 15 153 3804 165

2080 144 1936 15600 0 15600 13260 1260 1080 15600 0 0 0 480 600 0 1080 14520 967 226 239 56 15 78 3804 84



2080 184 1896 76440 0 76440 0 0 0 0 69678 6762 76440 2352 4410 0 6762 69678 4739 1108 876 56 15 382 3804 413

2080 184 1896 73590 0 73590 0 0 0 0 67080 6510 73590 2264 4246 0 6510 67080 4563 1067 1045 56 15 368 3804 397

2080 184 1896 59842 0 59842 0 0 0 0 54548 5294 59842 1841 3452 0 5294 54548 3710 868 916 56 15 299 3804 323

2080 184 1896 42640 0 42640 0 0 0 0 38868 3772 42640 1312 2460 0 3772 38868 2644 618 652 56 15 213 3804 230

2080 184 1896 39250 0 39250 0 0 0 0 35778 3472 39250 1208 2264 0 3472 35778 2433 569 601 56 15 196 3804 212

2080 184 1896 39250 0 39250 0 0 0 0 35778 3472 39250 1208 2264 0 3472 35778 2433 569 601 56 15 196 3804 212

2080 184 1896 37294 0 37294 0 0 0 0 33995 3299 37294 1148 2152 0 3299 33995 2312 541 571 56 15 186 3804 201

2080 184 1896 35901 0 35901 0 0 0 0 32725 3176 35901 1105 2071 0 3176 32725 2226 521 549 56 15 180 3804 194

2080 184 1896 31491 0 31491 0 0 0 0 28705 2786 31491 969 1817 0 2786 28705 1952 457 482 56 15 157 3804 170

2080 144 1936 18720 0 18720 0 0 0 0 17424 1296 18720 576 720 0 1296 17424 1161 271 286 56 15 94 3804 101

520 8 512 3822 0 3822 0 0 0 0 3763 59 3822 59 0 0 59 3763 237 55 58 31 8 19 0 21

520 8 512 3640 0 3640 0 0 0 0 3584 56 3640 56 0 0 56 3584 226 53 56 29 8 18 0 20

520 8 512 3120 0 3120 0 0 0 0 3072 48 3120 48 0 0 48 3072 193 45 48 25 7 16 0 17

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0









Principal 6240 552 5688 346258 0 346258 219337 96290 30630 346258 0 0 0 10654 19976 0 30630 315627 16182 5021 1743 168 44 5194 25709 1870

Employee 84760 7104 77656 2069241 0 2069241 1266748 200751 136742 1604242 424998 40001 465000 63506 113238 0 176744 1892497 128153 30004 27281 2325 610 21893 172725 10997



Total 91000 7656 83344 2415499 0 2415499 1486085 297041 167373 1950499 424998 40001 465000 74160 133214 0 207374 2208125 144335 35025 29023 2493 654 16000 198434 12867

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

Labor









Labor Budget

Fiscal Year Ending

December 31, 2004



Data Entry

Retirement

Employee Plan Cash DPE Billing

Number Name Contrib Bonus Rate Rate





Principal

29040 69879 83.02 192.89

21506 26435 78.47 182.32

19421 23874 70.86 164.64

Employee:

16066 17851 59.89 139.15

15500 17222 57.79 134.26

15118 16798 56.36 130.95

13699 15221 51.07 118.66

13681 15201 51.00 118.50

12565 13961 46.84 108.83

12284 13649 45.80 106.40

11341 12601 42.28 98.23

11180 12422 41.68 96.83

10888 12097 40.59 94.30

10206 11340 38.05 88.40

9865 10962 36.78 85.45

9641 10712 35.94 83.51

9641 10712 35.94 83.51

9525 10583 35.51 82.50

9072 10080 33.82 78.58

9072 10080 33.82 78.58

8675 9639 32.34 75.14

8454 9393 31.52 73.23

8402 9335 31.32 72.77

8315 9239 31.00 72.03

7919 8798 29.52 68.59

7862 8736 29.31 68.10

7862 8736 29.31 68.10

6462 7180 24.09 55.97

0 0 21.98 51.08

5758 6398 21.47 49.88

5504 6115 20.52 47.67

5504 6115 20.52 47.67

2808 3120 10.47 24.32



13759 15288 51.30 119.18

13246 14718 49.38 114.74

10771 11968 40.16 93.30

7675 8528 28.61 66.48

7065 7850 26.34 61.19

7065 7850 26.34 61.19

6713 7459 25.03 58.15

6462 7180 24.09 55.97

5668 6298 21.13 49.10

3370 3744 12.56 29.19

688 764 10.26 23.84

655 728 9.77 22.70

562 624 8.37 19.46

0 0 0.00 0.00









Principal 69967 120189

Employee 366567 407296



Total 436534 527485

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

FormulaVariables



Formula Variables: Value Plan





Federal unemployment rate 0.80%

Federal unemployment amount 7,000

State unemployment rate 0.21%

State unemployment amount 7,000

Disability insurance premium per $1,000 0.54%

Bonus percent of base pay 20.00%

Retirement plan contribution percent of base pay 15.00%

Standard hours 2,080

Annual raise percentage 0.00%

No. months raise effective 0.000

Fica wages 87,000

Fica rate 6.20%

Medicare wages 999,999

Medicare rate 1.45%

Net multiplier 3.24 3.24

DPE factor 1.40 1.40

Multiple of DPE 2.32 2.32





Formula Variables: (value must be 1.00 or more)

Mark-up Value

Reimbursable consultant multiple 1.00

Other reimbursable expense multiple 1.00

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

FormulaVariables

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitTarget

Acct *LB=from Labor Budget module Per

No. Operating Profit Target Amount Share Shares

Increase in net worth 135,000 $30.00 4,500

Dividend - $0.00 4,500

987.00 *LB-Cash bonus 527,485 20% Labor

986.00 *LB-Bonus FICA tax 29,023

988.00 *LB-Retirement plan contribution 436,534 15% Compensation

999.00 Provision for federal and state income tax 73,403



Total profit 1,201,445



Less: Other Nonoperating Revenue

811.10 Interest income (6,000)

811.20 Cash Value-Life Insurance-net increase (700)

811.30 Sale of assets-gain or (loss) -

811.40 Recovery of bad debt write-off -



Total other nonoperating revenue (6,700)



Operating profit target 1,194,745

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003



Revenue:

401.10 Billed Fee-Lump Sum 5,280,044 440,004 4,933,658.65 81.11% 81.11% 109.56% 101.31% 69.60% 65.46%

401.20 Billed Fee-DPE/Hourly 1,159,342 96,612 1,083,285.96 17.81% 17.81% 24.06% 22.25% 15.28% 14.37%

401.30 Billed Fee-Extra Service 70,439 5,870 65,817.58 1.08% 1.08% 1.46% 1.35% 0.93% 0.87%

411.00 Other 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%



Total Billed Fee 6,509,824 542,485 6,082,762.19 100.00% 100.00% 135.08% 124.91% 85.81% 80.71%





Reimbursable expense revenue:

421.00 Reimb Consultant 910,570 75,881 940,829.81 84.59% 86.50% 18.89% 19.32% 12.00% 12.48%

422.00 Reimb Other 165,852 13,821 146,865.47 15.41% 13.50% 3.44% 3.02% 2.19% 1.95%



Total reimbursable expense revenue 1,076,422 89,702 1,087,695.28 100.00% 100.00% 22.34% 22.34% 14.19% 14.43%





402.00 Unbilled Revenue-WIP 0 0 366,551.16 0.00% 7.53% 0.00% 4.86%



Total revenue 7,586,246 632,187 7,537,008.63 157.41% 154.77% 100.00% 100.00%



Reimbursable expense

Consultants

511.00 Structural 7,908 659 7,045.08 0.87% 0.16% 0.14% 0.10% 0.09%

512.00 Mechanical 178,516 14,876 159,043.90 19.60% 3.70% 3.27% 2.35% 2.11%

513.00 Electrical 456,245 38,020 406,477.50 50.11% 9.47% 8.35% 6.01% 5.39%

514.00 Mechanical & Electrical 673 56 600.00 0.07% 0.01% 0.01% 0.01% 0.01%

515.00 Civil 115,111 9,593 102,554.53 12.64% 2.39% 2.11% 1.52% 1.36%

515.50 Civil-Survey 224 19 200.00 0.02% 0.00% 0.00% 0.00% 0.00%

516.00 Landscape 6,123 510 5,455.00 0.67% 0.13% 0.11% 0.08% 0.07%

517.00 Sprinkler 140,984 11,749 125,605.75 15.48% 2.93% 2.58% 1.86% 1.67%

518.00 Architectural 4,786 399 4,263.60 0.53% 0.10% 0.09% 0.06% 0.06%

519.00 Other 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



Total consultants 910,570 75,881 811,245.36 100.00% 84.59% 18.89% 16.66% 12.00% 10.76%



Other reimbursable expense

541.00 Lodging 13,152 1,096 11,717.45 7.93% 0.27% 0.24% 0.17% 0.16%

542.00 Meals-Reimbursable 5,167 431 4,603.82 3.12% 0.11% 0.09% 0.07% 0.06%

543.00 Commercial Air Travel 48,552 4,046 43,256.31 29.27% 1.01% 0.89% 0.64% 0.57%

543.10 Commercial Air Travel-Airport Parking 35 3 31.00 0.02% 0.00% 0.00% 0.00% 0.00%

544.00 Charter Air Travel 18,435 1,536 16,424.29 11.12% 0.38% 0.34% 0.24% 0.22%

545.00 Car Rental 8,663 722 7,718.01 5.22% 0.18% 0.16% 0.11% 0.10%

545.10 Car Rental-Gasoline 74 6 66.14 0.04% 0.00% 0.00% 0.00% 0.00%

546.00 Personal Auto Mileage 3,844 320 3,424.55 2.32% 0.08% 0.07% 0.05% 0.05%

547.00 Other Travel Expense 1,324 110 1,179.78 0.80% 0.03% 0.02% 0.02% 0.02%



561.00 Reproductions/Printing 16,878 1,406 15,036.56 10.18% 0.35% 0.31% 0.22% 0.20%

561.10 Reproductions - Inhouse 4,842 403 4,313.61 2.92% 0.10% 0.09% 0.06% 0.06%

562.00 Renderings/Photos/Models 576 48 513.45 0.35% 0.01% 0.01% 0.01% 0.01%

563.00 Postage/Ship/Delivery 22,574 1,881 20,112.04 13.61% 0.47% 0.41% 0.30% 0.27%

564.00 Plan Review-Fire Marshal 9,080 757 8,089.95 5.48% 0.19% 0.17% 0.12% 0.11%

565.00 Specification Repro 12,642 1,054 11,263.37 7.62% 0.26% 0.23% 0.17% 0.15%

566.00 Other Office Expense 12 1 10.25 0.01% 0.00% 0.00% 0.00% 0.00%



Total other reimbursable expense 165,852 13,821 147,760.58 100.00% 15.41% 3.44% 3.03% 2.19% 1.96%



Total reimbursable expense 1,076,422 89,702 959,005.94 100.00% 22.34% 19.69% 14.19% 12.72%



Revenue less reimbursable expense6,509,824 542,485 6,578,002.69 135.08% 135.08% 85.81% 87.28%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003



Other Direct Expense

Direct Consultants:

611.00 Structural 27,298 2,275 27,584 1.82% 0.57% 0.57% 0.36% 0.37%

612.00 Mechanical 514,651 42,888 520,040.70 34.23% 10.68% 10.68% 6.78% 6.90%

613.00 Electrical 638,796 53,233 645,486.38 42.49% 13.26% 13.26% 8.42% 8.56%

614.00 Mechanical & Electrical 11,000 917 11,115.00 0.73% 0.23% 0.23% 0.14% 0.15%

615.00 Civil 72,332 6,028 73,090.00 4.81% 1.50% 1.50% 0.95% 0.97%

616.00 Landscape 19,720 1,643 19,926.25 1.31% 0.41% 0.41% 0.26% 0.26%

617.00 Sprinkler 187,322 15,610 189,283.42 12.46% 3.89% 3.89% 2.47% 2.51%

618.00 Architectural 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

619.00 Other 32,443 2,704 32,782.48 2.16% 0.67% 0.67% 0.43% 0.43%



Total Direct Consultants 1,503,561 125,297 1,519,308.23 100.00% 31.20% 31.20% 19.82% 20.16%



Other Direct

640.00 Budget Travel 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

641.00 Lodging 9,878 823 9,980.98 5.28% 0.20% 0.20% 0.13% 0.13%

642.00 Meals-Direct 5,847 487 5,908.24 3.13% 0.12% 0.12% 0.08% 0.08%

643.00 Commercial Air 67,061 5,588 67,763.73 35.87% 1.39% 1.39% 0.88% 0.90%

643.10 Commercial Air-Airport Parking 95 8 96.00 0.05% 0.00% 0.00% 0.00% 0.00%

644.00 Charter Air 6,213 518 6,277.75 3.32% 0.13% 0.13% 0.08% 0.08%

645.00 Car Rental 10,145 845 10,251.59 5.43% 0.21% 0.21% 0.13% 0.14%

645.10 Car Rental-Gasoline 165 14 166.32 0.09% 0.00% 0.00% 0.00% 0.00%

646.00 Personal Auto Mileage 2,619 218 2,646.72 1.40% 0.05% 0.05% 0.03% 0.04%

647.00 Other Travel Expense 1,163 97 1,175.01 0.62% 0.02% 0.02% 0.02% 0.02%

658.00 Errors & omissions 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



661.00 Reproductions 6,360 530 6,426.31 3.40% 0.13% 0.13% 0.08% 0.09%

661.10 Reproductions - Inhouse 9,766 814 9,868.25 5.22% 0.20% 0.20% 0.13% 0.13%

662.00 Renderings/Photos/Models 374 31 377.44 0.20% 0.01% 0.01% 0.00% 0.01%

663.00 Postage/Shipping/Delivery 22,157 1,846 22,389.03 11.85% 0.46% 0.46% 0.29% 0.30%

664.00 Plan Review-Fire Marshall 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

665.00 Specification Printing 9,234 769 9,330.28 4.94% 0.19% 0.19% 0.12% 0.12%

666.00 Other Office Expense 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

669.00 Bad Debt Expense 35,906 2,992 36,282.17 19.20% 0.75% 0.75% 0.47% 0.48%



Total other direct expense 186,982 15,582 188,939.82 100.00% 3.88% 3.88% 2.46% 2.51%







Total direct consultants and other 1,690,543 140,879 1,708,248.05 35.08% 35.08% 22.28% 22.66%





Net revenue 4,819,281 401,607 4,869,754.64 100.00% 100.00% 63.53% 64.61%



Direct Labor

601.00 *LB-Direct Labor-Principals 219,337 18,278 199,338.31 4.55% 4.09% 2.89% 2.64%

602.00 *LB-Direct Labor-Employees 1,266,748 105,562 1,030,566.31 26.28% 21.16% 16.70% 13.67%



Total direct labor 1,486,085 123,840 1,229,904.62 30.84% 25.26% 19.59% 16.32%





Gross profit 3,333,196 277,766 3,639,850.02 69.16% 74.74% 43.94% 48.29%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003

Indirect Expense

Indirect Labor

701.00 *LB-Indirect Labor-Principals 96,290 8,024 6,385.13 4.50% 2.00% 0.13% 1.27% 0.08%

701.10 LB-Indirect Labor-Marketing 84,192.43

702.00 *LB-Indirect Labor-Technical 200,751 16,729 299,026.68 9.39% 4.17% 6.14% 2.65% 3.97%

702.10 *LB-Indirect Labor-Nontech. 424,998 35,417 393,121.05 19.87% 8.82% 8.07% 5.60% 5.22%

703.00 Payroll Variance 0 0 (5,606.20) 0.00% 0.00% -0.12% 0.00% -0.07%

703.01 Overtime Applied to Personal PTO 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

704.00 Temporary Help 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



Total indirect labor 722,039 60,170 777,119.09 33.76% 14.98% 15.96% 9.52% 10.31%



Paid-time-off

711.00 *LB-Holiday Pay 74,160 6,180 64,896.24 3.47% 1.54% 1.33% 0.98% 0.86%

712.00 *LB-Vacation Pay 133,214 11,101 107,317.12 6.23% 2.76% 2.20% 1.76% 1.42%

713.00 *LB-Personal Time-Off 0 0 (16,623.84) 0.00% 0.00% -0.34% 0.00% -0.22%



Total paid-time-off 207,374 17,281 155,589.52 9.70% 4.30% 3.20% 2.73% 2.06%



Payroll related expense

721.00 *LB-Employer's FICA Tax 144,335 12,028 160,576.62 6.75% 2.99% 3.30% 1.90% 2.13%

721.10 *LB-Employer's Medicare Tax 35,025 2,919 0.00 1.64% 0.73% 0.00% 0.46% 0.00%

722.00 *LB-Federal Unemployment 2,493 208 2,633.63 0.12% 0.05% 0.05% 0.03% 0.03%

723.00 *LB-State Unemployment 654 55 3,066.42 0.03% 0.01% 0.06% 0.01% 0.04%

724.00 *LB-Workers' Comp Insurance 16,000 1,333 13,555.66 0.75% 0.33% 0.28% 0.21% 0.18%

729.00 Misc Employee Benefits 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



Total payroll related expense 198,507 16,542 179,832.33 9.28% 4.12% 3.69% 2.62% 2.39%



Benefits

731.00 *LB-Health Care Insurance 198,434 16,536 191,206.88 9.28% 4.12% 3.93% 2.62% 2.54%

731.01 Health Care Insurance Withheld 0 0 (18,124.16) 0.00% 0.00% -0.37% 0.00% -0.24%

731.10 Employee Medical Expense 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

732.10 Stockholders Physical 2,000 167 2,078.00 0.09% 0.04% 0.04% 0.03% 0.03%

733.00 *LB-Disability Income Ins. 12,867 1,072 12,840.22 0.60% 0.27% 0.26% 0.17% 0.17%

734.00 *LB-401K 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

735.10 Retirement Plan Fees 10,000 833 8,590.87 1.31% 0.21% 0.18% 0.13% 0.11%

737.00 Professional Development 7,000 583 7,132.95 0.92% 0.15% 0.15% 0.09% 0.09%

738.00 Professional Registration 13,000 1,083 12,875.00 1.70% 0.27% 0.26% 0.17% 0.17%

739.00 Employee Relations 3,400 283 3,385.74 0.45% 0.07% 0.07% 0.04% 0.04%

739.10 Moving Expenses 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

739.20 *LB-Cell Phone 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



Total benefits 246,701 20,558 219,985.50 11.54% 5.12% 4.52% 3.25% 2.92%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003

Other indirect expense

741.00 Lodging 18,000 1,500 17,573.86 2.36% 0.37% 0.36% 0.24% 0.23%

742.00 Meals-Indirect 8,400 700 8,338.64 1.10% 0.17% 0.17% 0.11% 0.11%

743.00 Commercial Air Travel 21,200 1,767 21,189.40 2.78% 0.44% 0.44% 0.28% 0.28%

744.00 Charter Air Travel 8,200 683 8,199.52 1.07% 0.17% 0.17% 0.11% 0.11%

744.10 Charter Air Travel-Discounts(CR) 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

745.00 Car Rental 5,700 475 5,654.83 0.75% 0.12% 0.12% 0.08% 0.08%

746.00 Personal Auto Mileage 4,200 350 4,159.76 0.55% 0.09% 0.09% 0.06% 0.06%

747.00 Other Travel Expense 6,700 558 6,618.95 0.88% 0.14% 0.14% 0.09% 0.09%

747.10 Conventions 0 0.00% 0.00% 0.00% 0.00% 0.00%

747.20 Advertising 0 0 0.00% 0.00% 0.00% 0.00% 0.00%

747.30 Business Entertainment 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

748.00 Auto Gas & Oil 6,700 558 6,692.13 0.88% 0.14% 0.14% 0.09% 0.09%

749.00 Other Travel Expense 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

751.00 Legal 1,500 125 1,320.00 0.20% 0.03% 0.03% 0.02% 0.02%

752.00 Accounting/Tax 7,300 608 7,277.00 0.96% 0.15% 0.15% 0.10% 0.10%

753.00 Bank Service Charge 3,000 250 3,300.58 0.39% 0.06% 0.07% 0.04% 0.04%

754.00 Network support 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

755.00 Prof Liability Insurance (Sch) 69,000 5,750 68,825.54 9.03% 1.43% 1.41% 0.91% 0.91%

756.00 Other Insurance (Sch) 5,000 417 4,829.62 0.65% 0.10% 0.10% 0.07% 0.06%

756.10 Stockholders' Life Insurance 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

756.11 Life insurance cash value 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

756.20 Stockholders' Disability Ins. 1,537 128 1,537.20 0.20% 0.03% 0.03% 0.02% 0.02%

757.00 Miscell Tax & Licenses 800 67 94.50 0.10% 0.02% 0.00% 0.01% 0.00%

757.10 Personal Property Taxes 9,000 750 8,676.62 1.18% 0.19% 0.18% 0.12% 0.12%

757.20 Corp Franchise Tax 300 25 10.00 0.04% 0.01% 0.00% 0.00% 0.00%

757.30 Corp Annual Registration 25 2 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

757.40 Sales Use Tax Expense 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

757.50 Contributions 7,500 625 1,450.00 0.98% 0.16% 0.03% 0.10% 0.02%

757.60 Public Relations 5,000 417 10,444.73 0.65% 0.10% 0.21% 0.07% 0.14%

758.00 Errors & Omissions 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

759.00 Interest-Stock Redemption 5,415 451 6,079.71 0.71% 0.11% 0.12% 0.07% 0.08%

760.00 Miscell Exp Recovery (Cr) (44,000) (3,667) (44,199.76) -5.76% -0.91% -0.91% -0.58% -0.59%

760.10 Print/Repro Recovery (Cr) (9,000) (750) (3,239.86) -1.18% -0.19% -0.07% -0.12% -0.04%

761.00 Reproductions-Outside 1,800 150 1,531.40 0.24% 0.04% 0.03% 0.02% 0.02%

761.10 Print/Repro Supplies 1,200 100 1,032.50 0.16% 0.02% 0.02% 0.02% 0.01%

762.00 Renderings/Photos/Models 2,500 208 2,220.58 0.33% 0.05% 0.05% 0.03% 0.03%

763.00 Postage/Ship/Delivery 46,000 3,833 45,072.81 6.02% 0.95% 0.93% 0.61% 0.60%

763.10 Equipment Rental-Xerox 25,000 2,083 24,308.79 3.27% 0.52% 0.50% 0.33% 0.32%

765.00 Penalties 0 0 660.25 0.00% 0.00% 0.01% 0.00% 0.01%

766.00 Other Office Expense 8,600 717 8,528.89 1.13% 0.18% 0.18% 0.11% 0.11%

766.10 Beverage & Vending Machine 1,800 150 1,610.18 0.24% 0.04% 0.03% 0.02% 0.02%

766.11 Vending Machine Income (Cr) 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

766.20 Paper Supplies 1,200 100 723.52 0.16% 0.02% 0.01% 0.02% 0.01%

766.30 Janitorial Expense 0 0 4,240.00 0.00% 0.00% 0.09% 0.00% 0.06%

766.40 Bulbs 1,500 125 1,309.18 0.20% 0.03% 0.03% 0.02% 0.02%

766.50 Repairs & Maintenance 6,000 500 5,161.67 0.79% 0.12% 0.11% 0.08% 0.07%

766.60 Maintenance Contracts 27,000 2,250 26,804.84 3.53% 0.56% 0.55% 0.36% 0.36%

766.70 R & M Office Machines 1,200 100 932.40 0.16% 0.02% 0.02% 0.02% 0.01%

767.00 Rent 135,588 11,299 135,588.00 17.75% 2.81% 2.78% 1.79% 1.80%

767.10 Utilities 26,000 2,167 25,816.38 3.40% 0.54% 0.53% 0.34% 0.34%

767.20 Utilities Adjustment 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

768.00 Telephone 46,000 3,833 44,935.93 6.02% 0.95% 0.92% 0.61% 0.60%

768.10 Telephone-Cellular 3,600 300 675.10 0.47% 0.07% 0.01% 0.05% 0.01%

769.00 Office Supplies 12,000 1,000 12,849.49 1.57% 0.25% 0.26% 0.16% 0.17%

769.10 Drafting Supplies 0 0 36.14 0.00% 0.00% 0.00% 0.00% 0.00%

769.20 Dues 15,000 1,250 15,021.56 1.96% 0.31% 0.31% 0.20% 0.20%

769.30 Books & Periodicals 7,400 617 7,387.96 0.97% 0.15% 0.15% 0.10% 0.10%

769.40 Copier Paper & Supplies 1,900 158 1,822.04 0.25% 0.04% 0.04% 0.03% 0.02%

769.50 Printing & Stationery 2,400 200 2,205.74 0.31% 0.05% 0.05% 0.03% 0.03%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003

771.00 Depreciation Furn & Fixtures 4,138 345 5,708.61 0.54% 0.09% 0.12% 0.05% 0.08%

772.00 Depreciation Leasehold Improvements 422 35 421.68 0.06% 0.01% 0.01% 0.01% 0.01%

773.00 Depreciation Computer Equipment 73,044 6,087 69,563.64 9.56% 1.52% 1.43% 0.96% 0.92%

773.10 Depreciation Software 19,560 1,630 52,112.36 2.56% 0.41% 1.07% 0.26% 0.69%

774.00 Abandonment 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

781.00 Frye-Printing 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

782.00 Frye-Legal 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

783.00 Frye-Personal Mileage 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

784.00 Frye-Marketing 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

785.00 Frye-Supplies 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

786.00 Frye-Meals 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

787.00 Frye-Software 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

788.00 Frye-Bank Charges 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%

792.00 Computer Maintenance 1,200 100 980.57 0.16% 0.02% 0.02% 0.02% 0.01%

792.10 Computer Repairs 200 17 135.78 0.03% 0.00% 0.00% 0.00% 0.00%

793.00 Computer Online Service 17,100 1,425 16,528.98 2.24% 0.35% 0.34% 0.23% 0.22%

795.00 Computer Supplies 24,000 2,000 24,060.78 3.14% 0.50% 0.49% 0.32% 0.32%

795.10 Computer Software Annual Updates 14,000 1,167 13,677.78 1.83% 0.29% 0.28% 0.18% 0.18%

795.20 Computer Software Support 70,000 5,833 68,647.58 9.16% 1.45% 1.41% 0.92% 0.91%

796.00 Plotter Supplies 29,000 2,417 28,748.02 3.80% 0.60% 0.59% 0.38% 0.38%

796.10 Plotter Maintenance 16,000 1,333 14,098.15 2.09% 0.33% 0.29% 0.21% 0.19%

796.90 Plotter Expense Recovery (Cr) (20,000) (1,667) (18,968.50) -2.62% -0.41% -0.39% -0.26% -0.25%

797.00 Personnel Training 0 0 0.00 0.00% 0.00% 0.00% 0.00% 0.00%



Total Other Indirect 763,829 63,652 791,023.75 100.00% 15.85% 16.24% 10.07% 10.50%







Total Indirect 2,138,451 178,204 2,123,550.19 44.37% 43.61% 28.19% 28.17%





Operating Profit 1,194,745 99,562 1,516,299.83 24.79% 31.14% 15.75% 20.12%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ProfitPlan









Annual Profit Plan

For the Fiscal Year Ending

December 31, 2004

Ref Budget Budget Ref Budget Ref

Budget Percent Ref Percent Percent Percent Percent

Annual Monthly Prior Yr of Percent Net Net Total Total

Acct.# Name Plan2004 Objective Actual Subtotal Subtotal Revenue Revenue Revenue Revenue

Period 2003

Other Revenue

811.10 *Interest Income (6,000) (500) (6,683.00) -0.12% -0.14% -0.08% -0.09%

811.20 Cash Value Life Insurance (700) (58) (696.01) -0.01% -0.01% -0.01% -0.01%

811.30 *Sale of Assets-Gain/Loss 0 0 0.00 0.00% 0.00% 0.00% 0.00%

811.40 *Recovery of Bad Debt W/O 0 0 (50,921.57) 0.00% -1.05% 0.00% -0.68%



Total Other Revenue (6,700) (558) (58,300.58) -0.14% -1.20% -0.09% -0.77%



Other Expense

986.00 *Bonus Payroll Tax Exp. 29,023 2,419 28,181.64 0.60% 0.58% 0.38% 0.37%

987.00 *Cash Bonus 527,485 43,957 391,263.88 10.95% 8.03% 6.95% 5.19%

988.00 *Retirement Plan Contrib. 436,534 36,378 375,325.56 9.06% 7.71% 5.75% 4.98%



Total Other Expense 993,042 82,754 794,771.08 20.61% 16.32% 13.09% 10.54%



Net Profit Before Tax 208,403 17,367 779,829.33 4.32% 16.01% 2.75% 10.35%



999.00 *Provision for Income Tax 73,403 6,117 302,328.00 1.52% 6.21% 0.97% 4.01%



Net profit after tax 135,000 11,250 477,501.33 2.80% 9.81% 1.78% 6.34%



*Dividend/Principals' Bonus 0 0 0.00 0.00% 0.00% 0.00% 0.00%



Increase in net worth 135,000 11,250 477,501.33 2.80% 9.81% 1.78% 6.34%

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year



Revenue:

401.10 Billed Fee-Lump Sum 5,310,881 4,615,023 4,839,740 4,390,918 7,811,167 7,423,693 6,057,351 6,398,993 6,402,025 6,101,846 4,671,171 3,845,098 3,569,915 4,933,658.65 5,280,044 346,385

401.20 Billed Fee-DPE/Hourly 1,034,203 521,090 715,894 1,359,422 756,409 719,568 937,924 1,831,590 1,241,629 1,501,463 2,068,901 1,774,385 1,211,462 1,083,285.96 1,159,342 76,056

401.30 Billed Fee-Extra Service 273,242 229,484 162,983 215,303 292,520 252,089 296,060 198,447 152,863 137,726 381,178 288,008 234,596 65,817.58 70,439 4,621

411.00 Other - - - - - - - - 0 0.00 0 0



Total Billed Fee 6,618,326 5,365,597 5,718,617 5,965,643 8,860,095 8,395,350 7,291,335 8,429,029 7,796,517 7,741,035 7,121,251 5,907,491 5,015,973 6,082,762.19 6,509,824 427,062







Reimbursable expense revenue:

421.00 Reimb Consultant 581,751 734,622 994,332 1,111,529 811,801 1,133,646 491,472 1,020,113 733,112 940,829.81 910,570 (30,260)

422.00 Reimb Other 789,887 630,820 614,969 911,332 368,124 420,198 270,220 499,858 300,208 363,714 299,432 223,911 167,430 146,865.47 165,852 18,986



revenue

Total reimbursable expense 789,887 630,820 614,969 911,332 949,875 1,154,820 1,264,552 1,611,387 1,112,009 1,497,359 790,903 1,244,023 900,542 1,087,695.28 1,076,422 (11,274)







402.00 Unbilled Revenue-WIP - 343,805 153,909 (265,819) 82,995 (201,055) 14,734 335,351 (433,907) 17,184 535,279 (435,663) (341,891) 366,551.16 0 (366,551)



Total revenue 7,408,213 6,340,222 6,487,495 6,611,156 9,892,965 9,349,114 8,570,621 10,375,767 8,474,620 9,255,578 8,447,432 6,715,852 5,574,624 7,537,008.63 7,586,246 49,237



Reimbursable expense

Consultants

511.00 Structural 6,524 6,457 (3,765) 19,502 10,267 12,565 7,044 11,580 280 7,045.08 7,908 863

512.00 Mechanical 89,261 91,531 201,119 155,478 131,270 222,311 186,888 181,324 165,073 159,043.90 178,516 19,473

513.00 Electrical 215,340 342,355 527,788 505,262 307,161 472,939 322,760 344,245 301,664 406,477.50 456,245 49,767

514.00 Mechanical & Electrical 378 - 5,828 23,168 8,053 500 3,397 2,195 300 600.00 673 73

515.00 Civil 110,865 67,605 46,614 67,064 183,128 88,414 32,542 53,688 48,889 102,554.53 115,111 12,556

515.50 Civil-Survey 200.00 224 24

516.00 Landscape 3,800 7,906 5,481 4,933 4,029 1,863 15,600 8,925 11,170 5,455.00 6,123 668

517.00 Sprinkler 80,180 85,320 101,273 45,729 48,663 58,895 55,490 36,236 42,475 125,605.75 140,984 15,379

518.00 Architectural - 300 13,770 - 4,088 1,953 0 0 6,045 4,263.60 4,786 522

519.00 Other 602,575 442,414 451,227 643,232 11,405 6,900 2,852 2,701 - 25,561 (11,628) 48,190 6,779 0.00 0 0



Total consultants 602,575 442,414 451,227 643,232 517,753 608,375 900,960 823,837 696,658 885,001 612,092 686,383 582,674 811,245.36 910,570 99,325



Other reimbursable expense

541.00 Lodging 19,000 20,528 15,342 22,850 13,148 12,511 6,378 7,744 10,766 11,717.45 13,152 1,435

542.00 Meals-Reimbursable 2,514 4,532 4,404 5,683 4,448 3,228 3,327 3,068 3,867 4,603.82 5,167 564

543.00 Commercial Air Travel 91,337 151,074 98,290 145,834 99,865 84,370 61,016 43,986 63,042 43,256.31 48,552 5,296

543.10 Commercial Air Travel-Airport Parking 31.00 35 4

544.00 Charter Air Travel 31,717 27,899 26,884 65,914 57,117 36,669 52,549 50,437 8,913 16,424.29 18,435 2,011

545.00 Car Rental 7,637 8,147 7,157 14,113 9,117 6,821 7,179 7,479 7,251 7,718.01 8,663 945

545.10 Car Rental-Gasoline 66.14 74 8

546.00 Personal Auto Mileage 674 230 747 369 781 1,111 739 1,111 639 3,424.55 3,844 419

547.00 Other Travel Expense 161 10,220 1,471 927 374 39,613 (37,335) 7,967 5,675 1,179.78 1,324 144

- - 0

561.00 Reproductions/Printing 29,537 26,047 14,268 47,025 16,215 18,301 13,985 4,843 3,200 15,036.56 16,878 1,841

561.10 Reproductions - Inhouse 66,937 18,857 24,537 47,317 23,083 45,586 3,726 9,239 12,789 4,313.61 4,842 528

562.00 Renderings/Photos/Models 7,327 1,829 1,803 1,241 354 586 2,432 1,288 3,379 513.45 576 63

563.00 Postage/Ship/Delivery 47,958 25,285 24,068 57,860 29,546 29,775 33,271 14,959 11,425 20,112.04 22,574 2,462

564.00 Plan Review-Fire Marshal 12,847 5,386 19,994 21,720 11,556 14,108 18,007 12,113 10,588 8,089.95 9,080 990

565.00 Specification Repro 17,887 4,452 3,005 2,592 - 5,229 11,156 2,733 5,029 11,263.37 12,642 1,379

566.00 Other Office Expense 153,937 101,079 144,278 158,440 8,347 5,191 255 1,528 898 266 1,216 2,192 261 10.25 12 1



Total other reimbursable expense

153,937 101,079 144,278 158,440 343,881 309,678 242,225 434,972 266,502 298,172 177,647 169,160 146,823 147,760.58 165,852 18,091



Total reimbursable expense 756,512 543,493 595,505 801,672 861,633 918,053 1,143,185 1,258,809 963,160 1,183,174 789,739 855,543 729,497 959,005.94 1,076,422 117,416



Revenue less reimbursable expense

6,651,701 5,796,729 5,891,990 5,809,484 9,031,332 8,431,062 7,427,436 9,116,958 7,511,459 8,072,404 7,657,693 5,860,309 4,845,126 6,578,002.69 6,509,824 (68,179)

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Other Direct Expense

Direct Consultants:

611.00 Structural 326,065 261,293 35,750 101,021 38,600 110,397 128,533 24,865 3,876 27,584 27,298 (286)

612.00 Mechanical 663,939 722,487 619,468 541,435 553,002 587,701 513,608 375,112 345,723 520,040.70 514,651 (5,390)

613.00 Electrical 893,471 946,126 685,039 727,094 593,678 641,450 600,611 415,905 424,119 645,486.38 638,796 (6,690)

614.00 Mechanical & Electrical 62,389 9,845 68,757 38,543 38,123 6,588 40,150 67,600 21,930 11,115.00 11,000 (115)

615.00 Civil 303,540 5,819 10,785 185,283 215,462 195,058 90,752 24,175 13,706 73,090.00 72,332 (758)

616.00 Landscape 71,283 15,650 1,839 42,406 65,628 34,936 10,718 11,495 (200) 19,926.25 19,720 (207)

617.00 Sprinkler 426,957 347,901 273,865 392,530 316,217 272,008 188,219 203,887 188,176 189,283.42 187,322 (1,962)

618.00 Architectural - - 5,500 8,250 - 29,208 (3,398) 0 3,052 0.00 0 0

619.00 Other 1,650,191 1,393,756 1,602,922 1,190,989 87,292 21,816 1,464 (2,083) (557) (2,566) 44,384 4,782 67,800 32,782.48 32,443 (340)



Total Direct Consultants 1,650,191 1,393,756 1,602,922 1,190,989 2,834,935 2,330,937 1,702,467 2,034,480 1,820,152 1,874,781 1,613,577 1,127,822 1,068,182 1,519,308.23 1,503,561 (15,747)



Other Direct

640.00 Budget Travel 8,106 0.00 0 0

641.00 Lodging 22,728 23,193 35,942 23,240 22,668 26,828 28,572 17,429 13,303 9,980.98 9,878 (103)

642.00 Meals-Direct 6,833 8,372 10,948 9,024 9,646 13,099 11,522 9,491 6,852 5,908.24 5,847 (61)

643.00 Commercial Air 156,749 204,276 223,552 141,447 139,597 186,467 233,395 140,787 107,069 67,763.73 67,061 (702)

643.10 Commercial Air-Airport Parking 96.00 95 (1)

644.00 Charter Air 42,725 44,583 55,130 62,773 47,027 38,187 11,597 10,230 5,232 6,277.75 6,213 (65)

645.00 Car Rental 12,873 17,602 20,106 16,096 14,802 17,005 16,112 12,740 11,151 10,251.59 10,145 (106)

645.10 Car Rental-Gasoline 166.32 165 (2)

646.00 Personal Auto Mileage 27 442 110 644 897 333 1,023 1,990 449 2,646.72 2,619 (27)

647.00 Other Travel Expense 909 2,213 634 752 1,032 1,577 1,338 4,249 1,348 1,175.01 1,163 (12)

658.00 Errors & omissions 1,000 - 8,073 732 - - 0 2,789 20,000 0.00 0 0

- - 0 0 0

661.00 Reproductions - 27,665 24,420 33,518 28,216 18,641 7,585 4,501 2,370 6,426.31 6,360 (67)

661.10 Reproductions - Inhouse 20,145 87,473 90,014 65,926 83,916 45,568 25,479 17,147 23,186 9,868.25 9,766 (102)

662.00 Renderings/Photos/Models 68,934 22,560 13,114 16,535 1,242 444 1,169 4,938 598 377.44 374 (4)

663.00 Postage/Shipping/Delivery 13,939 28,005 21,384 25,631 25,920 26,672 20,178 14,464 23,414 22,389.03 22,157 (232)

664.00 Plan Review-Fire Marshall 11,336 20 25 - 287 30 100 200 600 0.00 0 0

665.00 Specification Printing - 22,455 10,436 2,052 1,444 8,306 12,199 7,971 8,542 9,330.28 9,234 (97)

666.00 Other Office Expense 16,283 51 1,224 - 35 35,338 5 1,500 64 0.00 0 0

669.00 Bad Debt Expense 280,295 381,468 346,347 312,609 2,145 465,844 129,670 50,687 29,856 151,464 93,278 59,311 79,451 36,282.17 35,906 (376)



Total other direct expense 280,295 381,468 346,347 312,609 376,626 954,754 644,782 449,057 406,585 569,957 463,551 309,739 311,733 188,939.82 186,982 (1,958)







Total direct consultants and other

1,930,486 1,775,224 1,949,269 1,503,598 3,211,561 3,285,690 2,347,250 2,483,537 2,226,737 2,444,738 2,077,129 1,437,561 1,379,915 1,708,248.05 1,690,543 (17,705)







Net revenue 4,721,215 4,021,505 3,942,721 4,305,886 5,819,770 5,145,372 5,080,186 6,633,421 5,284,722 5,627,666 5,580,565 4,422,748 3,465,211 4,869,754.64 4,819,281 (50,473)



Direct Labor

601.00 *LB-Direct Labor-Principals 489,784 466,091 503,257 532,358 459,841 501,740 475,456 289,823 170,256 199,338.31 219,337 19,999

602.00 *LB-Direct Labor-Employees1,299,304 1,138,567 1,181,362 1,263,219 1,239,366 1,184,626 1,196,001 1,387,485 1,229,995 1,291,024 1,271,824 1,068,359 863,390 1,030,566.31 1,266,748 236,182



Total direct labor 1,299,304 1,138,567 1,181,362 1,263,219 1,729,150 1,650,717 1,699,258 1,919,843 1,689,835 1,792,764 1,747,280 1,358,182 1,033,645 1,229,904.62 1,486,085 256,181







Gross profit 3,421,911 2,882,938 2,761,359 3,042,667 4,090,620 3,494,655 3,380,929 4,713,578 3,594,887 3,834,902 3,833,285 3,064,566 2,431,566 3,639,850.02 3,333,196 (306,654)

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Indirect Expense

Indirect Labor

701.00 *LB-Indirect Labor-Principals 188,505 251,549 143,621 95,337 119,510 121,543 123,279 159,340 60,300 6,385.13 96,290 89,905

701.10 LB-Indirect Labor-Marketing 84,192.43 0 (84,192)

702.00 *LB-Indirect Labor-Technical 106,089 169,845 205,112 209,138 344,894 325,075 383,547 508,593 430,167 299,026.68 200,751 (98,276)

702.10 *LB-Indirect Labor-Nontech. 327,685 397,744 427,736 409,566 417,206 423,867 417,151 419,353 388,689 393,121.05 424,998 31,877

703.00 Payroll Variance 352,489 518,623 520,287 533,228 (219,060) (147,760) (164,960) (251,172) (159,567) (214,440) (17,300) (8,184) (5,417) (5,606.20) 0 5,606

703.01 Overtime Applied to Personal PTO 69,572 69,626 62,505 0 0 0 0.00 0 0

704.00 Temporary Help 7,174 2,032 383 60 - - 0 0 0 0.00 0 0



Total indirect labor 352,489 518,623 520,287 533,228 410,392 673,410 611,892 532,502 791,670 718,549 906,677 1,079,102 873,738 777,119.09 722,039 (55,080)



Paid-time-off

711.00 *LB-Holiday Pay 43,836 48,303 46,875 50,856 57,171 65,987 65,335 70,439 73,479 74,207 84,063 81,530 67,863 64,896.24 74,160 9,264

712.00 *LB-Vacation Pay 81,005 87,833 91,583 95,919 112,405 125,977 131,647 127,085 136,341 138,585 137,161 114,397 113,874 107,317.12 133,214 25,897

713.00 *LB-Personal Time-Off 3,802 10,726 11,205 5,901 4,376 12,582 9,751 16,557 29,287 40,452 (112,728) 12,672 (16,373) (16,623.84) 0 16,624



Total paid-time-off 128,643 146,862 149,663 152,676 173,953 204,545 206,734 214,082 239,107 253,243 108,496 208,600 165,364 155,589.52 207,374 51,785



Payroll related expense

721.00 *LB-Employer's FICA Tax 141,342 140,250 145,110 148,231 156,528 169,573 166,647 177,144 179,738 187,153 207,725 181,165 152,208 160,576.62 144,335 (16,241)

721.10 *LB-Employer's Medicare Tax - - - - - - 0 0 0 0.00 35,025 35,025

722.00 *LB-Federal Unemployment 4,743 3,668 3,379 3,470 3,361 3,394 3,223 3,083 2,560 2,633.63 2,493 (141)

723.00 *LB-State Unemployment 970 2,641 2,309 1,378 1,262 1,085 1,520 1,461 868 3,066.42 654 (2,412)

724.00 *LB-Workers' Comp Insurance3,100

1 10,508 16,939 14,499 18,303 21,381 16,856 17,902 24,488 12,200 17,130 15,020 11,693 13,555.66 16,000 2,444

729.00 Misc Employee Benefits - 195 499 - 60 190 140 0 0 0.00 0 0



Total payroll related expense

154,442 150,758 162,049 162,730 180,543 197,458 189,690 199,894 208,909 204,022 229,737 200,729 167,329 179,832.33 198,507 18,675



Benefits

731.00 *LB-Health Care Insurance 90,250 93,058 108,205 145,369 189,264 170,586 167,192 227,080 209,812 269,100 269,837 230,729 265,923 191,206.88 198,434 7,227

731.01 Health Care Insurance Withheld (59,812) (54,110) (53,915) (27,720) (18,124.16) 0 18,124

731.10 Employee Medical Expense 187 360 384 1,094 43 0 0 0.00 0 0

732.10 Stockholders Physical 1,860 790 731 1,089 934 1,580 1,611 1,160 622 1,088 2,245 3,681 2,655 2,078.00 2,000 (78)

733.00 *LB-Disability Income Ins. 10,518 11,299 11,719 12,267 14,357 4,724 12,192 - 7,048 14,206 14,194 13,105 11,144 12,840.22 12,867 27

734.00 *LB-Pension Plan Contribution - - - - - - 0 0 0 0.00 0 0

735.10 Retirement Plan Fees 15,324 6,953 7,044 9,366 20,449 18,204 8,522 24,589 30,858 27,776 25,487 12,521 9,822 8,590.87 10,000 1,409

737.00 Professional Development 3,184 630 1,189 3,692 4,302 7,272 5,401 11,312 11,822 10,857 12,791 11,526 5,272 7,132.95 7,000 (133)

738.00 Professional Registration 16,634 12,218 13,018 15,453 15,178 21,605 16,516 13,925 24,511 27,150 22,194 24,119 22,152 12,875.00 13,000 125

739.00 Employee Relations 4,409 5,394 5,998 7,421 5,858 8,053 10,039 8,888 10,517 17,017 17,982 13,961 1,422 3,385.74 3,400 14

739.10 Moving Expenses 350 1,339 2,640 371 1,000 - - - - - 0 0 0 0.00 0 0

739.20 *LB-Cell Phone - - 13,525 19,677 27,036 27,560 26,839 27,366 5,923 0.00 0 0



Total benefits 142,529 131,681 150,544 195,028 251,344 232,023 235,185 306,992 322,609 336,036 337,503 283,092 296,592 219,985.50 246,701 26,715

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Other indirect expense

741.00 Lodging 11,480 14,381 19,812 20,586 23,462 23,667 29,023 28,689 12,576 17,573.86 18,000 426

742.00 Meals-Indirect 7,716 10,664 7,651 9,077 12,495 14,857 15,749 18,048 9,625 8,338.64 8,400 61

743.00 Commercial Air Travel 31,749 49,594 36,458 38,496 34,760 39,983 81,835 40,863 18,977 21,189.40 21,200 11

744.00 Charter Air Travel 15,711 7,839 11,890 18,726 17,574 19,618 12,447 10,904 2,733 8,199.52 8,200 0

744.10 Charter Air Travel-Discounts(CR) (8,029) (6,565) (9,594) (1,379) - - 0 0 0 0.00 0 0

745.00 Car Rental 2,699 4,532 5,918 7,297 9,245 8,547 8,152 9,677 5,189 5,654.83 5,700 45

746.00 Personal Auto Mileage 3,342 3,567 2,532 3,402 2,033 2,186 2,462 3,196 3,767 4,159.76 4,200 40

747.00 Other Travel Expense 151,317 109,210 90,785 74,003 5 340 83 9,558 14,578 1,564 13,413 12,291 984 6,618.95 6,700 81

747.10 Conventions 0 0

747.20 Advertising 0 0

747.30 Business Entertainment 0.00 0 0

748.00 Auto Gas & Oil 11,138 11,758 12,242 13,151 12,946 13,246 16,087 11,746 7,040 6,692.13 6,700 8

749.00 Other Travel Expense 20,584 23,931 18,599 - - - 0 0 0 0.00 0 0

751.00 Legal 32,495 26,360 34,135 9,541 2,083 4,847 2,922 3,318 1,496 4,723 19,572 30,585 3,861 1,320.00 1,500 180

752.00 Accounting/Tax 7,172 4,471 5,284 5,138 7,899 5,345 9,845 6,826 10,558 10,064 7,668 8,687 7,634 7,277.00 7,300 23

753.00 Bank Service Charge 248 2,009 2,438 3,452 3,300.58 3,000 (301)

754.00 Network support - - 277 1,801 7,700 5,067 738 - 3,053 853 0 0 0 0.00 0 0

755.00 Prof Liability Insurance (Sch) 76,378 84,066 96,025 97,028 75,006 88,658 82,488 68,880 73,653 73,521 64,196 67,353 72,036 68,825.54 69,000 174

756.00 Other Insurance (Sch) 7,230 8,292 4,178 5,285 5,523 9,398 4,934 3,914 3,415 4,504 8,985 9,664 6,169 4,829.62 5,000 170

756.10 Stockholders' Life Insurance 24,284 20,985 26,972 18,597 46,409 46,387 45,993 45,993 49,198 27,537 16,429 9,429 4,369 0.00 0 0

756.11 Life insurance cash value (16,981) (34,101) (41,726) (42,313) (72,659) (51,645) (11,787) (8,957) (5,160) 0.00 0 0

756.20 Stockholders' Disability Ins. - - - - 5,739 4,640 5,427 5,937 5,429 6,123 5,449 3,746 1,861 1,537.20 1,537 0

757.00 Miscell Tax & Licenses - - - - 2,020 23,183 2,318 2,391 2,000 2,016 2,350 2,000 94.50 800 706

757.10 Personal Property Taxes 10,772 9,413 15,338 14,837 7,285 7,123 10,039 10,874 10,861 12,110 10,974 12,539 9,017 8,676.62 9,000 323

757.20 Corp Franchise Tax - - - - 35 72 40 170 348 609 35 125 349 10.00 300 290

757.30 Corp Annual Registration - - - - 75 50 75 300 25 175 20 0 55 0.00 25 25

757.40 Sales Use Tax Expense 3,860 3,369 359 - 0 0 0 0.00 0 0

757.50 Contributions 1,450.00 7,500 6,050

757.60 Public Relations 10,444.73 5,000 (5,445)

758.00 Errors & Omissions 5,000 5,000 12,160 - - - - 33,373 - - 0 0 2,470 0.00 0 0

759.00 Interest-Stock Redemption 1,007 - - 16,177 24,265 4,853 5,202 6,079.71 5,415 (665)

760.00 Miscell Exp Recovery (Cr) (88,429) (46,635) (108,239) (85,957) (46,547) (30,652) (19,467) (22,696) (16,360) (70,539) 12,129 (14,798) (29,991) (44,199.76) (44,000) 200

760.10 Print/Repro Recovery (Cr) (136,295) (108,580) (114,608) (52,347) (30) (1,032) (1,229) (323) (9,016) (3,239.86) (9,000) (5,760)

761.00 Reproductions-Outside 89,365 64,261 75,608 75,550 10,747 916 899 4,008 1,688 1,054 1,870 998 1,264 1,531.40 1,800 269

761.10 Print/Repro Supplies 106,793 4,862 2,956 - 1,009 - (130) 115 4,195 1,032.50 1,200 168

762.00 Renderings/Photos/Models 10,741 10,266 5,794 5,321 4,433 4,545 3,505 4,834 5,145 4,900 6,038 10,824 3,294 2,220.58 2,500 279

763.00 Postage/Ship/Delivery 53,591 40,166 47,333 56,142 87,426 52,677 41,704 45,645 35,828 41,377 45,071 43,096 38,438 45,072.81 46,000 927

763.10 Equipment Rental-Xerox 1,040 - 94 213 344 1,004 729 439 150 - 3,795 16,838 25,948 24,308.79 25,000 691

765.00 Specification Reproduction 732 - - - - - - - - - 0 0 0 660.25 0 (660)

766.00 Other Office Expense 12,231 3,247 2,499 2,686 3,236 1,534 2,036 4,730 4,407 11,037 14,799 23,370 9,374 8,528.89 8,600 71

766.10 Beverage & Vending Machine 609 1,068 1,063 2,092 6,546 6,105 4,516 4,250 5,196 3,002 2,208 1,977 1,962 1,610.18 1,800 190

766.11 Vending Machine Income (Cr) (3,968) (2,463) (1,609) (1,701) (1,201) (506) 0 0 0 0.00 0 0

766.20 Paper Supplies 2,270 1,260 1,386 1,306 1,204 1,315 1,032 540 218 - 0 281 1,157 723.52 1,200 476

766.30 Janitorial Expense 7,639 10,028 9,828 7,630 10,280 8,800 7,500 8,125 6,875 8,200 7,500 3,225 0 4,240.00 0 (4,240)

766.40 Bulbs 2,548 1,850 847 937 3,891 1,906 3,090 2,405 3,305 1,599 2,385 1,245 0 1,309.18 1,500 191

766.50 Repairs & Maintenance 8,552 5,620 2,883 3,171 8,592 6,009 2,195 3,213 1,206 718 6,500 2,372 1,615 5,161.67 6,000 838

766.60 Maintenance Contracts 2,596 2,574 70 480 2,388 1,787 4,684 8,515 15,988 37,437 38,755 37,861 6,504 26,804.84 27,000 195

766.70 R & M Office Machines 214 358 478 297 531 1,058 - - 347 - 0 0 0 932.40 1,200 268

767.00 Rent 162,084 163,968 163,968 163,968 150,399 136,830 135,795 135,588 135,588 137,971 135,673 135,873 147,224 135,588.00 135,588 0

767.10 Utilities 23,659 31,024 23,953 20,192 27,447 23,317 24,250 23,840 22,252 18,665 25,370 20,074 21,844 25,816.38 26,000 184

767.20 Utilities Adjustment 11,269 7,504 1,128 - - - - - - - 0 0 0 0.00 0 0

768.00 Telephone - - - - - - 35,354 47,492 42,785 41,813 41,825 51,533 51,110 44,935.93 46,000 1,064

768.10 Telephone-Cellular 40,314 36,111 41,872 43,975 46,938 46,173 14,171 13,974 9,616 9,023 10,295 3,988 1,192 675.10 3,600 2,925

769.00 Office Supplies 11,320 9,627 6,964 7,747 9,455 13,308 17,005 25,065 27,038 25,909 21,929 20,098 11,372 12,849.49 12,000 (849)

769.10 Drafting Supplies 27,152 11,984 9,432 10,031 16,947 8,219 5,162 197 68 - 0 0 0 36.14 0 (36)

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

769.20 Dues 13,381 19,789 19,513 22,302 14,703 15,615 15,337 17,172 13,191 11,228 13,361 12,521 10,613 15,021.56 15,000 (22)

769.30 Books & Periodicals - - - - 7,379 13,415 13,409 8,266 11,664 10,145 11,158 8,489 4,760 7,387.96 7,400 12

769.40 Copier Paper & Supplies 5,747 8,305 7,392 6,761 7,141 10,060 7,860 9,276 8,099 4,681 3,963 2,386 645 1,822.04 1,900 78

769.50 Printing & Stationery 2,831 3,302 1,085 1,049 1,727 3,438 1,451 5,869 6,428 6,743 4,164 3,709 4,295 2,205.74 2,400 194

771.00 Depreciation-Furn & Fixtures208,069 114,403 88,190 102,480 8,214 10,375 11,947 7,246 4,481 4,015 27,747 11,820 8,277 5,708.61 4,138 (1,570)

772.00 Depreciation-Leasehold Improvements 6,598 6,598 1,291 422 422 422 422 422 422 421.68 422 0

773.00 Depreciation-Computer Equipment 97,669 95,068 133,797 104,560 105,653 129,963 83,337 79,857 66,022 69,563.64 73,044 3,481

773.10 Depreciation-Software 5,801 16,538 27,055 24,884 18,348 8,603 5,111 4,461 52,112.36 19,560 (32,552)

774.00 Section 179 - - - - (3,659) 567 - 5,902 0 0 0 0 4,543 0.00 0 0

781.00 Frye-Printing - 9,620 95 183 - 1,551 1,826 0 0 0.00 0 0

782.00 Frye-Legal 1,105 1,534 426 - 21 308 0 0 0 0.00 0 0

783.00 Frye-Personal Mileage 2,484 9,862 4,176 6,869 2,437 2,704 22,728 29,527 9,855 0.00 0 0

784.00 Frye-Marketing 3,210 1,830 1,660 3,500 2,900 2,110 2,800 2,175 1,950 0.00 0 0

785.00 Frye-Supplies 20,118 3,586 1,604 - 892 250 16,069 2,031 246 0 0.00 0 0

786.00 Frye-Meals - - 30 - - 2,445 1,836 0 0 0.00 0 0

787.00 Frye-Software 1,748 3,759 7,874 1,466 72 6,879 2,716 32 0 0.00 0 0

788.00 Frye-Bank Charges 23,519 39,576 34,048 27,578 12,430 5,054 11,361 3,000 11,778 12,436 808 300 0 0.00 0 0

792.00 Maintenance Contract 51,492 48,045 28,146 1,640 5,252 24,576 24,787 6,703 18,850 - 69 0 0 980.57 1,200 219

792.10 Computer Repairs 2,499 502 95 664 798 588 1,855 3,191 554 - 0 0 0 135.78 200 64

793.00 Computer Online Service - 967 3,504 1,032 447 1,402 21,744 26,111 17,092 16,528.98 17,100 571

795.00 Computer Supplies 45,060 16,746 36,341 58,048 107,010 69,336 82,353 87,174 41,229 45,923 49,714 30,580 21,148 24,060.78 24,000 (61)

795.10 Computer Software Annual Updates

71,530 21,988 44,372 48,076 58,598 - 1,887 27,594 9,788 21,089 27,403 34,140 53,127 13,677.78 14,000 322

795.20 Computer Software Support - - - - - - 2,873 - 3,870 4,292 1,759 6,627 5,452 68,647.58 70,000 1,352

796.00 Plotter Supplies 1,354 - - - - 73,372 77,228 81,555 66,701 43,436 36,468 34,578 25,941 28,748.02 29,000 252

796.10 Plotter Maintenance - - - - - 10,778 14,335 5,715 2,856 22,778 0 2,685 34,463 14,098.15 16,000 1,902

796.90 Plotter Expense Recovery (Cr) (86,504) (107,067) (99,025) (32,863) (25,962) (35,601) (18,968.50) (20,000) (1,032)

797.00 Personnel Training 8,395 - - - - - - - - - 0 0 0 0.00 0 0



Total Other Indirect 1,148,140 894,734 831,297 810,609 883,946 812,032 861,389 846,127 745,847 771,236 995,575 902,227 699,158 791,023.75 763,829 (27,194)







Total Indirect 1,926,243 1,842,658 1,813,840 1,854,271 1,900,178 2,119,469 2,104,890 2,099,596 2,308,142 2,283,086 2,577,988 2,673,750 2,202,180 2,123,550.19 2,138,451 14,901







Operating Profit 1,495,668 1,040,280 947,519 1,188,396 2,190,442 1,375,186 1,276,039 2,613,982 1,286,745 1,551,816 1,255,296 390,816 229,386 1,516,299.83 1,194,745 (321,554)

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Other Revenue

811.10 *Interest Income (26,743) (59,158) (57,276) (83,494) (42,813) (38,998) (42,403) (31,748) (8,993) (6,683.00) (6,000) 683

811.20 Cash Value Life Insurance (42,046) (40,972) (68,551) (23,296) - - - - - - 0 0 0 (696.01) (700) (4)

811.30 *Sale of Assets-Gain/Loss (2,147) (31,500) 9,007 3,768 - 47,023 - - 0 0 0 0.00 0 0

811.40 *Recovery of Bad Debt W/O - - (151,055) (19,006) (25,762) - 0 (105,354) (20,919) (50,921.57) 0 50,922



Total Other Revenue (44,193) (72,472) (68,551) (23,296) (17,737) (55,391) (208,331) (55,477) (68,575) (38,998) (42,403) (137,102) (29,911) (58,300.58) (6,700) 51,601



Other Expense

986.00 *Bonus Payroll Tax Exp. 18,796 20,711 22,295 29,401 48,457 44,288 47,238 78,963 25,439 32,699 0 5,980 14,026 28,181.64 29,023 842

987.00 *Cash Bonus 562,755 484,862 467,100 696,715 1,173,176 875,344 922,571 1,851,353 540,050 581,868 470,197 117,973 408,895 391,263.88 527,485 136,222

988.00 *Retirement Plan Contrib. 323,357 333,181 343,650 378,785 447,766 476,252 486,484 596,373 473,887 490,835 465,146 0 326,072 375,325.56 436,534 61,208



Total Other Expense 904,908 838,754 833,045 1,104,901 1,669,399 1,395,884 1,456,292 2,526,689 1,039,376 1,105,401 935,343 123,953 748,993 794,771.08 993,042 198,271



Net Profit Before Tax 634,953 273,998 183,025 106,791 538,781 34,692 28,077 142,770 315,944 485,413 362,357 403,964 (489,696) 779,829.33 208,403 (571,426)



999.00 *Provision for Income Tax 234,361 107,346 77,224 58,591 222,053 14,796 16,625 58,747 119,729 196,401 150,260 165,079 (199,166) 302,328.00 73,403 (228,925)



Net profit after tax 400,592 166,652 105,801 48,200 316,728 19,896 11,452.21 84,022.90 196,214.56 289,011.86 212,097 238,885 (290,530) 477,501.33 135,000 (342,501)



*Dividend/Principals' Bonus 5,500 5,500 5,500 5,500 5,500 2,100 2,100 0 0 0.00 0 0



Increase in net worth 400,592 166,652 105,801 48,200 311,228 14,396 5,952 78,523 190,715 286,912 209,997 238,885 (290,530) 477,501.33 135,000 (342,501)





Cash vs. Accounts Receivable: 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Cash balance 272,951 255,332 283,816 31,816 137,549 71,995 36,844 179,206 32,581 43,895 43,895 42,256 29,575 38,999 71,933 32,934

Accounts receivable 1,356,387 1,503,178 1,475,357 1,746,668 2,257,872 1,956,197 2,096,535 1,969,978 2,263,134 2,707,211 2,707,211 1,854,879 1,466,637 1,879,894 1,879,894 -

Current 556,397 486,380 541,664 683,727 1,025,546 723,587 1,092,439 836,042 793,194 1,140,225 1,140,225 453,362 697,758 675,914 675,914 -

Employees - 594 - - 2,410 2,410 1,397 7,472 - -

Over 30 469,440 558,765 550,660 284,917 517,242 940,933 849,076 575,737 682,810 936,986 936,986 650,557 373,889 487,537 487,537 -

Over 60 141,550 3,936 321,474 590,811 340,244 118,208 52,914 391,206 488,533 341,516 341,516 537,141 314,019 123,737 123,737 -

Travel Advance - 440 - 340 480 480 600 513 50 50 -

Over 90 189,000 454,097 61,559 187,213 374,840 173,469 101,072 166,993 298,258 285,595 285,595 211,822 72,986 592,656 592,656 -

Average Collection Period-(Days) 56.0 59.9 -







Analysis of Operations



Time Analysis

Technical direct 80,655 67,757 64,739 66,419 89,180 81,355 77,033 83,565 72,003 74,897 67,772 53,898 41,791 47,025 54,184 7,159

Technical indirect 16,989 21,005 19,815 20,684 17,263 14,299 10,114 11,092 18,599 12,985 15,427 21,098 18,665 12,465 8,624 (3,841)

Technical indirect PTO 0 0 0 0 0 7,910 7,258 7,458 5,991 7,956 3,989 6,506 4,604 4,773 5,832 1,059

Total technical 97,644 88,762 84,554 87,103 106,443 103,564 94,405 102,115 96,593 95,838 87,188 81,502 65,060 64,263 68,640 4,377

Non-technical indirect 23,595 23,146 21,449 23,436 26,413 28,778 29,001 26,573 24,675 25,916 23,668 23,675 21,566 21,000 20,536 (464)

Non-technical indirect PTO - - - - 0 2,504 2,558 2,280 4,083 2,398 2,061 2,121 2,022 2,598 1,824 (774)

Total nontechnical 23,595 23,146 21,449 23,436 26,413 31,282 31,559 28,853 28,758 28,314 25,729 25,796 23,588 23,598 22,360 (1,238)

Total technical and nontechnical 121,239 111,908 106,003 110,539 132,856 134,846 125,964 130,966 125,350 124,152 112,917 107,298 88,648 87,861 91,000 3,139

6,731

Total technical and nontechnical PTO 7,970 8,135 8,280 7,806 10,414 9,816 9,737 10,074 10,354 6,050 8,802 7,030 7,371 7,656 285

Total less PTO 114,508 103,938 97,868 102,259 125,050 124,432 116,148 121,229 115,276 113,798 106,867 98,496 81,618 80,490 83,344 2,854

-

Standard hours 2,088 2,088 2,088 2,088 2,088 2,088 2,096 2,088 2,080 2,080 2,080 2,080 2,088 2,088 2,080 (8)







Overtime

Technical 11,161.5 4,378.0 4,742.5 4,905.0 1,334.0 3,031.5 2,913.5 641.0 374.5 133.0 - (133.0)

Non-technical 776.0 756.0 423.5 116.0 (45.5) (97.5) (157.0) 490.0 (185.5) (945.0) - 945.0

Total overtime 0.0 0.0 0.0 0.0 11937.5 5,134.0 5,166.0 5,021.0 1,288.5 2,934.0 2,756.5 1,131.0 189.0 (812.0) - 812.0

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Overtime percentage

Technical 11.71% 4.41% 5.29% 5.05% 1.40% 3.27% 3.46% 0.79% 0.58% 0.21% 0.00% -0.21%

NonTechnical 3.03% 2.48% 1.36% 0.40% -0.16% -0.34% -0.61% 1.94% -0.78% -3.85% 0.00% 3.85%

Average overtime percentage firmwide 9.87% 3.96% 4.28% 3.99% 1.04% 2.42% 2.50% 1.07% 0.21% -0.92% 0.00% 0.92%







Full-time-equivalents: Tech/NonTech

Technical-regular 45.63 47.50 42.78 46.56 45.80 44.62 40.52 38.88 30.98 30.71 33.00 2.29

Technical-overtime 5.35 2.10 2.26 2.35 0.64 1.46 1.40 0.31 0.18 0.06 0.00 -0.06

Total technical 46.76 42.51 40.50 41.72 50.98 49.60 45.04 48.91 46.44 46.08 41.92 39.18 31.16 30.78 33.00 2.22

NonTechnical regular 12.28 14.62 14.85 13.76 13.85 13.66 12.45 12.17 11.39 11.75 10.75 -1.00

NonTechnical overtime 0.37 0.36 0.20 0.06 -0.02 -0.05 -0.08 0.24 -0.09 -0.45 0.00 0.45

Total nontechnical 11.30 11.09 10.27 11.22 12.65 14.98 15.06 13.82 13.83 13.61 12.37 12.40 11.30 11.30 10.75 -0.55

Total FTE 58.06 53.60 50.77 52.94 63.63 64.58 60.10 62.72 60.26 59.69 54.29 51.59 42.46 42.08 43.75 1.67

-

-

FTE: Regular+Overtime -

FTE-Regular 0.00 0.00 0.00 0.00 57.91 62.12 57.63 60.32 59.65 58.28 52.96 51.04 42.37 42.47 43.75 1.28

FTE-Overtime 0.00 0.00 0.00 0.00 5.72 2.46 2.46 2.40 0.62 1.41 1.33 0.54 0.09 -0.39 0.00 0.39

FTE-Total 0.00 0.00 0.00 0.00 63.63 64.58 60.10 62.72 60.26 59.69 54.29 51.59 42.46 42.08 43.75 1.67

-

-

Ratio: Technical/NonTechnical

4.14 3.83 3.94 3.72 4.03 3.31 2.99 3.54 3.36 3.38 3.39 3.16 2.76 2.72 3.07 0.35

-

-

Utilization rates: 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Firm-wide dollars 72.98% 63.11% 63.81% 64.81% 74.74% 65.28% 67.49% 72.00% 62.11% 64.85% 63.25% 51.33% 49.87% 56.87% 61.52% 4.65%

Firm-wide dollars less paid-time-off

78.66% 68.70% 69.42% 70.32% 80.82% 71.03% 73.52% 78.29% 68.10% 71.39% 65.84% 55.73% 54.19% 61.28% 67.30% 6.02%

Firm-wide standard hours 0.00% 0.00% 0.00% 0.00% 73.75% 62.72% 63.77% 66.35% 58.04% 61.79% 61.52% 50.77% 47.24% 53.03% 59.54% 6.51%

Firm-wide total hours 66.53% 60.55% 61.07% 60.09% 67.13% 60.33% 61.15% 63.81% 57.44% 60.33% 60.02% 50.23% 47.14% 53.52% 59.54% 6.02%

Firm-wide hours less paid-time-off

70.44% 65.19% 66.15% 64.95% 71.32% 65.38% 66.32% 68.93% 62.46% 65.82% 63.42% 54.72% 51.20% 58.42% 65.01% 6.59%

Technical only hours 82.60% 76.34% 76.57% 76.25% 83.78% 78.56% 81.60% 81.83% 74.54% 78.15% 77.73% 66.13% 64.23% 73.18% 78.94% 5.76%







Per Direct Hour 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Net revenue 58.54 59.35 60.90 64.83 65.26 63.25 65.95 79.38 73.40 75.14 82.34 82.06 82.92 103.56 88.94 (14.61)

Average direct labor rate 16.11 16.80 18.25 19.02 19.39 20.29 22.06 22.97 23.47 23.94 25.78 25.20 24.73 26.15 27.43 1.27

Overhead expense 23.88 27.20 28.02 27.92 21.31 26.05 27.32 25.13 32.06 30.48 38.04 49.61 52.70 45.16 39.47 (5.69)

Break-even 39.99 44.00 46.27 46.94 40.70 46.34 49.38 48.10 55.53 54.42 63.82 74.81 77.43 71.31 66.89 (4.42)

Operating profit 18.54 15.35 14.64 17.89 24.56 16.90 16.56 31.28 17.87 20.72 18.52 7.25 5.49 32.24 22.05 (10.19)







Multiples of Direct Labor 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Net revenue 3.63 3.53 3.34 3.41 3.37 3.12 2.99 3.46 3.13 3.14 3.19 3.26 3.35 3.96 3.24 (0.72)

Direct labor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 -

Overhead rate 1.48 1.62 1.54 1.47 1.10 1.28 1.24 1.09 1.37 1.27 1.48 1.97 2.13 1.73 1.44 (0.29)

Break-even 2.48 2.62 2.54 2.47 2.10 2.28 2.24 2.09 2.37 2.27 2.48 2.97 3.13 2.73 2.44 (0.29)

Operating profit 1.15 0.91 0.80 0.94 1.27 0.83 0.75 1.36 0.76 0.87 0.72 0.29 0.22 1.23 0.80 (0.43)







Summary Recap 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Total revenue 7,408,213 6,340,222 6,487,495 6,611,156 9,892,965 9,349,114 8,570,621 10,375,767 8,474,620 9,255,578 8,447,432 6,715,852 5,574,624 7,537,009 7,586,246 49,237

Other direct and reimbursable

2,686,998 2,318,717 2,544,774 2,305,270 4,073,194 4,203,743 3,490,435 3,742,346 3,189,897 3,627,912 2,866,868 2,293,104 2,109,412 2,667,254 2,766,964 99,710

Net revenue 4,721,215 4,021,505 3,942,721 4,305,886 5,819,770 5,145,372 5,080,186 6,633,421 5,284,722 5,627,666 5,580,565 4,422,748 3,465,211 4,869,755 4,819,281 (50,473)

Direct labor 1,299,304 1,138,567 1,181,362 1,263,219 1,729,150 1,650,717 1,699,258 1,919,843 1,689,835 1,792,764 1,747,280 1,358,182 1,033,645 1,229,905 1,486,085 256,181

Overhead expense 1,926,243 1,842,658 1,813,840 1,854,271 1,900,178 2,119,469 2,104,890 2,099,596 2,308,142 2,283,086 2,577,988 2,673,750 2,202,180 2,123,550 2,138,451 14,901

Break-even 3,225,547 2,981,225 2,995,202 3,117,490 3,629,328 3,770,186 3,804,148 4,019,439 3,997,978 4,075,850 4,325,269 4,031,932 3,235,826 3,353,455 3,624,536 271,081

Operating profit 1,495,668 1,040,280 947,519 1,188,396 2,190,442 1,375,186 1,276,039 2,613,982 1,286,745 1,551,816 1,255,296 390,816 229,386 1,516,300 1,194,745 (321,554)

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year

Net Revenue per FTE 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Total staff 81,310 75,034 77,662 81,335 91,465 79,673 84,533 105,755 87,692 94,284 102,797 85,736 81,619 115,729 110,155 (5,574)

Technical staff 100,958 94,600 97,363 103,219 114,161 103,738 112,791 135,637 113,799 122,139 133,133 112,872 111,211 158,226 146,039 (12,187)







Operating Profit per FTE 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Total staff 25,759 19,410 18,664 22,448 34,426 21,294 21,233 41,674 21,351 25,999 23,123 7,576 5,403 36,035 27,308 (8,726)

Technical staff 31,983 24,471 23,398 28,488 42,968 27,726 28,331 53,449 27,708 33,680 29,947 9,974 7,362 49,267 36,204 (13,062)



1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Revenue factor 2.65 2.23 2.13 2.21 2.52 2.03 2.02 2.49 1.94 2.04 2.02 1.67 1.67 2.25 2.00 (0.26)

Net multiplier 3.63 3.53 3.34 3.41 3.37 3.12 2.99 3.46 3.13 3.14 3.19 3.26 3.35 3.96 3.24 (0.72)

Utilization rate 72.98% 63.11% 63.81% 64.81% 74.74% 65.28% 67.49% 72.00% 62.11% 64.85% 63.25% 51.33% 49.87% 56.87% 61.52% 4.65%

over/(under) 0.15 (0.20) (0.24) 0.29 (0.23) 0.03 (0.01) (0.36) (0.43) 0.40 - (0.40)

Revenue factor target 2.37 2.23 2.26 2.20 2.17 2.01 2.03 2.03 2.10 1.85 2.00 0.15

Revenue factor-Actual 2.65 2.23 2.13 2.21 2.52 2.03 2.02 2.49 1.94 2.04 2.02 1.67 1.67 2.25 2.00 (0.26)

Net revenue-Actual 4,721,215 4,021,505 3,942,721 4,305,886 5,819,770 5,145,372 5,080,186 6,633,421 5,284,722 5,627,666 5,580,565 4,422,748 3,465,211 4,869,755 4,819,281 (50,473)

Total labor-Actual 1,780,436 1,804,052 1,851,312 1,949,123 2,313,495 2,528,672 2,517,883 2,666,426 2,720,613 2,764,556 2,762,453 2,645,884 2,072,747 2,162,613 2,415,499 252,886

Total Labor-Calculated 2,455,599 2,307,341 2,247,870 3,015,191 2,435,356 2,799,834 2,744,990 2,175,479 1,650,101 2,632,300 2,415,499 (216,801)

Net Revenue-Calculated 5,482,984 5,638,939 5,690,416 5,866,137 5,903,729 5,556,758 5,616,068 5,379,082 4,352,768 4,000,834 4,819,281 818,447

Revenue factor variance

Net revenue-over/(under) 336,787 (493,567) (610,230) 767,284 (619,007) 70,908 (35,503) (956,334) (887,557) 868,920 - (868,920)

Total labor-over/(under) (142,104) 221,331 270,013 (348,765) 285,257 (35,278) 17,463 470,406 422,646 (469,687) - 469,687









Labor percentage of net revenue

37.71% 44.86% 46.96% 45.27% 39.75% 49.14% 49.56% 40.20% 51.48% 49.12% 49.50% 59.82% 59.82% 44.41% 50.12% 5.71%

Total labor 1,780,436 1,804,052 1,851,312 1,949,123 2,313,495 2,528,672 2,517,883 2,666,426 2,720,613 2,764,556 2,762,453 2,645,884 2,072,747 2,162,613 2,415,499 252,886

Net revenue 4,721,215 4,021,505 3,942,721 4,305,886 5,819,770 5,145,372 5,080,186 6,633,421 5,284,722 5,627,666 5,580,565 4,422,748 3,465,211 4,869,755 4,819,281 (50,473)

-

Average Annual Salary 30,663 33,660 36,466 36,817 36,360 39,155 41,897 42,510 45,144 46,316 50,886 51,291 48,821 51,394 55,211 3,817

0

41897 42510 45144 46316 50886 51291 48821 50938 55166 4228

39155 41897 42510 45144 46316 50886 51291 48821 50938 2117

107.00% 101.46% 106.20% 102.60% 109.87% 100.80% 95.18% 104.34% 108.30% 3.96%

12/29/2011 7:29 AM C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls

PriorKey

Profit Plan Report

Prior Years' Actual and Current Year-to-Date vs Plan Year

31-Dec-04





Period Period Period Period Period Period Period Period Period Period Period Period Period Period Annual Variance

Acct.# Name 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Plan2004 from

Period 1990 1991 1992 1993 1994 1995 1,996 1,997 1,998 1,999 2,000 2,001 2,002 2,003 Plan2004 Prior Year









Absolute Values 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Total Revenue 7,408,213 6,340,222 6,487,495 6,611,156 9,892,965 9,349,114 8,570,621 10,375,767 8,474,620 9,255,578 8,447,432 6,715,852 5,574,624 7,537,009 7,586,246 49,237

156.91%

Total Revenue % of Net Revenue 157.66% 164.54% 153.54% 169.99% 181.70% 168.71% 156.42% 160.36% 164.47% 151.37% 151.85% 160.87% 154.77% 157.41% 2.64%

Direct Labor 1,299,304 1,138,567 1,181,362 1,263,219 1,729,150 1,650,717 1,699,258 1,919,843 1,689,835 1,792,764 1,747,280 1,358,182 1,033,645 1,229,905 1,486,085 256,181

Net Multiplier 3.63 3.53 3.34 3.41 3.37 3.12 2.99 3.46 3.13 3.14 3.19 3.26 3.35 3.96 3.24 (0.72)

Average Direct Labor Rate 16.11 16.80 18.25 19.02 19.39 20.29 22.06 22.97 23.47 23.94 25.78 25.20 24.73 26.15 27.43 1.27

Average Billing Rate 58.54 59.35 60.90 64.83 65.26 63.25 65.95 79.38 73.40 75.14 82.34 82.06 82.92 103.56 88.94 (14.61)

Utilization Rate-Firmwide Dollars

72.98% 63.11% 63.81% 64.81% 74.74% 65.28% 67.49% 72.00% 62.11% 64.85% 63.25% 51.33% 49.87% 56.87% 61.52% 4.65%

Utilization Rate-Tech Only Hours

82.60% 76.34% 76.57% 76.25% 83.78% 78.56% 81.60% 81.83% 74.54% 78.15% 77.73% 66.13% 64.23% 73.18% 78.94% 5.76%

Ave. Direct Hours/FTE 1,389.06 1,264.22 1,275.20 1,254.61 1,401.58 1,259.73 1,281.80 1,332.26 1,194.77 1,254.80 1,248.40 1,044.83 984.34 1,117.54 1,238.49 120.95

Ave. Direct Hours/Tech-FTE 1,724.71 1,593.89 1,598.68 1,592.17 1,749.37 1,640.23 1,710.30 1,708.70 1,550.49 1,625.51 1,616.80 1,375.52 1,341.22 1,527.91 1,641.94 114.03

Revenue Factor 2.65 2.23 2.13 2.21 2.52 2.03 2.02 2.49 1.94 2.04 2.02 1.67 1.67 2.25 2.00 (0.26)

-

Net Revenue 4,721,215 4,021,505 3,942,721 4,305,886 5,819,770 5,145,372 5,080,186 6,633,421 5,284,722 5,627,666 5,580,565 4,422,748 3,465,211 4,869,755 4,819,281 (50,473)

Labor 1,780,436 1,804,052 1,851,312 1,949,123 2,313,495 2,528,672 2,517,883 2,666,426 2,720,613 2,764,556 2,762,453 2,645,884 2,072,747 2,162,613 2,415,499 252,886

Labor-related expense and benefits

296,971 282,439 312,593 357,758 431,887 429,481 424,875 506,886 531,518 540,057 567,240 483,821 463,921 399,818 445,208 45,390

Other expense (non-labor related)

1,148,140 894,734 831,297 810,609 883,946 812,032 861,389 846,127 745,847 771,236 995,575 902,227 699,158 791,024 763,829 (27,194)

Total expense 3,225,547 2,981,225 2,995,202 3,117,490 3,629,328 3,770,186 3,804,148 4,019,439 3,997,978 4,075,850 4,325,269 4,031,932 3,235,826 3,353,455 3,624,536 271,081

Operating profit 1,495,668 1,040,280 947,519 1,188,396 2,190,442 1,375,186 1,276,039 2,613,982 1,286,745 1,551,816 1,255,296 390,816 229,386 1,516,300 1,194,745 (321,554)

Profit distribution 904,908 838,754 833,045 1,104,901 1,669,399 1,395,884 1,456,292 2,526,689 1,039,376 1,105,401 935,343 123,953 748,993 794,771 993,042 198,271

Net Profit after distribution 590,760 201,526 114,474 83,495 521,044 (20,698) (180,254) 87,293 247,369 446,415 319,954 266,862 (519,608) 721,529 201,703 (519,826)

Other revenue (44,193) (72,472) (68,551) (23,296) (17,737) (55,391) (208,331) (55,477) (68,575) (38,998) (42,403) (137,102) (29,911) (58,301) (6,700) 51,601

Total profit before tax 634,953 273,998 183,025 106,791 538,781 34,692 28,077 142,770 315,944 485,413 362,357 403,964 (489,696) 779,829 208,403 (571,426)

Income Tax 234,361 107,346 77,224 58,591 222,053 14,796 16,625 58,747 119,729 196,401 150,260 165,079 (199,166) 302,328 73,403 (228,925)

Profit after tax 400,592 166,652 105,801 48,200 316,728 19,896 11,452 84,023 196,215 289,012 212,097 238,885 (290,530) 477,501 135,000 (342,501)

FTE 58.06 53.60 50.77 52.94 63.63 64.58 60.10 62.72 60.26 59.69 54.29 51.59 42.46 42.08 43.75 1.67

Percentage of Total Expense -

55.20%

Labor percentage of total expense 60.51% 61.81% 62.52% 63.74% 67.07% 66.19% 66.34% 68.05% 67.83% 63.87% 65.62% 64.06% 64.49% 66.64% 2.15%

Labor+benefits % total expense 64.40% 69.99% 72.25% 74.00% 75.64% 78.46% 77.36% 78.95% 81.34% 81.08% 76.98% 77.62% 78.39% 76.41% 78.93% 2.51%

35.60%

Non-labor expense % total expense 30.01% 27.75% 26.00% 24.36% 21.54% 22.64% 21.05% 18.66% 18.92% 23.02% 22.38% 21.61% 23.59% 21.07% -2.51%

0.00%

72.20% 76.58% 78.29%

Labor,benetfts+ distribution % total expense+distribution 80.80% 83.32% 84.28% 83.63% 87.07% 85.19% 85.11% 81.07% 78.29% 82.45% 80.93% 83.46% 2.53%

Percentage of Net Revenue 0.00%

24.32%

Non-labor expense % net revenue 22.25% 21.08% 18.83% 15.19% 15.78% 16.96% 12.76% 14.11% 13.70% 17.84% 20.40% 20.18% 16.24% 15.85% -0.39%

37.71%

Labor percentage of net revenue 44.86% 46.96% 45.27% 39.75% 49.14% 49.56% 40.20% 51.48% 49.12% 49.50% 59.82% 59.82% 44.41% 50.12% 5.71%

Labor+benefits % net revenue 44.00% 51.88% 54.88% 53.58% 47.17% 57.49% 57.93% 47.84% 61.54% 58.72% 59.67% 70.76% 73.20% 52.62% 59.36% 6.74%

63.17% 72.74%

Labor, benefits, distribution % net revenue 76.01% 79.24% 75.86% 84.62% 86.59% 85.93% 81.21% 78.36% 76.43% 73.57% 94.82% 68.94% 79.97% 11.03%

Operating profit % net revenue31.68% 25.87% 24.03% 27.60% 37.64% 26.73% 25.12% 39.41% 24.35% 27.57% 22.49% 8.84% 6.62% 31.14% 24.79% -6.35%

19.17%

Proift distribution % net revenue 20.86% 21.13% 25.66% 28.68% 27.13% 28.67% 38.09% 19.67% 19.64% 16.76% 2.80% 21.61% 16.32% 20.61% 4.29%

Profit after tax % net revenue8.48% 4.14% 2.68% 1.12% 5.44% 0.39% 0.23% 1.27% 3.71% 5.14% 3.80% 5.40% -8.38% 9.81% 2.80% -7.00%

0.00%

Profit distribution % Labor 50.83% 46.49% 45.00% 56.69% 72.16% 55.20% 57.84% 94.76% 38.20% 39.98% 33.86% 4.68% 36.14% 36.75% 41.11% 4.36%

60.50%

Profit distribution % Operating profit 80.63% 87.92% 92.97% 76.21% 101.51% 114.13% 96.66% 80.78% 71.23% 74.51% 31.72% 326.52% 52.42% 83.12% 30.70%

0.00%

Tax % taxable income 36.91% 39.18% 42.19% 54.87% 41.21% 42.65% 59.21% 41.15% 37.90% 40.46% 41.47% 40.86% 40.67% 38.77% 35.22% -3.55%



Per FTE 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Plan2004

Net Revenue per FTE 81,310 75,034 77,662 81,335 91,465 79,673 84,533 105,755 87,692 94,284 102,797 85,736 81,619 115,729 110,155 (5,574)

Operating Profit per FTE 25,759 19,410 18,664 22,448 34,426 21,294 21,233 41,674 21,351 25,999 23,123 7,576 5,403 36,035 27,308 (8,726)

Distribution per FTE 15,584 15,650 16,409 20,871 26,237 21,614 24,232 40,283 17,247 18,520 17,230 2,403 17,642 18,888 22,698 3,811

0.00%

Average Salary per FTE 30,662.99 33,660.33 36,466.32 36,817.49 36,359.50 39,154.79 41,896.76 42,510.36 45,144.23 46,316.43 50,886.08 51,291.16 48,821.13 51,394.09 55,211.40 3,817.31

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

TimeAnalysis

Annual Monthly Annual Monthly

Time Analysis Dollars Dollars Hours Hours FTE

Technical direct 1,486,085 123,840 54,184 4,515 26.05

Technical indirect 297,041 24,753 8,624 719 4.15

Technical indirect PTO 167,373 13,948 5,832 486 2.80

Total technical 1,950,499 162,542 68,640 5,720 33.00

Non-technical indirect 424,998 35,417 20,536 1,711 9.87

Non-technical indirect PTO 40,001 3,333 1,824 152 0.88

Total nontechnical 465,000 38,750 22,360 1,863 10.75

Total technical and nontechnical 2,415,499 201,292 91,000 7,583 43.75

Total technical and nontechnical PTO 207,374 17,281 7,656 638 3.68

Total less PTO 2,208,125 184,010 83,344 6,945 40.07



Standard hours 2,080.0 173.3



Ratio: Technical/Nontechnical 4.19 4.19 3.07 3.07 3.07



Utilization Rates: Dollars Dollars Hours Hours

Firmwide 61.52% 61.52% 59.54% 59.54%

Technical only 76.19% 76.19% 78.94% 78.94%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

ec234ca0-6214-4690-a3e2-826ba598c32b.xls



Per Mult Mult Percent Percent Per Per

Plan2004 Target Direct of Dir of of Net of Total Total Technical

Profit Plan Analysis: Annual Monthly Hour Labor DPE Revenue Revenue FTE FTE



Billed fee 6,509,824 542,485 120.14 4.38 3.14 135.08% 85.81%

Reimbursable Revenue 1,076,422 89,702 19.87 0.72 0.52 22.34% 14.19%

Unbilled Revenue-WIP - - 0.00 0.00 0.00 0.00% 0.00%

Total Revenue 7,586,246 632,187 140.01 5.10 3.66 157.41% 100.00% 173,400 229,886

Reimbursable Expenses 1,076,422 89,702 19.87 0.72 0.52 22.34% 14.19%

Revenue less Reimbursables 6,509,824 542,485 120.14 4.38 3.14 135.08% 85.81%

Total direct consultants and other 1,690,543 140,879 31.20 1.14 0.82 35.08% 22.28%

Net Revenue 4,819,281 401,607 88.94 3.243 2.32 100.00% 63.53% 110,155 146,039

Direct Labor 1,486,085 123,840 27.43 1.00 0.72 30.84% 19.59%

Indirect expense 2,138,451 178,204 39.47 1.44 1.03 44.37% 28.19%

Break-even point 3,624,536 302,045 66.89 2.44 1.75 75.21% 47.78%



Operating Profit 1,194,745 99,562 22.05 0.80 0.58 24.79% 15.75% 27,308 36,204



DPE Factor from Labor Budget 1.40

(Divided into multiple of direct labor to compute multiple of DPE)



Full-time-equivalents 43.75 33.00





Net Revenue per FTE Annual Monthly



Total staff 110,155 9,180

Technical staff 146,039 12,170





Operating Profit per FTE Annual Monthly



Total staff 27,308 2,276

Technical staff 36,204 3,017





Revenue Factor Target 2.00 (Net multiplier x Utilization rate)

Net Multiplier 3.24

Utilization Rate 61.52%





Revenue factor 2.00 (Net revenue / Total labor)

Net revenue 4,819,281

Total labor 2,415,499





Labor percentage of net revenue 50.12%

Total Labor 2,415,499

Net Revenue 4,819,281

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

LaborSummary

Labor Total Direct Total Direct Pct Dir Pct Dir Average Ave Dir Ave DPE Ave Bill

Summary Wages Dollars Hours Hours FTE Hours Dollars Labor Rate Labor Rate Rate Rate





Principal 346,258 219,337 6,240 3,952 3.0 7.29% 14.76% 55.49 55.50 77.45 179.98

Employee 2,069,241 1,266,748 84,760 50,232 40.8 92.71% 85.24% 24.41 25.22 35.20 81.78





Firm Average 2,415,499 1,486,085 91,000 54,184 43.8 100.00% 100.00% 26.54 27.43 38.28 88.94









Page 24

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

Multiple_of_DPE









Computation of Benefits Factor for Multiple of Direct Personnel Expense



Total wages 2,415,499

Less Paid-time-off benefits:

Holiday Pay 74,160 74,160

Vacation Pay 133,214 133,214

Personal Time-off - -



Net wages for hours worked 2,208,125

Cash bonus 527,485

Profit sharing plan -



Total wages for hours worked 2,735,610 2,735,610



Mandatory benefits:

FICA 144,335

Medicare 35,025

Fica & MC tax on bonus 29,023

Federal unemployment tax 2,493

State unemployment tax 654

Workers' compensation ins. 16,000



Total mandatory benefits 227,530 227,530



Customary benefits:

Health care ins. 198,434

Disability ins. 12,867

Retirement plan contribution 436,534

Cellular Phones -



Total customary benefits 647,834 647,834



Total benefits 1,082,739 1,082,739





Computation of DPE Benefits Factor



Benefits factor 0.396

Raw labor 1.000



DPE factor 1.396 139.58%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

Rates

Summary of Budget Rates and Multipliers:

Year Ending December 31, 2004 Project Annual

Budget Profit

Multipliers Plan



Average billing rate per direct hour $89.00 $88.94

Average direct labor rate $27.43 $27.43

Overhead per direct labor hour $40.00 $39.47

Break-even rate $67.43 $66.89

Operating profit per direct labor hour $21.57 $22.05





Total Multiplier 5.11 5.10

Other direct and reimbursable 1.86 1.86

Net Multiplier 3.25 3.24

Direct labor 1.00 1.00

Overhead multiple of direct labor 1.46 1.44

Break-even multiplier 2.46 2.44

Operating profit multiple of direct labor 0.79 0.80



Multiple of DPE 2.32 2.32

DPE factor 1.40 1.40

Net multiplier 3.25 3.24







Operating profit percentage of net revenue 24.24% 24.79%



Operating profit percentage of total revenue 15.40% 15.75%

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

CashPlan





Cash Plan

For the Fiscal Year Ending

10/31/2004









Begin Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan

Item Total Period Period Period Period Period Period Period Period Period Period Period Period Period

1 2 3 4 5 6 7 8 9 10 11 12 1



Operating profit 1,194,745.36 99,562 99,562 99,562 99,562 99,562 99,562 99,562 99,562 99,562 99,562 99,562 99,562

Other revenue (6,700.00) (558) (558) (558) (558) (558) (558) (558) (558) (558) (558) (558) (558)

- - - - - - - - - - - -

Total 1,201,445.36 100,120 100,120 100,120 100,120 100,120 100,120 100,120 100,120 100,120 100,120 100,120 100,120



Increases

Depreciation 97,164.16 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097

Redeem Cash Value-Life Insurance - 0

- 0 0 0

Hold Deposits-decrease in Accts. Rec. (100,000.00) 1175097 0 0 0 0 0 0 0 0 0 0 -1275097



Total increases (2,835.84) 1,183,194 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 (1,267,000)



Decreases

Bonus payroll tax expense 29,023.28 29,023

Cash bonus 527,485.38 78,282 - 38,300 - 410,904

Retirement plan contribution 373,424.31 373,424 - - 0 -

Corp. income tax deposits 20,000.00 - - - - - 10,000 10,000

State Income Tax 3,000.00 - 1,500 1,500

Dividend/Principals bonus - -

Equipment purchase (depreciation) 97,164.16 8,097.01 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097 8,097

Stock Redemption-Webb 93,015.00 - 93,015

Stock Redemption-Golson 22,563.00 - 22,563 - -



Total decreases 1,165,675.13 459,803 8,097 161,975 8,097 8,097 8,097 8,097 8,097 19,597 8,097 8,097 459,524



Net cash increase/-decrease 32,934.39 823,511 100,120 (53,758) 100,120 100,120 100,120 100,120 100,120 88,620 100,120 100,120 (1,626,403)



Beginning cash balance 38,999.10 38,999 862,510 962,631 908,873 1,008,994 1,109,114 1,209,235 1,309,355 1,409,475 1,498,096 1,598,216 1,698,337



Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Nov

Cash balance-plan 71,933.49 862,510 962,631 908,873 1,008,994 1,109,114 1,209,235 1,309,355 1,409,475 1,498,096 1,598,216 1,698,337 71,933

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

LaborCategory









Labor Budget

Fiscal Year Ending Actual

December 31, 2004 Pay

Rate

Data Entry 3.243

Hourly

Employee Pay DPE Billing

Number Name Position Rate Rate Rate

Princapal

59.48 83.02 192.89

56.22 78.47 182.32

50.77 70.86 164.64

Average 55.49 77.45 179.95

Technical Staff

Project Manager

42.91 59.89 139.15

40.38 56.36 130.95

Average 41.65 58.13 135.05

Senior Engineer

41.40 57.79 134.26

Project Designer

36.59 51.07 118.66

36.54 51.00 118.50

Average 36.57 51.04 118.58

Project Architect

30.29 42.28 98.23

29.86 41.68 96.83

25.75 35.94 83.51

Average 28.63 39.97 92.86

Construction Administration

33.56 46.84 108.83

29.08 40.59 94.30

22.21 31.00 72.03

Average 28.28 39.48 91.72

Project Engineer

27.26 38.05 88.40

25.44 35.51 82.50

Average 26.35 36.78 85.45

Graphics Designer

32.81 45.80 106.40

17.26 24.09 55.97

Average 25.04 34.94 81.19

Interior Designer

24.23 33.82 78.58

Average 24.23 33.82 78.58

Senior Drafter

26.35 36.78 85.45

25.75 35.94 83.51

23.17 32.34 75.14

24.23 33.82 78.58

22.44 31.32 72.77

22.58 31.52 73.23

21.15 29.52 68.59

21.00 29.31 68.10

21.00 29.31 68.10

Average 23.07 32.21 74.83

Drafter

15.75 21.98 51.08

14.70 20.52 47.67

14.70 20.52 47.67

15.38 21.47 49.88

Average 15.13 21.12 49.07

Administrative

36.75 51.30 119.18

35.38 49.38 114.74

28.77 40.16 93.30

20.50 28.61 66.48

18.87 26.34 61.19

18.87 26.34 61.19

17.93 25.03 58.15

17.26 24.09 55.97

15.14 21.13 49.10

9.00 12.56 29.19

7.35 10.26 23.84

7.00 9.77 22.70

6.00 8.37 19.46

Average 18.37 25.64 59.58

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

FTE Calculator



Labor Calculator For Total Amount per/FTE Technical Amount per/FTE

Required Full-Time-Equivalents (FTE) FTE FTE





Gross Multiplier 155.96% 155.96%

Gross Revenue 7,510,024 7,510,024



Target Net Multiplier 3.240 3.24

Net Revenue (6/5) 4,815,353 4,815,353

Net Revnue per FTE (9/25) 110,063 145,926



Ave. Dir. Labor Rate 27.43 27.43

Direct Labor (9/8) 1,486,220 1,486,220



Average Billing Rate (8x12) 88.87 88.87



Available Direct Hours (9/15) 54,182 54,182



Standard Hours/FTE 2,080 2,080



Target Utilization Rate 59.54% 78.94%



Ave Direct Hours/FTE (21x19) 1,238 1,642



Required FTE (17/23) 43.75 33.00

Indirect FTE 10.75



Ratio Tech to Non Tech 3.07

12/29/2011 C:\Docstoc\Working\pdf\ec234ca0-6214-4690-a3e2-826ba598c32b.xls

7:29 AM ec234ca0-6214-4690-a3e2-826ba598c32b.xls

TaxProvision

Computation of Federal Income Tax Provision:

Increase in net worth 135000

Dividend 0

Less - State income tax deduction:

Balance of Prior Years State Tax Paid 0

State Tax Deposits Paid this Year 4500 4500

Federal Taxable Income 130500

Federal Income Tax Rate 0.65 1.00 0.35

Federal Income Tax Provision 70269



Computation of State Income Tax Provision

Federal Taxable Income 130500

Add: State Income Tax Deducted of Federal Return 4500



Net Income Before Federal Income Tax Decuction 135000

Deduct: Federal Income Tax 70269

State Taxable Income 64731

Taxable

State Income Tax Calculation Income Rate Tax

First 25000 25000 0.04 1000

Next 25000 25000 0.05 1250

Next 50000 14731 0.06 884

Next 100000 0 0.07 0

Excess over 200000 0 0.08 0



State Income Tax Provision 64731 3134 3134



Total Federal and State Income Tax Provision 73403



Related docs
Other docs by xiaoyounan
AUSRANK2011W
Views: 0  |  Downloads: 0
G117464796
Views: 0  |  Downloads: 0
absolutist_vs_constitutionalist
Views: 0  |  Downloads: 0
Seminar_10_12_2011
Views: 0  |  Downloads: 0
Excel-Tool Potentialanalyse VDA-6.3-2010_en
Views: 1  |  Downloads: 0
07sanin-ballot-hirei
Views: 0  |  Downloads: 0
DOGs
Views: 0  |  Downloads: 0
smith-waterman_NDSS
Views: 0  |  Downloads: 0
t31c015
Views: 0  |  Downloads: 0
2011-02-13_sermon
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!