Revenue vs Cost Analysis Dashboard

Performance Analysis โ€ข May 2024 - May 2025

๐Ÿ“‹ How We Calculated These Numbers

Revenue Split: We take each terminal's monthly revenue and split it equally among whoever worked there that month. So if Terminal 824 made $100K and had 5 people working it, each person gets credit for $20K. This way nobody gets double-counted.

Costs: Each person's actual payroll cost goes to their assigned terminals. If someone works 3 terminals, their cost gets split 3 ways. Terminal costs = total of everyone working there.

The Math: ROI = How much gross margin we made รท How much we spent on payroll. Cost per Load = What we spent รท How many loads we handled. Total revenue verified at $12.57M.

๐Ÿ‘ฅ Who Works Where

Employee Terminals Start Date Notes
Balga, Kyle All (824, 1160, 1425, 1439, 4183, 4202) May 2024 Multi-terminal flexibility since start
Brown, Chandler 1160 only May 2024 $0 payroll cost, 1160 specialist since start
Septak, Kara 824, 1439, 4183, 4202 May 2024 Multi-terminal (excludes 1160, 1425) since start
Caves, Chris 824, 4183 May 2024 Started 824 only, added 4183 Aug 2024
Mansour, Keaton 824, 4183 May 2024 Started 824 (May-Aug), moved to 4183 (Sep+)
McDougal, Timothy 4183 only Aug 2024 4183 specialist since hire
Valdes, Mario 824 only Aug 2024 824 specialist since hire
Perez, Alejandro 1425 only May 2024 1425 specialist since start
Vazquez, Jean 4202 only Oct 2024 4202 specialist since hire
Smith, Jaxon 1439 only Feb 2025 1439 specialist since hire (newest)
$12.57M
Total Revenue
$691K
Total Payroll
18.2x
Revenue Multiple
5,796
Total Loads

๐Ÿ‘ฅ Employee Performance (Click headers to sort)

Employee Revenue Gross Margin Payroll Cost ROI Multiple Revenue per $1 Cost per Load
Balga, Kyle $3.69M $675K $118K 5.73x $31.31 $70.75
Septak, Kara $2.12M $394K $89K 4.44x $23.92 $85.40
Caves, Chris $1.54M $318K $81K 3.91x $18.94 $102.45
Valdes, Mario $986K $198K $59K 3.37x $16.81 $126.53
Perez, Alejandro $109K $11K $4K 2.64x $25.23 $111.03
McDougal, Timothy $555K $120K $49K 2.46x $11.35 $147.91
Mansour, Keaton $1.54M $318K $211K 1.51x $7.31 $265.45
Vazquez, Jean $468K $56K $52K 1.09x $9.04 $261.20
Smith, Jaxon $109K $19K $21K 0.92x $5.22 $469.84
Brown, Chandler $1.46M $270K $0 N/A N/A $0.00

๐Ÿš› Terminal Performance (Click headers to sort)

Terminal Revenue Gross Margin Team Cost ROI Multiple Margin % Total Loads Cost per Load
Terminal 1160 $2.92M $540K $20K 27.53x 18.5% 1,177 $16.68
Terminal 824 $4.93M $989K $247K 4.01x 20.1% 2,318 $106.35
Terminal 4183 $2.77M $601K $237K 2.54x 21.7% 1,653 $143.23
Terminal 4202 $1.40M $168K $93K 1.80x 12.0% 594 $157.38
Terminal 1425 $0.22M $23K $24K 0.95x 10.5% 78 $307.14
Terminal 1439 $328K $58K $63K 0.92x 17.6% 134 $468.28