Create a shipping calculator in excel
- or -
Post a project like this3120
$$
- Posted:
- Proposals: 11
- Remote
- #910770
- Completed
17871637341953973244733514704102165818629634519896861024343
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: We sell gifts and home accesories
Industry: Art and Design
Description of excel work: We are a design company with over 80 SKU'S (individual products).
Each product comes packed in cartons in differing quantities, we also pack some smaller items into larger outer cartons. For larger orders it is possible we will ship a combination of inners and outer
I have attached our master product specification spreadsheet with all of the products information
This spreadsheet is updated whenever there is a change in supplier or the packaging is modified so this needs to be factored in.
The new Shipping Calculator needs to pull relevant data from the Product Specification sheet to supply us with:
-Total weight
-CBM
-Total Carton Quantity
-Height of the order if it were to be stacked on a UK pallet (1.2 x 1m - including the height of the pallet).
The customer is only allowed to order in pack sizes (not split them) so this needs to be built into the sheet and provide us with a visual cue when multiples that are not pack sizes are ordered.
The spreadsheet needs to be as easy as possible to use by our employees and locked so the only fields tha can be edited are the input quantities.
Extra notes:
Industry: Art and Design
Description of excel work: We are a design company with over 80 SKU'S (individual products).
Each product comes packed in cartons in differing quantities, we also pack some smaller items into larger outer cartons. For larger orders it is possible we will ship a combination of inners and outer
I have attached our master product specification spreadsheet with all of the products information
This spreadsheet is updated whenever there is a change in supplier or the packaging is modified so this needs to be factored in.
The new Shipping Calculator needs to pull relevant data from the Product Specification sheet to supply us with:
-Total weight
-CBM
-Total Carton Quantity
-Height of the order if it were to be stacked on a UK pallet (1.2 x 1m - including the height of the pallet).
The customer is only allowed to order in pack sizes (not split them) so this needs to be built into the sheet and provide us with a visual cue when multiples that are not pack sizes are ordered.
The spreadsheet needs to be as easy as possible to use by our employees and locked so the only fields tha can be edited are the input quantities.
Extra notes:
James W.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
13 Jan 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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