Access Database (fairly simple) - Inventory usage and reorder point
- or -
Post a project like this1994
$$
- Posted:
- Proposals: 9
- Remote
- #2164894
- Awarded
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
SOFTWARE PROFESSIONAL EXPERIENCED IN DEVELOPMENT OF MS ACCESS DATABASE FOR LAST 20 YEARS
Kolkata
270269723760963451164609218761301884039188945423477992359079
Description
Experience Level: Intermediate
I have a cleaning company and we use 30-40 different cleaning products and 10-20 office products that I would like to track monthly usage and cost and set reorder points and quantities. (we don’t sell them, just use them) we do inventory once a month, I have a excel spreadsheet that I have been trying to use. I need to be able add new products, add different suppliers, have different reorder points. i.e. window cleaner if I average 5 gallons used per month I want to reorder when I have less than 2 months stock and I want to reorder so I have a 6 month stock. So when I do inventory at the end of the month if I have 8 in stock I would like the database to put that I need to order 22 more bottles (5x6=30, 8+22=30) There also is a quantity that comes in a case that would need to be accounted for, for this example if a case of window cleaner contains 5 per box, then I would need to order 5 cases which is actually 25 more bottles of window cleaner instead of 22. Some items like comet I only want 3 month supply and reorder if I’m under 1.5 months. I will send the spreadsheet look at tab Sept. 2018 to get an idea of what I was doing… (not pretty). This spreadsheet only has cleaning supplies, I would need to be able to add the office supplies to the database.
Travis C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
28 Oct 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Travis;
Do you want to enter and see just the results of your last situation from the database?
Also do you want from the database to warn you if the critical limits reaches?
Regards,
Selçuk K.
AS Web Development Team
720676
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies