Excel Help

Discussion in 'Freight Broker Forum' started by SourceDirection, Nov 5, 2021.

  1. SourceDirection

    SourceDirection Bobtail Member

    9
    4
    Sep 8, 2021
    0
    I have been in the freight broker world for 13 years but new in this position of reaching out to trucking companies to get quotes for current lanes we have and new business. We have many dedicated lanes we do weekly and we need to reach out to every carrier we can to see if they could quote the lanes we have to see if we can find a cheaper rate. This is for current business but we also follow this process for quoting new business opportunities.

    My question is, does anyone have an excel worksheet they use to list all the lanes we have out for bidding, what our target carrier rate would be, and a place to enter the rates the carriers give me to run the lanes? Ideally, this spreadsheet would have formulas and functions to consolidate all the lane, target rate and submitted carrier rates in one sheet but will also automatically move all the carrier information to one tab and all the customer information to another tab. I am not sure on the best way to enter all this info, including multiple carrier rates and the calculated profits based on the carrier quote minus the target rate.

    I assume there are folks out there that have done this type of RFP business before that already created an excel template they could share. I would like to consolidate and automate the sheet as much as possible to organize myself and quickly respond to the RFQs I receive.
     
    Last edited by a moderator: Nov 5, 2021
    Reason for edit: Removed contact information
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  3. BennysPennys

    BennysPennys Medium Load Member

    386
    2,769
    Sep 24, 2021
    0
    Do you realize that your asking someone to share several hundred to over a thousand lines of proprietary code with you that probably has 500 plus man hours in it?
     
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  • Draft saved Draft deleted