Product Service Schedule Database
Budget: $250 – $750 AUD
I require a simple and efficient database to be developed for scheduling periodical service intervals for our hot water units. The aim is to manage our services more effectively, ensuring that our customers are getting proper maintenance and that we are prepared with the necessary parts for each service. Reporting that will give me a list of all due services and parts for any given time period
Key components of this database project include:
Service Scheduling:
- service intervals as per manufacturers requirements from installation date for each unit, for the life of the units. Different systems have different service interval periods and this will continue for up to 20 years after installation date.
Customer Letter Generation:
- Automated generation of customer letters, postal or email, when a service is due, plus when servic is overdue.
- Each letter should include the specifics of the service, the date of service, and parts required for service.
Parts Tracking:
- A tracking feature to understand what parts are needed for each service and generate reports for future needs - eg monthly, quarterly stock forecasts.
Reports:
- Simple reports function that can populate all services dues within a requested timeframe.
- Simple report function that can populate all parts needed within a requuested timeframe.
- Simple report function that can populate overdue services.
Adding New Product:
- The ability for me to easily update part numbers, and add new Hot Water Units as new products come to market.
Ideal Skills:
- Advanced database creation and management.
- Experience in generating automatic letters or emails.
- Familiarity with service scheduling.
This project demands a high level of accuracy and attention to detail due to the significance of maintaining these units. It is essential that the database structure is easy to navigate and update.
Key components of this database project include:
Service Scheduling:
- service intervals as per manufacturers requirements from installation date for each unit, for the life of the units. Different systems have different service interval periods and this will continue for up to 20 years after installation date.
Customer Letter Generation:
- Automated generation of customer letters, postal or email, when a service is due, plus when servic is overdue.
- Each letter should include the specifics of the service, the date of service, and parts required for service.
Parts Tracking:
- A tracking feature to understand what parts are needed for each service and generate reports for future needs - eg monthly, quarterly stock forecasts.
Reports:
- Simple reports function that can populate all services dues within a requested timeframe.
- Simple report function that can populate all parts needed within a requuested timeframe.
- Simple report function that can populate overdue services.
Adding New Product:
- The ability for me to easily update part numbers, and add new Hot Water Units as new products come to market.
Ideal Skills:
- Advanced database creation and management.
- Experience in generating automatic letters or emails.
- Familiarity with service scheduling.
This project demands a high level of accuracy and attention to detail due to the significance of maintaining these units. It is essential that the database structure is easy to navigate and update.