12 - A - Copy of AOL TW CSTRPT5-9-02.XLS

Cost Report Project: XYZ Address: 123 ABC Road Job Number: 12345 Exhibit "A" Tri-Line Contracting A. B. C. (A + B) REVISED BUDGET 104,200 41,120 169,081 225,218 32,500 1,583,382 43,300 73,080 13,700 9,400 41,795 188,645 260,970 1,730,600 449,242 218,784 4,617 399,048 10000 52,231 28,436 25,900 34,000 35,200 335,000 1,800 300,350 3,200,196 3,500,560 100,000 82,000 126,660 0 0 0 0 0 13,421,015 1,062,210 14,483,225 240,123 14,723,348 813,185 0 TRADE DESCRIPTION 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 33 34 35 36 37 38 39 40 41 42 Demolition Protection/Barricades Concrete Steel/Misc. Iron/stair Fireproofing Architectural Woodwork Roofing /Sheet metal Work Raise roof at generator room Fire stopping Hollow metal Doors and frames Hardware Architectural Metal and Glass Raised Floor Drywall and carpentry/Ceilings Stone and ceramic tile Resilient Flooring and carpet Fluid applied Flooring Painting and wall covering Toilet Accessories Lockers Folding Wall Shower Doors Residential Appliances Window treatment Sprinkler Fire Extinguisher Cabinets Plumbing HVAC Electrical Security System Building Department Fee Kitchen Cabinets Telecom Cabling A/V System Final Cleaning Fitness Center Saunas Prepurchase Equipment SUBTOTAL (Includes Tax) GENERAL CONDITIONS SUBTOTAL INSURANCE SUBTOTAL FEE TOTAL FOR GC, Ins. & Fee 10/23/01 SCOPE BUDGET CHANGES 104,200 41,120 169,081 225,218 32,500 1,583,382 43,300 73,080 13,700 9,400 41,795 188,645 260,970 1,730,600 449,242 218,784 4,617 399,048 10,000 52,231 28,436 25,900 34,000 35,200 335,000 1,800 300,350 3,200,196 3,500,560 100,000 82,000 126,660 In Below In Below In Below In Below In Above 13,421,015 1,062,210 14,483,225 240,123 14,723,348 813,185 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 F. G. H. I. J. (D + E) (G + H + I) BASE COMMITTED TOTAL ANTICIPATEDPENDING TOTAL COMMITTED CHANGE COMMITTED REMAIN TO CHANGE ANT. ANTICIPATED COST ORDERS COST PURCHASE ORDERS EXTRASTO PURCHASE 76,025 0 160,581 266,756 0 1,260,542 0 7,900 0 7,400 41,795 257,250 258,520 1,528,500 438,217 219,404 0 339,730 3,155 52,231 10,854 22,056 39,644 28,450 335,000 0 333,350 3,023,000 3,476,570 0 82,000 109,102 883,726 430,711 0 14,150 0 13,706,619 1,062,210 14,768,829 221,532 14,990,361 749,518 2,033,261 0 0 76,267 200,000 20,000 250,000 31,817 7,900 0 0 19,985 67,630 66,029 245,516 39,330 33,974 40836 61,158 0 (21,016) 0 0 10,035 0 97,764 0 90,768 196,228 157,500 50,000 0 8,449 45,764 0 22,895 0 1,818,829 145,506 1,964,335 29,465 1,993,800 99,690 274,661 76,025 0 236,848 466,756 20,000 1,510,542 31,817 15,800 0 7,400 61,780 324,880 324,549 1,774,016 477,547 253,378 40,836 400,888 3,155 31,215 10,854 22,056 49,679 28,450 432,764 0 424,118 3,219,228 3,634,070 50,000 82,000 117,551 929,490 430,711 22,895 14,150 0 15,525,448 1,207,716 16,733,164 250,997 16,984,162 849,208 2,307,922 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 0 0 0 0 0 0 0 0 10,000 0 0 10,000 0 10,000 150 10,150 508 658 0 0 (2,000) (1,250) 0 12,217 0 0 0 0 5,323 8,900 11,547 (16,678) (609) 8,293 0 13,591 0 0 0 0 0 0 0 0 2,398 0 50,000 0 0 0 19,163 10,622 0 0 0 121,517 9,721 131,238 1,969 133,207 6,660 18,350 0 0 5,000 12,000 200 5,000 2,000 0 1,500 0 3,500 5,000 4,500 2,500 1,500 0 5,600 0 0 200 0 0 0 0 0 0 20,000 12,500 14,000 0 0 1,000 27,586 10,000 7,000 0 2,500 143,086 150,000 293,086 4,396 297,482 14,874 169,270 0 0 3,000 10,750 200 17,217 2,000 0 1,500 0 8,823 13,900 16,047 (14,178) 891 8,293 5,600 13,591 0 200 0 0 0 0 0 0 22,398 12,500 64,000 0 0 1,000 46,749 20,622 17,000 0 2,500 274,603 159,721 434,324 6,515 440,839 22,042 188,278 D. E. K. (F + J) TOTAL ANTIC. COSTS 76,025 0 239,848 477,506 20,200 1,527,759 33,817 15,800 1,500 7,400 70,603 338,780 340,596 1,759,838 478,438 261,671 46,436 414,479 3,155 31,415 10,854 22,056 49,679 28,450 432,764 0 446,516 3,231,728 3,698,070 50,000 82,000 118,551 976,239 451,333 39,895 14,150 2,500 15,800,051 1,367,438 17,167,489 257,512 17,425,001 871,250 2,496,200 L. (C - K) VARIANCE (28,175) (41,120) 70,767 252,288 (12,300) (55,623) (9,483) (57,280) (12,200) (2,000) 28,808 150,135 79,626 29,238 29,196 42,887 41,819 15,431 (6,845) (20,816) (17,582) (3,844) 15,679 (6,750) 97,764 (1,800) 146,166 31,532 197,510 (50,000) 0 (8,109) 976,239 451,333 39,895 14,150 2,500 2,379,036 305,228 2,684,264 17,389 2,701,653 58,065 2,496,200 Cost Report Project: XYZ Address: 123 ABC Road Job Number: 12345 Exhibit "A" Tri-Line Contracting A. B. C. (A + B) REVISED BUDGET 0 TRADE DESCRIPTION 43 44 45 46 47 48 49 50 51 52 53 54 TAX SUBTOTAL CONTINGENCY Final Cleaning Tele/Com Cabling *A/V System Preconstruction Services Control Inspection Fitness Center Saunas PREMIUM TIME ALLOWANCE TOTAL 10/23/01 SCOPE BUDGET CHANGES F. G. H. I. J. (D + E) (G + H + I) BASE COMMITTED TOTAL ANTICIPATEDPENDING TOTAL COMMITTED CHANGE COMMITTED REMAIN TO CHANGE ANT. ANTICIPATED COST ORDERS COST PURCHASE ORDERS EXTRASTO PURCHASE 115,896 15,855,775 0 0 15,656 2,109,146 0 0 0 0 0 0 0 0 2,109,146 131,552 17,964,921 0 0 0 0 165,000 0 0 0 18,129,921 37 10,695 0 0 0 0 20,000 0 30,695 1,046 140,913 0 0 0 0 0 0 0 140,913 9,648 322,005 0 0 0 0 0 0 0 20,000 342,005 10,732 473,613 0 0 0 0 0 20,000 0 20,000 513,613 D. E. K. (F + J) TOTAL ANTIC. COSTS 142,283 18,438,534 0 0 0 0 165,000 20,000 0 20,000 18,643,534 L. (C - K) VARIANCE 142,283 2,902,001 (550,000) (75,000) (900,000) (900,000) 0 (30,000) (70,000) (380,000) (2,999) 15,536,533 550,000 75,000 900,000 250,000 165,000 50,000 70,000 400,000 17,996,533 0 0 0 0 650,000 0 0 0 0 650,000 15,536,533 550,000 75,000 900,000 900,000 165,000 50,000 70,000 400,000 18,646,533 165,000 0 0 16,020,775