Please share workings from Excel. Need to understand how you calculated your findings.

(Q3: 20 pts) The company ABC is a used car dealership who buys 15 used cars from each of two car auctions each week held at different locations. It then transports the cars to repair shops it contracts with. When they are repaired (or restored) to meet specifications, the company sells 10 each to three different used car lots. Various costs associated with the average purchase and shipping from each auction to each repair shop are shown in Table 1. There are also transportation costs from the repair shops to the used car lots as shown in Table 2. The manager of ABC is concerned with supply chain network that minimizes its total costs. (Table 1) Repair Shop 1 Repair Shop 2 $850 $800 $900 $750 (Table 2) Used Car Lot 1 Used Car Lot 2 $400 Repair Shop 1 $150 Used Car Lot 3 $600 $550 Repair Shop 2 $450 $750 a) Develop a network representation of this problem. b) Formulate this problem as a transshipment linear programming model. Use the general notations for decision variables (i.e., Xij) c) Find the optimal solution. Submit Excel file, NOT a screen shot (Solver Solution) Auction 1 Auction 2