Overhead Dashboard
Global
Auctions
Dealership
Service
Parts
Rentals
Logistics
Brokerage
Leasing
Capital
RE
Marketing
Overhead
$186K
Payroll MTD
$42K
Commissions MTD
18%
$28K
Facilities MTD
$15K
Depreciation MTD
Payroll by Department
32 employees
Sales Team
8 employees • Base + Commission
$68,400
Service & Parts
12 employees • Hourly + OT
$54,200
Admin & Management
6 employees • Salary
$42,000
Logistics & Yard
6 employees • Hourly
$21,400
Commissions Earned
MTDMJ
Mike Johnson
6 deals closed • $1.2M volume
$14,400
SW
Sarah Williams
4 deals closed • $890K volume
$10,680
RD
Robert Davis
5 deals closed • $720K volume
$8,640
JT
Jennifer Taylor
3 deals closed • $685K volume
$8,220
Depreciation Schedule
Service Trucks (5)
Book Value: $185,000
$3,080/mo
Shop Equipment
Book Value: $125,000
$2,083/mo
Rental Fleet (34 units)
Book Value: $2.4M
$8,500/mo
Office & IT Equipment
Book Value: $45,000
$1,250/mo
Facility & Overhead Costs
Rent & Lease Payments
Nashville + Memphis locations
$12,500/mo
Utilities
Electric, Gas, Water, Internet
$4,800/mo
Insurance
Property, Liability, Workers Comp
$8,200/mo
Software & Subscriptions
ERP, CRM, Marketing Tools
$2,400/mo
Monthly Expense Summary
View Accounting| Category | Jan 2024 | Feb 2024 | Mar 2024 (Proj) | YTD Total | Budget | Variance |
|---|---|---|---|---|---|---|
| Payroll (Base) | $142,000 | $144,000 | $144,000 | $430,000 | $432,000 | -$2,000 |
| Commissions | $38,500 | $42,000 | $45,000 | $125,500 | $120,000 | +$5,500 |
| Facilities | $27,900 | $28,000 | $28,000 | $83,900 | $84,000 | -$100 |
| Depreciation | $14,913 | $14,913 | $14,913 | $44,739 | $45,000 | -$261 |
| Marketing | $8,200 | $8,500 | $9,000 | $25,700 | $27,000 | -$1,300 |
| TOTAL | $231,513 | $237,413 | $240,913 | $709,839 | $708,000 | +$1,839 |