In the Optimization class of the template project start developing your optimization code below
the line marked as “CREATE OPTIMIZATION CODE BELOW THIS LINE”
2- Create a public function named SeasonalWarehousing with a single input argument as a
Database object (e.g. db As Database).
3- Initialize the Flow property of all arcs to zero using a For Each loop over [login to view URL], and
initialize your solver model using InitSolver
4- Using a For Each loop over [login to view URL], add a variable for each arc using the ID property
of the arc as the variable string. The upper bound for the variable is the Capacity of the arc for
each variable. The lower bound for the variable is the Capacity of the arc if the Type property of
the arc is “shipment” and 0 otherwise.
5- Create the warehouse capacity constraints for each period from 1 to [login to view URL] using a For
loop. Inside this loop, add a function using a function string by concatenating a word such as
“Warehouse” with the period number. Set the lower bound of the function as 0, and the upper
bound as db.WarehouseCapacity. Create a For Each loop over [login to view URL], in which you first
create a LINQ to retrieve the arc from the list [login to view URL]("period_" & i & "_" & p).ArcsOut,
where the Type property of the arc is “warehouse”. This list will return a single arc, which can be
used as the variable name in SetCoeff (e.g. list(0).ID) in the warehouse capacity constraint with a
coefficient of 1.
6- Create the objective function. Using a For Each loop over [login to view URL], set the coefficient of
each variable representing an arc as the Cost property of that arc. Solve the model using this
objective function by minimizing it.
7- If the solution is optimal, then use a For Each loop over [login to view URL] to set the Flow
property of each arc using GetVarValues with the arc ID, and return the objective function value
using GetFunValue. If the solution is not optimal, return -1, which concludes the function
8- Compile and run the template project to validate the results of the optimization code. Click on
the entries in lstNode to see ArcIn ArcsOut with flow values.
9- Create a second database (e.g. [login to view URL]) with five or more products over six or more
periods, and test your project on this new database.
10- Add a new form named frmProducts. Create a drag-n-drop interface on this form to visualize
your database. Change the “Copy to Output Directory” property of your database file (in the
Solution Explorer) to “Copy if newer” to allow changes to your database. Add a button on
frmWarehouse to open an instance of frmProducts.
3 freelanceria on tarjonnut keskimäärin 251$ tähän työhön
Greetings, I've reviewed your 10 steps and I can create the app from your attached project files along with access databases. let's engage in a discussion to assess my suitability for your project.