Excell Calculation Tab for Freight and Transportation Costs

Cerrado Publicado hace 2 años Pagado a la entrega
Cerrado Pagado a la entrega

I´m looking for someone who can create for me an interactive excell-sheet which can calculate for me a price for products which we are importing from foreign country´s.

Actually we are struggeling with calcualting the real price per item after the product arrived the destination. So Freight Costs, Shipments from A to B, Road Transportation and other fee´s need to be calcualted in details and than be spreaded on each product but under consideration of the fact, that some products are bigger (higher load volume) than others. Also there must be the consideration, that the prices for Air Freight are charged by weight and volume but the seafreight is only by volume.

Additionally we need the sheet to be spreadable. Here some examples.

Example 1: We place a big order but we will ship it in 4 different parts since we need some goods earlyer and some can be later since we order in advance. Since its splitted in 4 delivery´s. 1 will and 2 will be by Airfreight. The 3rd one will be done by Rail and the last one by Ship (Small Amount). I need now a calculation, how much costs each product caused by each transportation.

Example 2: We have a big pre order from china by container. The order will be send all at once, the weight doesnt bother anyone anymore since the container will be fully charterd. So we a 20 foot or 40 foot container, has always the same amount of volume (length x depth x hight) Our products also have volume, every single resell set has volume. I need to calculate in detail, how much of the costs for the container has been caused by each single product which is inside the container to define a covering price in order to the ROI.

Please dont contact me if you didnt read the description, i have no time to explain this 30 times to every single one. Lets be productive.

Excel Visual Basic Procesamiento de datos Entrada de datos Microsoft Office

Nº del proyecto: #30714837

Sobre el proyecto

31 propuestas Proyecto remoto Activo hace 2 años

31 freelancers están ofertando un promedio de €144 por este trabajo

daniyal3214

I cna perfectly assist you with your Excel calculations for Freight and Transporation Cost. I am a professional Financial Analyst and Excel expert holding years fo experience. I will be happy to discuss in detail.

€50 EUR en 1 día
(130 comentarios)
6.8
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Más

€200 EUR en 7 días
(76 comentarios)
6.1
cheapestandbest

Hey, Checked the attached file and understood your requirement. To fulfill your request we will use VBscript into your excel sheet. Connect with us if you want to know more. Thanks

€145 EUR en 5 días
(18 comentarios)
5.8
sevillajk01

Hello, I hope you are fine! I can certainly help you with your excel price calculator project. I have completed 60+ excel project in this platform with 99% completion rate. I am an Excel specialist with 10 years of ex Más

€150 EUR en 3 días
(65 comentarios)
5.5
raghibmth

Sir, For your work solution I will create best excel sheet template....from this your calculation work will be very easy .. Expert in excel sheet template design... I have clearly read and understood the description o Más

€56 EUR en 1 día
(46 comentarios)
4.5
nadjasalewski

Hi there, This sounds like an interesting project and I would like to set up the price calculations for you. I've read and understood your description and with over 10 years of experience in working with Excel (with a Más

€225 EUR en 7 días
(8 comentarios)
4.4
osamawebjuggler

Hi I am exert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

€140 EUR en 1 día
(11 comentarios)
3.9
VbaStudio

Hi. I'm a specialist in Excel and VBA. I can take charge of the entire work. If interested send message.

€50 EUR en 7 días
(15 comentarios)
3.9
WPCSSHTML

I will be able to calculate the logistics costs for different types of transportation. I had experience (over 10 years) in international transportation of goods from Italy, China and Russia to Ukraine. The project will Más

€200 EUR en 7 días
(2 comentarios)
3.9
arunkumar9896

Hi, hope you are doing good. I read and understood the details of the project. I can perfectly help you with that once I get this valuable opportunity. I am a professional Data Analyst and Excel expert holding 7 years Más

€30 EUR en 7 días
(11 comentarios)
3.5
bmoatar1

Hi, I have full experience with Data entry, VBA, Web scraping. ========================================================== I can carry out your project on time with high quality guarantee. I hope to discuss more in deta Más

€115 EUR en 3 días
(1 comentario)
0.4
albiajeerah

Hi everyone. I'm Albi Ajeerah. I am from a freelancer in Malaysia and looking for a part-time job. I have four years experience in Microsoft Office. I am a hardworking and punctual person. My tools: - Words - Excel - P Más

€140 EUR en 7 días
(0 comentarios)
0.0
denisewilliams84

It will be an honor to work for you. I have impeccable ability in building relationship with colleagues, supervisors, and managers. I am adept in working with any complex figures and formulas. I have mastered the use o Más

€140 EUR en 7 días
(1 comentario)
0.0
palashmaheshwari

I very well understand these costing concepts and also have expertise in excel. My excel sheet will be comprehensive and easy to use.

€140 EUR en 7 días
(0 comentarios)
0.0
anthonymsalem

So the main part of this task will need financial modeling with a bit of strategy and financial forecast, and I have direct experience in both. The project is easy and should not take a lot of time or have serious obst Más

€250 EUR en 8 días
(0 comentarios)
0.0
geralynsirad1990

I believe I am the best candidate for this position because I have direct experience in many areas mentioned in the job description, including customer service and project leadership.

€140 EUR en 7 días
(0 comentarios)
0.0
bikramsinhadnr

I bid as i believe that I can help you with this project as i have the experience with Word, Editing, Data Entry, PDF and Copy Typing.

€140 EUR en 3 días
(0 comentarios)
0.0
nguyendinhtuong

Hi, I have read your description and I think that I could help you solve your problems. I have been working in banking sector and working with excel/vba for over 5 years, thus I am capable of solving those complex prob Más

€30 EUR en 7 días
(0 comentarios)
0.0
kingbaolin

Hi there, I am an individual freelancer, as well as the owner of a small sourcing agent. I help my clients around the world tackle their global sourcing and supply chain challenges. I am a native Chinese based in Chin Más

€140 EUR en 7 días
(0 comentarios)
1.6
HomeworkerDE

Hallo Auftraggeber, ich arbeite als Datenanalyst täglich mit Excel und entwicklele unteranderem auch Formulare für komplexe Berechnungen. Nach Durchsicht der Aufgabenstelung und der Beispieldatei hört es sich nach ein Más

€60 EUR en 2 días
(0 comentarios)
0.0