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.
23 freelancers are bidding on average $30 for this job
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.
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.