Banyan

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

Reports › Accounting

Inventory valuation Sample data

What the stock on the shelves is worth at cost and at list price, by department, condition and price band. As it stands today.

Items on hand
72,410
Value at cost
$3,547,682.14
Sample costs
Value at list price
$8,266,629.23
Margin if all sold at list
57.1%

What stands out

  • Industrial holds 92.7% of the stock's list value.
  • Parts priced over $2,000 are 0.6% of the items but 16.9% of the value.
  • Item counts and prices are Banyan's real listings. Cost is sample until real acquisition costs are entered.

By department

Download CSV
DepartmentPartsItemsAt costAt list priceShare of value
Industrial23,51655,394$3,288,812.86$7,665,463.3692.7%
Automotive9,95317,016$258,869.28$601,165.877.3%

By price band

Download CSV
Price of the partPartsItemsAt costAt list priceShare of value
Under $2510,03924,522$178,172.72$412,847.195%
$25 to $10014,30432,216$645,163.47$1,503,359.2318.2%
$100 to $5007,01212,777$1,161,101.91$2,701,018.1732.7%
$500 to $2,0001,7692,490$968,235.45$2,255,249.1427.3%
Over $2,000345405$595,008.59$1,394,155.5016.9%

By condition

Download CSV
ConditionPartsItemsAt costAt list priceShare of value
New – Open box19,48346,896$2,618,109.69$6,089,822.2773.7%
Used2,0513,359$453,591.42$1,073,160.2413%
New6,47813,821$301,677.01$695,698.188.4%
New other (see details)5,0227,799$140,479.37$326,199.063.9%
Remanufactured382446$20,281.16$45,771.730.6%
Seller refurbished3753$12,727.47$33,713.500.4%
For parts or not working813$586.25$1,665.000%
Open box823$229.77$599.250%

Top 25 categories by value

Download CSV
CategoryPartsItemsAt costAt list priceShare of value
Industrial › Mechanical Power Transmission9,54825,587$1,303,058.41$3,025,820.5136.6%
Industrial › Hydraulics, Pneumatics, Pumps & Plumbing4,7369,962$685,660.21$1,617,858.8919.6%
Industrial › Electric Motors1,0651,433$473,729.40$1,098,380.0013.3%
Industrial › CNC, Metalworking & Manufacturing9261,962$111,487.84$264,322.383.2%
Industrial › Other Business & Industrial1,4023,105$111,724.31$262,393.083.2%
Industrial › Rotary & Linear Motion3821,051$106,773.24$250,879.573%
Industrial › Electrical Equipment & Supplies1,3093,086$103,264.71$240,377.632.9%
Industrial › Other Automation Equipment6941,322$88,310.92$207,720.502.5%
Industrial › PLCs & HMIs5301,066$77,166.92$176,687.212.1%
Industrial › Material Handling4551,069$60,015.57$139,932.751.7%
Automotive › Transmission & Drivetrain1,1392,537$49,982.13$116,128.651.4%
Automotive › Engines & Engine Parts1,5893,236$45,641.95$105,373.281.3%
Automotive › Brakes & Brake Parts1,7312,073$39,998.11$93,648.011.1%
Industrial › Sensors252448$32,803.54$73,880.130.9%
Industrial › Fasteners & Hardware1,5283,631$31,059.76$72,139.490.9%
Industrial › Facility Maintenance & Safety156466$29,306.86$67,188.190.8%
Automotive › Steering & Suspension1,0421,440$23,827.99$57,101.370.7%
Industrial › Drives & Starters3751$24,089.25$53,238.500.6%
Industrial › Heavy Equipment, Parts & Attachments165413$18,521.55$41,477.950.5%
Automotive › Air & Fuel Delivery7381,286$17,634.45$40,368.880.5%
Automotive › Engine Cooling Components9841,833$15,361.14$36,068.800.4%
Automotive › Ignition Systems & Components7351,118$14,484.60$33,352.940.4%
Industrial › HVAC & Refrigeration72157$8,785.83$21,201.130.3%
Industrial › Test, Measurement & Inspection67122$9,476.51$20,346.960.2%
Automotive › Interior Parts & Accessories352472$9,073.97$20,298.920.2%