HomeMy WebLinkAboutID2519-Library-Quarterly-Report-2-28-12City of Palo Alto (ID # 2519)
Finance Committee Informational Report
Report Type: Informational Items Meeting Date: 2/28/2012
February 28, 2012 Page 1 of 1
(ID # 2519)
Title: Library Bond Oversight Quarterly Report Q1 2012
Subject: Library Bond Oversight Committee Quarterly Report for January 2012
From:City Manager
Lead Department: Public Works
Please see attached Library Bond Oversight Committee First Quarter Report 2012.
Attachments:
·1st Quarter Report 1-12 (DOC)
·2012 01 24 Revised Committee Financial Report(PDF)
Prepared By:Debra Jacobs, Project Engineer
Department Head:J. Michael Sartor, Director
City Manager Approval: James Keene, City Manager
TO:Finance Committee
FROM:Library Bond Oversight Committee
DATE:January 31 2011
SUBJECT:Library Bond Oversight Committee First Quarter Report –January
2012
The Library Bond Oversight Committee met in January, April,July, and October
2011 and January 2012. 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 January 18,
2012 financial report to the City Council, with Committee approval.
Submitted:
C.James Schmidt
Library Bond Oversight Committee Chair
ATTACHMENTS:
Attachment A: Library Bond Oversight Committee Quarterly Financial Report as
of January 18, 2012.
1 2 3 4 5 6 7
(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,418,111$ (418,111) 793,889$ 15.2%
Mitchell Park & Community Center Library 50,000,000 (957,000) 49,043,000 40,997,900 9,002,100 8,045,100 16.4%
Cubberley Temporary Library - 645,000 645,000 619,687 (619,687) 25,313 3.9%
Main Library 18,000,000 - 18,000,000 19,918,500 (1,918,500) (1,918,500) (10.7%)
Art Center Temporary Library - 500,000 500,000 506,309 (506,309) (6,309) (1.3%)
Total Prior to Bond Financing Costs 72,000,000 1,400,000 73,400,000 66,460,507 5,539,493 6,939,493 9.5%
Bond Financing Costs (a)4,000,000 (1,400,000) 2,600,000 1,250,000 2,750,000 1,350,000 51.9%
Grand Total 76,000,000$ -$ 76,000,000$ 67,710,507$ 8,289,493$ 8,289,493$ 10.9%
a) Elimination of capitalized interest resulted in savings (or budget reduction) of $1.4 million for the 2010 bond issuance
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 25,290,538 12,402,775 (37,693,313)
Construction Costs - - -
Contract Contingency 2,811,839 1,143,575 (3,955,414)
Other Contract Services 230,052 738,830 (968,881)
City (Inter-department) Service Charge 344,029 - (344,029)
Miscellaneous Cost 74,859 3,816,651 (3,891,510)
Total Library Projects Expenditures 73,400,000 28,751,316 18,101,831 26,546,853
Estimate of Pending Commitments/Costs - - 19,607,360 (19,607,360)
Total Bond Funds Less Bond Financing Costs 73,400,000 28,751,316 37,709,191 6,939,493 9.5%
Bond Financing Costs (a)2,600,000 571,208 678,792 1,350,000 51.9%
Grand Total 76,000,000$ 29,322,524$ 38,387,983$ 8,289,493$ 10.9%
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 in addition of the $571,208
in issuance costs, the Underwriter's portion of $348,010 is paid from bond premium
City of Palo Alto
Library Bond Oversight Committee Quarterly Financial Report
As of January 18, 2012
Description of Activity
Library Projects Budget to Actual Activities Summary
Budget History and Projection
1
City of Palo Alto
Library Bond Oversight Committee Quarterly Financial Report
As of January 18, 2012
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,583,704 88,810 (3,672,513)
Construction Costs - - - -
Contract Contingency - 321,499 157,491 (478,990)
Other Contract Services - 27,925 - (27,925)
City (Inter-department) Service Charge - 45,501 - (45,501)
Miscellaneous Cost - 3,163 - (3,163)
Total Library Projects Expenditures 5,212,000 3,981,792 246,301 983,907
Estimate of Pending Commitments/Costs - - 190,018 (190,018)
Total Bond Funds Less Bond Financing Costs 5,212,000$ 3,981,792$ 436,319$ 793,889$ 15.2%
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 19,834,691 11,527,601 (31,362,292)
Contract Contingency - 2,434,117 756,663 (3,190,780)
Other Contract Services - 202,127 648,830 (850,956)
City (Inter-department) Service Charge - 287,282 - (287,282)
Miscellaneous Cost - 71,571 3,816,651 (3,888,222)
Total Library Projects Expenditures 49,043,000 22,829,787 16,749,744 9,463,469
Estimate of Pending Commitments/Costs 1,418,369 (1,418,369)
Total Bond Funds Less Bond Financing Costs 49,043,000$ 22,829,787$ 18,168,113$ 8,045,100$ 16.4%
Reasons for Budget Decrease of:(957,000)$
1) LEED - Green building (Council approved) upgrades 1,200,000$
2) Fixed Equipment 1,750,000
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:
2
City of Palo Alto
Library Bond Oversight Committee Quarterly Financial Report
As of January 18, 2012
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 1,407,565 426,447 (1,834,012)
Contract Contingency - 22,723 150,432 (173,155)
Other Contract Services - - 90,000 (90,000)
City (Inter-department) Service Charge - - - -
Miscellaneous Cost - - - -
Total Library Projects Expenditures 18,000,000 1,430,289 666,879 15,902,833
Estimate of Pending Commitments/Costs 17,821,333 (17,821,333)
Total Bond Funds Less Bond Financing Costs 18,000,000$ 1,430,289$ 18,488,211$ (1,918,500)$ (10.7%)
Reasons for Budget Decrease of:-$
Net Budget Change -$
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 40,858 (74,358)
City (Inter-department) Service Charge - 11,247 - (11,247)
Miscellaneous Cost - 125 - (125)
Total Library Projects Expenditures 645,000 509,448 56,420 79,132
Estimate of Pending Commitments/Costs 53,819 (53,819)
Total Bond Funds Less Bond Financing Costs 645,000$ 509,448$ 110,239$ 25,313$ 3.9%
Description of Activity
Cubberley Temporary Library Budget to Actual Activities Summary (PE-09010)
Description of Activity
Main Library Budget to Actual Activities Summary (PE-11000)
3
City of Palo Alto
Library Bond Oversight Committee Quarterly Financial Report
As of January 18, 2012
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 - 344,356 (344,356)
Contract Contingency - - 38,131 (38,131)
Other Contract Services -
City (Inter-department) Service Charge - - - -
Miscellaneous Cost - - - -
Total Library Projects Expenditures 500,000 - 382,487 117,513
Estimate of Pending Commitments/Costs 123,822 (123,822)
Total Bond Funds Less Bond Financing Costs 500,000$ -$ 506,309$ (6,309)$ (1.3%)
Description of Activity
Art Center Temporary Library 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 July 26, 2011 Report
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
07/20/11 Group 4 Architecture Research & Planning Architectural 479.16
07/20/11 Group 4 Architecture Research & Planning Architectural 12,405
07/27/11 W.L. Butler Construction, Inc.Construction 157,980
07/27/11 Turner Construction Company Construction Management Services 26,028
08/31/11 Group 4 Architecture Research & Planning Architectural 19,560 October 25, 2011 Report
08/10/11 Group 4 Architecture Research & Planning Architectural 137
08/10/11 Group 4 Architecture Research & Planning Architectural 5,100
08/24/11 Turner Construction Company Construction Management Services 38,160
08/31/11 W.L. Butler Construction, Inc.Construction 137,659
09/14/11 Group 4 Architecture Research & Planning Architectural 2,550
09/14/11 Group 4 Architecture Research & Planning Architectural 1,116
12/07/11 Group 4 Architecture Research & Planning Architectural 5,100.00
10/19/11 Turner Construction Company Construction Management Services 1,176.00
12/21/11 Turner Construction Company Construction Management Services 3,806.42
11/09/11 Group 4 Architecture Research & Planning Architectural 1,146.02
Downtown Library Activity Details (PE-09005)
As of January 18, 2012
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 January 18, 2012
12/07/11 W.L. Butler Construction, Inc.Construction 64,873.60
Pivot Interiors Design - Modular Furniture
Moovers, Inc.Moving Services 580
W.L. Butler Construction, Inc.Construction 22,796
Group 4 Architecture Research Architectural 65,434
Sub-total - Engineering and Architectural Costs - 3,583,704 88,810 (3,672,513)
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
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 July 26, 2011 Report
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
07/27/11 Group 4 Architecture Research & Planning Architectural 9,339 October 25, 2011 Report
08/31/11 W. L. Butler Construction, Inc.Construction 13,299
Group 4 Architecture Research & Planning Architectural 14,198
Turner Construction Company Construction Management Services 14,404
W.L. Butler Construction, Inc.Construction 123,786
Protech Consulting and Engineering Hazardous Material Testing 990
Moovers, Inc.Moving Services 4,113
Sub-total - Contract Contingency - 321,499 157,491 (478,990)
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
07/13/11 City of Palo Alto - Public Works Parking Permit 230 October 25, 2011 Report
07/13/11 City of Palo Alto - Public Works Parking Permit 420
10/31/10 City of Palo Alto - Planning Plan Checking 861 Jan. 25, 2011 Report
Sub-total - City (Inter-department) Service Charge - 45,501 - (45,501)
Miscellaneous Cost
Summary of Expenditures as of July 21, 2010 3,158
04/10/36 Santa Clara County Downtown-Notice of Completion Filing Fee 5
Sub-total - Miscellaneous Cost - 3,163 - (3,163)
Grant Total 5,212,000 3,981,792 246,301 983,907
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 July 26, 2011 Report
5/17/2011 Flintco Pacific, Inc. Escrow 2841-042 Construction 93,874
Mitchell Park Library and Community Center Activity Details (PE-09006)
As of January 18, 2012
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 January 18, 2012
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 July 26, 2011 Report
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
7/27/2011 Group 4 Architecture Research & Planning Architectural 57,826
7/27/2011 Group 4 Architecture Research & Planning Architectural 13,045
7/27/2011 Group 4 Architecture Research & Planning Architectural 1,954
7/27/2011 Flintco Pacific, Inc.Construction 2,316,525
7/27/2011 Flintco Inc. Escrow Construction 257,391
7/27/2011 Turner Construction Company Construction Management Services 127,367 October 25, 2011 Report
10/5/2011 Group 4 Architecture Research & Planning Architectural 1,898
10/5/2011 Group 4 Architecture Research & Planning Architectural 57,826
10/5/2011 Group 4 Architecture Research & Planning Architectural 1,647
10/5/2011 Flintco Pacific, Inc.Construction 483,144
10/5/2011 Flintco, Inc. Escrow Construction 53,683
10/19/2011 Turner Construction Company Construction Management Services 170,058
11/2/2011 Flintco Pacific, Inc.Construction 705,850
11/2/2011 Group 4 Architecture Research & Planning Architectural 57,826
11/2/2011 Group 4 Architecture Research & Planning Architectural 2,060
11/2/2011 Flintco Pacific, Inc.Construction 78,428
11/30/2011 West Coast Code Consultants, Inc.Plan Check 420
11/30/2011 West Coast Code Consultants, Inc.Plan Check 560
11/30/2011 West Coast Code Consultants, Inc.Plan Check 560
11/30/2011 Group 4 Architecture Research & Planning Architectural 2,051
11/30/2011 West Coast Code Consultants, Inc.Plan Check 700
11/30/2011 Flintco Pacific, Inc.Construction 119,803
11/30/2011 Group 4 Architecture Research & Planning Architectural 1,722
11/30/2011 Group 4 Architecture Research & Planning Architectural 57,826
11/30/2011 Group 4 Architecture Research & Planning Architectural 4,789
11/30/2011 Flintco, Inc. Escrow Construction 837,115
12/21/2011 Turner Construction Company Construction Management Services 187,775
12/21/2011 Turner Construction Company Construction Management Services 129,453
12/21/2011 Turner Construction Company Construction Management Services 233,061
12/21/2011 Turner Construction Company Construction Management Services 2,385
12/21/2011 Turner Construction Company Construction Management Services 109
12/21/2011 Group 4 Architecture Research & Planning Architectural 46,261
Protect Consulting and Engineering Hazardous Material Testing 12,699
Movers, Inc.Moving Services 19,853
Group 4 Architecture Research Architectural 1,239,715
Turner Construction Company Construction Management Services 884,501
Flintco Pacific, Inc.Construction 8,926,193
West Coast Code Consultants, Inc.Plan Check 720
Sign and Services Company 443,920
Sub-total - Engineering Costs - 19,834,691 11,527,601 (31,362,292)
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
8/31/2011 W. L. Butler Construction, Inc.Construction 22,712.50
8/24/2011 Flintco Pacific, Inc.Construction 987,123.00
8/24/2011 Turner Construction Company Construction Management Services 151,367.49
8/24/2011 Flintco Inc. Escrow Construction 117,936.00
8/24/2011 Group 4 Architecture Research & Planning Architectural 48,250.00 October 25, 2011 Report
8/24/2011 Group 4 Architecture Research & Planning Architectural 57,825.84
8/24/2011 Flintco Pacific, Inc.Construction 74,304.00
10/5/2011 Group 4 Architecture Research & Planning Architectural 37,305.95
11/30/2011 Group 4 Architecture Research & Planning Architectural 20,265.95
11/30/2011 Flintco Pacific, Inc.Construction 241,110.00
Moovers, Inc.Moving Services 117
Flintco Pacific, Inc.Construction 663,370
Protect Consulting and Engineering Hazardous Material Testing 1,375
Group 4 Architecture Research & Planning Architectural 25,601
Turner Construction Company Construction Management Services 66,200
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 January 18, 2012
West Coast Code Consultants, Inc.Plan Check
Sub-total - Contract Contingency - 2,434,117 756,663 (3,190,780)
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
09/30/11 FedEx Coding Error Correction (89) October 25, 2011 Report
11/16/11 Jarvis, Fay, Doporto & Gibson, LLP Legal Services - Mitchell Park Library 3,776
12/21/11 ZFA Structural Engineers Mitchell Library Review 2,925
12/29/11 Jarvis, Fay, Doporto & Gibson, LLP Legal Services for Mitchell Park Library 11,170
12/29/11 State Water Resource Board Permit 505
Bruce Beasley Sculpture 90,000
Group 4 Architecture Research Architectural 65,850
Constance Riedinger Legal Services 15,000
ZFA Structural Engineers 9,667
Jarvis, Fay, Doporto & Gibson, LLP Legal Services for Mitchell Park Library 10,053
Envision Ware, Inc.Sorter System 442,889
Bibliotheca, Inc.15,370
Sub-total - Other Contract Services - 202,127 648,830 (850,956)
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) July 26, 2011 Report
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
07/06/11 City of Palo Alto - Development Center Plan Check Fee 93
07/06/11 City of Palo Alto - Planning Plan Check Fee 89
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 133
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 105
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 137
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 133 October 25, 2011 Report
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 105
08/31/11 City of Palo Alto - Planning Plan Review - modify permit 121
08/31/11 City Of Palo Alto - Development Center Mitchell Library Plan Check 145
08/31/11 City Of Palo Alto - Development Center Mitchell Library Plan Check 277
08/31/11 City Of Palo Alto - Planning Mitchell Library Plan Check 40
09/30/11 City of Palo Alto - Planning Mitchell Library - Permit Revision 89
10/31/11 City of Palo Alto - Development Center Plan Check Fee 113
10/31/11 City of Palo Alto - Development Center Plan Check Fee 325
Sub-total - City (Inter-department) Service Charge - 287,282 - (287,282)
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)
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) July 26, 2011 Report
04/21/11 City of Palo Alto - Utilities Utility Connection Fee 68,559
Group 4 Architecture Research Architectural 129,300
9
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 January 18, 2012
West Coast Code Consultants, Inc.Plan Check 3,160
Turner Construction Company Construction Management Services 270,729
Movers, Inc.Moving Services 6,533
Flintco Pacific, Inc.Construction 3,351,922
Protect Consulting and Engineering Hazardous Material Testing 10,616
Sign and Services Co.44,392
Sub-total - Miscellaneous Cost - 71,571 3,816,651 (3,888,222)
Grant Total 49,043,000 22,829,787 16,749,744 9,463,469
10
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 July 26, 2011 Report
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
07/27/11 Group 4 Architecture Research and Planning Architectural 319
07/27/11 Group 4 Architecture Research and Planning Architectural 1,150
07/27/11 Group 4 Architecture Research and Planning Architectural 1,875
07/27/11 Turner Construction Company Construction Management Services 5,572
08/10/11 Group 4 Architecture Research and Planning Architectural 31,374
08/24/11 Turner Construction Company Construction Management Services 2,868 October 25, 2011 Report
08/31/11 Group 4 Architecture Research and Planning Architectural 117
08/31/11 Group 4 Architecture Research and Planning Architectural 175
08/31/11 Group 4 Architecture Research and Planning Architectural 248
09/14/11 Group 4 Architecture Research and Planning Architectural 67
09/14/11 Group 4 Architecture Research and Planning Architectural 600
09/14/11 Group 4 Architecture Research and Planning Architectural 39,218
10/26/11 Group 4 Architecture Research and Planning Architectural 5,000
10/26/11 Group 4 Architecture Research and Planning Architectural 235,308
10/26/11 Group 4 Architecture Research and Planning Architectural 878
10/26/11 Group 4 Architecture Research and Planning Architectural 5,000
10/26/11 Group 4 Architecture Research and Planning Architectural 291
10/26/11 Group 4 Architecture Research and Planning Architectural 27
11/02/11 Group 4 Architecture Research and Planning Architectural 78,436
11/02/11 Group 4 Architecture Research and Planning Architectural 7,500
11/22/11 Group 4 Architecture Research and Planning Architectural 8,514
12/07/11 Group 4 Architecture Research and Planning Architectural 62,749
12/14/11 Group 4 Architecture Research and Planning Architectural 12,584
12/14/11 Group 4 Architecture Research and Planning Architectural 79,172
12/14/11 Group 4 Architecture Research and Planning Architectural 12,584
12/21/11 Protect Consulting and Engineering Hazardous Material Testing 3,530
12/21/11 Group 4 Architecture Research and Planning Architectural 3,052
01/11/12 Group 4 Architecture Research and Planning Architectural 225
01/11/12 Group 4 Architecture Research and Planning Architectural 9,761
01/11/12 Group 4 Architecture Research and Planning Architectural 70,592
01/11/12 Group 4 Architecture Research and Planning Architectural 150
Main Library Activity Details (PE-11000)
As of January 18, 2012
11
01/11/12 Group 4 Architecture Research and Planning Architectural 247
Group 4 Architecture Research and Planning Architectural 318,113
Turner Construction Company Construction Management Services 84,394
West Coast Code Consultants, Inc.Plan Check 10,800
Protect Consulting and Engineering Hazardous Material Testing 13,140
Sub-total - Engineering and Architectural Costs - 1,407,565 426,447 (1,834,012)
Contract Contingency
05/27/11 Group 4 Architecture Research and Planning Architectural 22,152 July 26, 2011 Report
06/09/11 Group 4 Architecture Research and Planning Architectural 571
Group 4 Architecture Research and Planning Architectural 139,682
Turner Construction Company Construction Management Services 10,750
Sub-total - Contract Contingency - 22,723 150,432 (173,155)
Other Contract Services
Creative Machines, Inc.Sculptures and Light Display 90,000
Sub-total - Other Contract Services - - 90,000 (90,000)
City (Inter-department) Service Charge
Sub-total - City (Inter-department) Service Charge - - - -
Miscellaneous Cost
Sub-total - Miscellaneous Cost - - - -
Grant Total 18,000,000 1,430,289 666,879 15,902,833
12
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 g g
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
Working Person's Enterprises, Inc.Construction Services 30,649
West Corporation Temp. Lib. - Security Access Card & Alarm 1,910
Ross McDonald Company, Inc.Library Shelving 3,540
Sub-total - Contract Contingency - 33,500 40,858 (74,358)
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 56,420 79,132
Temporary Library at Cubberley (for Mitchell Facility) - Activity Details (PE-09010)
As of January 18, 2012
13
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 -$
Big-D Pacific Builders, LP Construction Services 344,356
Sub-total - Engineering and Architectural Costs - - 344,356 (344,356)
Contract Contingency
Summary of Expenditures as of July 21, 2010 -
Big-D Pacific Builders, LP Construction Services 38,131
Sub-total - Contract Contingency - - 38,131 (38,131)
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 - 382,487 117,513
Art Center Temporary Library - Activity Details (Project # PE-11012)
As of January 18, 2012
14