Banyan

Concept. Real parts; orders, customers and money are sample data. Nothing live is changed.

Reports › Accounting

Margins Sample data

Profit on what sold, by brand, and the parts in stock priced closest to (or below) what was paid for them. All time.

Product revenue
$58,113.07
Cost of the parts sold
$25,111.06
Gross profit
$33,002.01
Gross margin
56.8%

What stands out

  • Rexroth has the best margin among brands that sold more than once: 63.5%.
  • The thinnest margin in stock is 42%, on Sheet Metal FTA88048-100 Screw #8 x 1-1/2" Phillips Flat Head (Pack of 100) Z/P.
  • Margins rest on sample costs. They become real as acquisition costs are entered on products and items.

By brand, on what sold

Download CSV
BrandUnitsRevenueCostProfitMargin
SMC49$7,470.00$3,357.65$4,112.3555.1%
SKF62$6,152.48$2,438.58$3,713.9060.4%
Baldor5$3,522.50$1,512.90$2,009.6057.1%
Martin30$3,414.78$1,709.64$1,705.1449.9%
Parker23$3,358.45$1,533.28$1,825.1754.3%
Dodge16$3,344.00$1,336.48$2,007.5260%
MRC20$2,988.33$1,309.54$1,678.7956.2%
FAG24$2,693.50$1,160.26$1,533.2456.9%
Norgren7$2,223.42$1,012.13$1,211.2954.5%
INA21$2,040.00$814.48$1,225.5260.1%
Syntron1$2,000.00$1,080.00$920.0046%
Rexroth10$1,866.00$681.81$1,184.1963.5%
Roller7$1,850.00$803.88$1,046.1256.5%
RHP9$1,727.25$684.32$1,042.9360.4%
WVE32$1,684.41$729.20$955.2156.7%
Festo10$1,519.00$716.86$802.1452.8%
Motorcraft11$1,312.95$491.49$821.4662.6%
Fafnir16$1,250.25$479.42$770.8361.7%
Miller3$1,200.00$570.00$630.0052.5%
SEW EuroDrive2$1,155.00$445.51$709.4961.4%
NSK15$1,106.00$496.46$609.5455.1%
Winsmith2$1,095.00$437.88$657.1260%
Unbranded32$1,053.50$457.85$595.6556.5%
Centric20$1,048.25$450.67$597.5857%
NTN13$1,038.00$400.77$637.2361.4%

Thinnest margins in stock

Download CSV
PartOn handCostPriceMargin
Sheet Metal FTA88048-100 Screw #8 x 1-1/2" Phillips Flat Head (Pack of 100) Z/P3$5.95$10.2542%
DNJ LIF101 Lifter (Ref #'s JB-6000 VL141 ALAMI4H 85004400 056-5136)10$6.53$11.2542%
Fel-Pro MS 96089 Exhaust Manifold Gasket Set 2$6.82$11.7542%
Victor Reinz 67755 Gasket Seal1$6.82$11.7542%
Osborn OG-80 Lockout Safety Hasp Scissor Type Lock (Pack Of 2)2$7.69$13.2542%
Mahle F7467 Exhaust Pipe Flange Gasket 60776 (Pack of 2) 8$7.69$13.2542%
Pipe Nipple 1/4" x 3" Long Black Malleable Steel Male Pipe Fitting (Pack Of 3)3$8.27$14.2542%
Pipe Nipple 1 x 2-1/2 npt Black Steel Malleable Iron Pipe Fitting (Pack Of 3)1$8.27$14.2542%
SMH SY6329G1 Power Connector Red 1/0 Gauge 6A0732$8.27$14.2542%
SOG VA-075 Seal V-ring 67.00mm ID X 79.00mm OD X 11.00mm Wide VA0752$8.56$14.7542%
Fel-Pro MS 93313 Engine Intake Manifold Gasket Set 017-7199-8 1$8.56$14.7542%
Ward 1 1/4" 90 Degree Street Elbow Black Malleable Pipe Fitting1$8.85$15.2542%
UHMW 79434506 Guide Belt Finger Inner 1003468 1" Bore 1 1/2" Tall 2 5/16" OD10$7.08$12.2042%
National 710109 Oil Seal 1.339" ID X 2.48" OD X .354" W (Pack of 2)1$9.14$15.7542%
National 710497 Multipurpose Oil Seal 41mm ID 16mm W 61.1mm OD (Pack of 2)2$9.14$15.7542%
Fel-Pro MS95819 Exhaust Manifold Gasket Set 017-3673-2 MS 958193$9.14$15.7542%
Parker 149F-8-6 Brass Male 90 Degree Elbow 3/4-16 Flare x 3/8 Pipe (Pack Of 2)2$9.43$16.2542%
Fel-Pro MS 95702 Exhaust Manifold Gasket Set 017-3618-6 (Pack of 2)1$9.43$16.2542%
Fel-Pro TCS 46009 Crankshaft Seal Set TCS46009 017-5646-610$5.89$10.1542%
Mahle F32801 Exhaust Pipe Flange Gasket 61289 2$7.95$13.7042%
New Departure 5206 Angular Contact Ball Bearing Double Row 30 X 62 X 0.9370 W10$10.30$17.7542%
NTN 698ZZ Ball Bearing Deep Groove 8mm ID X 19mm OD X 6mm Width Double Shielded1$10.30$17.7542%
Pipe Nipple 3/4 MPT x 4-1/2" Long Black Steel Nipple (Pack Of 2)2$8.24$14.2042%
Roadmax 8K981AP V-Ribbed Belt 8PK2491 1-3/32" x 98-5/8" 28mm x 2505mm K0809811$10.30$17.7542%
Precision Twist 26110 Tapered Shank High Speed Drill Bit 11mm 1MT Series 5ATS1$10.59$18.2542%
Phoenix Contact Type HC-B-6 Hood Side Entry Connector 1/2" Npt 100120NP10$8.53$14.7042%
SMC 9210-09 Pressure Gauge 0-160 PSI 1/4" Connection 9210091$10.88$18.7542%
Victor Reinz 15-10421-01 Engine Valve Cover Gasket Set VS50807R VS35444VR1$10.88$18.7542%
Cutler Hammer H1108 Heater Coil (Pack Of 2)2$11.17$19.2542%
Wagner BC113212 Parking Brake Cable Intermediate F113212 C934581$11.46$19.7542%