scheduling problem Excel solver

A small airline company maintains 2 daily flights between Denver, Portland and Las Vegas A crew must leave and arrive in the same city. Its possible for the flight crew to return aboard another airline. There are 6 airplanes in use. When a crew is actually flying a plane, the entire crew is paid $400 per hour. The other time spent (waiting between flights or flying aboard another airplane) costs the company $150 per hour. The crew rotation and Flying Hours and Other Hours appear in the template. Solve how should the company schedule the crews to minimize cost? B C D E E F G H H 1 1 2 3 Crew Cost Per Hour Flying Cost Other Cost $ 400.00 $ 150.00 4 Flying Hours Cos Other Hours Cost Total Cost of Rotatio Assign Crew to this Rotatic Crew Rotation Cost Other Hours 2 11 10 10 5 3 Flying Hours 6 3 5 4 6 6 3 7 6 4 - 7 8 4 4 7 12 - 7 . 5 5 - 7 7 3 3 9 + 5 Crew Rotation 6 Denver to Portland + Portland to Denver 7 Denver to Portland + (Portland to Denver)* 8 Denver to Portland + Portland to Vegas to +(Vegas to 9 Denver to Vegas +(Vegas to Denver) Overi 10 Denver to Vegas + Vegas to Portland + (Portland to 11 Portland to Denver + Denver to Portland 12 Portland to Denver + (Denver to Portland)* ( 13 Portland to Denver + Denver to Vegas +(Vegas to * Portland to Venca verseto Denver 14 Portland to Vegas +Vegas to Denver + (Denver to 15 Portland to Vegas + Vegas to Portland . 16 Vegas to Denver + Denver to Portland + (Portland to 17 Vegas to Denver + Denver to Vegas 18 Vegas to Portland + Portland to Vegas 40 19 Vegas to Portland + Portland to Denver + (Denver to 20 21 22 CONSTRAINTS 23 FLIGHT 24 Denver TO Portland 25 Denver TO Portland 26 Denver TO Vegas 27 Denver TO Vegas * Save 28 Portland TO Denver 29 Portland TO Denver 30 Portland TO Vegas 31 Portland TO Vegas 32 Vegas To Denver 33 Vegas To Denver 34 Vegas TO Portland 35 Vegas TO Portland 36 Minimize Cost CREW CONSTRAINT TIME OF DAY NUMBER OF CREWS AM PM AM PM AM PM AM PM AM PM AM PM A small airline company maintains 2 daily flights between Denver, Portland and Las Vegas A crew must leave and arrive in the same city. Its possible for the flight crew to return aboard another airline. There are 6 airplanes in use. When a crew is actually flying a plane, the entire crew is paid $400 per hour. The other time spent (waiting between flights or flying aboard another airplane) costs the company $150 per hour. The crew rotation and Flying Hours and Other Hours appear in the template. Solve how should the company schedule the crews to minimize cost? B C D E E F G H H 1 1 2 3 Crew Cost Per Hour Flying Cost Other Cost $ 400.00 $ 150.00 4 Flying Hours Cos Other Hours Cost Total Cost of Rotatio Assign Crew to this Rotatic Crew Rotation Cost Other Hours 2 11 10 10 5 3 Flying Hours 6 3 5 4 6 6 3 7 6 4 - 7 8 4 4 7 12 - 7 . 5 5 - 7 7 3 3 9 + 5 Crew Rotation 6 Denver to Portland + Portland to Denver 7 Denver to Portland + (Portland to Denver)* 8 Denver to Portland + Portland to Vegas to +(Vegas to 9 Denver to Vegas +(Vegas to Denver) Overi 10 Denver to Vegas + Vegas to Portland + (Portland to 11 Portland to Denver + Denver to Portland 12 Portland to Denver + (Denver to Portland)* ( 13 Portland to Denver + Denver to Vegas +(Vegas to * Portland to Venca verseto Denver 14 Portland to Vegas +Vegas to Denver + (Denver to 15 Portland to Vegas + Vegas to Portland . 16 Vegas to Denver + Denver to Portland + (Portland to 17 Vegas to Denver + Denver to Vegas 18 Vegas to Portland + Portland to Vegas 40 19 Vegas to Portland + Portland to Denver + (Denver to 20 21 22 CONSTRAINTS 23 FLIGHT 24 Denver TO Portland 25 Denver TO Portland 26 Denver TO Vegas 27 Denver TO Vegas * Save 28 Portland TO Denver 29 Portland TO Denver 30 Portland TO Vegas 31 Portland TO Vegas 32 Vegas To Denver 33 Vegas To Denver 34 Vegas TO Portland 35 Vegas TO Portland 36 Minimize Cost CREW CONSTRAINT TIME OF DAY NUMBER OF CREWS AM PM AM PM AM PM AM PM AM PM AM PM