original sale data 2015.xlsx
TRANSCRIPT
-
7/26/2019 Original SALE DATA 2015.xlsx
1/28
July 2015 SALE SUMMERY
DATE 21 22 23 24 25 26 27
DENIM JEANS 3 2 2
COTTON JEANS 8 2 1 2 1 1
FORMAL TROUSERS 1
COTTON TROUSERS 1SHIRT 7 1 2 1 1
DENIM SHIRTS RS 300 2
T SHIRTS. 20
NIGHT PANTS RS 215 2
NIGHT PANTS RS 150 2
CAPRI PLAIN RS. 110 6
TOTAL 52 2 2 4 4 0 4
DENIM JEANS 1350 0 0 0 1000 0 800
COTTON JEANS 3600 900 450 900 500 0 400
FORMAL TROUSERS 450 0 0 0 0 0 0
COTTON TROUSERS 450 0 0 0 0 0 0
SHIRT 2800 0 450 900 450 0 450
DENIM SHIRTS RS 300 960 0 0 0 0 0 0
T SHIRTS. 5000 0 0 0 0 0 0
NIGHT PANTS RS 215 600 0 0 0 0 0 0
NIGHT PANTS RS 150 480 0 0 0 0 0 0
CAPRI PLAIN RS. 110 1140 0 0 0 0 0 0To!l 16830 900 900 1800 1950 0 1650
-
7/26/2019 Original SALE DATA 2015.xlsx
2/28
28 29 30 31 SALE TOTAL "TY #ALANCE
$ %& %2
1 1 1$ 22% 211
1 42 41
1 40 3&12 &2 %0
2 15 13
20 &' $'
2 ' 4
2 1' 14
' ' 0
1 1 0 0 $0 '30 5'0
SALE AMT ORIG. AMT AMT. #ALANCE
0 0 0 0 3150 2030 23$%0 450
500 500 0 0 $$50 45&0 5'&$0 450
0 0 0 0 450 2$0 110$0 450
0 0 0 0 450 2$0 10530 450
0 0 0 0 5050 22%0 15200 400
0 0 0 0 &'0 '00 3&00 480
0 0 0 0 5000 4'00 1$4%0 250
0 0 0 0 '00 430 %'0 300
0 0 0 0 4%0 300 2100 240
0 0 0 0 1140 ''0 0 190500 500 0 0 25030 16030 141%&0
64.04315
P(o)* &000
+(o. A,!*l!-l &000
-
7/26/2019 Original SALE DATA 2015.xlsx
3/28
25810
61560
11340
1080017480
4500
22080
1290
2400
660
15$&20
290 1120 35.55556
270 3160 40.77419
270 180 40
270 180 40
190 2770 54.85149
300 360 37.5
230 400 8
215 170 28.33333
150 180 37.5
110 480 42.10526
Cash available on hand
25030
Difference
0
invest sell proftie available
157920 25030 9000 141890
16030
-
7/26/2019 Original SALE DATA 2015.xlsx
4/28
DENIM JEANS 3
COTTON JEANS 8
FORMAL TROUSERS 1
COTTON TROUSERS 1
SHIRT 7
DENIM SHIRTS RS 300 2
T SHIRTS. 20NIGHT PANTS RS 215 2
NIGHT PANTS RS 150 2
CAPRI PLAIN RS. 110 6
-
7/26/2019 Original SALE DATA 2015.xlsx
5/28
DATE 1 2 3 4 5 6
DENIM JEANS CL!"D CL!"D CL!"D CL!"D
COTTON JEANS 1 3 #"$% &'()
FORMAL TROUSERS 1COTTON TROUSERS
1SHIRT 2DENIM SHIRTS RS 300
T SHIRTS. 1CHEC/S SHIRTS
PLAIN SHIRTS
PRINTED SHIRT
NE PRINTED SHIRT
NIGHT PANTS RS 215 1NIGHT PANTS RS 150
CAPRI PLAIN RS. 110
TOTAL $ 3 0 0 0 0
DATE 1 2 3 4 5 6
DENIM JEANS 0 0 0 0 0 0
COTTON JEANS 400 1200 0 0 0 0
FORMAL TROUSERS 400 0 0 0 0 0
COTTON TROUSERS 400 0 0 0 0 0
SHIRT 700 0 0 0 0 0
DENIM SHIRTS RS 300 0 0 0 0 0 0
T SHIRTS. 220 0 0 0 0 0CHEC/S SHIRTS 0 0 0 0 0 0
PLAIN SHIRTS 0 0 0 0 0 0
PRINTED SHIRT 0 0 0 0 0 0
NE PRINTED SHIRT 0 0 0 0 0 0
NIGHT PANTS RS 215 300 0 0 0 0 0
NIGHT PANTS RS 150 0 0 0 0 0 0
CAPRI PLAIN RS. 110 0 0 0 0 0 0
To!l 2420 1200 0 0 0 0
-
7/26/2019 Original SALE DATA 2015.xlsx
6/28
-
7/26/2019 Original SALE DATA 2015.xlsx
7/28
July 2015 SALE SUM
7 8 9 10 11 12 13 14 15 16
1 0 2
8 3 3 3 1 1 5 1 1
1 3
1 1 1 2 12
1 1 2 1
1 1
6 2 1 1 1
1 1 2
2
& ' 0 14 ' 2 3 1' 5 4
7 8 9 10 11 12 13 14 15 16
0 500 0 0 0 0 0 850 0 0
3200 1200 0 1450 1200 500 450 2100 400 500
0 0 0 450 0 0 0 1400 0 0
400 0 0 0 500 0 0 450 800 500
0 700 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 220 0 0 450 560 360 00 0 0 450 0 0 0 500 0 0
0 0 0 3000 1000 500 450 500 0 0
0 0 0 0 0 0 0 500 500 1000
0 0 0 0 0 0 0 0 0 0
0 0 0 600 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
3'00 2400 0 '1$0 2$00 1000 1350 '%'0 20'0 2000
2200
1200
500
1250
5001210
-
7/26/2019 Original SALE DATA 2015.xlsx
8/28
-
7/26/2019 Original SALE DATA 2015.xlsx
9/28
ERY
17 18 19 20 21 22 23 24 25 26
0 closed 0
3 3
11 2
1 1
4 1
1
1
2 4 3 0 4 0 1 1 0 4
17 18 19 20 21 22 23 24 25 26
0 0 0 0 0 0 0 0 0 0
0 0 1200 0 0 0 0 0 0 1500
0 0 0 0 0 0 0 0 0 0
500 0 0 0 0 0 0 0 0 0
400 0 0 0 700 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 320 360 0 00 0 0 0 0 0 0 0 0 0
0 2000 0 0 500 0 0 0 0 0
0 0 0 0 0 0 0 0 0 500
0 0 0 0 0 0 0 0 0 0
0 0 0 0 300 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
&00 2000 1200 0 1500 0 320 3'0 0 2000
-
7/26/2019 Original SALE DATA 2015.xlsx
10/28
-
7/26/2019 Original SALE DATA 2015.xlsx
11/28
27 28 29 30 31 SALE #ALANCE TOTAL "TY
1 closed 4 $% %2
1 3 40 1$1 211
5 3' 41
% 31 3&
2 & $1 %0
0 13 13
3 11 '5 $'
2 4 14 1%
3 3 22 23 45
5 13 1%
0 1% 1%
4 0 4
0 14 14
0 0 0
0 4 12 2 0 112 54$ '5&
27 28 29 30 31 SALE AMT ORIG. AMT AMT. #ALANCE
0 0 500 0 0 1%50 1160 22'20
0 500 1200 0 0 1$000 10800 4'1$0
0 0 0 0 0 2250 1350 &$20
0 0 0 0 0 3550 2160 %3$0
0 0 700 0 0 3200 1710 134&0
0 0 0 0 0 0 0 3&00
0 0 920 0 0 3410 2530 14&500 0 0 1000 0 1&50 960 33'0
0 1500 1260 0 0 10$10 5060 52&0
0 0 0 0 0 2500 1150 2&&0
0 0 0 0 0 0 0 4'%0
0 0 0 0 0 1200 860 0
0 0 0 0 0 0 0 2100
0 0 0 0 0 0 0 0
0 2000 45%0 1000 0 4$'20 27740 13$'40
*&+(, 1&%%0
*re *&+(, &000
,otal !ale privio-s C-rrent $2'50 To!l 2%%%0 P(,*ou C!
25030
SHOP RENT
SHOP MENT PAY
pre prof. 410c-rrent pro. 19880 THIS MONTH S
total 20290 4$'20
SHOP RENT 3000 To!l !,!*l!-l
-
7/26/2019 Original SALE DATA 2015.xlsx
12/28
SHOP MENT PAY 1000 '%'50
available 16290 C! R*, o 01.transfer 13000
A,!*l!-l #!l! 'vailable 55'50
(!)( 20000
!,!*l!-l 35'50
-
7/26/2019 Original SALE DATA 2015.xlsx
13/28
23780 %2
56970 211
11070 41
10530 3&
15200 %0
3900 13
17480 $'
4320 4
10350 14
4140 0
4680
860
2100
0
165380
SALE PRICE ORIG. PRICE
450 290
450 270
450 270
450 270
400 190
480 300
400 230450 240
450 230
450 230
500 260
300 215
240 150
190 110
#!l!
3000 01.07.2015 , 31.07.2015
1000 21.07.15 , 31.07.15
21030 LE
invest sell proftie available
-
7/26/2019 Original SALE DATA 2015.xlsx
14/28
165380 47620 19880 137640
27740
15000
s-ndha 22849
h-ndia 20540
parth 59340
friends 24790
shree nath 22700 receive profite
/haani tet 23400 13000
s-ndha tet 23873 20000
212492 33000
-
7/26/2019 Original SALE DATA 2015.xlsx
15/28
-
7/26/2019 Original SALE DATA 2015.xlsx
16/28
-
7/26/2019 Original SALE DATA 2015.xlsx
17/28
DATE 1 2 3 4 5 6
DENIM JEANS 2
COTTON JEANS 1 3
FORMAL TROUSERS
COTTON TROUSERS 1
SHIRT
DENIM SHIRTS RS 300 1
T SHIRTS. 1
N6 T SHIRTS 1
CHEC/S SHIRTS 1 1
PLAIN SHIRTS 1 4 1
PRINTED SHIRT
NE PRINTED SHIRT
NIGHT PANTS RS 215
NIGHT PANTS RS 150
CAPRI PLAIN RS. 110TOTAL 3 0 $ 3 5 0
DATE 1 2 3 4 5 6
DENIM JEANS 1000 0 0 0 0 0
COTTON JEANS 0 0 500 0 1200 0
FORMAL TROUSERS 0 0 0 0 0 0
COTTON TROUSERS 0 0 0 500 0 0
SHIRT 0 0 0 0 0 0
DENIM SHIRTS RS 300 0 0 550 0 0 0T SHIRTS. 0 0 350 0 0 0
NE T SHIRTS 0 0 0 350 0 0
CHEC/S SHIRTS 0 0 0 500 500 0
PLAIN SHIRTS 500 0 1900 0 500 0
PRINTED SHIRT 0 0 0 0 0 0
NE PRINTED SHIRT 0 0 0 0 0 0
NIGHT PANTS RS 215 0 0 0 0 0 0
NIGHT PANTS RS 150 0 0 0 0 0 0
CAPRI PLAIN RS. 110 0 0 0 0 0 0
To!l 1500 0 3300 1350 2200 0
-
7/26/2019 Original SALE DATA 2015.xlsx
18/28
-
7/26/2019 Original SALE DATA 2015.xlsx
19/28
July 2015 SALE SUM
7 8 9 10 11 12 13 14 15 16
2 1
1
1
1
1 1 )e 2
3 0 1 0 3 1 0 0 0 0
7 8 9 10 11 12 13 14 15 16
0 0 0 0 0 0 0 0 0 0
1000 0 0 0 0 450 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 450 0 0 0 0 00 0 0 0 350 0 0 0 0 0
0 0 0 0 400 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
450 0 420 0 0 0 0 1000 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
1450 0 420 0 1200 450 0 1000 0 0
-
7/26/2019 Original SALE DATA 2015.xlsx
20/28
-
7/26/2019 Original SALE DATA 2015.xlsx
21/28
ERY
17 18 19 20 21 22 23 24 25 26
0 0 0 0 0 0 0 0 0 0
17 18 19 20 21 22 23 24 25 26
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
-
7/26/2019 Original SALE DATA 2015.xlsx
22/28
pre. *rofit
c-r. *rofit
SHOP RENT
SHOP MEN PAY
-
7/26/2019 Original SALE DATA 2015.xlsx
23/28
27 28 29 30 31 SALE #ALANCE TOTAL "TY
2 $' $%
$ 1'4 1$1
0 3' 3'
1 30 31
0 $1 $1
2 11 13
2 '3 '5
2 113 115
2 12 14
% 15 23
0 13 13
0 1% 1%
0 0 0
0 12 12
0 0 00 0 0 0 0 2' '34 ''0
27 28 29 30 31 SALE AMT ORIG. AMT AMT. #ALANCE
0 0 0 0 0 1000 580 22040
0 0 0 0 0 3150 1890 442%0
0 0 0 0 0 0 0 &$20
0 0 0 0 0 500 270 %100
0 0 0 0 0 0 0 134&0
0 0 0 0 0 1000 600 33000 0 0 0 0 $00 460 144&0
0 0 0 0 0 $50 400 22'00
0 0 0 0 0 1000 480 2%%0
0 0 0 0 0 4$$0 1840 3450
0 0 0 0 0 0 0 2&&0
0 0 0 0 0 0 0 4'%0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 1%00
0 0 0 0 0 0 0 0
0 0 0 0 0 12%$0 6520 153%20
*&+(, '350
*&+(, 1&%%0
,otal !ale privio-s C-rrent $&000 *re *&+(, &000 P(,*ou C!
To!l 35230 $2'50
SHOP RENT
3350 500 3000 SHOP MENT PAY
3000 3000
-
7/26/2019 Original SALE DATA 2015.xlsx
24/28
13450 12850 THIS MONTH S
6350 33000 12%$0
3000 45850 To!l !,!*l!-l
3000 $&520
13800 33150 C! R*, o 01.transfer 0
A,!*l!-l #!l! 'vailable $&520
(!)( 0
!,!*l!-l $&520
-
7/26/2019 Original SALE DATA 2015.xlsx
25/28
'!#'%
')* 10 3600 2900
2 &00 9 3240 2430
2 0
1 360 270
4 1%00 2 800 460
4 8 3200 2080
2$00 11200 %140 3060
SALE PRICE ORIG. PRICE
450 290
450 270
450 270
450 270
400 190
480 300400 230
400 200
450 240
450 230
450 230
500 260
300 215
250 150
190 110
#!l!
3000 01.08.2015 , 31.08.2015
3000 01.08.2015 , 31.08.2015
66650
-
7/26/2019 Original SALE DATA 2015.xlsx
26/28
LE
-
7/26/2019 Original SALE DATA 2015.xlsx
27/28
-
7/26/2019 Original SALE DATA 2015.xlsx
28/28