Solve using excel. Use solver and solver table. Please add what your solver and solver table inputs are.

B Network Homework 2 4 Accuracy Always Accounting has locations in Minneapolis, Seattle, Houston, and Boston. They perform a variety of 3 annual audits for a number of companies, large and small. For their larger clients, AA sends traveling audit teams on location at least once per year. Suppose AA needs to send a team of 20 people to a client in Sacramento, 30 people to a client in Miami, 15 people to a client in Denver, and 25 people to a client in Chicago. AA's Minneapolis office can spare 20 auditors, Seattle can proved 50 auditors, the Houston office has 30 available auditors, and Boston has 40 available auditors for these projects. A round-trip flight must be purchased for each auditor to travel from their respective AA 7 offices to the client they will be auditing. The price of airfare is provided below. 6 10 Minneapolis Seattle 11 Houston 12 Boston 18 19 20 21 22 23 24 13 15 14 Find a way to minimize cost for AA while meeting the constraints discussed. Your final answer should be $19,025. Suppose the Minneapolis office has a potential change in schedule which may free up as many as 10 more auditors. Once you have optimized this model, use Solver Table to see what happens to costs and auditors sent from each location with the possible, incremental change in the Minneapolis office. 16 17 25 26 27 30 31 32 33 34 35 36 37 38 39 40 41 D $207 $317 $581 E Sacramento Miami Denver Chicago $401 $307 $159 $137 $600 $243 $333 $240 $162 $208 $340 $311 $260 F G H K L