Data stock take and sales amounts

I am after either a spread sheet or data base that can,

Calculate weekly/monthly/ yearly items sold and items deducted from what stock I have left

It would need: stock code, that knows How many items in that stock code e.g. buy 3 get 1 free , that can calculate: if I’m selling 3 for $25, but they get 1 free it would need to calculate 75 / 4 = `$18.75

These would need to be changeable in the spreadsheet or database

Able to deduct off flavor E.g. if they buy 2 and get one free , that stock code might have 2 mint flavor and two peach

At the moment I only have 3 flavors so it would need to be able to add more flavors when I get them in

There would be many variables

Buy 2 , might be one peach, one mint , or one natural and one mint, or 2 mint, or 2 peach or 2 peach and so forth

I would need to look at one sheet that shows weekly sales and stock then click another one and see monthly stock and sales

I have one peach flavor

I have one mint flavor

And one natural flavor

I will have a certain amount of stock, say 3300

As I add the stock codes, it will add the amounts and deduct the items from the overall 3300 stock I have at that present time

Maybe I can have an alert when stock is low so I can reorder with plenty of time

Skills: Microsoft Access

See more: get microsoft access for free, selling database, monthly database access, sales database microsoft access, free microsoft access stock database, free access stock database, add code access database, access weekly sales, microsoft access stock, access database code, can booking system hotel done database, stock sales microsoft access, sales microsoft access, alert database, access code codes, database codes, weekly sales access, access weekly database, access database sales, weekly sales database, codes database, access codes, access database weekly, weekly database access, look bucket

About the Employer:
( 0 reviews ) colombo, Sri Lanka

Project ID: #5879520

10 freelancers are bidding on average $296 for this job


[login to view URL] I have gone through your project requirements. I will do all the things mentioned in your request and all the combinations will be possible for sale of fruits and inventory of them I will do the job wit More

$277 USD in 10 days
(469 Reviews)

Hi, I can do the job, I am MS Access developer for a several years, I am a responsible worker, I enjoy my job, and I like to leave my clients satisfied Regards Diego

$250 USD in 5 days
(17 Reviews)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$250 USD in 10 days
(8 Reviews)

Hi, I have been an Access programmer ( that is all I do) in New Jersey for the last 18 years. I have worked on hundreds of projects large and small. This is exactly the type of project I specialize in. Because I hav More

$333 USD in 10 days
(1 Review)

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data More

$250 USD in 6 days
(10 Reviews)

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [login to view URL] Lollipop (video demonstration) [login to view URL] and feedback a More

$500 USD in 10 days
(6 Reviews)

Hi! I'm an experienced software developer and am interested in bidding on your project. My area of expertise is C/C++/C#,,, MS Access, vb6 and Dev2k,Form6/6i and crystal Reports. I have check the More

$250 USD in 5 days
(0 Reviews)

Sir/Madam, Greetings. This is an IT person and experienced Access database developer . TASK [login to view URL] me know your desired timeline & budget. I can be flexible in both timeline n budget as I can com More

$300 USD in 1 day
(0 Reviews)

I am an individual, new to and freelancing, but I am very experienced in the Microsoft technologies with over 10 years of experience. English is my first language and I am currently living in Indianapoli More

$300 USD in 10 days
(0 Reviews)

Hi, I've done extensive Access and Excel development for investment banks so your sales application would be very straightforward. Please let me know if I can be of assistance.

$250 USD in 5 days
(0 Reviews)