linear programming

Lengkap Disiarkan 3 bulan lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

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)

Statistik Matematik Matlab and Mathematica Analisis Statistik Excel

ID Projek: #37504143

Tentang projek

11 cadangan Projek jarak jauh Aktif 3 bulan lepas

Dianugerahkan kepada:

imraanlateef

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 Lagi

£15 GBP dalam sehari
(0 Ulasan)
0.0

11 pekerja bebas membida secara purata £18 untuk pekerjaan ini

monicawriter99

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 Lagi

£40 GBP dalam 2 hari
(111 Ulasan)
6.2
mwikalicarolyne2

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 Lagi

£19 GBP dalam sehari
(10 Ulasan)
4.7
wilfrednjorog

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 Lagi

£23 GBP dalam sehari
(4 Ulasan)
3.8
ionstefanache1

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

£15 GBP dalam 7 hari
(1 Ulasan)
3.5
odhiamborober

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 Lagi

£20 GBP dalam 7 hari
(1 Ulasan)
2.4
lscardenasu

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 Lagi

£13.5 GBP dalam 7 hari
(0 Ulasan)
0.0
Jaidev08

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 Lagi

£15 GBP dalam sehari
(0 Ulasan)
0.0
SmartOfficer

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 dalam 2 hari
(2 Ulasan)
0.0
MahmoudSaleh13

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 dalam 7 hari
(0 Ulasan)
0.0
drexcelprox

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

£15 GBP dalam sehari
(0 Ulasan)
0.0