[BR] Best/WorstLanes Report

Goal

• The goal here is to give managers the ability to view which lanes are most profitable and least profitable.

Design

1. Filters

   1. Start and end date

   2. Select Interval: The selection you see will be the same as the other report pages

   3. These filters will dictate what data is displaying below

2. Filter button

   1. This button will export this page

3. Biggest Winners

   1. This group will display the top 5 lanes that are profitable by customers.

   2. This will list the highest “Total Profit” on the top and down

4. Lanes

   1. This is the lane that we covered for a particular customer

5. Customer

   1. Customer who are dedicated to this lane

6. Total Revenue

   1. The total revenue that we received for this lane for a particular customer (#5) in the given interval.

7. Lane Volume

   1. How many loads we covered for this lane for a particular customer in the given interval.

8. Average Profit

   1. The average profit we made for this lane for a particular customer in the given interval

9. Total Profit

   1. Average Profit (#8) x Lane Volume (#7)

10. Average Rate

    1. The average rate we quoted to a particular customer for this lane in the given interval

11. Projected Revenue (Yearly)

    1. Total Revenue (#6) x 12

12. Projected Volume (Yearly)

    1. Lane Volume (#7) x 12

13. Projected Profit (Yearly)

    1. Average Profit (#8) x Projected Volume yearly (#12)

14. Export Winner Lanes

    1. Ability to export the winner lanes only

15. Pagination

    1. Ability to view more lanes that are profitability in the given interval

    2. It won’t display lanes that are loss

16. Average Loss

    1. The average loss we did for this lane for a particular customer in the given interval

17. Total Loss

    1. Average Loss (#16) x Lane Volume

18. Projected Revenue (Yearly)

    1. Total Loss (#17) x 12

19. Projected Volume (Yearly)

    1. Same as #12

20. Projected Loss (Yearly)

    1. Average Loss (#16) x Projected volume Yearly (#19)