Complete the following problem. See below for the link to this template. $(15$ pts$).$

Systems Unlimited sells personal computers to universities and colleges on the East Coast and ships them from three distribution warehouses. The firm is able to supply the following numbers of computers to the universities by the beginning of the academic year. $($See file$)$ Four universities have ordered computers that must be delivered and installed by the beginning of the academic year. $($See file$)$ The shipping and installation costs per computer are provided in the file.

Determine the shipments that will minimize total costs.

How many computers will Richmond provide to Central? $(2$ pts$)$

Steps:

Use this template: Transportation Problem Template.xlsx Download Transportation Problem Template.xlsx

Do not alter this template, it makes grading difficult, and alterations are not needed.

Add in the formulations needed in the excel spreadsheet. $(5$ pts$)$

Open solver and complete all the necessary fields as shown in the Transportation video. $(8$ pts$)$

Run solver.