DO NOT USE THE ONES EXISTING ON CHEGG - IT'S NOT WHAT I WANT - ANSWER THE QUESTION COMPLETELY

SHOW YOUR WORK AND EXPLAIN - so I understand how to put it in excel, how does it work, etc.

2. A retail chain comprises of 5 retailers R1,R2,R3,R4, and R5. Also, there are three suppliers S1,S2, and S3 who can supply to each of the 5 suppliers. The 5 suppliers face a demand of 10,000 each. The production capacity of each of the suppliers is 20,000 . The transportation cost of a unit of product between a supplier and retailer is as follows: \begin{tabular}{l} \\ \hline S1 \\ \hline S2 \\ \hline S3 \\ \hline \end{tabular} Determine the quantities supplied by the suppliers to the retailers that minimize the total cost of transportation. Specifically, answer the following questions: (60 points) (a) Write down the decision variables and objective function. (20 points) (b) Write down all the constraints. (20 points) (c) Setup the problem in excel and use the solver to solve. (10 points) (d) Provide a diagram of the optimal network. It's okay to hand draws the network. (10 points) Formulate the above problem if it is also given that setting up each supply source has a fixed cost of $25,000 /supply source. ( 30 points) a. Write down the decision variables. (10 points) b. Write down the objective function. (10 points) c. Write down all the constraints. (10 points)