Embroidery Thread Stock Control

This is an embroidery factory project. Factory imports its own embroidery threads and uses it for personal use as well as sell to other embroiderers. It has a warehouse where majority of the stock is held. Factory floor has threads used for internal use. Orders placed by other embroiderers are despatched straight from warehouse. End of every week empty cones from factory are recorded to prove no cones are missing or stolen. This also shows how many cones were consumed in that period. Past experience has taught us a lesson where we ended up selling our thread to others and we ended up not having enough thread for ourselves and hence had to buy at a very high rate. Once job gets allocated you need to feed in the existing data and email me the final file. Existing entries are approx. 300. Limit should be at least a minimum of 1000 which we shall update ourselves when we add more thread at a later date. We need the following reports at end of every month: 1. current stock in warehouse 2. current stock in factory floor 3. the month's empty cones 4. cones sold to other embroiderers 5. breakdown of any one colour of thread showing how many are in warehouse or factory or sold last month 6. data of how much a customer has bought in the past giving description of the items (colour ref & qty) 7. reorder point alert Need evidence of similar work done. Serious bidders only....no time wasters. THIS PROJECT NEEDS TO BE COMPLETED IN 1 WEEK TOPS!! WE ALREADY HAVE QUICKBOOKS SO WE WOULD PREFER TO USE THE SAME PROGRAM. OTHERWISE IF YOU HAVE ANOTHER OPTION WHERE I CAN GET BETTER REPORTS THAN QUICKBOOKS, I'D BE INTERESTED. I'LL NEED TO SEE YOUR WORK FIRST.