Question $1$

Computers Unlimited sells microcomputers to universities and colleges of the East Coast and ships them from three distribution warehouses. The firm is able to supply the following numbers of microcomputers to the universities by the beginning of the academic year: $420$ from Richmond, $810$ from Atlanta, and $330$ from DC for a total of $1,560.$ Four universities have ordered microcomputers that must be delivered by the beginning of the academic year: Northeastern needs $520,$ Tech needs $240,$ State needs $400,$ and Southeastern needs $380.$

The shipping costs per microcomputer from each warehouse to each university in the below in Cells J$16$ to M$18.$

Solve this problem using Solver.