What is the formula for the operating cost for each destination?

Can you write out what it is and show the answers for each one please.

A B D E F G H ! K L M N 0 P 1 Rose Tree Regional Airline Assignment Problem 2 3 4 Constants Section: Plane Data: Cargo Capacity Fill Legend 5 6 7 8 9 9 10 Operating Cost per Passenger Mile $0.110 $0.100 $0.090 $0.075 Passenger Capacity 117 78 70 133 Plane Type Boeing 717 Bombardier CR700 Embraer E170 Airbus A220 Fee Schedule: Operating Cost per Cargo Mile $0.055 $0.050 $0.045 $0.035 935 150 156 Changing Cells Optimization Cell Available Fleet 15 18 12 5 838 11 12 13 14 15 16 17 18 19 20 Destination Las Vegas Albuquerque Denver Cheyenne Boise Reno Phoenix Average Ticket Price $213 $263 $127 $678 $133 $317 $274 Cargo Price/ft3 $300.00 $150.00 $200.00 $200.00 $300.00 $125.00 $175.00 Plane Assignment Costs Extra Add'l Cargo Daily Demand Daily Daily Cargo Passenger Shipments Bookings Boeing 717 Bombardie r CRJ700 Embraer E170 Airbus A220 Total Passenger Capacity to be Added 1 Calculations and Results Section: Distance from Destination Salt Lake Hub Las Vegas 313 Albuquerque 421 Denver 322 Cheyenne 321 Boise 257 Reno 372 Phoenix 439 Total/Avg 1 1 21 22 23 24 25 26 27 28 29 30 1 1 750 500 550 100 750 500 1,250 4400 1,500 1,500 2,000 1,500 1,000 750 500 8750 1 1 1 1 1 1 11 1 7 1 1 1 1 1 7 Plane Utilization % of Total Passenger Cargo Capacity Capacity Utilized 188% 2,079 126% 2,079 138% 2,079 25% 2,079 188% 2,079 126% 2,079 314% 2,079 158% 14553 1 1 1 1 1 1 7 1 1 11 11 1 71 398 398 398 398 398 398 398 2786 % of Cargo Operating Capacity Cost Utilized 72% $ 175.28 72% $ 235.76 96% INCCORECT 72% 48% 36% 24% 60% 411 Total Cost 0 Operating cost-Cells N22 through N28 hold the operating cost for each plane type to each des- tination. The cost is calculated by the following formula: Number of planes assigned x Operating Cost per passenger mile x Mileage to destination + Number of planes assigned Operating Cost per cargo mile x Mileage to destination A B D E F G H ! K L M N 0 P 1 Rose Tree Regional Airline Assignment Problem 2 3 4 Constants Section: Plane Data: Cargo Capacity Fill Legend 5 6 7 8 9 9 10 Operating Cost per Passenger Mile $0.110 $0.100 $0.090 $0.075 Passenger Capacity 117 78 70 133 Plane Type Boeing 717 Bombardier CR700 Embraer E170 Airbus A220 Fee Schedule: Operating Cost per Cargo Mile $0.055 $0.050 $0.045 $0.035 935 150 156 Changing Cells Optimization Cell Available Fleet 15 18 12 5 838 11 12 13 14 15 16 17 18 19 20 Destination Las Vegas Albuquerque Denver Cheyenne Boise Reno Phoenix Average Ticket Price $213 $263 $127 $678 $133 $317 $274 Cargo Price/ft3 $300.00 $150.00 $200.00 $200.00 $300.00 $125.00 $175.00 Plane Assignment Costs Extra Add'l Cargo Daily Demand Daily Daily Cargo Passenger Shipments Bookings Boeing 717 Bombardie r CRJ700 Embraer E170 Airbus A220 Total Passenger Capacity to be Added 1 Calculations and Results Section: Distance from Destination Salt Lake Hub Las Vegas 313 Albuquerque 421 Denver 322 Cheyenne 321 Boise 257 Reno 372 Phoenix 439 Total/Avg 1 1 21 22 23 24 25 26 27 28 29 30 1 1 750 500 550 100 750 500 1,250 4400 1,500 1,500 2,000 1,500 1,000 750 500 8750 1 1 1 1 1 1 11 1 7 1 1 1 1 1 7 Plane Utilization % of Total Passenger Cargo Capacity Capacity Utilized 188% 2,079 126% 2,079 138% 2,079 25% 2,079 188% 2,079 126% 2,079 314% 2,079 158% 14553 1 1 1 1 1 1 7 1 1 11 11 1 71 398 398 398 398 398 398 398 2786 % of Cargo Operating Capacity Cost Utilized 72% $ 175.28 72% $ 235.76 96% INCCORECT 72% 48% 36% 24% 60% 411 Total Cost 0 Operating cost-Cells N22 through N28 hold the operating cost for each plane type to each des- tination. The cost is calculated by the following formula: Number of planes assigned x Operating Cost per passenger mile x Mileage to destination + Number of planes assigned Operating Cost per cargo mile x Mileage to destination