Please help with the calculations as I am new with Excel Solver, and I am having problems formulating.
For the LP problems, you will need to solve using the Excel Solver. We have used the Sum Product feature when using Excel. So in cases where you can use that, please do so.
See the attached file.
The spreadsheet incorporates each route assignment as an ...
The solution assists with the Sum Product feature when using Excel.