Apr 20 | May 20 | Jun 20 | Jul 20 | Aug 20 | Sep 20 | Oct 20 | Nov 20 | Dec 20 | Jan 21 | Feb 21 | Mar 21 | TOTAL
Ordinary Income/Expense
Income
Installation Charge Received | 0.00 | 47,826.00 | 347,826.00 | 674,783.00 | 505,217.00 | 491,304.00 | 330,435.00 | 203,478.00 | 82,609.00 | 30,435.00 | 91,304.00 | 121,739.00 | 2,926,956.00
Market consulting fee (MPSL) | 1,218,194.00 | 2,619,358.00 | 1,252,285.00 | 52,987.00 | 1,011,211.00 | 328,200.00 | 385,963.00 | 998,516.00 | 1,066,742.00 | 393,221.00 | 1,187,867.00 | 632,054.00 | 11,146,598.00
Marketing & Technical Consultan | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 826,000.00 | 9,912,000.00
Parts Sales | 0.00 | 319,338.00 | 1,679,938.00 | 2,691,070.00 | 2,287,884.00 | 609,039.00 | 2,012,135.00 | 1,985,507.00 | 2,895,505.00 | 938,963.00 | 1,289,284.00 | 1,044,967.00 | 17,753,630.00
Repairing Charge | 0.00 | 0.00 | 0.00 | 60,870.00 | 0.00 | 0.00 | 7,826.00 | 0.00 | 66,957.00 | 0.00 | 0.00 | 18,261.00 | 153,914.00
Service Charge After Warranty | 0.00 | 4,348.00 | 13,044.00 | 0.00 | 34,782.00 | 56,522.00 | 30,435.00 | 39,131.00 | 39,131.00 | 86,958.00 | 82,609.00 | 43,480.00 | 430,440.00
Service Charge from MML | 0.00 | 377,775.00 | 2,402,649.00 | 2,070,207.00 | 2,296,872.00 | 2,523,537.00 | 2,311,983.00 | 2,039,985.00 | 1,737,765.00 | 2,357,316.00 | 2,704,869.00 | 2,704,869.00 | 23,527,827.00
Total Income | 2,044,194.00 | 4,194,645.00 | 6,521,742.00 | 6,375,917.00 | 6,961,966.00 | 4,834,602.00 | 5,904,777.00 | 6,092,617.00 | 6,714,709.00 | 4,632,893.00 | 6,181,933.00 | 5,391,370.00 | 65,851,365.00
Cost of Goods Sold
Cost of Sales
02. Sales
2.01 Car rent | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 118,557.00 | 1,422,684.00
2.02 Travelling & Transport - L | 27,720.00 | 0.00 | 0.00 | 0.00 | 17,340.00 | 0.00 | 68,640.00 | 0.00 | 90,400.00 | 0.00 | 0.00 | 31,260.00 | 235,360.00
2.03 Salary & Allowances | 104,000.00 | 210,000.00 | 110,000.00 | 244,000.00 | 144,000.00 | 158,000.00 | 154,000.00 | 134,000.00 | 160,000.00 | 160,000.00 | 110,000.00 | 160,000.00 | 1,848,000.00
2.04 Telephone & Mobile Expense | 0.00 | 0.00 | 3,492.00 | 0.00 | 1,188.00 | 0.00 | 0.00 | 2,503.00 | 1,827.00 | 3,380.00 | 0.00 | 1,775.00 | 14,165.00
2.05 Company Contribution to PF | 4,992.00 | 4,992.00 | 4,992.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 5,280.00 | 62,496.00
2.06 Marketing & promotion expe | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00
2.07 Gratuity Expense | 5,027.00 | 5,373.00 | 5,027.00 | 15,573.00 | 5,500.00 | 5,317.00 | 5,683.00 | 5,317.00 | 5,683.00 | 5,500.00 | 4,950.00 | 6,050.00 | 75,000.00
Total 02. Sales | 260,296.00 | 338,922.00 | 242,068.00 | 383,410.00 | 291,865.00 | 287,154.00 | 352,160.00 | 270,657.00 | 381,747.00 | 292,717.00 | 238,787.00 | 322,922.00 | 3,662,705.00
03. Parts
3.01 Freight Charge | 0.00 | 0.00 | 409,906.88 | 1,367,146.26 | 547,431.36 | 159,067.93 | 259,114.77 | 554,746.15 | 872,632.50 | 183,871.03 | 463,793.00 | 472,321.93 | 5,290,031.81
3.02 Car Rent | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 65,206.00 | 782,472.00
3.03 Travelling & Transport - L | 28,352.00 | 0.00 | 30,197.00 | 30,674.00 | 31,539.00 | 41,686.00 | 57,086.00 | 73,019.00 | 50,908.00 | 45,085.00 | 135,866.00 | 45,851.00 | 570,263.00
3.04 Printing & Stationery | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,310.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,310.00
3.05 Insurance Expense | 0.00 | 0.00 | 10,135.00 | 8,424.00 | 0.00 | 16,587.00 | 6,010.00 | 10,290.00 | 0.00 | 4,169.00 | 0.00 | 5,723.00 | 61,338.00
3.06 Postage & Courier | 0.00 | 0.00 | 500.00 | 200.00 | 300.00 | 280.00 | 0.00 | 150.00 | 180.00 | 1,380.00 | 900.00 | 600.00 | 4,490.00
3.07 Salary & Allowances | 102,500.00 | 205,000.00 | 102,500.00 | 248,200.00 | 109,700.00 | 109,700.00 | 109,700.00 | 109,700.00 | 109,700.00 | 109,700.00 | 139,296.00 | 176,916.00 | 1,632,612.00
3.08 Bank Charge | 0.00 | 0.00 | 5,060.00 | 13,951.65 | 0.00 | 0.00 | 0.00 | 575.00 | 11,955.25 | 0.00 | 458.38 | 230.00 | 32,230.28
3.09 General Expense | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,885.00 | 0.00 | 0.00 | 1,885.00
3.10 Telephone & Mobile Expense | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 2,640.00 | 1,640.00 | 3,947.00 | 31,987.00
3.11 Company Contribution to PF | 4,920.00 | 4,920.00 | 4,920.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 5,266.00 | 62,154.00
3.12 Gratuity Expense | 4,954.00 | 5,296.00 | 4,954.00 | 19,336.00 | 5,485.00 | 5,302.00 | 5,668.00 | 5,302.00 | 5,668.00 | 5,485.00 | 4,937.00 | 6,034.00 | 78,421.00
3.13 Welfare Expenses | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 400.00 | 6,810.00 | 0.00 | 35,500.00 | 42,710.00
Closing Stock-Parts | 0.00 | (6,188,291.00) | (6,281,702.00) | (11,373,336.00) | (12,039,761.00) | (12,686,506.00) | (12,193,525.00) | (13,412,157.00) | (15,472,832.00) | (31,222,244.20) | (31,310,588.56) | (32,675,880.86) | (184,856,823.62)
Opening Stock-Parts | 0.00 | 6,359,641.00 | 6,188,291.00 | 6,281,702.00 | 11,373,336.00 | 12,039,761.00 | 12,686,506.00 | 12,193,525.00 | 13,412,157.00 | 14,780,708.00 | 31,222,244.20 | 31,310,588.56 | 157,848,459.76
Purchase-Parts | 0.00 | 0.00 | 1,401,039.00 | 6,750,286.00 | 2,110,149.00 | 1,048,065.00 | 1,037,783.00 | 2,579,357.00 | 3,818,677.00 | 16,970,209.20 | 1,013,312.00 | 1,982,153.00 | 38,711,030.20
Total 03. Parts | 208,572.00 | 454,412.00 | 1,943,646.88 | 3,419,695.91 | 2,211,291.36 | 807,054.93 | 2,042,764.77 | 2,187,619.15 | 2,882,557.75 | 960,170.03 | 1,742,330.02 | 1,434,455.63 | 20,294,570.43
04. Service
4.01 Postage & Courier | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 30.00 | 0.00 | 30.00 | 0.00 | 0.00 | 0.00 | 0.00 | 60.00
4.02 Office Supplies | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,645.00 | 0.00 | 0.00 | 0.00 | 1,645.00
4.03 Telephone & Mobile Expense | 15,631.00 | 15,354.00 | 16,190.00 | 17,061.00 | 17,155.00 | 17,709.00 | 17,702.00 | 16,723.00 | 15,232.00 | 15,591.00 | 11,371.00 | 14,162.00 | 189,881.00
4.04 Welfare Expenses | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 12,000.00 | 36,000.00 | 48,000.00
4.05 Repair & Maintenance | 0.00 | 0.00 | 0.00 | 0.00 | 570.00 | 2,413.00 | 2,194.00 | 5,403.84 | 0.00 | 0.00 | 4,512.00 | 82.00 | 15,174.84
4.06 Travelling & Transport - L | 0.00 | 3,500.00 | 20,413.00 | 0.00 | 28,500.00 | 59,000.00 | 55,484.00 | 56,760.00 | 57,500.00 | 41,000.00 | 64,731.00 | 68,177.00 | 455,065.00
4.07 Salary & Allowances | 635,100.00 | 1,293,700.00 | 971,100.00 | 1,850,560.00 | 1,092,260.00 | 1,165,260.00 | 1,183,260.00 | 1,101,260.00 | 1,031,260.00 | 1,151,260.00 | 1,183,260.00 | 1,103,260.00 | 13,761,540.00
4.08 Printing & Stationery | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 746.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 746.00
4.09 Company Contribution to PF | 30,101.00 | 30,101.00 | 30,101.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 31,980.00 | 378,123.00
4.11 Gratuity Expense | 30,310.00 | 32,400.00 | 30,310.00 | 98,874.00 | 33,313.00 | 32,203.00 | 34,423.00 | 32,203.00 | 34,423.00 | 33,313.00 | 29,982.00 | 36,644.00 | 458,398.00
4.12 Computer & Internet Expens | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2,350.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2,350.00
Total 04. Service | 711,142.00 | 1,375,055.00 | 1,068,114.00 | 1,998,475.00 | 1,203,778.00 | 1,310,945.00 | 1,325,789.00 | 1,244,359.84 | 1,172,040.00 | 1,273,144.00 | 1,337,836.00 | 1,290,305.00 | 15,310,982.84
Total Cost of Sales | 1,180,010.00 | 2,168,389.00 | 3,253,828.88 | 5,801,580.91 | 3,706,934.36 | 2,405,153.93 | 3,720,713.77 | 3,702,635.99 | 4,436,344.75 | 2,526,031.03 | 3,318,953.02 | 3,047,682.63 | 39,268,258.27
Total COGS | 1,180,010.00 | 2,168,389.00 | 3,253,828.88 | 5,801,580.91 | 3,706,934.36 | 2,405,153.93 | 3,720,713.77 | 3,702,635.99 | 4,436,344.75 | 2,526,031.03 | 3,318,953.02 | 3,047,682.63 | 39,268,258.27
Gross Profit | 864,184.00 | 2,026,256.00 | 3,267,913.12 | 574,336.09 | 3,255,031.64 | 2,429,448.07 | 2,184,063.23 | 2,389,981.01 | 2,278,364.25 | 2,106,861.97 | 2,862,979.98 | 2,343,687.37 | 26,583,106.73
Expense
01. Administrative Expenses
1.01 Office Rent | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 329,840.00 | 3,958,080.00
1.02. Office Rent- VAT | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 49,476.00 | 593,712.00
1.03 Travelling & Transport - L | 3,000.00 | 4,250.00 | 4,240.00 | 5,380.00 | 2,800.00 | 4,017.00 | 5,252.00 | 5,683.00 | 5,573.00 | 13,785.00 | 7,385.00 | 7,280.00 | 68,645.00
1.04 Utilities | 31,000.00 | 47,163.00 | 48,526.00 | 44,274.00 | 47,409.00 | 45,121.00 | 46,855.00 | 48,115.00 | 45,566.00 | 44,247.00 | 42,115.00 | 44,971.00 | 535,362.00
1.06 Salary & Allowance | 426,100.00 | 770,300.00 | 419,800.00 | 866,380.00 | 439,060.00 | 442,090.00 | 440,980.00 | 440,080.00 | 439,180.00 | 440,528.00 | 439,060.00 | 438,775.00 | 6,002,333.00
1.07 Postage & Courier | 0.00 | 13,788.00 | 34,450.00 | 6,679.00 | 2,450.00 | 3,017.00 | 6,667.00 | 14,349.00 | 0.00 | 6,230.00 | 0.00 | 3,241.00 | 90,871.00
1.08 Computer and Internet Expe | 21,250.00 | 21,250.00 | 30,250.00 | 22,200.00 | 24,541.00 | 21,250.00 | 22,770.00 | 22,770.00 | 22,770.00 | 22,770.00 | 22,770.00 | 22,770.00 | 277,361.00
1.09 Fuel & Lubricant | 0.00 | 7,450.00 | 23,020.00 | 14,680.00 | 26,300.00 | 31,030.00 | 30,040.00 | 25,680.00 | 29,640.00 | 25,780.00 | 31,150.00 | 32,970.00 | 277,740.00
1.10 Entertainment | 0.00 | 0.00 | 240.00 | 0.00 | 0.00 | 2,060.00 | 1,640.00 | 900.00 | 960.00 | 1,500.00 | 3,220.00 | 2,000.00 | 12,520.00
1.11 Printing & Stationery | 1,408.00 | 0.00 | 2,130.00 | 0.00 | 14,117.00 | 784.00 | 4,706.00 | 0.00 | 6,843.00 | 6,362.00 | 1,970.00 | 0.00 | 38,320.00
1.13 Office Supplies | 3,342.00 | 0.00 | 6,790.00 | 0.00 | 6,964.00 | 0.00 | 6,741.00 | 3,949.00 | 6,253.00 | 5,984.00 | 0.00 | 6,582.00 | 46,605.00
1.14 Telephone & Mobile Expense | 4,693.00 | 4,714.00 | 6,413.00 | 6,889.00 | 6,976.00 | 5,923.00 | 7,328.00 | 4,472.00 | 9,902.00 | 7,968.00 | 10,922.00 | 6,515.00 | 82,715.00
1.15 Welfare Expanses | 3,100.00 | 5,230.00 | 3,230.00 | 0.00 | 0.00 | 0.00 | 10,000.00 | 5,798.00 | 800.00 | 26,893.00 | 58,900.00 | 27,200.00 | 141,151.00
1.16 Repair & Maintenance | 20,322.00 | 0.00 | 14,464.00 | 2,699.00 | 2,797.00 | 2,742.00 | 2,194.00 | 0.00 | 0.00 | 0.00 | 91,144.00 | 27,215.83 | 163,577.83
1.17 Bank Charges | 60.00 | 350.00 | 1,005.00 | 1,958.18 | 13,367.50 | 590.20 | 1,077.50 | 699.55 | 4,603.50 | 15,170.00 | 695.00 | 1,294.00 | 40,870.43
1.18 Depreciation & Amortizatio | 62,727.00 | 72,090.00 | 70,922.00 | 98,210.00 | 72,983.00 | 84,043.00 | 71,529.00 | 70,360.00 | 69,364.00 | 187,151.00 | 80,028.00 | 76,805.00 | 1,016,212.00
1.19 Technical and Management F | 122,652.00 | 251,679.00 | 391,305.00 | 382,555.00 | 417,718.00 | 290,076.00 | 354,287.00 | 365,557.00 | 402,883.00 | 277,974.00 | 370,916.00 | 323,482.00 | 3,951,084.00
1.20 Legal and Professional Fee | 285,315.00 | 100,625.00 | 77,625.00 | 185,725.00 | 117,875.00 | 77,625.00 | 99,475.00 | 77,625.00 | 77,625.00 | 131,675.00 | 77,625.00 | 320,356.00 | 1,629,171.00
1.21 Insurance Expenses | 0.00 | 0.00 | 12,430.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 191,196.00 | 0.00 | 0.00 | 203,626.00
1.22 License & Renewal Fees | 0.00 | 0.00 | 35,134.00 | 46,932.00 | 20,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 102,066.00
1.23 Company Contribution to PF | 16,363.00 | 16,363.00 | 16,363.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 17,107.00 | 203,052.00
1.24 Gratuity Expense | 16,477.00 | 17,613.00 | 16,477.00 | 43,655.00 | 17,820.00 | 17,226.00 | 18,414.00 | 17,226.00 | 18,414.00 | 17,820.00 | 16,038.00 | 19,602.00 | 236,782.00
1.25 Office General Expenses | 0.00 | 10,000.00 | 13,183.00 | 10,500.00 | 8,236.00 | 7,655.00 | 12,533.00 | 24,424.00 | 9,380.00 | 10,655.00 | 10,570.00 | 8,865.00 | 126,001.00
Total 01. Administrative Expenses | 1,397,125.00 | 1,722,181.00 | 1,607,313.00 | 2,135,139.18 | 1,637,836.50 | 1,431,672.20 | 1,538,911.50 | 1,524,110.55 | 1,546,179.50 | 1,830,111.00 | 1,660,931.00 | 1,766,346.83 | 19,797,857.26
Insurance Expense | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | (645.00) | 0.00 | (645.00)
Total Expense | 1,397,125.00 | 1,722,181.00 | 1,607,313.00 | 2,135,139.18 | 1,637,836.50 | 1,431,672.20 | 1,538,911.50 | 1,524,110.55 | 1,546,179.50 | 1,830,111.00 | 1,660,286.00 | 1,766,346.83 | 19,797,212.26
Net Ordinary Income | (532,941.00) | 304,075.00 | 1,660,600.12 | (1,560,803.09) | 1,617,195.14 | 997,775.87 | 645,151.73 | 865,870.46 | 732,184.75 | 276,750.97 | 1,202,693.98 | 577,340.54 | 6,785,894.47
Other Income/Expense
Other Income
Foreign Exchange Gain | 0.00 | 8,475.07 | 20,998.88 | 17,562.49 | 0.00 | 3,855.87 | 2,925.72 | 5,190.48 | 8,511.70 | 0.00 | 0.00 | 0.00 | 67,520.21
Interest Income | 154,166.67 | 154,166.67 | 154,166.67 | 154,166.67 | (95,000.04) | 94,255.00 | 122,488.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 738,409.64
Total Other Income | 154,166.67 | 162,641.74 | 175,165.55 | 171,729.16 | (95,000.04) | 98,110.87 | 125,413.72 | 5,190.48 | 8,511.70 | 0.00 | 0.00 | 0.00 | 805,929.85
Other Expense
Foreign Exchange Loss | 0.00 | 29,169.74 | 0.00 | 22,884.04 | 27,120.97 | 0.00 | 26,466.97 | 0.00 | 26,729.68 | 0.00 | 52,251.21 | 51,712.60 | 236,335.21
Income Tax Expenses | 1,036,971.00 | 476,267.00 | 254,428.51 | 927,175.20 | 542,581.81 | 375,281.02 | 767,794.36 | 383,818.67 | 460,044.09 | 836,855.58 | 848,548.21 | 872,646.04 | 7,782,411.49
Total Other Expense | 1,036,971.00 | 505,436.74 | 254,428.51 | 950,059.24 | 569,702.78 | 375,281.02 | 794,261.33 | 383,818.67 | 486,773.77 | 836,855.58 | 900,799.42 | 924,358.64 | 8,018,746.70
Net Other Income | (882,804.33) | (342,795.00) | (79,262.96) | (778,330.08) | (664,702.82) | (277,170.15) | (668,847.61) | (378,628.19) | (478,262.07) | (836,855.58) | (900,799.42) | (924,358.64) | (7,212,816.85)
Net Income | (1,415,745.33) | (38,720.00) | 1,581,337.16 | (2,339,133.17) | 952,492.32 | 720,605.72 | (23,695.88) | 487,242.27 | 253,922.68 | (560,104.61) | 301,894.56 | (347,018.10) | (426,922.38)
①Yearly sales | 65,851,365.00
②Managementfee(①×6%) | 3,951,082 | BDT
Exchange Rate(As of 30,July 2021) THB⇔BDT | 0.3853
THB | 1,522,351.89 | THB