linear programming

Completed Posted 3 months ago Paid on delivery
Completed Paid on delivery

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)

Statistics Mathematics Matlab and Mathematica Statistical Analysis Excel

Project ID: #37504143

About the project

11 proposals Remote project Active 3 mos ago

Awarded to:


Hi, I can right away provide you with the solution through "Solver In Excel" as I have just finished doing it. I have the Scenario ready with the constraints implemented, to keep the overall cost at minimum. I can prov More

£15 GBP in 1 day
(0 Reviews)

11 freelancers are bidding on average £18 for this job


Heythere, I will help with the project on linear programming. I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments in this field and I will More

£40 GBP in 2 days
(111 Reviews)

Hi there! I can do your linear programming job accurately. My experience with Statistics, Mathematics, R Programming Language, Matlab and Mathematica and Statistical Analysis makes me the right person to help you com More

£19 GBP in 1 day
(10 Reviews)

Hello, Good afternoon? I hope this proposal finds you well. As an experienced freelancer, I have honed my skills in Statistics, Statistical Analysis, R Programming Language, Mathematics and Matlab and Mathematica an More

£23 GBP in 1 day
(4 Reviews)

Hi, I have experience in this kind of educational/academic projects(LP). Please contact me to discuss about details Thanks

£15 GBP in 7 days
(1 Review)

I bring a wealth of experience in optimization and modeling, making me the ideal candidate for creating a cost-effective recycled waste processing model. My approach involves formulating an objective function to minimi More

£20 GBP in 7 days
(1 Review)

My name is Laura and I am writing to you with enthusiasm in expressing my interest in the position available. I am currently pursuing a degree in Physics, a discipline that has provided me with a solid foundation in pr More

£13.5 GBP in 7 days
(0 Reviews)

Hi, I would love to get on this project and help you solve this LP problem. I'm highly experienced in the Optimization domain and I've worked with a lot of LP problems on Excel Solver. If accepted, I aim to deliver thi More

£15 GBP in 1 day
(0 Reviews)

Hi there. I am expert in Excel Solver Function and I can create linear charts. So If you can give your project I will do that within your deadline. I am waiting your response. Thank you.

£12 GBP in 2 days
(2 Reviews)

Dear Sir I hope you are well, Iam ready to perform this project for you, can I study your data and send you the requested model? Best regards, Mahmoud Saleh

£15 GBP in 7 days
(0 Reviews)

Hi, I have Review Attached document I am ready to Start work on it, Let's discuss on private Chat. Thank you

£15 GBP in 1 day
(0 Reviews)