#11-5616 Change Order #4 (Method Factory, Inc.) CHANGE ORDER
CHANGE ORDER NO. 4 CONTRACT NO. 11-5616
BCC Date: 10/12/10
Agenda Item: _16F5
TO: Method Factory
1005 North Orange Ave.
Sarasota,FL 34236
DATE: October 28, 2011
PROJECT NAME: GovMax Upgrade
PROJECT NO.: 50001
Under our AGREEMENT dated October 10,2010
You hereby are authorized and directed to make the following change(s) in accordance with terms and
conditions of the Agreement: Add Statement of Work COL2011_I, COL2011_3, COL2012_01 and
COL2013 01 attached.
FOR THE Additive Sum of: _Eighty Thousand Seven Hundred Fifty Dollars ($_80,750.00 ).
Original Agreement Amount $ 153,875.00
Sum of Previous Changes $ 8,875.00
This Change Order adds $ ' 80,750.00
Present Agreement Amount $ 228,500.00
The time for completion shall be increased by _731 calendar days due to this Change Order.
Accordingly, the Contract Time is now 1,219 calendar days. The final completion date is
_2/18/14 . Your acceptance of this Change Order shall constitute a modification to our Agreement
and will be performed subject to all the same terms and conditions as contained in our Agreement indicated
above, as fully as if the same were repeated in this acceptance. The adjustment, if any, to the Agreement shall
constitute a full and final settlement of any and all claims of the Contractor arising out of or related to the
change set forth>herein, including claims for impact and delay costs.
Accepted: // /1 , 2011
CONTRACTOR OWNER:
MethodFactocy-Inc. BOARD OF COUNTY COMMISSIONERS
OF COLLIER COUNTY,FLORIDA
By: _ y
Scott Auer, I erector Susan Usher, Project Manager
11-5616—Method Factory GovMax Upgrade 1
Change Order#4
DE' - ,/DIRECTOR
By: � ,i
Ma, "Isac ion
CONTRACT SPECIALIST
By:
Lyn l4. d
Date: ig//3/, /
P-iiMl
ATTEST •LL " ��•3 ��4 AD BOARD OF COUNTY COMMISSIONERS OF
COLLIER COUNTY FLORIDA
II •':ht E.:Ba ck l� +-,4► ",
14. Cia-ak
BY > ANEW BY:
tor ► " ; :T' Fred W. Coyle, Chairman
teleitdre
Approved : "-Td Fpiin
an. -gal Suffcienc,"
Print Name: SCOTT R. TEACH
Ass' t County Attorney
env
11-5616—Method Factory GovMax Upgrade 2
Change Order#4
Ekivillax
?arers Sarasota County Government in association with MMethodFactory
Statement of Work: GovMax v5 Discretionary Support
Client Name: I Collier County, FL
Project Name: GovMax v5 Discretionary Support
Proposal Number: COL2011_03
Date Prepared: 10/24/2011
This document outlines the ad-hoc support arrangement with Collier County, FL for GovMax
V5.0.
Ad-hoc support tenets:
The ad-hoc support arrangement does not commit Collier County, FL to a minimum number of
support hours per month. As such, MethodFactory does not maintain a support level agreement
for this project.
MethodFactory will bill monthly for:
• Technical and/or end-user training
• Custom data imports
• Custom data exports
• Custom report development
• Collier County, FL application enhancement requests
Requested Items
Description Hours
None
The hourly rate for application support is $125.00. Billings for issue management will be
associated to issues within the GovMax V5.0 issue tracker.
Any issues that have development effort estimates greater than 24 hours or would result in
significant functional changes will require the generation of a Statement of Work(SOW)and
signature approval by Collier County, FL. Any SOW's will include estimates for development,
testing, documentation, deployment and project management. All time required to research
issues and generate SOW's will be billed as part of the issue management process.
Recommended Discretionary Support Hours 120
Discretionary Support Cost $15,000.00
Project lead (signature authority):
Support hours in PO: 120
PO Number:
PO expiration date:
Payment terms: as per the Master Services Agreement
Collier County, FL Designated GovMax v5 Support Contacts
Evfl]ax
Partners Sarasota County Government in association with MMethodFactory
As per the GovMax v5 support process, Collier County, FL may name up-to 4 contacts with the
authority to submit service requests and obligate Collier County, FL to pay for requested services.
The GovMax v5 Support Administrator will maintain a list of client representatives that have been
authorized to submit services requests. As a control, requests submitted by other than the
named individuals in the grid below will be referred back to the client's primary GovMax v5
contact.
Name e-mail Phone
1. Susan Usher Susanusher(acolliergov.net 239-252-8810
2. Mark lsackson MarkIsackson0colliergov.net 239-252-8717
3.
4.
All invoices will be mailed directly to the Project lead designated above*. The Project lead is
responsible for ensuring that all invoices are submitted to Collier County, FL's Finance office and
that the payment terms above are met. The Project lead is responsible for notifying
MethodFactory of any invoice disputes prior to the expiration of the payment terms listed on the
invoice. The Project lead agrees to be the single point of contact to MethodFactory for the
resolution of any billing issues.
Approval of Statement of Work
Project Name: GovMax v5 Discretionary Support
Proposal Number COL2011_03
Collier County, FL MethodFactory
Name: Chairman Fred W. Coyle Scott Auer, Partner.-- -- —�
Date: \"\131∎1 /1)/3)
Signature: `iT L�- - G ,8ik
Collier County Attorney Attest
Name: SCOTT R. TEACH !DWIGHT'"V,.o'lkklbeil ', . CLERK
Date: \a131� L � �"
ttio,a)
Signature: ff.
t�1
Attest, �to( `(81 s
•
1VMETHODFACTORY
„„„terne,nt prowess
Statement of Work: COL2011_01 GovMax V5 Enhancements
Client Name: Collier County, FL
Project Name: GovMax v5 Enhancements
Proposal Number: COL2011_01
Date Prepared: 08/16/2011
Modified: 10/25/2011
n
Ak
METHODFACTORY
implement, progress
Contents
Work Description: 3
Ticket#05252 -Account Export does not contain or include the Annualized amounts 3
Ticket#05253—New Report—Proforma JL Code Report 5
Ticket#05254—The customization of entity titles for Org Code and Account Objects is
incomplete. 7
Ticket#05257— New report—Security Report 11
Ticket#05258—New report—Performance Measure report 17
Ticket#05261 —Work Scope Enhancement 18
Ticket#05262—Add the program to the performance workspace under the business unit and
move the program indicators onto the programs 20
Estimation of Work 34
2
COL201101
S3 - °.5.2099 vvw.ineti o.:f.,ctory.com l C 2010 Metn dFactory.All right >=rvad.
/i
METH ODFACTORY
implement.progress
Work Description:
Ticket #05252 - Account Export does not contain or include the
Annualized amounts
MethodFactory will add the Account Annualized budget field to the Account grid and add it to the
Account Export file format.
The following budget value located on the Account Information tab will be included in the Account grid
and Account Export.
Information s��om Nrrt as„ .r9."; ... .,2:1;,/,--,, ,
Fund Center 101522-301-0mb Capital
Commitment Item 763100-Improvements General
Annualized: 1
Show Details
Below are the account details for the selected account.Select a forecast budget year to view details specified for that year
S Hew r`•..Delete More Options 122=1 IS
Description A.Code Name JL Code F`t`2012 FY 2013 FY 2014 F "2015 FY 2016 FY 2011 Act
50001 Proj Budget 5100.000 SO SO SO SO 590,750
Account Grid
I
3
COL2011_01
82-._,45.2699 i www m ethod`acmry 0 n 2010 Me"D 0Fect rr, A rig;;s resenged.
Aik
METHODFACTORY
implement.progress
wa rm, .n rt V�E',1 a a
Expenditures I" i» �� s. V . .i41-:: ' 4 a 0;
r
t 1. i 1 31. 2 tax:. _
,.'G Fund Center `"` ❑Exact Search Reset
la Edit cry'Refresh List
Fr 2315 ,2010 F1-2011 A.dcpted Fr 2311-•n'iended F!2311 tactuai F`r"2011 Encumbrances FY 2011 Balance Fur
SO 5379.929 5378.470 5373.470 5125,204 SO - $253266 1
SO $291,142 $309.193 5309.193 5106,633 SO $202,555 E
SO SO 50 S0 SO SO 50 E `.
SO $904 SO SO S180 SO -$180 E _
SO 50 SO SO 50 SO 50 E
So SO so so So so 2011 Annualize so E
$0 $2.086 $0 SO 50 50 50 E
$0 $0 $192 $192 SO SO $192 E
SO $50.012 $52,614 $52,614 $17,200 $0 $35,414 E
SO $38233 $36,485 536,435 $14,552 $0 $21,933 E
50 $52,060 $87,820 $87,820 $17,911 SO $69,909 E
SO $116,094 5125.070 $125.070 531,268 SO $93,803 E
SO SO $11,100 S11,100 SO 50 511.100 E v
4 ?'
I4 4_1F-1 1 2 3 4 5 6 7 8 9 10 .., : ► N 20358 iter- in 408 pa}=_r
Account Export
Confirmation
T2"'z^t `r F2\3'14 F. Fi' F- 011 r r 2011 32011 FY d0l 1 F 2011 mound Cent'�
FY 2012 2015 FY 201Q name
game X093 2416 «dopted A3lended Aciuel Encumbrance alance
Board Of
rle3
ed 378525.00 0.00 0.00 0.00 0.00 379928.97 378470.00 378470.00 125203.88 0.00 253266.12 County
ats Commrssei
Board Of
I Securty 53069.00 0.00 0.00 0.00 0.00 50012.20 52614.00 52614.00 17199.94 0.00 35414.06 County _
hag Commissioi
Board Of
ance For 0A0 0.00 0.00 0.00 0.00 903.75 0.00 0.00 184.00 0. 180.00 County
Phone Commissioi
2011 Annualize Board Of
bursement 5000.00 0.00 0.00 0.00 0.00 5799.42 5000.00 5000.00 2409.25 0.00 2590.75 County
lar Commissioi
Board Of
[Previous' [ Export Finish 1
4
NketFq Fa y. _
COL201101
mr, ' -- ,ct „�av,.%ethodfa dory-cam [010 V - rac' ,.tl rigirU reserved.
A METHODFACTORY
implement. progress
Ticket #05253 - New Report- Proforma J! Code Report
New Report—Proforma JL Code Report
A new report is needed showing the data by JL Code, revenues and expenditures—Proforma type of
report.
Below is an excerpt of our Budget Document. This section is"driven" by JL Codes.
FY 2012 FY2012 FY2012 Ff2012
Program Summary Total FTE Budget Revenues Net Cost
Departmental AdministrationtOverhead 0.50 212,094 216,600 -4,506
Funding for departmental administration and foxed departmental
overhead.
Maintenance,Repair,and Acquisition 23.50 4,340,421 4,394,600 -54,179
Maintain County vehicles and equipment in excellent operating condition
with a minimum 95%availability rate.
Fuel Services 2.00 6,103,878 6,107,800 -3,922
Ensure cost effective,dependable,and timely fuel services are provided
for County vehicles,equipment,and emergency generators. Refueling
stations maintained to exceed 99%availability.
Reserves - 77,900 77,900 -
Maintain sufficient reserve funds to cover contingency requirements. '
Current Level of Service Budget 26.00 10,734,293 10,796,900 -62,607
We would like a report that we can run which will give us the above information,so that we don't have
to run and re-run the Budget Documents.
We would like the option of running this report by Summary(above)or Show Line Items.
Report Detail: I Show Line Items J
ShoN Line Items
Summa OnI
The report needs to run by"PROGRAM" .
Summary Only format:
We need a report similar to the above,where...
• the JL Code is the driver
• Revenue and expense totals are side by side(as shown above)or in close proximity to one
another.
• Report should display the JL Code number(xxxxxx-xx)and title
• FTE totals are not needed in the report
• Depending on how difficult it is, including descriptions is optional.
5
COL2O11 of
t p.esy ,.8-.34'.2699 r ,vvev.--,t,r7rdfar terv.norm _Z01Q r vthod Fdctorv.All rights reserved.
1 \
Ak
METHODFACTORY
implement progress
• Report will have 3 columns, expenditures, revenues, difference and the data will come from Out
Year 1(the year we are budgeting).
Show Line Items format:
• Within a JL Code,display Expenditures first,then Revenues(similar to the Capital Project report)
Project Line Item Budget Proforma
60044 Oil Well Rd,Immok Rd to Everglades
163@73.313 Surplus Gas Tax Road Construction 761200 Easement 0 0 1693,003 0
143473.313 Sirius Gas Tax Road Construction 743100 Improvements General 0 7.075.732 7.375.700 137.000
Expenditure Totals 0 7,075.732 8.938,700 137.000
143473313 Surplus Gas Tax Road Construction 334492 Grant Proceeds 4,834,530 4,8395003 4,839.543 0
Project 63044 Variance: 4,839,5570 -2.239,232 -4.102.200 -137.000
• JL Code and title should be included in report
• Expense and Revenue OrgCodes and Account Object Codes should be displayed.
• FTE and descriptions are not needed in the"show line item" report.
• The columns to be displayed in the report:
o Out years 1 to 5.
o History year 1 and 2 do not store their information in JL Codes so these columns are not
needed.
For both reports,show only funded account dollars.
6
Vh-thodFactO ry Inc COL2011_O1
m p.c^�� 9� x.25°9 wv r. 'erhod`a�mry.ccm ... 2010 m,t,,dr, r, ., •Igh.s reservee.
A METHODFACTORY
` implement,progress
Ticket #05254 - The customization of entity titles for Org Code and
Account Objects is incomplete.
The customization of entity titles for Org Code and Account Objects is incomplete. (ticket 4195).
Account Object or Object Code should be renamed to Commitment Item.Org Code should be renamed
to Fund Center
Below are all the exceptions.
Where? What needs to be changed?
.... .,.... Y! Mnr Org Code d '
n arch drop-down list-
-� e Yd ""G
vrk ,
4F.1 Positio 1 '., : ,: .?s r ,a a ^' A x'?�, " - ,1 1 . t .��4�.Y , _
2 Position?IBudge t SApliit b s = uy , ' ya �:a *. e Org Code and Account Object
'''''''''t6'''s X . a r h a
O5
rg Code and Account Na
me 3 Position Additives Tab . ' ` . c' '"vaH +k k xe q ` ,F . F is&ff: w ;: ; 's*' t 9, ''' , Account Objet 4 Work Scope main page
7
COL2O11_O1
,�ems;t,progr<.,s, SAS-�d5.26°9 wivw.no thodfactory.curs 'C.2010 MethodFactory.All rights reserved.
Ak•
METHODFACTORY
Implement.progress
Positions:
Where? What needs to be changed?
Position Search deop=do*nl!St",„:'-r::'pk' ,;titi;:r,;k.v''',2.-,':':!A1?...:::$:I'°,: litl,,p,,rg,,C,,od ;"::,'*''-'z;;';".,,,,,,:,'::;,ftK:;::.,',',,,':.:4",.:,...trir,::,:j!:.:!::t.,i,.,.:,,,,T;:,.,$:vt;;I..F1.::,,,,,..o.„,,,,;i,,,„,.,_-g.,,-,,,,s=aji::,it,r4,::,,:,,,,,:„?.:.,,:..,
Position Budget Split tab Org Code and Account Object
- -"----',4--''' ' 44"0:"-r- ,'k•;4,..-"N..`"*"';'1.4'1'Org Code Account NainO:ft'te.,:i,,-;:,„
Position Additives Ta.IY...7,,,,, ,--',-,.:--,1,-,,,7;li,...,-,!--,t'Vii,,1;,0.,....,' "`::TA":- -- --.,,, ,-......----,„--,
I My Default Work Scope ..d Logout'9 j
ing I Position 13udgeting
- -------- ----
,
i.•'',-':-",'-;=,_'-'/''''''-.'tjj:.' '''':'li'';''.''''' ''ij':'...,:ci'''-;-'''1': -_,'r-•' : "; y '. :;'-f.;'..:4:-:, -,--;:-'"*.""..:` i
All Positions *Positions' .: ,r.-_,...', -;-,,,,_ ,r,,?„,,.,., . ,z4„:,..,-A,,,,4-,,,-,„.„..,.:„.
-,'`,,,,.: 'Position Number A I r Exact Search Reset
-. Please select..
IEI Edit '' 'Budget Status
Poston Nur Class Jot Trtle FY 2512 Budgeted F,"201
Incumbent
50000470 4150,749 1
Job Title Ultector-Pubic Utkim Engineering ■ I:
".Z.' 50000471 IMEN1111111111111111111111111111111 Director-Solid Waste 4134,101 1
▪ 50000472 Position Number Manager-Utility Billing&Cust Serv. 5123,586 1
-.D.: 50000473
Position TStanding Manager-Environmental Complance 479,243 1 _n
Ti---1 50000474 MCIYte..LAR RALPH Equipment Operator.Senior 467,207 1 I ,
8
jr COL2011_01 ,., ,. ,. _,,,. , ,,,,
jib& METIODFACTORY
implement.progress
Home , Budgeting I Position Budgeting I Position 1 My Default Work Scope
Budget Splits vt )tfnt5 .
Position Expenditure Detail Defaults:
Organization Code: 210155-408-Public Utilities Planning&Proj
Mgmt
Account Object: 1512100-Regular Salaries
Setup the default account detail values for the splitting of the additives expenditure default items...
JL Code: 1090203-10-Departmental Administration
JL Object Code: I Please Select .
Grant: 'Please Select. .
Budget Issue: 'Please Select. .
Service Level: 11 -SL 1 zj
Save Split I
__........
Home Budgeting I Position Budgeting I Position I My Default Work Scope J Logout
J L.„Ii o tton; � ustom,�.� ��..� Additives � 1�etltems
_.
Sp,;!:_`;c i i t t,r 'Additive Code .z. I r Exact Search I Reset I
Additive Code Name Ocpect Code Account Name Ad
j COLA COLA Adjustment 519100 Reserve For Salary Adjustment CC
DC15 Deferred Comp 51,500 match 512600 Er 457 Deferred Comp Fri
Work Scope:
Where? What needs to be changed?
t1181n d t` ' ' "' ACCOUII .�b ��ra 'tttt 1Z td »
9
C0L201101
26■9 1 v+v, eel?odfactory.coin c 2010 Meth odff-atory.AU rights reserved.
. . , ..
Alk,..,
-1.-
METHODFACTORY
implement.progress
Home :. My Work Scope I My Default Wor
7;titilz My Work Scope
,,,..-.knit-,,,-..9..t•
Select a Favorite Work Scope:I My Default Work Scope j ...)New
1„,..i.,.. ...,....,„
The followins items are included in the selected work scot-. To manase the work score tress s
Edit 1.7. Refresh List
Entity Current ,Assigned
Account Object 1860 1860
Budget Issue 2 2
Capital Project 543 543
Grant 24 24
Fund Center Code 1339 1339
Position 2154 2153
10
C01_201101 , _,_.1
,,,.....,)1C,Methodr":3;;I:15 All-Ignt,reser,L
A METHODFACTORY
implement.progress
Ticket #05257- New report- Security Report
Ticket#04277 requested that a new column be added to the User Security screen displaying additional
information provided in the Description field or create a new field where a Department name could be
typed in.
Settings I System Settings 1 Security I User Management I°me Z Logout 9
User Management
a New Delete More Options
-as,%Erne Frst':a-e Role Description/Department
r 2, I train System Administrator
r it, Adams Steven Budget Tech View Only
r rm Allen Deborah Budget Tech View Only
r 24 Alonso Hedede Budget Tech View Only
I
troGS 1 sruern Sethrtas I S.aattr I Uw M.eup«nsnt rr i;iti . Loomis 4)
User Management
„ t.,,„., ,. i;!tpae*mantt I rum,held I
User Same' ( • Main Phone: kl- 2 E623
First tame:" tever Other Phone. I
Lott Name:' lAdamn Mobile Phone: 34-2c)3a-t1
Primary E-mail' teaerrawnh?c#hergo,net Fade: F.44 eiie
Cadhm E mall° IStinerAdams,tcoiberge:net Secondary E mail: I
Active User: ■ User Rot.' Rietne!Teen Vow Ore .J
Reset Password: Menet Pom I Reset WOrltscopas.9 Rasat'N en Scenes st trwt Iti
ipsion
tEltC PTER J
Edited by Scott Auer on Wednesday, March 23, 2011 at 8:49 AM
We'll consider it again when looking at updating the user management
workspace in the future.
Edited by Susan Usher on Wednesday, March 23 2011 08:44:20 AM
i am extremely disappointed.
i will need to think of plan B.
Edited by Scott Auer on Wednesday, March 23, 2011 at 8:03 AM
Unfortunately after further review the user management screen does not
allow for customization. Request can not be accomodated.
11
COL2011_01
.2,,c v-. ,c_ A g,'-'s reserved.
A METHODFACTORY
implement.progress
There are no reports on Security,there are no exports on Security. There is nothing to"grab"which
shows me the Users,their depts.,or what they have access too. There is NOTHING.
We need something...a report,an export,something to help us determine who has what without
opening and closing 160 Users.
New Report or Export should display the following:(in order of Priority)
(Scott,Rachel and I worked on the Report Specification document and have come up with the
following...)
Report#1:
• Selection will be on User or"all users"
• Report will display User name,Role, Description field(I typed in the dept name here)
User litsisiveitwet
rve Wow" FA... Oa...PP.*
tall Moll*` kit., **is Fre.* V,:. i'
C.NYn.F..it i it ar s..r.i.q i+r..r r
4w..skew. G �rAw it. �ta.llri -..u:Mr
a..w Pons! Fowl Paw?*j fOYt[NAKM•s IF.,. `.n.t»..1,sve
ITT
• Fr__
the DEFAULT WORK SCOPE tab, list the available (checked) BC and BU assigned to the user
or if the"Assigned OrgCode Only" box is checked. (include the BC/BU titles)
— r ': "x'= CNtn+M Ytcrs:cope . 'A
y�am�,.. .�,.. >..._ ....,�_
Use the lone below to caeiqure',hW OW SC 0C4 ft:*the yew To confquro this scope horn an chtatthq users sc
select the user bc,r the C'o deem bat bete*and r#eie Copy
Charming a user's Moue woe-twee.will remove eel of Mee custom weeliscopvat
Copy from User. Itrar,I !J
18yinese Ceram I I
leueineee Unfl 114
[r Ass■yted i?r9arramonal Codes Oreyl Com"CAWS. I
Report#2: (Assigned OrgCode Only)
• Selection will be on User or"all users"
• Report will display User name and Description field
• List of OrgCodes assigned to the user and OrgCode titles.
12
COL2O11 01
r.r r-rt pragres, 88 i.'-- ww N.met h o d facto ry 11 2010 MethodFactory.All•ct to■•sened.
Ak METHODFACTORY
implement progress
1r,tue Wn. $<Ope Aseigeed Poteee Upe Pe‘tultedi
I.,42,evto tear rr.10.4i Le.04010't th. -,tr•*Jae.%)a,td. mkaNgf 0,el,. It 4. the
••,tt, ,t lee ze. vot EA;3sPa.,-' ,,e 0*1 3stte, G.,"•
e‘..14.2 the,new,,,,a4.4 41.et. 'VI 41
coao r swats Rasa J i !
•
t
• Please filter out the retired OrgCodes. (Active OrgCodes=Yes.)
8udgetin0 Looltuois
r mad Lem.
t sad coma%lease
OP 0.4 7.1
c.s1 Comm*Way ta te7;4A
fiesta..
Buseetet or.*
Provo,. rat.,Exew.?..-etum *.
r111■0**11 L,At4V■11{1
HA Cob
Departereeet
trn1•44 10 i4 Owe*.Mts.
so ans.
Champ,Rate
Ihoed(weer Stews 777-.'n
Report#3:(lookups)
• Selection will be on User or"all users"
• Report will display User name
• By each LOOKUP tab,Yes or No,are any of the Create, Edit,or Delete boxes checked? It does
not need to tell what is checked,just if something is checked.
Uses atabase Access Navtgatton Aivess °Ole - fleet& • Scope PerforrnanceWo Scope
c;:x Lookups 177E;p4tpipti4.i.
Budgeting Capital Projects Position Report
Read Create Edit Delete
Select All
Budgeting Settings
Account Major
Arrni int Minor
Report#4(Capital Projects tab)
13
COL2011_01
Mrqr odta tory AP
AlMETHODFACTORY
Implement.progress
• Selection will be on User or"all users"
• Report will display User name
• From the CAPITAL PROJECTS tab,does the User have"View Only"or"CIP Category Manager"
E r r'.- " Act ;' c a _ ''''F'77.heck- "i' ,t=
'---' t Capital Projects
User Type: I View Only J
Vieaj Ono,
`Required Fields CIP Cat-•• Man-ter Locks I Clear Profile I Apply I Save
• List of Assigned CIP Categories
The new Security reports will be placed in a new workspace under Reporting called Security Reports.
Reprwting
r
Budget Document Budget Issue
gaFCrs docuinants used t:p.a..:-try* i`i `r i':9ta f*SC*'s a+'a4auw*Cr ae ar0nc alaty:a
Pom.a1Ua1 Badge Boast or C1:CUmenls 42 113212211 2111/24124,9& get 3122 recces,44.1audns
V'4:41 ClesctrtatAns these rflO is are ref Sic,5-, sssues an 04422 as rrarcamnt0s'0 currant
'.v-.5 xxes earn
Capital Projects a Expenditure
fi.V4411 b td 41'00 mill 11*, ., tr t td t.,.j.*t tg F*aot/rt;rra,K.,,..4.-S,..41s t Atooit"he 1,44,4.01
,.044141 I tttt4wtg.anato 'rt f4. 11, 404 g.rnM?Aef *41.,*.,fl ewe«« 41,410.4 .:.rn*41an,tdl r:s.„:
1,442.1 tnG 22241 1141 n th.S.t 0'i1 44 446,4:1 +11:0-0;,.7',lart0e5
,e.the ittl LAttons.r to,.I.i0 PrbiP:is cot..
Fund Proforma Grant
+t?
*e r -i-i-ixcnery and Del./0 ora:.ts a.a.atk tor tare ,,f101,1^vaYb a.aiaCie ID,vole+tfrvj analrvng 44.
ri..er t.aianc.+q Funds F.r4'?aatss4ss and Swtoce t ;.!'neon,t;taMt
Lewitt
Position ' `. Revenue
!,:Mori Hac49 rorraY:10 011102 114 Leto,'wan data{1ry�� 'anus raccn 1xYl4ta to 4,000104 vwa wtn 4010
cti',,11.1•1+' ana^454s .ai^r'Cni'.laao11.44 set-x0.000 154,011.rw:cxrrn4114,110,w4
,,,,,r a-,raced: 94'r r,rorans
tipStrategic Performance -- Custom
r*Jarlra. tOot ttrt.441 t.,143 t,t w+t^i 0100t.*Mt L__J °,,ttoo,rr{7tal('1,005 TS...<42411 44 4
.1.1111212 19 watoornS Plan+Pe15teloe}.du;t..Ftt t$see to wt,%is,' t8
_,......ets•:g tjttt.r.*!.rs 44r14*4e!.21;1 SCV.eta.e
al tr.'.a;n.Enta.rr,.•I.E,Its:,.a.
Arlik Queued Reports ( Lookup Reports
Illir tr,a9ts t e AtisTG4;1ed,!cods
Pro.the 1011.sn*ear 3410 r 3.001 tow at
t-' se:A.04 Rkp3Its
Access to this workspace will be managed through Role Management through a 'Access Security
Reports'option from with the Reporting area.
14
COL2011_O1
_ :5-?649 ovaw.methodfact o'y 111 _-U 10 V he'Factery.All rights es<r,-d.
A METHODFACTORY
implement. progress
Role Management
Details Members Settings Area . Budgeting Area 1 Reporting Area Budgeting Phases Performance Area
Reporting
17 Access Lookup Reports l Access Position 17 Access Reporting
0 Access Security Reports
?
liequired Fields Apply Save I Car
Report#5
User Management
-,---..---- .---.- :-----A-rLer---'.. --__, -is 1.! i 1
— - -- Performance Work Scope ,
,.- VSet,. .....,..:. 1,•?.k!e!..,.. . 5-ir'w„..4t?'
Copy from User: I Please select Z.J Copy I
- - i• i - .er select from the items below
Performance Work Scope: 'Business Center_, .7.1
Report should state what the
I Core Services:
l selections are for each
I
I Business Processes: category and which Perf .....1
I Process Activities:
I WorltStope. ...i
Comma Changes l
And just like the Report#3,a yes or no, if there is a check mark in the create,write, or delete box
1S
COL2011_01
n
METHODFACTORY
implement.progress
'eon Ana SeiNt>ai ,< Cn+a6 Pmad tj War Oslo*
(Magsua Lot* r I r r r
. ,_ �___ �.- — _
incur Ina Ktata.Data r I. r r r
':Iew Eivaget rpoitars r j r r r
...:,enac es h:8er r 6 r r
*naltanga r I r r r
' ncert C .Lore,* r I r �..T r r
Ebi.v able 1 ig r r r
tdeast.a .._..........._._, v_._ r 1 r ___, r r
oti,,..t..e r l r r
y
,,..,rs 1 I r r r
•RLiN«ii PteC@tatee FS,t,on r_.._ I r ----r r
E*.S,naii Plan r 1 r r r
chatw�ge r $ r r r
birasve r I ri r r
1
c,gectn* r 1 it r r
Ciwnats r 1 r r r
P,roc aas:.ctnat,F-, A-t.ae r 1 r r r
Crate+ a r 1 r r r
/thaw* r 1 r r r
Utioctua r 1 r r r
6.-,.,, r d r r r
t
colort as r aaw tallama,a aIMIlli a. 1 $MAW*n.... :..a 1
16
Method!actory,Inc. COL2011 O1
A METHODFACTORY
implement progress
Ticket #05258- New report- Performance Measure report
Collier County would like to budget up to 40 hours of MethodFactory development services to develop a
Performance Measure report that will be defined sometime in the future.
17
C0L2011 01
,mpem it.�rogres; °88 i4ti 2649 www_mrt ht,dfactory_co ni ,OiO M-[ Fact.p..4i rights reserved.
Ilk
IVIETHODFACTORY
implement.progress
Ticket #05261 - Work Scope Enhancement
Allow the"option"to have Work Scopes update themselves for new Account Objects.
Work Scopes are extremely cumbersome when the work scope does not allow updates to include
new Account Objects.
Settings:
With this change we'll need to add a new Inclusive Scope option for Account Objects.We'll
change the verbiage of the existing option to reflect the inclusivity of Positions into a Saved
work scope.
Site Options
Fiscal Year Information , Budget Information Service Level Information i Position Information I; General Information lj Workspace Options j
General Account ;Position Budget Issue Grant Capital Protect , Performance Workscope
1 Default New Work Scope p Default New Work Scope r
Position scope to Account Object scope to
Inclusive Scope Inclusive Scope
'Required Fields Apply [ Save 1 Cancel j
Work scope:
On the Account Object sub-scope screen we'll add the checkbox that will allow for a default
value and user override of the inclusivity site option selection.
1.8
C0L2011 01
AA METHODFACT ?RY
implement.progress
My Work Scope
Favorite:Fund Test 1
Account Object v Excluded Items: 1334 Current Items: 11 Reset Search Return to List
Inclusive Scope
Checking this box will include all items created in the future.
Exclusion Work Scope Assigned Work Scope(Included)
The following records have been manually IExc uded from the The following records are=EWA in the work scope of the
work scope of the user. user.
Code: Search Reset Code:'„ Search Reset
®Include r.Include All ®Exclude -.Exclude All
79
M„u u:d�ar Cory.Ine. COL2O11 01
n
Ak
METHODFACTORY
implement.progress
Ticket #05262 -Add the program to the performance workspace under
the business unit and move the program indicators onto the programs
Collier County would like MethodFactory to add Programs within the Performance to allow for the
ability to security which programs individuals have access to edit the program narratives and
performance measurers.
First, MethodFactory will copy the Program relationship from the Fund Center to under the aligned to
Business Unit within the Performance workspace.
Budgeting Lookups
Search Filter ,Business Unit v j 10807 ❑Exact Search J Reset
i New Delete More Options •
CiP Cost 7FA Fund Business
Fund Center Fund Center Name Fund Only Center Program Function Code Center Una
History Status
989010-607 Interest 607 1 080705 51 513 0807 A'
178985-001 Sea Turtle Montoring 001 1 080701 53 537 0807
156341-111 Recreation Programs 111 1 080702 57 572 0807
156381-111 East Naples Community Park 111 1 080702 57 572 0807
156380-111 Veterans Community Park 111 1 080702 57 572 0807
1 5631 3-11 1 Golden Gate Aquatic Fealties 111 1 080702 57 572 0807
156395-111 Max Hasse Community Park 111 1 080702 57 572 0807
989010-130 nterest 130 1 080703 51 513 0807
156332-111 Parks&Other Property 111 1 080702 57 572 0807
156364-001 Parks&Recreation Marina Ops 001 1 080701 57 672 0807
v
14 4 II 1 • ►1 32 items in 1 pages
The relationship between the Program and the Fund Center will remain within the Fund Center lookup.
Collier County is aware that there is a chance that you could have a program in the Fund Center lookup
table not created in the performance workspace or vice versa.
20
COL2011_01
,erved-
..,•1__4 : L. . , ,
A ETHODFACTOR . , .
- implement progress
- NI- ' , - - , ei
Atiki
■
. ,
. , ,
,.„..-.4,,.:,‘„,.
fivf,i-' - illgitl,
fp • .-,- .":".----4'--:',_--,_-,---_-;!ifw---4-4,-.---7- -- ---.-„,.• .,,,.--.±4,-_,.. -,•:-,-;-:.•:,:-.. -_, ,,-,-_-,,,---- ,-- -- -, '
„„,..,,,t,„, ,...,,,--;,,,,,„„.,— . . uy D.,f..„,..,,ons,,, ,,
nom* •i Ptomain”
. , .
..„
12'fittilicentennotiOptiki$ --'
. -
‘,
.,
e rf o r ril a n c e Management
• _4,14 Ct.o.r.=E.....1"12.-.0.•
,•1
jr. „...N44,of Ise
*
autin•ss Cent*r
--„-A a:v:1 ..t‘•SO..m:
41.11121-Lour.,t•mmtso
4.a.K3
21, ,
3C3 :lire
.•'.. „.,
A 181.1•Wo......,
aisitinsts Unit
440„):,- p.,..ssz,..,....0 4
4D,scrons Fiekl PP,ru ,
A:4101 oen,s&rt.
.., .4r-------
„„, . .....
-•,3 0-4,25 ett..ars,rs1t e a
,,,:,.*:- ;',.-e '''': • 'Xt:,', °;01 4: ::.
,413111J: Cx.olgo Zone me
:JOKE NW Se..ce.C ':1 , .4,tk ..11 • .11•- 4,, i• • -..--_--
,'4-...tor'AM.':•.`""*
• ..r.•
• ...4 12•C•oatei 1.voutcoem oo
•••••- -..,,,, , ,,,,,
•
' '-'' ''.;" ---;'-'7, ,N:
...a 12 Aerarocrot 4.e Se-Ars
&rchrd 120.1.CfPta
• 4+4
. ,.r -...---•— - — ..'
}
Second, MethodFactory will copy the program Narratives from the Program Lookup tables into the
Statement areas of the Performance Program.
21
COL2011_01, _ _r„._
, .4.-4,4..__.4-. ■
■ '. , y
A
M E'TH O DFACTORY
impl®mesa,progress
0 ---•ii, '� �r.
( a.ny.+r".; ,,,, r o,, esn.✓r+'. f ,,,,,, W „^weak1. , 4e€kn4.xa r
Mane lookups l$uYgafng lookups tit,,,Nearer Wnfl Scnpc a Logo t"ig
.eltta a ' Budgeting Lookups
eke
Program Cod. 025702
Program Mama Farya&12ecreatum ti l l;
. , V m
ii.ioA Stslsa**
To benefit the well bauag of the peup4 Carry aeol e+n trurreoeM cf Ceihet County .......
-, :.-- Badgei V.ti.nce
� }oncost FY 20 I1.rite sups€Yen.�ctY are W,ecasl at s22r 308 bola.FY 2811 ada{(ed buGGc4�e to w
pre 43Inx)haled.,acatscres and e,curtbtg suetne eddl,artet Watamc.,ek ouerng the Year
tap raueg menses are forecast re S88 bptl b►nw FY 2011 adhctM budget to meet tM sttgMty
aadtysd rer.onw hater eV
1t#
s ¢iwenuc5 are down by 310 8G3 due to a decreased enrollment rettn rec<eat.:sa Canes and eltaetat:
0ogr ams Expenses rate tools Leduc ed xcordulgy
'' °€:smara FY 2812.Personal sondes decreased S77 g08 nee was duo to a moor Waterer to
rawrt 6 alaos I It PSs a cararst D... ,
72
CoL2011_o1
A METHODFA TOR
implement.progress
0 4110 . ttNr-..'-
_,.. f7',.,...... i''„ --; _, _; #-,). .f
a sy °a z.rrs• . = tra�•nr J, r.r,.»-r w t n.. s �•
Nome MR!Nooh tiYcak Scw. xr, LOONS lit
3=.. .P. Activity Statements
• J:1'ft-c3,cs bats Car a
• -.in 4,1",ttas.e xn.:c Ptogrem Mission Statematti
• 4:5 -:-"'' '!r+rY-rrr To tens&the well.tent)of trta p lcdP ccrrrnv,it,acrd PnmMrMnt of CC0er Cefecce
• _4-X :sat¢elate:.sacn:r r
tst.:Yes ,.., t,
,1_: 1.;xnc. w.r Progtan Budget Viflinces and
..ii AO4 taro, Notes:
..tOr% % hhtecast FY 2011 orsons serrtes rte aliei:sal at'..e22T 33G tter+.•rx f Y 2011 adapted budget Ono-to nut G
. u tur ded.st errors and mt:tnu+g some n0la,cnat fetstefes dueled the yCat
-.=:t AV woo A ur?est
Opel t^i expenses are Suet est at$88 600 hals FY Nt 1
adapted twogt to mete tea ship.,teemed moons*
.r taincerin forecast
+:t45.forte t:f+ v
;�1.==X. Cass Set •-_
...�.�w,..... .. - ..,
.,j 100:'-C PO*4.P+
4044.1 ..,t.Meal,:,
Joe:3-:oleo.:re Ma
F e+vx tixs P.•so,
• �-_ Arco II
,,• r.+,.•...,. r Stan �' CaecN
-4
Next,MethodFactory will move the measure and indicator from the Business Unit to the appropriate
program.Which measures and indicators will be moved to what program will depend on the Indicator
title which is prefixed with the program code as shown below.
23
COL2011_01
Ak
te„,i1
N1ETHODFACTORY
implement.progress
itifilltif.
a...a...ay • .54...4. •oorrirg re., ,,,-,r. , Wars 14-,r.
SOM. PAY 0440'NM,54.COP . Loam(40
132!!!!!!!!Mill MI Palfiell 4 Waita'atateaf.ileparowees !I
'..::* a.s.ass L..*. ae QUM-Via
.....
-
., .4,5Swirve Objective Setup
s .4 01 Cleave-'.75.55aats eaa a
• 4 : El.tea(.51,se..:arat
.«
s- 4 02 1.1sensa it t 0er-55.rs ,... le*tafa. 5.4eassar. 5:55sealeVrt at.
• .4-5 ea.,'5.....ardessa..5 r•
405
• .4 ' Mike ef ewe C•se's•5•
,4 De I5,Eac'Re eces 175.1ste5
—
a 4.
4ces: .7.1Arly,EiVrga ,,y) e'vel5se e.-....eac Peva.4teattar5at 5.f 5. .5a ease.4411.5 5 vats eattealeace a,55)
.c., -..s,,•,.. .,-es.,s e,.i,-me,-,.■'s a
..al D*04 .0.400;51.55=0, art, laesealasfaa.A4005.1554555 554.5514es Vir" tr.***.***15***4
,,,,IC6V5 .e**,V al I •esst rea SAW.5a a'.Rae 504 t,ZN. d,...ease.ne East.:.5..04 ascesa a.:".. a
jicees 51.ase.." ..;... at ease ree a...sea.avire‘5e.aaaemeas 1,:5. pc ease'e a...sea Pweee5Seiestraneas es:5% a
- sia 121111123EREEZR ...I r,-**-,...11.3.-..5.7 a--.574.re,*:..5. • sass'et['VP.,,'Tv,kyr,47,11k,11.,..... * *
,,ACOVW. **IS**I * *
4 12IISC i *aria&R.
Measure Title. ifteetait Fee eased Facets Reetsis te l,2%
.4 Ito 1,4 ''''"i'''. Measure Details
4104044 *Utak rear 2ss
.joedo
•elrret Ce5a
4 03.0 Caast*:ant aas
4 03:1•3 Ptiala"..eeoars.0
JOS Fume.olVaes155.,taan . .. .
so
4 it)
* la 01115111*Fab 1 ilostairt
MB (l 4.44 2::": 'i.`::•..
)4 4 1 1, N. 1 I
Finally,this change will require an update to the Budget Document and Budget Document—CIP reports
to support the new location for the program narratives.
Collier County will be responsible for managing the security to the new programs.
24
- ' COL2011 01
+� lk �v�
slip, " r
�1 implement progress
Collier County's implementation of the Estimation functionality
Collier County would like to activate the ASSUMPTION feature.
Items of concern are:
• The use of the Annualized field.
o Rename the Assumption field to Assumption Adj
o Create new field,Assumption Total
• Formulas
o Manual Entry
o Straight Line Pay Period(Regular Salaries)
o Budget Formula
o YTD formula
o Retirement Formula
o Social Security Formula
• Reports
• Security
The Annualized Field:
In Collier County,the Annualized field is populated by all the users. It is an estimate of how much will be
spent/collected in the current year(history year 1 or FY 2011 in the example below). This field is used
and printed in the Budget Doc. We cannot have this field automatically changing its total. Therefore I
am proposing a new field;which will display the Assumption Total or Assumption Results.
Account-t 100011-001 1 511100)511100
Information Custom Notes History Change Log
Add Polo Acid Aliyt n■eiits
Fund Center 100010-001-Board Of County Commissioners
Commitment Item 511100-Salaries Elected Officials
Annualized: 1379,900
Assumption Adjustment Assumption Total:I I
Show Details
Below are the account details for the selected account.Select a forecast budget year to view details specified for that year.
New Delete More Options All Years v Jr
Description JL Cade Name JL Code FY 2412 FY 2013
50002011-Salary-COLETTA JR JAMES Departmental Administration/Overhead 010101-10 S75,705 SO
12) 50002012-Salary-HLLER GEORGIA Departmental AeminiatratwnfOverttead 010101-10 575.705 $0
50002013-Salary-COYLE FRED Departmental Administration/Overhead 010101-t0 $75,705 SO
50002014-Salary-FIALA DONNA LOU Departmental Administration/Overhead 010101-10 $75,705 SO
50002015-Salary-HENNING THOMAS Departmental Adminetratlon/Overhead 010101-10 $75,705 SO
25
it. .,:I I, !r,- COL2011 01
..' '--.-:•,.-,:ipl,-,i-,,..1., ,!,.-..,2-,-,,,Ally,,,..,,,v1q,.. ...4::-.t,.,,J,,,,,,,,,i.,,,,,,,,,,,,,,r,.,
' - , ,-,--. 0.4.1041(!43.-5-:.:,-;,,,..'E.--,:s:!;,:!?-).-,:-.,::-!:=i',.,-,k,.•!..s.,,:.-,::;:,•-..:::-.f--, ;::,:ii-A-5-,_,_,,,„
yr R
-...,-,'-----.:B11ET-HODP----Ae,41-0
Alkk
friiriiiiiiiint----firogrei ' - -
dl I Jtj
,14 ; 1 ,[1., ■ ,, ,I .5.ttr-,.::clic:ages
IFY 20101 FY 2crse I Amende 378,470 378.470 d 1
Encumbrance* YTO. ' 1
0 1 125 ealanSe I Annualized
379.929
,204 253,266 379,900
APP/Y I Save I Cantu I Delet* I
1t,
COL2011_01
Ak
METH DFACTORY
implement.progress
Assumption Formulas:
Regular Salaries(account object 512100)
Formula:
(((last pay period amount)*((#of pay periods remaining)+(partial pay period)))+YTD expenses+
encumbrances+Assumption Adjustment=Assumption Total
Last pay period amount can be loaded onto a Salaries Lookup table.
In the Site Options screen,shouldn't the"Last Pay Period" be renamed"Remaining Pay Periods"?
In the Site Option screen,we need to add another field to include a decimal,for the year-end partial pay
period.
Settings I Organization Settings 1 Site Options 1 My Default Work Scc 14 J Logout
16 in
Site Options 17
13
�._. 20 •
Fecal Year Information Budget Information Service Level Information Position Information ,G*neral informatli 21 rkspace Options ; .3
22 .4
23 .5
Position Prefix: View Position Number Start:" 24 .6 it
25 .7
Pay Periods:* 126 Si-weekly J Last Pay Period:* ® .a
Partial Payroll(in l0ths) 9'
Minimum Additive FTE:" 10 75 FICA Rate: 0.062
Calculate Merit at Merit Date: 1-- Budget Calculation: 'Salary*FTE*Pos J
Calculation Accuracy: 1To the week Splits Must Equal 100%: l
"Required Fields Apply I Save I Cancel I
Collier's Pay Periods are bi-weekly,with the pay period ending on a Friday. At year end,the Finance
office will accrue a partial payroll into the current fiscal year(history year 1 or FY 2011)for proper year-
end cut offs. Therefore we have 26 pay periods plus a partial as follows:
FY 2011=0.5 pay periods(pay period beginning 9/24,5 business days in Sept)
FY 2012=0.5 pay periods(pay period beginning 9/22,5 business days in Sept)
FY 2013=0.6 pay periods(pay period beginning 9/21,6 business days in Sept)
FY 2014=0.7 pay periods(pay period beginning 9/20,7 business days in Sept)
FY 2015=0.8 pay periods(pay period beginning 9/19,8 business days in Sept)
When Finance prepares the accrual,they divide the partial pay period's dollars by 10 business days
multiplied by the number of business days in September. They do not count the weekends.
COL2011 01
%I 4",,rtt ,'.
METHODFACTORY
Implement.progress
Other account objects that would use this formula are:
• 511100 Salaries elected officials
• 514100 Other Salaries and Wages
• 514100 Overtime
• 522200 Retirement High Hazard
• 522500 Retirement Elected
Scott,will I have multiple(6) look-up tables?
Budget Formula
Amended Budget+Assumption Adjustment=Assumption Total
Some examples of Account Objects that would use this formula are:
• 512600 ER 457(Deferred Compensation)
• 523150 Health Insurance
• 523151 Health Ins—VSIP
• 523160 Life Insurance
• 524100 Workers Comp
• 525100 Unemployment
• 6xxxxx internal service charges
YTD Actuals Formula
YTD Actuals+Assumption Adjustment=Assumption Total
Some examples of Account Objects that would use this formula are:
• 518100 Termination Pay
• 518200 VSIP Program
• 528100 Allowance Moving
• 3xxxxx Department's Charges for Services(to the public).
Retirement Regular formula(account object 522100)
It appears that Arlington calculates its Retirement contributions by taking the Assumption Total from
above and multiplying it by their retirement percent. Florida Retirement System has too many different
rates. The formula should be applied to the future salaries calculated above and this number should be
added to what has been expensed in the accounting system,YTD actual.
The formula will need to include the following accounts
• 512100 Regular Salaries
• 513100 Other Salaries and Wages
• 514100 Overtime
C0L2011 01
Y.
I MET F TORl�
impierrtent,`progress
Formula=SUM ((last pay period amount) * ((#of pay periods remaining)+(partial pay period))+
Assumption Adjustments)for the above accounts* retirement Percentage(use Additive HA, FY 11
Assumption%)+YTD Expenses acc't obj 522100+Encumbrances acc't obj 522100+Assumption Adj
acc't obj 522100.
A B C D E F
1 Retirement Calculation 522100
2 Reg Salaries Other Sal&Wages Overtime Retirement Reg
3 512100 513100 514100 Assumption Total
4 Last Pay Period Amount
5 *(ft of Pay Periods remaining+partial PP)
6 Subtotal +134*B5
7 +Assumption Adjustments
8 Subtotal @sum(B6:B7) @sum(B8:D8)
9 *Retirement%(HA additive)
10 Subtotal
11"+YTD expenses for Acct Obj 522100
12'+Encumbrances for Acct Obj 522100
13 +Assumption Adjustments for Acct Obj 522100
14 Assumption Total forAcc't Obj 522100 @sum(F10:F13)
20
C0L2011 01
n
A METHODFACTORY
implement.progress
Additive Code:
Additive Name: 'FRS Regular Class Pension
Adjustment Type: 104-Fringe Additive
Account Object: 522100-Retirement Regular J
Additive Type: 01-All Positions -j
Additive Dependency: No Dependency ml
Budget Category: 02-Percent of Salary
Additive Group: 00-N/A
Additive Class: Retirement Plan
Calculate On Base Salary: r
Exclude From: FICA/Medicare J
Include in Over-Time:
Calculate if Hired Prior. .
Effective Start Date: Apply Now
Notes:
Additive Budgets
Enter the forecasted budget values for the additive.Please enter the values as percentage amounts.
5.33 % 0 % 0 % 0 % 0 %
FY 2011 Assumptions Apply I Site. I Delete- I Cancel I
WARNING:Since these formulas are Account Object driven and not Account Object/Fund driven,the
Fire Districts and Emergency Medical Services calculated Assumptions will have to be manually altered.
Regular Salaries includes the employee's pay for Regular Retirement personnel and for Special Risk/High
Risk Retirement personnel. So the above formula will include all the EMS workers and Fire fighters in
the calculation for Regular Retirement.
Social Security formula(account object 521100)
The formula will need to include the following accounts
• 511100 Elected Official Salary
• 512100 Regular Salaries
• 513100 Other Salaries and Wages
• 514100 Overtime
Formula=SUM ((last pay period amount) * ((#of pay periods remaining)+(partial pay period))+
Assumption Adjustments)for the above accounts * retirement Percentage(use Additive FICA,FY 11
Assumption%)+YTD Expenses acc't obj 521100+Encumbrances acc't obj 521100+Assumption Adj
acc't obj 521100.
COL2011 01
METHIODFACTORY
implement.progress
A B C D E F G
1 Social Security Calculation 521100
2 Elected Officials Reg Salaries Other Sal&Wages Overtime Social Security
3 511100 512100 513100 514100 Assumption Total
4 Last Pay Period Amount
5 *(#of Pay Periods remaining+partial PP)
6 Subtotal +B4*B5
7 !:+Assumption Adjustments
8 ` Subtotal @sum(B6:B7) @sum(B8:E8)
9 *Social Security%(FICA additive)
10li Subtotal
11'+YTD expenses for Acc't Obj 521100
12 +Encumbrances for Acct Obj 521100
13 +Assumption Adjustments for Acct Obj 521100
14 Assumption Total for Acct Obj 521100 @sum(F10:F13)
Additive Code:
Additive Nam.: ICA Terri
Adftnenine Type: 148 tS.1 Saler,Adlet.e
Account 0blect: N1100 SCC It Secuat r F lattttvzg
Additive type: 101.All Poston%
Additive Dependency: 'FICA Eftiotior +
BudgetCoteg•ry 107 PrLr5 a•Satary
Additive Group: 100-r.G J
Additive C111110. Iu,e.Rrt.e :1
Windy in Cher-rime:
Caicuia**if Heed Pnoe-
Elective Sian 0..e: [ACV No.
Mom :l
.:J
Additive Budges
Enter the tomcatted to nni values tot the*Ones Phase rerr the mien as manage ene rds
1 62 '. ° '.I D1
"'11 dententi9els Ap r 1 *toe I Osists I Coal
I will use the FY 11 Assumption%for both FICA and Medicare,7.65%. No need to have separate
calculations for FICA and MEDI. During the months of January—September, no one will be at cap.
Everyone will have to pay both with the exception of a handful of people. I can live with that.
Reports:
A new report will be needed for Collier County.
• A revenue report
• An expense report
C0L2011 01
Aimplement pi-ogress
A B C D E F G H I
1 FY 2011 FY 2011 FY 2011 FY 2011
2 Amended Budget YTD Expenses Encumbrances Annualized Assumption Adj. Assumption Tot Variance
0
3
a
v.
u
a
N
,..00
3
9
v
N
C
d
N
3 ` .
32
.�,� C0L2011 01
Ilk NTFATCY
Implement progress
Security:
Security over the Assumption field is a major concern for Collier County.
We use the Annualized field to estimate how much money the depts.will spend/collect this year.
(History Year 1 or FY 2011).
The new Assumption field is too close to the Annualized field.
My fear is that users will accidently input their Annualized amounts into the Assumption field.
Therefore under role management, I would like to see another check box.
Role Management
Details `, Members Settings Area Budgeting Area Reporting Area ', Budgeting Phases Performance Area
Accounts
17 Access Accounts R Create Account Details FT Create Accounts
r Delete Account Details F Delete Accounts R Edit Account Annualized
r Edit Account Detail Annualized P Edit Account Details r Edit Account History
r Edit Accounts 17 Export Accounts R Override%Change Locking
F Read Account Details r Read Accounts ❑ EditAssumptionAdjustment
If the box is checked,the user may edit or input a value into the Assumption Adj field.
If the box is unchecked,the user will not be able to input a value. (The title of the field and box should
be grayed out). I do not mind if the users see the values in the boxes. I just don't want them thinking if
they accidently type in a value,that the value will be stored in GovMax.
COL2011 01
401k MET AFACTOY implement.
progress
Estimation of Work
The cost for services is based upon the standard rate as defined in the Master Services Agreement.This
effort will be billed against proposal number COL2011_01.
Change Hours
ak �'�4 ry+, x P 3�ms+ ' �a3 t a s
Ticket'#05252 Account Ex ort does not contain or�include the Annualize• „,,,,i'''''',.„, » ■■
5 33 I'° 7 A rU% Al It 3 a ' '..,,:iv fir, ,‘,2„,,W., ,k,y�.,re't*” '3 yy" 11,
,.'"$ q r„ :-y �y� a r�` 4 5"� .� �,h }, Wax wF t t !"'' ? t,t`m$ ',
amounts 2 [� .�-� � � �� .� x�. � a< �
Ticket#05253—New Report—Proforma JL Code Report 10
Ticket#05254 The customization of entity titles for Org Code and Account ObjeCts'Osr" 16
r " 'Y a c z t .....� '4"a rc k3.'f„ r '"" ' sf `t'�" z xr • t 1'"..
is incomplete k � ,�' k. � �y xi
5 .e. P Y.�":,J+'yk"' S'' A# i'' 3 "� b`s2 (i 4 Au i' J A7ka 17,gy• �'�" ceil-
,, e.,'IC',
,-- ;:;', . ' �s}C'il: W a ,- ..4 ,.TP t r.,;M1�`' '1 x'°1-4,.:' ,`* te:FI -;'^`S ?;s.p ^`'..:.-,..%- -..k 2..".='.
Ticket#05257—New report—Security Report 14
Ticket#05258* .,Newt reports Performance Measure report 4 4 , 44 40
�,i. a @ .. # . S #`" +=-. .o k fi�;3 va Z,,,,n-gz,v'-fir t „s "sn�'e4,f. 0" Ifit ,, &, , ,•,sue
Ticket#05261—Work Scope Enhancement 14
Ticket#05262" Add the program to the performance workspace under the business: ' 31
unit and�moye the progaan!indicators onto the Q ograms " 4 :, f t ; �. t
as ' r"-»y . An ,elif.x*t.:;a + .�;., ', , �"' '^ft,... , -;0 .. ' „ a s a 10:, „.'
Collier County's implementation of the Estimation functionality(note—this is a 131
good faith estimate for development. Prior to development Collier County and
MethodFactory will need to clarify questions and functionality as described in this
section.)
$TotalI el ent r 270:
..)'°r 9..4 ,.�.`�' er.iyki�.r. *, 1 ."4, r7'd a*.Ars y�.'�u., ;';.' ,._ rj,,,- , , * t-' ... ,• iO4..,xx ,. l:
Project Management Included
Total Additional Effort 270 hrs
Total Additional Effort Cost $33,750
Payment terms:
• As defined in the Master Services Agreement executed on 10/29/07.
* Method Factory should not start ticket 05258 until:
1) Ticket 05262,Add the Program to the performance workspace under the Business Unit, is
completed
2) Collier County approves Ticket 05258 in the Method Factory Ticket Tracker system.
34
COL2011 01
Aikk
METHODFACTORY
implement.progress
Approval of Statement of Work COL2011_01:
Collier County, FL MethodFactory
Name: Chairman Fred W. Coyle Scott J.Auer
Title: Partner .,"
1 0.113111 �----
Date:
(e 2b 1( /
Signature: *luck. uu c"..13.3isz...
Collier County Attorney Attest
Name:
SCOTT R. TEACH DWIGHT E. BROCK, CLERK
Title: Deputy County Attorney
Date: 9 20'
‘ a1,314 1 6 i
Signature:
oci ,t
L f- = ,
This statement of work is subject to the terms and conditions in the Tcec. d Master Se,„ „cp
Agreement. ' y �h �`'"
via r V
35
COL2011 01
gpvi_Max Sarasota County Government in association with MMethodFactory
Client Name: I Collier County, FL
Project Name: GovMax v5 Extended Annual Support (FY 2013)
Proposal Number: COL2013_01
Date Prepared: 10/24/2011
This document outlines the Extended Annual Support arrangement with Collier County, FL for GovMax
V5.0.
Extended Annual Support(EAS)tenets:
MethodFactory's will provide warranty and support services pursuant to the terms of the implementation
agreements—renewable annually, in one (1)year increments. During the term of the extended annual
support contract MethodFactory extends the application warranty and will resolve any application defects
at no cost to the client.
• Periodic system updates
• Access to the support portal
• Technical support by phone and email
• Project Management(planning, organizing, and managing resources to bring about the
successful completion of service requests)
• Account Management(communicating and working with client on matters not directly related to a
discrete service requests)
• Issue Management(Logging,tracking, resolving and closing of service requests to the client's
satisfaction)
• Up to 15 minutes of technical support/consulting assistance per incident
• Application defects
• Annual fiscal year database setup(limitations apply+)
+Changes to the organization's departmental structure are not included with the annual fiscal database
setup.
What is not covered by EAS:
• Custom imports
• Custom exports
• New report request
• Modifications to existing custom reports or GovMax v5 report templates
• Collier County, FL enhancements to the application
Period of Coverage: 2-20-2013—2-21-2014
Annual Support Cost $16,000.00
Payment terms: as per the Master Services Agreement
Future GovMax v5 Extended Annual Support agreement cost increases will not exceed 3.0%in
any given year.
Collier County, FL Designated GovMax v5 Support Contacts
Ikivifiax
v�..
Gtf"Lners Sarasota County Government in association with MethodFactory
As per the GovMax v5 support process, Collier County, FL may name up-to 4 contacts with the authority
to submit service requests and obligate Collier County, FL to pay for requested services. The GovMax v5
Support Administrator will maintain a list of client representatives that have been authorized to submit
services requests. As a control, requests submitted by other than the named individuals in the grid below
will be referred back to the client's primary GovMax v5 contact.
Name e-mail Phone
1. Susan Usher Susanusher @colliergov.net 239-252-8810
2. Mark Isackson MarkIsackson@colliergov.net 239-252-8717
3.
4.
Approval of Statement of Work
Project Name: GovMax v5 Extended Annual Support(FY 2013)
Proposal Number COL2013_01
Collier County,Fl MethodFactory
Name: Chairman Fred W.Coyle Scott Auer, Partner__
Date: \43 \k !D 2 F
Signature: `I/ `-t -
Collier County Attorney Attest
Name: SCOTT R. TEACH DWIGHT E BROCK, CLERK
Date: tia13 �� 11 3 2o12
Signature:
.___ At�!!t.-t1i eta rf11�1Tt�de►
This statement of work is subject to the terms and conditions in theixecthed-Master f rvice
Agreement. •••• •
GovMax r
Partners Sarasota County Government in association with A&MethodFactory ,
Client Name: I Collier County, FL
Project Name: GovMax v5 Extended Annual Support(FY 2012)
Proposal Number: COL2012_01
Date Prepared: 10/24/2011
This document outlines the Extended Annual Support arrangement with Collier County, FL for GovMax
V5.0.
Extended Annual Su000rt(EAS)tenets:
MethodFactory's will provide warranty and support services pursuant to the terms of the implementation
agreements—renewable annually, in one (1)year increments. During the term of the extended annual
support contract MethodFactory extends the application warranty and will resolve any application defects
at no cost to the client.
• Periodic system updates
• Access to the support portal
• Technical support by phone and email
• Project Management(planning, organizing, and managing resources to bring about the
successful completion of service requests)
• Account Management(communicating and working with client on matters not directly related to a
discrete service requests)
• Issue Management(Logging, tracking, resolving and closing of service requests to the client's
satisfaction)
• Up to 15 minutes of technical support/consulting assistance per incident
• Application defects
• Annual fiscal year database setup (limitations apply+)
+Changes to the organization's departmental structure are not included with the annual fiscal database
setup.
What is not covered by EAS:
• Custom imports
• Custom exports
• New report request
• Modifications to existing custom reports or GovMax v5 report templates
• Collier County, FL enhancements to the application
Period of Coverage: 2-21-2012—2-20-2013
Annual Support Cost $16,000.00
Payment terms: as per the Master Services Agreement
Future GovMax v5 Extended Annual Support agreement cost increases will not exceed 3.0%in
any given year.
Collier County, FL Designated GovMax v5 Support Contacts
I3rivfflax
l7artnerrs Sarasota County Government in association with MMethodFactory
As per the GovMax v5 support process, Collier County, FL may name up-to 4 contacts with the authority
to submit service requests and obligate Collier County, FL to pay for requested services. The GovMax v5
Support Administrator will maintain a list of client representatives that have been authorized to submit
services requests. As a control, requests submitted by other than the named individuals in the grid below
will be referred back to the client's primary GovMax v5 contact.
Name e-mail Phone
1. Susan Usher Susanusher(7acolliergov.net 239-252-8810
2. Mark Isackson MarkIsackson0colliergov.net 239-252-8717
3.
4.
Approval of Statement of Work
Project Name: GovMax v5 Extended Annual Support(FY 2012)
Proposal Number COL2012_01
Collier County,FL Method Factory,
Name: Chairman Fred W.Coyle Scott Auer, Partner
Date: 113\I fC/Z�111 ,.. _..
Signature: Co-a,c),„„k,
Collier County Attorney Attest
Name: SCOTT R. TEACH DWIGHT ES B 0 K., CLERK
Date: --N- ITS-\ — -
Signature: '
'441/ . .
This statement of work is subject to the terms and conditions in the'.eiuted Master`'1"srvice,
Agreement
\32011
'NA 10
Wh wow _ --
MEMORANDUM
Date: January 3, 2012
To: Lyn Wood, Contract Specialist
Purchasing Department
From: Martha Vergara, Deputy Clerk
Minutes and Records Department
Re: Change Order #4
"GovMax v5 Discretionary Support"
Contractor: MethodFactory
Attached is one (1) Original, referenced above (Item #16F1) approved by
the Board of County Commissioners on Tuesday, December 13, 2011.
The original has been kept by the Minutes and Records Department to
be kept as part of the Boards Official Records.
If you should have any questions please contact me at 252-7240.
Thank you