Thomas Kuriakose
Active Member
Dear All,
I read the ABC analysis in chandoo.org and tried to apply the template for an ABC analysis on total usage and unit value, but due to zero usage values the formulas and not giving the figures.
Column D = is the unit price of the item
Column E = is the total consumption in 2 years
Column F = is the total consummation value or usage value.
We need the summary as in summary sheet to be populated based on the ABC analysis.
The number of items should be the count of items in A Class, B Class and C Class respectively.
The Items with no usage/consumption should be another class.
Please find attached the file for you reference.
Kindly help in using this template to get the summary values.
thanks,
with regards,
thomas
I read the ABC analysis in chandoo.org and tried to apply the template for an ABC analysis on total usage and unit value, but due to zero usage values the formulas and not giving the figures.
Column D = is the unit price of the item
Column E = is the total consumption in 2 years
Column F = is the total consummation value or usage value.
We need the summary as in summary sheet to be populated based on the ABC analysis.
The number of items should be the count of items in A Class, B Class and C Class respectively.
The Items with no usage/consumption should be another class.
Please find attached the file for you reference.
Kindly help in using this template to get the summary values.
thanks,
with regards,
thomas