Hello Fay,
Thanks for sharing your experience with us. I understand you want to find the objectives, and equation of the constraints to minimize cost using Solver in Excel.
Please, read our article Excel Solver to Minimize Cost with Examples to gain a general idea of how Solver works. Here, we...