linear programming
Budget: £10 – £20 GBP
What would the objective be to minimize the cost(as an equation), and also what would be the equation for the constraints?
The main question asks to:
Create a recycled waste processing model and solve using Excel Solver.
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.
the regional authority is keen to develop a planning tool which will enable it to transport General Waste in the most cost-effective way possible. Costs are incurred when transporting from a recycling centre to a hub, and from a hub to the specialist facility. Additionally, there is a cost incurred when carrying out the preliminary sort at the hubs.
The data provided is as follows(numbers provided in excel screenshot):
• Number of tonnes of General Waste to be recycled at each of the recycling centres
• Transportation costs between recycling centres and the hub (£ per tonne) (Note: it is not possible to transport General Waste from all recycling centres to all hubs and infeasible routes are indicated by an x)
• Hub capacity (in tonnes) – there is a limit as to how much General Waste a hub can receive from recycling centres
• Preliminary sorting costs at each hub (£ per tonne)
• Transportation costs between hubs and the specialist facility (£ per tonne)
The main question asks to:
Create a recycled waste processing model and solve using Excel Solver.
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.
the regional authority is keen to develop a planning tool which will enable it to transport General Waste in the most cost-effective way possible. Costs are incurred when transporting from a recycling centre to a hub, and from a hub to the specialist facility. Additionally, there is a cost incurred when carrying out the preliminary sort at the hubs.
The data provided is as follows(numbers provided in excel screenshot):
• Number of tonnes of General Waste to be recycled at each of the recycling centres
• Transportation costs between recycling centres and the hub (£ per tonne) (Note: it is not possible to transport General Waste from all recycling centres to all hubs and infeasible routes are indicated by an x)
• Hub capacity (in tonnes) – there is a limit as to how much General Waste a hub can receive from recycling centres
• Preliminary sorting costs at each hub (£ per tonne)
• Transportation costs between hubs and the specialist facility (£ per tonne)