I need to solve the problem attached to the spreadsheet
It’s a linear programming model
Only people with excel modeling experience
Only people that knows this type of problems and models
Must solve the problem and put a step by step solution very DETAILED in order to explain this quite easy ( this also includes the logic use to solve the problem and the step by step guide to make the model in excel, and different test scenarios )
The price is fixed to $15 CAD
Not sure if the initial formulation could be solved through linear optimization, it requires non linear solver. The second step of cooks scheduling could be done through linear solver. I can provide the optimal solution model along with step by step procedure in excel to achieve the same.