Demand Data for Each Route on Each Day in off season $($Passengers$)$

Route Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Mumbai$-$Delhi $104979711893114116$

Bangalore$-$Kolkata $951021111161069398$

Chennai$-$Hyderabad $93109899311410392$

Mumbai$-$Chennai $9710111711510011295$

Delhi$-$Bangalore $106106989796112116$

Revenue & Cost Per Flight for Each Route $($INR$)$

Route Revenue Cost

Mumbai$-$Delhi $68,15338,878$

Bangalore$-$Kolkata $43,20237,642$

Chennai$-$Hyderabad $41,33235,822$

Mumbai$-$Chennai $63,70139,681$

Delhi$-$Bangalore $48,14037,619$

Total Number of Aircraft Available Each Day

$10$ Aircraft

Solve the above scheduling problem using excel VBA and provide solutions and insights