Only the correct excel formulas to plug in the 3 gray highlighted cells are needed, not the calculation of the actual answer

(Answers should use =SUMPRODUCT() excel formula) Note: 1=yes 0=no

E A B C D E F G 1 Excercise: A trucking company has bases in the cities listed. The data shown are averages for a typical month. Find the total monthly 2 costs for all cities, for all Eastern cities, and for all Western cities with appropriate formulas. These formulas should react correctly even 3 if some cities are reclassified as Eastern, Western, or neither. Hint: How does a sum of products calculate when one of the columns has 4 all Os and 1s? 5 6 7 8 9 All cities 10 All Eastern cities 11 All Western cities 12 13 City Eastern city Western city Gallons per mile Miles per trip Trips per month Dollars per gallon 14 Boston 1 0 0.0435 120 50 $3.26 15 New York 1 0 0.0417 139 79 $3.43 16 DC 1 0 0.0313 197 120 $3.63 17 Charlotte 1 0 0.0303 171 70 $3.27 18 Philadelphia 1 0 0.0313 106 50 $3.49 19 Pittsburgh 1 0 0.0435 128 69 $3.39 20 Cleveland 1 0 0.0385 125 70 $3.65 21 St. Louis 0 0 0.0455 177 68 $3.44 22 Kansas City 0 0 0.0500 178 79 $3.50 23 Dallas 0 0 0.0333 117 127 $3.51 24 Houston 0 0 0.0357 169 128 $3.27 25 Atlanta 1 0 0.0323 190 122 $3.32 26 Miami 1 0 0.0400 162 96 $3.34 27 Los Angeles 0 1 0.0385 181 138 $3.41 28 San Diego 0 1 0.0400 119 101 $3.60 29 San Francisco 0 1 0.0476 166 88 $3.63 30 Seattle 0 1 0.0370 188 79 $3.29 31 Phoenix 0 1 0.0500 149 59 $3.30 32 Denver 0 1 0.0345 195 75 $3.49