Find Jobs
Hire Freelancers

Shipping Quotation tool in excel

$750-1500 USD

Cancelled
Posted about 10 years ago

$750-1500 USD

Paid on delivery
I need to build a quotation tool. This is for a express air shipping service I currently have destination, shipping rate, discounts, profit margin, competitor rates all on hard copy sheets. What I want to accomplish is to automate and generate a quote while the client is in front of me. The Excel quotation program should be able to allow me to to the following: *Select Origination / Destination (Country) - Zone Package weight / Dimensions + Zone to determine shipping rate My Wholesale Cost Retail shipping rate chart And some way of adding discounts % while keeping a watch on my profit margins. Adding competitors rate and have application show how much of a savings client is getting with the ability to do a weekly, monthly, yearly savings calculations Generate final quote to PDF
Project ID: 5798121

About the project

35 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
35 freelancers are bidding on average $866 USD for this job
User Avatar
Hi, I'll be happy to help you with this project. Have done many quote and invoice generating macro applications in the past few months Also I can give you a discount If everything goes through smoothly Please feel free to message me if you need to discuss any questions you might have prior to award
$750 USD in 3 days
4.9 (251 reviews)
7.6
7.6
User Avatar
Hi, I am an Excel expert and would be happy to take on your project. I propose to provide an Excel automated tool to generate the quotes automatically. Let me know and we can discuss further. Regards, Arul
$1,000 USD in 7 days
5.0 (173 reviews)
7.4
7.4
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$750 USD in 4 days
4.9 (326 reviews)
7.6
7.6
User Avatar
Hi MKT. I have developed a couple of very similar Invoicing applications in Excel and I can design another for you. Besides I would be able to recommend a few new features to you as well which I incorporated in the past projects. Kindly discuss the project with me so I may share a few samples with you. Thank you for reading my bid. Regards. Usman.
$850 USD in 4 days
5.0 (72 reviews)
6.8
6.8
User Avatar
Hi: I have few doubts: 1- Will you be using volumetric weight for calculating shipping cost? 2- Are all zip codes within a city serviceable? I am asking this because sometimes a particular zip code in a city is not serviced by the shipping provider. 3 - Does shipping rate also depend on the type of material (documents or Product/commodities) shipped ? 4- Do you provide insurance for the items that you ship? 5- What is the criteria for providing discount to clients? I have designed a preliminary template that I want to share with you. The sites does not allow me to communicate with you unless you initiate the communication. Please connect with me to discuss more. Please check my projects reviews. My all projects are related to Excel and macros. I have 100% completion rate with 5-star rating on all projects.
$750 USD in 7 days
4.9 (169 reviews)
7.1
7.1
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$757 USD in 10 days
4.9 (162 reviews)
6.4
6.4
User Avatar
Hello, A nice and simple user environment implemented as an Excel sheet can give you all the desired functionality. Using drop-down lists you will be able to select the origination /destination and zone, and enter the package weight and/or dimensions, while the code behind it will do automatically the calculations for the costs, possible discounts, and prices, as well as the comparison to the competitors. A button will allow you to make the final selection, and to preview the quote before saving it as a PDF, which then could be printed as a hard copy or send to the customer as attachment via email. Another button will allow you to make changes to the "database" records, that is, the table(s) of the wholesale costs, rates, destinations, competitors' rates, etc.. A few words about me: I'm developing VBA code for more than 15 years and I'm a trainer for Excel and VBA for 12+ years. As you can guess, I have created a plethora of Excel-VBA programs of any kind and difficulty level, for both training purposes and business. Looking forward to hear from you, Kind regards, chriskerpini
$750 USD in 3 days
4.9 (70 reviews)
6.5
6.5
User Avatar
Excel/VBA developer since 1997. I have also worked in the air express and air cargo fields for 7 years. Can certainly do. Regards, Svet.
$1,666 USD in 15 days
5.0 (57 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$750 USD in 20 days
4.9 (115 reviews)
6.2
6.2
User Avatar
My Bid is 100$ totally for this type of job what ever be the the maximum complexity of the project . I have done Excel to PDF conversion in Macro button . If it is more simple my bid will lower accordingly/ I have excellent experience in Excel/VBA [over ten plus years]. Please check my past reviews and ratings. I assure you 100% accurate & quality job. Please ping back so that we can discuss the complete requirement and i can give you a demo work. If you are 100% happy with my demo work then you can award me this full project . I am sincere,honest and hardworking independent freelancer . I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$750 USD in 3 days
4.9 (147 reviews)
5.9
5.9
User Avatar
Good day, I am Excel developer of spreadshetweb.com. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$888 USD in 7 days
5.0 (69 reviews)
6.0
6.0
User Avatar
Hello, I have done many projects and I think this project can be done with little budget as well! If you like contact me to send a sample, also more about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
$750 USD in 7 days
4.9 (61 reviews)
5.2
5.2
User Avatar
Hello, I'm very keen on your project as it involve Excel and Interface creation, two category where I'm pretty strong at it. Please check my portfolio as I have in the past created very complex dashboard in excel, to generate statistical forecast based on several various entry for large amount of record. I'm sure I can help you on your project and deliver the product you're dreaming of ! Lets speak more about it via private message. Best Regards Vincent - Aerobace
$750 USD in 6 days
4.8 (8 reviews)
5.4
5.4
User Avatar
I have over 8 years of experience in Excel and Access VBA. I have developed several Applications, Automation, Dashboard and Report Analysis using VBA. I have developed a Similar tool for a Courier Company and I will be able to do this project with 100% quality.
$750 USD in 10 days
4.9 (12 reviews)
3.9
3.9
User Avatar
Dear Sir, I've led the data analytics division of Ingram in the EMEA centre and I am a certified Six Sigma Black Belt. I would like to support the project and write the tool for you. I am specialized in Excel analysis, dashboards and charting. If you award the project to me I can start working on it within one day. Kind regards Viktor Mihalkov
$750 USD in 5 days
5.0 (5 reviews)
3.8
3.8
User Avatar
I am proficient in Excel and have done numerous projects. I have understood the requirement and can complete the tool within a day. Will generate a professional template wherein bare minimum user input will be required. The output will be formatted in a professional way and a PDF generated. Message me in case you need any clarification.
$750 USD in 1 day
4.7 (7 reviews)
3.0
3.0
User Avatar
Hello, I have good experience in creating complex Excel models for pricing and various other applications. I can work on this project and deliver a very flexible tool as per your requirement. I can even future proof it to some extent by creating enough flexibility and user interaction
$833 USD in 5 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hello MKTChannelNtwk, I have big experience in building complex Excel projects. I suggest: - destination, shipping rate, discounts, profit margin, competitor rates and other main topics are located in individual sheet so you easy can adjust values. - When making input for a quotation I suggest to create Userforms which gives you a nice user interface. - The data from each individual quotation can easily be stored internally in excel so you can retrieve it later if needed - Creating the the pdf-file should should also contain your company logo etc., and perhaps your TOC. - If you want a statistical module can be created. - To ensure no data are lost I suggest incorporation at backup module. If you think my suggestion is interesting, please let me know.I would happily create a demo for your consideration. Kind regards
$800 USD in 30 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Hi, Greetings. I am willing to do this work for you. I red your requirement and its straightforward and easy to do. Lets discuss about it and continue. I will also provide 6 months technical support for you free of charge. I worked as a developer for 16 years and now working freelance. Thank you. Best regards,
$750 USD in 10 days
5.0 (3 reviews)
2.2
2.2
User Avatar
I'm a head manager of highly experienced company. We have more than 7 years experience in up to 10 different businesses and we have created more than 22 programed excel software with 40 updates. After completing project, we will support you for free 6 months.
$1,250 USD in 20 days
5.0 (1 review)
1.3
1.3

About the client

Flag of UNITED STATES
Bloomington, United States
0.0
0
Member since Apr 13, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.