a. Formulate the problem and solve by using Excel Solver. That is how many computers from each DC will be shipped to each college and what will be the total cost? b. To better meet demand at the four colleges it supplies, the company is considering two alternatives: (1) expand Richmond DC to a capacity of 600, at a cost equivalent to an additional $6 in handling and shipping per unit; or (2) purchase a new DC in Charlotte that can supply 300 units with shipping costs of \$19 to Tech, \$26 to A \& M, \$22 to State, and \$16 to Central. Which alternative should management select, based solely on transportation costs? c. We're Computers has determined that when it is unable to meet the demand for PCs at the colleges it supplies, the colleges tend to purchase PCs elsewhere in the future. Thus, the firm has estimated a shortage cost for each PC demanded but not supplied that reflects the loss of future sales and goodwill. These costs for each college are as follows: Solve part (a) with these shortage costs included. Compute the total transportation cost and the total shortage cost. (Hint: Consider shortage as the 4thDC ). 9.1 We're Computers sells PCs to colleges on the East Cost and ships them from three distribution centers (DCs). The firm is able to supply the following numbers of PCs to the colleges by the beginning of the academic year. Four colleges have ordered PCs that must be delivered and installed. The shipping and installation costs per PC from each distributor to each college are as follows: a. Formulate the problem and solve by using Excel Solver. That is how many computers from each DC will be shipped to each college and what will be the total cost? b. To better meet demand at the four colleges it supplies, the company is considering two alternatives: (1) expand Richmond DC to a capacity of 600, at a cost equivalent to an additional $6 in handling and shipping per unit; or (2) purchase a new DC in Charlotte that can supply 300 units with shipping costs of \$19 to Tech, \$26 to A \& M, \$22 to State, and \$16 to Central. Which alternative should management select, based solely on transportation costs? c. We're Computers has determined that when it is unable to meet the demand for PCs at the colleges it supplies, the colleges tend to purchase PCs elsewhere in the future. Thus, the firm has estimated a shortage cost for each PC demanded but not supplied that reflects the loss of future sales and goodwill. These costs for each college are as follows: Solve part (a) with these shortage costs included. Compute the total transportation cost and the total shortage cost. (Hint: Consider shortage as the 4thDC ). 9.1 We're Computers sells PCs to colleges on the East Cost and ships them from three distribution centers (DCs). The firm is able to supply the following numbers of PCs to the colleges by the beginning of the academic year. Four colleges have ordered PCs that must be delivered and installed. The shipping and installation costs per PC from each distributor to each college are as follows