I need a more user friendly excel tool to allow me to develop my landed cost for importing containers of wood components. Process is simple, but has some variables that I would like it to consider as i enter items in.
Process is as follows:
1. Agent sends me an excel with costings delivered to port. His sheet breaks down the LxWxH of each piece, skid/unit, and then total skids in unit. Costed out to a per piece.
2. My sheet needs to be able to take that data (or i manually enter) and give me a landed cost into US. I will need my sheet to have the ability to enter in freight rates, duties, tariffs, and customs clearance fees. Even though I have a per piece cost in the sheet he provides, I want my sheet to be able to calculate that same number
3. Once the sheet calculates my landed cost, i would like it to give me a delivered m/3
4. Sheet also needs to allow me to change number of units of a certain size of product, but be able to keep from going overweight
Possibly this could be even a form that allows me to enter in what the sourcing agent provides Would like to see if this could be developed into a power app or something as well.
Hello, I can use VBA to achieve your requirements.
I have made VBA toos, you can have a look:
[login to view URL]
I can make a button in your excel. When you click the button, then the Excel automatically loads the excel from agent, and calculates cost and others for you.
I didn't understand "to give me a delivered m/3", but it doesn't matter, you can explain it to me.
$25 USD w 1 dzień
0,0 (1 opinia)
0,0
0,0
21 freelancers are bidding on average $30 USD for this job
Hello client
I read your project specs and I got a rough idea about the scope of work. A detailed discussion with you will help further in deep understanding. I will build the calculator in excel. Regarding my experience in excel, I have done many projects in the past. I would request you to go through my profile page before you contact me.
With many thanks, I request you to contact me so that we start the discussion.
Roy
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months.
Willing to take up your project. Thank you, Regards.
Hi, I can do the calculator in Excel that you need.
I am available, I can start immediately. Do not hesitate to contact me.
• Clarification: The indicated delivery time is indicative. For a correct projection, it is necessary to know more in detail the project and your needs.
My name is Esteban,
I'm Industrial Engineer and Excel / VBA Expert.
I'm new freelance, You can see some of my experiences in my profile.
I can solve this problem as well as help you in economic analysis and evaluations, based on regression studies and statistical estimates.
I would love to help you in your project and that you can help me earn more points !!
I have all the essential skills of formulating the spreadsheet for costing for Importing or Exporting cargoes provided the details of inputs to be given. In addition to general data entry jobs, I have a specialized skill in the documentation of exporting & importing deals. Not only about documentation alone, but I also have a holistic idea about the export & import business. Therefore, preparing or overseeing of costing part will not be a big deal.
I am an Engineer by profession with rich experience 28+ years in Technical & Commercial functions in a process Industry. I also possess expertise & hands on experience of working in ERP / SAP & fluent in usage of MS Office software like MS Word, MS Excel, MS Powerpoint etc.
With above credentials, I feel that I am the suitable candidate for this assignment.
This sheet can be also created on Google Sheets (it's a google version of excel). I did a lot of work using formulas to accomplish complicated processes on Excel and Google sheets.