Hello, I am looking for someone to develop software to assist me in managing the various tours we offer. We offer tours with a maximum of 25 participants, and for each of these tours, I need to assign the following resources:
• Vehicle
• Driver
• Guide
• Winery 1
• Winery 2
• Winery 3
There are 4 types of tours:
• AM (to which I need to assign: vehicle, driver, guide, winery 1, winery 2)
• PM (to which I need to assign: vehicle, driver, guide, winery 1, winery 2)
• DC (to which I need to assign: vehicle, driver, guide, winery 1, winery 2, winery 3)
• TG (to which I need to assign: vehicle, driver, guide, winery 1)
The number of available seats for the specific tour, the number of seats already booked (and thus the number of resources I need), should be taken automatically from an API.
Let me explain further: Suppose that for June 20th, the AM tour has 87 participants booked. Since our tours have a maximum of 25 participants, 87/25=3.48, which rounds up to 4. So, for this tour, I will need the following resources:
• AM1 (vehicle 1, driver 1, guide 1, winery 1, winery 2)
• AM2 (vehicle 2, driver 2, guide 2, winery 3, winery 4)
• AM3 (vehicle 3, driver 3, guide 3, winery 5, winery 6)
• AM4 (vehicle 4, driver 4, guide 4, winery 7, winery 8)
And so on for all the others.
NOTE: since all the tours depart at the same time and have the same schedule winery 1 on the AM1 tour can be used as winery 4 on the AM2 tour…
The software I would like should have the following functionalities:
• Connect to the API to update the number of participants as new bookings come in, so that I can calculate the necessary resources.
• Have a calendar for the availability of each resource (vehicles, drivers, guides, wineries) so that only available resources are visible/usable for the various days.
• Have a calendar where for each day, I see:
• The number of available and booked seats for each of the 4 tours (for example):
• AM: Available 150, Booked 87
• PM: Available 150, Booked 142
• DC: Available 25, Booked 18
• TG: Available 25, Booked 14
Then, upon selecting the day, I should see:
• AM: Available 150, Booked 87
• PM: Available 150, Booked 142
• DC: Available 25, Booked 18
• TG: Available 25, Booked 14
• Needed and Available vehicles
• Needed and Available drivers
• Needed and Available guides
• Needed and Available wineries
And have the ability to manage the various tours, assigning the necessary resources to each one in the simplest way possible (perhaps even by drag and drop), Including various checks to ensure that everything has been assigned correctly, all tours are covered with the necessary resources, and warnings in case of errors.
Obviously I’m at disposal for further info and clarifications
Best regards
Saverio