Logistic optimization using Excel solver

**ElBeginnerDon** · 04-26-2020, 11:07 AM

Hi everyone

**ElBeginnerDon** · 04-27-2020, 04:15 AM

Hello, it's me again. I have solved my problem thanks to a link that had been sent in another discussion. However, it seems it is not possible to generate the limits' and sensibility's reports in order to analyze the results given by the Excel Solver. I think this may come from the fact that my objective function is a sum of two sum products. Does anyone know how to workaround this problem?
Thank you for your time!

**ElBeginnerDon** · 04-27-2020, 09:52 AM

UP please
Can anybody help me here?

**Pepe Le Mokko** · 04-27-2020, 11:14 AM

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

**MrShorty** · 04-27-2020, 11:43 AM

I am unable to understand exactly what you need help with.

I see your SUMPRODUCT() in B23 where you calculate the distribution cost. Right now there is nothing in C6:E8, so this is returning 0.
It's not clear to me how you intend to calculate construction costs. I put =SUMPRODUCT(K16:M16,K17:M17) into B24 as a guess of how you intend to calculate the construction costs, but your OP suggests that you need something more complicated to compute construction costs. This seems to be the main question you are asking is how to calculate the construction costs, but I am not sure how you intend to calculate construction costs. Can you explain in more detail (maybe even work out an example by hand)?

Once you have distribution costs (in B23) and construction costs (in B24?), then you can compute total costs -- presumably as a simple SUM() of these 2 =SUM(B23:B24). Then have Solver minimize this SUM() function by changing the various decision variables.