Laserfiche WebLink
EXHIBIT A UTAT �l ConsuI t 1 n g <br />P. 0. Box 236 <br />Calimesa, CA 92320 <br />Gell: (626) 379-1404 <br />Office: (951) 845-4391 <br />Vincent@mvrconsuiting.com <br />DBEMC/58C <br />February 23, 2017 <br />William E. Galvez, City Engineer <br />20 Civic Center Plaza <br />Santa Ana, CA 92701 <br />Subject. Proposal for Timesheet Keeper Access Database Program <br />Dear Mr. Galvez, <br />We are pleased to submit the following proposal to create a Timesheet keeper ,Access Database program for <br />the Santa Ana Public Works Agency (PWA), Below is an outline of the services to be provided, <br />I. SCOPE OF SERVICES: <br />1. Develop ah Access database fortimesheet. keeplog which will. be used by PWA. <br />2. Different levels of access/perm 'isslons to the database will be established f.or employees, supervisors, <br />principals, City Engin.eer, and the Director of the public Works, as well as accounting clerks. <br />3. The database program will.allow reports to be created for a timesheet, showing hours and cost spent <br />on projects a nd activities, on a weekly, semi monthly, yearly, or user specified date range; <br />4. The program will provide for PWA to create summary repo is including, <br />Labor Billing Report (labor hours, hourly rate, total.expenses and overhead) <br />• Project Budget and Balance <br />Total labor Hours <br />5.. As.progress is made on the program, updated versionsof the database will be sent to PWA for <br />review to ensure the final product will be optimal. <br />6. Upon final delivery, training (for each level of access) will be given an how to use the database. <br />11. TIME OF COMPLETION: The above Scope of Services will be completed by May 15, 2017. <br />IIL FEES; <br />Programmer/Developer: Vincent van Rooijen <br />BEE <br />PWA Access Database Program Development for Timesheet Keeping, including Deslgn, <br />Security, and creation of'Fables, Queries, Forms and Reports <br />$6,1pp <br />Trai_nirig for Staff/Users) <br />$ 400 <br />Katal Fee for' Basi Services <br />$6,soo. <br />■ Additional Reports to be defined by City (approximately 5 @ $.400 per repori:) <br />$2,000 <br />H11g.h.1,evel Training for Supervlsars an.d .Report Customization. (approximately 15 hours) <br />Total <br />d' Addltiona.l Programming, Development, Updates and Services, as needed :ns�5 <br />per Hour <br />