Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Purchase Orders report
City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 1 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 010007 ABSOLUTE SECURITY IN 00000028 001 100510-55330- Y Security Guard Services 55,000.00 55,000.00 0.00 00000028 001 100520-55300- Y Security Guard Services 3,300.00 3,300.00 0.00 PO# 00000028 Due on 08/31/2020 Dept/Loc: 510 Totals: 58,300.00 58,300.00 0.00 Security Guard Services 00000059 001 100510-55330- SECURITY GUARD SERVICES 55,000.00 348.40 54,651.60 00000059 002 100520-55300- SECURITY GUARD SERVICES 3,300.00 0.00 3,300.00 PO# 00000059 Due on 07/01/2020 Dept/Loc: 510 Totals: 58,300.00 348.40 57,951.60 SECURITY GUARD SERVICES Vendor # 010007 ABSOLUTE SECURITY IN Totals: 116,600.00 58,648.40 57,951.60 **** 010009 ADORAMA 00000095 001 270240-56116- ROLAND ALL-IN-ONE HD AV MIXER FO 2,473.12 0.00 2,473.12 PO# 00000095 Due on Dept/Loc: 240 Totals: 2,473.12 0.00 2,473.12 BROADCAST EQUIPMENT - SWITCHER Vendor # 010009 ADORAMA Totals: 2,473.12 0.00 2,473.12 **** 010011 AGRICULTURAL COMM. W 00000089 001 239639-55526- WEED ABATEMENT - LLAD 39 42,607.00 0.00 42,607.00 00000089 002 241641-55526- WEED ABATEMENT - LLAD 41 27,741.00 0.00 27,741.00 PO# 00000089 Due on 05/03/2021 Dept/Loc: 630 Totals: 70,348.00 0.00 70,348.00 WEED ABATEMENT - LLAD 39 & 41 Vendor # 010011 AGRICULTURAL COMM. W Totals: 70,348.00 0.00 70,348.00 **** 010020 AMERICOMP GROUP 00000076 001 100230-55000- CONTRACT SERVICES - PRINTERS/COP 10,000.00 3,319.06 6,680.94 00000076 002 100230-51200- TONERS FOR PRINTERS AND COPIERS 27,000.00 9,421.68 17,578.32 PO# 00000076 Due on Dept/Loc: 230 Totals: 37,000.00 12,740.74 24,259.26 CONTRACT SERVICES/TONER Vendor # 010020 AMERICOMP GROUP Totals: 37,000.00 12,740.74 24,259.26 **** 010037 BEST CONTRACTING SER 00200152 001 504510-56100- DBC ROOF REHAB PROJECT (PHASE 3) 111,800.00 106,210.00 5,590.00 PO# 00200152 Due on Dept/Loc: 610 Totals: 111,800.00 106,210.00 5,590.00 DBC ROOF REHAB PROJECT (PHASE 3) SECTIONS H,E,J&K Vendor # 010037 BEST CONTRACTING SER Totals: 111,800.00 106,210.00 5,590.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 2 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 010038 BEST LIGHTING PRODUC 00000027 001 100630-55505- PARKS 18,000.00 13,868.34 4,131.66 00000027 002 100620-52320- CITY HALL 6,500.00 1,981.67 4,518.33 00000027 003 100510-52320- DIAMOND BAR CENTER 7,000.00 2,404.14 4,595.86 00000027 004 238638-52320- DISTRICT #38 5,000.00 1,895.21 3,104.79 PO# 00000027 Due on Dept/Loc: 630 Totals: 36,500.00 20,149.36 16,350.64 MONTHLY MAINTENANCE & LIGHTING SUPPLIES 00200020 001 100620-52320- Dept 620 - MAINT OF GROUNDS/BUIL 4,324.53 4,324.53 0.00 00200020 002 100510-52320- Dept 510 - MAINT OF GROUNDS/BUIL 4,303.22 4,303.22 0.00 00200020 003 238638-52320- Dept 638 - MAINT OF GROUNDS/BUIL 3,075.60 3,075.60 0.00 00200020 004 100630-55520- Dept 630 - CS - TRAILS MAINTENAN 990.02 990.02 0.00 PO# 00200020 Due on Dept/Loc: 620 Totals: 12,693.37 12,693.37 0.00 MAINT OF GROUNDS/BUILDINGS Vendor # 010038 BEST LIGHTING PRODUC Totals: 49,193.37 32,842.73 16,350.64 **** 010043 BRIGHTVIEW LANDSCAPE 00000026 001 100510-55505- DIAMOND BAR CENTER 72,528.00 60,440.00 12,088.00 00000026 002 100630-55505- PARKS 356,628.00 297,190.00 59,438.00 00000026 003 100510-52320- "AS-NEEDED" DIAMOND BAR CENTER 5,000.00 0.00 5,000.00 00000026 004 100630-52320- "AS-NEEDED" PARKS 25,000.00 9,284.07 15,715.93 PO# 00000026 Due on Dept/Loc: 630 Totals: 459,156.00 366,914.07 92,241.93 LANDSCAPE MAINTENANCE 00200012 001 100630-52320- Dept 630 - MAINT OF GROUNDS/BUIL 11,025.22 11,025.22 0.00 00200012 002 100510-55300- Dept 510 - CS - SPECIAL EVENTS 13,236.36 13,236.36 0.00 00200012 003 100630-55300- Dept 630 - CS - SPECIAL EVENTS 29,719.00 29,719.00 0.00 PO# 00200012 Due on Dept/Loc: 630 Totals: 53,980.58 53,980.58 0.00 MAINTENANCE Vendor # 010043 BRIGHTVIEW LANDSCAPE Totals: 513,136.58 420,894.65 92,241.93 **** 010051 CALIFORNIA NEWSPAPER 00000030 001 100240-52110- Printing newsletter, guide and c 53,998.86 46,689.04 7,309.82 PO# 00000030 Due on Dept/Loc: 240 Totals: 53,998.86 46,689.04 7,309.82 Printing of newsletter, guide and calendar Vendor # 010051 CALIFORNIA NEWSPAPER Totals: 53,998.86 46,689.04 7,309.82 **** 010054 CANNON CORPORATION 00000046 001 100615-54400- On-Call Engineering - $5,000 5,000.00 210.00 4,790.00 00000046 002 100615-54420- PS Plan Check - $10,000 10,000.00 5,687.55 4,312.45 00000046 003 100615-54440- PS Inspection - $5,000 5,000.00 462.00 4,538.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 3 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open PO# 00000046 Due on 10/11/2020 Dept/Loc: 610 Totals: 20,000.00 6,359.55 13,640.45 On-Call Engineering Services (Penco) 00200095 001 100615-54420- ON-CALL ENGINEERING 12,699.21 0.00 12,699.21 00200095 002 100615-54440- ON-CALL ENGINEERING 4,386.42 210.35 4,176.07 PO# 00200095 Due on Dept/Loc: 615 Totals: 17,085.63 210.35 16,875.28 ON-CALL ENGINEERING Vendor # 010054 CANNON CORPORATION Totals: 37,085.63 6,569.90 30,515.73 **** 010060 DENNIS CAROL A 00000039 001 100130-54900- Y MINUTE TRANSCRIPTION FOR COUNCIL 14,300.00 14,300.00 0.00 00000039 001 100410-54900- Y MINUTE TRANSCRIPTION FOR COUNCIL 2,000.00 2,000.00 0.00 00000039 001 100520-54900- Y MINUTE TRANSCRIPTION FOR COUNCIL 950.00 950.00 0.00 00000039 001 100610-54900- Y MINUTE TRANSCRIPTION FOR COUNCIL 1,500.00 1,500.00 0.00 PO# 00000039 Due on Dept/Loc: 140 Totals: 18,750.00 18,750.00 0.00 MINUTE TRANSCRIPTION SERVICES 00000053 001 100130-54900- MINUTE SECRETARY FOR COUNCIL & C 14,300.00 2,750.00 11,550.00 00000053 002 100410-54900- MINUTE SECRECTARY FOR COUNCIL & 2,000.00 475.00 1,525.00 00000053 003 100520-54900- MINUTE SECRECTARY FOR COUNCIL & 950.00 175.00 775.00 00000053 004 100610-54900- MINUTE SECRECTARY FOR COUNCIL & 1,500.00 300.00 1,200.00 PO# 00000053 Due on Dept/Loc: 130 Totals: 18,750.00 3,700.00 15,050.00 MINUTE SECRETARY FOR COUNCIL & COMMISSION MEETINGS Vendor # 010060 DENNIS CAROL A Totals: 37,500.00 22,450.00 15,050.00 **** 010079 CIVIC PUBLICATIONS I 00000010 001 253180-52110- Y USED OIL GRANT ADVERTISING IN LO 387.00 387.00 0.00 00000010 001 253180-52160- Y USED OIL GRANT ADVERTISING IN LO 1,300.00 1,300.00 0.00 00000010 001 253180-52170- Y USED OIL GRANT ADVERTISING IN LO 2,800.00 2,800.00 0.00 PO# 00000010 Due on Dept/Loc: 130 Totals: 4,487.00 4,487.00 0.00 USED OIL GRANT ADVERTISING Vendor # 010079 CIVIC PUBLICATIONS I Totals: 4,487.00 4,487.00 0.00 **** 010094 DAPEER ROSENBLIT & L 00000068 001 100120-54024- CITY PROSECUTOR - CODE ENFORCEME 50,000.00 20,161.83 29,838.17 PO# 00000068 Due on Dept/Loc: 410 Totals: 50,000.00 20,161.83 29,838.17 CITY PROSECUTOR - CODE ENFORCEMENT Vendor # 010094 DAPEER ROSENBLIT & L Totals: 50,000.00 20,161.83 29,838.17 **** 010097 DAVID EVANS AND ASSO 00180177 001 301610-56105- GRAND/GSD INTERSECTION ENHANCEME 2,365.13 2,365.13 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 4 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open PO# 00180177 Due on Dept/Loc: 610 Totals: 2,365.13 2,365.13 0.00 GRAND/GSD INTERSECTION ENHANCEMENT 00180178 001 301610-56105- GRAND/GSD INTERSECTION - CONTING 10,000.00 1,646.23 8,353.77 PO# 00180178 Due on Dept/Loc: 610 Totals: 10,000.00 1,646.23 8,353.77 GRAND/GSD INTERSECTION - CONTINGENCY Vendor # 010097 DAVID EVANS AND ASSO Totals: 12,365.13 4,011.36 8,353.77 **** 010108 DEPARTMENT OF TRANSP 00000071 001 100655-55536- TRAFFIC SIGNAL MAINTENANCE FOR 7 15,000.00 9,609.71 5,390.29 PO# 00000071 Due on 11/05/2020 Dept/Loc: 655 Totals: 15,000.00 9,609.71 5,390.29 CS-TRAFFIC SIGNAL MAINTENANCE 00200032 001 100655-55536- Dept 655 - CS - TRAFFIC SIGNAL M 14,961.29 14,961.29 0.00 PO# 00200032 Due on Dept/Loc: 655 Totals: 14,961.29 14,961.29 0.00 CS - TRAFFIC SIGNAL MAINT Vendor # 010108 DEPARTMENT OF TRANSP Totals: 29,961.29 24,571.00 5,390.29 **** 010114 DIANA CHO & ASSOCIAT 00000074 001 225440-54900- CDBG PROGRAM CONSULTANT 4,690.00 2,685.50 2,004.50 PO# 00000074 Due on Dept/Loc: 410 Totals: 4,690.00 2,685.50 2,004.50 CDBG PROGRAM CONSULTANT 00200117 001 225440-54900- Dept 440 - PS - OTHER PROF SVCS 929.00 929.00 0.00 00200117 002 301610-56101- Dept 610 - CIP-STREET IMPROVMENT 7,513.00 7,513.00 0.00 PO# 00200117 Due on Dept/Loc: 440 Totals: 8,442.00 8,442.00 0.00 PROF SERVICES Vendor # 010114 DIANA CHO & ASSOCIAT Totals: 13,132.00 11,127.50 2,004.50 **** 010116 DMPR 4 LLC 00000002 001 100130-52302- Unit # 376, 140, 092, 127, 371, 21,600.00 20,002.00 1,598.00 PO# 00000002 Due on 07/06/2020 Dept/Loc: 130 Totals: 21,600.00 20,002.00 1,598.00 Storage Rental Vendor # 010116 DMPR 4 LLC Totals: 21,600.00 20,002.00 1,598.00 **** 010117 DOGGIE WALK BAGS INC 00000003 001 250170-51200- FY 20/21: Doggie bags for dispen 14,191.20 14,191.20 0.00 PO# 00000003 Due on 07/17/2020 Dept/Loc: 630 Totals: 14,191.20 14,191.20 0.00 Doggie Bags City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 5 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00000004 001 250170-51200- FY 20-21: Doggie bags for dispe 16,819.20 15,440.36 1,378.84 PO# 00000004 Due on 07/17/2020 Dept/Loc: 630 Totals: 16,819.20 15,440.36 1,378.84 Doggie Bags Vendor # 010117 DOGGIE WALK BAGS INC Totals: 31,010.40 29,631.56 1,378.84 **** 010124 ECOFERT INC 00000032 001 100630-52320- FERTILIZER INJECTION SYSTEM - MO 13,800.00 11,500.00 2,300.00 PO# 00000032 Due on Dept/Loc: 630 Totals: 13,800.00 11,500.00 2,300.00 FERTILIZER INJECTION SYSTEM - MONTHLY SERVICE 00200112 001 100630-52320- Dept 630 - MAINT OF GROUNDS/BUIL 3,450.00 3,450.00 0.00 PO# 00200112 Due on Dept/Loc: 630 Totals: 3,450.00 3,450.00 0.00 MAINT OF GROUNDS/BUILDINGS Vendor # 010124 ECOFERT INC Totals: 17,250.00 14,950.00 2,300.00 **** 010127 EMERALD LANDSCAPE SE 00000008 001 100620-52320- LANDSCAPE MAINTENANCE SERVICES A 19,000.00 10,524.46 8,475.54 PO# 00000008 Due on 08/17/2020 Dept/Loc: 630 Totals: 19,000.00 10,524.46 8,475.54 LANDSCAPING SERVICES AT CITY HALL 00200011 001 100620-52320- DEPT 620 - MAINT OF GROUNDS/BUIL 5,360.46 5,360.46 0.00 PO# 00200011 Due on Dept/Loc: 620 Totals: 5,360.46 5,360.46 0.00 MAINT OF GROUNDS/BUILDINGS Vendor # 010127 EMERALD LANDSCAPE SE Totals: 24,360.46 15,884.92 8,475.54 **** 010130 PETER LEWANDOWKSI 00180239 001 100-22107- ENVIRONMENTAL PREPARATION 48,076.91 0.00 48,076.91 PO# 00180239 Due on Dept/Loc: 410 Totals: 48,076.91 0.00 48,076.91 ENVIRONMENTAL PREPARATION Vendor # 010130 PETER LEWANDOWKSI Totals: 48,076.91 0.00 48,076.91 **** 010131 ENVIRONMENTAL SCIENC 00200157 001 100-22107- EIR - TECHNICAL REPORTS/EVALUATI 147,560.00 101,302.20 46,257.80 PO# 00200157 Due on Dept/Loc: 410 Totals: 147,560.00 101,302.20 46,257.80 EIR - TECHNICAL REPORTS/EVALUATIONS Vendor # 010131 ENVIRONMENTAL SCIENC Totals: 147,560.00 101,302.20 46,257.80 **** 010134 EXTERIOR PRODUCTS CO City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 6 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00000034 001 100630-55505- PARKS AND FACILITIES 18,000.00 11,790.00 6,210.00 00000034 002 100630-56116- PARKS 15,000.00 12,240.23 2,759.77 00000034 003 100520-55300- RECREATION 19,500.00 4,814.65 14,685.35 00000034 004 100150-54900- ECONOMIC DEVELOPMENT - RESTAURAN 6,500.00 6,481.50 18.50 PO# 00000034 Due on Dept/Loc: 630 Totals: 59,000.00 35,326.38 23,673.62 BANNERS, AMERICAN FLAGS, HOLIDAY DECOR 00200025 001 100150-54900- Dept 150 - PS - OTHER PROF SVCS 143.50 143.50 0.00 00200025 002 100520-55520- Dept 520 - CS - TRAILS MAINTENAN 9,529.00 9,529.00 0.00 00200025 003 100520-55520- Dept 520 - CS - TRAILS MAINTENAN 3,832.50 3,832.50 0.00 00200025 004 100630-55520- Dept 630 - CS - TRAILS MAINTENAN 5,582.58 5,582.58 0.00 00200025 005 100630-56116- Dept 630 - EQUIPMENT 3,481.50 3,481.50 0.00 PO# 00200025 Due on Dept/Loc: 150 Totals: 22,569.08 22,569.08 0.00 PROFESSIONAL SERVICES Vendor # 010134 EXTERIOR PRODUCTS CO Totals: 81,569.08 57,895.46 23,673.62 **** 010137 FEHR & PEERS 00000061 001 100615-54410- CONTRACT ENGINEERING SERVICES- S 40,000.00 34,339.91 5,660.09 PO# 00000061 Due on 10/08/2020 Dept/Loc: 615 Totals: 40,000.00 34,339.91 5,660.09 PS - ENGINEERING Vendor # 010137 FEHR & PEERS Totals: 40,000.00 34,339.91 5,660.09 **** 010138 FIDUCIARY EXPERTS LL 00000072 001 100210-54010- 457 PLAN CONSULTING SERVICES 8,000.00 8,000.00 0.00 PO# 00000072 Due on Dept/Loc: 210 Totals: 8,000.00 8,000.00 0.00 457 PLAN CONSULTING SERVICES Vendor # 010138 FIDUCIARY EXPERTS LL Totals: 8,000.00 8,000.00 0.00 **** 010151 GATEWAY CORP CENTER 00000047 001 100620-52400- CAPITAL CONTRIBUTION AND ASSOCIA 21,065.00 20,721.62 343.38 PO# 00000047 Due on Dept/Loc: 130 Totals: 21,065.00 20,721.62 343.38 CAPITAL CONTRIBUTION AND ASSOCIATION DUES Vendor # 010151 GATEWAY CORP CENTER Totals: 21,065.00 20,721.62 343.38 **** 010164 GRAFFITI CONTROL SYS 00000040 001 100430-55540- GRAFFITI ABATEMENT 39,000.00 29,750.00 9,250.00 PO# 00000040 Due on Dept/Loc: 410 Totals: 39,000.00 29,750.00 9,250.00 GRAFFITI ABATEMENT Vendor # 010164 GRAFFITI CONTROL SYS Totals: 39,000.00 29,750.00 9,250.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 7 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 010168 GUARANTEED JANITORIA 00000023 001 100620-52320- JANITORIAL SERVICES AT CITY HALL 117,369.00 87,912.00 29,457.00 00000023 002 100510-55505- JANITORIAL SERVICES AT DIAMOND B 72,160.00 54,000.00 18,160.00 00000023 003 100630-55505- JANITORIAL SERVICES - PARKS 34,000.00 24,500.00 9,500.00 PO# 00000023 Due on Dept/Loc: 630 Totals: 223,529.00 166,412.00 57,117.00 JANITORIAL SERVICES 00200052 001 100620-52320- MAINT OF GROUNDS/BUILDINGS 23,438.48 23,438.48 0.00 00200052 002 100510-55520- CS - TRAILS MAINTENANCE 12,760.00 12,760.00 0.00 00200052 003 100630-55520- CS - TRAILS MAINTENANCE 6,147.00 6,147.00 0.00 PO# 00200052 Due on Dept/Loc: 510 Totals: 42,345.48 42,345.48 0.00 LANDSCAPE MAINTENANCE Vendor # 010168 GUARANTEED JANITORIA Totals: 265,874.48 208,757.48 57,117.00 **** 010172 HARBOR TRUCK BODIES 00200150 001 502990-56115- 2006 HARBOR TRUCK BODY FOR NEW F 9,989.04 9,989.04 0.00 PO# 00200150 Due on Dept/Loc: 610 Totals: 9,989.04 9,989.04 0.00 2006 HARBOR TRUCK BODY FOR NEW FORD F-450 Vendor # 010172 HARBOR TRUCK BODIES Totals: 9,989.04 9,989.04 0.00 **** 010173 HARDY & HARPER INC 00000033 001 100655-55512- ROAD MAINTENANCE 310,000.00 52,547.84 257,452.16 00000033 002 100655-55514- SIDEWALK INSPECTION AND REPAIR 130,000.00 0.00 130,000.00 00000033 003 100655-55516- SIGNING AND STRIPING 50,000.00 0.00 50,000.00 PO# 00000033 Due on Dept/Loc: 630 Totals: 490,000.00 52,547.84 437,452.16 ROAD MAINTENANCE SERVICES Vendor # 010173 HARDY & HARPER INC Totals: 490,000.00 52,547.84 437,452.16 **** 010178 HDL COMPANIES 00000075 001 100210-54010- SALES TAX CONSULTANT 15,000.00 5,562.81 9,437.19 PO# 00000075 Due on Dept/Loc: 210 Totals: 15,000.00 5,562.81 9,437.19 SALES TAX CONSULTANT Vendor # 010178 HDL COMPANIES Totals: 15,000.00 5,562.81 9,437.19 **** 010179 HDL COREN & CONE 00000078 001 100210-54010- PROFESSIONAL SERVICES - PROPERTY 14,500.00 13,691.85 808.15 PO# 00000078 Due on Dept/Loc: 210 Totals: 14,500.00 13,691.85 808.15 PROFESSIONAL SERVICES - PROPERTY TAX CONSULTANT City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 8 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open Vendor # 010179 HDL COREN & CONE Totals: 14,500.00 13,691.85 808.15 **** 010188 HR GREEN PACIFIC INC 00000080 001 100615-54400- On-Call Engineering - $5,000 5,000.00 0.00 5,000.00 00000080 002 100615-54420- PS Plan Check - $10,000 10,000.00 0.00 10,000.00 00000080 003 100615-54440- PS - Inspection - $4,000 4,000.00 0.00 4,000.00 PO# 00000080 Due on 11/01/2020 Dept/Loc: 610 Totals: 19,000.00 0.00 19,000.00 On-Call Engineering Services (HR Green) 00190137 001 100615-54420- ON-CALL ENGINEERING SERVICES 1,218.02 96.34 1,121.68 00190137 002 100615-54440- ON-CALL ENGINEERING SERVICES 2,350.23 1,061.52 1,288.71 PO# 00190137 Due on Dept/Loc: 615 Totals: 3,568.25 1,157.86 2,410.39 ON-CALL ENGINEERING SERVICES 00200094 001 100615-54420- ON-CALL ENGINEERING/STAFF AUGMEN 15,000.00 1,048.88 13,951.12 00200094 002 100615-54440- ON-CALL ENGINEERING/STAFF AUGMEN 5,000.00 0.00 5,000.00 PO# 00200094 Due on Dept/Loc: 615 Totals: 20,000.00 1,048.88 18,951.12 ON-CALL ENGINEERING/STAFF AUGMENTATION Vendor # 010188 HR GREEN PACIFIC INC Totals: 42,568.25 2,206.74 40,361.51 **** 010191 HUMANE SOCIETY OF PO 00000012 001 100340-55404- FY2020-21 ANIMAL CONTROL SERVICE 200,284.00 166,903.30 33,380.70 PO# 00000012 Due on Dept/Loc: 140 Totals: 200,284.00 166,903.30 33,380.70 FY 2020-21 ANIMAL CONTROL SERVICES Vendor # 010191 HUMANE SOCIETY OF PO Totals: 200,284.00 166,903.30 33,380.70 **** 010204 ITERIS INC 00000048 001 207650-54410- ON-CALL TRAFFIC ENGINEERING SERV 60,000.00 24,597.40 35,402.60 PO# 00000048 Due on Dept/Loc: 650 Totals: 60,000.00 24,597.40 35,402.60 CS - TRAFFIC - CITYWIDE SIGNAL TIMING (Iteris) Vendor # 010204 ITERIS INC Totals: 60,000.00 24,597.40 35,402.60 **** 010212 JOE A. GONSALVES & S 00000005 001 100130-54900- Profession Legislative Services 30,180.00 27,590.00 2,590.00 PO# 00000005 Due on 07/16/2020 Dept/Loc: 130 Totals: 30,180.00 27,590.00 2,590.00 Professional Legislative Representation Vendor # 010212 JOE A. GONSALVES & S Totals: 30,180.00 27,590.00 2,590.00 **** 010214 JOHN L HUNTER & ASSO 00000045 001 100610-54200- Y Annual NPDES stormwater complian 11,292.00 4,120.12 7,171.88 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 9 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00000045 001 201610-54200- Y Annual NPDES stormwater complian 45,168.00 16,480.47 28,687.53 PO# 00000045 Due on 09/26/2020 Dept/Loc: 610 Totals: 56,460.00 20,600.59 35,859.41 NPDES Stormwater Compliance (John Hunter) Vendor # 010214 JOHN L HUNTER & ASSO Totals: 56,460.00 20,600.59 35,859.41 **** 010221 KEVIN D JONES 00000015 001 100615-54400- CONTRACT SERVICES - SR-57/60 CON 50,500.00 36,000.00 14,500.00 PO# 00000015 Due on 08/20/2020 Dept/Loc: 615 Totals: 50,500.00 36,000.00 14,500.00 CONTRACT SERVICES Vendor # 010221 KEVIN D JONES Totals: 50,500.00 36,000.00 14,500.00 **** 010224 KIMLEY HORN AND ASSO 00000018 001 100615-54410- ON-CALL TRAFFIC CONSULTANT 13,000.00 4,856.15 8,143.85 PO# 00000018 Due on 08/28/2020 Dept/Loc: 615 Totals: 13,000.00 4,856.15 8,143.85 ON-CALL TRAFFIC CONSULTANT Vendor # 010224 KIMLEY HORN AND ASSO Totals: 13,000.00 4,856.15 8,143.85 **** 010228 KOA CORPORATION 00000077 001 255615-54400- LOCAL ROADWAY SAFETY PLAN (LSRP) 71,883.00 38,952.12 32,930.88 00000077 002 100615-54410- LOCAL ROADWAY SAFETY PLAN (LRSP) 7,987.00 4,328.01 3,658.99 PO# 00000077 Due on Dept/Loc: 615 Totals: 79,870.00 43,280.13 36,589.87 PS-ENGINEERING/PS-TRAFFIC Vendor # 010228 KOA CORPORATION Totals: 79,870.00 43,280.13 36,589.87 **** 010236 LANCE, SOLL & LUNGHA 00000081 001 100210-54010- AUDIT SERVICES 35,100.00 23,560.00 11,540.00 PO# 00000081 Due on Dept/Loc: 210 Totals: 35,100.00 23,560.00 11,540.00 Audit Services Vendor # 010236 LANCE, SOLL & LUNGHA Totals: 35,100.00 23,560.00 11,540.00 **** 010253 LOS ANGELES COUNTY P 00000050 001 100630-52320- F/Y 20-21 - SUMP PUMP MAINTENANC 20,000.00 15,835.50 4,164.50 PO# 00000050 Due on 09/29/2020 Dept/Loc: 630 Totals: 20,000.00 15,835.50 4,164.50 SUMP PUMP MAINTENANCE @ SYCAMORE CANYON PARK 00000051 001 100610-55550- LA COUNTY PUBLIC WORKS INDUSTRIA 30,000.00 27,184.43 2,815.57 PO# 00000051 Due on 09/28/2020 Dept/Loc: 610 Totals: 30,000.00 27,184.43 2,815.57 LA County Industrial Waste Services City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 10 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00200010 001 100630-52320- Dept 630 - MAINT OF GROUNDS/BUIL 1,824.23 1,824.23 0.00 PO# 00200010 Due on Dept/Loc: 630 Totals: 1,824.23 1,824.23 0.00 MAINT OF GROUNDS/BUILDINGS Vendor # 010253 LOS ANGELES COUNTY P Totals: 51,824.23 44,844.16 6,980.07 **** 010254 LOS ANGELES COUNTY S 00000049 001 100310-55400- Y FY2020-21 SHERIFF LAW ENFORCEMEN 7,344,554.00 7,344,554.00 0.00 00000049 001 100310-55402- Y FY2020-21 SHERIFF LAW ENFORCEMEN 203,990.00 203,990.00 0.00 00000049 001 100520-55402- Y FY2020-21 SHERIFF LAW ENFORCEMEN 25,000.00 25,000.00 0.00 PO# 00000049 Due on 10/01/2020 Dept/Loc: 130 Totals: 7,573,544.00 7,573,544.00 0.00 FY2020-21 LASD SHERIFF SERVICES 00000064 001 100310-55400- LAW ENFORCEMENT GENERAL SERVICES 7,344,554.00 5,301,261.36 2,043,292.64 00000064 002 100310-55402- LAW ENFORCEMENT SPECIAL SERVICES 203,990.00 2,158.29 201,831.71 00000064 003 100520-55402- LAW ENFORCEMENT - PARKS/RECREATI 25,000.00 0.00 25,000.00 PO# 00000064 Due on Dept/Loc: 130 Totals: 7,573,544.00 5,303,419.65 2,270,124.35 FY2020-21 SHERIFF'S LAW ENFORCEMENT SERVICES Vendor # 010254 LOS ANGELES COUNTY S Totals: 15,147,088.00 12,876,963.65 2,270,124.35 **** 010270 MCE CORPORATION 00000011 001 238638-55524- LANDSCAPE MAINTENANCE - DISTRICT 177,676.00 148,063.00 29,613.00 00000011 002 239639-55524- LANDSCAPE MAINTENANCE - DISTRICT 146,083.00 121,735.40 24,347.60 00000011 003 241641-55524- LANDSCAPE MAINTENANCE - DISTRICT 59,073.00 49,226.10 9,846.90 00000011 004 238638-52320- "AS-NEEDED" LANDSCAPE MAINTENANC 12,500.00 841.25 11,658.75 00000011 005 239639-52320- "AS-NEEDED" LANDSCAPE MAINTENANC 12,500.00 0.00 12,500.00 00000011 006 241641-52320- "AS-NEEDED" LANDSCAPE MAINTENANC 4,997.40 0.00 4,997.40 PO# 00000011 Due on 08/17/2020 Dept/Loc: 630 Totals: 412,829.40 319,865.75 92,963.65 LANDSCAPE MAINTENANCE - DISTRICTS 38, 39, 41 00000042 001 100655-55528- PARKWAY & VEGETATION MAINTENANCE 130,000.00 95,779.00 34,221.00 00000042 002 100655-55532- STORM DRAIN MAINTENANCE 10,000.00 5,536.45 4,463.55 00000042 003 100655-55530- RIGHT-OF-WAY MAINTENANCE 20,952.94 14,541.71 6,411.23 PO# 00000042 Due on Dept/Loc: 630 Totals: 160,952.94 115,857.16 45,095.78 STREET MAINTENANCE & VEGETATION CONTROL Vendor # 010270 MCE CORPORATION Totals: 573,782.34 435,722.91 138,059.43 **** 010274 MICHAEL BALLIET CONS 00000062 001 250170-54900- ENVIRONMENTAL CONSULTING SERVICE 30,475.00 13,462.50 17,012.50 PO# 00000062 Due on Dept/Loc: 130 Totals: 30,475.00 13,462.50 17,012.50 ENVIRONMENTAL CONSULTING SERVICES 00200038 001 250170-54900- PS - OTHER PROF SVCS 5,064.38 5,064.38 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 11 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open PO# 00200038 Due on Dept/Loc: 170 Totals: 5,064.38 5,064.38 0.00 PS - OTHER PROF SVCS Vendor # 010274 MICHAEL BALLIET CONS Totals: 35,539.38 18,526.88 17,012.50 **** 010278 MITY LITE INC 00200153 001 106350-52310- EQUIPMENT MAINTENANCE 2,844.14 2,844.14 0.00 PO# 00200153 Due on Dept/Loc: 350 Totals: 2,844.14 2,844.14 0.00 EQUIPMENT MAINTENANCE 20015301 001 106510-51200- COUNTERTOP SHIELDS 4,000.00 0.00 4,000.00 PO# 20015301 Due on Dept/Loc: 610 Totals: 4,000.00 0.00 4,000.00 COUNTERTOP SHIELDS Vendor # 010278 MITY LITE INC Totals: 6,844.14 2,844.14 4,000.00 **** 010290 NETWORK PARATRANSIT 00000037 001 206650-55560- SENIOR/DISABLED TRANSPORTATION S 350,000.00 90,366.34 259,633.66 PO# 00000037 Due on 09/10/2020 Dept/Loc: 130 Totals: 350,000.00 90,366.34 259,633.66 DIAMOND RIDE SERVICES FY2020-21 Vendor # 010290 NETWORK PARATRANSIT Totals: 350,000.00 90,366.34 259,633.66 **** 010292 NEXTECH SYSTEMS INC 00000083 001 100655-55536- TRAFFIC SIGNAL MAINTENANCE - BAT 15,000.00 1,324.19 13,675.81 PO# 00000083 Due on Dept/Loc: 655 Totals: 15,000.00 1,324.19 13,675.81 TRAFFIC SIGNAL MAINTENANCE Vendor # 010292 NEXTECH SYSTEMS INC Totals: 15,000.00 1,324.19 13,675.81 **** 010300 OFFICE SOLUTIONS 00000016 001 100130-51200- CITY MANAGER OFFICE SUPPLIES ($2 15,000.00 3,193.90 11,806.10 PO# 00000016 Due on Dept/Loc: 140 Totals: 15,000.00 3,193.90 11,806.10 OFFICE SUPPLIES Vendor # 010300 OFFICE SOLUTIONS Totals: 15,000.00 3,193.90 11,806.10 **** 010305 OROLIA USA INC 00200144 001 503230-56130- COMPUTER EQ - HARDWARE EXP 6,937.68 6,937.68 0.00 PO# 00200144 Due on Dept/Loc: 230 Totals: 6,937.68 6,937.68 0.00 COMPUTER EQ - HARDWARE EXP City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 12 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open Vendor # 010305 OROLIA USA INC Totals: 6,937.68 6,937.68 0.00 **** 010306 OTIS ELEVATOR COMPAN 00000024 001 100510-52320- DIAMOND BAR CENTER - SERVICE, ST 3,000.00 752.28 2,247.72 00000024 002 100620-52320- CITY HALL - SERVICE, STATE TESTI 10,000.00 5,520.60 4,479.40 PO# 00000024 Due on Dept/Loc: 630 Totals: 13,000.00 6,272.88 6,727.12 ELEVATOR & WHEELCHAIR LIFT SERVICES Vendor # 010306 OTIS ELEVATOR COMPAN Totals: 13,000.00 6,272.88 6,727.12 **** 010323 PUBLIC STORAGE #2305 00000001 001 100130-52302- Storage Unit # 2108 5,600.00 5,126.00 474.00 PO# 00000001 Due on 07/06/2020 Dept/Loc: 130 Totals: 5,600.00 5,126.00 474.00 Storage Rental Vendor # 010323 PUBLIC STORAGE #2305 Totals: 5,600.00 5,126.00 474.00 **** 010330 RAYCOM DATA TECHNOLO 00000065 001 100130-54900- Scanning Services 30,000.00 7,227.51 22,772.49 PO# 00000065 Due on Dept/Loc: 130 Totals: 30,000.00 7,227.51 22,772.49 Scanning Services Vendor # 010330 RAYCOM DATA TECHNOLO Totals: 30,000.00 7,227.51 22,772.49 **** 010332 REGIONAL CHAMBER OF 00000087 001 100150-55000- FY2020-21 Regional Chamber of Co 12,000.00 10,000.00 2,000.00 PO# 00000087 Due on Dept/Loc: 150 Totals: 12,000.00 10,000.00 2,000.00 FY2020-21 Chamber of Commerce Contract Vendor # 010332 REGIONAL CHAMBER OF Totals: 12,000.00 10,000.00 2,000.00 **** 010337 RICHARD FISHER ASSOC 00200049 001 301630-56104- CANYON LOOP TRAIL DESIGN 24,063.92 0.00 24,063.92 PO# 00200049 Due on Dept/Loc: 630 Totals: 24,063.92 0.00 24,063.92 CANYON LOOP TRAIL - DESIGN Vendor # 010337 RICHARD FISHER ASSOC Totals: 24,063.92 0.00 24,063.92 **** 010341 RKA CONSULTING GROUP 00000067 001 100420-55100- BUILDING AND SAFETY SERVICES 536,070.00 449,642.60 86,427.40 PO# 00000067 Due on 10/22/2020 Dept/Loc: 410 Totals: 536,070.00 449,642.60 86,427.40 BUILDING AND SAFETY SERVICES City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 13 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00200088 001 100420-55100- Dept 420 - CS - BUILDING & SAFET 344,969.06 344,969.06 0.00 PO# 00200088 Due on Dept/Loc: 420 Totals: 344,969.06 344,969.06 0.00 CS - BUILDING & SAFETY 00200089 001 301610-56101- AREA 1 & 2 DESIGN 68,438.75 17,133.75 51,305.00 00200089 002 100615-54400- AREA 1 & 2 DESIGN 6,286.25 0.00 6,286.25 PO# 00200089 Due on Dept/Loc: 610 Totals: 74,725.00 17,133.75 57,591.25 AREA 1 & 2 - DESIGN Vendor # 010341 RKA CONSULTING GROUP Totals: 955,764.06 811,745.41 144,018.65 **** 010345 RTS FINANCIAL SERVIC 00000060 001 100310-55412- CROSSING GUARD SERVICES FOR FY 2 138,000.00 0.00 138,000.00 PO# 00000060 Due on 10/08/2020 Dept/Loc: 310 Totals: 138,000.00 0.00 138,000.00 CROSSING GUARD SERVICES FY 20/21 Vendor # 010345 RTS FINANCIAL SERVIC Totals: 138,000.00 0.00 138,000.00 **** 010355 SCHAFER CONSULTING 00190192 001 503230-56135- CONSULTING SERVICES FOR ERP IMPL 96,910.00 76,583.75 20,326.25 PO# 00190192 Due on Dept/Loc: 230 Totals: 96,910.00 76,583.75 20,326.25 CONSULTING SERVICES FOR ERP PROJECT Vendor # 010355 SCHAFER CONSULTING Totals: 96,910.00 76,583.75 20,326.25 **** 010356 SCI CONSULTING GROUP 00000084 001 238638-54900- Y PROFESSIONAL SERVICES - LLAD #38 5,640.00 5,386.56 253.44 00000084 001 239639-54900- Y PROFESSIONAL SERVICES - LLAD #38 5,640.00 5,386.56 253.44 00000084 001 241641-54900- Y PROFESSIONAL SERVICES - LLAD #38 5,640.00 5,386.56 253.44 PO# 00000084 Due on Dept/Loc: 610 Totals: 16,920.00 16,159.68 760.32 PROFESSIONAL SERVICES Vendor # 010356 SCI CONSULTING GROUP Totals: 16,920.00 16,159.68 760.32 **** 010362 SHEPPARD, MULLIN, RI 00180203 001 100120-54022- PROFESSIONAL SERVICES - TRES HER 48,076.91 18,302.82 29,774.09 PO# 00180203 Due on Dept/Loc: 210 Totals: 48,076.91 18,302.82 29,774.09 PROFESSIONAL SERVICES - TRES HERMANOS Vendor # 010362 SHEPPARD, MULLIN, RI Totals: 48,076.91 18,302.82 29,774.09 **** 010365 SIEMENS INDUSTRY INC 00000020 001 207650-55536- TRAFFIC SIGNAL MAINTENANCE SERVI 220,000.00 220,000.00 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 14 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open PO# 00000020 Due on 08/25/2020 Dept/Loc: 615 Totals: 220,000.00 220,000.00 0.00 TRAFFIC SIGNAL MAINTENANCE SERVICES 00000066 001 207650-55536- TRAFFIC SIGNAL MAINTENANCE - FY 220,000.00 115,367.82 104,632.18 PO# 00000066 Due on 10/16/2020 Dept/Loc: 650 Totals: 220,000.00 115,367.82 104,632.18 TRAFFIC SIGNAL MAINTENANCE 00190147 001 301610-56102- Dept 610 - CIP-TRAFFIC CONTROL I 326,053.25 326,053.25 0.00 PO# 00190147 Due on Dept/Loc: 610 Totals: 326,053.25 326,053.25 0.00 CIP-TRAFFIC CONTROL IMPRV 00200036 001 100655-55536- Dept 655 - CS - TRAFFIC SIGNAL M 40,000.00 40,000.00 0.00 00200036 002 207650-55536- Dept 650 - CS - TRAFFIC SIGNAL M 13,391.57 13,391.57 0.00 PO# 00200036 Due on Dept/Loc: 655 Totals: 53,391.57 53,391.57 0.00 CS - TRAFFIC SIGNAL MAINT Vendor # 010365 SIEMENS INDUSTRY INC Totals: 819,444.82 714,812.64 104,632.18 **** 010366 SIEMENS MOBILITY INC 00000038 001 301610-56102- Battery Back-Up System - Final 1 96,553.00 91,725.35 4,827.65 PO# 00000038 Due on 10/11/2020 Dept/Loc: 610 Totals: 96,553.00 91,725.35 4,827.65 Battery Backup CIP Project (Siemens) Vendor # 010366 SIEMENS MOBILITY INC Totals: 96,553.00 91,725.35 4,827.65 **** 010368 SIMPSON ADVERTISING 00000036 001 100240-54900- Y GRAPHIC DESIGN SERVICES 51,050.00 51,050.00 0.00 00000036 001 100510-52160- Y GRAPHIC DESIGN SERVICES 5,000.00 5,000.00 0.00 00000036 001 100510-54900- Y GRAPHIC DESIGN SERVICES 5,000.00 5,000.00 0.00 PO# 00000036 Due on Dept/Loc: 240 Totals: 61,050.00 61,050.00 0.00 GRAPHIC DESIGN SERVICES 00000043 001 100240-54900- Y GRAPHIC DESIGN SERVICES 51,050.00 51,050.00 0.00 00000043 001 100510-52160- Y GRAPHIC DESIGN SERVICES 5,000.00 5,000.00 0.00 00000043 001 100510-54900- Y GRAPHIC DESIGN SERVICES 5,000.00 5,000.00 0.00 PO# 00000043 Due on Dept/Loc: 240 Totals: 61,050.00 61,050.00 0.00 DESIGN SERVICES 00000056 001 100240-54900- SPECIALTY GRAPHIC DESIGN SERVICE 51,050.00 33,411.40 17,638.60 00000056 002 100510-54900- GRAPHIC DESIGN SERVICES RECREATI 5,000.00 325.00 4,675.00 00000056 003 100510-52160- GRAPHIC DESIGN SERVICES DBC ADS 5,000.00 920.00 4,080.00 PO# 00000056 Due on Dept/Loc: 240 Totals: 61,050.00 34,656.40 26,393.60 GRAPHIC DESIGN SERVICES Vendor # 010368 SIMPSON ADVERTISING Totals: 183,150.00 156,756.40 26,393.60 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 15 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 010375 SO COAST AIR QUALITY 00000017 001 100130-52302- FACILITIES LEASE FROM JULY 2020 29,607.00 0.00 29,607.00 PO# 00000017 Due on Dept/Loc: 130 Totals: 29,607.00 0.00 29,607.00 FACILITY LEASE Vendor # 010375 SO COAST AIR QUALITY Totals: 29,607.00 0.00 29,607.00 **** 010376 SOCIAL VOCATIONAL SE 00000014 001 100645-55528- LANDSCAPE MAINTENANCE - WEED ABA 34,404.00 22,768.00 11,636.00 PO# 00000014 Due on Dept/Loc: 630 Totals: 34,404.00 22,768.00 11,636.00 WEED ABATEMENT Vendor # 010376 SOCIAL VOCATIONAL SE Totals: 34,404.00 22,768.00 11,636.00 **** 010382 SPECTRUM BUSINESS 00200023 001 100230-54030- Dept 230 - PS - DATA PROCESSING 6,411.24 6,411.24 0.00 PO# 00200023 Due on Dept/Loc: 230 Totals: 6,411.24 6,411.24 0.00 PS - DATA PROCESSING SERVICES Vendor # 010382 SPECTRUM BUSINESS Totals: 6,411.24 6,411.24 0.00 **** 010385 STANTEC CONSULTING S 00000019 001 100615-54410- ON-CALL TRAFFIC CONSULTANT 13,000.00 0.00 13,000.00 PO# 00000019 Due on 08/28/2020 Dept/Loc: 615 Totals: 13,000.00 0.00 13,000.00 ON-CALL TRAFFIC CONSULTANT Vendor # 010385 STANTEC CONSULTING S Totals: 13,000.00 0.00 13,000.00 **** 010386 STATEWIDE TRAFFIC SA 00000086 001 502990-56116- Vehicle work/safety lighting 15,000.00 0.00 15,000.00 PO# 00000086 Due on 03/24/2021 Dept/Loc: 630 Totals: 15,000.00 0.00 15,000.00 Vehicle work/safety lighting Vendor # 010386 STATEWIDE TRAFFIC SA Totals: 15,000.00 0.00 15,000.00 **** 010390 STUMP FENCE CO 00200148 001 100630-52320- MAINT OF GROUNDS/BUILDINGS 3,850.00 3,850.00 0.00 PO# 00200148 Due on Dept/Loc: 630 Totals: 3,850.00 3,850.00 0.00 MAINT OF GROUNDS/BUILDINGS Vendor # 010390 STUMP FENCE CO Totals: 3,850.00 3,850.00 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 16 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 010397 TAIT AND ASSOCIATES 00000052 001 100615-54400- On-Call Landscape Architecture 7,000.00 0.00 7,000.00 PO# 00000052 Due on 11/02/2020 Dept/Loc: 610 Totals: 7,000.00 0.00 7,000.00 On-Call Landscape Architecture Services (Tait) Vendor # 010397 TAIT AND ASSOCIATES Totals: 7,000.00 0.00 7,000.00 **** 010402 TENNIS ANYONE INC 00000029 001 100520-55320- Tennis Instruction 70,000.00 70,000.00 0.00 PO# 00000029 Due on 08/31/2020 Dept/Loc: 520 Totals: 70,000.00 70,000.00 0.00 Tennis Instruction 00000090 001 100520-55320- Tennis Instruction 31,315.89 8,728.52 22,587.37 PO# 00000090 Due on 03/23/2021 Dept/Loc: 520 Totals: 31,315.89 8,728.52 22,587.37 Tennis Instruction Vendor # 010402 TENNIS ANYONE INC Totals: 101,315.89 78,728.52 22,587.37 **** 010403 THE COMDYN GROUP INC 00000031 001 100230-54900- CONSULTING SERVICES FOR AS-NEEDE 40,000.00 29,150.81 10,849.19 PO# 00000031 Due on 09/04/2020 Dept/Loc: 230 Totals: 40,000.00 29,150.81 10,849.19 PROFESSIONAL SERVICES Vendor # 010403 THE COMDYN GROUP INC Totals: 40,000.00 29,150.81 10,849.19 **** 010410 THE SAUCE CREATIVE S 00000055 001 100520-52110- Print and design services. 10,400.00 5,537.21 4,862.79 00000055 002 100520-55300- Print and design services. 2,100.00 1,902.03 197.97 PO# 00000055 Due on 10/28/2020 Dept/Loc: 520 Totals: 12,500.00 7,439.24 5,060.76 Print and design services. Vendor # 010410 THE SAUCE CREATIVE S Totals: 12,500.00 7,439.24 5,060.76 **** 010413 THE TAIT GROUP INC 00000035 001 100615-54410- CONTRACT SERVICES - TRAFFIC RELA 45,000.00 39,800.00 5,200.00 PO# 00000035 Due on 09/04/2020 Dept/Loc: 615 Totals: 45,000.00 39,800.00 5,200.00 CS-ENGINEERING Vendor # 010413 THE TAIT GROUP INC Totals: 45,000.00 39,800.00 5,200.00 **** 010418 TRANE SERVICE GROUP 00000022 001 100630-52320- PARKS 10,000.00 9,265.78 734.22 00000022 002 100510-52320- DIAMOND BAR CENTER 27,500.00 18,206.69 9,293.31 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 17 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00000022 003 100620-52320- CITY HALL 27,500.00 19,732.54 7,767.46 PO# 00000022 Due on Dept/Loc: 630 Totals: 65,000.00 47,205.01 17,794.99 HVAC MAINTENANCE 00000096 001 504620-56100- City Hall Indoor Air Quality Pro 44,908.00 0.00 44,908.00 PO# 00000096 Due on 05/13/2021 Dept/Loc: 630 Totals: 44,908.00 0.00 44,908.00 City Hall Indoor Air Quality Project Vendor # 010418 TRANE SERVICE GROUP Totals: 109,908.00 47,205.01 62,702.99 **** 010420 TREMCO 00000025 001 100620-52320- ROOF MANAGEMENT - CITY HALL 7,285.00 4,357.66 2,927.34 00000025 002 100510-52320- ROOF MANAGEMENT - DIAMOND BAR CE 5,500.00 3,890.86 1,609.14 00000025 003 100630-55505- ROOF MANAGEMENT - PARKS & FACILI 5,350.00 2,522.05 2,827.95 PO# 00000025 Due on Dept/Loc: 630 Totals: 18,135.00 10,770.57 7,364.43 COMPREHENSIVE ROOF MANAGEMENT Vendor # 010420 TREMCO Totals: 18,135.00 10,770.57 7,364.43 **** 010427 TYLER TECHNOLOGIES I 00190182 001 503230-56135- IMPLEMENTATION OF FINANCE ERP SY 408,157.82 175,084.00 233,073.82 PO# 00190182 Due on Dept/Loc: 230 Totals: 408,157.82 175,084.00 233,073.82 IMPLEMENTATION OF FINANCE ERP SYSTEM Vendor # 010427 TYLER TECHNOLOGIES I Totals: 408,157.82 175,084.00 233,073.82 **** 010429 URBAN LAND INSTITUTE 00000079 001 100150-54900- TECHNICAL ASSISTANCE FOR ECONOMI 30,000.00 25,000.00 5,000.00 PO# 00000079 Due on Dept/Loc: 130 Totals: 30,000.00 25,000.00 5,000.00 TECHNICAL ASSISTANCE PANEL-DIAMOND BAR TOWN CTR Vendor # 010429 URBAN LAND INSTITUTE Totals: 30,000.00 25,000.00 5,000.00 **** 010432 UNITED RECORDS MANAG 00000021 001 100230-55000- CONTRACT SERVICES - OFF-SITE STO 8,000.00 4,326.02 3,673.98 PO# 00000021 Due on 08/28/2020 Dept/Loc: 230 Totals: 8,000.00 4,326.02 3,673.98 OFF-SITE STORAGE OF BACK-UP TAPES Vendor # 010432 UNITED RECORDS MANAG Totals: 8,000.00 4,326.02 3,673.98 **** 010449 WAXIE SANITARY SUPPL 00000006 001 100620-51200- Y FY 20-21: Janitorial Supplies f 0.00 0.00 0.00 00000006 001 100510-51200- Y FY 20-21: Janitorial Supplies f 0.00 0.00 0.00 00000006 001 100510-52320- Y FY 20-21: Janitorial Supplies f 0.00 0.00 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 18 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open 00000006 001 100510-51210- Y FY 20-21: Janitorial Supplies f 20,000.00 482.01 19,517.99 00000006 002 100510-52320- FY 20-21: Building Maintenance 5,000.00 0.00 5,000.00 00000006 003 100620-51200- FY 20-21: Janitorial Supplies f 30,000.00 10,815.99 19,184.01 00000006 004 100630-51200- FY 20-21: Janitorial Supplies f 10,000.00 0.00 10,000.00 PO# 00000006 Due on 07/31/2020 Dept/Loc: 630 Totals: 65,000.00 11,298.00 53,702.00 Janitorial Supplies Vendor # 010449 WAXIE SANITARY SUPPL Totals: 65,000.00 11,298.00 53,702.00 **** 010451 WEST COAST ARBORISTS 00000009 001 100645-55522- CITYWIDE TREE MAINTENANCE SERVIC 275,463.00 173,131.50 102,331.50 00000009 002 238638-55522- TREE MAINTENANCE - DISTRICT #38 62,350.00 35,396.00 26,954.00 00000009 003 239639-55522- TREE MAINTENANCE DISTRICT #39 6,500.00 5,665.00 835.00 00000009 004 241641-55522- TREE MAINTENANCE DISTRICT #41 6,500.00 6,348.00 152.00 PO# 00000009 Due on 08/17/2020 Dept/Loc: 630 Totals: 350,813.00 220,540.50 130,272.50 CITYWIDE TREE CARE AND MAINTENANCE 00200015 001 100645-55522- Dept 645 - TREE MAINTENANCE 150,454.00 150,454.00 0.00 00200015 002 100645-55522- Dept 645 - TREE MAINTENANCE 7,204.00 7,204.00 0.00 00200015 003 238638-55522- Dept 638 - TREE MAINTENANCE 6,500.00 6,500.00 0.00 00200015 004 241641-55522- Dept 639 - TREE MAINTENANCE 3,469.00 3,469.00 0.00 00200015 005 239639-55522- Dept 639 - CS - TREE MAINTENANCE 6,500.00 6,500.00 0.00 PO# 00200015 Due on Dept/Loc: 645 Totals: 174,127.00 174,127.00 0.00 CS - TREE MAINTENANCE Vendor # 010451 WEST COAST ARBORISTS Totals: 524,940.00 394,667.50 130,272.50 **** 010454 WILLDAN GEOTECHNICAL 00000063 001 100615-54430- On-call geotechnical engineering 8,000.00 0.00 8,000.00 PO# 00000063 Due on 11/15/2020 Dept/Loc: 610 Totals: 8,000.00 0.00 8,000.00 On-Call Geotechnical Services (Willdan) Vendor # 010454 WILLDAN GEOTECHNICAL Totals: 8,000.00 0.00 8,000.00 **** 011001 BONTERRA PSOMAS 00070257 001 100-22107- PLANNING DEPOSIT 147,745.61 0.00 147,745.61 PO# 00070257 Due on Dept/Loc: 210 Totals: 147,745.61 0.00 147,745.61 PLANNING DEPOSIT 00070416 001 100-22107- MITIGATION MONITORING 144,916.90 4,402.37 140,514.53 PO# 00070416 Due on Dept/Loc: 410 Totals: 144,916.90 4,402.37 140,514.53 MITIGATION MONITORING Vendor # 011001 BONTERRA PSOMAS Totals: 292,662.51 4,402.37 288,260.14 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 19 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 011002 MNS ENGINEERS INC 00000058 001 100615-54410- Grant writing services for the A 21,620.00 12,329.35 9,290.65 PO# 00000058 Due on 11/06/2020 Dept/Loc: 610 Totals: 21,620.00 12,329.35 9,290.65 ATP Grant Writing Services (MNS Engineers) Vendor # 011002 MNS ENGINEERS INC Totals: 21,620.00 12,329.35 9,290.65 **** 011003 DENNIS VLASICH 00190125 001 503230-56135- CONSULTING SERVICES - LAND MANAG 18,471.43 3,951.20 14,520.23 PO# 00190125 Due on Dept/Loc: 230 Totals: 18,471.43 3,951.20 14,520.23 CONSULTING SERVICES - LAND MANAGEMENT SYSTEM RFP Vendor # 011003 DENNIS VLASICH Totals: 18,471.43 3,951.20 14,520.23 **** 011005 SJC 3 CONSULTING INC 00000073 001 225440-54900- CDBG HOME IMPROVEMENT PROGRAM CO 20,143.00 9,040.00 11,103.00 PO# 00000073 Due on Dept/Loc: 410 Totals: 20,143.00 9,040.00 11,103.00 CDBG HOME IMPROVEMENT PROGRAM CONSULTANT Vendor # 011005 SJC 3 CONSULTING INC Totals: 20,143.00 9,040.00 11,103.00 **** 011006 MERCURY DISPOSAL 00200075 001 250170-54900- Dept 170 - PS - OTHER PROF SVCS 12,426.89 12,426.89 0.00 PO# 00200075 Due on Dept/Loc: 170 Totals: 12,426.89 12,426.89 0.00 PS - OTHER PROF SVCS Vendor # 011006 MERCURY DISPOSAL Totals: 12,426.89 12,426.89 0.00 **** 011008 TIMOTHY J PEREZ 00200141 001 100130-54900- DATABASE ADMINISTRATION 4,141.50 2,992.50 1,149.00 00200141 002 100410-54200- DATABASE ADMINISTRATION 3,000.00 0.00 3,000.00 PO# 00200141 Due on Dept/Loc: 230 Totals: 7,141.50 2,992.50 4,149.00 DATABASE ADMINISTRATION Vendor # 011008 TIMOTHY J PEREZ Totals: 7,141.50 2,992.50 4,149.00 **** 011009 JCL TRAFFIC SERVICES 00200143 001 502655-56116- SPEED RADAR TRAILER 27,955.35 27,955.35 0.00 PO# 00200143 Due on Dept/Loc: 630 Totals: 27,955.35 27,955.35 0.00 SPEED RADAR TRAILER Vendor # 011009 JCL TRAFFIC SERVICES Totals: 27,955.35 27,955.35 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 20 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 011010 MICHAEL BAKER 00200159 001 301630-56104- CIP-PARK IMPROVEMENTS 90,536.00 90,536.00 0.00 PO# 00200159 Due on Dept/Loc: 630 Totals: 90,536.00 90,536.00 0.00 CIP-PARK IMPROVEMENTS 20015901 001 301630-56104- CANYON LOOP TRAIL CEQA 49,952.50 42,927.25 7,025.25 20015901 001 301630-56104- CANYON LOOP TRAIL CEQA 49,952.50 42,927.25 7,025.25 PO# 20015901 Due on Dept/Loc: 520 Totals: 99,905.00 85,854.50 14,050.50 CANYON LOOP TRAIL CEQA Vendor # 011010 MICHAEL BAKER Totals: 190,441.00 176,390.50 14,050.50 **** 011011 METROPOINTE ENGINEER 00200160 001 100615-54410- ENGINEERING DESIGN SERVICES 79,900.00 0.00 79,900.00 PO# 00200160 Due on Dept/Loc: 615 Totals: 79,900.00 0.00 79,900.00 ENGINEERING DESIGN SERVICES Vendor # 011011 METROPOINTE ENGINEER Totals: 79,900.00 0.00 79,900.00 **** 011012 CONTRUCTION HARDWARE 00200151 001 100620-52320- CONSTRUCTION CITY CLERK'S OFFICE 3,281.71 0.00 3,281.71 PO# 00200151 Due on Dept/Loc: 610 Totals: 3,281.71 0.00 3,281.71 CONSTRUCTION FOR CITY CLERK OFFICE Vendor # 011012 CONTRUCTION HARDWARE Totals: 3,281.71 0.00 3,281.71 **** 011013 GENTRY BROTHERS INC 00200155 001 301610-56101- Dept 610 - CIP-STREET IMPROVMENT 129,820.00 129,820.00 0.00 PO# 00200155 Due on Dept/Loc: 610 Totals: 129,820.00 129,820.00 0.00 CIP-STREET IMPROVMENTS Vendor # 011013 GENTRY BROTHERS INC Totals: 129,820.00 129,820.00 0.00 **** 011018 VALLEY VISTA SERVICE 00000041 001 100655-55510- STREET SWEEPING SERVICES 202,296.10 147,177.90 55,118.20 PO# 00000041 Due on Dept/Loc: 630 Totals: 202,296.10 147,177.90 55,118.20 STREET SWEEPING SERVICES Vendor # 011018 VALLEY VISTA SERVICE Totals: 202,296.10 147,177.90 55,118.20 **** 011019 MUSCO SPORTS LIGHTIN 00000094 001 100630-52320- PANTERA PARK OUTAGE REPLACEMENT 14,700.00 0.00 14,700.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 21 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open PO# 00000094 Due on Dept/Loc: 630 Totals: 14,700.00 0.00 14,700.00 PANTERA PARK MAINTENANCE Vendor # 011019 MUSCO SPORTS LIGHTIN Totals: 14,700.00 0.00 14,700.00 **** 011020 RANCE THRALL B & T 00000013 001 241641-55526- GOAT WEED ABATEMENT SERVICES IN 19,964.02 0.00 19,964.02 PO# 00000013 Due on Dept/Loc: 630 Totals: 19,964.02 0.00 19,964.02 WEED ABATEMENT - DISTRICT 41 00200019 001 241641-55526- WEED ABATEMENT 19,540.00 19,540.00 0.00 PO# 00200019 Due on Dept/Loc: 641 Totals: 19,540.00 19,540.00 0.00 WEED ABATEMENT Vendor # 011020 RANCE THRALL B & T Totals: 39,504.02 19,540.00 19,964.02 **** 011021 OUTDOOR CREATIONS 00200142 001 100630-56116- FF 19/20 NEW PRECAST CONCRETE SI 1,690.15 1,500.15 190.00 PO# 00200142 Due on Dept/Loc: 630 Totals: 1,690.15 1,500.15 190.00 C/O NEW PRECAST CONCRETE SITE Vendor # 011021 OUTDOOR CREATIONS Totals: 1,690.15 1,500.15 190.00 **** 011022 WARREN ANDERSON FORD 00200149 001 502990-56115- TWO NEW WORK TRUCKS 85,888.62 85,888.62 0.00 PO# 00200149 Due on Dept/Loc: 610 Totals: 85,888.62 85,888.62 0.00 TWO NEW WORK TRUCKS Vendor # 011022 WARREN ANDERSON FORD Totals: 85,888.62 85,888.62 0.00 **** 011024 HUSHMAND ASSOCIATES 00000044 001 301630-56104- DIAMOND BAR CENTER SLOPE STABILI 73,500.00 42,039.75 31,460.25 PO# 00000044 Due on 08/25/2020 Dept/Loc: 615 Totals: 73,500.00 42,039.75 31,460.25 Diamond Bar Center Slope Stabilization Design Svc Vendor # 011024 HUSHMAND ASSOCIATES Totals: 73,500.00 42,039.75 31,460.25 **** 011032 SHI INTERNATIONAL CO 00000007 001 100230-52314- 3-YEAR AGREEMENT FOR MICROSOFT E 12,413.72 12,413.72 0.00 PO# 00000007 Due on 07/22/2020 Dept/Loc: 230 Totals: 12,413.72 12,413.72 0.00 COMPUTER MAINTENANCE Vendor # 011032 SHI INTERNATIONAL CO Totals: 12,413.72 12,413.72 0.00 City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 22 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open **** 011063 JHD PLANNING LLC 00000069 001 103410-54300- HOUSING ELEMENT UPDATE FY 2021 - 75,364.00 27,000.00 48,364.00 PO# 00000069 Due on Dept/Loc: 410 Totals: 75,364.00 27,000.00 48,364.00 HOUSING ELEMENT UPDATE FY 2021 - 2029 Vendor # 011063 JHD PLANNING LLC Totals: 75,364.00 27,000.00 48,364.00 **** 011065 DISCOVERY SCIENCE CE 00000093 001 250170-54900- RECYCLING SCHOOL EDUCATION PROGR 15,000.00 0.00 15,000.00 PO# 00000093 Due on Dept/Loc: 130 Totals: 15,000.00 0.00 15,000.00 REECYCLING EDUCATION PROGRAM Vendor # 011065 DISCOVERY SCIENCE CE Totals: 15,000.00 0.00 15,000.00 **** 011076 SEHI COMPUTERS PRODU 00000057 001 251160-56130- HP LAPTOP COMPUTERS, ACCESSORIES 20,289.28 20,289.28 0.00 PO# 00000057 Due on 10/08/2020 Dept/Loc: 160 Totals: 20,289.28 20,289.28 0.00 COMPUTER EQUIP-HARDWARE Vendor # 011076 SEHI COMPUTERS PRODU Totals: 20,289.28 20,289.28 0.00 **** 011090 HAAKER EQUIPMENT COM 00000054 001 106630-56116- FY 19-20 Trailer Mounted Hot Wat 22,661.02 22,661.02 0.00 PO# 00000054 Due on Dept/Loc: 630 Totals: 22,661.02 22,661.02 0.00 HOT WATER PRESSURE WASHER Vendor # 011090 HAAKER EQUIPMENT COM Totals: 22,661.02 22,661.02 0.00 **** 011092 ANIMAL PEST MANAGEME 00000070 001 100510-52320- COMPREHENSIVE PEST CONTROL - DIA 3,000.00 525.00 2,475.00 00000070 002 100630-52320- COMPREHENSIVE PEST CONTROL - PAR 1,000.00 350.00 650.00 00000070 003 100620-52320- COMPREHENSIVE PEST CONTROL - CIV 3,000.00 600.00 2,400.00 PO# 00000070 Due on Dept/Loc: 630 Totals: 7,000.00 1,475.00 5,525.00 COMPREHENSIVE PEST CONTROL Vendor # 011092 ANIMAL PEST MANAGEME Totals: 7,000.00 1,475.00 5,525.00 **** 011136 HARRY H JOH CONSTRUC 00000085 001 504630-56100- Washington Park Poured-in-Place 39,893.81 37,899.11 1,994.70 PO# 00000085 Due on 02/26/2021 Dept/Loc: 630 Totals: 39,893.81 37,899.11 1,994.70 Washington Park Poured-in-Place Surfacing City of Diamond Bar, CA OPEN PURCHASE ORDERS BY VENDOR REPORT Report generated: 05/17/2021 14:18 User: AlfaL Program ID: poreport Page 23 PO # LN GL Account Alloc Description Amount Ordered Amount Liq/Cancel Amount Open Vendor # 011136 HARRY H JOH CONSTRUC Totals: 39,893.81 37,899.11 1,994.70 **** 011156 INNOVATIVE EMERGENCY 00000088 001 256350-54900- Hazard Mitigation Grant - FEMA F 40,434.31 0.00 40,434.31 PO# 00000088 Due on Dept/Loc: 130 Totals: 40,434.31 0.00 40,434.31 Hazard Mitigation Plan - FEMA Grant Project Vendor # 011156 INNOVATIVE EMERGENCY Totals: 40,434.31 0.00 40,434.31 **** 011170 GENESIS PRO ROOFING 00000092 001 225440-54900- HOME IMPROVEMENT PROJECT-23540 C 18,900.00 17,010.00 1,890.00 PO# 00000092 Due on 04/09/2021 Dept/Loc: 410 Totals: 18,900.00 17,010.00 1,890.00 HOME IMPROVEMENT PROJECT-23540 CASA LOMA Vendor # 011170 GENESIS PRO ROOFING Totals: 18,900.00 17,010.00 1,890.00 **** 011176 EIDE BAILLY LLP 00000091 001 100130-54900- Professional Services - Interim 45,000.00 3,545.00 41,455.00 PO# 00000091 Due on Dept/Loc: 130 Totals: 45,000.00 3,545.00 41,455.00 Professional Services - Interim Finance Director Vendor # 011176 EIDE BAILLY LLP Totals: 45,000.00 3,545.00 41,455.00 **** 011183 TURBOSCAPE INC 00000097 001 100630-52320- WOOD CHIPS FOR PLAY GROUND AND D 15,496.87 0.00 15,496.87 PO# 00000097 Due on 05/07/2021 Dept/Loc: 630 Totals: 15,496.87 0.00 15,496.87 PARKS & FACILITIES MAINTENANCE Vendor # 011183 TURBOSCAPE INC Totals: 15,496.87 0.00 15,496.87 Grand Totals: 24,637,521.32 18,813,708.06 5,823,813.26 ** END OF REPORT - Generated by Alfa Lopez **