This is re-posted as I have not heard back from the person I was going to use.
I am after quite a simple Access DB for our new company. We currently sell ink cartridges, toners etc.
We currently use a large Excel sheet to work out prices based on the cost price, weight etc. There is also a seperate sheet that lists all the cartridges that fit into each printer.
What we are looking for is something that is a bit more tidy and faster to work with. The way we see this working is we create a product (cartridge) and then once we have that done, we then create the printer and then select all the cartridges that fit in that printer.
There could be some on going work on this if the design is good and if any modifications are needed.
Look forward to hearing back from you.
This is a copy of the PM I sent one guy on here to give him a better understanding of how we work out costs etc. I will also attach it so you can have a look.
The prices are worked out in the following way:
Cost price + postage cost (this needs to be drived from the weight and type of package eg, letter, large letter, packet, parcel) + stationary cost (this needs to be derived from another drop down selection box and includes different means of packaging the item) = SUBTOTAL
We then take the subtotal and enter a MARKUP rate (this is a percentage which defaults to 20%, but can be changed by us if needed) = NEW SUBTOTAL
NEW SUBTOTAL + VAT (again this is set at 17.5% but we also need to be able to change this (I was thinking a drop down box using a lookup as here in the UK we have different rates for different goods, again default to something like 'Std Rate - 17.5%'.
This then gives us our MINIMUM SALE PRICE.
We then enter the amount we actually sell at, find what the VAT amount is at the vakue selected above, and then finally the actual mark up we have used.
I hope that has made sense. If you send me your email address, I will email you the calculation sheet we are currently using in Excel.