Loading...
HomeMy WebLinkAboutStaff Report 1986 City of Palo Alto (ID # 1986) Finance Committee Informational Report Report Type: Informational Items Meeting Date: 9/20/2011 September 20, 2011 Page 1 of 1 (ID # 1986) Title: Library Bond Oversight Quarterly Report Q3 20011 Subject: Library Bond Oversight Committee Quarterly Report for July 2011 From: City Manager Lead Department: Public Works Please see attached Library Bond Oversight Committee Third Quarter Report 2011. Attachments:  3rd Quarter Report 7-11 (DOC)  Committee Financial Report, July 13, 2011- Revised (PDF) TO: Finance Committee FROM: Library Bond Oversight Committee DATE: July 29, 2011 SUBJECT: Library Bond Oversight Committee Third Quarter Report – July 2011 The Library Bond Oversight Committee met in January, April and July 2011. Members of the City staff and project management firm regularly attend our meetings. The Committee finds that the City’s financial reporting for all library-related projects is accurate and appropriate. The Committee forwards the July 13, 2011 financial report to the City Council, with Committee approval. Submitted: Dena Mossar Library Oversight Committee Chair ATTACHMENTS: Attachment A: Library Bond Oversight Committee Quarterly Financial Report as of July 13, 2011 1234567 (3 minus 1) (4 minus 1) (4 minus 3) (6 divide by 3) Measure N Estimates Changes in Measure Estimates Engineer's Estimate Projected Costs Diff. Between Measure N Estimates vs. Projected Costs $ Diff. Between Engineer's Estimate vs. Projected Costs % Diff. Between Engineer's Estimate vs. Projected Costs Downtown Library 4,000,000$ 1,212,000$ 5,212,000$ 4,455,781$ (455,781) 756,219$ 14.5% Mitchell Park & Community Center Library 50,000,000 (957,000) 49,043,000 41,566,317 8,433,683 7,476,683 15.2% Temporary Library at Cubberley - 645,000 645,000 612,795 (612,795) 32,205 5.0% Main Library 18,000,000 - 18,000,000 18,000,000 - - 0.0% Temp. Library at Art Center Auditorium - 500,000 500,000 500,000 (500,000) - 0.0% Total Prior to Bond Financing Costs 72,000,000 1,400,000 73,400,000 65,134,893 6,865,107 8,265,107 11.3% Bond Financing Costs (a)4,000,000 (1,400,000) 2,600,000 1,250,000 1,350,000 1,350,000 51.9% Grand Total 76,000,000$ -$ 76,000,000$ 66,384,893$ 8,215,107$ 9,615,107$ 12.7% a) Elimination of capitalized interest resulted in savings (or budget reduction) of $1.4 million for the 2010 bond issuance and if the same can be achieved for the second bond issuance additional savings will be realized Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Budget Original Budget (per Measure N Ballot Measure)72,000,000$ -$ -$ 72,000,000$ Temporary Mitchell Park Library (Council Approved - CMR: 463:09)645,000 645,000 Temporary Main Library Facility - Art Center Auditorium 500,000 500,000 Net Other Budget Changes 255,000 255,000 Expenditures - Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 18,122,960 19,175,576 (37,298,537) Construction Costs - - - Contract Contingency 1,031,000 2,683,252 (3,714,252) Other Contract Services 211,764 90,000 (301,764) City (Inter-department) Service Charge 341,474 - (341,474) Miscellaneous Cost 74,854 - (74,854) Total Library Projects Expenditures 73,400,000 19,782,053 21,948,828 31,669,119 Estimate of Pending Commitments/Costs - - 23,404,012 (23,404,012) Total Bond Funds Less Bond Financing Costs 73,400,000 19,782,053 45,352,840 8,265,107 11.3% Bond Financing Costs (a) (b)2,600,000 568,000 682,000 1,350,000 51.9% Grand Total 76,000,000$ 20,350,053$ 46,034,840$ 9,615,107$ 12.7% 2010 GO Bond True Interest Cost (TIC)4.21% a) Elimination of capitalized interest resulted in savings (or budget reduction) of $1.4 million for the 2010 bond issuance and if the same can be achieved for the second bond issuance additional savings will be realized b) Second (unofficial) bond issuance cost estimate is $682,000 (assumes capitalized interest savings will be achieved) Budget History and Projection City of Palo Alto Library Bond Oversight Committee Quarterly Financial Report As of July 13, 2011 Description of Activity Library Projects Budget to Actual Activities Summary 1 City of Palo Alto Library Bond Oversight Committee Quarterly Financial Report As of July 13, 2011 Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Original Budget (per Measure N Ballot Measure)4,000,000$ -$ -$ 4,000,000$ Budget Change 1,212,000 1,212,000 Expenditures Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 3,106,428 346,972 (3,453,400) Construction Costs - - - - Contract Contingency - 298,861 172,139 (470,999) Other Contract Services - 27,925 - (27,925) City (Inter-department) Service Charge - 44,851 - (44,851) Miscellaneous Cost - 3,158 - (3,158) Total Library Projects Expenditures 5,212,000 3,481,223 519,111 1,211,667 Estimate of Pending Commitments/Costs - - 455,448 (455,448) Total Bond Funds Less Bond Financing Costs 5,212,000$ 3,481,223$ 974,558$ 756,219$ 14.5% Reasons for Budget Increase of:1,212,000$ 1) Seismic upgrade 30,000$ July 2010 2) Roof replacement 125,000 June 2011 3) LEED - Green building upgrades 100,000 4) Construction Management Services increase 400,000 5) Fixed Equipment 187,000 6) Moving costs deemed to be bondable costs 50,000 7) Contingency adjustment 320,000 Net Budget Change 1,212,000$ c) Permanent and built-in casework and equipment portions that are now deem to be bondable costs (part of $4.3 million in FF&E that in the 2008 estimate were identified as non-bondable costs) Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Original Budget (per Measure N Ballot Measure)50,000,000$ -$ -$ 50,000,000$ Budget Change (957,000) (957,000) Expenditures Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 13,823,574 17,884,828 (31,708,402) Contract Contingency - 675,917 2,368,123 (3,044,039) Other Contract Services - 183,839 90,000 (273,839) City (Inter-department) Service Charge - 285,377 - (285,377) Miscellaneous Cost - 71,571 - (71,571) Total Library Projects Expenditures 49,043,000 15,040,277 20,342,951 13,659,773 Estimate of Pending Commitments/Costs 6,183,090 (6,183,090) Total Bond Funds Less Bond Financing Costs 49,043,000$ 15,040,277$ 26,526,040$ 7,476,683$ 15.2% Reasons for Budget Decrease of:(957,000)$ 1) LEED - Green building (Council approved) upgrades 1,200,000$ Sept. 2010 2) Fixed Equipment 1,750,000 July 2012 3) Moving costs deemed to be bondable costs 100,000 4) Contingency adjustment (4,007,000) Net Budget Change (957,000)$ c) Permanent and built-in casework and equipment portions that are now deem to be bondable costs (part of $4.3 million in FF&E that in the 2008 estimate were identified as non-bondable costs) Description of Activity Description of Activity Mitchell Park Library and Community Center Budget to Actual Activities Summary (PE-09006) Downtown Library Budget to Actual Activities Summary (PE-09005) Completed: Construction Began: Construction Began: Scheduled Completion: 2 City of Palo Alto Library Bond Oversight Committee Quarterly Financial Report As of July 13, 2011 Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Original Budget (per Measure N Ballot Measure) 18,000,000$ -$ -$ 18,000,000 Budget Change - - Expenditures Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 728,381 928,215 (1,656,596) Contract Contingency - 22,723 134,691 (157,414) Other Contract Services - - - - City (Inter-department) Service Charge - - - - Miscellaneous Cost - - - - Total Library Projects Expenditures 18,000,000 751,105 1,062,906 16,185,989 Estimate of Pending Commitments/Costs 16,185,989 (16,185,989) Total Bond Funds Less Bond Financing Costs 18,000,000$ 751,105$ 17,248,895$ -$ 0.0% Reasons for Budget Decrease of:-$ May 2012 August 2012 Net Budget Change -$ August 2013 Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Temporary Mitchell Park Library (Council Approved - CMR: 463:09) 645,000$ -$ -$ 645,000$ Expenditures Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 464,577 15,562 (480,139) Contract Contingency - 33,500 8,299 (41,799) City (Inter-department) Service Charge - 11,247 - (11,247) Miscellaneous Cost - 125 - (125) Total Library Projects Expenditures 645,000 509,448 23,861 111,691 Estimate of Pending Commitments/Costs 79,486 (79,486) Total Bond Funds Less Bond Financing Costs 645,000$ 509,448$ 103,347$ 32,205$ 5.0% Description of Activity Main Library Budget to Actual Activities Summary (PE-11000) Description of Activity Temporary Library at Cubberley Budget to Actual Activities Summary (PE-09010) Scheduled Completion: Construction Begins: Award Contract: 3 City of Palo Alto Library Bond Oversight Committee Quarterly Financial Report As of July 13, 2011 Engineer's (Budget) Estimate Expenses Commitment s (aka Purchase Orders) Remaining Balance % Diff. Between Engineer's Est. vs. Remaining Bal. Temporary Main Library Facility - Art Center Auditorium 500,000$ -$ -$ 500,000$ Expenditures Engineering, Architectural, Constr., and Publishing (Reproduction) Costs - - - Contract Contingency - - - - Other Contract Services - City (Inter-department) Service Charge - - - - Miscellaneous Cost - - - - Total Library Projects Expenditures 500,000 - - 500,000 Estimate of Pending Commitments/Costs 500,000 (500,000) Total Bond Funds Less Bond Financing Costs 500,000$ -$ 500,000$ -$ 0.0% Description of Activity Temp. Library at Art Center Auditorium Budget to Actual Activities Summary (Project # PE-11012) 4 Payment or Posting Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Project Budget Original Budget (per Measure N Ballot Measure) 4,000,000 Budget Change 1,212,000 Sub-total - 2010 Engineer's Budget Estimate 5,212,000 - - 5,212,000 Engineering, Architectural, Constr., and Publishing (Reproduction) Costs Summary of Expenditures as of July 21, 2010 418,563 08/24/10 Group 4 Architecture Research & Planning Architectural 362 09/21/10 Group 4 Architecture Research & Planning Architectural 135 08/03/10 Group 4 Architecture Research & Planning Architectural 16,233 08/03/10 Group 4 Architecture Research & Planning Architectural 56,000 08/10/10 Protech Consulting and Engineering Hazardous Material Testing 5,210 08/10/10 Turner Construction Company Construction Management Services 68,577 Oct. 21, 2010 Report 09/21/10 Group 4 Architecture Research & Planning Architectural 15 09/21/10 Group 4 Architecture Research & Planning Architectural 18,080 09/21/10 Group 4 Architecture Research & Planning Architectural 2,970 09/21/10 W.L. Butler Construction, Inc.Construction 93,177 10/05/10 Protech Consulting and Engineering Hazardous Material Testing 990 10/19/10 Group 4 Architecture Research & Planning Architectural 10,544 11/02/10 W. L. Butler Construction, Inc.Construction 69,984 11/02/10 Turner Construction Company Construction Management Services 27,984 11/02/10 Group 4 Architecture Research & Planning Architectural 11,864 12/07/10 Turner Construction Company Construction Management Services 55,174 12/07/10 Group 4 Architecture Research & Planning Architectural 11,688 Jan. 25, 2011 Report 12/07/10 W. L. Butler Construction, Inc.Construction 92,055 12/14/10 Group 4 Architecture Research & Planning Architectural 519 12/14/10 W. L. Butler Construction, Inc.Construction 159,940 01/04/11 Turner Construction Company Construction Management Services 27,984 01/07/11 Group 4 Architecture Research & Planning Architectural 11,688 01/21/11 West Coast Code Consultants, Inc.Plan Check 350 01/21/11 Turner Construction Company Construction Management Services 30,212 01/31/11 W. L. Butler Construction, Inc.Construction 211,220 02/18/11 W. L. Butler Construction, Inc.Construction 279,472 02/18/11 Group 4 Architecture Research & Planning Architectural 8,766 02/18/11 Turner Construction Company Construction Management Services 27,429 03/16/11 W. L. Butler Construction, Inc.Construction 277,033 April 26, 2011 Report 03/18/11 Group 4 Architecture Research & Planning Architectural 432 03/18/11 Group 4 Architecture Research & Planning Architectural 409 03/18/11 Group 4 Architecture Research & Planning Architectural 8,766 03/18/11 Group 4 Architecture Research & Planning Architectural 136 03/31/11 Pivot Interiors Design 2,250 03/31/11 Turner Construction Company Construction Management Services 17,808 04/07/11 Group 4 Architecture Research & Planning Architectural 13,149 04/19/11 Group 4 Architecture Research & Planning Architectural 2,795 04/25/11 W. L. Butler Construction, Inc.Construction 342,711 05/10/11 Turner Construction Company Construction Management Services 39,522 05/12/11 Group 4 Architecture Research & Planning Architectural 220 05/12/11 Group 4 Architecture Research & Planning Architectural 24,891 05/12/11 Group 4 Architecture Research & Planning Architectural 14,610 05/17/11 Turner Construction Company Construction Management Services 28,334 05/27/11 W. L. Butler Construction, Inc.Construction 238,387 06/07/11 W. L. Butler Construction, Inc.Construction 352,713 06/07/11 Group 4 Architecture Research & Planning Architectural 14,610 06/09/11 Moovers, Inc.Moving Services 10,233 06/16/11 Group 4 Architecture Research & Planning Architectural 233 Pivot Interiors Design - Modular Furniture Moovers, Inc.Moving Services 580 W.L. Butler Construction, Inc.Construction 225,329 Group 4 Architecture Research Architectural 51,893 Turner Construction Company Construction Management Services 69,170 Sub-total - Engineering and Architectural Costs - 3,106,428 346,972 (3,453,400) Contract Contingency Summary of Expenditures as of July 21, 2010 19,140 10/19/10 Group 4 Architecture Research & Planning Architectural 660 10/19/10 Group 4 Architecture Research & Planning Architectural 4,070 Oct. 21, 2010 Report Downtown Library Activity Details (PE-09005) As of July 13, 2011 5 Payment or Posting Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Downtown Library Activity Details (PE-09005) As of July 13, 2011 08/27/10 Asbestos Management Group Hazardous Material Testing 2,500 02/28/11 City of Palo Alto - Planning Plan Check Fee 93 April 26, 2011 Report 02/18/11 W. L. Butler Construction, Inc.Construction 15,686 04/25/11 W. L. Butler Construction, Inc.Construction 59,235 05/27/11 W. L. Butler Construction, Inc.Construction 163,149 07/01/11 Turner Construction Company Construction Management Services 1,123 07/01/11 Turner Construction Company Construction Management Services 24,611 06/07/11 Group 4 Architecture Research & Planning Architectural 5,104 06/07/11 Group 4 Architecture Research & Planning Architectural 3,489 Group 4 Architecture Research & Planning Architectural 14,198 Turner Construction Company Construction Management Services 16,898 Moovers, Inc.Moving Services 4,113 W.L. Butler Construction, Inc.Construction 136,930 Sub-total - Contract Contingency - 298,861 172,139 (470,999) Other Contract Services Summary of Expenditures as of July 21, 2010 2,225 08/27/10 Asbestos Management Group Hazardous Material Testing 25,700 Oct. 21, 2010 Report Sub-total - Other Contract Services - 27,925 - (27,925) City (Inter-department) Service Charge Summary of Expenditures as of July 21, 2010 43,990 10/31/10 City of Palo Alto - Planning Plan Checking 861 Jan. 25, 2011 Report Sub-total - City (Inter-department) Service Charge - 44,851 - (44,851) Miscellaneous Cost Summary of Expenditures as of July 21, 2010 3,158 Sub-total - Miscellaneous Cost - 3,158 - (3,158) Grant Total 5,212,000 3,481,223 519,111 1,211,667 6 Payment Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Project Budget Original Budget (per Measure N Ballot Measure) 50,000,000$ Budget Change (957,000) Sub-total - 2010 Engineer's Budget Estimate 49,043,000 - - 49,043,000 Engineering, Architectural, Constr., and Publishing (Reproduction) Costs Summary of Expenditures as of July 21, 2010 3,101,748 08/03/10 Group 4 Architecture Research & Planning Architectural 37,609 08/10/10 Group 4 Architecture Research & Planning Architectural 18,595 10/05/10 Group 4 Architecture Research & Planning Architectural 7,522 10/05/10 Group 4 Architecture Research & Planning Architectural 13,942 10/05/10 Group 4 Architecture Research & Planning Architectural 2,971 07/27/10 Moovers, Inc.Moving Services 435 09/21/10 Turner Construction Company Construction Management Services 163,918 10/19/10 Group 4 Architecture Research & Planning Architectural 47,110 10/19/10 State Water Resources Control Board Submitting Permit Registration Documents 375 Oct. 21, 2010 Report 10/19/10 Group 4 Architecture Research & Planning Architectural 18,517 08/03/10 Peninsula Digital Imaging Reproduction Services 3,066 08/03/10 Peninsula Digital Imaging Reproduction Services 2,401 08/03/10 Peninsula Digital Imaging Reproduction Services 5,105 08/03/10 Peninsula Digital Imaging Reproduction Services 2,119 11/02/10 Bank of Sacramento - Flintco Pacific Escrow Construction 86,542 11/02/10 Flintco Pacific, Inc.Construction 778,876 11/02/10 Group 4 Architecture Research & Planning Architectural 1,037 12/07/10 Turner Construction Company Construction Management Services 635 12/07/10 Turner Construction Company Construction Management Services 70,780 12/07/10 Turner Construction Company Construction Management Services 64,319 12/07/10 Protech Consulting and Engineering Hazardous Material Testing 8,385 12/07/10 Peninsula Digital Imaging Reproduction Services 7,672 12/14/10 West Coast Code Consultants, Inc.Plan Check 26,820 12/14/10 Group 4 Architecture Research & Planning Architectural 46,200 Jan. 25, 2011 Report 12/21/10 Group 4 Architecture Research & Planning Architectural 46,297 12/21/10 Flintco Pacific, Inc.Construction 732,895 12/21/10 Flintco Pacific, Inc. Escrow 2841-042 Construction 81,433 12/28/10 Flintco Pacific, Inc.Construction 757,231 12/28/10 Flintco Pacific, Inc. Escrow 2841-042 Construction 84,137 01/04/11 Group 4 Architecture Research & Planning Architectural 2,942 01/04/11 Group 4 Architecture Research & Planning Architectural 4,564 01/04/11 Turner Construction Company Construction Management Services 73,919 1/21/2011 Group 4 Architecture Research & Planning Architectural 267 1/21/2011 Group 4 Architecture Research & Planning Architectural 46,261 1/21/2011 Turner Construction Company Construction Management Services 105,917 2/1/2011 Flintco Pacific, Inc.Construction 1,098,865 2/1/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 126,732 2/18/2011 Flintco Pacific, Inc.Construction 1,497,190 2/18/2011 Turner Construction Company Construction Management Services 94,502 2/18/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 193,977 2/24/2011 Group 4 Architecture Research & Planning Architectural 46,261 3/10/2011 West Coast Code Consultants, Inc.Plan Check 1,820 3/10/2011 West Coast Code Consultants, Inc.Plan Check 1,680 3/16/2011 West Coast Code Consultants, Inc.Plan Check (560) 3/16/2011 West Coast Code Consultants, Inc.Plan Check 560 April 26, 2011 Report 3/16/2011 Protech Consulting and Engineering Hazardous Material Testing 1,250 3/17/2011 West Coast Code Consultants, Inc.Plan Check 560 3/18/2011 Group 4 Architecture Research & Planning Architectural 46,261 3/31/2011 Flintco Pacific, Inc.Construction 446,177 3/31/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 76,548 3/31/2011 Turner Construction Company Construction Management Services 94,572 4/11/2011 Group 4 Architecture Research & Planning Architectural 4,219 4/11/2011 Group 4 Architecture Research & Planning Architectural 127 4/11/2011 Group 4 Architecture Research & Planning Architectural 7,366 4/11/2011 Group 4 Architecture Research & Planning Architectural 80,956 4/20/2011 West Coast Code Consultants, Inc.Plan Check 140 4/20/2011 West Coast Code Consultants, Inc.Plan Check 280 4/20/2011 West Coast Code Consultants, Inc.Plan Check 560 3/29/2011 Palo Alto Stores Supplies/Parts 1,342 4/25/2011 Flintco Pacific, Inc. Escrow 2841-042 85,140 4/25/2011 Flintco Pacific, Inc.Construction 766,263 4/26/2011 Group 4 Architecture Research & Planning Architectural 2,528 5/10/2011 Turner Construction Company Construction Management Services 82,594 5/12/2011 Group 4 Architecture Research & Planning Architectural 683 5/12/2011 Group 4 Architecture Research & Planning Architectural 80,956 5/17/2011 Turner Construction Company Construction Management Services 101,701 5/17/2011 Flintco Pacific, Inc.Construction 815,307 Mitchell Park Library and Community Center Activity Details (PE-09006) As of July 13, 2011 7 Payment Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Mitchell Park Library and Community Center Activity Details (PE-09006) As of July 13, 2011 5/17/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 93,874 5/17/2011 Flintco Pacific, Inc.Construction 29,559 7/1/2011 Turner Construction Company Construction Management Services 99,493 7/1/2011 Group 4 Architecture Research & Planning Architectural 19,540 7/1/2011 Group 4 Architecture Research & Planning Architectural 3,109 7/1/2011 Group 4 Architecture Research & Planning Architectural 17,038 7/1/2011 Group 4 Architecture Research & Planning Architectural 92,521 7/1/2011 Group 4 Architecture Research & Planning Architectural 8,314 7/5/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 125,101 7/5/2011 Flintco Pacific, Inc.Construction 1,125,909 Protect Consulting and Engineering Hazardous Material Testing 12,699 Movers, Inc.Moving Services 19,853 Group 4 Architecture Research Architectural 778,227 Turner Construction Company Construction Management Services 1,678,285 Flintco Pacific, Inc.Construction 15,392,805 West Coast Code Consultants, Inc.Plan Check 2,960 Sub-total - Engineering Costs - 13,823,574 17,884,828 (31,708,402) Contract Contingency Summary of Expenditures as of July 21, 2010 104,373 08/03/10 Group 4 Architecture Research & Planning Architectural 1,771 10/05/10 Group 4 Architecture Research & Planning Architectural 25,951 Jan. 25, 2011 Report 10/19/10 Group 4 Architecture Research & Planning Architectural 10,740 2/1/2011 Flintco Pacific, Inc.Construction 41,725.00 2/18/2011 Flintco Pacific, Inc.Construction 248,603.00 April 26, 2011 Report 3/31/2011 Flintco Pacific, Inc.Construction 242,754.00 Moovers, Inc.Moving Services 6,649 Flintco Pacific, Inc.Construction 1,873,859 Protect Consulting and Engineering 11,991 Group 4 Architecture Research & Planning 201,735 Turner Construction Company Construction Management Services 270,729 West Coast Code Consultants, Inc.Plan Check 3,160 Sub-total - Contract Contingency - 675,917 2,368,123 (3,044,039) Other Contract Services Summary of Expenditures as of July 21, 2010 93,750 07/01/11 FedEx Mailing 89 08/26/10 Bruce Beasley Sculpture 90,000 Oct. 21, 2010 Report Bruce Beasley Sculpture 90,000 Sub-total - Other Contract Services - 183,839 90,000 (273,839) City (Inter-department) Service Charge Summary of Expenditures as of July 21, 2010 176,008 09/30/10 City of Palo Alto - Planning Permit Fees - Mitchell Park Library - Bldg A 70,153 09/30/10 City of Palo Alto - Planning Permit Fees - Mitchell Park Teen Center - Bldg B 10,768 09/30/10 City of Palo Alto - Planning Permit Fees - Mitchell Park Multipurpose Center - Bldg C 21,184 Oct. 21, 2010 Report 09/30/10 City of Palo Alto - Planning Demolition Permit MPL - 3700 Middlefield 525 09/30/10 City of Palo Alto - Planning Demolition Permit MPCC - 3800 Middlefield 525 09/28/10 City of Palo Alto - Planning Permit (Grading and Fill)1,830 10/31/10 City of Palo Alto - Planning Revision permit for Mitchell Park Library & CC 141 11/16/10 City of Palo Alto - Planning Architectural Review Board Fees 2,090 Jan. 25, 2011 Report 01/31/11 Palo Alto Stores Supplies/Parts 101 03/31/11 Palo Alto Stores Supplies/Parts 97 03/31/11 Palo Alto Stores Supplies/Parts 4,045 April 26, 2011 Report 03/31/11 Palo Alto Stores Supplies/Parts 89 03/31/11 Palo Alto Stores Supplies/Parts 661 06/14/10 Palo Alto Stores Reversal of Prior Charges (2,834) 03/29/11 Palo Alto Stores Reversal of Prior Charges (628) 03/30/11 Palo Alto Stores Reversal of Prior Charges (571) 04/04/11 Palo Alto Stores Reversal of Prior Charges (143) 04/30/11 City of Palo Alto - Public Works Underground Fire Supply/Hydrant Permit Fee 1,335 Sub-total - City (Inter-department) Service Charge - 285,377 - (285,377) Miscellaneous Cost Summary of Expenditures as of July 21, 2010 3,315 06/30/10 Office Max (US Bank-Calcard) - Reversed Reverse office supplies charged to project (246) 06/30/10 Debra Jacobs Reverse prior travel and meeting expense (6) Oct. 21, 2010 Report 06/30/10 Karen Bengard Reverse prior travel and meeting expense (20) 06/30/10 Hung Nguyen Reverse prior travel and meeting expense (11) 8 Payment Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Mitchell Park Library and Community Center Activity Details (PE-09006) As of July 13, 2011 06/30/10 Hung Nguyen Reverse prior travel and meeting expense (20) 03/30/11 Palo Alto Stores Supplies/Parts 4 April 26, 2011 Report 03/30/11 Palo Alto Stores Supplies/Parts 214 03/30/11 Palo Alto Stores Reversal of Prior Charges (4) 03/30/11 Palo Alto Stores Reversal of Prior Charges (214) 04/21/11 City of Palo Alto - Utilities Utility Connection Fee 68,559 Group 4 Architecture Research Architectural West Coast Code Consultants, Inc.Plan Check Turner Construction Company Construction Management Services Movers, Inc.Moving Services Flintco Pacific, Inc.Construction Protect Consulting and Engineering Hazardous Material Testing Sub-total - Miscellaneous Cost - 71,571 - (71,571) Grant Total 49,043,000 15,040,277 20,342,951 13,659,773 9 Payment Date Purchasing Document Payee Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Project Budget Original Budget (per Measure N Ballot Measure) 18,000,000$ Budget Change - Sub-total - 2010 Engineer's Budget Estimate 18,000,000 - - 18,000,000 Engineering, Architectural, Constr., and Publishing (Reproduction) Costs 10/05/10 Group 4 Architecture Research and Planning Architectural 73,246 10/05/10 Group 4 Architecture Research and Planning Architectural 700 10/05/10 Group 4 Architecture Research and Planning Architectural 73,246 11/02/10 Group 4 Architecture Research and Planning Architectural 5,785 11/02/10 Group 4 Architecture Research and Planning Architectural 122,100 Jan. 25, 2011 Report 12/07/10 Group 4 Architecture Research and Planning Architectural 2,390 01/04/11 Group 4 Architecture Research and Planning Architectural 15,000 01/04/11 Group 4 Architecture Research and Planning Architectural 583 01/04/11 Group 4 Architecture Research and Planning Architectural 859 01/04/11 Turner Construction Company Construction Management Services 1,195 02/24/11 Group 4 Architecture Research and Planning Architectural 4,860 03/18/11 Group 4 Architecture Research and Planning Architectural 73,246 03/18/11 Group 4 Architecture Research and Planning Architectural 7,500 03/18/11 Group 4 Architecture Research and Planning Architectural 53 03/18/11 Group 4 Architecture Research and Planning Architectural 3,843 04/11/11 Group 4 Architecture Research and Planning Architectural 112,464 04/11/11 Group 4 Architecture Research and Planning Architectural 3,993 04/11/11 Group 4 Architecture Research and Planning Architectural 7,500 01/21/11 Group 4 Architecture Research and Planning Architectural 24,392 April 26, 2011 Report 01/21/11 Turner Construction Company Construction Management Services 1,434 01/21/11 Group 4 Architecture Research and Planning Architectural 2,500 01/24/11 Group 4 Architecture Research and Planning Architectural 1,500 01/21/11 Group 4 Architecture Research and Planning Architectural 447 02/18/11 Turner Construction Company Construction Management Services 478 02/18/11 Group 4 Architecture Research and Planning Architectural 48,831 02/18/11 Group 4 Architecture Research and Planning Architectural 2,653 02/18/11 Group 4 Architecture Research and Planning Architectural 3,238 05/12/11 Group 4 Architecture Research and Planning Architectural 6,250 05/12/11 Group 4 Architecture Research and Planning Architectural 40,052 05/12/11 Group 4 Architecture Research and Planning Architectural 12,411 05/12/11 Group 4 Architecture Research and Planning Architectural 3,263 05/17/11 Group 4 Architecture Research and Planning Architectural 4,553 06/09/11 Group 4 Architecture Research and Planning Architectural 31,374 07/01/11 Turner Construction Company Construction Management Services 9,169 07/11/11 Group 4 Architecture Research and Planning Architectural 11,100 07/11/11 Group 4 Architecture Research and Planning Architectural 488 07/11/11 Group 4 Architecture Research and Planning Architectural 15,687 Group 4 Architecture Research and Planning Architectural 824,581 Turner Construction Company Construction Management Services 92,834 West Coast 10,800 Sub-total - Engineering and Architectural Costs - 728,381 928,215 (1,656,596) Contract Contingency 05/27/11 Group 4 Architecture Research and Planning Architectural 22,152 06/09/11 Group 4 Architecture Research and Planning Architectural 571 Group 4 Architecture Research and Planning Architectural 123,941 Turner Construction Company Construction Management Services 10,750 Sub-total - Contract Contingency - 22,723 134,691 (157,414) Other Contract Services Sub-total - Other Contract Services - - - - City (Inter-department) Service Charge Sub-total - City (Inter-department) Service Charge - - - - Miscellaneous Cost Sub-total - Miscellaneous Cost - - - - Grant Total 18,000,000 751,105 1,062,906 16,185,989 Main Library Activity Details (PE-11000) As of July 13, 2011 10 Payment Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Project Budget Temporary Mitchell Park Library (Council Approved - CMR: 463:09)645,000 gg Sub-total - 2010 Engineer's Budget Estimate 645,000 - - 645,000$ Engineering, Architectural, Constr., and Publishing (Reproduction) Costs Summary of Expenditures as of July 21, 2010 439,283$ 10/05/10 Group 4 Architecture Research & Planning Architectural 5,774 Oct. 21, 2010 Report 08/24/10 Group 4 Architecture Research & Planning Architectural 329 01/27/11 Johnstone Moyer, Inc.Temp. Library Improvements 19,191 April 26, 2011 Report Group 4 Architecture Research & Planning Architectural 12,362 Ross McDonald Company, Inc.Library Shelving 3,200 Sub-total - Engineering and Architectural Costs - 464,577 15,562 (480,139) Contract Contingency Summary of Expenditures as of July 21, 2010 2,541 08/24/10 Johnstone Moyer, Inc.Temp. Library Improvements 24,604 Oct. 21, 2010 Report 08/27/10 West Corporation Temp. Lib. - Security Access Card & Alarm 310 01/27/11 Johnstone Moyer, Inc.Temp. Library Improvements 6,045 April 26, 2011 Report Group 4 Architecture Research & Planning Architectural 4,759 Ross McDonald Company, Inc.Library Shelving 3,540 Sub-total - Contract Contingency - 33,500 8,299 (41,799) City (Inter-department) Service Charge Summary of Expenditures as of July 21, 2010 11,247 Sub-total - City (Inter-department) Service Charge - 11,247 - (11,247) Miscellaneous Cost Summary of Expenditures as of July 21, 2010 125 Sub-total - Miscellaneous Cost - 125 - (125) Grant Total 645,000 509,448 23,861 111,691 Temporary Library at Cubberley (for Mitchell Facility) - Activity Details (PE-09010) As of July 13, 2011 11 Payment Date Payee Description Engineer's (Budget) Estimate Expenses Commitments (aka Purchase Orders) Remaining Balance Project Budget Temporary Main Library Facility - Art Center Auditorium 500,000 Sub-total - 2010 Engineer's Budget Estimate 500,000 - - 500,000$ Engineering, Architectural, Constr., and Publishing (Reproduction) Costs Summary of Expenditures as of July 21, 2010 -$ Sub-total - Engineering and Architectural Costs - - - - Contract Contingency Summary of Expenditures as of July 21, 2010 - Sub-total - Contract Contingency - - - - City (Inter-department) Service Charge Summary of Expenditures as of July 21, 2010 - Sub-total - City (Inter-department) Service Charge - - - - Miscellaneous Cost Summary of Expenditures as of July 21, 2010 - Sub-total - Miscellaneous Cost - - - - Grant Total 500,000 - - 500,000 Temporary Library for Main (Art Center Auditorium) - Activity Details (Project # PE-11012) As of July 13, 2011 12