(Answered) : Someone Explain Solve Question Excel Solver Formulas Need Use Also Construct Dummy Variabl Q36283490

Can someone explain to me how to solve this question in ExcelSolver, What formulas do I need to use, Also how Can I Construct aDummy Variable for this question, I am really lost.. Please help meunderstand

Nortex Chemicals, Inc. is involved in the natural gas processing industry in the Texas Panhandle One of its primary operations involves purchasing large tanks, each roughly the size of a rail car of particular byproducts from natural gas processing. It further purifies