You are required to plan routing for LUMS Grammar School, a premier school in city of Lahore for primary education. They are moving 738 students every day. They have 41 stops having different demand on each stop. Each bus costs you Rs. 8000 / day and Rs. 45/Kms and each bus carries 60 kids. Currently they are running 20 buses and travelling 625Kms per trip per day (2 trips/day). They are spending Rs. 8,277,500 per month on transportation of kids. They are charging 10,000 per kid for bus expenses. Principal of LUMS Grammar School is very worried about the rising cost of transportation. They can't simply shift the cost to parents which are already vert stressed due to high cost of transportation. LUMS Grammar School has hired you to reduce the transportation cost using optimization techniques. You are given the data in following tables 1. Using Exact method (solver), determine the optimal bus routes for the demand listed. List all routes 2. What is minimum distance of all the routes [one shift only]? Show your work. 3. What is the minimal cost required [monthly. Consider 22 days per month]? Show your work. 4. What cost savings per child you are anticipating per month due to your work? 5. Imagine you have a bus which can carry 1000 children. What would be minimum distance per shift. Logistics Management for MS SCRM Spring 23 Page 9 of 11