My WebLink
|
Help
|
About
|
Sign Out
Home
Browse
Search
R2017-91 Professional Services Agreement with Quetica, LLC for Decatur Supply Chain Study CP 2014-06
COD
>
City Clerk
>
RESOLUTIONS
>
2017
>
R2017-91 Professional Services Agreement with Quetica, LLC for Decatur Supply Chain Study CP 2014-06
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
7/20/2017 9:41:35 AM
Creation date
7/20/2017 9:41:33 AM
Metadata
Fields
Template:
Resolution/Ordinance
Res Ord Num
R2017-91
Res Ord Title
Professional Services Agreement with Quetica, LLC for Decatur Supply Chain Study CP 2014-06
Department
Public Works
Approved Date
7/17/2017
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
31
PDF
Print
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
View images
View plain text
The estimated level of effort by resource is as follows: <br /> I.Labor Costs <br /> Estimated Level of Effort by Resource(Hours) <br /> Subtotal Labor <br /> Phase Task Description Director Principal Senior Experienced Experienced Analyst/ Cost($)by <br /> Consultant Consultant Consultant Analyst Associate Statistician Task&Phase <br /> G Project kickoff meeting 8 8 12 0 12 0 $ 7,020.00 <br /> .o Project management meetings 40 24 40 0 0 0 $ 21,400.00 <br /> Total Project Management 48 32 521 0 121 0 $ 28,420.00 <br /> = Initial stakeholder interviews&Supply chain data 40 8 8 0 40 80 $ 24,520.00 <br /> Network Definition/Assessment 16 8 0 20 80 $ 13,720.00 <br /> s Demand assessement/socioeconoimc structure&documentation 4 8 16 0 40 80 $ 16,840.00 <br /> Develop"what-if'scenarios <br /> 8 8 16 0 0 O $ 6,240.00 <br /> Assess network constraints 8 12 12 0 0 0 $ 6,380.00 <br /> n Document and Summarize Phase 1 8 24 0 40 0 $ 10,360.00 <br /> Total Phase 1-Discovery 60 60 84 0 140 240 $ 78,060.00 <br /> Supply chain model development 12 100 24 0 80 240 $ 56.960.00 <br /> o Supply chain optimization 16 80 16 0 0 80 $ 29,440.00 <br /> Identify strategies and actions 8 20 40 0 0 0 $ 12,600.00 <br /> System needs and economic opportunities 12 24 24 040 0 $ 16,560 00 <br /> Total Phase 2-Design 48 224 104 0 120 320 $115,560.00 <br /> °aao Develop Business CaseOPlanning <br /> 4 8 24 0 40 0 $ 11,360.00 <br /> Study direct connection to west coast ports via UP in Pan20 24 40 0 0 40 $ 19,800.00 <br /> v N c — <br /> E 2 Implementation and action plan12 12 24 0 20 0 $ 11,760.00 <br /> a w Summary 4 4 16 0 40 0 $ 9,240.00 <br /> m' E n Phase 3-Business Case and Implemg 40 48 104 0 100 40 $ 52,160.00 <br /> s 196 364 344 0 372 600 <br /> Specific Rate of Compr) $250.00 $200.00 $165.00 $145.00 $12000 $8500 <br /> Total Labor Compensation $ 49,000.00 $ 72,800.00 $ 56,760.00 $ $ 44,640.00 $ 51,000.00 $274,200.00 <br /> II.Data Costs Total <br /> Data <br /> a. Supply chain benchmarking data $ 5,000.00 <br /> Total Data Costs $ 5,000.00 <br /> III.Travel Expenses <br /> Person-Trips Person-Days Airfare Hotel Meals Rental Car Total <br /> $250 $120 $60 $100/day Travel <br /> Project Mgmt 1 trip,3 people,1 day 31 3 $750 $360 $180 $100 $ 1,390.00 <br /> Phase 1 2 trips,2 people 1 day;1 trip 2 people,2 days 6 8 $1,500 $960 $480 $300 $ 3,240.00 <br /> Phase 2 2 trips,2 people,1 day 4 4 $1,000 $480 <br /> $240 $200 $ 1,920.00 <br /> Phase 3 2 trips,3 people,1 day 61 6 $1,500 $720 $360 $200 $ 2,780.00 <br /> Total Travel Costs $ 9,330.00 <br /> Total Estimated Project Costs $288,530.00 <br /> The total estimated labor cost is $274,200.00. <br /> Direct expenses for data acquisition and travel are estimated at $5000.00 and $9330.00 <br /> respectively. <br /> The total estimated project cost is $288,530.00. <br /> Last Revised:2017-06-01 <br />
The URL can be used to link to this page
Your browser does not support the video tag.