Project:xxxxx

SUBJECT: CASH FLOW PROJECTION Vs CASH FLOW STATEMENT

Status Nov-22 Dec-22 Q4 Jan-23 Feb-23 Mar-23 Q1 Apr-23 May-23 Jun-23 Q2 Jul-23 Aug-23 Sep-23 Q3 Oct-23 Nov-23 Dec-23 Q4 Jan-24 Feb-24 Q1 2022 -2023 Budget
Roads & civil 193,694,478 268,407,260 462,101,738 72,389,346 604,092,201 202,350,882 878,832,429 320,707,760 262,199,297 671,128,438 1,254,035,495 646,807,000 745,920,560 867,831,000 2,260,558,560 875,295,000 945,920,564 801,874,629 2,623,090,193 130,513,636 10,515,523 141,029,159 7,478,618,415
P 193,694,478 268,407,260 462,101,738 72,389,346 604,092,201 202,350,882 878,832,429 320,707,760 262,199,297 671,128,438 1,254,035,495 646,807,000 745,920,560 867,831,000 2,260,558,560 875,295,000 945,920,564 801,874,629 2,623,090,193 130,513,636 10,515,523 141,029,159 7,619,647,574
Total Revenue A 61,807,708 123,105,182 184,912,891 70,857,793 604,092,235 202,350,649 877,300,677 320,707,878 262,199,087 671,089,545 1,253,996,510 651,179,844 586,347,537 409,962,736 1,647,490,118 500,350,607 630,139,689 191,986,681 1,322,476,977 100,395,105 8,088,864 108,483,969 5,394,661,140
V 131,886,770 145,302,078 277,188,847 422,490,925 (33.750) 233.213 422,491,125 (118.159) 210.24 38,893 38,985 (4,372,844) 159,573,023 457,868,264 613,068,442 374,944,393 315,780,875 609,887,948 1,300,613,216 30,118,531 2,426,659 32,545,191 2,645,945,807
Cost of sales -
P - 58,047,804 58,047,804 200,989,989 297,165,032 305,954,658 804,109,679 380,449,819 450,333,045 - 830,782,864 - - - - - - - - 5,882,604 - 5,882,604 1,698,822,950
Cost of
A 63,047,589 38,407,341 101,454,930 122,808,448 169,057,152 17,326,494 309,192,093 5,472,000 8,113,293 16,687,407 30,272,700 5,882,604 - 5,882,604 446,802,328
materials
V - 58,047,804 58,047,804 116,095,607 174,143,411 290,239,018 464,382,429 380,449,819 387,285,456 (38,407,341) 729,327,934 (122,808,448) (169,057,152) (17,326,494) (309,192,093) (5,472,000) (8,113,293) (16,687,407) (30,272,700) - - - 912,293,372
P 390,000 1,070,063 1,460,063 1,277,563 1,580,000 2,158,313 5,015,875 1,815,413 650,149 - 2,465,562 - - - - - - - - 3,727,250 1,787,625 5,514,875 14,456,375
Labor (wages
A 896,013 1,821,262 2,717,275 1,089,268 1,319,180 2,133,222 4,541,670 2,041,090 2,679,162 3,996,185 8,716,438 5,663,188 5,584,056 5,433,898 16,681,142 5,123,492 3,498,635 4,244,533 12,866,660 3,727,250 1,787,625 5,514,875 51,038,059
and salary)
V (506,013) (751,199) (1,257,212) 188,295 260,820 25,091 474,205 (225,677) (2,029,013) (3,996,185) (6,250,875) (5,663,188) (5,584,056) (5,433,898) (16,681,142) (5,123,492) (3,498,635) (4,244,533) (12,866,660) - - - (36,581,684)
P 1,240,000 9,560,000 10,800,000 36,877,153 45,341,917 55,498,816 137,717,886 65,578,364 18,211,250 - 83,789,614 - - - - - - - - 13,180,000 783,051 13,963,051 246,270,551
Hiring Costs A 2,350,000 650,000 3,000,000 899,000 688,136 761,864 2,349,000 737,288 1,511,864 7,809,831 10,058,983 16,516,667 16,854,000 26,289,000 59,659,667 11,338,000 8,000,000 17,526,000 36,864,000 13,180,000 783,051 13,963,051 125,894,701
V (1,110,000) 8,910,000 7,800,000 35,978,153 44,653,781 54,736,952 135,368,886 64,841,076 16,699,386 (7,809,831) 73,730,631 (16,516,667) (16,854,000) (26,289,000) (59,659,667) (11,338,000) (8,000,000) (17,526,000) (36,864,000) - - - 120,375,850
P 734,554 3,386,731 4,121,286 25,522,059 37,410,330 42,809,056 105,741,445 60,311,218 25,013,078 - 85,324,296 - - - - - - - - 29,264,255 - 29,264,255 224,451,281
Fuel &
A 503,490 129,100 632,590 - - - - - 364,750 2,899,033 3,263,783 9,416,665 11,366,077 9,972,029 30,754,771 5,386,231.17 6,755,120 11,319,683 23,461,034 29,264,255 - 29,264,255 87,376,433
Lubricants
V 231,064 3,257,631 3,488,696 25,522,059 37,410,330 42,809,056 105,741,445 60,311,218 24,648,328 (2,899,033) 82,060,513 (9,416,665) (11,366,077) (9,972,029) (30,754,771) (5,386,231) (6,755,120) (11,319,683) (23,461,034) - - - 137,074,848
P 150,438,738 138,806,300 289,245,038 502,388,880 863,429,175 1,117,844,655 2,483,662,710 991,027,614 1,011,030,179 - 2,002,057,793 - - - - - - - - 32,588,727 3,808,788 36,397,515 4,811,363,055
Subcontracting
A 44,002,993 101,420,074 145,423,067 56,004,341 493,380,108 184,054,218 733,438,666 284,646,433 171,547,830 561,071,772 1,017,266,035 420,473,911 250,175,929 230,392,182 901,042,022 373,488,210 547,671,421 111,590,789 1,032,750,421 32,588,727 3,808,788 36,397,515 3,866,317,726
cost
V 106,435,745 37,386,226 143,821,971 446,384,538 370,049,067 933,790,437 1,750,224,043 706,381,181 839,482,349 (561,071,772) 984,791,758 (420,473,911) (250,175,929) (230,392,182) (901,042,022) (373,488,210) (547,671,421) (111,590,789) (1,032,750,421) - - - 945,045,329
P 3,264,760 6,192,782 9,457,542 8,312,282 9,339,072 9,543,162 27,194,515 10,012,767 67,670,372 - 77,683,139 562,500 562,500 562,500 1,687,500 562,500 562,500 562,500 1,687,500 562,500 562,500 1,125,000 118,835,196
Other cost A 212,500 212,500 425,000 212,500 212,500 212,500 637,500 212,500 212,500 562,500 987,500 562,500 562,500 562,500 1,687,500 562,500 562,500 562,500 1,687,500 562,500 562,500 1,125,000 6,550,000
V 3,052,260 5,980,282 9,032,542 8,099,782 9,126,572 9,330,662 26,557,015 9,800,267 67,457,872 (562,500) 76,695,639 - - - - - - - - - - - 112,285,196
P 156,068,052 217,063,679 373,131,732 775,367,924 1,254,265,525 1,533,808,660 3,563,442,109 1,509,195,195 1,572,908,072 657,705,869 3,082,103,268 556,254,020 641,491,682 746,334,660 1,687,500 752,753,700 813,491,685 689,612,181 1,687,500 85,205,336 6,941,963 92,147,300 7,114,199,408
Total Cost Of
A 47,964,996 104,232,936 152,197,932 58,205,109 495,599,924 187,161,804 740,966,836 287,637,311 239,363,695 614,746,662 1,141,747,669 575,441,378 453,599,714 289,976,103 1,319,017,195 401,370,434 574,600,968 161,930,912 1,137,902,314 85,205,336 6,941,963 92,147,300 4,583,979,246
sales
V 108,103,057 112,830,743 220,933,800 717,162,815 758,665,601 1,346,646,856 2,822,475,273 1,221,557,884 1,333,544,377 42,959,207 1,940,355,599 (19,187,358) 187,891,968 456,358,557 (1,317,329,695) 351,383,266 238,890,717 527,681,269 (1,136,214,814) - - - 2,530,220,162
P 37,626,426 51,343,581 88,970,006 (702,978,578) (650,173,324) (1,331,457,778) (2,684,609,680) (1,188,487,435) (1,310,708,775) 13,422,569 (1,828,067,773) 90,552,980 104,428,878 121,496,340 2,258,871,060 122,541,300 132,428,879 112,262,448 2,621,402,693 45,308,300 3,573,559 48,881,860 456,566,306
Gross Profit A 13,842,713 18,872,246 32,714,959 12,652,684 108,492,311 15,188,845 136,333,840 33,070,567 22,835,392 56,342,883 112,248,841 75,738,466 132,747,823 119,986,634 328,472,923 98,980,173 55,538,720 30,055,769 184,574,662 15,189,769 1,146,900 16,336,669 810,681,894
V 23,783,713 32,471,335 56,255,048 (715,631,263) (758,665,635) (1,346,646,623) (2,820,943,520) (1,221,558,002) (1,333,544,167) (42,920,314) (1,940,316,614) 14,814,514 (28,318,945) 1,509,706 1,930,398,137 23,561,127 76,890,159 82,206,679 2,436,828,031 30,118,531 2,426,659 32,545,191 (354,115,588)

P 19% 19% 19% -971% -108% -658% -305% -371% -500% 2% -146% 14% 14% 14% 100% 14% 14% 14% 100% 35% 34% 35% 6%
Percentage
A 22% 15% 18% 18% 18% 8% 16% 10% 9% 8% 9% 12% 23% 29% 20% 20% 9% 16% 14% 15% 14% 15% 15%
profit
V -3% 4% 2% -989% -126% -666% -321% -381% -509% -6% -155% 2% -9% -15% 80% -6% 5% -2% 86% 20% 20% 20% -9%

LEGENDS: P-PLANNED A-ACTUAL V-VARIANCE