Question: The Centre for Diverse Needs, educational support unit for a high school is tasked with planning the most efficient school bus routes to pick up

The Centre for Diverse Needs, educational support unit for a high school is tasked with planning the most efficient school bus routes to pick up and drop off students. The school operates with a fixed number of buses and possesses a comprehensive list of student addresses with corresponding bus stop locations. The primary goal is to optimise the bus routes, minimising the distance travelled by the buses, while ensuring all students are picked up and dropped off on time. Datal Number of Bus Stops: 11 Student Addresses: 30 students in total Bus Capacities: Each bus can accommodate 30 students. Maximum Daily Distance per Bus: 50 kilometres Maximum Daily Time per Bus: 1 hour 30 minutes Distance Matrix (in kilometres) between Bus Stops 1. Clearly show the decision variables, objective function and constraints function. 2. Formulate a Goal Programming model for this problem. 3. Implement your model in a spreadsheet and solve it. 4. How do you interpret the optimal solution for this
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
