Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainInventory & Stock ManagementABC Inventory Analysis

SpreadsheetInventory & Stock ManagementFree

ABC Inventory Analysis

Rank every item by annual usage value and class it A, B or C so you know where control matters most.

Shown with sample data

Colour

ABC Inventory Analysis

Rank every item by annual usage value and class it A, B or C so you know where control matters most.

Items
10
Annual usage value
$102,618
A items
3
Carry about 80% of value
C items
4
Count these least often
Annual value by category
  • Electrical$80,100
  • Fasteners$9,346
  • Packaging$8,180
  • Consumables$4,992
Share of annual value by category
  • Electrical$80,10078%
  • Fasteners$9,3469%
  • Packaging$8,1808%
  • Consumables$4,9925%

How to use it

  1. 1List each item with its annual usage and unit cost.
  2. 2Read the class: A items are few but carry most of the value.
  3. 3Count and review A items most often, C items least.
  4. 4Re-run the analysis every quarter as demand shifts.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

A small share of items usually accounts for most of the money tied up in stock. Enter annual usage and unit cost for each item and the sheet works out annual value, each item’s share and rank, and classes it A (top 80% of value), B (next 15%) or C, so counting, safety stock and supplier attention go where they pay off.

Who it’s for

  • Deciding what to count weekly, monthly or yearly
  • Setting service levels by item class
  • Cutting cash tied up in slow stock

What’s included

  • ABC analysis sheet: One row per stocked item.
  • Summary by Category sheet: Annual value and the number of entries for each category, calculated from the ABC analysis sheet.

How to use it

  1. 1List each item with its annual usage and unit cost.
  2. 2Read the class: A items are few but carry most of the value.
  3. 3Count and review A items most often, C items least.
  4. 4Re-run the analysis every quarter as demand shifts.

Tips

  • An item with low value but long lead time can still deserve A-level attention.
Related searchesabc analysisinventory classificationpareto inventorystock controlannual usage value

Details

Format
Spreadsheet
Category
Inventory & Stock Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInventory & Stock ManagementFree

ABC Inventory Analysis

Rank every item by annual usage value and class it A, B or C so you know where control matters most.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Inventory & Stock Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More inventory & stock management templates

View all
Inventory Tracker with Reorder Alerts4 sheets

Stock value

$894

Items to reorder

4

Out of stock

1

ABCD
1ItemCategorySupplierUnit cost
2Espresso beans 1kgBeveragesRoast Co.$18.50
3Oat milk 1LBeveragesDairyFree Ltd$2.10
4Loose leaf tea 500gBeveragesLeaf & Co$11.80
5Croissants, frozen (case of 50)FoodBake Supply$32.00
Items
SpreadsheetInventory & Stock Management

Inventory Tracker with Reorder Alerts

Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.

10 min setupPreview
Stock Movement Ledger2 sheets

Stock value

$8,664

Items to reorder

1

ABCD
1DateTypeQty inQty out
2Nov 2Receipt2,0000
3Nov 3Issue0350
4Nov 3Issue024
5Nov 4Receipt600
Movements
SpreadsheetInventory & Stock Management

Stock Movement Ledger

Log every receipt, issue and adjustment and see the running quantity on hand for each item.

10 min setupPreview
Inventory Valuation & Turnover Report2 sheets

Stock value

$27,060

Overall turnover

4.7

Slow or dead value

$14,060

Stock value by category
$17k
$5,790
$2,800
$1,430
Finished goodsComponentsPackagingSpares
SpreadsheetInventory & Stock Management

Inventory Valuation & Turnover Report

Value stock by category and see turnover and days on hand so slow movers stand out.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ