I developed a web-based Excursion Planner for a travel agency to streamline the process of organizing and scheduling excursions, managing resources, and automating communication with guides.

Problem:

The travel agency needed an efficient way to manage daily excursion schedules, assign buses and guides, and ensure that the same resources were not double-booked. The manual process of planning excursions and communicating schedules to guides was time-consuming and prone to errors, especially during peak tourist seasons.

Solution:

I created a custom web application that allowed the agency to:

• Add and manage excursions: The agency can create excursions, detailing the itinerary and other necessary information.
• Assign buses and guides: Each day, based on bookings, an agent can assign buses and guides to each excursion. The system ensures that no bus or guide is double-booked on the same day.
• Automate email scheduling: Once the schedule is set, the system automatically emails the assigned guides with their excursion details for the day, saving time and reducing the need for manual communication.

Key Features:

1. Excursion Management:
   • The system allows the agency to add excursions with detailed plans, including the excursion name, date, and key activities. This gives the agent a clear view of all upcoming excursions.
2. Bus and Guide Assignment:
   • Agents can assign a bus and a guide to each excursion based on the bookings for that day.
   • The system ensures that no bus or guide can be assigned to multiple excursions on the same day, preventing conflicts in scheduling.
3. Automated Email Notifications:
   • Once the schedule is finalized, the app sends out automated emails to each assigned guide, providing them with the details of their assigned excursion for the day. This eliminates manual coordination and ensures guides have the information they need.
4. Reports and Payment Tracking:
   • The app includes a reporting feature, allowing the agency to generate reports on where each guide was assigned and how much they are owed for their services. This simplifies the process of calculating payments and tracking each guide’s work over time.

Impact:

• Time Efficiency: The web app drastically reduced the time agents spent manually coordinating excursions, buses, and guides.
• Error Reduction: By preventing double-bookings and automating communication, the app ensured smooth operations, even during busy seasons.
• Improved Accountability: The reporting feature made it easy for the agency to track each guide’s assignments and the associated payments, improving financial transparency.