Must use excel template below to solve:

	DV#1	DV#2
Decision Variables
Objective Function Coefficient
Constraints:			LHS	Sign	RHS
Constraint #1
Constraint #2
Constraint #3
Constraint #4

M6.1. Eye Med Corporation uses a raw material called FT131 in production operations at its five divisions (1,2,3,4,5). Only six supply chain partners (Acme ,Best, Carter , Diamond, Echo, Ford) of FT131 meet Eye Med's quality control standards. Each supply chain partner can meet any of the division's demands. The cost for each supply chain partner to ship to each division is shown in the table below. Eye Med believes in spreading its business among the supply chain partners so that the company will be less affected by supply problems (e.g., labor strikes or resource availability). Company policy requires that each division have a separate supply chain partner. Find the optimal assignment of supply chain partner to divisions that will minimize the total cost. DIVISION 1 Best 660 2 Acme 614 603 665 532 720 SUPPLY CHAIN PARTNER Carter Diamond 534 600 702 693 775 850 511 581 484 693 859 830 553 648 Echo 590 693 900 632 657 Ford 630 645 930 553 747 3 4 5 SOLUTION: The optimal solution, the value of the cost, should be $2,937. (Note: One supply chain partner will not be assigned to any division) Questions: a) Which Supply Chain Partner is assigned to Division 1? b) Which Supply Chain Partner is assigned to Division 2? c) Which Supply Chain Partner is assigned to Division 3? d) Which Supply Chain Partner is assigned to Division 4? e) Which Supply Chain Partner is assigned to Division 5? f) Which Supply Chain Partner is not assigned to any Division? Use the Alt LP Template.xlsx provided to you in the Module Documents & Files. Solve the problem using Excel Solver, place the answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the