HomeMy WebLinkAboutCHANGE ORDER - GENERAL CORRESPONDENCE - 6604200CHANGE ORDER NO. 1
PROJECT TITLE: Revenue Model Services
CONTRACTOR: Economic and Planning Systems
PURCHASE ORDER NO.: 6604200
DESCRIPTION: Revenue Model Development
1. Reason for Change: Need for additional work.
2. Description of Change: Additional meetings and consulting
3. Change in Contract Cost: $2205
4. Change in Contract Time: January 31, 2007 completion
ORIGINAL CONTRACT COST $_35,060_
TOTAL APPROVED CHANGE ORDERS _0
TOTAL PENDING CHANGE ORDERS ,2,205
TOTAL THIS CHANGE ORDER _2,205_
TOTAL % OF ORIGINAL CONTRACT, THIS C.O.: 6.3%
TOTAL % OF ORIGINAL CONTRACT, ALL C.O.'S: 6.3%
ADJUSTED CONTRACT COST $ _37,265_
(Assuming all change orders a roved
ACCEPTED BY: DATE: %
Contractor's Representative
ACCEPTED BY: DATE
Project Manager
REVIEWED BY:
Title:
APPROVED BY:
DATE:
DATE:
Tit[
APPROVED BY: DATE: 7-to - J %
,;f Purchasing Agent over $30,000
cc: Purchasing
3 Date: 07/11106
Purchase Order Number: 6604200
City of Fort Collins City Of Fort Collins 7
Page Number: 1
. Delivery Date: 09/21/06 Buyer: O'NEILL,JAMES
Purchase Order number must appear on invoices, packing lists, labels, bills of lading, and all correspondence.
Note:
Line Qty/Units Description Account Extended Price
1 1 Lot 101-550101.529290 �FVtikt6e 17,530.00
Revenue Model Services
Per service agreement dated July 10, 2006
2 1 Lot 101-410500.529290 L4,jq f-- 17,530.00
Charges for this account
Total $35,060.00
City of Fort Collins
Accounting Department
PO Box 580
Department Copy Fort Collins, CO 80522-0580
Invoice
EPS Employer ID: 94-3056856
Invoice Number: 16843.7
To: City of Fort Collins \
300 LaPorte Avenue
P.O. Box 580
Fort Collins, CO 80522
Attention: Diane Jones, Deputy City Manager
G-
Project: Fort Collins Revenue Forecast
Project Manager: Daniel Guimond PIC: Guimond
Professional Services for the Period: I/l/2007 to IJ31/2007
Task Extra Meetings
Task Maximum:
Previous Billing Against Max:
Current Billing Against Max:
Balance After this Invoice:
Economic e�
Planning Systems
PON, Roane,
Re.1 F,J.Ic F,ouumi,s
R,gianal Economics
Land U- Paliry
January 01, 2007
EPS # 16843
Contract # P.O. 6604200
$2,000.00
$0.00
$1,904.31
$95.69
Professional Services
H , rs
Rote 'h r e
Daniel Guimond Principal
3.00
$210.00 630.00
Joshua Birks Associate
9.50
$100.00 950.00
Professional Services Total:
12.50
$1,580.00
Reimbursables
Charre
Car Rental/Transportation
$67.49
M ileage/Parking
$188.80
Per Dierr. Hotel
$68.02
Reimbursables Total:
$324.31
Total Task 2 $1,904.31
Total Project Invoice Amount: $1,904.31
�10C(.
-G- Y l kr t' a
•-�t�/l�':,�
.. bJ
�yfi`.,;5ry7s --^� [.:P+N`i..+'h.tT{...4,e ?� rt,."�"1°,} r" '� ,...�.i.S..A.'!✓
��"x,.t
/�� �R r p, .� b f, j' t s. 1s'�,w�t,r..
..' U`-'6..•'V"�'°+�'t 1 �'•...4f � "'.....^.._
111
���t. "i; t), ,.
,per'
L)
S A C `
R A M E N 7 0
R E R K E L E Y D F N
Page l of 2
v F R
2150 River Plaza Prise.
Sacramento C.1 9 S33
Suite 400 Phone: 916-649-8010 .. Phone: 510-841-91 )0 phone:
lax: 916 649-2070 111x: 510-841-9208 Fax•
303-623-3557,
303-h23-9049
+cww.epsys.nim
Economic e5
Planning Systems
Public Finance
Real Estate Economics
Regional Economics
Statement of Account Land Use Policy
EPS
Tax ID: 94-3056856 JUN � 1 7007
Date: June 05, 2007 C+fY !i ,
a9ers off
To: Diane Jones C(
City of Fort Collins
300 LaPorte Avenue
P.O. Box 580
Fort Collins, CO 80522
Project: 16843 Fort Collins Revenue Forecast
Manager: Daniel Guimond
Invoice
Payments/
Invoice
Invoice Date
Amount
Credits
Balance
7 1/l/07
$1,904.31
$0.00
$1,904.31
8 2/28/07
$300.00
$0.00
$300.00
Total Amount Due
$0.00
$2,204.31
$2,204.31
Accounts Receivable Aging Summary
Current l Month 2 Months 3 Months >3 Months
0.00 0.00 0.00 300.00 1,904.31
Qpg'(OUE
S A C R A M E N T O B E R K E L E Y D E N V E R
2150 River plaza Drive, Suite 400 phone: 916-649-8010 phone: 310-841-9M) phone: 303-623-3557
Sacramento, CA 95833 tax: 916-649-2070 fax: 310-841-9208 tax: 303-623-9049
www.ep5ys.a>m
From: Mike Freeman
To: Gill, Erin
Date: 6/12/2007 3:58:35 PM
Subject: Re: EPS Fort Collins Revenue Forecast
Erin, these are fine to pay, please pay out of the original splits, thanks.
Mike Freeman
Economic Advisor/Interim CFO
City of Fort Collins, CO
(970) 416-2259
mfreeman@fcgov.com
>>> Erin Gill 6/12/2007 3:37:00 PM >>>
Mike
A PO set up payable to EPS, for the Fort Collins Revenue Forecasting, amount $35,060.00 (per the work
order), has been spent in full. I have attached 2 outstanding invoices still owed for this Revenue
Forecasting PO.
Dan Guimond claims you orally authorized the attached invoices to be paid in addition to the $35,060.00
PO amount.
Is this correct?
If so, would you like the attached invoices to be paid out of:
101-410900
Or the original split 50150 PO accounts:
101-550101 Finance
101-410500 Budget
Thanks,
Erin
Economic V
Planning Systems
Public Finance
Invoice Real Estate Economics
Regional Economics
EPS Employer ID: 94-3056856 Land Use Policy
Invoice Number: 16843.8 February 28, 2007 .
To: City of Fort Collins
300 LaPorte Avenue
P.O. Box 580
Fort Collins, CO 80522 FINANCE'07MAR1910117
Attention: Diane Jones, Deputy City Manager
Project: Fort Collins Revenue Forecast EPS # 16843
Project Manager: Daniel Guimond PIC: Guimond
Professional Services for the Period: 2/1/2007 to 2/28/2007 Contract # P.O. 6604200
Task 2 Extra Meetings
Professional Services
Joshua Birks Associate
Professional Services Total:
Task Maximum:
Previous Billing Against Max:
Current Billing Against Max:
Balance After this Invoice:
Hours
3.00
3.00
Total Task 2
$2,205.00
$1,904.31
$300.00
$0.69
Rate Charge
$100.00 300.00
O7AA AA
$300.00
*** Total Project Invoice Amount: $300.00
APerl Receivables:
Current 1 Month 2 Months 3 Months >3 Months
$300.00 $1,904.31 $0.00 $11,360.00 $0.00
P
S A C R A M E /� T O B E It E L E Y DEN V E Rage I of"
2150 River Plaza Drive, Suite 400 phone: 916-649-8010 phone: 510-H414190 phone: 303-623-3557
Sacramenlo, CA 95533 fax: 916-649 2070 fax: 510-841 9209 fax: 303-(i23-9049
wwwXpsyt.eom
Jun 12 2007 10:59RM HP LRSERJET FRX
P. 1
s
Delia Cruz
From: Dan Guimond fdguimond@epsdenver.comj
Sent: March 27, 2007 4:5
To: Delia Cruz
Subject: RE: Project o. 16843-City of Fort Collins�4
,V
Please have her contact Mike Freeman CFO in the City Manager's office who authorized the additional work on this �'
project. - Dan
Daniel R. Guimond, Principal Pvv& mo_ocxo2r
Economic & Planning Systems
73017th Street Suite 630
Denver, Colorado 80202
303-623-3557(P)
303-623-9049 (F)
-----Original Message ---
From: Delia Cruz [mailto:dcruzoepssac.coml
Sent: Tuesday, March 27, 2007 5:13 PM
To: Dan Guimond
Cc: Judy Pernell
Subject: Project No. 16843-City of Fort Collins
F0-*-t0(XL-* i?"00
Post-ir Fax Note
7871
Dateif I Ro
Pe98y�
To
From
cow
(�
Ana x
,4,
Pho.a. °II b
ex# _
�e
FaxK .y3
Hi Dan,
I got a call from E#in, one of the Finance Staff from the City of Fort Collins. She is telling me that our budget for this
project was only $35,060.00; ref. P.O. No. 6604200.
Per our record, this client was invoiced for a total of $37,260.86 as of
2/28/07 and already paid a total of $35,056.55.(see attached) Therefore we need to ask another P.O. for the remaining
$2,204.31 so that EPS can collect the last two invoices.
Please let me know your comments because I promised to give her feedback by tomorrow.
For your disposition.
Thank you very much.
Delia
Delia Cruz, Accountant
Economic & Planning Systems, Inc.
(916)285-1943 direct
(916)649-8010 ext. 943
(916) 239-6270 fax
Because information exchanged by electronic media can deteriorate or be.damaged, lost, or modified intentionally or
otherwise, use of this electronic data by anyone other than Economic & Planning Systems, Inc., shall be at the sole risk of
such user and without liability or legal exposure to Economic & Planning Systems, Inc. The recipient is responsible for
verifying the accuracy of electronically received data against hard copy documentation; if there is any discrepancy
between the hard copy and the electronic copy, the hard copy will govern. Recipient assumes all risks in changing or
modifying data and revising or updating hard copy documents.
EXHIBIT "B"
Budget and Work Schedule
EPS proposes to initiate work on a time and materials basis with an initial upset limit of $35,060
for Tasks 1-7. The approximate allocation of time by task and staff level is shown in Table 1.
The short term revenue forecasts (Tasks 1 and 2) will be completed by July 21, 2006. The
second phase of the project will be completed within a 90 day time period.
Table 1
Estimated Hours by Task
Fort Collins Revenue Forecasts
Description
Project
Manager
Research/
Associate Production
Total
Hours
Total
cost
Labor
Task 1: Project Initiation
8
16
16
40
$4,160
Task 2: Trade Area Economic Base
4
8
16
28
$2,560
Task 3: Short Term Revenue Forecasts
8
40
24
72
$7,040
Task 4: Retail Sales Model Refinement
8
32
24
64
$6,240
Task 5: Retail Sales Forecasts
8
24
24
56
$5,440
Task 6: Other Revenue Indicators
4
16
16
36
$3,360
Task 7: Reports
16
16
16
46
$5,760
Total Hours
56
152
136
344
Hourly Rate
$200
$100
$60
Dollars by Person
$11,200
$15,200
$8,160
$34,560
Expenses
Local Travel
$250
Miscellaneous Expenses
250
Total Expenses
$500
Total Labor and Expenses $35,060
EPS will bill the City for actual hours worked and materials used, not to exceed $35,060.
Standard Professional Services Agreement- January, 2005