Nick U. (job poster) hired Sameer A. (Tasker) to help with this task. Got a similar task you need done?

Hard Excel requirement with Solver

Posted by Nick U.



Due date
Tuesday, 16th Oct 2012
I need someone to help do a Network Optimization Model for me. It is not easy so if your excel / logical thinking skills aren't up for it, best you not give it a go. Its 2 products, 6 locations, exchange rates, transport costs, tariffs etc.. I've got all the data just not sure how to set up the spreadsheet and Solver for it all given all the variables listed above.
Sameer A.
No Completion rate

The percentage of accepted tasks this Tasker has completed.

Task Activity
7 comments about this Task
Comments are now closed
Hi Nick,
I have 2 questions for you:

1) What are the Capacity constraints that are uploaded to the blackboard under the assignment tab)

2) Would you know how to create the cost matrix for th year

Let me know if you have this information. Otherwise I won't be able to complete this task.


Nick U.poster
OK Cool. Will assign to you now!
I would surely wanna give it a crack as well. But surely will require the data to give it a go. Will work on it once assigned. But surely it shouldn't be that hard. I do this at work.
Nick U.poster
I'm sure its just a matter of setting up a master spreadsheet with all the data and calculations and copying that into different sheets and applying the changes and running the same solver... hope this is something you can do. I've had a good crack and will send through what I have done when I assign. Just want to give you an idea of what it is. Let me know if you think you will be able to do it. I can extend the due date also!! Thanks!
Nick U.poster
Hi Sameer,and Kavita, don't want to assign just yet, a bit more info. Its not just the solver part its setting up the spreadsheet as well, its two products, and 6 manufacturing plants, if a plant is only producing one product then only 20% of that products fixed costs apply, plus the plants fixed costs. Need to be able to run the problem/solver for different years and the different years have different exchange rates.
Task Assigned
0 new tasks