Scribd
Upload
5 views3 pages

SKU Demand and Cost Analysis Report

This document contains information about 40 SKUs including their average demand, storage costs, and annual sales. It classifies the SKUs into three categories (A, B, C) based on their cumulative percentage of total sales. Category A comprises the top 20% of SKUs and accounts for 73.7% of total sales. Category B comprises the next 20% of SKUs and accounts for 20.93% of sales. Category C comprises the bottom 60% of SKUs and accounts for the remaining 5.37% of sales.

Uploaded by

LUISA MARIA OSORIO CARDENAS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views3 pages

SKU Demand and Cost Analysis Report

This document contains information about 40 SKUs including their average demand, storage costs, and annual sales. It classifies the SKUs into three categories (A, B, C) based on their cumulative percentage of total sales. Category A comprises the top 20% of SKUs and accounts for 73.7% of total sales. Category B comprises the next 20% of SKUs and accounts for 20.93% of sales. Category C comprises the bottom 60% of SKUs and accounts for the remaining 5.37% of sales.

Uploaded by

LUISA MARIA OSORIO CARDENAS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SKU Demanda promedio semestral (Und) Costo almacenamiento $ Venta ( $/año)

A009 500 44 22000


A001 700 26.3 18410
A006 100 43.9 4390
A002 200 17.6 3520
A011 100 20 2000
A015 80 15 1200
A005 4 92.1 368.4
A040 35.4 10 354
A039 34 9.4 319.6
A038 32.6 8.8 286.88
A037 31.2 8.2 255.84
A036 29.8 7.6 226.48
A035 28.4 7 198.8
A034 27 6.4 172.8
A033 25.6 5.8 148.48
A032 24.2 5.2 125.84
A012 50 2.3 115
A003 2 52.6 105.2
A031 22.8 4.6 104.88
A004 1.1 87.7 96.47
A030 21.4 4 85.6
A029 20.1 3.4 68.34
A028 18.6 2.8 52.08
A027 17.2 2.2 37.84
A007 3 8.8 26.4
A026 15.8 1.6 25.28
A020 6 2.6 15.6
A025 14.4 1 14.4
A017 1.8 7 12.6
A019 9 1.4 12.6
A013 3.1 4 12.4
A021 8.8 1.4 12.32
A008 2.5 4.5 11.25
A018 3.2 3 9.6
A010 1 8.8 8.8
A022 10.2 0.8 8.16
A014 5 1.2 6
A024 13 0.4 5.2
A016 2.3 2 4.6
A014 11.6 0.2 2.32
54830.06
Venta Acumulada % venta acumu Clasificacion % ABC
22000 40.12%
40410 73.70% A 73.70% zona
44800 81.71% 0-80%
48320 88.13% 80-95%
50320 91.77% 95-100%
51520 93.96% Total
51888.4 94.63% B 20.93%
52242.4 95.28%
52562 95.86%
52848.88 96.39%
53104.72 96.85%
53331.2 97.27%
53530 97.63%
53702.8 97.94%
53851.28 98.21%
53977.12 98.44%
54092.12 98.65%
54197.32 98.85%
54302.2 99.04%
54398.67 99.21%
54484.27 99.37%
54552.61 99.49%
54604.69 99.59%
54642.53 99.66%
54668.93 99.71%
54694.21 99.75%
54709.81 99.78%
54724.21 99.81%
54736.81 99.83%
54749.41 99.85%
54761.81 99.88%
54774.13 99.90%
54785.38 99.92%
54794.98 99.94%
54803.78 99.95%
54811.94 99.97%
54817.94 99.98%
54823.14 99.99%
54827.74 100.00%
54830.06 100.00% C 5.37%
Tabla 1 resumen inversion/ articulos
articulos % articulos acum % venta
2 5.00% 73.70%
5 12.50% 20.93%
33 82.50% 5.37%
40 100% 100%

You might also like