• Demonstrate screenshots, provide your explanations about the models you developed in this file.
• Provide your Excel and/or POM files along with your solution(s). In any Excel solution, provide essential formulas and take screenshots without excluding the column and row indices. In LP questions, do not forget to include your Solver settings. In any question, present your work as a guide to decision makers.
• can u send me steps with screenshots ? thank you so much from now love you

15) You will start a business that will purchase groceries from local suppliers, then transport to a central warehouse, and resell. You have agreed with 4 suppliers, purchased trucks, and hired drivers & employees. Your trucks will transport vegetables from those suppliers to your warehouse. Transportation costs are at your own expense. There is one decision left over: selecting the site to construct your warehouse. You will decide among three alternative sites on sale nearby, which are depicted below along with your suppliers: o 700 600 500 400 a D 300 200 100 0 0 100 200 300 400 500 600 SITES O SUPPLIERS From supplier at (100,200): 70 trucks/day From supplier at (200,500): 60 trucks/day From supplier at (400,600): 40 trucks/day From supplier at (500,300): 10 trucks/day All warehouse sites are sold at the same price. You should only consider the transportation costs from suppliers to warehouse sites. Estimate the transportation costs by the formula: Load x Distance (or Trips x Distance; actually, they both rely on the same idea). There is no need to involve fuel prices at this point. Which of the warehouse sites should be selected to minimize transportation costs? Develop a solution for this problem in Microsoft Excel and ranks the best option. 15) You will start a business that will purchase groceries from local suppliers, then transport to a central warehouse, and resell. You have agreed with 4 suppliers, purchased trucks, and hired drivers & employees. Your trucks will transport vegetables from those suppliers to your warehouse. Transportation costs are at your own expense. There is one decision left over: selecting the site to construct your warehouse. You will decide among three alternative sites on sale nearby, which are depicted below along with your suppliers: o 700 600 500 400 a D 300 200 100 0 0 100 200 300 400 500 600 SITES O SUPPLIERS From supplier at (100,200): 70 trucks/day From supplier at (200,500): 60 trucks/day From supplier at (400,600): 40 trucks/day From supplier at (500,300): 10 trucks/day All warehouse sites are sold at the same price. You should only consider the transportation costs from suppliers to warehouse sites. Estimate the transportation costs by the formula: Load x Distance (or Trips x Distance; actually, they both rely on the same idea). There is no need to involve fuel prices at this point. Which of the warehouse sites should be selected to minimize transportation costs? Develop a solution for this problem in Microsoft Excel and ranks the best option