Please answer a-f showing the formulas

Decision Variables \begin{tabular}{|l|c|c|c|c|c|} \hline 19 & \multicolumn{6}{|l|}{ Philadelphia } & Atlanta & Dallas & Los Angeles \\ \hline 20 & 350 & 350 & 350 & 350 \\ \hline 21 & Unmet Demand & 350 & \end{tabular} Constraints FlexSteal, marketed as a miracle brush-on sealant and baldness cure, is manufactured at three plants (Plant 1 , Plant 2, and Plant 3) that are struggling to keep up with the demand at the four regional centers (Philadelphia, Atlanta, Dallas, L.A.). The operating cost to ship a truckload from each of the existing plants to the regional centers is shown in the Excel table (B4:E6). The capacity (F4:F6) and the demand (B9:E9) are both measured in truckloads. The supply chain manager has explored plant construction costs in two other cities as well as the operating cost to ship a truckload from each of the plants to the regional centers. The plan is to build a new plant at either A or B with a capacity of 400 to allow room for sales growth. The construction costs for the new plants (G7:G8) and the cost to ship to each of the regional centers (B7:E8) are also shown in the Excel table. a) State the formula for unmet demand at Philadelphia at Cell B21. b) State the formula for Excess Capacity with Plant 1 at Cell B26. c) State the formula for Total Cost at Cell E25. d) State the formula for "Changing variable" cells in Solver. e) State the formula for "Constraints" cells in Solver. f) What is the lowest cost solution for adding a new plant? Decision Variables \begin{tabular}{|l|c|c|c|c|c|} \hline 19 & \multicolumn{6}{|l|}{ Philadelphia } & Atlanta & Dallas & Los Angeles \\ \hline 20 & 350 & 350 & 350 & 350 \\ \hline 21 & Unmet Demand & 350 & \end{tabular} Constraints FlexSteal, marketed as a miracle brush-on sealant and baldness cure, is manufactured at three plants (Plant 1 , Plant 2, and Plant 3) that are struggling to keep up with the demand at the four regional centers (Philadelphia, Atlanta, Dallas, L.A.). The operating cost to ship a truckload from each of the existing plants to the regional centers is shown in the Excel table (B4:E6). The capacity (F4:F6) and the demand (B9:E9) are both measured in truckloads. The supply chain manager has explored plant construction costs in two other cities as well as the operating cost to ship a truckload from each of the plants to the regional centers. The plan is to build a new plant at either A or B with a capacity of 400 to allow room for sales growth. The construction costs for the new plants (G7:G8) and the cost to ship to each of the regional centers (B7:E8) are also shown in the Excel table. a) State the formula for unmet demand at Philadelphia at Cell B21. b) State the formula for Excess Capacity with Plant 1 at Cell B26. c) State the formula for Total Cost at Cell E25. d) State the formula for "Changing variable" cells in Solver. e) State the formula for "Constraints" cells in Solver. f) What is the lowest cost solution for adding a new plant