The planning team wants to understand how they should source the next weeks production to three locations: location A, location B, and location C. They are concerned with 4 products that can be produced in each facility. Each product can only be sourced to a single facility (a facility can produce multiple products.) Create an Excel model using the data below to determine the sourcing plan to minimize the cost of production. Please include screenshots of all Excel formulas used and a screenshot of the formulas in Solver. All information for this problem is included in the data set below.

	A	B	C	Demand
Mechanical Water Pump	$33	$41	$46	60
Cartridge Water Pump	$26	$32	$28	60
Oil Pump	$17	$14	$20	75
Hydraulic Housing	$40	$42	$60	45
Hrs. available	25	52	64
Consumption rate (mins)	A	B	C
Mechanical Water Pump	35	30	32
Cartridge Water Pump	28	24	22
Oil Pump	42	40	36
Hydraulic Housing	55	48	45