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. This month.

Product revenue
$13,268.74
Cost of the parts sold
$5,471.14
Gross profit
$7,797.60
Gross margin
58.8%

What stands out

  • Motorcraft has the best margin among brands that sold more than once: 71.4%.
  • 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
SMC11$1,223.50$528.08$695.4256.8%
SKF14$1,015.50$425.20$590.3058.1%
Valve1$887.50$319.50$568.0064%
Promess1$815.00$366.75$448.2555%
Roller2$637.50$268.13$369.3757.9%
Motorcraft2$554.00$158.62$395.3871.4%
SCA Schucker2$520.00$249.60$270.4052%
Shimpo1$500.00$190.00$310.0062%
Boston Gear1$500.00$150.00$350.0070%
Moog2$465.00$210.55$254.4554.7%
FAG3$455.50$215.33$240.1752.7%
Martin6$454.99$203.81$251.1855.2%
RHP3$454.25$161.66$292.5964.4%
Siemens1$450.00$144.00$306.0068%
Nidec1$447.50$187.95$259.5558%
Festo2$440.00$206.80$233.2053%
Cat1$425.00$165.75$259.2561%
INA2$417.50$165.10$252.4060.5%
Varvel1$398.50$111.58$286.9272%
Bower BCA2$390.00$191.10$198.9051%
Cleveland Mixer1$375.00$180.00$195.0052%
NSK4$372.50$177.83$194.6752.3%
Rexroth3$370.00$147.30$222.7060.2%
Cover1$350.00$175.00$175.0050%
Powertran1$350.00$171.50$178.5051%

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%