Excel file- LTL shipping price calculator

Completed Posted 3 months ago Paid on delivery
Completed Paid on delivery

I need your help to design a shipping price calculator in Microsoft Excel. The template and rates are attached. Here’s what I need:

- The calculator is used to determine the price to ship an LTL shipment from pickup to destination. (green cell)

- The user must be able to change the numbers in the grey and blue cells.

- Each shipment travels in two legs...the first leg is the linehaul and the second leg is LTLC.

- The appropriate fuel surcharges must be applied to each leg. Then, the price for both legs are combined to form the total shipping price. (green cell)

- LTLC min = minimum charge. L5C = less than 500lb weight break.

- The LTLC pricing is in price per hundred lb format. For example: 12.78 = $0.1278 per lb.

- The correct minimum LTLC charge must be used for light weight shipments (i.e. the minimum charge should be used for a shipment weighing 80lbs to London ON)

- The correct LTLC weight break must be used when the weight is close to the next break (i.e. 490lb shipment should be priced using 500lbs x the 500lb price/lb). The formula to calculate this break is (price/lb x beginning weight break) / price per lb for previous weight break. For the London ON example: (.1278 X 500) / .1896 = 337. Use L5C price/lb for >337, use 500 x .1278 for 337-500lbs.

- I'd like the formulas built into the tool so I can copy and paste different pricing into the LTLC tab and use the tool for different customers.

Excel Logistics

Project ID: #37485105

About the project

28 proposals Remote project Active 3 mos ago

Awarded to:

IMBASANTAKUMAR

Hello there! My name is Basanta and I'm a native of Odisha, India. I have over 12+ years of experience in different domains, including MNCs such as IBM, Accenture, Amazon and Google. I understand you need help creatin More

$40 CAD in 1 day
(0 Reviews)
0.0

28 freelancers are bidding on average $116 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$180 CAD in 3 days
(518 Reviews)
8.4
AccountantArman

"Sir, Excel is my Speciality. I am master of excel. I can help you 100% in this project as per your requirements. send me a message so that we can discuss. I am Excel Advanced Level Expert. This is basic work for me. I More

$120 CAD in 1 day
(263 Reviews)
7.3
nagyzoltan68

Hello, I would like to work on your project to create an MS Excel file- LTL shipping price calculator. I have extensive experience using Excel macros / VBA, formulas, and charts. Please initiate a chat, share your fi More

$100 CAD in 2 days
(188 Reviews)
7.0
Giovanni704

Hi there! As I have read, I see you need help to design an Excel pricing calculator I could help you develop this project and get what you need for this job. I'm a professional Database Administrator and Analytics En More

$30 CAD in 1 day
(56 Reviews)
6.9
mananraja

hi I have expertise in Excel Macro Programming, and can develop you Excel sheet to perform all the calculations you mentioned using formulas. I'm available to discuss more details in chat, and can start right away. A More

$100 CAD in 1 day
(136 Reviews)
6.7
usmanbashir12100

Hi, If you are having issues with Organizing data lists, Records, Survey analysis & any thing related Microsoft Excel or Spreadsheet. Look no more, Im offering professional Excel services and solutions to all your bu More

$220 CAD in 7 days
(17 Reviews)
5.7
WelcomeClient

Hi There, Ready right now I'm ready to design a shipping price calculator in Microsoft Excel. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share More

$80 CAD in 1 day
(126 Reviews)
6.0
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc More

$100 CAD in 1 day
(37 Reviews)
5.5
OmarFarukBD

I am going to start your project right now. I understand that you need help designing a shipping price calculator in Microsoft Excel. The template and rates are attached so you can see exactly what I'm talking about. A More

$180 CAD in 4 days
(13 Reviews)
4.9
monicawriter99

Hithere, I will help with the project on Excel file- LTL shipping price calculator. I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments in More

$108 CAD in 3 days
(17 Reviews)
4.6
zafarfarooq612

Hello, I understand your requirement to design a shipping price calculator in Microsoft Excel, incorporating specific calculations for the linehaul and LTLC legs, fuel surcharges, and weight breaks. I will create a us More

$140 CAD in 7 days
(34 Reviews)
4.3
d4971638

Hi I understand you need help designing a shipping price calculator in Microsoft Excel. With my expertise in Excel and web development, I am confident that I can provide the necessary tools to create a powerful tool th More

$45 CAD in 3 days
(9 Reviews)
2.8
abnerlacida37

Good Day I am writing this letter for express my interest as I am looking for a Data Entry that suits in my experience so I have enclosed my Curriculum Vitae / Resume herein for your better perusal. An experience OFW More

$50 CAD in 7 days
(0 Reviews)
0.0
fatinatikahhhh

I understand that you are looking for help to create a shipping price calculator in Microsoft Excel. You need the calculator to determine the price to ship an LTL shipment from pickup to destination. The user must be a More

$30 CAD in 5 days
(0 Reviews)
0.0
aklimawork

I am very good at excel formula and manipulation. I will make this price calculator automated as much as possible

$150 CAD in 7 days
(0 Reviews)
0.0
dariasputriperda

I have knowledge about export import or logistic, I know and I have all qualification for this job requirements such as about logistic report in excel

$140 CAD in 7 days
(0 Reviews)
0.0
lysanderramos

Excel Shipping Price Calculator Proposal Offered by: Lysander Objective: To develop an Excel-based shipping price calculator for LTL shipments, ensuring accuracy in calculating shipping costs with user interactivity More

$100 CAD in 7 days
(0 Reviews)
0.0
Asadjutt111

Hello there! My name is Asad, and I am a dedicated data maestro. With a decade of freelancing experience under my belt, I have the skills necessary to help you design a shipping price calculator in Microsoft Excel. I More

$140 CAD in 1 day
(0 Reviews)
0.0