We are looking for a UK-based Excel guru who can create a calculator which will do the following:
1. Calculate the Ex-works cost of bespoke products which vary in size and shape, and consist of at least 5 different components
2. Determine the correct packaging method (standard cardboard, thick cardboard or wooden crate), packing size and weight of each shipment based on single and multiple items of varying sizes (if packed together)
3. Calculate the total shipping cost using a fixed rate per kilogram and the actual or volumetric weight (whichever is higher). We can provide the formula for calculating the volumetric weight.
4. Attribute a proportion of the shipping cost to each product, depending on the product size and/or value.
5. Provide useful data such as profit, profit margins, shipping costs, etc.
We have tried building this calculator before which may be useful. After signing a NDA, we would be able to send more data and information to the most suitable candidate for the job.
We look forward to receiving your proposal.
21 freelanceria on tarjonnut keskimäärin £151 tähän työhön
I am an Excel, Google Sheet, VBA and Google App Script expert. I have completed a lot of relevant jobs with 5 star feedback. I am interested in your project. I can start it right now so Lets start it. Malik
Hi! I know how to help you with this task. Your process can efectively be optimised through excel and/or VBA. Please contact me to discuss details. Thank you!
Good Day. I have created various excel templates before with calculations. Given the opportunity, I will give my best shot to fit with your expectation.