Loading...
HomeMy WebLinkAbout06 Consultant Invoice Page 1 of 2 Palm Desert Vision Zero Strategy Invoicing Progress Report Invoice Period: May 25 – June 28, 2024 Invoice Number: 304.0002023.267 - 06 Services Provided This Period Task 1. Safe Routes to School Plan (52.55% complete) 1.1 Existing Conditions – submitted draft memo and traffic count data 1.2 Collisions and Gaps Analysis – submitted draft memo and traffic count data 1.3 Outreach and Engagement – close-out community survey 1.4 Advisory Committee – selected July meeting date 1.5 Crossing Guard Analysis – address comments and conduct analysis 1.6 Recommendation and Prioritization – continue developing recommendations Task 2. Safe Routes for Seniors Plan (46.32% complete) 2.1 Existing Conditions – see above 2.2 Collisions and Gaps Analysis – see above 2.3 Outreach and Engagement – see above 2.4 Advisory Committee – see above 2.5 Recommendation and Prioritization – see above Task 3. Public Engagement and Activation (3.78% complete) 3.1 Campaign Goals and Objectives – develop Consumer Insight Survey and Creative Brief Task 4. Investment Strategy (8.51% complete) 4.1 Review and Consolidate Planning Documents – no updates this period Task 5. Dashboard and Monitoring Tool (0.95% complete) Services Anticipated Next Period Page 2 of 2 Task 1. Safe Routes to School Plan 1.1 Existing Conditions – revise draft memo 1.2 Collisions and Gaps Analysis – see above 1.3 Outreach and Engagement – no anticipated services 1.4 Advisory – schedule and conduct second AC meeting 1.5 Crossing Guard Analysis – submit analysis 1.6 Recommendation and Prioritization – continue developing recommendations Task 2. Safe Routes for Seniors Plan 2.1 Existing Conditions – see above 2.2 Collisions and Gaps Analysis – see above 2.3 Outreach and Engagement – see above 2.4 Advisory Committee – see above Task 3. Public Engagement and Activation 3.1 Campaign Goals and Objectives – address survey and creative brief feedback; administer survey 3.2 Ideation and Concept Development – develop a trend analysis and three marketing campaign concepts; refine, select, and document final concept and execution strategy Task 4. Investment Strategy 4.1 Review and Consolidate Planning Documents – no anticipated services Chris Gerry City of Palm Desert, Department of Public Works 73-510 Fred Waring Drive Palm Desert, CA 92260 July 18, 2024 Invoice No:304.0002023.267 - 6 Project 304.0002023.267 Palm Desert, CA Vision Zero Strategy Contract No. C46970 Professional Services Through June 28, 2024 Task 0001 Safe Routes to School Plan Professional Personnel Hours Rate Amount Brown, Les 14.00 245.00 3,430.00 Dronen, Caitlin .25 160.00 40.00 Ferrer, Kassandra 1.00 150.00 150.00 Haukom, Kristin 4.50 245.00 1,102.50 Hernandez, Samantha 19.00 130.00 2,470.00 Lei, Zihui 3.00 140.00 420.00 Mil Arias, Jorge 1.00 115.00 115.00 Purcell, Christopher 38.50 130.00 5,005.00 Scott, Kaitlin 6.00 190.00 1,140.00 Totals 87.25 13,872.50 Total Labor 13,872.50 $13,872.50Total this Task Task 0002 Safe Routes for Seniors Plan Professional Personnel Hours Rate Amount Brown, Les 9.00 245.00 2,205.00 Corbett, Samuel .50 330.00 165.00 Ferrer, Kassandra .75 150.00 112.50 Lei, Zihui 20.00 140.00 2,800.00 Purcell, Christopher 5.25 130.00 682.50 Scott, Kaitlin 18.00 190.00 3,420.00 Totals 53.50 9,385.00 Total Labor 9,385.00 Project 6304.0002023.267 Palm Desert, CA Vision Zero Strategy Invoice Reimbursable Expenses Travel - Mileage 194.30 Total Reimbursables 1.0 times 194.30 194.30 $9,579.30Total this Task Task 0003 Public Engagement and Activation Professional Personnel Hours Rate Amount Brown, Les 4.50 245.00 1,102.50 Cibor, Catherine 2.25 245.00 551.25 Mil Arias, Jorge .50 115.00 57.50 Totals 7.25 1,711.25 Total Labor 1,711.25 Consultants Ideapeddler, LLC dba Idea Peddler, LLC 7,105.00 Total Consultants 1.0 times 7,105.00 7,105.00 $8,816.25Total this Task Task 0005 Dashboard & Monitoring Tool Professional Personnel Hours Rate Amount Mil Arias, Jorge .25 115.00 28.75 Totals .25 28.75 Total Labor 28.75 $28.75Total this Task Billing Limits Current Prior To-Date Total Billings 32,296.80 191,875.62 224,172.42 Limit 948,920.00 Remaining 724,747.58 $32,296.80Total this Invoice Outstanding Invoices Number Date Balance 5 6/17/2024 52,336.04 Total 52,336.04 Page 2 Project 6304.0002023.267 Palm Desert, CA Vision Zero Strategy Invoice 6:23:41 PMInvoice 6 Dated 7/18/2024Alta Planning + Design Thursday, July 18, 2024Billing Backup Project 304.0002023.267 Palm Desert, CA Vision Zero Strategy Task 0001 Safe Routes to School Plan Professional Personnel Hours Rate Amount 304.00964 Brown, Les 5/28/2024 1.00 245.00 245.00 304.00964 Brown, Les 5/29/2024 .50 245.00 122.50 304.00964 Brown, Les 5/30/2024 2.00 245.00 490.00 304.00964 Brown, Les 5/31/2024 .50 245.00 122.50 304.00964 Brown, Les 6/4/2024 2.00 245.00 490.00 304.00964 Brown, Les 6/10/2024 .50 245.00 122.50 304.00964 Brown, Les 6/14/2024 .50 245.00 122.50 304.00964 Brown, Les 6/18/2024 2.00 245.00 490.00 304.00964 Brown, Les 6/19/2024 1.50 245.00 367.50 304.00964 Brown, Les 6/20/2024 .50 245.00 122.50 304.00964 Brown, Les 6/24/2024 .50 245.00 122.50 304.00964 Brown, Les 6/25/2024 1.50 245.00 367.50 304.00964 Brown, Les 6/26/2024 1.00 245.00 245.00 304.00951 Dronen, Caitlin 5/29/2024 .25 160.00 40.00 304.00971 Ferrer, Kassandra 6/21/2024 1.00 150.00 150.00 304.00627 Haukom, Kristin 6/18/2024 1.00 245.00 245.00 304.00627 Haukom, Kristin 6/19/2024 .50 245.00 122.50 304.00627 Haukom, Kristin 6/20/2024 1.00 245.00 245.00 304.00627 Haukom, Kristin 6/24/2024 1.00 245.00 245.00 304.00627 Haukom, Kristin 6/25/2024 .50 245.00 122.50 304.00627 Haukom, Kristin 6/26/2024 .50 245.00 122.50 304.00804 Hernandez, Samantha 6/20/2024 4.00 130.00 520.00 304.00804 Hernandez, Samantha 6/21/2024 8.00 130.00 1,040.00 304.00804 Hernandez, Samantha 6/24/2024 7.00 130.00 910.00 304.00910 Lei, Zihui 6/26/2024 1.50 140.00 210.00 304.00910 Lei, Zihui 6/27/2024 1.50 140.00 210.00 304.00945 Mil Arias, Jorge 5/29/2024 1.00 115.00 115.00 304.00916 Purcell, Christopher 5/30/2024 .25 130.00 32.50 304.00916 Purcell, Christopher 5/31/2024 .25 130.00 32.50 304.00916 Purcell, Christopher 6/3/2024 .25 130.00 32.50 304.00916 Purcell, Christopher 6/12/2024 .75 130.00 97.50 304.00916 Purcell, Christopher 6/18/2024 .50 130.00 65.00 304.00916 Purcell, Christopher 6/19/2024 3.00 130.00 390.00 304.00916 Purcell, Christopher 6/20/2024 4.50 130.00 585.00 304.00916 Purcell, Christopher 6/21/2024 4.00 130.00 520.00 304.00916 Purcell, Christopher 6/24/2024 6.50 130.00 845.00 304.00916 Purcell, Christopher 6/25/2024 6.75 130.00 877.50 304.00916 Purcell, Christopher 6/26/2024 5.00 130.00 650.00 304.00916 Purcell, Christopher 6/27/2024 4.00 130.00 520.00 304.00916 Purcell, Christopher 6/28/2024 2.75 130.00 357.50 304.00518 Scott, Kaitlin 5/30/2024 .75 190.00 142.50 Page 3 Project 6304.0002023.267 Palm Desert, CA Vision Zero Strategy Invoice 304.00518 Scott, Kaitlin 6/3/2024 .50 190.00 95.00 304.00518 Scott, Kaitlin 6/10/2024 .75 190.00 142.50 304.00518 Scott, Kaitlin 6/17/2024 1.00 190.00 190.00 304.00518 Scott, Kaitlin 6/18/2024 .50 190.00 95.00 304.00518 Scott, Kaitlin 6/24/2024 1.00 190.00 190.00 304.00518 Scott, Kaitlin 6/26/2024 1.50 190.00 285.00 Totals 87.25 13,872.50 Total Labor 13,872.50 Total this Task $13,872.50 Task 0002 Safe Routes for Seniors Plan Professional Personnel Hours Rate Amount 304.00964 Brown, Les 5/28/2024 .50 245.00 122.50 304.00964 Brown, Les 5/29/2024 .50 245.00 122.50 304.00964 Brown, Les 5/30/2024 1.50 245.00 367.50 304.00964 Brown, Les 6/4/2024 1.00 245.00 245.00 304.00964 Brown, Les 6/10/2024 .50 245.00 122.50 304.00964 Brown, Les 6/11/2024 1.00 245.00 245.00 304.00964 Brown, Les 6/18/2024 1.00 245.00 245.00 304.00964 Brown, Les 6/19/2024 1.00 245.00 245.00 304.00964 Brown, Les 6/20/2024 .25 245.00 61.25 304.00964 Brown, Les 6/24/2024 .50 245.00 122.50 304.00964 Brown, Les 6/25/2024 1.00 245.00 245.00 304.00964 Brown, Les 6/28/2024 .25 245.00 61.25 304.00164 Corbett, Samuel 5/28/2024 .25 330.00 82.50 304.00164 Corbett, Samuel 6/28/2024 .25 330.00 82.50 304.00971 Ferrer, Kassandra 6/24/2024 .75 150.00 112.50 304.00910 Lei, Zihui 5/28/2024 7.00 140.00 980.00 304.00910 Lei, Zihui 5/29/2024 8.75 140.00 1,225.00 304.00910 Lei, Zihui 6/3/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/5/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/6/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/10/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/17/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/19/2024 .50 140.00 70.00 304.00910 Lei, Zihui 6/24/2024 .25 140.00 35.00 304.00910 Lei, Zihui 6/25/2024 2.25 140.00 315.00 304.00916 Purcell, Christopher 5/28/2024 1.00 130.00 130.00 304.00916 Purcell, Christopher 6/25/2024 1.25 130.00 162.50 304.00916 Purcell, Christopher 6/26/2024 3.00 130.00 390.00 304.00518 Scott, Kaitlin 5/28/2024 5.00 190.00 950.00 304.00518 Scott, Kaitlin 5/29/2024 6.00 190.00 1,140.00 304.00518 Scott, Kaitlin 6/3/2024 .50 190.00 95.00 304.00518 Scott, Kaitlin 6/12/2024 1.00 190.00 190.00 304.00518 Scott, Kaitlin 6/14/2024 1.00 190.00 190.00 304.00518 Scott, Kaitlin 6/17/2024 1.00 190.00 190.00 304.00518 Scott, Kaitlin 6/18/2024 1.25 190.00 237.50 304.00518 Scott, Kaitlin 6/19/2024 .25 190.00 47.50 Page 4 Project 6304.0002023.267 Palm Desert, CA Vision Zero Strategy Invoice 304.00518 Scott, Kaitlin 6/25/2024 2.00 190.00 380.00 Totals 53.50 9,385.00 Total Labor 9,385.00 Reimbursable Expenses Travel - Mileage EX 000000027829 5/28/2024 Lei, Zihui / Mileage 95.14 EX 000000027829 5/29/2024 Lei, Zihui / Mileage 99.16 Total Reimbursables 1.0 times 194.30 194.30 Total this Task $9,579.30 Task 0003 Public Engagement and Activation Professional Personnel Hours Rate Amount 304.00964 Brown, Les 6/6/2024 1.50 245.00 367.50 304.00964 Brown, Les 6/14/2024 1.50 245.00 367.50 304.00964 Brown, Les 6/18/2024 .75 245.00 183.75 304.00964 Brown, Les 6/26/2024 .50 245.00 122.50 304.00964 Brown, Les 6/28/2024 .25 245.00 61.25 304.00110 Cibor, Catherine 6/6/2024 .50 245.00 122.50 304.00110 Cibor, Catherine 6/11/2024 .25 245.00 61.25 304.00110 Cibor, Catherine 6/13/2024 .25 245.00 61.25 304.00110 Cibor, Catherine 6/18/2024 .50 245.00 122.50 304.00110 Cibor, Catherine 6/26/2024 .50 245.00 122.50 304.00110 Cibor, Catherine 6/27/2024 .25 245.00 61.25 304.00945 Mil Arias, Jorge 6/27/2024 .50 115.00 57.50 Totals 7.25 1,711.25 Total Labor 1,711.25 Consultants Ideapeddler, LLC dba Idea Peddler, LLC AP 89073 6/28/2024 Ideapeddler, LLC dba Idea Peddler, LLC / Professional Services WO1 4,379.68 AP 89073 6/28/2024 Ideapeddler, LLC dba Idea Peddler, LLC / Professional Services WO1 2,725.32 Total Consultants 1.0 times 7,105.00 7,105.00 Total this Task $8,816.25 Task 0005 Dashboard & Monitoring Tool Professional Personnel Hours Rate Amount 304.00945 Mil Arias, Jorge 6/5/2024 .25 115.00 28.75 Totals .25 28.75 Total Labor 28.75 Total this Task $28.75 $32,296.80Total this Project Page 5 Project 6304.0002023.267 Palm Desert, CA Vision Zero Strategy Invoice $32,296.80Total this Report Page 6 IIdeaa Peddler 1023 Springdale Rd Ste 4E Austin, TX 78721 (512)940-3642 accounting@ideapeddler.com ideapeddler.com INVOICE BBILLL TO Alta 101 SW Main St Suite 2000 Portland, OR 97204 IINVOICEE #2573 DDATE 06/25/2024 DDUEE DATE 07/25/2024 TTERMS Net 30 CCAMPAIGN Vision Zero DESCRIPTION QTY RATE AMOUNT Project Administration and Management - 5/26-6/25/24 •VP+ 9 hrs x $250/hr = $2,250 •Associate Director + 12 hrs x $185/hr = $2,220 •Planner 23 hrs x $110/hr = $2,530 1 7,000.00 7,000.00 Check processing fee 1 105.00 105.00 Project Number 304.0002023.267 SUBTOTAL 7,105.00 TAX 0.00 TOTAL 7,105.00 BALANCE DUE $$7,105.00 3URMHFWꢀꢁꢂ 7DVNꢀꢁꢂ 6XEꢀ7DVNꢀꢁꢂ $SSURYHGꢀ%\ꢂ $SSURYHGꢀ'DWHꢂ ꢀꢁꢂꢃꢁꢁꢁꢄꢁꢄꢀꢃꢄꢅꢆ ꢇꢈꢉꢊꢄꢋꢆꢄꢌꢃꢀꢄꢍꢈDQGꢈꢀꢈꢉꢂꢋꢀꢆꢎꢃꢅꢏꢍ -0$ꢈꢐꢈ/HVꢈ%URZQ ꢁꢅꢐꢄꢅꢐꢄꢁꢄꢂ