.NET / C# / Algorithm Expert Required

I want a C# Expert who have got an exhaustive knowledge of implementing picking algorithms like S-shape Routing, Heuristic etc and having experience in designing and developing Warehouse Management application logic.

Skills:

[url removed, login to view]

Algorithm

Command Line Scripting

SQL

Estimate: $100

Delivery: ASAP

Note: Those who think, can do it, let me know their understanding and logic in PM, only PM messages with reasonable queries would be entertained.

MARKETING EXECUTIVES PROMOTING THEIR PORTFOLIOS WILL BE IGNORED STRAIGHT AWAY, ONLY FREELANCERS/PROGRAMMERS

-------------------

PROBLEM DEFINITION (point wise bids also welcome. see problem definition below)

--------------------------------

Please refer to attached diagram for an example of a simple warehouse floor plan.

The warehouse consists of 6 racks of product bins A1-F10. Each product bin holds a unique type of product – a product is only accessible by standing directly in front of the product bin.

e.g A 'picker' standing at position 'X' can pick from product bins B6 and C6, whereas a picker standing in position 'Y' cannot pick from anywhere.

The order picking procedure is as follows:

A 'pick sheet' will print at the packing station P1, P2 or P3 & be collected by a picker. The pick sheet lists all products required for an order, the bin location for each product & the route the picker should follow.

When all items have been picked, the picker returns to the packing station where they collected the original pick sheet & deposits all items.

Note: Pickers can walk directly through the packing stations, but they cannot walk directly through any racking or product bins!

Tasks to do

---------------

1 Create a database of 60 products, assign each a stock level and a unique Bin location from the range A1 – F10 (see attached warehouse floorplan).

2 Provide a method for querying a product/bin location which returns the product description, bin location and current stock level.

3 Provide a method for creating an order. An order will always consist of 5 different products chosen by the user. If there is insufficient stock available to fulfil the order display a warning message, otherwise decrease the relevant stock level and calculate/display the optimum picking route.

4 From time to time, developer may want to check the picking route without placing an order. Provide a simple mechanism whereby a developer can use the Command Line Script to query 5 products and view the calculated route. The products must be specified as arguments to the Script.

The optimum picking route must start from one of the pick stations (P1, P2, P3), and is the shortest number of steps needed to 'pick' all of the products before returning to the original pick station. Choosing the starting pick station is part of the route and needs to be supplied by your picking algorithm.

5 The picking route, including the chosen starting pick station would usually be included on the pick sheet so it must be displayed in a way easily interpreted by the picker.

6 The user interface must be web based.

7 Write a short paragraph about the scalability of your solution, i.e. How would the implementation handle a much bigger warehouse?

8 An object oriented approach must be demonstrated.

9 The task must be completed using C# and MSSQL 200x.

.NET Algorithm C# Programming Software Architecture SQL

Project ID: #1448921

About the project