We require some software written (VB6, or VB2008 Express) for my roof manufacturing business.
The software will comprise stock management (Parts as well as Bar Lengths), job management, job optimisation, a cutting screen (computer gets placed next to our saw showing what to cut next - from the optimised cutting list) as well as the back end options and settings.
The system should use a mysql database, and be multi-user capable, eg a user can add new jobs whilst another user is cutting etc. ? The database will be connected via the office network, the settings for the DB must be configurable.
The database will include info about all parts we stock, as well as minimum order levels. ? The system will be able to print order lists.
When a job is entered in the system, the stock is marked as 'reserved', if the stock minus reserved < minimum stock then order more to bring stock back up to minimum stock level.
The software must implement a stock optimisation strategy, for cutting the bar lengths. ? The algorithm used must be at least as good as commercial offerings (I can provide examples from a commercial optimiser). ? For research on this - it is commonly known as the 1D bin packing problem.
There is a $50 bonus if your algorithm correctly optimises the bars with angled cuts on the ends.
Full details will be developed/evolved with the successful bidder, and bonuses will be payable for additional features.
Please bid based on the information above, we will however finalise the bid based on a more formal requirements list and prototype (eg screen layouts and flowcharts), with the option to opt-out (with 10% payout) at this stage.
After the requirements are set, and the bid agreed, payment will be made for milestones, with bonuses paid for any additional features I request after the formal requirements stage.