KRAPI FOR THE MONTH OF SEPTEMBER 2011
| COLLECTION PER SBU | (for the month of September 2011) |
|
|
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
| SBU | PLAN | August 2011 | (+/-) |
|
|
|
| |||
|
|
| COLLECTION | SALES | COLLECTION |
|
|
|
| ||
| HAMP | 1,545,454.60 | 1,079,531.63 | 70% | 21 | 795,072.58 | (465,922.97) |
|
|
|
|
| HGLUMP | 1,545,454.60 | 595,141.15 | 39% | 7 | 236,791.57 | (950,313.45) |
|
|
|
|
| HGPMP | 1,835,774.60 | 1,213,356.80 | 66% | 17 | 580,090.28 | (622,417.80) |
|
|
|
|
| HGGMP | 2,000,000.00 | 773,874.94 | 39% | 11 | 517,807.23 | (1,226,125.06) |
|
|
|
|
| HGCMP | 863,636.40 | 339,169.27 | 39% | 9 | 224,153.24 | (524,467.13) |
|
|
|
|
| HGOMP | 909,091.00 | 499,179.40 | 55% | 7 | 256,225.08 | (409,911.60) |
|
|
|
|
| TOTAL | 8,699,411.20 | 4,500,253.19 | 52% | 72 | 2,610,139.98 | (4,199,158.01) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CASH BALANCE | (for the month of September 2011) |
|
|
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
| SBU | PLAN | Bank Balance | Book Balance | (+/-) |
|
|
|
| ||
|
|
|
|
|
|
|
|
|
| ||
| HAMP |
|
|
|
|
|
|
|
| ||
| HGLUMP | 50,000.00 | 330,734.89 | 13,734.89 | (36,265.11) |
|
|
|
| ||
| HGPMP | 50,000.00 | 386,313.15 | 14,422.85 | (35,577.15) |
|
|
|
| ||
| HGGMP | 50,000.00 | 40,123.55 | 10,005.20 | (39,994.80) |
|
|
|
| ||
| HGCMP | 50,000.00 | 121,453.02 | 14,296.51 | (35,703.49) |
|
|
|
| ||
| HGOMP | 50,000.00 | 181,123.42 | 16,188.73 | (33,811.27) |
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
| CLEARANCE OF A/P | (for the month of September 2011) |
|
|
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
| SBU | PLAN | Actual | (+/-) |
|
|
|
|
| ||
|
|
|
|
|
|
|
|
|
| ||
| HAMP |
|
|
|
|
|
|
|
| ||
| HGLUMP | 673,000.00 | 584,642.93 | 87% |
|
|
|
|
| ||
| HGPMP | 491,636.36 | 388,118.57 | 79% |
|
|
|
|
| ||
| HGGMP | 393,090.91 | 281,281.41 | 72% |
|
|
|
|
| ||
| HGCMP | 272,818.18 | 206,554.71 | 76% |
|
|
|
|
| ||
| HGOMP | 182,000.00 | 174,362.20 | 96% |
|
|
|
|
| ||
| TOTAL | 2,012,545.45 | 1,634,959.82 | 82% |
|
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
| COST REDUCTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPEX | (for the month of September 2011) |
|
|
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
| SBU | PLAN | Actual | (+/-) | % |
|
|
|
| ||
|
|
|
|
| (+/-) |
|
|
|
| ||
| HAMP |
|
|
|
|
|
|
|
| ||
| HGLUMP | 102,476.32 | 106,871.73 | 4,395.41 | 4% |
|
|
|
| ||
| HGPMP | 183,739.76 | 182,389.72 | (1,350.04) | -1% |
|
|
|
| ||
| HGGMP | 186,195.34 | 104,100.04 | (82,095.30) | -44% |
|
|
|
| ||
| HGCMP | 69,338.43 | 73,907.02 | 4,568.59 | 7% |
|
|
|
| ||
| HGOMP | 96,702.25 | 130,487.58 | 33,785.33 | 35% |
|
|
|
| ||
| TOTAL | 638,452.10 | 597,756.09 | (40,696.01) | 0% |
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
| INTEREST EXPENSE | (for the month of September 2011) |
|
|
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
| SBU | PLAN | Actual | (+/-) | % |
|
|
|
| ||
|
|
|
|
| (+/-) |
|
|
|
| ||
| HAMP |
|
|
|
|
|
|
|
| ||
| HGLUMP | 69,485.66 | 37,033.00 | (32,452.66) | -47% |
|
|
|
| ||
| HGPMP | 132,082.62 | 137,252.60 | 5,169.98 | 4% |
|
|
|
| ||
| HGGMP | 56,283.01 | 19,490.00 | (36,793.01) | -65% |
|
|
|
| ||
| HGCMP | 206,102.75 | 73,989.00 | (132,113.75) | -64% |
|
|
|
| ||
| HGOMP | 140,055.05 | 33,585.00 | (106,470.05) | -76% |
|
|
|
| ||
| TOTAL | 604,009.10 | 301,349.60 | (302,659.50) | -50% |
|
|
|
| ||
|
|
|
|
|
|
|
|
|
|
|
|
| HAMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| Sales and Collection | 1,545,454.60 | 1,079,531.63 | 70% |
| Total | 1,545,454.60 | 1,079,531.63 | 70% |
| HGLUMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 153,374.84 | 253,569.53 | 165% |
| Arrears | 89,625.16 | 25,391.95 | 28% |
| SALES |
|
|
|
| Downpayment | 157,600.00 | 58,530.67 | 37% |
| Cash Sales | 1,146,000.00 | 257,649.00 | 22% |
| Total | 1,546,600.00 | 595,141.15 | 38% |
| HGPMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 802,226.59 | 695,247.29 | 87% |
| Arrears | 264,983.19 | 64,676.65 | 24% |
| SALES |
|
|
|
| Downpayment | 232,000.00 | 46,829.44 | 20% |
| Cash Sales | 642,000.00 | 406,603.42 | 63% |
| Total | 1,941,209.78 | 1,213,356.80 | 63% |
| HGGMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 680,000.00 | 415,711.98 | 61% |
| Arrears | 322,923.08 | 59,612.52 | 18% |
| SALES |
|
|
|
| Downpayment | 304,400.00 | 31,658.09 | 10% |
| Cash Sales | 784,000.00 | 266,892.35 | 34% |
| Total | 2,091,323.08 | 773,874.94 | 37% |
| HGCMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 207,777.90 | 248,558.73 | 120% |
| Arrears | 63,481.15 | 42,452.46 | 67% |
| SALES |
|
|
|
| Downpayment | 120,000.00 | 11,658.09 | 10% |
| Cash Sales | 884,000.00 | 36,499.99 | 4% |
| Total | 1,275,259.05 | 339,169.27 | 27% |
| HGOMP | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 304,906.40 | 206,772.15 | 68% |
| Arrears | 239,569.12 | 34,353.49 | 14% |
| SALES |
|
|
|
| Downpayment | 173,200.00 | 61,500.54 | 36% |
| Cash Sales | 862,000.00 | 196,553.22 | 23% |
| Total | 1,579,675.52 | 499,179.40 | 32% |
| TOTAL | PLAN | ACTUAL | PERCENTAGE |
| COLLECTION |
|
|
|
| MA | 3,693,740.33 | 2,650,832.58 | 72% |
| Arrears | 980,581.70 | 184,034.61 | 19% |
| SALES |
|
|
|
| Downpayment | 987,200.00 | 198,518.74 | 20% |
| Cash Sales | 4,318,000.00 | 1,127,697.99 | 26% |
| Total | 9,979,522.03 | 4,161,083.92 | 42% |
No comments:
Post a Comment
1. One of our beliefs is learning. It pays that you learn more to do more Just to survive you have to learn how forage in a forest or raise your food, catch prey
2. In order to discharge your job well, you have to learn your admin plan the process flow and standards.
3. To keep up with changes, you have to learn and read. There is no other way
4. signify that you have read by putting your name on this comment box. Every staff must: post the name on this comment box, or like, agree/will do. Your registering on this comment box is being graded under communication. Observe RRURAC: Read, Reflect, Understand, Realize (apply to reality) Apply, and Check (if it works)
You need to make __comments a month to qualify for promotion under our CCD
Read the posts on this site every AM talk. Many problems arise simply because people do not know what to do, because they did not read this site
We are making sure that you improve yourself, engage yourself in self improvement through this site...
Note: Only a member of this blog may post a comment.