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. Last 30 days.

Product revenue
$21,911.16
Cost of the parts sold
$9,514.00
Gross profit
$12,397.16
Gross margin
56.6%

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
SMC20$2,153.00$954.86$1,198.1455.6%
Syntron1$2,000.00$1,080.00$920.0046%
SKF20$1,735.50$753.47$982.0356.6%
Parker9$1,323.45$684.32$639.1348.3%
FAG6$986.50$427.18$559.3256.7%
INA7$973.50$382.22$591.2860.7%
Valve1$887.50$319.50$568.0064%
Ferraz Shawmut1$845.00$295.75$549.2565%
Promess1$815.00$366.75$448.2555%
Micro Motion1$800.00$408.00$392.0049%
Baldor1$785.00$306.15$478.8561%
Euchner1$750.00$300.00$450.0060%
Marcie Electric Inc1$750.00$352.50$397.5053%
RHP4$739.25$241.46$497.7967.3%
Fafnir8$671.50$256.01$415.4961.9%
WVE14$637.97$273.52$364.4557.1%
Roller2$637.50$268.13$369.3757.9%
Martin11$611.49$265.70$345.7956.5%
Festo3$590.00$274.30$315.7053.5%
Brother1$567.50$209.98$357.5263%
Motorcraft2$554.00$158.62$395.3871.4%
Unbranded15$552.50$244.23$308.2755.8%
Oriental Motor3$525.00$291.75$233.2544.4%
SCA Schucker2$520.00$249.60$270.4052%
Boston Gear1$500.00$150.00$350.0070%

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%