Move... Mark as read Mark as unread Spam
YELO BROTHERS (PVT) LTD
Logout

Dashboard


 18-Sep-23

















1 14 15 21 200

Description Target Actual Vairance
Sales Rep Performance Credit Outstanding Dated Cheque

Monthly Sales Rep Target 30%
85,000,000 25,170,911 59,829,089
Route Target Cancel Cash Cheque Credit Original Invoice Value Cancelled Secondary Inv Value Monthly Sales Target Cash Sale Cheque Sale Credit Sale 1-14 Days 15-21 Days 21 < Days 1-14 Days 15-21 Days 21 < Days

Unilever Primary Target 43%
78,200,000 33,328,657 44,871,343
3% 97% 34% 26% 40% 69% 19.5% 11.1% 13.6% 25.5% 60.9%

Unilever Secondary Target 30%
85,000,000 25,170,911 59,829,089
2088 0% 3% 15% 35% 50% 5,881,926 148,492 5,733,434 - 856,294 1,983,343 2,893,777 2,491,639 1,231,577 449,245 604,278 3,318,290 9,957,286







2082 0% 2% 15% 43% 42% 4,390,554 84,021 4,306,533 - 666,131 1,848,852 1,791,525 1,654,975 203,209 91,247 1,134,766 1,350,186 4,230,317

Market Outstanding-Cheque 179%
17,000,000 30,468,244 (13,468,244)
2083 0% 1% 54% 3% 42% 1,603,651 16,510 1,587,141 - 861,410 54,171 671,594 610,104 12,595 516,159 76,009 204,084 -

Market Outstanding-Credit 199%
5,666,667 11,251,907 (5,585,241)
2086 0% 4% 42% 10% 47% 2,419,105 91,280 2,327,825 - 988,805 233,662 1,105,327 871,132 346,214 8,715 90,521 499,909 594,150

Inventory Holding Value 105%
34,000,000 35,799,597 (1,799,597)
2087 0% 3% 42% 31% 27% 3,046,862 105,886 2,940,975 - 1,240,117 906,852 793,980 677,230 266,429 76,749 692,629 963,818 2,189,838







2081 0% 3% 45% 23% 31% 2,925,911 96,686 2,829,225 - 1,286,305 652,834 890,075 661,522 127,393 2,529 714,275 707,680 1,033,201

Collection Details
2084 0% 5% 50% 14% 36% 2,496,659 116,791 2,379,867 - 1,182,819 330,827 866,202 425,020 46,301 44,477 519,581 284,844 187,254

Days Cheque Sale Credit Sale Retnd Cheq Total
2085 0% 0% 40% 21% 39% 1,867,615 2,023 1,865,592 - 741,263 392,248 732,065 571,617 49,350 70,865 243,963 388,340 267,014

1-7 Days 195,859 4,498,297 115,417 4,809,573
2080 0% 9% 65% 4% 31% 1,323,240 122,921 1,200,319 - 781,997 42,383 375,914 331,791 49,723 62,298 50,594 25,000 25,000

8-14 Days 3,930,757 3,796,733
7,727,490
Other 0% 0% 0% 0% 0% - - - - - - - - - - - - -

15-21 Days 7,742,151 2,332,792
10,074,942
Total 0% 3% 34% 26% 40% 25,955,521 784,610 25,170,911 - 8,605,140 6,445,172 10,120,460 8,295,030 2,332,792 1,322,284 4,126,616 7,742,151 18,484,060

21-30 Days 13,377,206 87,633






















More than 31 Days 5,106,854 536,453
5,643,307
Weekly Purchases Primary Target

Sales Rep Slow Moving Inventory Target Sales Rep Slow Moving Inventory Target

Total 30,352,827 11,251,907 115,417 28,255,312
Week Target Actual Variance



Week Target Actual Variance Week Target Actual Variance







1st Week Order 19,550,000 9,183,015 (10,366,985)



2088

- 2081

-

Inventory Value
2nd Week Order 19,550,000 10,734,835 (8,815,165)



2082

- 2084

-

Days Amount Total
3rd Week Order 19,550,000 13,410,807 (6,139,193)



2083

- 2085

-

0-30 Days

23,354,404

4th Week Order 19,550,000 - (19,550,000)



2086

- 2080

-

30 -45 Days

290,921

5th Week Order
- -



Total - - - Total - - -

46 -60 Days

550,159

Total 78,200,000 33,328,657 (44,871,343)












61 -75 Days

226,948

CASH FLOW PROJECTION

More than 75 Days

5,593,763

Date Cheques to be No of Chq Bank Balance Expenses Unilever Fund Avalability Sheduled Fund Avalability Forecasted Forecasted Temporary Tem Loan Projected

Goods in Delivery - Today

3,002,997

Realized Description Amount Due After Exp & Purchases for After Scheduled Daily Cash Credit Cash Loan Settlement Fund

Goods in Delivery - Tomrw

2,780,405 35,799,597
Opening Bal



21,059,911 Bills Uni Due Bills Primary Targt Purchases Collection Collection

Availability







Monday, September 18 1,060,342 25 22,120,253 - - 22,120,253 - 22,120,253 1,352,273 395,001

23,867,528

Cash & Bank Balances
Tuesday, September 19 2,396,036 44 24,516,289 - 4,701,449 19,814,841 - 19,814,841 1,352,273 395,001

21,562,115

Peoples Bank




Wednesday, September 20 2,093,229 24 26,609,518 Building Rent 170,000 - 26,439,518 - 26,439,518 1,352,273 395,001

28,186,793

BOC

1,057,772

Thursday, September 21 2,079,538 23 28,689,056 - - 28,689,056 - 28,689,056 1,352,273 395,001

30,436,331

Commercial Bank




Friday, September 22 905,779 16 29,594,835 - - 29,594,835 - 29,594,835 1,352,273 395,001

31,342,110

Deposits




Saturday, September 23 - - 29,594,835 - - 29,594,835 - 29,594,835 - -

29,594,835

NDB (OD)

20,000,000

Sunday, September 24 - - 29,594,835 - - 29,594,835 - 29,594,835 - -

29,594,835





21,057,772
Monday, September 25 966,026 13 30,560,861 Salary Advance 600,000 - 29,960,861 11,730,000 18,230,861 1,352,273 395,001

19,978,136

Cash In Hand - Not yet Deposited




Tuesday, September 26 4,380,706 40 34,941,567 - - 34,941,567 3,910,000 31,031,567 1,352,273 395,001

32,778,842

Petty Cash Balance

2,139 21,059,911
Wednesday, September 27 966,930 15 35,908,497 - - 35,908,497 3,910,000 31,998,497 1,352,273 395,001

33,745,772







Thursday, September 28 647,064 11 36,555,561 Utility Bill 60,000 - 36,495,561 - 36,495,561 1,352,273 395,001

38,242,836

Unilever Payable
Friday, September 29 3,638,667 19 40,194,228 - - 40,194,228 - 40,194,228 1,352,273 395,001

41,941,503

Inv No Inv Date Credit Days Due Date Total
Saturday, September 30 - - 40,194,228 - - 40,194,228 - 40,194,228 - -

40,194,228

1533460247 12-Sep-23 5 17-Sep-23 815,695
Sunday, October 1 - - 40,194,228 - - 40,194,228 - 40,194,228 - -

40,194,228

1547834130 12-Sep-23 5 17-Sep-23 2,315,143
Monday, October 2 1,130,910 8 41,325,138 - - 41,325,138 11,730,000 29,595,138 1,352,273 395,001

31,342,413

1533460405 14-Sep-23 5 19-Sep-23 1,205,044
Tuesday, October 3 1,214,594 11 42,539,732 - - 42,539,732 3,910,000 38,629,732 1,352,273 395,001

40,377,007

1547834288 14-Sep-23 5 19-Sep-23 3,496,405
Wednesday, October 4 204,419 3 42,744,151 - 12,837,644 29,906,508 3,910,000 25,996,508 1,352,273 395,001

27,743,782

1533460491 15-Sep-23 19 4-Oct-23 3,573,849
Thursday, October 5 117,000 2 42,861,151 Vehicle Advance 540,000 - 42,321,151 - 42,321,151 1,352,273 395,001

44,068,426

1547834369 15-Sep-23 19 4-Oct-23 9,263,795
Friday, October 6 166,748 2 43,027,899 - - 43,027,899 - 43,027,899 1,352,273 395,001

44,775,174




30-Dec-99

Saturday, October 7 - - 43,027,899 - - 43,027,899 - 43,027,899 - -

43,027,899




30-Dec-99

Sunday, October 8 - - 43,027,899 - - 43,027,899 - 43,027,899 - -

43,027,899





20,669,930
Monday, October 9 453,844 4 43,481,743 - - 43,481,743 11,730,000 31,751,743 1,352,273 395,001

33,499,018

Discount Receivable
Tuesday, October 10 60,748 1 43,542,491 Monthly Salary 2,000,000 - 41,542,491 3,910,000 37,632,491 1,352,273 395,001

39,379,766

Discount




Wednesday, October 11 - - 43,542,491 - - 43,542,491 3,910,000 39,632,491 1,352,273 395,001

41,379,766

Discount




Thursday, October 12 - - 43,542,491 - - 43,542,491 - 43,542,491 1,352,273 395,001

45,289,766

Discount




Friday, October 13 - - 43,542,491 - - 43,542,491 - 43,542,491 1,352,273 395,001

45,289,766

Discount




Saturday, October 14 - - 43,542,491 - - 43,542,491 - 43,542,491 - -

43,542,491

Discount




Sunday, October 15 - - 43,542,491 Monthly Vehicle Payment 1,200,000 - 42,342,491 - 42,342,491 - -

42,342,491

Discount




Monday, October 16 - - 43,542,491 - - 43,542,491 11,730,000 31,812,491 1,352,273 395,001

33,559,766

Damage




Tuesday, October 17 - - 43,542,491 - - 43,542,491 3,910,000 39,632,491 1,352,273 395,001

41,379,766

Damage


-
Wednesday, October 18 - - 43,542,491 - - 43,542,491 3,910,000 39,632,491 1,352,273 395,001

41,379,766







Thursday, October 19 - - 43,542,491 - - 43,542,491 - 43,542,491 1,352,273 395,001

45,289,766

Total Value of Cheques on Hand


30,352,827
Friday, October 20 - - 43,542,491 Building Rent 170,000 - 43,372,491 - 43,372,491 1,352,273 395,001

45,119,766

Total Value of Credit Bills Receivable


11,251,907
Saturday, October 21 - - 43,542,491 - - 43,542,491 - 43,542,491 - -

43,542,491

Total Value of Returned Cheques on Hand


115,417
Sunday, October 22 - - 43,542,491 - - 43,542,491 - 43,542,491 - -

43,542,491

Total Inventory On Hand


35,799,597
Monday, October 23 - - 43,542,491 - - 43,542,491 11,730,000 31,812,491 1,352,273 395,001

33,559,766

Unilever Receivable


-
Tuesday, October 24 - - 43,542,491 - - 43,542,491 3,910,000 39,632,491 1,352,273 395,001

41,379,766

Unilever Payable


(20,669,930)
Wednesday, October 25 - - 43,542,491 Salary Advance 600,000 - 42,942,491 3,910,000 39,032,491 1,352,273 395,001

40,779,766

Owners Capital 56,849,818
Thursday, October 26 - - 43,542,491 - - 43,542,491 - 43,542,491 1,352,273 395,001

45,289,766