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| Department | Parts | Items | At cost | At list price | Share of value |
|---|---|---|---|---|---|
| Industrial | 23,516 | 55,394 | $3,288,812.86 | $7,665,463.36 | 92.7% |
| Automotive | 9,953 | 17,016 | $258,869.28 | $601,165.87 | 7.3% |
By price band
Download CSV| Price of the part | Parts | Items | At cost | At list price | Share of value |
|---|---|---|---|---|---|
| Under $25 | 10,039 | 24,522 | $178,172.72 | $412,847.19 | 5% |
| $25 to $100 | 14,304 | 32,216 | $645,163.47 | $1,503,359.23 | 18.2% |
| $100 to $500 | 7,012 | 12,777 | $1,161,101.91 | $2,701,018.17 | 32.7% |
| $500 to $2,000 | 1,769 | 2,490 | $968,235.45 | $2,255,249.14 | 27.3% |
| Over $2,000 | 345 | 405 | $595,008.59 | $1,394,155.50 | 16.9% |
By condition
Download CSV| Condition | Parts | Items | At cost | At list price | Share of value |
|---|---|---|---|---|---|
| New – Open box | 19,483 | 46,896 | $2,618,109.69 | $6,089,822.27 | 73.7% |
| Used | 2,051 | 3,359 | $453,591.42 | $1,073,160.24 | 13% |
| New | 6,478 | 13,821 | $301,677.01 | $695,698.18 | 8.4% |
| New other (see details) | 5,022 | 7,799 | $140,479.37 | $326,199.06 | 3.9% |
| Remanufactured | 382 | 446 | $20,281.16 | $45,771.73 | 0.6% |
| Seller refurbished | 37 | 53 | $12,727.47 | $33,713.50 | 0.4% |
| For parts or not working | 8 | 13 | $586.25 | $1,665.00 | 0% |
| Open box | 8 | 23 | $229.77 | $599.25 | 0% |
Top 25 categories by value
Download CSV| Category | Parts | Items | At cost | At list price | Share of value |
|---|---|---|---|---|---|
| Industrial › Mechanical Power Transmission | 9,548 | 25,587 | $1,303,058.41 | $3,025,820.51 | 36.6% |
| Industrial › Hydraulics, Pneumatics, Pumps & Plumbing | 4,736 | 9,962 | $685,660.21 | $1,617,858.89 | 19.6% |
| Industrial › Electric Motors | 1,065 | 1,433 | $473,729.40 | $1,098,380.00 | 13.3% |
| Industrial › CNC, Metalworking & Manufacturing | 926 | 1,962 | $111,487.84 | $264,322.38 | 3.2% |
| Industrial › Other Business & Industrial | 1,402 | 3,105 | $111,724.31 | $262,393.08 | 3.2% |
| Industrial › Rotary & Linear Motion | 382 | 1,051 | $106,773.24 | $250,879.57 | 3% |
| Industrial › Electrical Equipment & Supplies | 1,309 | 3,086 | $103,264.71 | $240,377.63 | 2.9% |
| Industrial › Other Automation Equipment | 694 | 1,322 | $88,310.92 | $207,720.50 | 2.5% |
| Industrial › PLCs & HMIs | 530 | 1,066 | $77,166.92 | $176,687.21 | 2.1% |
| Industrial › Material Handling | 455 | 1,069 | $60,015.57 | $139,932.75 | 1.7% |
| Automotive › Transmission & Drivetrain | 1,139 | 2,537 | $49,982.13 | $116,128.65 | 1.4% |
| Automotive › Engines & Engine Parts | 1,589 | 3,236 | $45,641.95 | $105,373.28 | 1.3% |
| Automotive › Brakes & Brake Parts | 1,731 | 2,073 | $39,998.11 | $93,648.01 | 1.1% |
| Industrial › Sensors | 252 | 448 | $32,803.54 | $73,880.13 | 0.9% |
| Industrial › Fasteners & Hardware | 1,528 | 3,631 | $31,059.76 | $72,139.49 | 0.9% |
| Industrial › Facility Maintenance & Safety | 156 | 466 | $29,306.86 | $67,188.19 | 0.8% |
| Automotive › Steering & Suspension | 1,042 | 1,440 | $23,827.99 | $57,101.37 | 0.7% |
| Industrial › Drives & Starters | 37 | 51 | $24,089.25 | $53,238.50 | 0.6% |
| Industrial › Heavy Equipment, Parts & Attachments | 165 | 413 | $18,521.55 | $41,477.95 | 0.5% |
| Automotive › Air & Fuel Delivery | 738 | 1,286 | $17,634.45 | $40,368.88 | 0.5% |
| Automotive › Engine Cooling Components | 984 | 1,833 | $15,361.14 | $36,068.80 | 0.4% |
| Automotive › Ignition Systems & Components | 735 | 1,118 | $14,484.60 | $33,352.94 | 0.4% |
| Industrial › HVAC & Refrigeration | 72 | 157 | $8,785.83 | $21,201.13 | 0.3% |
| Industrial › Test, Measurement & Inspection | 67 | 122 | $9,476.51 | $20,346.96 | 0.2% |
| Automotive › Interior Parts & Accessories | 352 | 472 | $9,073.97 | $20,298.92 | 0.2% |