Elaboração de Movigrama

Elaboração de Movigrama


Overview

Extrato TB Limpeza Series Dimensionamento Grágico DIM Cobertura Parecer Zonas FES Auxiliar


Sheet 1: Extrato

SKU QUANT TIPO DATA SALDO INICIAL
DEMO 2 E 8/28/2000 20400
5 E 9/19/2000
2 E 9/21/2000
7 E 9/22/2000
12 E 9/27/2000
6 E 10/17/2000
8 E 10/19/2000
3 E 10/25/2000
1 E 11/10/2000
2 E 11/14/2000
1 E 11/25/2000
2 E 1/9/2001
2 E 1/24/2001
4 E 1/30/2001
5 E 2/1/2001
5 E 2/3/2001
2 E 2/23/2001
2 E 3/15/2001
4 E 3/22/2001
34 E 3/23/2001
68 E 3/23/2001
30 E 3/28/2001
2 E 3/30/2001
8 E 4/3/2001
4 E 4/5/2001
7 E 4/7/2001
3 E 4/14/2001
3 E 4/20/2001
3 E 4/30/2001
633 E 5/26/2001
438 E 5/28/2001
52 E 5/29/2001
222 E 6/19/2001
1930 E 6/20/2001
5 E 6/28/2001
150 E 12/20/2000
1000 E 12/15/2000
2 E 9/5/2000
3 E 10/6/2000
2 E 2/13/2001
3 E 3/8/2001
4 E 3/24/2001
200 E 7/17/2001
5400 E 7/4/2000
7000 E 7/5/2000
1600 E 7/7/2000
3000 E 7/11/2000
6000 E 7/12/2000
3100 E 7/14/2000
4600 E 7/17/2000
12000 E 7/19/2000
6000 E 7/25/2000
3200 E 7/27/2000
12800 E 7/31/2000
8800 E 8/3/2000
4600 E 8/7/2000
4600 E 8/8/2000
6000 E 8/10/2000
2200 E 8/14/2000
2200 E 8/16/2000
5400 E 8/17/2000
5000 E 8/18/2000
3600 E 8/22/2000
4400 E 8/23/2000
5400 E 8/25/2000
6000 E 8/29/2000
13000 E 8/30/2000
6000 E 9/11/2000
7800 E 9/13/2000
5400 E 9/14/2000
5000 E 9/18/2000
5000 E 9/21/2000
9600 E 9/26/2000
3200 E 9/28/2000
6000 E 10/2/2000
8400 E 10/6/2000
5400 E 10/6/2000
10000 E 10/9/2000
8000 E 10/24/2000
1300 E 10/24/2000
16200 E 10/25/2000
7000 E 11/1/2000
3000 E 11/1/2000
6000 E 11/4/2000
7000 E 11/6/2000
3600 E 11/9/2000
5400 E 11/9/2000
2000 E 11/11/2000
6400 E 11/17/2000
3800 E 11/21/2000
5400 E 11/22/2000
8600 E 11/23/2000
5000 E 11/27/2000
5000 E 12/2/2000
6000 E 12/2/2000
3800 E 12/5/2000
1800 E 12/6/2000
6400 E 12/7/2000
5800 E 12/11/2000
9000 E 12/13/2000
6000 E 12/15/2000
6400 E 12/22/2000
10400 E 1/9/2001
1000 E 1/10/2001
9400 E 1/11/2001
10400 E 1/12/2001
8600 E 1/12/2001
9400 E 1/18/2001
9000 E 1/19/2001
9000 E 1/23/2001
4000 E 1/29/2001
5000 E 1/29/2001
800 E 1/31/2001
6600 E 1/31/2001
10400 E 2/5/2001
10400 E 2/7/2001
10400 E 2/13/2001
3000 E 2/21/2001
17400 E 2/23/2001
10400 E 2/28/2001
3400 E 3/1/2001
10400 E 3/7/2001
10000 E 3/8/2001
10400 E 3/10/2001
15000 E 3/16/2001
8000 E 3/20/2001
8000 E 3/23/2001
5200 E 3/27/2001
6400 E 3/27/2001
6000 E 4/3/2001
10200 E 4/6/2001
6800 E 4/6/2001
4200 E 4/10/2001
6800 E 4/17/2001
2600 E 4/17/2001
6800 E 4/18/2001
8800 E 4/18/2001
6800 E 4/20/2001
9000 E 4/24/2001
9000 E 4/28/2001
6600 E 5/2/2001
6600 E 5/8/2001
9800 E 5/8/2001
6600 E 5/16/2001
26600 E 5/23/2001
9800 E 5/28/2001
2600 E 6/1/2001
6900 E 6/6/2001
6000 E 6/6/2001
8000 E 6/9/2001
5750 E 6/14/2001
3113 E 6/18/2001
25000 E 6/22/2001
4460 E 6/25/2001
3858 E 6/28/2001
8250 E 6/28/2001
3000 E 7/3/2001
3000 E 7/3/2001
1000 E 7/6/2001
3030 E 7/7/2001
1200 E 7/12/2001
3000 E 7/12/2001
6000 E 7/17/2001
11000 E 7/19/2001
7000 E 7/23/2001
3000 E 7/25/2001
3000 E 7/26/2001
11000 E 7/26/2001
3000 E 7/27/2001
4200 S 9/4/2000
1874 S 5/31/2001
338 S 6/20/2001
675 S 6/26/2001
222 S 6/26/2001
6984 S 7/5/2001
639 S 7/26/2001
1023 S 7/26/2001
205 S 7/26/2001
187 S 7/27/2001
86 S 7/27/2001
950 S 5/25/2001
800 S 8/28/2000
2800 S 9/1/2000
2600 S 9/21/2000
951 S 10/4/2000
2800 S 10/7/2000
2800 S 10/9/2000
2800 S 10/10/2000
2800 S 10/11/2000
800 S 10/16/2000
400 S 10/20/2000
4000 S 10/24/2000
2800 S 10/25/2000
800 S 10/26/2000
1400 S 11/7/2000
2000 S 11/30/2000
2800 S 12/2/2000
1600 S 12/4/2000
3000 S 12/5/2000
3200 S 12/6/2000
1400 S 12/11/2000
2600 S 12/13/2000
2800 S 1/8/2001
2800 S 1/9/2001
3000 S 1/11/2001
2000 S 2/20/2001
3000 S 2/20/2001
2800 S 3/2/2001
2800 S 3/6/2001
3200 S 3/7/2001
400 S 3/8/2001
2600 S 3/8/2001
3200 S 3/27/2001
2800 S 3/29/2001
1600 S 4/7/2001
1600 S 4/17/2001
600 S 4/17/2001
4200 S 4/19/2001
3200 S 4/24/2001
2200 S 4/25/2001
1000 S 4/27/2001
400 S 4/28/2001
3200 S 5/2/2001
2200 S 5/3/2001
3200 S 5/4/2001
3200 S 5/7/2001
3000 S 5/8/2001
3200 S 5/9/2001
3200 S 5/10/2001
3200 S 5/11/2001
3200 S 5/14/2001
2800 S 5/15/2001
3400 S 5/16/2001
3200 S 5/17/2001
3200 S 5/18/2001
2800 S 5/21/2001
400 S 5/22/2001
200 S 5/23/2001
600 S 5/23/2001
3200 S 5/24/2001
3200 S 5/25/2001
800 S 6/4/2001
3400 S 6/5/2001
800 S 6/6/2001
2750 S 6/12/2001
3000 S 6/13/2001
4400 S 6/15/2001
2913 S 6/18/2001
3800 S 6/19/2001
1000 S 6/20/2001
1000 S 6/20/2001
1000 S 6/20/2001
1121 S 6/20/2001
900 S 6/22/2001
1296 S 6/23/2001
2124 S 6/27/2001
2927 S 6/29/2001
200 S 8/28/2000
200 S 9/1/2000
400 S 9/21/2000
200 S 10/3/2000
200 S 10/7/2000
200 S 10/9/2000
200 S 10/10/2000
200 S 10/11/2000
200 S 10/16/2000
200 S 10/24/2000
200 S 10/25/2000
200 S 11/30/2000
200 S 12/2/2000
200 S 12/4/2000
400 S 12/5/2000
400 S 12/6/2000
400 S 12/13/2000
400 S 1/8/2001
200 S 1/9/2001
200 S 1/11/2001
200 S 2/20/2001
200 S 2/20/2001
200 S 3/2/2001
200 S 3/6/2001
400 S 3/7/2001
200 S 3/8/2001
200 S 3/27/2001
200 S 4/7/2001
200 S 4/17/2001
200 S 4/19/2001
200 S 4/24/2001
200 S 4/25/2001
200 S 4/27/2001
200 S 5/2/2001
200 S 5/3/2001
200 S 5/4/2001
200 S 5/7/2001
200 S 5/9/2001
200 S 5/10/2001
200 S 5/11/2001
200 S 5/14/2001
200 S 5/16/2001
200 S 5/18/2001
200 S 5/24/2001
200 S 5/25/2001
200 S 6/4/2001
200 S 6/5/2001
200 S 6/6/2001
200 S 6/13/2001
400 S 6/15/2001
200 S 6/18/2001
200 S 6/19/2001
2200 S 8/22/2000
2000 S 8/24/2000
1000 S 8/30/2000
2600 S 8/31/2000
2800 S 9/29/2000
1800 S 10/2/2000
800 S 10/3/2000
1525 S 10/3/2000
1000 S 10/4/2000
1188 S 10/4/2000
2800 S 10/5/2000
2800 S 11/3/2000
3200 S 4/26/2001
1600 S 4/27/2001
2400 S 4/28/2001
2600 S 4/30/2001
3200 S 5/28/2001
4268 S 5/29/2001
3200 S 5/30/2001
3581 S 5/31/2001
3400 S 6/1/2001
2262 S 6/4/2001
2600 S 6/6/2001
3400 S 6/7/2001
2800 S 6/8/2001
3400 S 6/9/2001
300 S 6/12/2001
400 S 6/13/2001
2635 S 6/21/2001
1800 S 6/22/2001
1800 S 6/22/2001
1805 S 6/25/2001
1553 S 6/25/2001
2645 S 6/25/2001
3400 S 6/26/2001
1627 S 6/27/2001
655 S 6/28/2001
1000 S 7/2/2001
1720 S 7/2/2001
800 S 7/3/2001
1972 S 7/3/2001
2413 S 7/4/2001
800 S 7/4/2001
2077 S 7/5/2001
2600 S 7/6/2001
1496 S 7/9/2001
1200 S 7/9/2001
2234 S 7/10/2001
2646 S 7/11/2001
2600 S 7/12/2001
2589 S 7/13/2001
1149 S 7/14/2001
1600 S 7/14/2001
2150 S 7/16/2001
2800 S 7/17/2001
2764 S 7/18/2001
2600 S 7/19/2001
3105 S 7/20/2001
761 S 7/21/2001
1600 S 7/21/2001
2000 S 7/23/2001
2765 S 7/24/2001
2951 S 7/25/2001
2000 S 7/26/2001
400 S 7/27/2001
200 S 8/22/2000
200 S 8/24/2000
400 S 8/31/2000
200 S 9/29/2000
400 S 10/2/2000
400 S 10/4/2000
382 S 10/5/2000
200 S 11/3/2000
150 S 12/21/2000
200 S 4/26/2001
200 S 4/28/2001
200 S 5/28/2001
200 S 5/29/2001
200 S 5/30/2001
200 S 5/31/2001
200 S 6/1/2001
200 S 6/21/2001
200 S 6/22/2001
200 S 6/25/2001
200 S 6/26/2001
200 S 6/27/2001
200 S 6/28/2001
600 S 7/2/2001
200 S 7/3/2001
400 S 7/4/2001
200 S 7/5/2001
200 S 7/6/2001
200 S 7/9/2001
200 S 7/10/2001
200 S 7/11/2001
200 S 7/12/2001
400 S 7/13/2001
200 S 7/16/2001
200 S 7/17/2001
200 S 7/18/2001
200 S 7/20/2001
200 S 7/21/2001
200 S 7/23/2001
200 S 7/24/2001
200 S 7/25/2001
200 S 7/27/2001
200 S 7/14/2000
4600 S 7/27/2000
1800 S 7/31/2000
1200 S 7/31/2000
1800 S 7/31/2000
2600 S 8/1/2000
2200 S 8/2/2000
5000 S 8/3/2000
800 S 8/10/2000
1800 S 8/11/2000
2200 S 8/16/2000
2000 S 8/17/2000
2800 S 8/18/2000
2600 S 8/21/2000
2000 S 8/23/2000
200 S 7/14/2000
400 S 7/29/2000
200 S 7/31/2000
200 S 8/1/2000
400 S 8/2/2000
400 S 8/5/2000
200 S 8/7/2000
200 S 8/11/2000
200 S 8/17/2000
200 S 8/18/2000
200 S 8/21/2000
600 S 8/23/2000
1600 S 9/15/2000
1000 S 1/15/2001
2600 S 12/14/2000
200 S 12/14/2000
1200 S 3/16/2001
3000 S 3/19/2001
3000 S 3/20/2001
400 S 3/21/2001
1800 S 3/21/2001
200 S 3/21/2001
200 S 3/16/2001
200 S 3/19/2001
2800 S 7/17/2000
300 S 7/17/2000
1040 S 11/17/2000
260 S 11/13/2000
600 S 11/17/2000
2800 S 11/6/2000
200 S 11/6/2000
2000 S 10/26/2000
2800 S 10/27/2000
200 S 10/26/2000
400 S 10/27/2000
1600 S 8/7/2000
2600 S 8/8/2000
200 S 8/8/2000
1000 S 7/20/2000
1800 S 3/26/2001
200 S 3/24/2001
200 S 3/26/2001
1600 S 11/7/2000
400 S 11/7/2000
1000 S 8/7/2000
2800 S 8/9/2000
2200 S 8/10/2000
200 S 8/9/2000
1000 S 2/14/2001
3800 S 2/15/2001
3400 S 4/9/2001
1400 S 4/10/2001
200 S 2/14/2001
200 S 4/9/2001
400 S 2/14/2001
2600 S 4/20/2001
400 S 2/14/2001
2600 S 8/5/2000
400 S 1/31/2001
1600 S 2/2/2001
2400 S 2/5/2001
3200 S 2/16/2001
1200 S 2/19/2001
200 S 8/5/2000
200 S 1/31/2001
400 S 2/3/2001
400 S 2/15/2001
200 S 2/16/2001
2600 S 7/7/2000
2400 S 7/10/2000
400 S 7/7/2000
800 S 10/18/2000
2800 S 10/19/2000
1200 S 4/18/2001
200 S 10/18/2000
200 S 10/19/2000
600 S 7/21/2000
2800 S 7/24/2000
400 S 7/21/2000
400 S 7/24/2000
1800 S 9/4/2000
3100 S 12/19/2000
1600 S 12/20/2000
200 S 9/4/2000
300 S 12/19/2000
2000 S 7/11/2000
1800 S 8/14/2000
400 S 7/3/2000
2600 S 7/4/2000
600 S 7/3/2000
400 S 7/4/2000
1800 S 7/3/2000
2600 S 9/26/2000
200 S 9/26/2000
2600 S 9/27/2000
2200 S 9/28/2000
200 S 9/27/2000
2000 S 9/22/2000
1800 S 7/20/2000
2200 S 7/21/2000
200 S 7/19/2000
400 S 7/20/2000
1000 S 8/28/2000
2600 S 7/5/2000
200 S 7/10/2000
400 S 7/11/2000
1000 S 7/13/2000
2400 S 7/14/2000
2400 S 7/18/2000
2800 S 7/19/2000
400 S 7/10/2000
200 S 7/11/2000
400 S 7/13/2000
400 S 7/18/2000
1000 S 8/11/2000
3200 S 3/5/2001
200 S 3/5/2001
1000 S 10/31/2000
2400 S 11/1/2000
3000 S 11/16/2000
200 S 10/31/2000
200 S 11/1/2000
400 S 11/16/2000
1800 S 11/14/2000
200 S 11/14/2000
2000 S 11/10/2000
2000 S 11/11/2000
1400 S 11/27/2000
3000 S 11/28/2000
260 S 11/25/2000
200 S 11/27/2000
140 S 11/28/2000
1600 S 7/13/2000
2800 S 8/29/2000
1400 S 8/30/2000
400 S 3/12/2001
200 S 8/29/2000
400 S 3/8/2001
1400 S 1/15/2001
600 S 11/11/2000
3000 S 11/13/2000
400 S 11/11/2000
200 S 11/13/2000
3200 S 3/9/2001
2800 S 3/10/2001
800 S 3/12/2001
200 S 3/9/2001
200 S 3/10/2001
400 S 11/10/2000
200 S 11/10/2000
2600 S 7/12/2000
2400 S 9/19/2000
400 S 7/12/2000
200 S 9/19/2000
1600 S 11/17/2000
1400 S 11/20/2000
2200 S 11/21/2000
200 S 11/20/2000
3200 S 9/5/2000
1000 S 9/6/2000
1000 S 9/9/2000
1000 S 12/15/2000
1000 S 12/16/2000
2600 S 12/18/2000
400 S 9/5/2000
200 S 9/9/2000
200 S 12/15/2000
200 S 12/16/2000
2600 S 9/25/2000
1800 S 10/6/2000
1000 S 10/20/2000
1800 S 2/7/2001
3000 S 2/8/2001
400 S 9/25/2000
200 S 9/28/2000
200 S 2/8/2001
400 S 9/28/2000
1800 S 12/11/2000
2000 S 12/15/2000
2000 S 12/16/2000
2800 S 8/25/2000
1000 S 8/28/2000
600 S 8/25/2000
1000 S 8/14/2000
2800 S 8/15/2000
1000 S 11/8/2000
3000 S 11/9/2000
200 S 8/14/2000
400 S 8/15/2000
200 S 11/8/2000
200 S 11/9/2000
2800 S 10/17/2000
200 S 10/17/2000
1800 S 10/31/2000
3000 S 10/30/2000
200 S 10/30/2000
1400 S 11/20/2000
400 S 10/4/2000
400 S 10/6/2000
3000 S 1/12/2001
1800 S 3/23/2001
3200 S 3/24/2001
400 S 10/6/2000
2400 S 12/1/2000
400 S 12/1/2000
2600 S 1/10/2001
400 S 1/10/2001
400 S 1/13/2001
400 S 1/15/2001
400 S 1/13/2001
2194 S 10/16/2000
3200 S 4/2/2001
1600 S 4/3/2001
3200 S 4/5/2001
2600 S 4/6/2001
200 S 4/2/2001
200 S 4/5/2001
3600 S 2/1/2001
800 S 2/5/2001
3400 S 2/6/2001
400 S 2/1/2001
200 S 2/5/2001
200 S 2/6/2001
400 S 2/7/2001
3000 S 1/13/2001
3200 S 1/18/2001
400 S 1/18/2001
600 S 11/21/2000
2800 S 11/23/2000
1800 S 11/24/2000
4800 S 12/12/2000
400 S 11/21/2000
200 S 11/23/2000
200 S 12/12/2000
400 S 3/21/2001
2600 S 1/29/2001
2000 S 1/30/2001
400 S 1/29/2001
1000 S 7/29/2000
2800 S 3/30/2001
200 S 3/31/2001
400 S 3/21/2001
3000 S 3/22/2001
1400 S 3/23/2001
200 S 3/21/2001
3200 S 2/9/2001
2000 S 2/10/2001
3200 S 4/12/2001
1000 S 4/17/2001
2000 S 4/18/2001
600 S 4/20/2001
600 S 4/30/2001
600 S 5/8/2001
400 S 5/15/2001
200 S 2/9/2001
200 S 4/18/2001
200 S 4/20/2001
200 S 4/30/2001
200 S 5/8/2001
2000 S 10/18/2000
600 S 11/24/2000
2600 S 11/25/2000
1400 S 11/27/2000
400 S 11/24/2000
400 S 11/25/2000
3000 S 11/29/2000
200 S 11/28/2000
400 S 11/29/2000
1200 S 1/30/2001
2400 S 1/31/2001
800 S 2/2/2001
400 S 1/30/2001
200 S 1/22/2001
3000 S 1/23/2001
600 S 1/24/2001
200 S 1/22/2001
400 S 1/23/2001
1200 S 3/26/2001
1600 S 4/3/2001
2800 S 4/4/2001
200 S 4/4/2001
3200 S 12/22/2000
3000 S 1/5/2001
400 S 1/15/2001
4 S 1/16/2001
3000 S 1/17/2001
1196 S 1/19/2001
3400 S 2/21/2001
2000 S 2/22/2001
200 S 1/5/2001
200 S 1/15/2001
200 S 1/17/2001
200 S 2/22/2001
1200 S 2/10/2001
3200 S 2/12/2001
400 S 2/10/2001
200 S 2/12/2001
2000 S 1/19/2001
2800 S 1/22/2001
200 S 1/19/2001
2800 S 11/22/2000
200 S 11/22/2000
2000 S 11/8/2000
1800 S 7/25/2000
2400 S 7/26/2000
400 S 7/27/2000
200 S 10/20/2000
400 S 7/25/2000
400 S 7/26/2000
400 S 7/27/2000
200 S 10/20/2000
1000 S 1/25/2001
2600 S 1/26/2001
400 S 1/25/2001
1000 S 7/25/2000
400 S 8/16/2000
200 S 8/16/2000
1600 S 2/7/2001
1800 S 4/10/2001
3000 S 4/11/2001
200 S 4/10/2001
1200 S 9/18/2000
2600 S 9/20/2000
600 S 9/22/2000
400 S 9/18/2000
200 S 9/20/2000
400 S 9/22/2000
600 S 1/26/2001
3200 S 1/27/2001
1000 S 1/29/2001
200 S 1/27/2001
3200 S 4/23/2001
400 S 4/25/2001
200 S 4/23/2001
2600 S 1/24/2001
2200 S 1/25/2001
200 S 1/24/2001
2800 S 12/7/2000
732 S 12/21/2000
200 S 12/18/2000
68 S 12/21/2000
100 S 12/20/2000
900 S 12/20/2000
3000 S 1/16/2001
800 S 1/17/2001
400 S 1/16/2001
2800 S 7/6/2000
400 S 7/5/2000
400 S 7/6/2000
2200 S 3/12/2001
2600 S 3/13/2001
200 S 3/12/2001
1400 S 9/18/2000
400 S 4/11/2001
2600 S 4/16/2001
400 S 4/11/2001
1600 S 2/22/2001
3000 S 2/23/2001
1000 S 2/23/2001
3000 S 3/1/2001
400 S 2/24/2001
400 S 3/1/2001
200 S 5/15/2001
1400 S 5/23/2001
200 S 5/15/2001
3400 S 2/13/2001
1200 S 2/14/2001
400 S 2/13/2001
3000 S 3/15/2001
1800 S 3/16/2001
200 S 3/15/2001
3400 S 3/28/2001
1000 S 3/29/2001
600 S 4/6/2001
200 S 3/29/2001
200 S 4/6/2001
3800 S 5/22/2001
800 S 3/13/2001
3000 S 3/14/2001
600 S 3/15/2001
400 S 3/13/2001
200 S 3/14/2001
0 7/3/2000
0 7/4/2000
0 7/5/2000
0 7/6/2000
0 7/7/2000
0 7/8/2000
0 7/9/2000
0 7/10/2000
0 7/11/2000
0 7/12/2000
0 7/13/2000
0 7/14/2000
0 7/15/2000
0 7/16/2000
0 7/17/2000
0 7/18/2000
0 7/19/2000
0 7/20/2000
0 7/21/2000
0 7/22/2000
0 7/23/2000
0 7/24/2000
0 7/25/2000
0 7/26/2000
0 7/27/2000
0 7/28/2000
0 7/29/2000
0 7/30/2000
0 7/31/2000
0 8/1/2000
0 8/2/2000
0 8/3/2000
0 8/4/2000
0 8/5/2000
0 8/6/2000
0 8/7/2000
0 8/8/2000
0 8/9/2000
0 8/10/2000
0 8/11/2000
0 8/12/2000
0 8/13/2000
0 8/14/2000
0 8/15/2000
0 8/16/2000
0 8/17/2000
0 8/18/2000
0 8/19/2000
0 8/20/2000
0 8/21/2000
0 8/22/2000
0 8/23/2000
0 8/24/2000
0 8/25/2000
0 8/26/2000
0 8/27/2000
0 8/28/2000
0 8/29/2000
0 8/30/2000
0 8/31/2000
0 9/1/2000
0 9/2/2000
0 9/3/2000
0 9/4/2000
0 9/5/2000
0 9/6/2000
0 9/7/2000
0 9/8/2000
0 9/9/2000
0 9/10/2000
0 9/11/2000
0 9/12/2000
0 9/13/2000
0 9/14/2000
0 9/15/2000
0 9/16/2000
0 9/17/2000
0 9/18/2000
0 9/19/2000
0 9/20/2000
0 9/21/2000
0 9/22/2000
0 9/23/2000
0 9/24/2000
0 9/25/2000
0 9/26/2000
0 9/27/2000
0 9/28/2000
0 9/29/2000
0 9/30/2000
0 10/1/2000
0 10/2/2000
0 10/3/2000
0 10/4/2000
0 10/5/2000
0 10/6/2000
0 10/7/2000
0 10/8/2000
0 10/9/2000
0 10/10/2000
0 10/11/2000
0 10/12/2000
0 10/13/2000
0 10/14/2000
0 10/15/2000
0 10/16/2000
0 10/17/2000
0 10/18/2000
0 10/19/2000
0 10/20/2000
0 10/21/2000
0 10/22/2000
0 10/23/2000
0 10/24/2000
0 10/25/2000
0 10/26/2000
0 10/27/2000
0 10/28/2000
0 10/29/2000
0 10/30/2000
0 10/31/2000
0 11/1/2000
0 11/2/2000
0 11/3/2000
0 11/4/2000
0 11/5/2000
0 11/6/2000
0 11/7/2000
0 11/8/2000
0 11/9/2000
0 11/10/2000
0 11/11/2000
0 11/12/2000
0 11/13/2000
0 11/14/2000
0 11/15/2000
0 11/16/2000
0 11/17/2000
0 11/18/2000
0 11/19/2000
0 11/20/2000
0 11/21/2000
0 11/22/2000
0 11/23/2000
0 11/24/2000
0 11/25/2000
0 11/26/2000
0 11/27/2000
0 11/28/2000
0 11/29/2000
0 11/30/2000
0 12/1/2000
0 12/2/2000
0 12/3/2000
0 12/4/2000
0 12/5/2000
0 12/6/2000
0 12/7/2000
0 12/8/2000
0 12/9/2000
0 12/10/2000
0 12/11/2000
0 12/12/2000
0 12/13/2000
0 12/14/2000
0 12/15/2000
0 12/16/2000
0 12/17/2000
0 12/18/2000
0 12/19/2000
0 12/20/2000
0 12/21/2000
0 12/22/2000
0 12/23/2000
0 12/24/2000
0 12/25/2000
0 12/26/2000
0 12/27/2000
0 12/28/2000
0 12/29/2000
0 12/30/2000
0 12/31/2000
0 1/1/2001
0 1/2/2001
0 1/3/2001
0 1/4/2001
0 1/5/2001
0 1/6/2001
0 1/7/2001
0 1/8/2001
0 1/9/2001
0 1/10/2001
0 1/11/2001
0 1/12/2001
0 1/13/2001
0 1/14/2001
0 1/15/2001
0 1/16/2001
0 1/17/2001
0 1/18/2001
0 1/19/2001
0 1/20/2001
0 1/21/2001
0 1/22/2001
0 1/23/2001
0 1/24/2001
0 1/25/2001
0 1/26/2001
0 1/27/2001
0 1/28/2001
0 1/29/2001
0 1/30/2001
0 1/31/2001
0 2/1/2001
0 2/2/2001
0 2/3/2001
0 2/4/2001
0 2/5/2001
0 2/6/2001
0 2/7/2001
0 2/8/2001
0 2/9/2001
0 2/10/2001
0 2/11/2001
0 2/12/2001
0 2/13/2001
0 2/14/2001
0 2/15/2001
0 2/16/2001
0 2/17/2001
0 2/18/2001
0 2/19/2001
0 2/20/2001
0 2/21/2001
0 2/22/2001
0 2/23/2001
0 2/24/2001
0 2/25/2001
0 2/26/2001
0 2/27/2001
0 2/28/2001
0 3/1/2001
0 3/2/2001
0 3/3/2001
0 3/4/2001
0 3/5/2001
0 3/6/2001
0 3/7/2001
0 3/8/2001
0 3/9/2001
0 3/10/2001
0 3/11/2001
0 3/12/2001
0 3/13/2001
0 3/14/2001
0 3/15/2001
0 3/16/2001
0 3/17/2001
0 3/18/2001
0 3/19/2001
0 3/20/2001
0 3/21/2001
0 3/22/2001
0 3/23/2001
0 3/24/2001
0 3/25/2001
0 3/26/2001
0 3/27/2001
0 3/28/2001
0 3/29/2001
0 3/30/2001
0 3/31/2001
0 4/1/2001
0 4/2/2001
0 4/3/2001
0 4/4/2001
0 4/5/2001
0 4/6/2001
0 4/7/2001
0 4/8/2001
0 4/9/2001
0 4/10/2001
0 4/11/2001
0 4/12/2001
0 4/13/2001
0 4/14/2001
0 4/15/2001
0 4/16/2001
0 4/17/2001
0 4/18/2001
0 4/19/2001
0 4/20/2001
0 4/21/2001
0 4/22/2001
0 4/23/2001
0 4/24/2001
0 4/25/2001
0 4/26/2001
0 4/27/2001
0 4/28/2001
0 4/29/2001
0 4/30/2001
0 5/1/2001
0 5/2/2001
0 5/3/2001
0 5/4/2001
0 5/5/2001
0 5/6/2001
0 5/7/2001
0 5/8/2001
0 5/9/2001
0 5/10/2001
0 5/11/2001
0 5/12/2001
0 5/13/2001
0 5/14/2001
0 5/15/2001
0 5/16/2001
0 5/17/2001
0 5/18/2001
0 5/19/2001
0 5/20/2001
0 5/21/2001
0 5/22/2001
0 5/23/2001
0 5/24/2001
0 5/25/2001
0 5/26/2001
0 5/27/2001
0 5/28/2001
0 5/29/2001
0 5/30/2001
0 5/31/2001
0 6/1/2001
0 6/2/2001
0 6/3/2001
0 6/4/2001
0 6/5/2001
0 6/6/2001
0 6/7/2001
0 6/8/2001
0 6/9/2001
0 6/10/2001
0 6/11/2001
0 6/12/2001
0 6/13/2001
0 6/14/2001
0 6/15/2001
0 6/16/2001
0 6/17/2001
0 6/18/2001
0 6/19/2001
0 6/20/2001
0 6/21/2001
0 6/22/2001
0 6/23/2001
0 6/24/2001
0 6/25/2001
0 6/26/2001
0 6/27/2001
0 6/28/2001
0 6/29/2001
0 6/30/2001
0 7/1/2001
0 7/2/2001
0 7/3/2001
0 7/4/2001
0 7/5/2001
0 7/6/2001
0 7/7/2001
0 7/8/2001
0 7/9/2001
0 7/10/2001
0 7/11/2001
0 7/12/2001
0 7/13/2001
0 7/14/2001
0 7/15/2001
0 7/16/2001
0 7/17/2001
0 7/18/2001
0 7/19/2001
0 7/20/2001
0 7/21/2001
0 7/22/2001
0 7/23/2001
0 7/24/2001
0 7/25/2001
0 7/26/2001
0 7/27/2001

Sheet 2: TB

Soma de QUANT TIPO
DATA E S Total Global
7/3/2000 2800 2800
7/4/2000 5400 3000 8400
7/5/2000 7000 3000 10000
7/6/2000 3200 3200
7/7/2000 1600 3000 4600
7/10/2000 3000 3000
7/11/2000 3000 2600 5600
7/12/2000 6000 3000 9000
7/13/2000 3000 3000
7/14/2000 3100 2800 5900
7/17/2000 4600 3100 7700
7/18/2000 2800 2800
7/19/2000 12000 3000 15000
7/20/2000 3200 3200
7/21/2000 3200 3200
7/24/2000 3200 3200
7/25/2000 6000 3200 9200
7/26/2000 2800 2800
7/27/2000 3200 5400 8600
7/29/2000 1400 1400
7/31/2000 12800 5000 17800
8/1/2000 2800 2800
8/2/2000 2600 2600
8/3/2000 8800 5000 13800
8/5/2000 3200 3200
8/7/2000 4600 2800 7400
8/8/2000 4600 2800 7400
8/9/2000 3000 3000
8/10/2000 6000 3000 9000
8/11/2000 3000 3000
8/14/2000 2200 3000 5200
8/15/2000 3200 3200
8/16/2000 2200 2800 5000
8/17/2000 5400 2200 7600
8/18/2000 5000 3000 8000
8/21/2000 2800 2800
8/22/2000 3600 2400 6000
8/23/2000 4400 2600 7000
8/24/2000 2200 2200
8/25/2000 5400 3400 8800
8/28/2000 2 3000 3002
8/29/2000 6000 3000 9000
8/30/2000 13000 2400 15400
8/31/2000 3000 3000
9/1/2000 3000 3000
9/4/2000 6200 6200
9/5/2000 2 3600 3602
9/6/2000 1000 1000
9/9/2000 1200 1200
9/11/2000 6000 6000
9/13/2000 7800 7800
9/14/2000 5400 5400
9/15/2000 1600 1600
9/18/2000 5000 3000 8000
9/19/2000 5 2600 2605
9/20/2000 2800 2800
9/21/2000 5002 3000 8002
9/22/2000 7 3000 3007
9/25/2000 3000 3000
9/26/2000 9600 2800 12400
9/27/2000 12 2800 2812
9/28/2000 3200 2800 6000
9/29/2000 3000 3000
10/2/2000 6000 2200 8200
10/3/2000 2525 2525
10/4/2000 3939 3939
10/5/2000 3182 3182
10/6/2000 13803 2600 16403
10/7/2000 3000 3000
10/9/2000 10000 3000 13000
10/10/2000 3000 3000
10/11/2000 3000 3000
10/16/2000 3194 3194
10/17/2000 6 3000 3006
10/18/2000 3000 3000
10/19/2000 8 3000 3008
10/20/2000 1800 1800
10/24/2000 9300 4200 13500
10/25/2000 16203 3000 19203
10/26/2000 3000 3000
10/27/2000 3200 3200
10/30/2000 3200 3200
10/31/2000 3000 3000
11/1/2000 10000 2600 12600
11/3/2000 3000 3000
11/4/2000 6000 6000
11/6/2000 7000 3000 10000
11/7/2000 3400 3400
11/8/2000 3200 3200
11/9/2000 9000 3200 12200
11/10/2000 1 2600 2601
11/11/2000 2000 3000 5000
11/13/2000 3460 3460
11/14/2000 2 2000 2002
11/16/2000 3400 3400
11/17/2000 6400 3240 9640
11/20/2000 3000 3000
11/21/2000 3800 3200 7000
11/22/2000 5400 3000 8400
11/23/2000 8600 3000 11600
11/24/2000 2800 2800
11/25/2000 1 3260 3261
11/27/2000 5000 3000 8000
11/28/2000 3340 3340
11/29/2000 3400 3400
11/30/2000 2200 2200
12/1/2000 2800 2800
12/2/2000 11000 3000 14000
12/4/2000 1800 1800
12/5/2000 3800 3400 7200
12/6/2000 1800 3600 5400
12/7/2000 6400 2800 9200
12/11/2000 5800 3200 9000
12/12/2000 5000 5000
12/13/2000 9000 3000 12000
12/14/2000 2800 2800
12/15/2000 7000 3200 10200
12/16/2000 3200 3200
12/18/2000 2800 2800
12/19/2000 3400 3400
12/20/2000 150 2600 2750
12/21/2000 950 950
12/22/2000 6400 3200 9600
1/5/2001 3200 3200
1/8/2001 3200 3200
1/9/2001 10402 3000 13402
1/10/2001 1000 3000 4000
1/11/2001 9400 3200 12600
1/12/2001 19000 3000 22000
1/13/2001 3800 3800
1/15/2001 3400 3400
1/16/2001 3404 3404
1/17/2001 4000 4000
1/18/2001 9400 3600 13000
1/19/2001 9000 3396 12396
1/22/2001 3200 3200
1/23/2001 9000 3400 12400
1/24/2001 2 3400 3402
1/25/2001 3600 3600
1/26/2001 3200 3200
1/27/2001 3400 3400
1/29/2001 9000 4000 13000
1/30/2001 4 3600 3604
1/31/2001 7400 3000 10400
2/1/2001 5 4000 4005
2/2/2001 2400 2400
2/3/2001 5 400 405
2/5/2001 10400 3400 13800
2/6/2001 3600 3600
2/7/2001 10400 3800 14200
2/8/2001 3200 3200
2/9/2001 3400 3400
2/10/2001 3600 3600
2/12/2001 3400 3400
2/13/2001 10402 3800 14202
2/14/2001 3200 3200
2/15/2001 4200 4200
2/16/2001 3400 3400
2/19/2001 1200 1200
2/20/2001 5400 5400
2/21/2001 3000 3400 6400
2/22/2001 3800 3800
2/23/2001 17402 4000 21402
2/24/2001 400 400
2/28/2001 10400 10400
3/1/2001 3400 3400 6800
3/2/2001 3000 3000
3/5/2001 3400 3400
3/6/2001 3000 3000
3/7/2001 10400 3600 14000
3/8/2001 10003 3600 13603
3/9/2001 3400 3400
3/10/2001 10400 3000 13400
3/12/2001 3600 3600
3/13/2001 3800 3800
3/14/2001 3200 3200
3/15/2001 2 3800 3802
3/16/2001 15000 3200 18200
3/19/2001 3200 3200
3/20/2001 8000 3000 11000
3/21/2001 3400 3400
3/22/2001 4 3000 3004
3/23/2001 6808068 6803200 13611268
3/24/2001 4 3400 3404
3/26/2001 3200 3200
3/27/2001 11600 3400 15000
3/28/2001 30 3400 3430
3/29/2001 4000 4000
3/30/2001 2 2800 2802
3/31/2001 200 200
4/2/2001 3400 3400
4/3/2001 6008 3200 9208
4/4/2001 3000 3000
4/5/2001 4 3400 3404
4/6/2001 17000 3400 20400
4/7/2001 7 1800 1807
4/9/2001 3600 3600
4/10/2001 4200 3400 7600
4/11/2001 3800 3800
4/12/2001 3200 3200
4/14/2001 3 3
4/16/2001 2600 2600
4/17/2001 9400 3400 12800
4/18/2001 15600 3400 19000
4/19/2001 4400 4400
4/20/2001 6803 3400 10203
4/23/2001 3400 3400
4/24/2001 9000 3400 12400
4/25/2001 2800 2800
4/26/2001 3400 3400
4/27/2001 2800 2800
4/28/2001 9000 3000 12000
4/30/2001 3 3400 3403
5/2/2001 6600 3400 10000
5/3/2001 2400 2400
5/4/2001 3400 3400
5/7/2001 3400 3400
5/8/2001 16400 3800 20200
5/9/2001 3400 3400
5/10/2001 3400 3400
5/11/2001 3400 3400
5/14/2001 3400 3400
5/15/2001 3600 3600
5/16/2001 6600 3600 10200
5/17/2001 3200 3200
5/18/2001 3400 3400
5/21/2001 2800 2800
5/22/2001 4200 4200
5/23/2001 26600 2200 28800
5/24/2001 3400 3400
5/25/2001 4350 4350
5/26/2001 633 633
5/28/2001 10238 3400 13638
5/29/2001 52 4468 4520
5/30/2001 3400 3400
5/31/2001 5655 5655
6/1/2001 2600 3600 6200
6/4/2001 3262 3262
6/5/2001 3600 3600
6/6/2001 12900 3600 16500
6/7/2001 3400 3400
6/8/2001 2800 2800
6/9/2001 8000 3400 11400
6/12/2001 3050 3050
6/13/2001 3600 3600
6/14/2001 5750 5750
6/15/2001 4800 4800
6/18/2001 3113 3113 6226
6/19/2001 222 4000 4222
6/20/2001 1930 4459 6389
6/21/2001 2835 2835
6/22/2001 25000 4700 29700
6/23/2001 1296 1296
6/25/2001 4460 6203 10663
6/26/2001 4497 4497
6/27/2001 3951 3951
6/28/2001 12113 855 12968
6/29/2001 2927 2927
7/2/2001 3320 3320
7/3/2001 6000 2972 8972
7/4/2001 3613 3613
7/5/2001 9261 9261
7/6/2001 1000 2800 3800
7/7/2001 3030 3030
7/9/2001 2896 2896
7/10/2001 2434 2434
7/11/2001 2846 2846
7/12/2001 4200 2800 7000
7/13/2001 2989 2989
7/14/2001 2749 2749
7/16/2001 2350 2350
7/17/2001 6200 3000 9200
7/18/2001 2964 2964
7/19/2001 11000 2600 13600
7/20/2001 3305 3305
7/21/2001 2561 2561
7/23/2001 7000 2200 9200
7/24/2001 2965 2965
7/25/2001 3000 3151 6151
7/26/2001 14000 3867 17867
7/27/2001 3000 873 3873
Total Global 7649008 7662327 15311335

Sheet 3: Limpeza

DATA ENTRADA SAÏDA
3/7/00 -2800
4/7/00 5400 -3000
5/7/00 7000 -3000
6/7/00 -3200
7/7/00 1600 -3000
10/7/00 -3000
11/7/00 3000 -2600
12/7/00 6000 -3000
13/7/00 -3000
14/7/00 3100 -2800
17/7/00 4600 -3100
18/7/00 -2800
19/7/00 12000 -3000
20/7/00 -3200
21/7/00 -3200
24/7/00 -3200
25/7/00 6000 -3200
26/7/00 -2800
27/7/00 3200 -5400
29/7/00 -1400
31/7/00 12800 -5000
1/8/00 -2800
2/8/00 -2600
3/8/00 8800 -5000
5/8/00 -3200
7/8/00 4600 -2800
8/8/00 4600 -2800
9/8/00 -3000
10/8/00 6000 -3000
11/8/00 -3000
14/8/00 2200 -3000
15/8/00 -3200
16/8/00 2200 -2800
17/8/00 5400 -2200
18/8/00 5000 -3000
21/8/00 -2800
22/8/00 3600 -2400
23/8/00 4400 -2600
24/8/00 -2200
25/8/00 5400 -3400
28/8/00 2 -3000
29/8/00 6000 -3000
30/8/00 13000 -2400
31/8/00 -3000
1/9/00 -3000
4/9/00 -6200
5/9/00 2 -3600
6/9/00 -1000
9/9/00 -1200
11/9/00 6000 0
13/9/00 7800 0
14/9/00 5400 0
15/9/00 -1600
18/9/00 5000 -3000
19/9/00 5 -2600
20/9/00 -2800
21/9/00 5002 -3000
22/9/00 7 -3000
25/9/00 -3000
26/9/00 9600 -2800
27/9/00 12 -2800
28/9/00 3200 -2800
29/9/00 -3000
2/10/00 6000 -2200
3/10/00 -2525
4/10/00 -3939
5/10/00 -3182
6/10/00 13803 -2600
7/10/00 -3000
9/10/00 10000 -3000
10/10/00 -3000
11/10/00 -3000
16/10/00 -3194
17/10/00 6 -3000
18/10/00 -3000
19/10/00 8 -3000
20/10/00 -1800
24/10/00 9300 -4200
25/10/00 16203 -3000
26/10/00 -3000
27/10/00 -3200
30/10/00 -3200
31/10/00 -3000
1/11/00 10000 -2600
3/11/00 -3000
4/11/00 6000 0
6/11/00 7000 -3000
7/11/00 -3400
8/11/00 -3200
9/11/00 9000 -3200
10/11/00 1 -2600
11/11/00 2000 -3000
13/11/00 -3460
14/11/00 2 -2000
16/11/00 -3400
17/11/00 6400 -3240
20/11/00 -3000
21/11/00 3800 -3200
22/11/00 5400 -3000
23/11/00 8600 -3000
24/11/00 -2800
25/11/00 1 -3260
27/11/00 5000 -3000
28/11/00 -3340
29/11/00 -3400
30/11/00 -2200
1/12/00 -2800
2/12/00 11000 -3000
4/12/00 -1800
5/12/00 3800 -3400
6/12/00 1800 -3600
7/12/00 6400 -2800
11/12/00 5800 -3200
12/12/00 -5000
13/12/00 9000 -3000
14/12/00 -2800
15/12/00 7000 -3200
16/12/00 -3200
18/12/00 -2800
19/12/00 -3400
20/12/00 150 -2600
21/12/00 -950
22/12/00 6400 -3200
5/1/01 -3200
8/1/01 -3200
9/1/01 10402 -3000
10/1/01 1000 -3000
11/1/01 9400 -3200
12/1/01 19000 -3000
13/1/01 -3800
15/1/01 -3400
16/1/01 -3404
17/1/01 -4000
18/1/01 9400 -3600
19/1/01 9000 -3396
22/1/01 -3200
23/1/01 9000 -3400
24/1/01 2 -3400
25/1/01 -3600
26/1/01 -3200
27/1/01 -3400
29/1/01 9000 -4000
30/1/01 4 -3600
31/1/01 7400 -3000
1/2/01 5 -4000
2/2/01 -2400
3/2/01 5 -400
5/2/01 10400 -3400
6/2/01 -3600
7/2/01 10400 -3800
8/2/01 -3200
9/2/01 -3400
10/2/01 -3600
12/2/01 -3400
13/2/01 10402 -3800
14/2/01 -3200
15/2/01 -4200
16/2/01 -3400
19/2/01 -1200
20/2/01 -5400
21/2/01 3000 -3400
22/2/01 -3800
23/2/01 17402 -4000
24/2/01 -400
28/2/01 10400 0
1/3/01 3400 -3400
2/3/01 -3000
5/3/01 -3400
6/3/01 -3000
7/3/01 10400 -3600
8/3/01 10003 -3600
9/3/01 -3400
10/3/01 10400 -3000
12/3/01 -3600
13/3/01 -3800
14/3/01 -3200
15/3/01 2 -3800
16/3/01 15000 -3200
19/3/01 -3200
20/3/01 8000 -3000
21/3/01 -3400
22/3/01 4 -3000
23/3/01 6808068 -6803200
24/3/01 4 -3400
26/3/01 -3200
27/3/01 11600 -3400
28/3/01 30 -3400
29/3/01 -4000
30/3/01 2 -2800
31/3/01 -200
2/4/01 -3400
3/4/01 6008 -3200
4/4/01 -3000
5/4/01 4 -3400
6/4/01 17000 -3400
7/4/01 7 -1800
9/4/01 -3600
10/4/01 4200 -3400
11/4/01 -3800
12/4/01 -3200
14/4/01 3 0
16/4/01 -2600
17/4/01 9400 -3400
18/4/01 15600 -3400
19/4/01 -4400
20/4/01 6803 -3400
23/4/01 -3400
24/4/01 9000 -3400
25/4/01 -2800
26/4/01 -3400
27/4/01 -2800
28/4/01 9000 -3000
30/4/01 3 -3400
2/5/01 6600 -3400
3/5/01 -2400
4/5/01 -3400
7/5/01 -3400
8/5/01 16400 -3800
9/5/01 -3400
10/5/01 -3400
11/5/01 -3400
14/5/01 -3400
15/5/01 -3600
16/5/01 6600 -3600
17/5/01 -3200
18/5/01 -3400
21/5/01 -2800
22/5/01 -4200
23/5/01 26600 -2200
24/5/01 -3400
25/5/01 -4350
26/5/01 633 0
28/5/01 10238 -3400
29/5/01 52 -4468
30/5/01 -3400
31/5/01 -5655
1/6/01 2600 -3600
4/6/01 -3262
5/6/01 -3600
6/6/01 12900 -3600
7/6/01 -3400
8/6/01 -2800
9/6/01 8000 -3400
12/6/01 -3050
13/6/01 -3600
14/6/01 5750 0
15/6/01 -4800
18/6/01 3113 -3113
19/6/01 222 -4000
20/6/01 1930 -4459
21/6/01 -2835
22/6/01 25000 -4700
23/6/01 -1296
25/6/01 4460 -6203
26/6/01 -4497
27/6/01 -3951
28/6/01 12113 -855
29/6/01 -2927
2/7/01 -3320
3/7/01 6000 -2972
4/7/01 -3613
5/7/01 -9261
6/7/01 1000 -2800
7/7/01 3030 0
9/7/01 -2896
10/7/01 -2434
11/7/01 -2846
12/7/01 4200 -2800
13/7/01 -2989
14/7/01 -2749
16/7/01 -2350
17/7/01 6200 -3000
18/7/01 -2964
19/7/01 11000 -2600
20/7/01 -3305
21/7/01 -2561
23/7/01 7000 -2200
24/7/01 -2965
25/7/01 3000 -3151
37098 14000 -3867
37099 3000 -873

Sheet 4: Series

Saldo Inicial: 20400
Data Entrada Saída Saldo
-30 7/1/2000 0 0 20400 PROCV($A3;Limpeza!$A$2:$C$277;2;FALSO) PROCV($A3;Limpeza!$A$2:$C$277;3;FALSO)
-29 7/2/2000 0 0 20400
-28 7/3/2000 0 -2800 17600
-27 7/4/2000 5400 -3000 20000
-26 7/5/2000 7000 -3000 24000
-25 7/6/2000 0 -3200 20800
-24 7/7/2000 1600 -3000 19400
-23 7/8/2000 0 0 19400
-22 7/9/2000 0 0 19400
-21 7/10/2000 0 -3000 16400
-20 7/11/2000 3000 -2600 16800
-19 7/12/2000 6000 -3000 19800
-18 7/13/2000 0 -3000 16800
-17 7/14/2000 3100 -2800 17100
-16 7/15/2000 0 0 17100
-15 7/16/2000 0 0 17100
-14 7/17/2000 4600 -3100 18600
-13 7/18/2000 0 -2800 15800
-12 7/19/2000 12000 -3000 24800
-11 7/20/2000 0 -3200 21600
-10 7/21/2000 0 -3200 18400
-9 7/22/2000 0 0 18400
-8 7/23/2000 0 0 18400
-7 7/24/2000 0 -3200 15200
-6 7/25/2000 6000 -3200 18000
-5 7/26/2000 0 -2800 15200
-4 7/27/2000 3200 -5400 13000
-3 7/28/2000 0 0 13000
-2 7/29/2000 0 -1400 11600
-1 7/30/2000 0 0 11600
0 7/31/2000 12800 -5000 19400
1 8/1/2000 0 -2800 16600
2 8/2/2000 0 -2600 14000
3 8/3/2000 8800 -5000 17800
4 8/4/2000 0 0 17800
5 8/5/2000 0 -3200 14600
6 8/6/2000 0 0 14600
7 8/7/2000 4600 -2800 16400
8 8/8/2000 4600 -2800 18200
9 8/9/2000 0 -3000 15200
10 8/10/2000 6000 -3000 18200
11 8/11/2000 0 -3000 15200
12 8/12/2000 0 0 15200
13 8/13/2000 0 0 15200
14 8/14/2000 2200 -3000 14400
15 8/15/2000 0 -3200 11200
16 8/16/2000 2200 -2800 10600
17 8/17/2000 5400 -2200 13800
18 8/18/2000 5000 -3000 15800
19 8/19/2000 0 0 15800
20 8/20/2000 0 0 15800
21 8/21/2000 0 -2800 13000
22 8/22/2000 3600 -2400 14200
23 8/23/2000 4400 -2600 16000
24 8/24/2000 0 -2200 13800
25 8/25/2000 5400 -3400 15800
26 8/26/2000 0 0 15800
27 8/27/2000 0 0 15800
28 8/28/2000 2 -3000 12802
29 8/29/2000 6000 -3000 15802
30 8/30/2000 13000 -2400 26402
31 8/31/2000 0 -3000 23402
32 9/1/2000 0 -3000 20402
33 9/2/2000 0 0 20402
34 9/3/2000 0 0 20402
35 9/4/2000 0 -6200 14202
36 9/5/2000 2 -3600 10604
37 9/6/2000 0 -1000 9604
38 9/7/2000 0 0 9604
39 9/8/2000 0 0 9604
40 9/9/2000 0 -1200 8404
41 9/10/2000 0 0 8404
42 9/11/2000 6000 0 14404
43 9/12/2000 0 0 14404
44 9/13/2000 7800 0 22204
45 9/14/2000 5400 0 27604
46 9/15/2000 0 -1600 26004
47 9/16/2000 0 0 26004
48 9/17/2000 0 0 26004
49 9/18/2000 5000 -3000 28004
50 9/19/2000 5 -2600 25409
51 9/20/2000 0 -2800 22609
52 9/21/2000 5002 -3000 24611
53 9/22/2000 7 -3000 21618
54 9/23/2000 0 0 21618
55 9/24/2000 0 0 21618
56 9/25/2000 0 -3000 18618
57 9/26/2000 9600 -2800 25418
58 9/27/2000 12 -2800 22630
59 9/28/2000 3200 -2800 23030
60 9/29/2000 0 -3000 20030
61 9/30/2000 0 0 20030
62 10/1/2000 0 0 20030
63 10/2/2000 6000 -2200 23830
64 10/3/2000 0 -2525 21305
65 10/4/2000 0 -3939 17366
66 10/5/2000 0 -3182 14184
67 10/6/2000 13803 -2600 25387
68 10/7/2000 0 -3000 22387
69 10/8/2000 0 0 22387
70 10/9/2000 10000 -3000 29387
71 10/10/2000 0 -3000 26387
72 10/11/2000 0 -3000 23387
73 10/12/2000 0 0 23387
74 10/13/2000 0 0 23387
75 10/14/2000 0 0 23387
76 10/15/2000 0 0 23387
77 10/16/2000 0 -3194 20193
78 10/17/2000 6 -3000 17199
79 10/18/2000 0 -3000 14199
80 10/19/2000 8 -3000 11207
81 10/20/2000 0 -1800 9407
82 10/21/2000 0 0 9407
83 10/22/2000 0 0 9407
84 10/23/2000 0 0 9407
85 10/24/2000 9300 -4200 14507
86 10/25/2000 16203 -3000 27710
87 10/26/2000 0 -3000 24710
88 10/27/2000 0 -3200 21510
89 10/28/2000 0 0 21510
90 10/29/2000 0 0 21510
91 10/30/2000 0 -3200 18310
92 10/31/2000 0 -3000 15310
93 11/1/2000 10000 -2600 22710
94 11/2/2000 0 0 22710
95 11/3/2000 0 -3000 19710
96 11/4/2000 6000 0 25710
97 11/5/2000 0 0 25710
98 11/6/2000 7000 -3000 29710
99 11/7/2000 0 -3400 26310
100 11/8/2000 0 -3200 23110
101 11/9/2000 9000 -3200 28910
102 11/10/2000 1 -2600 26311
103 11/11/2000 2000 -3000 25311
104 11/12/2000 0 0 25311
105 11/13/2000 0 -3460 21851
106 11/14/2000 2 -2000 19853
107 11/15/2000 0 0 19853
108 11/16/2000 0 -3400 16453
109 11/17/2000 6400 -3240 19613
110 11/18/2000 0 0 19613
111 11/19/2000 0 0 19613
112 11/20/2000 0 -3000 16613
113 11/21/2000 3800 -3200 17213
114 11/22/2000 5400 -3000 19613
115 11/23/2000 8600 -3000 25213
116 11/24/2000 0 -2800 22413
117 11/25/2000 1 -3260 19154
118 11/26/2000 0 0 19154
119 11/27/2000 5000 -3000 21154
120 11/28/2000 0 -3340 17814
121 11/29/2000 0 -3400 14414
122 11/30/2000 0 -2200 12214
123 12/1/2000 0 -2800 9414
124 12/2/2000 11000 -3000 17414
125 12/3/2000 0 0 17414
126 12/4/2000 0 -1800 15614
127 12/5/2000 3800 -3400 16014
128 12/6/2000 1800 -3600 14214
129 12/7/2000 6400 -2800 17814
130 12/8/2000 0 0 17814
131 12/9/2000 0 0 17814
132 12/10/2000 0 0 17814
133 12/11/2000 5800 -3200 20414
134 12/12/2000 0 -5000 15414
135 12/13/2000 9000 -3000 21414
136 12/14/2000 0 -2800 18614
137 12/15/2000 7000 -3200 22414
138 12/16/2000 0 -3200 19214
139 12/17/2000 0 0 19214
140 12/18/2000 0 -2800 16414
141 12/19/2000 0 -3400 13014
142 12/20/2000 150 -2600 10564
143 12/21/2000 0 -950 9614
144 12/22/2000 6400 -3200 12814
145 12/23/2000 0 0 12814
146 12/24/2000 0 0 12814
147 12/25/2000 0 0 12814
148 12/26/2000 0 0 12814
149 12/27/2000 0 0 12814
150 12/28/2000 0 0 12814
151 12/29/2000 0 0 12814
152 12/30/2000 0 0 12814
153 12/31/2000 0 0 12814
154 1/1/2001 0 0 12814
155 1/2/2001 0 0 12814
156 1/3/2001 0 0 12814
157 1/4/2001 0 0 12814
158 1/5/2001 0 -3200 9614
159 1/6/2001 0 0 9614
160 1/7/2001 0 0 9614
161 1/8/2001 0 -3200 6414
162 1/9/2001 10402 -3000 13816
163 1/10/2001 1000 -3000 11816
164 1/11/2001 9400 -3200 18016
165 1/12/2001 19000 -3000 34016
166 1/13/2001 0 -3800 30216
167 1/14/2001 0 0 30216
168 1/15/2001 0 -3400 26816
169 1/16/2001 0 -3404 23412
170 1/17/2001 0 -4000 19412
171 1/18/2001 9400 -3600 25212
172 1/19/2001 9000 -3396 30816
173 1/20/2001 0 0 30816
174 1/21/2001 0 0 30816
175 1/22/2001 0 -3200 27616
176 1/23/2001 9000 -3400 33216
177 1/24/2001 2 -3400 29818
178 1/25/2001 0 -3600 26218
179 1/26/2001 0 -3200 23018
180 1/27/2001 0 -3400 19618
181 1/28/2001 0 0 19618
182 1/29/2001 9000 -4000 24618
183 1/30/2001 4 -3600 21022
184 1/31/2001 7400 -3000 25422
185 2/1/2001 5 -4000 21427
186 2/2/2001 0 -2400 19027
187 2/3/2001 5 -400 18632
188 2/4/2001 0 0 18632
189 2/5/2001 10400 -3400 25632
190 2/6/2001 0 -3600 22032
191 2/7/2001 10400 -3800 28632
192 2/8/2001 0 -3200 25432
193 2/9/2001 0 -3400 22032
194 2/10/2001 0 -3600 18432
195 2/11/2001 0 0 18432
196 2/12/2001 0 -3400 15032
197 2/13/2001 10402 -3800 21634
198 2/14/2001 0 -3200 18434
199 2/15/2001 0 -4200 14234
200 2/16/2001 0 -3400 10834
201 2/17/2001 0 0 10834
202 2/18/2001 0 0 10834
203 2/19/2001 0 -1200 9634
204 2/20/2001 0 -5400 4234
205 2/21/2001 3000 -3400 3834
206 2/22/2001 0 -3800 34
207 2/23/2001 17402 -4000 13436
208 2/24/2001 0 -400 13036
209 2/25/2001 0 0 13036
210 2/26/2001 0 0 13036
211 2/27/2001 0 0 13036
212 2/28/2001 10400 0 23436
213 3/1/2001 3400 -3400 23436
214 3/2/2001 0 -3000 20436
215 3/3/2001 0 0 20436
216 3/4/2001 0 0 20436
217 3/5/2001 0 -3400 17036
218 3/6/2001 0 -3000 14036
219 3/7/2001 10400 -3600 20836
220 3/8/2001 10003 -3600 27239
221 3/9/2001 0 -3400 23839
222 3/10/2001 10400 -3000 31239
223 3/11/2001 0 0 31239
224 3/12/2001 0 -3600 27639
225 3/13/2001 0 -3800 23839
226 3/14/2001 0 -3200 20639
227 3/15/2001 2 -3800 16841
228 3/16/2001 15000 -3200 28641
229 3/17/2001 0 0 28641
230 3/18/2001 0 0 28641
231 3/19/2001 0 -3200 25441
232 3/20/2001 8000 -3000 30441
233 3/21/2001 0 -3400 27041
234 3/22/2001 4 -3000 24045
235 3/23/2001 4868 0 28913
236 3/24/2001 4 -3400 25517
237 3/25/2001 0 0 25517
238 3/26/2001 0 -3200 22317
239 3/27/2001 11600 -3400 30517
240 3/28/2001 30 -3400 27147
241 3/29/2001 0 -4000 23147
242 3/30/2001 2 -2800 20349
243 3/31/2001 0 -200 20149
244 4/1/2001 0 0 20149
245 4/2/2001 0 -3400 16749
246 4/3/2001 6008 -3200 19557
247 4/4/2001 0 -3000 16557
248 4/5/2001 4 -3400 13161
249 4/6/2001 17000 -3400 26761
250 4/7/2001 7 -1800 24968
251 4/8/2001 0 0 24968
252 4/9/2001 0 -3600 21368
253 4/10/2001 4200 -3400 22168
254 4/11/2001 0 -3800 18368
255 4/12/2001 0 -3200 15168
256 4/13/2001 0 0 15168
257 4/14/2001 3 0 15171
258 4/15/2001 0 0 15171
259 4/16/2001 0 -2600 12571
260 4/17/2001 9400 -3400 18571
261 4/18/2001 15600 -3400 30771
262 4/19/2001 0 -4400 26371
263 4/20/2001 6803 -3400 29774
264 4/21/2001 0 0 29774
265 4/22/2001 0 0 29774
266 4/23/2001 0 -3400 26374
267 4/24/2001 9000 -3400 31974
268 4/25/2001 0 -2800 29174
269 4/26/2001 0 -3400 25774
270 4/27/2001 0 -2800 22974
271 4/28/2001 9000 -3000 28974
272 4/29/2001 0 0 28974
273 4/30/2001 3 -3400 25577
274 5/1/2001 0 0 25577
275 5/2/2001 6600 -3400 28777
276 5/3/2001 0 -2400 26377
277 5/4/2001 0 -3400 22977
278 5/5/2001 0 0 22977
279 5/6/2001 0 0 22977
280 5/7/2001 0 -3400 19577
281 5/8/2001 16400 -3800 32177
282 5/9/2001 0 -3400 28777
283 5/10/2001 0 -3400 25377
284 5/11/2001 0 -3400 21977
285 5/12/2001 0 0 21977
286 5/13/2001 0 0 21977
287 5/14/2001 0 -3400 18577
288 5/15/2001 0 -3600 14977
289 5/16/2001 6600 -3600 17977
290 5/17/2001 0 -3200 14777
291 5/18/2001 0 -3400 11377
292 5/19/2001 0 0 11377
293 5/20/2001 0 0 11377
294 5/21/2001 0 -2800 8577
295 5/22/2001 0 -4200 4377
296 5/23/2001 26600 -2200 28777
297 5/24/2001 0 -3400 25377
298 5/25/2001 0 -4350 21027
299 5/26/2001 633 0 21660
300 5/27/2001 0 0 21660
301 5/28/2001 10238 -3400 28498
302 5/29/2001 52 -4468 24082
303 5/30/2001 0 -3400 20682
304 5/31/2001 0 -5655 15027
305 6/1/2001 2600 -3600 14027
306 6/2/2001 0 0 14027
307 6/3/2001 0 0 14027
308 6/4/2001 0 -3262 10765
309 6/5/2001 0 -3600 7165
310 6/6/2001 12900 -3600 16465
311 6/7/2001 0 -3400 13065
312 6/8/2001 0 -2800 10265
313 6/9/2001 8000 -3400 14865
314 6/10/2001 0 0 14865
315 6/11/2001 0 0 14865
316 6/12/2001 0 -3050 11815
317 6/13/2001 0 -3600 8215
318 6/14/2001 5750 0 13965
319 6/15/2001 0 -4800 9165
320 6/16/2001 0 0 9165
321 6/17/2001 0 0 9165
322 6/18/2001 3113 -3113 9165
323 6/19/2001 222 -4000 5387
324 6/20/2001 1930 -4459 2858
325 6/21/2001 0 -2835 23
326 6/22/2001 25000 -4700 20323
327 6/23/2001 0 -1296 19027
328 6/24/2001 0 0 19027
329 6/25/2001 4460 -6203 17284
330 6/26/2001 0 -4497 12787
331 6/27/2001 0 -3951 8836
332 6/28/2001 12113 -855 20094
333 6/29/2001 0 -2927 17167
334 6/30/2001 0 0 17167
335 7/1/2001 0 0 17167
336 7/2/2001 0 -3320 13847
337 7/3/2001 6000 -2972 16875
338 7/4/2001 0 -3613 13262
339 7/5/2001 0 -9261 4001
340 7/6/2001 1000 -2800 2201
341 7/7/2001 3030 0 5231
342 7/8/2001 0 0 5231
343 7/9/2001 0 -2896 2335
344 7/10/2001 0 -2434 -99
345 7/11/2001 0 -2846 -2945
346 7/12/2001 4200 -2800 -1545
347 7/13/2001 0 -2989 -4534
348 7/14/2001 0 -2749 -7283
349 7/15/2001 0 0 -7283
350 7/16/2001 0 -2350 -9633
351 7/17/2001 6200 -3000 -6433
352 7/18/2001 0 -2964 -9397
353 7/19/2001 11000 -2600 -997
354 7/20/2001 0 -3305 -4302
355 7/21/2001 0 -2561 -6863
356 7/22/2001 0 0 -6863
357 7/23/2001 7000 -2200 -2063
358 7/24/2001 0 -2965 -5028
359 7/25/2001 3000 -3151 -5179
360 7/26/2001 14000 -3867 4954
361 7/27/2001 3000 -873 7081
362 7/28/2001 0 0 7081
363 7/29/2001 0 0 7081
364 7/30/2001 0 0 7081
365 7/31/2001 0 0 7081

Sheet 5: Dimensionamento

Planilha para Dimensionamento de Estoque
Primeira etapa - Dimensionamento dos parâmentros
1) CARACTERIZAÇÃO DO ITEM
Código da SKU: demo
Descrição (nome do item): Gancho
Classificação ABC: A
Classificação de criticidade (XYZ): Y Intercambiável
Classificação de obtenção (123): 3 Fácil
Perfil da Demanda: Repetitiva
Característica do Processo de obtenção: Aquisição de fornecedor em São Paulo
Nível de serviço atual (apurado em campo): 100%
Embalagem de manuseio: Preencher aqui com embalagem de despacho
Fornecedor(es): Incluir nome do fornecedor aqui
Confiabilidade do(s) fornecedor(es): Avaliar (Pessima; ruim, media, boa, muito boa)
Custo de compra: 4.20 [R$/unidade]
Preço de Venda: 8.35 [R$/unidade]
Margem de Contribuição: 4.15 [R$/unidade] = Informação fornecida pelo usuário
Custo do Dinheiro: 18% [%aa] = Informação processada pela planilha
2) ESTATÍSTICAS APURADAS Entrada Saída Saldo
Média: 2,140 2,174 17,538
Desvio padrão: 4,279 1,639 8,276
Coeficiente de Variação: 200% 75% 47%
Máximo: 26,600 0 34,016
Soma: 781,108 793,427 NA
Número de ocorrências: 125 250 365
Giro: 45.2 vezes/ano
Cobertura média: 8 dias
TMER: 3 dias
TMEA: 1.5 dias
Popularidade (de despacho): 250 vezes/ano
Popularidade (de entregas): 125 vezes/ano
Sincronia: 2.0 saídas/entrada
Capital de Giro investido: 73,658 [R$]
Custo do Capital de Giro: 13,258 [R$/por ano]
Saldo acima do Ponto de Pedido: 74 dias 20%
Saldo abaixo do Ponto Pedido: 270 dias 74%
Exposição à Ruptura (stock-out): 5 dias 1%
Saldo zerado: 16 dias 4%
Política para o Tamanho dos Lotes de reposição
Classe Tamanho do Lote (dias)
A 3
B 5
C 10
3) PARÂMETROS DE GESTÃO ESTATÍSTICA
Tempo de Atendimento (leadtime): 10 dias
Nível de serviço requerido: 98 %
Estoque de segurança: 3361 unidades
Estoque de segurança: 1.5 dias
Ponto de pedido automático (MPDE1): 25098 unidades
Ponto de pedido automático (MPDE2): 25699 unidades
Ponto de pedido manual (intervenção do usuário): 0 unidades
Ponto de Pedido considerado: 25699 unidades
Tamanho do Lote automático: 6521 unidades
Tamanho do Lote manual (intervenção do usuário): 7000 unidades
Tamanho do lote considerado: 7000 unidades
ALARME (disparar medida contingencial, se/quando necessario)
Critério: 2 dias
Gatilho para disparo de emergência: 4348 unidades
Séries
Saldo Inicial: 19400 Cobertura Campos Auxiliares
Data Entrada Saída Saldo Instantânea Emergência Segurança P.Pedido
1 8/1/2000 0 -2800 16600 8 4348 3361 25699
2 8/2/2000 0 -2600 14000 6 4348 3361 25699
3 8/3/2000 8800 -5000 17800 8 4348 3361 25699
4 8/4/2000 0 0 17800 8 4348 3361 25699
5 8/5/2000 0 -3200 14600 7 4348 3361 25699
6 8/6/2000 0 0 14600 7 4348 3361 25699
7 8/7/2000 4600 -2800 16400 8 4348 3361 25699
8 8/8/2000 4600 -2800 18200 8 4348 3361 25699
9 8/9/2000 0 -3000 15200 7 4348 3361 25699
10 8/10/2000 6000 -3000 18200 8 4348 3361 25699
11 8/11/2000 0 -3000 15200 7 4348 3361 25699
12 8/12/2000 0 0 15200 7 4348 3361 25699
13 8/13/2000 0 0 15200 7 4348 3361 25699
14 8/14/2000 2200 -3000 14400 7 4348 3361 25699
15 8/15/2000 0 -3200 11200 5 4348 3361 25699
16 8/16/2000 2200 -2800 10600 5 4348 3361 25699
17 8/17/2000 5400 -2200 13800 6 4348 3361 25699
18 8/18/2000 5000 -3000 15800 7 4348 3361 25699
19 8/19/2000 0 0 15800 7 4348 3361 25699
20 8/20/2000 0 0 15800 7 4348 3361 25699
21 8/21/2000 0 -2800 13000 6 4348 3361 25699
22 8/22/2000 3600 -2400 14200 7 4348 3361 25699
23 8/23/2000 4400 -2600 16000 7 4348 3361 25699
24 8/24/2000 0 -2200 13800 6 4348 3361 25699
25 8/25/2000 5400 -3400 15800 7 4348 3361 25699
26 8/26/2000 0 0 15800 7 4348 3361 25699
27 8/27/2000 0 0 15800 7 4348 3361 25699
28 8/28/2000 2 -3000 12802 6 4348 3361 25699
29 8/29/2000 6000 -3000 15802 7 4348 3361 25699
30 8/30/2000 13000 -2400 26402 12 4348 3361 25699
31 8/31/2000 0 -3000 23402 11 4348 3361 25699
32 9/1/2000 0 -3000 20402 9 4348 3361 25699
33 9/2/2000 0 0 20402 9 4348 3361 25699
34 9/3/2000 0 0 20402 9 4348 3361 25699
35 9/4/2000 0 -6200 14202 7 4348 3361 25699
36 9/5/2000 2 -3600 10604 5 4348 3361 25699
37 9/6/2000 0 -1000 9604 4 4348 3361 25699
38 9/7/2000 0 0 9604 4 4348 3361 25699
39 9/8/2000 0 0 9604 4 4348 3361 25699
40 9/9/2000 0 -1200 8404 4 4348 3361 25699
41 9/10/2000 0 0 8404 4 4348 3361 25699
42 9/11/2000 6000 0 14404 7 4348 3361 25699
43 9/12/2000 0 0 14404 7 4348 3361 25699
44 9/13/2000 7800 0 22204 10 4348 3361 25699
45 9/14/2000 5400 0 27604 13 4348 3361 25699
46 9/15/2000 0 -1600 26004 12 4348 3361 25699
47 9/16/2000 0 0 26004 12 4348 3361 25699
48 9/17/2000 0 0 26004 12 4348 3361 25699
49 9/18/2000 5000 -3000 28004 13 4348 3361 25699
50 9/19/2000 5 -2600 25409 12 4348 3361 25699
51 9/20/2000 0 -2800 22609 10 4348 3361 25699
52 9/21/2000 5002 -3000 24611 11 4348 3361 25699
53 9/22/2000 7 -3000 21618 10 4348 3361 25699
54 9/23/2000 0 0 21618 10 4348 3361 25699
55 9/24/2000 0 0 21618 10 4348 3361 25699
56 9/25/2000 0 -3000 18618 9 4348 3361 25699
57 9/26/2000 9600 -2800 25418 12 4348 3361 25699
58 9/27/2000 12 -2800 22630 10 4348 3361 25699
59 9/28/2000 3200 -2800 23030 11 4348 3361 25699
60 9/29/2000 0 -3000 20030 9 4348 3361 25699
61 9/30/2000 0 0 20030 9 4348 3361 25699
62 10/1/2000 0 0 20030 9 4348 3361 25699
63 10/2/2000 6000 -2200 23830 11 4348 3361 25699
64 10/3/2000 0 -2525 21305 10 4348 3361 25699
65 10/4/2000 0 -3939 17366 8 4348 3361 25699
66 10/5/2000 0 -3182 14184 7 4348 3361 25699
67 10/6/2000 13803 -2600 25387 12 4348 3361 25699
68 10/7/2000 0 -3000 22387 10 4348 3361 25699
69 10/8/2000 0 0 22387 10 4348 3361 25699
70 10/9/2000 10000 -3000 29387 14 4348 3361 25699
71 10/10/2000 0 -3000 26387 12 4348 3361 25699
72 10/11/2000 0 -3000 23387 11 4348 3361 25699
73 10/12/2000 0 0 23387 11 4348 3361 25699
74 10/13/2000 0 0 23387 11 4348 3361 25699
75 10/14/2000 0 0 23387 11 4348 3361 25699
76 10/15/2000 0 0 23387 11 4348 3361 25699
77 10/16/2000 0 -3194 20193 9 4348 3361 25699
78 10/17/2000 6 -3000 17199 8 4348 3361 25699
79 10/18/2000 0 -3000 14199 7 4348 3361 25699
80 10/19/2000 8 -3000 11207 5 4348 3361 25699
81 10/20/2000 0 -1800 9407 4 4348 3361 25699
82 10/21/2000 0 0 9407 4 4348 3361 25699
83 10/22/2000 0 0 9407 4 4348 3361 25699
84 10/23/2000 0 0 9407 4 4348 3361 25699
85 10/24/2000 9300 -4200 14507 7 4348 3361 25699
86 10/25/2000 16203 -3000 27710 13 4348 3361 25699
87 10/26/2000 0 -3000 24710 11 4348 3361 25699
88 10/27/2000 0 -3200 21510 10 4348 3361 25699
89 10/28/2000 0 0 21510 10 4348 3361 25699
90 10/29/2000 0 0 21510 10 4348 3361 25699
91 10/30/2000 0 -3200 18310 8 4348 3361 25699
92 10/31/2000 0 -3000 15310 7 4348 3361 25699
93 11/1/2000 10000 -2600 22710 10 4348 3361 25699
94 11/2/2000 0 0 22710 10 4348 3361 25699
95 11/3/2000 0 -3000 19710 9 4348 3361 25699
96 11/4/2000 6000 0 25710 12 4348 3361 25699
97 11/5/2000 0 0 25710 12 4348 3361 25699
98 11/6/2000 7000 -3000 29710 14 4348 3361 25699
99 11/7/2000 0 -3400 26310 12 4348 3361 25699
100 11/8/2000 0 -3200 23110 11 4348 3361 25699
101 11/9/2000 9000 -3200 28910 13 4348 3361 25699
102 11/10/2000 1 -2600 26311 12 4348 3361 25699
103 11/11/2000 2000 -3000 25311 12 4348 3361 25699
104 11/12/2000 0 0 25311 12 4348 3361 25699
105 11/13/2000 0 -3460 21851 10 4348 3361 25699
106 11/14/2000 2 -2000 19853 9 4348 3361 25699
107 11/15/2000 0 0 19853 9 4348 3361 25699
108 11/16/2000 0 -3400 16453 8 4348 3361 25699
109 11/17/2000 6400 -3240 19613 9 4348 3361 25699
110 11/18/2000 0 0 19613 9 4348 3361 25699
111 11/19/2000 0 0 19613 9 4348 3361 25699
112 11/20/2000 0 -3000 16613 8 4348 3361 25699
113 11/21/2000 3800 -3200 17213 8 4348 3361 25699
114 11/22/2000 5400 -3000 19613 9 4348 3361 25699
115 11/23/2000 8600 -3000 25213 12 4348 3361 25699
116 11/24/2000 0 -2800 22413 10 4348 3361 25699
117 11/25/2000 1 -3260 19154 9 4348 3361 25699
118 11/26/2000 0 0 19154 9 4348 3361 25699
119 11/27/2000 5000 -3000 21154 10 4348 3361 25699
120 11/28/2000 0 -3340 17814 8 4348 3361 25699
121 11/29/2000 0 -3400 14414 7 4348 3361 25699
122 11/30/2000 0 -2200 12214 6 4348 3361 25699
123 12/1/2000 0 -2800 9414 4 4348 3361 25699
124 12/2/2000 11000 -3000 17414 8 4348 3361 25699
125 12/3/2000 0 0 17414 8 4348 3361 25699
126 12/4/2000 0 -1800 15614 7 4348 3361 25699
127 12/5/2000 3800 -3400 16014 7 4348 3361 25699
128 12/6/2000 1800 -3600 14214 7 4348 3361 25699
129 12/7/2000 6400 -2800 17814 8 4348 3361 25699
130 12/8/2000 0 0 17814 8 4348 3361 25699
131 12/9/2000 0 0 17814 8 4348 3361 25699
132 12/10/2000 0 0 17814 8 4348 3361 25699
133 12/11/2000 5800 -3200 20414 9 4348 3361 25699
134 12/12/2000 0 -5000 15414 7 4348 3361 25699
135 12/13/2000 9000 -3000 21414 10 4348 3361 25699
136 12/14/2000 0 -2800 18614 9 4348 3361 25699
137 12/15/2000 7000 -3200 22414 10 4348 3361 25699
138 12/16/2000 0 -3200 19214 9 4348 3361 25699
139 12/17/2000 0 0 19214 9 4348 3361 25699
140 12/18/2000 0 -2800 16414 8 4348 3361 25699
141 12/19/2000 0 -3400 13014 6 4348 3361 25699
142 12/20/2000 150 -2600 10564 5 4348 3361 25699
143 12/21/2000 0 -950 9614 4 4348 3361 25699
144 12/22/2000 6400 -3200 12814 6 4348 3361 25699
145 12/23/2000 0 0 12814 6 4348 3361 25699
146 12/24/2000 0 0 12814 6 4348 3361 25699
147 12/25/2000 0 0 12814 6 4348 3361 25699
148 12/26/2000 0 0 12814 6 4348 3361 25699
149 12/27/2000 0 0 12814 6 4348 3361 25699
150 12/28/2000 0 0 12814 6 4348 3361 25699
151 12/29/2000 0 0 12814 6 4348 3361 25699
152 12/30/2000 0 0 12814 6 4348 3361 25699
153 12/31/2000 0 0 12814 6 4348 3361 25699
154 1/1/2001 0 0 12814 6 4348 3361 25699
155 1/2/2001 0 0 12814 6 4348 3361 25699
156 1/3/2001 0 0 12814 6 4348 3361 25699
157 1/4/2001 0 0 12814 6 4348 3361 25699
158 1/5/2001 0 -3200 9614 4 4348 3361 25699
159 1/6/2001 0 0 9614 4 4348 3361 25699
160 1/7/2001 0 0 9614 4 4348 3361 25699
161 1/8/2001 0 -3200 6414 3 4348 3361 25699
162 1/9/2001 10402 -3000 13816 6 4348 3361 25699
163 1/10/2001 1000 -3000 11816 5 4348 3361 25699
164 1/11/2001 9400 -3200 18016 8 4348 3361 25699
165 1/12/2001 19000 -3000 34016 16 4348 3361 25699
166 1/13/2001 0 -3800 30216 14 4348 3361 25699
167 1/14/2001 0 0 30216 14 4348 3361 25699
168 1/15/2001 0 -3400 26816 12 4348 3361 25699
169 1/16/2001 0 -3404 23412 11 4348 3361 25699
170 1/17/2001 0 -4000 19412 9 4348 3361 25699
171 1/18/2001 9400 -3600 25212 12 4348 3361 25699
172 1/19/2001 9000 -3396 30816 14 4348 3361 25699
173 1/20/2001 0 0 30816 14 4348 3361 25699
174 1/21/2001 0 0 30816 14 4348 3361 25699
175 1/22/2001 0 -3200 27616 13 4348 3361 25699
176 1/23/2001 9000 -3400 33216 15 4348 3361 25699
177 1/24/2001 2 -3400 29818 14 4348 3361 25699
178 1/25/2001 0 -3600 26218 12 4348 3361 25699
179 1/26/2001 0 -3200 23018 11 4348 3361 25699
180 1/27/2001 0 -3400 19618 9 4348 3361 25699
181 1/28/2001 0 0 19618 9 4348 3361 25699
182 1/29/2001 9000 -4000 24618 11 4348 3361 25699
183 1/30/2001 4 -3600 21022 10 4348 3361 25699
184 1/31/2001 7400 -3000 25422 12 4348 3361 25699
185 2/1/2001 5 -4000 21427 10 4348 3361 25699
186 2/2/2001 0 -2400 19027 9 4348 3361 25699
187 2/3/2001 5 -400 18632 9 4348 3361 25699
188 2/4/2001 0 0 18632 9 4348 3361 25699
189 2/5/2001 10400 -3400 25632 12 4348 3361 25699
190 2/6/2001 0 -3600 22032 10 4348 3361 25699
191 2/7/2001 10400 -3800 28632 13 4348 3361 25699
192 2/8/2001 0 -3200 25432 12 4348 3361 25699
193 2/9/2001 0 -3400 22032 10 4348 3361 25699
194 2/10/2001 0 -3600 18432 8 4348 3361 25699
195 2/11/2001 0 0 18432 8 4348 3361 25699
196 2/12/2001 0 -3400 15032 7 4348 3361 25699
197 2/13/2001 10402 -3800 21634 10 4348 3361 25699
198 2/14/2001 0 -3200 18434 8 4348 3361 25699
199 2/15/2001 0 -4200 14234 7 4348 3361 25699
200 2/16/2001 0 -3400 10834 5 4348 3361 25699
201 2/17/2001 0 0 10834 5 4348 3361 25699
202 2/18/2001 0 0 10834 5 4348 3361 25699
203 2/19/2001 0 -1200 9634 4 4348 3361 25699
204 2/20/2001 0 -5400 4234 2 4348 3361 25699
205 2/21/2001 3000 -3400 3834 2 4348 3361 25699
206 2/22/2001 0 -3800 34 0 4348 3361 25699
207 2/23/2001 17402 -4000 13436 6 4348 3361 25699
208 2/24/2001 0 -400 13036 6 4348 3361 25699
209 2/25/2001 0 0 13036 6 4348 3361 25699
210 2/26/2001 0 0 13036 6 4348 3361 25699
211 2/27/2001 0 0 13036 6 4348 3361 25699
212 2/28/2001 10400 0 23436 11 4348 3361 25699
213 3/1/2001 3400 -3400 23436 11 4348 3361 25699
214 3/2/2001 0 -3000 20436 9 4348 3361 25699
215 3/3/2001 0 0 20436 9 4348 3361 25699
216 3/4/2001 0 0 20436 9 4348 3361 25699
217 3/5/2001 0 -3400 17036 8 4348 3361 25699
218 3/6/2001 0 -3000 14036 6 4348 3361 25699
219 3/7/2001 10400 -3600 20836 10 4348 3361 25699
220 3/8/2001 10003 -3600 27239 13 4348 3361 25699
221 3/9/2001 0 -3400 23839 11 4348 3361 25699
222 3/10/2001 10400 -3000 31239 14 4348 3361 25699
223 3/11/2001 0 0 31239 14 4348 3361 25699
224 3/12/2001 0 -3600 27639 13 4348 3361 25699
225 3/13/2001 0 -3800 23839 11 4348 3361 25699
226 3/14/2001 0 -3200 20639 9 4348 3361 25699
227 3/15/2001 2 -3800 16841 8 4348 3361 25699
228 3/16/2001 15000 -3200 28641 13 4348 3361 25699
229 3/17/2001 0 0 28641 13 4348 3361 25699
230 3/18/2001 0 0 28641 13 4348 3361 25699
231 3/19/2001 0 -3200 25441 12 4348 3361 25699
232 3/20/2001 8000 -3000 30441 14 4348 3361 25699
233 3/21/2001 0 -3400 27041 12 4348 3361 25699
234 3/22/2001 4 -3000 24045 11 4348 3361 25699
235 3/23/2001 4868 0 28913 13 4348 3361 25699
236 3/24/2001 4 -3400 25517 12 4348 3361 25699
237 3/25/2001 0 0 25517 12 4348 3361 25699
238 3/26/2001 0 -3200 22317 10 4348 3361 25699
239 3/27/2001 11600 -3400 30517 14 4348 3361 25699
240 3/28/2001 30 -3400 27147 12 4348 3361 25699
241 3/29/2001 0 -4000 23147 11 4348 3361 25699
242 3/30/2001 2 -2800 20349 9 4348 3361 25699
243 3/31/2001 0 -200 20149 9 4348 3361 25699
244 4/1/2001 0 0 20149 9 4348 3361 25699
245 4/2/2001 0 -3400 16749 8 4348 3361 25699
246 4/3/2001 6008 -3200 19557 9 4348 3361 25699
247 4/4/2001 0 -3000 16557 8 4348 3361 25699
248 4/5/2001 4 -3400 13161 6 4348 3361 25699
249 4/6/2001 17000 -3400 26761 12 4348 3361 25699
250 4/7/2001 7 -1800 24968 11 4348 3361 25699
251 4/8/2001 0 0 24968 11 4348 3361 25699
252 4/9/2001 0 -3600 21368 10 4348 3361 25699
253 4/10/2001 4200 -3400 22168 10 4348 3361 25699
254 4/11/2001 0 -3800 18368 8 4348 3361 25699
255 4/12/2001 0 -3200 15168 7 4348 3361 25699
256 4/13/2001 0 0 15168 7 4348 3361 25699
257 4/14/2001 3 0 15171 7 4348 3361 25699
258 4/15/2001 0 0 15171 7 4348 3361 25699
259 4/16/2001 0 -2600 12571 6 4348 3361 25699
260 4/17/2001 9400 -3400 18571 9 4348 3361 25699
261 4/18/2001 15600 -3400 30771 14 4348 3361 25699
262 4/19/2001 0 -4400 26371 12 4348 3361 25699
263 4/20/2001 6803 -3400 29774 14 4348 3361 25699
264 4/21/2001 0 0 29774 14 4348 3361 25699
265 4/22/2001 0 0 29774 14 4348 3361 25699
266 4/23/2001 0 -3400 26374 12 4348 3361 25699
267 4/24/2001 9000 -3400 31974 15 4348 3361 25699
268 4/25/2001 0 -2800 29174 13 4348 3361 25699
269 4/26/2001 0 -3400 25774 12 4348 3361 25699
270 4/27/2001 0 -2800 22974 11 4348 3361 25699
271 4/28/2001 9000 -3000 28974 13 4348 3361 25699
272 4/29/2001 0 0 28974 13 4348 3361 25699
273 4/30/2001 3 -3400 25577 12 4348 3361 25699
274 5/1/2001 0 0 25577 12 4348 3361 25699
275 5/2/2001 6600 -3400 28777 13 4348 3361 25699
276 5/3/2001 0 -2400 26377 12 4348 3361 25699
277 5/4/2001 0 -3400 22977 11 4348 3361 25699
278 5/5/2001 0 0 22977 11 4348 3361 25699
279 5/6/2001 0 0 22977 11 4348 3361 25699
280 5/7/2001 0 -3400 19577 9 4348 3361 25699
281 5/8/2001 16400 -3800 32177 15 4348 3361 25699
282 5/9/2001 0 -3400 28777 13 4348 3361 25699
283 5/10/2001 0 -3400 25377 12 4348 3361 25699
284 5/11/2001 0 -3400 21977 10 4348 3361 25699
285 5/12/2001 0 0 21977 10 4348 3361 25699
286 5/13/2001 0 0 21977 10 4348 3361 25699
287 5/14/2001 0 -3400 18577 9 4348 3361 25699
288 5/15/2001 0 -3600 14977 7 4348 3361 25699
289 5/16/2001 6600 -3600 17977 8 4348 3361 25699
290 5/17/2001 0 -3200 14777 7 4348 3361 25699
291 5/18/2001 0 -3400 11377 5 4348 3361 25699
292 5/19/2001 0 0 11377 5 4348 3361 25699
293 5/20/2001 0 0 11377 5 4348 3361 25699
294 5/21/2001 0 -2800 8577 4 4348 3361 25699
295 5/22/2001 0 -4200 4377 2 4348 3361 25699
296 5/23/2001 26600 -2200 28777 13 4348 3361 25699
297 5/24/2001 0 -3400 25377 12 4348 3361 25699
298 5/25/2001 0 -4350 21027 10 4348 3361 25699
299 5/26/2001 633 0 21660 10 4348 3361 25699
300 5/27/2001 0 0 21660 10 4348 3361 25699
301 5/28/2001 10238 -3400 28498 13 4348 3361 25699
302 5/29/2001 52 -4468 24082 11 4348 3361 25699
303 5/30/2001 0 -3400 20682 10 4348 3361 25699
304 5/31/2001 0 -5655 15027 7 4348 3361 25699
305 6/1/2001 2600 -3600 14027 6 4348 3361 25699
306 6/2/2001 0 0 14027 6 4348 3361 25699
307 6/3/2001 0 0 14027 6 4348 3361 25699
308 6/4/2001 0 -3262 10765 5 4348 3361 25699
309 6/5/2001 0 -3600 7165 3 4348 3361 25699
310 6/6/2001 12900 -3600 16465 8 4348 3361 25699
311 6/7/2001 0 -3400 13065 6 4348 3361 25699
312 6/8/2001 0 -2800 10265 5 4348 3361 25699
313 6/9/2001 8000 -3400 14865 7 4348 3361 25699
314 6/10/2001 0 0 14865 7 4348 3361 25699
315 6/11/2001 0 0 14865 7 4348 3361 25699
316 6/12/2001 0 -3050 11815 5 4348 3361 25699
317 6/13/2001 0 -3600 8215 4 4348 3361 25699
318 6/14/2001 5750 0 13965 6 4348 3361 25699
319 6/15/2001 0 -4800 9165 4 4348 3361 25699
320 6/16/2001 0 0 9165 4 4348 3361 25699
321 6/17/2001 0 0 9165 4 4348 3361 25699
322 6/18/2001 3113 -3113 9165 4 4348 3361 25699
323 6/19/2001 222 -4000 5387 2 4348 3361 25699
324 6/20/2001 1930 -4459 2858 1 4348 3361 25699
325 6/21/2001 0 -2835 23 0 4348 3361 25699
326 6/22/2001 25000 -4700 20323 9 4348 3361 25699
327 6/23/2001 0 -1296 19027 9 4348 3361 25699
328 6/24/2001 0 0 19027 9 4348 3361 25699
329 6/25/2001 4460 -6203 17284 8 4348 3361 25699
330 6/26/2001 0 -4497 12787 6 4348 3361 25699
331 6/27/2001 0 -3951 8836 4 4348 3361 25699
332 6/28/2001 12113 -855 20094 9 4348 3361 25699
333 6/29/2001 0 -2927 17167 8 4348 3361 25699
334 6/30/2001 0 0 17167 8 4348 3361 25699
335 7/1/2001 0 0 17167 8 4348 3361 25699
336 7/2/2001 0 -3320 13847 6 4348 3361 25699
337 7/3/2001 6000 -2972 16875 8 4348 3361 25699
338 7/4/2001 0 -3613 13262 6 4348 3361 25699
339 7/5/2001 0 -9261 4001 2 4348 3361 25699
340 7/6/2001 1000 -2800 2201 1 4348 3361 25699
341 7/7/2001 3030 0 5231 2 4348 3361 25699
342 7/8/2001 0 0 5231 2 4348 3361 25699
343 7/9/2001 0 -2896 2335 1 4348 3361 25699
344 7/10/2001 0 -2434 -99 0 4348 3361 25699
345 7/11/2001 0 -2846 -2945 -1 4348 3361 25699
346 7/12/2001 4200 -2800 -1545 -1 4348 3361 25699
347 7/13/2001 0 -2989 -4534 -2 4348 3361 25699
348 7/14/2001 0 -2749 -7283 -3 4348 3361 25699
349 7/15/2001 0 0 -7283 -3 4348 3361 25699
350 7/16/2001 0 -2350 -9633 -4 4348 3361 25699
351 7/17/2001 6200 -3000 -6433 -3 4348 3361 25699
352 7/18/2001 0 -2964 -9397 -4 4348 3361 25699
353 7/19/2001 11000 -2600 -997 0 4348 3361 25699
354 7/20/2001 0 -3305 -4302 -2 4348 3361 25699
355 7/21/2001 0 -2561 -6863 -3 4348 3361 25699
356 7/22/2001 0 0 -6863 -3 4348 3361 25699
357 7/23/2001 7000 -2200 -2063 -1 4348 3361 25699
358 7/24/2001 0 -2965 -5028 -2 4348 3361 25699
359 7/25/2001 3000 -3151 -5179 -2 4348 3361 25699
360 7/26/2001 14000 -3867 4954 2 4348 3361 25699
361 7/27/2001 3000 -873 7081 3 4348 3361 25699
362 7/28/2001 0 0 7081 3 4348 3361 25699
363 7/29/2001 0 0 7081 3 4348 3361 25699
364 7/30/2001 0 0 7081 3 4348 3361 25699
365 7/31/2001 0 0 7081 3 4348 3361 25699

Sheet 6: Grágico DIM


Sheet 7: Cobertura


Sheet 8: Parecer

PARECER:
Demanda: Dependente. Regularidade extraordinária. Giro muito bom.
Oferta: Existe maior irregularidade na Entrada do que na saída!
Saldo: Oscila razoável, de 16 e -4 dias, apresentando DIMENSIONAMENTO ADEQUADO.
Estratégia de Gestão: MRP, com ótimos resultados.
Estoque de segurança: Até Julho/2001 foi usado conforme esperado, uma única vez. Em Julho o saldo tornou-se negativo (crítico), expondo o atendimento à produção.
Leadtime: 10 dias… Inerrente da distância SAO/MAO.
Ponto de Pedido: Adequado.
Tamanho do lote: Adequado (Sincronia de 1 lote de abastecimento para 2 lotes de consumo).
Simulação: Não Aplicável (o item esta sendo gerido por algoritmo MRP).
Avaliação Geral: BEM DIMENSIONADO!
RECOMENDAÇÕES:
Manter parametros como estão. Verificar como registrar entradas on-line.

Sheet 9: Zonas


Sheet 10: FES

Tabela do Fator de Segurança = f(Nível de Serviço desejado)
N.S. F.E.S.
50.00 0.00
75.00 0.67
80.00 0.84
85.00 1.04
90.00 1.28
93.32 1.50
95.00 1.65
96.00 1.75
97.00 1.88
98.00 2.05
99.00 2.33
99.50 2.57
99.60 2.65
99.70 2.75
99.80 2.88
99.90 3.09
99.99 4.00
Caro usuário: Não altere o conteúdo desta planilha.

Sheet 11: Auxiliar

Planilha de Variáveis Globais
Entrada Saída Saldo
>0 <0
Caro usuário: Não altere o conteúdo desta planilha auxiliar desnecessariamente

Comentários