Décerné

Excel Shipping Cost Calculator

I send parcels out daily from 50-200 articles per day.

I need to check that my shipper ( Australia Post) is charging me correctly.

Charges vary by weight and by postcode zone.

Postcode zones and the associated postcodes are included in attachment.

Our warehouse is located in zone V1 so postage charge examples are:

1. Upto 500g to other V1 postcodes = cost is $4.87

2. Upto 500g to all other postcodes = cost is $5.55

3. Over 500g to all other zones is calculated by adding the Basic Charge and the Per Kg charge for that zone

eg a 2.0 kg parcel to Zone N2 costs = $8.18 + (2.0 x [url removed, login to view] ).

What I need is a user friendly excel work book that has:

1. Packing Staff data entry form and summary printout sheet

2. Admin Only "back end" to change data base as needed ( ie postage rates, postcodes, zones etc)

I have included a basic excel workbook to show how I would do it, but your improvementts are most welcome as I am only a basic excel operator.

Note: Once printed the sheets can be deleted but I would like a CONFIRM DELETE Button

Compétences : Microsoft

Voir plus : excel shipping cost calculator, shipping cost calculator excel, excel shipping calculator, excel postage calculator, postage calculator excel, excel postage cost calculator, shipping charges excel, shipping charges calculator excel, shipping calculator excel, postage rates excel, excel calculator shipping cost, your other warehouse, x rates, what is the data entry operator, what is a data entry operator, warehouse data entry, N2, microsoft australia, i parcel, how to work as a data entry operator, excel data entry form examples, data entry staff needed, data entry rates per australia, data entry operator in australia, australia post data entry

Concernant l'employeur :
( 0 commentaires ) Australia

N° du projet : #1631113

1 freelance a fait une offre moyenne de 35 $ pour ce travail

ethicalboy

Please see what I said.

35 $ USD en 1 jour
(2 Commentaires)
2.1