Database For Ash Maids

**Proposal Goal:**To build a FileMaker database to create estimates and store and report information on customers, jobs, job scheduling, sales reps and commissions for Ash Maids. **Assumptions:** The database will be developed with FileMaker 11 and each user will have a license for FileMaker 11 or a later version. The database will be hosted with FileMaker Server for sharing among the users. The cost for any software or hardware needed is not included in this proposal. **Description of Work**: The work will be done in 4 phases as follows: Phase 1: Create the tables, data fields and data entry screens for estimates, customers and jobs. Customer data fields include customer name, address, phone, email and other contact information. Customer location can be displayed within the database using Google maps. Job data fields include type of space, levels, square footage, number and type of rooms, additional tasks (e.g. carpet cleaning, upholstery cleaning) and frequency of cleaning, starting date and time. Other data fields include sales rep and team info. Phase 2: Create the scheduling process. The scheduling process will create the work dates for each job and display these in a calendar format. Schedule can be viewed and printed for any selected customer or any selected team. It may be necessary to use one or more FileMaker plug-ins, depending on the specific ways in which the calendar will be viewed and used. Phase 3: Create the tables, data fields and data entry screens for sales rep and commission information. Phase 4: Create reports.