Please help solve all of the problems with data solver using the excel template given above. Please also give the step-by-step solution and explanation.

Because there are a total of 3 different excel template, i will post this questions 3 times, and u can just copy paste the answer and i'll give three thumbs up.

Thank you very much.

2. Catch \& Release (C\&R) Co. produces fly boxes. C\&R has three small plants. C\&R supplies their items to four fly fishing shops. There are three warehouses to stop by. The shipping cost is calculated as following: Shippingcost=$1thenumberofboxesxthedistance(StartwithMAXorMIN)1.WriteObjectiveFunctionusingdecisionvariablesthatdefinedabove Plant 1 and plant 2 can produce up to 800 items and 1000 items respectively. And 2. Write all the constraints. warehouses also have their capacities, 500,700 , and 600 items for warehouse 1 , 3. Create a Spreadsheet model of the problem on Excel and find the optimal 2 , and 3, respectively. solutions for Pij and Wif (Make sure you generate Sensitivity report) Fly fishing shops order 200,500,600 and 300 items for shop 1,2,3 and 4 , 4. What is the Optimal total cost? respectively. 5. If it is possible to increase the capacity of warehouse 1 by up to 100 , but it Pij : Shipment(No. of items) from plant i to Warehouse j will cost $10 dollar per unit. Would you increase the capacity of Wij : Shipment(No. of items) from Warehouse i to fly shop j 6. C\&R's logistics manager is thinking of introducing new route by renting a new truck. The new route is from Plant 1 to fly shop 3 without stopping any warehouse. The distance between Plant 1 and Fly shop 3 will be 35 . And the initial cost of new route (including truck rental and driver's salary) will be $2,000. What would be the transportation cost with the new route? (excluding initial cost of new route $2,000 ) You need to modify the spreadsheet model and solve the problem again 7. Would the new route be advisable to implement? If yes how much C&R can save after implementation? Explain 8. The cost of new route turned out to be way greater than we expected. Therefore, the C&R decided not to implement the new route. Instead, the C\&R merged another fishing shop. And the CEO wants to add the new plant from the acquisition. The third plant will have the capacity, 1000 and can provide items to all three warehouses. New network with the third plant would be like the picture in the next page. However, CEO said, "Since the new plant will be added, we might close one of our current plant and we can save fixed cost for the plant". As an analyst, you should find out if the third warehouse would be beneficial to add. And if we would like to close one warchouse which one we should close, out of three? The fixed costs to open plants 1,2 and 3 are $5,000,$6,000 and $7,000