Loading...
HomeMy WebLinkAboutInformation Item 12/21 Spread sheet for City of Azusa Public Safety Construction Project Aft - � 9 The City ofAzusa Lipo Police Department John Broderick, Chief of Police INFORMATION ITEM To: Honorable Mayor and Members of the City Council From: John Broderick, Chief of Police Via: Rick Cole, City Manager Date: December 21, 1998 Subject: Spreadsheet for City of Azusa Public Safety Construction Project Please find attached the spreadsheet reflecting the budget vs actual costs as of November 1998. This spreadsheet does not reflect the $500,000 Division of State Architect grant award, which will appear in the December version. If you have any questions or concerns, please call me at(626) 812-3209. Sam Gonzalez, Lieutenant Project Manager * * * Phone #(626)812-3200 • 725 North Alameda Avenue,Azusa, California 91702-2504 • FAX#(626)812-9308 U:10PR0\MISCWORMCAPROJTDEXPAND.WB2 RUN 12/03/88 AT 1003 AM PAGE 1 CITY OF AZUSA POLICE FACILITY CONSTRUCTION PROJECT BUDGET VS ACTUAL COSTS AS OF NOVEMBER 1998 COUNCIL ITEMS ON CONTRACT ITEMS NOT CUMULATIVE NET REMAINING AMT(OVER) CUMULATIVE BUDGET BUDGET FUNDING WORK APPROVAL ORIGINAL ON AMOUNT LESS AMOUNT CONTRACT UNDER AMOUNT Draw DESCRIPTION AMOUNT SOURCE VENDOR DESCRIPTION DATE QUOTE CHANGES TOTAL CONTRACT BILLED RETENTION BILLED AMOUNT BUDGET EXPENSED Number FY 1998/99 ARCHITECT&PROJ MGMT 150 LaSalle Kanda&Tso Assoc Engrg-Svc Bldg N/A 150.00 0.00 150.00 0.00 0.00 0.00 150.00 0 0.00 3,650 LaSalle WMM Associates State Grant-2nd 1/2 N/A 3,650.00 0.00 3,650.00 3,650.00 0.00 3,650.00 0.00 0 3,650.00 216 4,500 LaSalle WMM Associates Construction Admin N/A 4,500.00 0.00 4,500.00 4,500.00 0.00 4,500.00 0.00 0 8,150.00 252 O LaSalle Contingency Contingency N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 8,150.00 8,300 8,300.00 0.00 8,300.00 0.00 6,150.00 0.00 8,150.00 150.00 0.00 LEGAL SERVICES 4,027 LaSalle Best Best&Krieger Legal Svcs N/A 0.00 0.00 0.00 4,027.15 0.00 0.00 0.00 4,027.15 0 0.00 LAND AND INSURANCE 3,262 LaSalle To Be Advised/ICRMA Insurance N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,262 0.00 CONSTRUCTION-BLDG 347,127 LaSalle Hazama Corporation Construction 02/18/97 347,126.99 0.00 347,126.99 347,126.99 0.00 347,126.99 0.00 0 347,126.99 207,224,236,253P 46,762 Hazama Corporation Construction 08/04/97 0.00 46,762.00 46,762.00 30,112.81 0.00 30,112.81 16,649.19 0 377,239.80 253P 206,700 Hazama Corporation Construction 09/15/97 0.00 206,700 206,700.00 206,700.00 0.00 206,700.00 0.00 0 583,939.80 248,253P 88,283 Hazama Corporation Construction 12/01/97 0.00 88,283 88,283.00 0.00 0.00 0.00 88,283.00 0 583,939.80 27,279 Hazama Corporation Construction 01/20/98 0.00 27,279 27,279.00 0.00 0.00 0.00 27,279.00 0 583,939.80 112,000 Hazama Corporation Construction 01/20/98 0.00 112,000 112,000.00 0.00 0.00 0.00 112,000.00 0 583,939.80 51,811 Hazama Corporation Construction 04/06/98 0.00 51,811 51,811.00 0.00 0.00 0.00 51,811.00 0 583,939.80 4,554 Hazama Corporation Construction N/A 0.00 4,554 4,554.00 0.00 0.00 0.00 4,554.00 0 583,939.80 4,962 Hazama Corporation Construction N/A 0.00 4,962 4,962.00 0.00 0.00 0.00 4,962.00 0 583,939.80 4,321 Hazama Corporation Construction N/A 0.00 4,321 4,321.00 0.00 0.00 0.00 4,321.00 0 583,939.80 3,145 Hazama Corporation Construction N/A 0.00 3,145 3,145.00 0.00 0.00 0.00 3,145.00 0 583,939.80 4,537 Hazama Corporation Construction N/A 0.00 4,537 4,537.00 0.00 0.00 0.00 4,537.00 0 583,939.80 4,355 Hazama Corporation Construction N/A 0.00 4,355 4,355.00 0.00 0.00 0.00 4,355.00 0 583,939.80 2,805 Hazama Corporation Construction N/A 0.00 2,805 2,805.00 0.00 0.00 0.00 2,805.00 0 583,939.80 4,108 Hazama Corporation Construction N/A 0.00 4,108 4,108.00 0.00 0.00 0.00 4,108.00 0 583,939.80 4,930 Hazama Corporation Construction N/A 0.00 4,930 4,930.00 0.00 0.00 0.00 4,930.00 0 583,939.80 4,558 Hazama Corporation Construction N/A 0.00 4,558 4,558.00 0.00 0.00 0.00 4,558.00 0 583,939.80 4,037 Hazama Corporation Construction N/A 0.00 4,037 4,037.00 0.00 0.00 0.00 4,037.00 0 583,939.80 4,832 Hazama Corporation Construction 08/12/98 0.00 4,832 4,832.00 4,832.00 0.00 4,832.00 0.00 0 588,771.80 224 119,690 Hazama Corporation Construction 08/17/98 0.00 119,690 119,690.00 119,690.00 0.00 119,690.00 0.00 0 708,461.80 224 17,881 Hazama Corporation Construction 08/17/98 0.00 17,881 17,881.00 0.00 0.00 0.00 17,881.00 0 708,461.80 42,267 LaSalle Hazama Corporation Construction 11/03/98 0.00 42,267 42,267.00 0.00 0.00 0.00 42,267.00 0 708,461.80 8,381 LaSalle Converse Consultants Geotechnical Svcs None 0.00 8,380.97 8,380.97 5,765.84 0.00 5,765.84 2,615.13 0 714,227.64 225,229,238,242,254 6,739 LaSalle Excel Systems Security Access 03/16/98 6,739.20 0.00 6,739.20 0.00 0.00 0.00 6,739.20 0 714,227.64 8,908 LaSalle Apex Engineering Ductwork Engrg N/A 8,908.00 0.00 8,908.00 8,908.00 0.00 8,908.00 0.00 0 723,135.64 217,232 1,050 LaSalle Dr.Maureen Sassoon Asbestos Abatement N/A 600.00 0.00 600.00 450.00 1,050.00 0.00 1,050.00 0.00 0 724,185.64 205,231 219 LaSalle Signs&Lucite Prods Signs N/A 218.67 0.00 218.67 218.67 0.00 218.67 0.00 0 724,404.31 223 521 LaSalle Lab Safety Supply Carpet Runner N/A 520.63 0.00 520.63 482.60 0.00 482.60 38.03 0 724,886.91 218 1,652 LaSalle Laschober&Sovich Food Svc Consult N/A 1,651.50 0.00 1,651.50 1,651.50 0.00 1,651.50 0.00 0 726,538.41 219,233 7,746 LaSalle Montana Testing Geotechnical Svcs N/A 0.00 7,746.00 7,746.00 7,746.00 0.00 7,746.00 0.00 0 734,284.41 220,240.243,258 300 LaSalle National Roofing Roof Inspector N/A 0.00 300.00 300.00 300.00 0.00 300.00 0.00 0 734,584.41 221 280 LaSalle Pete's Cabling Sign Cabling/Radio N/A 280.00 0.00 280.00 280.00 0.00 280.00 0.00 0 734,864.41 222 4,079 LaSalle Excel Systems Radio Disp Interface N/A 4,079.00 0.00 4,079.00 4,079.00 0.00 4,079.00 0.00 0 738,943.41 249 4,870 LaSalle Weld Tech Wtr/Gas Piping N/A 4,870.00 0.00 4,870.00 4,870.00 0.00 4,870.00 0.00 0 743,813.41 234 240 LaSalle Grainger Air Hose/Tire Inflatr N/A 240.40 0.00 240.40 240.40 0.00 240.40 0.00 0 744,053.81 235 145 LaSalle Pete Carltock Cabling-MessegSign N/A 145.00 0.00 145.00 145.00 0.00 145.00 0.00 0 744,198.81 237 200 LaSalle Engineered Concrete Core Drilling N/A 0.00 0.00 0.00 200.00 200.00 0.00 200.00 0.00 0 744,398.81 239 504 LaSalle Azusa/Environ Hith Plan Ck-LACO N/A 0.00 0.00 0.00 504.00 504.00 0.00 504.00 0.00 0 744,902.81 241 4,750 LaSalle Kel-Fam Acoustics Fire Range Panels N/A 4,750.00 0.00 4,750.00 4,750.00 0.00 4,750.00 0.00 0 749,652.81 256 O LaSalle To Be Advised Gym Expnsn/Storage None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 749,652.81 20,250 LaSalle To Be Advised Fire Range Flooring None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,250 749,652.81 O LaSalle To Be Advised Signage/Elect. None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 749,652.81 1,181,778 380,129.39 780,243.97 1,160,373.36 1,154.00 749,652.81 0.00 749,652.81 411,874.55 20,251 COMMUNICATION SYSTEM 5,004 LaSalle Warner Group Comm Sys Design 11/04/96 5,004.00 0.00 5,004.00 0.00 0.00 0.00 5,004.00 0 0.00 3,250 LaSalle Warner Group Comm Sys Design None 0.00 3,250.00 3,250.00 0.00 0.00 0.00 3,250.00 0 0.00 O Gen Fnd To Be Advised AVL None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 O LaSalle To Be Advised Mapping None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 19,828 LaSalle Durham Communication Radio Equip/Upgrade 10/06/97 19,828.00 0.00 19,828.00 0.00 0.00 0.00 19,828.00 0 0.00 150 LaSalle Greg Hampton Silent Radio Install None 0.00 0.00 0.00 150.00 150.00 0.00 150.00 0.00 0 150.00 227 3,986 LaSalle Excel Systems Relocate Panel N/A 3,986.00 0.00 3,986.00 3,986.00 0.00 3,986.00 0.00 0 4,136.00 255 O LaSalle To Be Advised Radio Equipment None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 4,136.00 U:W PRONASCWORK\CAPROAPDEXPAND.WB2 RUN 12/03/98 AT 10:03 AM PAGE 2 I CITY OF AZUSA POLICE FACILITY CONSTRUCTION PROJECT BUDGET VS ACTUAL COSTS , AS OF NOVEMBER 1998 II COUNCIL ITEMS ON CONTRACT ITEMS NOT CUMULATIVE NET REMAINING AMT(OVER) CUMULATIVE BUDGET BUDGET FUNDING WORK APPROVAL ORIGINAL ON AMOUNT LESS AMOUNT CONTRACT UNDER AMOUNT Draw DESCRIPTION AMOUNT SOURCE VENDOR DESCRIPTION DATE QUOTE CHANGES TOTAL CONTRACT BILLED RETENTION BILLED AMOUNT BUDGET EXPENSED Number 32,218 28,818.00 3,250.00 32,068.00 150.00 4,136.00 0.00 4,136.00 28,082.00 0 DATA/TELECOMMUNICATION 560 LaSalle Hewlett Packard Move Computer N/A 560.00 0.00 560.00 0.00 0.00 0.00 560.00 0 0.00 O LaSalle To Be Advised CAD Upgrade N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 180 LaSalle Apex Engineering CAD Upgrade N/A 180.00 0.00 180.00 0.00 0.00 0.00 180.00 0 0.00 4,932 LaSalle To Be Advised Computer Hdwre/Soft N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 9,710 LaSalle Compaq Computer Corp (5)Laptops/MDC 10/19/98 9,710.03 0.00 9,710.03 0.00 0.00 0.00 9,710.03 0 0.00 250 LaSalle Data Comm%Micro Hubs/Cables N/A 250.47 0.00 250.47 0.00 0.00 0.00 250.47 0 0.00 • 17,075 LaSalle Excel Systems ID Mgr System 10/19/98 17,075.00 0.00 17,075.00 0.00 0.00 0.00 17,075.00 0 0.00 700 LaSalle Excel Systems Install Paging Sys N/A 700.00 0.00 700.00 437.50 0.00 437.50 262.50 0 437.50 249 135 LaSalle Peter Carltock IMAX Cabling N/A 135.00 0.00 135.00 135.00 0.00 135.00 0.00 0 572.50 246 2,363 LaSalle Cable Express Intel Hubs N/A 2,363.13 0.00 2,363.13 0.00 0.00 0.00 2,363.13 0 572.50 31,137 LaSalle To Be Advised Hubs/Routers N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 572.50 80,239 LaSalle To Be Advised MDC's N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.000 572.50 4,163 LaSalle To Be Advised Operations Support N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 572.50 130 LaSalle To Be Advised PC Computers N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 572.50 O LaSalle To Be Advised Professional Consult N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.000 572.50 4,900 LaSalle Advanced Inter Systems Network Consultant N/A 4,900.00 0.00 4,900.00 4,900.00 0.00 4,900.00 0.000 5,472.50 245 75 LaSalle Michael Comfier Computer Consult N/A 0.00 0.00 0.00 75.00 75.00 0.00 75.00 0.000 5,547.50 226 493 LaSalle Jet Research Viewsonic Monitor N/A 492.54 0.00 492.54 492.54 0.00 492.54 0.000 6,040.04 228 47,177 LaSalle Lucent Technologies Cabling-Teleph/Comp 01/20/98 47,176.84 0.00 47,176.84 47,176.84 0.00 47,176.84 0.000 53,216.88 247P 28,961 Gen Fnd Lucent Technologies Cabling-Teleph/Comp 01/20/98 28,960.82 0.00 28,960.82 15,947.10 0.00 15,947.10 13,013,72 0 69,163.98 247P 6,019 LaSalle Lucent Technologies Ceiling Speakers 02/17/98 6,019.45 0.00 6,019.45 0.00 0.00 0.00 6,019.45 0 69,163.98 218 LaSalle Lucent Technologies Install 24-Port Pack N/A 218.00 0.00 218.00 0.00 0.00 0.00 218.00 0 69,163.98 293 LaSalle Lucent Technologies Install Fax Line N/A 0.00 0.00 0.00 293.49 293.49 0.00 293.49 0.00 0 69,457.47 230 3,964 LaSalle Lucent Technologies Circuit Pack-16 Port N/A 3,963.95 0.00 3,963.95 0.00 0.00 0.00 3,963.95 0 69,457.47 418 LaSalle Lucent Technologies Install Analog Line N/A 418.00 0.00 418.00 418.00 0.00 418.00 0.00 0 69,875.47 250 2,293 LaSalle Voice&Data Network Telephone Equipmt N/A 2,293.30 0.00 2,293.30 1,831.65 0.00 1,831.65 461.65 0 71,707.12 244 O LaSalle To Be Advised Telephone Equipmt N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 71,707.12 246,386 125,416.53 0.00 125,416.53 368.49 71,707.12 0.00 71,707.12 54,077.90 0 FURNISHINGS 8,000 LaSalle To Be Advised Employee Lockers N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 22,500 LaSalle Quality Matl Handling Employee Lockers 11/16/98 22,500.00 0.00 22,500.00 0.00 0.00 0.00 22,500.00 0 0.00 O LaSalle To Be Advised Office Space/Tmg N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 102 LaSalle Azusa Glass Desktop Glass N/A 102.49 0.00 102.49 102.49 0.00 102.49 0.00 0 102.49 206 20,544 LaSalle KI%West Office Int Ph 2 Furniture 01/20/98 19,650.68 0.00 19,650.68 0.00 0.00 0.00 19,650.68 0 102.49 8,741 LaSalle KI%West Office Int Furniture 01/20/98 8,741.10 0.00 8,741.10 3,894.85 0.00 3,894.85 4,846.25 0 3,997.34 257 7,244 LaSalle Western Office Interiors Work Stations 01/20/98 7,243.70 0.00 7,243.70 6,353.88 0.00 6,353.88 889.82 0 10,351.22 251,259 3,824 LaSalle Western Office Interiors Computer Unit N/A 3,649.11 0.00 3,649.11 3,649.11 0.00 3,649.11 0.000 14,000.33 251 40,330 LaSalle Western Office Interiors Work Stns-Ph 2 01/20/98 40,330.41 0.00 40,330.41 0.00 0.00 0,00 40,330.41 0 14,000.33 1,256 LaSalle 0&R Office Works (4)Exec Chairs N/A 1,255.70 0.00 1,255.70 0.00 0.00 0.00 1,255.700 14,000.33 6,568 LaSalle To Be Advised Evidence Storage N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 14,000.33 1,903 LaSalle California's Best Window Tinting N/A 1,903.00 0.00 1,903.00 0.00 0.00 0.00 1,903.00 0 14,000.33 _ 7,688 LaSalle To Be Advised Window Coverings N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 14,000.33 128,701 105,376.19 0.00 105,376.19 0.00 14,000.33 0.00 14,000.33 91,375.86 0 MISCELLANEOUS (1,030) LaSalle First Trust Escrow Fees N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (1,030) 0.00 50 LaSalle Atlantic Relocation Sys Professional Movers N/A 50.00 0.00 50.00 0.00 0.00 0.00 50.00 0 0.00 401 LaSalle Craig Electric Flag Floodlights N/A 400.53 0.00 400.53 400.53 0.00 400.53 0.00 0 400.53 215 2,654 LaSalle To Be Advised Professional Movers N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 400.53 2,075 451 0 451 0 401 0 401 50 (1,030) PROJECT CONTINGENCY 0 Gen Fnd Contingency Contingency N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 O LaSalle Contingency Contingency N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 O 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 SUBTOTAL 1998/99: 1,606,747 648,490.64 783,493.97 1,431,984.61 5,699.64 848,046.79 0.00 848,046.79 589,637.46 22,483 848,046.79 AMT TO BE REIMBURSED TO GEN FND BY LIGHT FND 0 ---- ---- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 TOTAL 1998/99 1,606,747 648,490.64 783,493.97 1,431,984.61 5,699.64 848,046.79 0.00 848,046.79 589,637.46 22,483 848,046.79 TOTAL-ALL YEARS 5,618,214 4,194,739 1,156,235 5,350,974 98,177 4,859,514 (175,958) 4,683,558 589,637 22,484 4,859,514