Pls help break the solution down into steps to creat excel templete.

FlexSteal, marketed as a miracle brush$-$on sealant and baldness cure, is manufactured at three plants that are struggling to keep up with the demand at the four regional centers. The cost to ship a truckload from

each of the existing plants to the regional centers is shown in the table. Existing plants can produce up to $300($Low Capacity$).$ Note that the capacity and the total demand are both measured in truckloads.

The supply chain manager has explored plant construction costs in two other cities as well as the cost to ship a truckload from each of the plants to the regional centers. The current plan is to build another plant

with either a capacity of $300$ or a capacity of $500$ to allow room for sales growth. The construction cost for the new plants and cost to ship to each of the regional centers is shown here.

Use a sample EXCEL file $($See instructions$)$ to compute following costs.

a$.(3$ points$)$ By running EXCEL Solver, computer a setup cost of new plant$($s$).$

Answer: $$

b$.(3$ points$)$ By running EXCEL Solver, computer a total shipping cost.

Answer: $

c$.(3$ points$)$ By running EXCEL Solver, computer a minimum total cost

Answer: $

d$.(3$ points$)$ By running EXCEL Solver, which plants are in operation. This answer must include existing plants and potential plant$($s$).$

Answer:

e$.(3$ points$)$ By running EXCEL Solver, which plant has excess capacity $($inventory left$)?$

Answer: Plant