This document was exported from Numbers.

Each table was converted to an Excel workshe

objects on each Numbers sheet were placed on separate worksheets. Please be aware that
calculations may differ in Excel.
Numbers Sheet Name Numbers Table Name
Prod formulas
Table 1
GRV 1 costing by me
Table 1
GRV 2 costing by me
Table 1
GRV 1 reverse costing
Table 1
GRV 2 reverse costing
Table 1
Sheet 1
Table 1
converted to an Excel worksheet. All other
rksheets. Please be aware that formula

Excel Worksheet Name

Prod formulas

GRV 1 costing by me

GRV 2 costing by me

GRV 1 reverse costing

GRV 2 reverse costing

Sheet 1
 Table 1

CARD R/F Comber 40/1 CCH 30/1 CCH R/F

Lycra
Card mtr/min 265 R/F rpm 12200 npm 400 20000 R/F rpm 11500
sliver hank 0.11 Eff % 90 fpn 5.2 3.4 Eff % 88

Mac eff % 0.94 Count 20.3 lap weight gm 75 152 gps 235 gps Count 16
Card prdct n of 8 641.9986363636 TM 4.8 mac eff % 0.92 TM 3.8
hrs

uti 97% TPI 21.6266502261 Noil 15 TPI 15.2

180.0733907354 (100-noil)/100 0.83 299.6052631579

GPS R/F prdctn of 8 hrs
uti 98% Comber prdc tn 8 416.9256 lycra uti 98%
hrs

881.6393210404 uti 93% 9 r/f

Per RF of 1632
16/1 ch 25 mtr/sec max

S/F Finisher D/F

rpm 1250 mpm 420 Hank

Count TPI
Mac eff % 82 mac eff% 80 34ch 1.29 0.9
Roving hank 0.75 Sliver hank 0.11 40ch 1.31 1.02
TPI 1.25 Prdct n/ delivery/8 865.9636363636
hrs
S/F prdctn 8 hrs 7.872 uti 88.60%

uti 81.8

Count S/F TM Hank

30CH 1.25 0.85
40CH 1.32 1.02

Ring traveller
speed calculation

Spdl speed 12800

Ring dia mm 40

RT speed 26.79

3
Table 1

4
 Table 1
20CCH 30KCW 24CCH 2/40 SIRO

Actual count 20.2 30.3 24.2 20.3

RPM 15800 20300 16300 15300
spindles 1632 1632 1632 1632
Avg RPM 15300 19800 15800 14800
Eff % 0.9 0.92 0.92 0.9
TM 3.46 4.43 3.47 4.45
TPI 15.55 24.39 17.07 20.05
prdctn 1545.27 869.08 1240.41 1153.65
1 day salary 140000 140000 140000 140000
1 day salary per R/f 8750 8750 8750 8750

wages&salary 5.6624367008 10.0681296357 7.0541023538 7.5846228564

pkng 3.5 3.5 3.5 3.5
ukg 2.6695576836 3.2810294191 2.6895838455 2.78
power cost 18.6869037852 22.9672059337 18.8270869187 19.484932342
store 1.5 1.5 1.5 1.5
bales rate 45000 45000 45000 45000
row cotton 126.40 126.40 126.40 126.40
realstn 0.7 0.7 0.7 0.7
clean cotton cost 149.8778491172 149.8778491172 149.8778491172 149.8778491172
Waste rs 21.49 21.49 21.49 21.49
yarn rate current 220 200 186 186
Other cost 2 2 2 2
yarn cost 31.349340486 40.0353355695 32.8811892725 34.07
Bank & personal cost 15.79 15.79 15.79 15.79

Total cost of yarn 197.022061398 205.7031846866 198.5490383897 199.74

Profit 22.977938602 -5.7031846866 -12.5490383897 -13.7374043156
No. Of RF 1 7 6 2 16

KG per count 1545.27 6083.55 7442.48 2307.30

Total profit 35507.15 -34695.626168412 -93395.939329368 -31696.31 -124280.7325874

Notes : 40.2 * 0.73 =

power cost per kg

30.2 * 0.70 =
power cost per kg

24.2 * 0.71 =
power cost per kg

Personal int 1300000 650000

Cc int 1900000 1000000

Loan int 5300000

Instalment 5700000

Others 1200000

15400000

Without 9700000
installm ent total

5
Table 1

6
 Table 1
16KCW 20CHY 70D 12KH 16KW 2/40 SIRO 2/36 SIRO

Actual count 16.3 20.3 12.3 16.3 20.3 18.3

RPM 14000 12200 11700 14500 14500 14200
spindles 1440 1440 1440 1440 1440 1440
Avg RPM 13500 11700 11200 14000 14000 13700
Eff % 0.89 0.9 0.87 0.87 0.9 0.9
TM 4.4 4.8 3.8 4.35 4.45 4.46
TPI 17.76 21.63 13.33 17.56 20.05 19.08
prdctn 1290.64 746.04 1848.90 1323.41 962.90 1098.42
1 day salary 140000 140000 140000 140000 140000 140000
1 day salary per R/f 8750 8750 8750 8750 8750 8750

wages&salary 6.779569508 11.7286690755 4.7325563991 6.6117311395 9.087100527 7.9659986136

pkng 3.5 3.5 3.5 3.5 3.5 3.5
ukg 2.9121350932 3.5846709167 2.2783385621 2.61 3.05 2.85
power cost 20.3849456522 25.0926964167 15.9483699348 18.278546613 21.3480046535 19.9578382808
store 1.5 1.5 1.5 1.5 1.5 1.5
bales rate 45000 45000 45000 45000 45000 45000
row cotton 126.40 126.40 126.40 126.40 126.40 126.40
realstn 0.87 0.87 0.87 0.87 0.87 0.87
clean cotton cost 140.2695337724 140.2695337724 140.2695337724 140.2695337724 140.2695337724 140.2695337724
Waste rs 4.37 4.37 4.37 4.37 4.37 4.37

yarn rate current 174 209 162 164 202 189.5

Other cost 2 2 2 2 2 2
yarn cost 34.1645151602 43.8213654922 27.6809263339 31.89 37.44 34.92

Bank & personal cost 15.79 15.79 15.79 15.79 15.79 15.79

Bank & personal cost 9.95 9.95 9.95 9.95 9.95 9.95
without installment

Total cost of yarn 190.2289207276 199.8808992646 183.7404601063 187.95 193.49 190.98

Net Profit -16.2289207276 9.1191007354 -21.7404601063 -23.949811525 8.505361047 -1.4833706669

No. Of RF 2 1 2 1 3 3

KG per count 2581.28 746.0352017483 3697.79 1323.41 2888.7102021022 3295.2554065505

Total net p rofit -20945.733530402 6803.17 -40195.828615608 -31695.31 8189.8410763275 -1629.3617366472
per RF

Total net profit -41891.467060804 6803.17 -80391.657231217 -31695.31 24569.523228982 -4888.0852099416

Notes : 40.2 * 0.73 =

power cost per kg
30.2 * 0.70 =
power cost per kg
24.2 * 0.71 =
power cost per kg

Personal int 1300000

Cc int 1900000

Loan int 5300000

Instalment 5700000

Others 1200000

15400000

Without 9700000
instalm ent total

7
 Table 1

8
Table 1

9
10
 Table 1
per rf cost with instalment 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685 62685

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

SR NO DISCRPTION COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT
20.2 24.2 24.2 24.2 24.2 24.2 24.2 30.3 30.3 30.3 30.3 30.3 30.3 30.3 20.3 20.3

CCH CCH CCH CCH CCH CCH CCH KCW KCW KCW KCW KCW KCW KCW SIRO SIRO
RF RPM 14500 16000 16000 16000 16000 16000 16000 20000 20000 20000 20000 20000 20000 20000 15300 15300

RF avg RPM 14000 15500 15500 15500 15500 15500 15500 19500 19500 19500 19500 19500 19500 19500 14800 14800
Spdl per RF 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632 1632

TM 3.46 3.47 3.47 3.47 3.47 3.47 3.47 4.43 4.43 4.43 4.43 4.43 4.43 4.43 4.45 4.45
TPI 15.55 17.07 17.07 17.07 17.07 17.07 17.07 24.39 24.39 24.39 24.39 24.39 24.39 24.39 20.05 20.05

Eff% 90 92 92 92 92 92 92 92 92 92 92 92 92 92 90 90

GPS 288.8017952622 248.5418337124 248.5418337124 248.5418337124 248.5418337124 248.5418337124 248.5418337124 174.8184503416 174.8184503416 174.8184503416 174.8184503416 174.8184503416 174.8184503416 174.8184503416 235.6311231873 235.6311231873

NO OF RF 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

1 PURCHASE PRICE OF BALE 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500 45500

2 PURCHASE PRICE IN KG 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95 127.95
3 AVERAGE PRICE OF WASTE 63.02 63.02 63.02 63.02 45.89 45.89 45.89 45.89 63.02 63.02 63.02 63.02 63.02 63.02 63.02 63.02

4 RECOVERY PERCENTAGE 0.7 0.7 0.7 0.7 0.87 0.87 0.87 0.87 0.71 0.71 0.71 0.71 0.725 0.725 0.725 0.725
5 EFFECTIVE PRICE OF WASTE 17.6456 17.6456 17.6456 17.6456 5.0479 5.0479 5.0479 5.0479 17.0154 17.0154 17.0154 17.0154 16.0701 16.0701 16.0701 16.0701

6 EFFECTIVE PURCHASE PRICE 110.3071559055 110.3071559055 110.3071559055 110.3071559055 122.9048559055 122.9048559055 122.9048559055 122.9048559055 110.9373559055 110.9373559055 110.9373559055 110.9373559055 111.8826559055 111.8826559055 111.8826559055 111.8826559055
7 NET EFFECTIVE PURCHASE PRICE 157.5816512936 157.5816512936 157.5816512936 157.5816512936 141.2699493167 141.2699493167 141.2699493167 141.2699493167 156.24979705 156.24979705 156.24979705 156.24979705 154.3209046973 154.3209046973 154.3209046973 154.3209046973

8 ACTUAL PRODUCTION IN KG/DAY(L/C) 1413.97 1216.86 1216.86 1216.86 1216.86 1216.86 1216.86 855.9111328726 855.9111328726 855.9111328726 855.9111328726 855.9111328726 855.9111328726 855.9111328726 1153.65 1153.65

9 TOTAL COST WITH INSTALMENT/KG 44.33 51.51 51.51 51.51 51.51 51.51 51.51 73.24 73.24 73.24 73.24 73.24 73.24 73.24 54.34 54.34

10 TOTAL YARN COST WITH INSTALMENT 201.9141624953 209.0953487355 209.0953487355 209.0953487355 192.7836467586 192.7836467586 192.7836467586 214.5076928072 229.4875405405 229.4875405405 229.4875405405 229.4875405405 227.5586481878 227.5586481878 208.6571428408 208.6571428408

11 SALES RATE 225 225 228 228 199 199 199 199 208.5 208.5 208.5 208.5 192 192 192 192

12 PROFIT AFTER INSTALMENT 23.0858375047 15.9046512645 18.9046512645 18.9046512645 6.2163532414 6.2163532414 6.2163532414 -15.5076928072 -20.9875405405 -20.9875405405 -20.9875405405 -20.9875405405 -35.5586481878 -35.5586481878 -16.6571428408 -16.6571428408

13 NET PROFIT PER DAY 32642.76 19353.75 23004.33 23004.33 7564.44 7564.44 7564.44 -13273.206918847 -17963.469600257 -17963.469600257 -17963.469600257 -17963.469600257 -30435.042853816 -30435.042853816 -19216.512490533 -19216.512490533

11
Table 1

12
 Table 1
per rf cost with instalment 55310 55310 55310 55310 55310 55310 55310 55310 55310 55310 55310 55310 55310 55310

Lycra rate / kg 416

Cott on net eff ec tive 145.46 NE20/1 lycra

purchase price

1 2 3 4 5 6 7 8 9 10 11 12 13 14 Lycra % Rs. Of lycra Deduc tion of cotton Extra c ost for

rs. spandex

SR NO DISCRPTION COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT 7 29.12 10.1819169156 18.9380830844

16.3 16.3 20.3 12.2 16.2 16.2 16.2 16.2 20.2 20.2 20.2 20.2 18.2 18.2 6 24.96 8.7273573562 16.2326426438

KCW KCW CHY lycra KW KCW KCW KCW KCW KW SIRO KW SIRO KW SIRO KW SIRO KW SIRO KW SIRO 5 20.8 7.2727977968 13.5272022032

RF RPM 14000 14000 12200 14000 14000 14000 14000 14000 14000 14000 14000 14000 4 16.64 5.8182382375 10.8217617625

RF avg RPM 13500 13500 11700 13500 13500 13500 13500 13500 13500 13500 13500 13500 3 12.48 4.3636786781 8.1163213219

Spdl per RF 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 2.5 10.4 3.6363988984 6.7636011016

TM 4.4 4.4 4.8 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4
TPI 17.76 17.76 21.63 15.37 17.71 17.71 17.71 17.71 19.78 19.78 19.78 19.78

Eff% 89 89 90 89 89 89 89 89 89 89 89 89
GPS 298.7598195671 298.7598195671 172.693333738 461.385401498 301.5303787841 301.5303787841 301.5303787841 301.5303787841 216.5591513792 216.5591513792 216.5591513792 216.5591513792

NO OF RF 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 PURCHASE PRICE OF BALE 45000 45000 45000 45000 45000 45000 45000 45000 45000 45000 45000 45000 45000 45000

2 PURCHASE PRICE IN KG 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55 126.55

3 AVERAGE PRICE OF WASTE 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89 45.89

4 RECOVERY PERCENTAGE 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87

5 EFFECTIVE PRICE OF WASTE 5.0479 5.0479 0 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479 5.0479

6 EFFECTIVE PURCHASE PRICE 121.4987816648 121.4987816648 126.5466816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648 121.4987816648

7 NET EFFECTIVE PURCHASE PRICE 139.6537720285 139.6537720285 145.4559559365 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285 139.6537720285

EXTRA COST FOR SPANDEX YARN 18.9380830844

8 ACTUAL PRODUCTION IN KG/DAY(L/C) 1290.64 1290.64 746.0352017483 1993.18 1302.61 1302.61 1302.61 1302.61 935.535533958 935.535533958 935.535533958 935.535533958 0 0

9 TOTAL COST WITH INSTALMENT/KG 42.85 42.85 74.14 27.75 42.46 42.46 42.46 42.46 59.12 59.12 59.12 59.12 #DIV/0! #DIV/0!

10 TOTAL YARN COST WITH INSTALMENT 182.5083993987 182.5083993987 238.5326317715 167.403329555 182.1146371406 182.1146371406 182.1146371406 182.1146371406 198.7749897614 198.7749897614 198.7749897614 198.7749897614 #DIV/0! #DIV/0!

11 SALES RATE 158 158 214 160 175 175 175 175 194 194 194 194 189 189

12 PROFIT AFTER INSTALMENT -24.5083993987 -24.5083993987 -24.5326317715 -7.403329555 -7.1146371406 -7.1146371406 -7.1146371406 -7.1146371406 -4.7749897614 -4.7749897614 -4.7749897614 -4.7749897614 #DIV/0! #DIV/0!

13 NET PROFIT PER DAY -31631.57992327 -31631.57992327 -18302.206893104 -14756.204933881 -9267.6062818327 -9267.6062818327 -9267.6062818327 -9267.6062818327 -4467.172596078 -4467.172596078 -4467.172596078 -4467.172596078 #DIV/0! #DIV/0!

13
Table 1

14
 Table 1
NO SR NO DESCRIPTION FAB-19 Mar-19 APR-MAR Apr-19 May-19

1 OPENING STOCK 15529085.00 12806925.00 13537560.00 16541795.00

2 CLOSING STOCK 12806925.00 13537560.00 16541795.00 18054500.00

i STOCK DIFF 2722160.00 -730635.00 0.00 -3004235.00 -1512705.00

3 A TOTAL PURCHASE FP BALES 126062401.00 192325258.00 ### 168145975.00 66292614.00

4 A1 TOTAL PROCESS COTTON PURCHASE 359488.00 1593461.00 1321786.00 1761708.00
5 A2 ADD RM LORRY FRIEGHT 837400.00 1122740.00 13263910.00 384600.00 1711600.00
6 A3 LESS DEBIT NOTE/RETURN 2553688.00 1716018.00 8023933.00 1358165.00 678135.00

ii TOTAL (A)+(A1)+(A2)+(A3) 124705601.00 193325441.00 ### 168494196.00 69087787.00

7 B TOTAL SALES YARN 182697902.00 169540322.00 ### 173555463.00 193511655.00

8 B1 LESS LORRY FRIEGHT YARN 434855.00 358000.00 3541411.00 473500.00 1289790.00

9 B2 TOTAL SALES P COTTON(WASTE) 13619522.00 12461222.00 136905399.00 13894315.00 14689014.00

10 B3 COMMISSION SALES 1370234.00 1271552.00 5800547.00 1300000.00 1451000.00

11 B4 LESS DEBIT NOTE SALES 1366419.00 284313.00 5357164.00 248280.00 174618.00

12 B5 QUALITY CLAIM EXPNSE 0.00 11666.00 21000.00

13 B6 CASE DISCOUNT EXPENSE 0.00 749014.00 34829.00

iii TAOTAL B+B1+B2+B3+B4+B5+B6+B7+B8 193145916.00 180087679.00 ### 184667318.00 205229432.00

14 C MACHINERY MAINTANANCE 1718971.00 2076841.00 19110005.00 1536775.00 3579834.00

15 C1 PURCHASE PACKING 2781086.00 2794429.00 24836318.00 1253806.00 1378421.00
16 C2 SALARY PACKING + EXPENSE 450111.00 494009.00 5605077.00 510683.00 536582.00

iv TOTAL C+C1+C2+C3+C4+D+D1 4950168.00 5365279.00 49551400.00 3301264.00 5494837.00

17 E POWER EXPENSE 13995486.00 11997286.00 141828476.00 15184359.00 13389572.00

18 F ADMINISTRATIVE EXPENSE
19 F1 SALES PROMOTION EXPENSE INCLUDE TRAVEL 228500.00

20 G BANK CHARGE 5188.00 336287.00 2248.00

21 G1 CC / WHR INTEREST 1858615.00 1878834.00 18447799.00 1705527.00 1691642.00

22 G2 TL INTEREST 5254617.00 5319702.00 47549807.00 4764766.00 4764766.00

23 G3 INSTALMENT 5700000.00 5700000.00 68400000.00 5700000.00 5700000.00

24 H SALARY EXPENSE 7643738.00 7418359.00 78256719.00 7067177.00 7137623.00

H1 USL INTERST 1300000.00 1300000.00 12006323.00 1000000.00 1000000.00

25 I LABOUR WELFARE EXPENSE 130000.00 135000.00 15000.00

26 J WATER EXPENSE 336350.00 140000.00 140000.00 332500.00

27 K OTHER EXPENSE 340830.00 7562489.00 27056585.00 3737443.00 1385667.00

v TOTAL EXPENSE E+E1+G+G1+G2+G3+H+H1+I+J+K 36793324.00 41451670.00 393545709.00 39650559.00 35404018.00

28 L1 OTHER INCOME 0.00

29 L2 SCHEME 9570285.00 51605835.00 78174721.00 0.00 3713991.00

vi TOTAL 9570285.00 51605835.00 78174721.00 0.00 3713991.00

30 DAYS 28.00 31.00 365.00 30.00 31.00

31 PRODUCTION YARN IN KG/MONTH 813306.00 898198.00 9347475.00 928515.00 975605.00

32 PRODUCTION YARN IN KG/DAY 29046.64 28974.13 25609.52 30950.50 31471.13

33 PRODUCTION OF WASTE IN KG/MONTH 217489.00 203371.00 2406824.00 208796.00 218701.00

34 TOTAL PRODUCTION YARN+WASTE(49+51) 1030795.00 1101569.00 11754299.00 1137311.00 1194306.00

COMBER IN % OF INPUT 10.13 7.20 8.69 7.34 7.10
FLAT IN % OF INPUT 4.42 4.60 4.48 4.31 4.40
LICKRIN IN % OF INPUT 4.33 4.61 4.98 4.74 4.89
OTHER WASTE IN % OF INPUT 1.77 1.66 1.78 1.46 1.49
TOTAL % WASTE GENERATION 20.64 18.06 19.93 17.85 17.89
MICRODUST IN % OF INPUT 1.49 1.61 1.17 1.69 1.65
LAY DOWN WEIGHT IN KG 1043329.00 1130019.00 12110901.00 1173069.00 1226421.00

LAY DOWN DIFFRENCE WEIGHT IN KG

35 COTTON CONSUMPTION IN KG/MONTH 1053947.00 1125801.00 12073746.00 1169563.00 1222433.00

COTTON CONSUMPTION IN BALES/MONTH 6564.00 7000.00 75197.00 7264.00 7615.00

36 WIP OPENING FIBER SHAPE 92251.00 81633.00 48696.00 85851.00 89357.00

WIP OPENING YARN SHAPE 1729.00 20502.00 28329.00

37 WIP CLOSING FIBER SHAPE 81633.00 85851.00 85851.00 89357.00 93335.00

WIP CLOSING YARN SHAPE 1860.00 28329.00 22576.00

38 REALISATION 77.17 79.78 77.42 79.39 79.81

39 YARN SALES IN KG/MONTH 945685.00 883942.00 8671017.64 903770.00 984947.00

BALES PURCHASE IN NOS 6853.00 9917.00 82228.00 8000.00 3383.00
BALES PURCHASE IN KG/MONTH 1115326.00 1628172.00 13267867.05 1290727.00 545812.00
WEIGHT SHORTAGE IN KG AT GODOWN LEVEL
WEIGHT SHORTAGE % AT GODOWN LEVEL
INVISIBLE LOSS % AT PRODUCTION LEVEL 2.20 2.15 2.65 2.76 2.30

40 ELECTRICAL UNITS AS PER PGVCL BILL 1999350.00 1705450.00 20975750.00 2215650.00 1930400.00

41 COST OF UNIT AS PER PGVCL 7.00 7.03 6.76 6.85 6.94

42 ELECTRICAL UNITS AS PER ELE. DEPT
43 ELECTRIC COST (59*60)
ACTUAL ELECTRIC COST PER KG 17.21 13.36 15.17 16.35 13.72

DIFFERENCE BETWEEN BILL AND USAGE

44 AVERAGE YARN SALE PRICE 194.50 191.80 201.41 192.03 196.46

45 AVERAGE COTTON PURCHASE PRICE 117.20 119.75 120.86 128.05 124.68
46 YARN COMMISSION & FREIGHT PER KG ((8+10)/31) 2.22 1.81 1.00 1.91 2.81

46A AVERAGE YARN SALE AFTER COMMISION(44-46) 192.28 189.99 200.41 190.12 193.65
47 AVERAGE WASTE SALE PRICE 61.34 60.76 56.94 64.92 68.60

48 AVERAGE WASTE KG/YARN(47*(100-38))% 12.47 10.76 11.43 11.76 12.14

49 CLEAN COTTON COST((45-48)/38)% 135.72 136.60 141.34 146.48 141.02

YARN PRODUCTION * AVG COUNT

50 AS PER PRODUCTION

51 ADJ PROFIT PER KG 4.21 0.01 10.25 -3.04 8.96

52 POWER EXP PER KG (E/31) 17.21 13.36 15.17 16.35 13.72
ACTUAL ELECTRIC COST PER KG
53 UNITS/KG(40/31) 2.46 1.90 2.24 2.39 1.98
54 AVG COUNT 24.75 22.89 22.64 22.02 20.74
55 SALARY EXP PER KG (H/31) 9.40 8.26 8.37 7.61 7.32
56 PAKING EXP PER KG ((C1+C2)/31) 3.97 3.66 3.26 1.90 1.96

57 CC INT EXP PER KG (G1/31) 2.29 2.09 1.97 1.84 1.73

58 TL INT EXP PER KG (G2/31) 6.46 5.92 5.09 5.13 4.88

59 OTHER EXP PER KG (K/31) 0.42 8.42 2.89 4.03 1.42

60 MAINT. EXP PER KG (C/31) 2.11 2.31 2.04 1.66 3.67

61 WATER EXP PER KG (J/31) 0.41 0.16 0.00 0.15 0.34

62 LABOUR WELFARE EXP PER KG (I/31) 0.16 0.15 0.00 0.02 0.00
63 ADMIN+SALES EXP PER KG(F+F1/31) 0.28 0.00 0.00 0.00 0.00

64 BANK CHARGES PER KG(G/31) 0.01 0.00 0.00 0.36 0.00

65 USL INTERSET(H1/31) 1.60 1.45 1.28 1.08 1.03

66 INSTALMENT(G3/31) 7.01 6.35 7.32 6.14 5.84

67 LORRY FRIEGHT YARN COTTON(A2+B1/31) 1.56 1.65 1.80 0.92 3.08

68 COMMISION(B3/31) 1.68 1.42 0.62 1.40 1.49

69 TOTAL EXP PER KG(52+55TO64) 54.57 55.19 49.82 48.58 46.49
70 TOTAL EXPENSE PER KG(iv+v/31) 51.33 52.12 47.40 46.26 41.92
DIFF IN EXP PER KG(66-65) 3.25 3.06 2.42 2.32 4.56

COST PER COUNT PER KG(66/54) 2.21 2.41 2.20 2.21 2.24
SALES PRICE PER COUNT PER KG (46A/54) 7.77 8.30 8.85 8.63 9.34

71 SALE YARN KG 813306.00 8981980.00 9347475.00 903770.00 984947.00

72 SCHEME 9570285.00 51605835.00 78174721.00 3713991.00

73 TOTAL RECEIVABLE 112434554.00 134598676.00 163864028.00 221851153.00

74 STOCK 163625580.00 221162723.00 257802965.00 166335079.00

75 SCHEME RECEIVABLE IN THIS MONTH 9570285.00 51605835.00 3713991.00

76 SBI FD 19900000.00 19900000.00 19900000.00 19900000.00

77 TOTAL PAYBLE OTHER THAN BANK 169211499.00 196054080.00 264804729.00 198962712.00

78 BANK CC 191040989.00 191856262.00 191781275.00 191211651.00

79 INSTALLMENT 5700000.00 5700000.00 5700000.00 5700000.00

-64292354.00 -12248943.00 -15019011.00 -1988131.00

15
 Table 1

16
17
18