abc analysis

Toen 000) Avg Ret Und Poo 38.00 09 14 *12 2 4 3 3 4 7 0 5 30.00 S880 $0.00 91.14 $2.40 241 30.00 32.18 $10 $1.49 $0.00 9594 $1.35 $80 6 4 0 9 SKU LISTING BY ANNUAL SALES. FOR GROUP ASSIGNMENT JUNE 15TH REGION 1 REGION 2 wa SKUS LISTING DESCRIPTIONS FORMAT Bak Dolar Tonn (.000 Unik Price Seks Doors IBM BOXED EVERYDAY SEASONAL $ 94.001.00 271 $8.50 $ 1,306,300.00 ITEM 2 BOXED EVERYDAY SEASONAL $ 8,609,70.00 194 $4.97 $ 219.416.00 ITEMS PIECES SEASONAL $ 368.050.00 30 $249 $ MOM 4 BOXED SEASONAL $ 14414.845.00 14 $8.97 $ 61107.00 MEMG DOED EVERYDAY SEASONAL $ 35.600.00 20 $10.70 $ TOMO DOXED EVERYDAY SEASONAL $ 364,301.00 12 $0.4 $ 112,270.00 ? PECES SEASONAL $ 362.754.00 33 $3.50 $ ITEMO BOXED EVERYDAY SEASONAL $ 361,916,00 7 $10.20 $ 123,175.00 ITEMS PIECES SEASONAL $ 30,313.00 12 $2.91 $ 100236.00 ITBM 10 PIECES SEASONAL $ 357.241.00 33 $2.46 $ ITEM 11 PIECES SEASONAL $ 330,440.00 36 $3.57 $ ITEM 12 BOXED EVERYDAY SEASONAL $ 330,187.00 13 31.07 3 ITEM 13 BOXED EVERYDAY SEASONAL 2.012,07300 164 $1.05 $ ITEM 14 BOXED EVERYDAY SEASONAL $ 32,81300 31 $1.12 $ 140.00 ITEM 15 PIECES SEASONAL 34217800 40 $705 IBM 16 BARS EVERYDAY SEASONAL 30,493.00 21 $ 131061.00 ITEM 17 SINGLES SEASONAL 310,190,00 16 $1.20 $ 26.693.00 ITEM 10 BOXED EVERYDAY SEASONAL 3292400 13 $769 $ 89,08700 ITEM 19 BOXED EVERYDAY SEASONAL 338.213.00 8 $1173 $ 291,577.00 ITEM 20 PIECES SEASONAL 332,507.00 33 3176 $ ITEM 21 PIECES SEASONAL 127,174.00 19 $ 1100 ITEM 22 BOXED EVERYDAY SEASONAL 225,00/400 29 9103 $ ITEM 23 BOXED EVERYDAY SEASONAL 125.58700 9 $456 $ 81,57700 ITEM 24 BOXED EVERYDAY SEASONAL 119 $631 $ 1,93700 ITEM BOXED EVERYDAY SEASONAL 317.00 $758 3 ITEMS BOXED EVERYDAY SEASONAL 316.000 8 3 H00 ITEM 77 PIECES SEASONAL 312,487.00 M $ 66.000 ITEM 29 PIECES SEASONAL 31251200 19 364 $ 10172700 Tel 23 SINGLES SEASONAL 33700 13 $ 900 ITEM 30 BOXED EVERYDAY SEASONAL 3.51400 17 17 $ M1000 ITEM 31 PECES SEASONAL 215,47800 M $ 435400 TEM PIECES SEASONAL 140 11 3521 $ 78.14300 ITEM 33 NOVELTY SEASONAL 18.00 10 3313 3 74,815.00 ITEMS BOKED EVERYDAY SEASONAL 3 $ $ ITEMS BOXED EVERYDAY SEASONAL $ 2417.50100 61 $ $ 11,51000 ITE BOXED EVERYDAY SEASONAL $ 300 11 $ ITEM 3 BOXED EVERYDAY SEASONAL $ 31511 $ N30 ITEM 39 NOVELTY $ SEASONAL 1.511 IT NOVELTY EVERYDAY SEASONAL $ 202.14101 $ 15 $18/ 8. 0 1 3 7 0 3 000 0 15400 2 21 $10 $0.00 3441 S800 3000 $100 g 6 6 4 3 4 5 C6 27 28 9 30 31 32 33 34 35 36 37 38 39 40 41 42 43 3 3 $41 0 13 $100 $741 $100 315 5 3 $ STEP 1 DO THE TOTAL FOR THE BUSINESS STEP 2 DO THE TOTAL IN ROW 504 STEP 3 DO SORT OF HIGHEST TO LOWEST IN THE BUS TOTAL COLUMN STEP FIRST 80% IS YOUR A SKUS DIFFERENCE WILL BE THE NEW CALC TO CALC FOR THE B SKUS THAT RESULT USE 80% FOR B SKUS. WHAT EVER IS REMAINING ARE THE CSKUS NO CAL CULATIONS NEEDED. SHOW TOTAL FOR A, B AND C SKUS. STEP 1 DO THE TOTAL FOR THE BUSINESS STEP 2 DO THE TOTAL IN ROW 504 STEP 3 DO SORT OF HIGHEST TO LOWEST IN THE BUS TOTAL COLUMN STEP FIRST 80% IS YOUR A SKUS DIFFERENCE WILL BE THE NEW CALC TO CALC FOR THE B SKUS THAT RESULT USE 80% FOR B SKUS. WHAT EVER IS REMAINING ARE THE CSKUS NO CAL CULATIONS NEEDED. SHOW TOTAL FOR A, B AND C SKUS. TOTAL FOR BUSINESS IS ADDING REGION 1 TO REGION 2 Toen 000) Avg Ret Und Poo 38.00 09 14 *12 2 4 3 3 4 7 0 5 30.00 S880 $0.00 91.14 $2.40 241 30.00 32.18 $10 $1.49 $0.00 9594 $1.35 $80 6 4 0 9 SKU LISTING BY ANNUAL SALES. FOR GROUP ASSIGNMENT JUNE 15TH REGION 1 REGION 2 wa SKUS LISTING DESCRIPTIONS FORMAT Bak Dolar Tonn (.000 Unik Price Seks Doors IBM BOXED EVERYDAY SEASONAL $ 94.001.00 271 $8.50 $ 1,306,300.00 ITEM 2 BOXED EVERYDAY SEASONAL $ 8,609,70.00 194 $4.97 $ 219.416.00 ITEMS PIECES SEASONAL $ 368.050.00 30 $249 $ MOM 4 BOXED SEASONAL $ 14414.845.00 14 $8.97 $ 61107.00 MEMG DOED EVERYDAY SEASONAL $ 35.600.00 20 $10.70 $ TOMO DOXED EVERYDAY SEASONAL $ 364,301.00 12 $0.4 $ 112,270.00 ? PECES SEASONAL $ 362.754.00 33 $3.50 $ ITEMO BOXED EVERYDAY SEASONAL $ 361,916,00 7 $10.20 $ 123,175.00 ITEMS PIECES SEASONAL $ 30,313.00 12 $2.91 $ 100236.00 ITBM 10 PIECES SEASONAL $ 357.241.00 33 $2.46 $ ITEM 11 PIECES SEASONAL $ 330,440.00 36 $3.57 $ ITEM 12 BOXED EVERYDAY SEASONAL $ 330,187.00 13 31.07 3 ITEM 13 BOXED EVERYDAY SEASONAL 2.012,07300 164 $1.05 $ ITEM 14 BOXED EVERYDAY SEASONAL $ 32,81300 31 $1.12 $ 140.00 ITEM 15 PIECES SEASONAL 34217800 40 $705 IBM 16 BARS EVERYDAY SEASONAL 30,493.00 21 $ 131061.00 ITEM 17 SINGLES SEASONAL 310,190,00 16 $1.20 $ 26.693.00 ITEM 10 BOXED EVERYDAY SEASONAL 3292400 13 $769 $ 89,08700 ITEM 19 BOXED EVERYDAY SEASONAL 338.213.00 8 $1173 $ 291,577.00 ITEM 20 PIECES SEASONAL 332,507.00 33 3176 $ ITEM 21 PIECES SEASONAL 127,174.00 19 $ 1100 ITEM 22 BOXED EVERYDAY SEASONAL 225,00/400 29 9103 $ ITEM 23 BOXED EVERYDAY SEASONAL 125.58700 9 $456 $ 81,57700 ITEM 24 BOXED EVERYDAY SEASONAL 119 $631 $ 1,93700 ITEM BOXED EVERYDAY SEASONAL 317.00 $758 3 ITEMS BOXED EVERYDAY SEASONAL 316.000 8 3 H00 ITEM 77 PIECES SEASONAL 312,487.00 M $ 66.000 ITEM 29 PIECES SEASONAL 31251200 19 364 $ 10172700 Tel 23 SINGLES SEASONAL 33700 13 $ 900 ITEM 30 BOXED EVERYDAY SEASONAL 3.51400 17 17 $ M1000 ITEM 31 PECES SEASONAL 215,47800 M $ 435400 TEM PIECES SEASONAL 140 11 3521 $ 78.14300 ITEM 33 NOVELTY SEASONAL 18.00 10 3313 3 74,815.00 ITEMS BOKED EVERYDAY SEASONAL 3 $ $ ITEMS BOXED EVERYDAY SEASONAL $ 2417.50100 61 $ $ 11,51000 ITE BOXED EVERYDAY SEASONAL $ 300 11 $ ITEM 3 BOXED EVERYDAY SEASONAL $ 31511 $ N30 ITEM 39 NOVELTY $ SEASONAL 1.511 IT NOVELTY EVERYDAY SEASONAL $ 202.14101 $ 15 $18/ 8. 0 1 3 7 0 3 000 0 15400 2 21 $10 $0.00 3441 S800 3000 $100 g 6 6 4 3 4 5 C6 27 28 9 30 31 32 33 34 35 36 37 38 39 40 41 42 43 3 3 $41 0 13 $100 $741 $100 315 5 3 $ STEP 1 DO THE TOTAL FOR THE BUSINESS STEP 2 DO THE TOTAL IN ROW 504 STEP 3 DO SORT OF HIGHEST TO LOWEST IN THE BUS TOTAL COLUMN STEP FIRST 80% IS YOUR A SKUS DIFFERENCE WILL BE THE NEW CALC TO CALC FOR THE B SKUS THAT RESULT USE 80% FOR B SKUS. WHAT EVER IS REMAINING ARE THE CSKUS NO CAL CULATIONS NEEDED. SHOW TOTAL FOR A, B AND C SKUS. STEP 1 DO THE TOTAL FOR THE BUSINESS STEP 2 DO THE TOTAL IN ROW 504 STEP 3 DO SORT OF HIGHEST TO LOWEST IN THE BUS TOTAL COLUMN STEP FIRST 80% IS YOUR A SKUS DIFFERENCE WILL BE THE NEW CALC TO CALC FOR THE B SKUS THAT RESULT USE 80% FOR B SKUS. WHAT EVER IS REMAINING ARE THE CSKUS NO CAL CULATIONS NEEDED. SHOW TOTAL FOR A, B AND C SKUS. TOTAL FOR BUSINESS IS ADDING REGION 1 TO REGION 2