Đang Thực Hiện

121850 Ink Cartridge Database

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.

Kỹ năng: Bất kì công việc gì, Microsoft Access, Visual Basic

Xem thêm: design packet, visual basic cost, create design box packaging, take packaging design, sell packaging design, sale packaging design, rate visual basic, rates packaging design, product packaging design person, product packaging box design, product package design price, price letter design, packaging design sale, packaging design costs, packaging design box set, packaging design box price, packaging box design price, packaging box design company, new packaging design costs, i parcel, set packaging design price, price packaging design, find packaging, find minimum cost, find packaging company

Về Bên Thuê:
( 0 nhận xét )

Mã Dự Án: #1868016