Find sorted annual revenue, % of annual revenue, cumulative % annual revenue ,Rank ( ABC class) based on revenue?

PRODUCT # Sorted Annual Rev % of Ann Rev Cumulative % Annual Rev Rank (ABC class) based on Revenue Ann Rev SR101 SR103 SR105 SR201 SR203 SR205 SR301 SR303 SR305 ANNUAL UNITS SOLD 15,000 750 1,600 45 10 9,250 700 550 3,000 100 SALE PRICE PER UNIT $250 $1,500 $600 $2,250 $3,500 $500 $650 $700 $920 $1,100 SR500 Mark 2 2 2 Question Assignment 1 Build an ABC Analysis based on Annual Revenue 2 Does this analysis follow the Pareto Principle (Yes / Somewhat / No)? Explain. 3 On Sheet "Volume", build an ABC Analysis based on Annual Volume (Units Sold) 4 Does this analysis follow the Pareto Principle (Yes / Somewhat / No)? Explain. 5 Do the two Analyses result in the same ABC groupings? Explain. 2 2 10