A stock report needs to be created for some 50-60 species of items with an accrued total of 1000 items of stock.
Each item has its own identification number, also weight per kilogram is indicated, and then total price per item dependant on its weight per kilogram. Then an overall total for those particular items in a species category. The report also needs to generate a base case summary, that indicates all summary information at a glance to a viewer.
All information has already been entered in excel, however a tool is required to access this information through a ASP application to make information more easily accessible. This particular project simple requires what is already entered in an excel spreadsheet to be represented now in a more easy user format with track/search functions, as well as other functions such as the sale of the item being recorded and the overall stock quantity being automatically updated by the application.
Once the existing spreadsheet has been viewed it will be easier to ascertain the parameters required.
You must submit a timeframe and stick to a strict deadline for delivery of the completed project. Additional fees will be paid for value added inputs based on the developers skills, expertise and experience in enhancing the application with additional functions by reviewing the raw data available.
The end tool/application needs to be able to be hosted on a server, and accessible by multiple users who login to access the stock report, as well as carry out activities with the stock and update the information which is immediately updated on the system so that others realise that the item is/is not available any longer.
The successful vendor would also receive first rights to other such minor applications that are applicable to other areas adopting the same core design and functional principles.