it a question from strategic management information system solution must be on excel

Problems From Chapter #31 Using Solver to minimize Transporation Costs Once you haw pace below Problem #3 The following table gives the distances between Boston, Chicage, Dallas, Les Angeles, and Miami. Each city requires 40,000 klowart nlight a hours (wh) of power, and Chicago, Dellas, and Miami are capable of producing 70,000 kWh. Assume that shipping 1,000 kWh over 100 mies costs $4 From where should power be sent to minimize the cost of meeting each city's demand? Los Angeles Chicogo 983 1,205 2,112 1,390 1,205 12 14 16 17 18 19 20 21