LINEAR PROGRAMMING MODEL URGENT PLS

A widget manufacturer operates five production facilities, and must purchase the required raw material from one of the three vendors. Vendors 1, 2, and 3 can supply at most 360, 270, and 450 pounds of raw material, respectively. In order to satisfy the current demand for widgets, Production Facilities 1, 2, 3, 4, and 5 require 180, 90, 230, 210, and 140 pounds of raw material, respectively. The unit cost of shipping 1 pound of raw material from each vendor to each production facility is given in the table below:

	To Production Facility (cost, $/Pound)
From	1	2	3	4	5
Vendor 1	12	14	13	16	18
Vendor 2	15	19	14	15	16
Vendor 3	20	17	16	12	17

a) Provide the mathematical formulation for this problem.

b) Use Solver to solve this problem.