We have a school with a fleet of multiple busses. We need to pick up students in two trip. Class 4th to 10th in first trip and LKG, UKG, 1st, 2nd, 3rd in second trip. We have student staying across all corners of the city. The capacity of each bus is between 30-35. We have a few small busses with a capacity of 25, 20 and 15 also.
The main objective of this project is to identify and select 30-35 students in one area and assign a bus. Each bus driver should know which 35 students to pick up. Each child should know which bus to board.
We can capture the latitude and longitude of all the students and teachers. We want to display these children on the map with name, class and admission no (this is a unique no, very important for all reports).
Based on this information we need a tool to select manually a set of 35, 25, 15 students and make a list of them. based on that we can assign a bus.
Generate reports in excel with various options. Facility to save report formats.
We have situations where we need to call only selective classes. based on that only those students should be visible on the map and we should be able to assign the buses to them.
Every year with new admissions happening the density of students in a area increases. which means say for example this year Bus Route 1 was picking up 35 students from Area A1, A2, A3, next year with new admissions the bus might get full in A1 only. So we need to add one bus for A1 and another bus for A2, A3 and A4 to make it 35 or add smaller bus to have A2 and A3.
Need basic tools to select students based on their locations. So that we can generate reports.
Next Good to Have Feature (Not a Must have feature) would be to suggest optimum routes sequence of pickup and drops.