Create a Linear Optimization Model using Excel and Solver tool

Create a working broad Linear Optimization Model from the Case Study provided using Excel and the Solver tool.
– List out all the constraints.
– Explain how you got the solution.
I just want a Linear Optimization model to be created in excel and then calculate its prediction using the Solver tool provided by excel. I also want all the constraints to be listed out and a possible explanation of how you analyzed the model and how you received each formula/solution.
Please watch this video for a detailed explanation and look especially at the Methods section as that’s how I want the methods for the case study to be listed.

Also, feel free to use the attached excel sheet to create the Linear Optimization model in it using the Solver tool.