Save this already loaded solver model in L14 in the following worksheet and generate a feasibility report.

Next, load the model in L3, run it and create an answer report. (Select REPLACE, not merge when prompted).

Finally, provide answers to the following and highlight tyour answers: From the feasability report, which food retailer will not receive their order? Comparing the two solver models, please explain why the first solver model is infeasible and what constraints changed in the second model.

Ingredients R US, Inc. Order Distribution Plan
		Shipping Costs from Distribution Center (per pallet)			Numberof Items Shipped
Food Retailers	Pallet Orders	Distribution Ctr. 1	Distribution Ctr. 2	Distribution Ctr. 3	Distribution Ctr. 1	Distribution Ctr. 2	Distribution Ctr. 3	Shipped	Total Costs
Food Buzz	60	$ 20.25	$ 78.15	$ 27.15	60	0	0	60	$ 1,215.00
Healthy Stuff	78	$ 50.85	$ 50.00	$ 47.90	0	0	78	78	$ 3,736.20
Smoothie City	125	$ 84.00	$ 38.40	$ 65.55	0	125	0	125	$ 4,800.00
Burger Barn	187	$ 86.65	$ 25.40	$ 13.90	0	0	187	187	$ 2,599.30
Caf Organic	313	$ 108.95	$ 21.50	$ 33.95	313	0	0	313	$ 34,101.35
Dessert Center	567	$ 116.45	$ 7.95	$ 26.20	567	0	0	567	$ 66,027.15
Total	1330				940	125	265	1330	$ 12,350.50
Initial Inventory					1,005	335	275	1,615
Remaining Inventory					65	210	10	285
Infeasible Constraints
Number Shipped (F5:H9)	int	Integer
Shipped (I5:I9)	>=	Demand (B5:B12)
Total Costs (J10)	<=	12,000
Constraints with Solution
Number Shipped (F5:H9)	int	Integer
Shipped (I5:I9)	>=	Demand (B5:B12)
Review of Model:
Ingredients R US, Inc. provides the raw materials for food preparation to several local eateries.
The ingredients are ordered by pallet and transported from one of three distribution centers.
Depending on order type, the nearest distribution center cannot always be utilized to fill orders.
Ingredients R US, Inc. has tasked you with satisfying demand while minizing total cost to ship product to customers.