I want to do a desktop application to manage a small food production unit in C# .NET.
Multiple users can use the system simultaneously from different PCs. Means the software should have a login system with admin and restricted user accesses.
I should be able to create/edit/delete and print recipes. Please find an attached excel file in which you can see how our recipe looks like. Print a copy to see how it prints. See how it pulls values from the ingredient costing sheet.
To achieve this, we will need screens to manage suppliers, ingredients, recipes etc.
Ingredient screen should select supplier name added in the suppliers page. We can add cost of ingredients as well here.
Recipes use these ingredients and effectively the recipe will tell you the cost to make a particular litre of the product. Costing at the back end automatically.
Production planning. I should be able to select the recipes from the list of recipes and add it to a particular days production. Then I can print the list of total ingredients needed for the production for any day and the recipes.
I need clean coding. Good, consistent naming convention, good logic, 4th normalised db and documented code.
I prefer VB or C# .NET with MYSQL or free version of SQL server.
The attached screen shots and excel file will be helpful as a quide line.
Please start work only after you understand clearly what you are doing.
Thanks for your time.
VERY IMPORTANT: We make all recipes for a base litre say 10litre and then we can print recipes for a particular litre we need. When I do the production planning by selecting a recipe, I should be able to enter the litre amount for that recipe there so that it plans for that much litre of that particular recipe.
I have prepared some screen shots and this will give you a better idea about the project. Look at the attached sheets and let me know whether you can do this project in a week's time, with good coding skills. I have more works in pipeline. This is just a project to find some good coders. More than one coder could be accepted in the process. So, be competent.
* * *This broadcast message was sent to all bidders on Saturday Mar 8, 2008 11:38:26 AM:
Production management screen may be bit confusing. How much litre of product was made on a day will be shown in the production overview table in page 5. Date in columns and Recipe/products in rows. Total of each row and total of each column is to be shown as well. Calendar below will help to goto a particular day's production and modify/print it.