(50 Points) Executive Furniture Company manufactures office desks at three locations: Des Moines, Evansville, and Fort Lauderdale. The firm distributes the desks through regional warehouses located in Albuquerque, Boston, and Cleveland. Estimates of the monthly supplies available at each factory and the monthly desk demands at each of the three warehouses are shown in the following figure: The firm has found that production costs per desk are identical at each factory, and hence the only relevant costs are those of shipping from each factory to each warehouse. These costs, shown in the following table, are assumed to be constant, regardless of the volume shipped. The goal is to determine the number of desks to be shipped on each route to minimize total transportation costs. a) Formulate the problem (25 Points) b) Solve the problem using Solver in Excel. (25 Points)