In excel:Accuracy Always Accounting has locations in Minneapolis, Seattle, Houston, and Boston. They perform a variety
Posted: Mon Jul 11, 2022 11:24 am
In excel:Accuracy Always Accounting has locations inMinneapolis, Seattle, Houston, and Boston. They perform avariety of annual audits for a number of companies, large andsmall. For their larger clients, AA sends traveling auditteams on location at least once per year. Suppose AA needs tosend a team of 20 people to a client in Sacramento, 30 people to aclient in Miami, 15 people to a client in Denver, and 25 people toa client in Chicago. AA's Minneapolis office can spare 20auditors, Seattle can proved 50 auditors, the Houston office has 30available auditors, and Boston has 40 available auditors for theseprojects. A round-trip flight must be purchased for eachauditor to travel from their respective AA offices to the clientthey will be auditing. The price of airfare is providedbelow.
Sacramento Miami Denver Chicago
Minneapolis $401 $307 $159 $137
Seattle $207 $600 $243 $333
Houston $317 $240 $162 $208
Boston $581 $340 $311 $260
Find a way to minimize cost for AA while meeting the constraintsdiscussed. Your final answer should be $19,025.
Suppose the Minneapolis office has a potential change inschedule which may free up as many as 10 more auditors. Onceyou have optimized this model, use SolverTable to see what happensto costs and auditors sent from each location with the possible,incremental change in the Minneapolis office.
Sacramento Miami Denver Chicago
Minneapolis $401 $307 $159 $137
Seattle $207 $600 $243 $333
Houston $317 $240 $162 $208
Boston $581 $340 $311 $260
Find a way to minimize cost for AA while meeting the constraintsdiscussed. Your final answer should be $19,025.
Suppose the Minneapolis office has a potential change inschedule which may free up as many as 10 more auditors. Onceyou have optimized this model, use SolverTable to see what happensto costs and auditors sent from each location with the possible,incremental change in the Minneapolis office.