ABC Inventory Classification

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have spreadsheet with YTD sales for approx. 1,000 parts and need to know
which items are the most important. Basically I need an ABC report which
will tell me what parts make up 80%, 15% and 5% of the total Revenue and
assign a letter of A, B, or C respectively. Is this possible in Excel? If
so how would I do it?

Thank you,
 
Highlight all your data go to Data--> PivotTable

Create a pivot table and it will do all the magic you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ABC Report 2
Embeded IF - between ranges 2
Inventory Spreadsheet 3
ABC Report 1
SUMIFs function 2
Excel Excel help plse 1
Need Year-To-Date Sum Function with nested Vlookup and offset 3
Multiple Column Criteria which deletes all but Highest Value 8

Back
Top