You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter Fay
- Start date

Hello Fay,What would the objective be to minimize the cost, and also what would be the equation for the constraints?

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

Now, I will explain with an example you have provided me via conversation. Let's discuss your given problem here briefly:

"

A regional authority runs twelve recycling centres (A to L) accepting a variety of materials, many of which can be separated at the centres and transported to specialist sites for further processing. Items which don’t fit into any specific category are deposited in skips labelled “General Waste”. General Waste is transported from recycling centres to regional hubs ( P, Q, and R), where there are facilities to enable a preliminary separation of material, before transportation to a specialist facility (labelled S) for final processing.

I have processed the data you have provided to create the model and it turned out like this:

Now, let's set our objectives and constraints in Excel:

We need the coefficients to be the transportation costs per tone in

As expected, the function returns 0.

Now, let's set up our constraints based on the given sorting costs per ton and hub capacity. (See the below picture)

Let's get to our final calculations before accessing Solver. In

Similarly, enter the below formula in

As a result, we have completed our data processing for the

There it is! The output shows you need to transport 357.67, 409.6 & 288.45 tonnes of waste materials each time to get the minimum cost of £1326.29.

Ticket Pricing

I am attaching the final workbook here. Cheers!