Eugene
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Eugene as PDF for free.
More details
- Words: 3,499
- Pages: 20
COMMISSION/INCENTIVE
RSTI - GAISANO Gross Sales
479,964.76 107,094.00 93,600.00 680,658.76
Net sales w/o Tax
428,539.96 95,619.64 83,571.43 607,731.04
Labor Cost
13,053.80
Commission Based on Net Sales LESS TAX AND VAT total commission COLLECTED 612,592.88 546,957.93 68,065.88 60,773.11 UNCOLLECTED TOTAL COMMISSION
Materials Cost Miscellaneous
231,154.00
25,781.41
CM w/ TAX
410,669.55
%
60.33%
337,741.83 COLLECTED 90.00% UNCOLLECTD 10.00% commssion based on collected amount
337,741.83
%
55.57%
Distribution of Com 0.5% com 2% com 2.0% Essel 3,038.66 12,154.62 0.5% PMD commission based on collected amount 90.00% 2,734.79 10,939.16 10.00% 303.87 1,215.46 3,038.66 12,154.62 Net margin afterw/h tax less commission
Commission Based on Net Margin
CM w/o TAX
0.5% com 1,688.71 1,519.84 168.87 1,688.71
2% com 6,754.84 6,079.35 675.48 6,754.84
53.07%
3% com 5% 10,132.25 16,887.09 9,119.03 15,198.38 1,013.23 1,688.71 10,132.25 16,887.09
O.B.MONTESORRI Gross Sales
300,000.00
Net sales w/o Tax
267,857.14
Labor Cost
13,241.33
Materials Cost Miscellaneous
108,294.00
Commission Based on Net Sales
COLLECTED UNCOLLECTED
TOTAL
Err:522 36,000.00 300,000.00
total commission Err:522 88.00% 32,142.86 12.00% 267,857.14 100.00%
11,243.82
0.5% com 1,339.29 1,178.57 160.71 1,339.29
CM w/ TAX
167,220.85
%
55.74%
2% com 5,357.14
0.5% com
2% com
135,077.99
4,714.29 642.86 5,357.14
3% com
%
50.43%
Distribution of Com 2.0% Essel 0.5% PMD
Net margin afterw/h tax less commission Commission Based on Net Margin
CM w/o TAX
47.93% 5%
135,077.99 COLLECTED UNCOLLECTED total commission
88.00% 12.00%
675.39 599.75 75.64 675.39
2,701.56 2,377.37 324.19 2,701.56
4,052.34 3,566.06 486.28 4,052.34
6,753.90 5,943.43 810.47 6,753.90
Paul M.Diaz de Rivera COMMISSION Option 1 COMMISSION BASED ON NET SALES NO. 2 3 4 5 6 7 8 9 10 11 12 13 14
PROJECT
Contract Amount
RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria
680,658.76 300,000.00 135,000.00 263,842.40 90,000.00 145,390.00 33,000.00 150,000.00 8,000.00 4,212.05 326,800.00 3,194.00 770,000.00
Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Net Sales Weight (%)Commission Collected Collected A. CommissionCommission (Total) Amount less 12% VAT (based on CA) (remaining) 607,731.04 0.05% 3,038.66 612,592.88 546,957.93 2,734.79 303.87 267,857.14 0.50% 1,339.29 300,000.00 267,857.14 1,339.29 120,535.71 2.00% 2,410.71 135,000.00 120,535.71 2,410.71 235,573.57 2.00% 4,711.47 221,532.14 197,796.55 3,955.93 755.54 80,357.14 commission 1,607.14 60,000.00 53,571.43 1,071.43 535.71 129,812.50 0.50% 649.06 99,507.50 88,845.98 444.23 204.83 29,464.29 2.00% 589.29 9,900.00 8,839.29 176.79 412.50 133,928.57 0.50% 669.64 150,000.00 133,928.57 669.64 7,142.86 2.00% 142.86 8,000.00 7,142.86 142.86 3,760.76 2.00% 75.22 4,212.05 3,760.76 75.22 291,785.71 2.00% 5,835.71 326,800.00 291,785.71 5,835.71 2,851.79 2.00% 57.04 3,194.00 2,851.79 57.04 687,500.00 2.00% 13,750.00 770,000.00 687,500.00 13,750.00 34,876.08 (3,487.61) (3,487.61) 27,900.87
P/
32,663.63 (3,266.36) (3,266.36) 26,130.90
2,212.45 (221.25) (221.25) 1,769.96
OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO. 1 2 3 4 5 6 7 8 9 10 11 12 13 14
PROJECT Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria
NET CM
79,705.11 0.00 135,077.99 19,918.03 64,812.69 26,873.29 69,618.97 5,547.59 34,228.57 3,948.86 1,735.76 154,443.71 3,948.86 41,277.75
Total Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Weight (%)CommissionCOLLECTED (Total) 2.00% 1,594.10 90.00% 2.00% 90.00% 2.00% 2,701.56 88.00% 2.00% 398.36 100.00 2.00% 1,296.25 84.00% 2.00% 537.47 66.00% 2.00% 1,392.38 66.00% 2.00% 110.95 30.00% 2.00% 684.57 100.00% 2.00% 78.98 100.00% 2.00% 34.72 100.00% 2.00% 3,088.87 100.00% 2.00% 78.98 100.00% 2.00% 825.56 100.00%
12,822.74 (1,282.27) (1,282.27) 10,258.19
CommissionCommission (based on CA) (remaining) 1,434.69 159.41 2,377.37 324.19 398.36 0.00 1,088.85 207.40 354.73 182.74 918.97 473.41 99.86 11.10 684.57 78.98 34.72 3,088.87 78.98 825.56 -
11,464.50 (1,146.45) (1,146.45) 9,171.60
1,358.24 (135.82) (135.82) 1,086.59
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
1 2 3 4 5 6 7 8 9 10 11 12 13 14
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria Total Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
NET CM 79,705.11 0.00 135,077.99 19,918.03 64,812.69 26,873.29 69,618.97 5,547.59 34,228.57 3,948.86 1,735.76 154,443.71 3,948.86 41,277.75
Weight (%)CommissionCOLLECTED (Total) 3.00% 2,391.15 90.00% 3.00% 90.00% 3.00% 4,052.34 88.00% 3.00% 597.54 100.00 3.00% 1,944.38 84.00% 3.00% 806.20 66.00% 3.00% 2,088.57 66.00% 3.00% 166.43 30.00% 3.00% 1,026.86 100.00% 3.00% 118.47 100.00% 3.00% 52.07 100.00% 3.00% 4,633.31 100.00% 3.00% 118.47 100.00% 3.00% 1,238.33 100.00% 17,995.78 (1,799.58) (1,799.58) 14,396.63
NOTE: PLDT/IEEI, Fortune Tobacco, F.R. sevilla/ Holy Angel - rectification/ on-going were not included in this commission scheme. elg/ 06.11.07
CommissionCommission (based on CA) (remaining) 2,152.04 239.12 3,566.06 486.28 597.54 1,633.28 311.10 532.09 274.11 1,378.46 710.11 49.93 116.50 1,026.86 118.47 52.07 4,633.31 118.47 1,238.33 17,096.90 (1,709.69) (1,709.69) 13,677.52
2,137.22 (213.72) (213.72) 1,709.77
ssion
ssion
ssion
Mark Anthony Alejo COMMISSION Option 1 COMMISSION BASED ON NET SALES NO.
PROJECT
Contract AmountNet Sales
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics
263,842.40 145,390.00 33,000.00 150,000.00
Total Commission less ewt Less : 10% reserved Fund Net Commission
235,573.57 129,812.50 29,464.29 133,928.57
Weight (%)Commission Collected Collected A.Commission Commission (Total) Amount less 12% VAT (based on CA) (remaining) 0.50% 1,177.87 221,532.14 197,796.55 988.98 188.89 2.00% 2,596.25 99,507.50 88,845.98 1,776.92 819.33 0.50% 147.32 9,900.00 8,839.29 44.20 103.13 33482.14% 2,678.57 150,000.00 133,928.57 2,678.57 -
6,600.01 (660.00) (660.00) 5,280.01
5,488.67 (548.87) (548.87) 4,390.94
1,111.34 (111.13) (111.13) 889.07
OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO.
PROJECT
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics
NET CM 64,812.69 69,618.97 5,547.59 34,228.57
Total Commission less ewt Less : 10% reserved Fund Net Commission
Weight (%) Commission COLLECTED (Total) (%) 2.00% 1,296.25 84.00% 2.00% 1,392.38 66.00% 2.00% 110.95 30.00% 2.00% 684.57 100.00% 2,799.58 (279.96) (279.96) 2,239.67
Commission Commission (based on CA)(remaining) 1,088.85 207.40 918.97 473.41 33.29 77.67 684.57 0.00 2,041.11 (204.11) (204.11) 1,632.89
758.48 (75.85) (75.85) 606.78
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics Total Commission less ewt Less : 10% reserved Fund Net Commission
NOTE: ** - implementation only elg/ 06.11.07
NET CM 64,812.69 69,618.97 5,547.59 34,228.57
Weight (%) Commission COLLECTED (Total) (%) 3.00% 1,944.38 84.00% 3.00% 2,088.57 66.00% 3.00% 166.43 30.00% 3.00% 1,026.86 100.00% 4,199.38 (419.94) (419.94) 3,359.50
Commission Commission (based on CA)(remaining) 1,633.28 311.10 1,378.46 710.11 49.93 116.50 1,026.86 0.00 3,061.66 (306.17) (306.17) 2,449.33
1,137.71 (113.77) (113.77) 910.17
mission aining)
mission
mission
Arvin J. Torres COMMISSION ( for approval) Option 1 COMMISSION BASED ON NET SALES NO. PROJECT Contract Amount Net sales Weight (%)Commission Collected Collected A.Commission Commission (Total) Amount (CA) less 12% Tax(based on CA)(remaining) 1 Ateneo Rockwell Plantbox #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 2 O.B. Montessorri 300,000.00 267,857.14 0.50% 1,339.29 300,000.00 267,857.14 1,339.29 3 Benson Yu 135,000.00 120,535.71 0.00% 602.68 135,000.00 120,535.71 602.68 4 Metro Stonerich 90,000.00 80,357.14 0.50% 401.79 60,000.00 53,571.43 267.86 133.93 5 Blue Torch Construction 145,390.00 129,812.50 ### 649.06 99,507.50 88,845.98 444.23 204.83 6 Redgold Logistics 150,000.00 133,928.57 0.50% 669.64 150,000.00 133,928.57 669.64 Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
P/
#REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF!
OPTION 2 COMMISSION BASED ON NET MARGIN (0.50%) NO. 1 2 3 4 5 6
PROJECT Ateneo Rockwell Plantbox O.B. Montessorri Benson Yu Metro Stonerich Blue Torch Construction Redgold Logistics
NET CM 79,705.11 135,077.99 19,918.03 26,873.29 69,618.97 34,228.57
Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Weight (%)Commission COLLECTED (Total) (%) 0.50% 398.53 90.00% 0.50% 675.39 88.00% 0.50% 99.59 100.00 0.50% 134.37 66.00% 0.50% 348.09 66.00% 0.50% 171.14 100.00%
P/
1,827.11 (195.76) (182.71) 1,448.64
Commission Commission (based on CA)(remaining) 358.67 39.85 594.34 81.05 99.59 88.68 45.68 229.74 118.35 171.14 1,542.17 (165.23) (154.22) 1,222.72
284.94 (30.53) (28.49) 225.91
OPTION 3 COMMISSION BASED ON NET MARGIN (1.00%) NO. 1 2 3 4 5 6
PROJECT Ateneo Rockwell Plantbox O.B. Montessorri Benson Yu Metro Stonerich Blue Torch Construction Redgold Logistics Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
elg/ 06.11.07
NET CM 79,705.11 135,077.99 19,918.03 26,873.29 69,618.97 34,228.57
Weight (%)Commission COLLECTED (Total) (%) 1.00% 797.05 90.00% 1.00% 1,350.78 88.00% 1.00% 199.18 100.00 1.00% 268.73 66.00% 1.00% 696.19 66.00% 1.00% 342.29 100.00%
P/
3,654.22 (391.52) (365.42) 2,897.27
Commission Commission (based on CA)(remaining) 717.35 79.71 1,188.69 162.09 199.18 177.36 91.37 459.49 236.70 342.29 3,084.35 (330.47) (308.43) 2,445.45
569.87 (61.06) (56.99) 451.83
mmission
mmission
mmission
HOUSE ACCOUNT (for Approval) Option 1 COMMISSION BASED ON NET SALES NO. 1 2 3 4 5 6 7
SALES Daruma Corp Double share Double Share Dos Palmas arreceffi Arch. Vincent Caisip Arch. Vincent Caisip Southcall Builders Inc.
Total contract Net Sales 39,000.00 24,000.00 8,000.00 326,800.00 8,000.00 8,000.00 9,000.00
21,428.57 21,428.57 7,142.86 291,785.71 7,142.86 7,142.86 8,035.71
Collected 39,000.00 24,000.00 8,000.00 326,800.00 8,000.00 8,000.00 9,000.00
Total Commission less Tax & VAT Net Commission
2%
1%
0.50%
428.57 428.57 142.86 5,835.71 142.86 142.86 160.71
214.29 214.29 71.43 2,917.86 71.43 71.43 80.36
107.14 107.14 35.71 1,458.93 35.71 35.71 40.18
7,282.14 (728.21) 6,553.93
3,641.07 (364.11) 3,276.96
1,820.54 (182.05) 1,638.48
Option 2 COMMISSION BASED ON NET MARGIN NO. 1 2 3 4 5 6 7
SALES Daruma Corp Double share Double Share Dos Palmas arreceffi Arch. Vincent Caisip Arch. Vincent Caisip Southcall Builders Inc. Total Commission less Tax & VAT Net Commission
elg/ 06.11.07
Net CM 11,846.57 1,769.64 8,343.87 3,948.86 4,841.71 398.57 209,670.53
Collected 100% 100% 100% 100% 100% 100% 100%
2%
1%
0.50%
236.93 35.39 166.88 78.98 96.83 7.97 4,193.41
118.47 17.70 83.44 39.49 48.42 3.99 2,096.71
59.23 8.85 41.72 19.74 24.21 1.99 1,048.35
4,816.39 (481.64) 4,334.76
2,408.20 (240.82) 2,167.38
1,204.10 (120.41) 1,083.69
Essel M. Calimoso - Commission (for Approval) COMMISSION BASED ON NET SALES NO. 1 2 3
PROJECT
Contract Amount Net SalesWeight (%) CommissionCollected Collected A. Commission Commission Commission (Total) Amount less 12% VAT(received)(based on CA) (remaining) Ateneo Rockwell Plantbox #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! O.B. Montessorri 300,000.00 267,857.14 2.00% 5,357.14 300,000.00 267,857.14 5,357.14 RSTI - Gaisano 680,658.76 607,731.04 ### 12,154.62 612,592.88 546,957.93 10,939.16 1,215.46 Commission less w/tax & VAT Net Commission
P/
#REF! #REF! #REF!
16,296.30 (1,629.63) 14,666.67
#REF! #REF! #REF!
Note : 1 EMC received commission for O.B. Montessori & RSTI amounting Php 13,976.29 (April 2007) 2 But now she have a commission for Ateneo Rockwell Plant boxes amounting Php 12,033.85 OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO. 1 2 3
PROJECT
NET CM
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri
79,705.11 0.00 135,077.99
Commission COLLECTED Weight (%) (Total) 2.00% 1,594.10 90.00% 2.00% 90.00% 2.00% 2,701.56 88.00%
Total Commission less w/tax & VAT Net Commission
4,295.66 (460.25) 3,835.41
Commission Commission (based on CA) (remaining) 1,434.69 159.41
1,434.69 (153.72) 1,280.97
159.41 (17.08) 142.33
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
NET CM
1 2 3
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri
79,705.11 0.00 135,077.99
CommissionCOLLECTED Weight (%) (Total) 3.00% 2,391.15 90.00% 3.00% 90.00% 3.00% 4,052.34 88.00%
Total Commission less w/tax & VAT Net Commission
6,443.49 (690.37) 5,753.12
Commission Commission (based on CA) (remaining) 2,152.04 239.12
2,152.04 (230.58) 1,921.46
239.12 (25.62) 213.50
elg/ 06.11.07
Raffy S. Dorado - Commission (for Approval) COMMISSION BASED ON NET SALES NO. 1
PROJECT RSTI - Gaisano Commission less w/tax & VAT Net Commission
Contract Amount Net salesWeight (%) CommissionCollected Collected A. Commission Commission (Total) Amount less 12% VAT (based on CA)(remaining) 680,658.76 607,731.04 0.50% 3,038.66 612,592.88 546,957.93 2,734.79 303.87
P/
3,038.66 (303.87) 2,734.79
2,734.79 (273.48) 2,461.31
303.87 (30.39) 273.48
#REF! #REF! #REF!
OPTION 2 COMMISSION BASED ON NET MARGIN (.50%) NO.
1
PROJECT
RSTI - Gaisano
NET CM
0.00
Total Commission less w/tax & VAT Net Commission
Commission COLLECTED Weight (%) (Total) 0.50%
-
90.00%
-
Commission Commission (based on CA) (remaining) -
-
0.00 0.00
0.00 0.00
OPTION 3 COMMISSION BASED ON NET MARGIN (1.00%) NO. 1
PROJECT RSTI - Gaisano Total Commission less w/tax & VAT Net Commission
elg/ 06.11.07
NET CM 0.00
CommissionCOLLECTED Weight (%) (Total) 1.00% 90.00% 0.00 0.00 0.00
Commission Commission (based on CA) (remaining) 0.00 0.00 0.00
0.00 0.00 0.00
ission ining)
COMMISSION/ INCENTIVE 1. METROSTONE RICH W/H TAX 9,642.86 Commission - based on Net sales GROSS SALES Collected (66.67%) 60,000.00 Uncollected (33.33%) 30,000.00 90,000.00 GROSS SALES 90,000.00
Commission based on Net Margin Collected (66%) 26,873.29 Uncollected (34%) 26,873.29
NET SALES 80,357.14 -
LABOR 14,725.45
NET SALES 53,571.43 26,785.71 80,357.14
MATERIALS 37,615.80
MISCELLANEOUS 1,142.60
2% PMD 1,071.43 535.71 1,607.14 % after Commission
NET CM 1% Com 17,736.37 177.36 9,136.92 91.37 26,873.29 268.73
2% Com 354.73 182.74 537.47
NET CM 26,873.29 -
% 33.44%
0.5% AJT 267.86 commission 133.93 remaining 401.79 30.94% 3% Com 532.09 274.11 806.20 total commission
2. RSTI - GAISANO W/H TAX 72,927.72
NET SALES 607,731.04
LABOR 14,900.00
MATERIALS 231,154.00
Commission - based on Net sales GROSS SALES COLLECTED (90%) 612,592.88 UNCOLLECTED (10%) 68,065.88
NET SALES 546,957.93 60,773.10
2% EMC 10,939.16 1,215.46
0.25% PMD 1,367.39 151.93
680,658.76
607,731.03
12,154.62
GROSS SALES 680,658.76
MISCELLANEOUS 25,781.41
NET CM 335,895.63
% 55.27%
0.25% MAA 1,367.39 commission 151.93 remaining
1,519.33 % after Commission
1,519.33 52.77%
Commission based on Net Margin 335,895.63 335,895.63
NET CM 302,306.06 33,589.56 335,895.63
1% Com 3,023.06 335.90 3,358.96
2% Com 6,046.12 671.79 6,717.91
W/H TAX 32,142.86
NET SALES 267,857.14
LABOR 13,241.33
MATERIALS 108,294.00
Commission - based on Net sales GROSS SALES Collected (100%) 300,000.00
NET SALES 267,857.14
300,000.00
267,857.14
2% EMC 5,357.14 5,357.14
0.25% PMD 669.64 669.64
NET CM 1% Com 135,077.99 1,350.78 135,077.99 1,350.78
2% Com 2,701.56
COLLECTED (90%) UNCOLLECTED (10%)
3% Com 9,069.18 1,007.69 10,076.87 total commission
3. O.B. MONTESSORI GROSS SALES 300,000.00
MISCELLANEOUS 11,243.82
NET CM 135,077.99
% 50.43%
0.25% AJT 669.64 commission 669.64 total commission % after Commission 47.93%
Commission based on Net Margin Collected (100%)
135,077.99
3% Com 4,052.34
2,701.56
4,052.34 total commission
4. BLUE TORCH CONSTRUCTION GROSS SALES 145,390.00
W/H TAX 15,577.50 Commission - based on Net sales GROSS SALES Collected (68.44%) 99,507.50 Uncollected (31.56) 45,882.50
NET SALES 129,812.50 -
LABOR 16,729.35
MATERIALS 41,073.19
NET SALES 88,845.98 40,966.52
2% (MAA) 1,776.92 819.33
0.25% PMD 222.11 102.42
145,390.00
129,812.50
2,596.25
MISCELLANEOUS 2,390.99
324.53
0.25% AJT 222.11 Commission 102.42 remaining 324.53 total commission
% after Commission
51.13%
Commission based on Net Margin NET CM
1% Com
2% Com
NET CM 69,618.97 -
3% Com
% 53.63%
Collected (68.44%) Uncollected (31.56)
69,618.97 69,618.97
47,647.22 21,971.75 69,618.97
476.47 219.72 696.19
952.94 439.43 1,392.38
W/H TAX 28,268.83 Commission - based on Net sales GROSS SALES Collected (84%) 221,532.14 Uncollected (16%) 42,310.26 263,842.40
NET SALES 235,573.57 -
LABOR 16,789.50
MATERIALS 148,965.00
NET SALES 197,796.55 37,777.02 235,573.57
2% PMD 3,955.93 755.54 4,711.47
0.25% MAA 494.49 94.44 588.93
1,429.42 659.15 2,088.57 total commission
5. LEGEND HOTELS - KALOOKAN GROSS SALES 263,842.40
MISCELLANEOUS 6,544.88
NET CM 63,274.19 -
% 26.86%
0.25% RSD 494.49 commission 94.44 remaining 588.93 total commission
% after Commission
24.36%
Commission based on Net Margin Collected (84%) Uncollected (16%)
63,274.19 63,274.19
NET CM 1% Com 53,150.32 531.50 10,123.87 101.24 63,274.19 632.74
2% Com 1,063.01 202.48 1,265.48
3% Com 1,594.51 303.72 1,898.23 total commission
6. DO ALL METAL/ PEARL OF THE ORIENT/ CONSTECH GROSS SALES 33,000.00
W/H TAX NET SALES 3,535.71 29,464.29 Commission - based on Net sales GROSS SALES NET SALES Collected (30%) 9,900.00 8,839.29 Uncollected (70%) 23,100.00 20,625.00 33,000.00 29,464.29
LABOR 4,147.70
MATERIALS 18,546.00
MISCELLANEOUS 1,223.00
NET CM 5,547.59 -
% 18.83%
2% PMD 0.50% MAA 176.79 44.20 commission 412.50 103.13 remaining total commission 589.29 147.32 % after Commission 16.33%
Commission based on Net Margin NET CM 1,664.28 3,883.31 5,547.59
1% of CM 16.64 38.83 55.48
2% Com 33.29 77.67 110.95
W/H TAX 14,464.29 Commission - based on Net sales GROSS SALES Collected (100%)) 135,000.00
NET SALES 120,535.71 -
LABOR 27,298.56
MATERIALS 67,048.53
135,000.00
120,535.71
Collected (30%) Uncollected (70%)
5,547.59 5,547.59
3% Com 49.93 commission 116.50 remaining 166.43 total commission
7. MR. BENSON YU GROSS SALES 135,000.00
NET SALES 120,535.71
MISCELLANEOUS 6,270.60
2% PMD 2,410.71
0.25% AJT 301.34
2,410.71 % after Commission
301.34
NET CM 19,918.02 -
% 16.52%
commission total commission 14.02%
Commission based on Net Margin Collected (100%)
19,918.02
NET CM 1% Com 19,918.02 199.18
2% Com 398.36
3% Com 597.54
19,918.02
19,918.02
199.18
398.36
597.54 total commission
W/H TAX 16,071.43 Commission - based on Net sales GROSS SALES
NET SALES 133,928.57 -
LABOR 15,690.00
MATERIALS 83,810.00
MISCELLANEOUS 2,500.00
NET SALES
2% MAA
0.25% PMD
0.25% AJT
8. REDGOLD LOGISTICS GROSS SALES 150,000.00
NET CM 34,228.57 -
% 25.56%
Collected (100%)
150,000.00
133,928.57
2,678.57
150,000.00
133,928.57
2,678.57
34,228.57
NET CM 34,228.57
1% Com 342.29
2% Com 684.57
34,228.57
34,228.57
342.29
684.57
W/H TAX 5,705.36 Commission - based on Net sales GROSS SALES Collected (56.25%) 29,955.36 Uncollected (43.75) 23,294.64 53,250.00
NET SALES 47,544.64 -
LABOR 13,154.65
MATERIALS 11,081.00
NET SALES 26,745.86 20,798.79 47,544.64
2% MAA 534.92 415.98 950.89
NET CM 19,736.29 19,736.29 19,736.29
1% Com 197.36
2% Com 394.73
197.36
394.73
334.82 commission
334.82 334.82 % after Commission
334.82 total commission 23.06%
Commission based on Net Margin Collected (100%)
3% Com 1,026.86 1,026.86 total commission
9. PLDT/ IEEI GROSS SALES 53,250.00
MISCELLANEOUS 3,572.70
NET CM 19,736.29 -
% 41.51%
0.25% PMD 0.25% AJT 66.86 66.86 Commission 52.00 52.00 Remaining total commission 118.86 118.86 % after Commission 39.01%
Commission based on Net Margin Collected (56.25%) Uncollected (43.75)
19,736.29 19,736.29 19,736.29
3% Com 592.09 commission 592.09 total commission
10. MONOLITH - LANDMARK CONTRACT AMOUNT 108,477.42
W/H TAX 11,622.58 Commission - based on Net sales AMOUNT Collected (89.64) 97,239.97 Uncollected (10.36%) 11,237.45 108,477.42
NET SALES 96,854.84 NET SALES 86,821.40 10,033.44 96,854.84
LABOR MATERIALS MISCELLANEOUS 13,275.17 12,522.00 12,504.22
2% PMD 1,736.43 200.67 1,937.10 NET CM after Commission
0.5% AJT 434.11 50.17 484.27 57.95%
Commission based on Net Margin Collected (89.64) Uncollected (10.36%)
NET CM 58,553.45 -
1% 52,487.31 6,066.14 58,553.45
2% 1,049.75 121.32 1,171.07
3% 1,574.62 Commission 181.98 Remaining 1,756.60 total commission
NET CM 58,553.45 -
% 60.45%
Commission Remaining total commission
9. FORTUNE TOBACCO CONTRACT AMOUNT 3,308,500.00
W/H TAX 354,482.14 Commission - based on Net sales AMOUNT Collected (88.39) 2,924,477.67 Uncollected (11.61%) 384,022.33 3,308,500.00
NET SALES 2,954,017.86 NET SALES 2,611,140.78 342,877.08 2,954,017.86
Commission based on Net Margin 1,343,604.88
LABOR MATERIALS MISCELLANEOUS 138,008.22 1,826,886.90 94,378.00
2% PMD 52,222.82 6,857.54 59,080.36 NET CM after Commission
NET CM ### -
% 40.61%
0.5% MAA 13,055.70 1,714.39 14,770.09 total commission 38.11%
88.39% of CM 1,187,612.35
2% Com 23,752.25
3% Com 35,628.37
LABOR 145,708.74
MATERIALS 482,457.62
MISCELLANEOUS 18,055.89
8. ROBINSONS GALLERIA GROSS SALES 770,000.00
W/H TAX 82,500.00 Commission - based on Net sales GROSS SALES Collected (100%) 770,000.00
NET SALES 687,500.00 NET SALES 687,500.00
770,000.00
687,500.00
NET CM 41,277.75 -
2% Com PMD 13,750.00 13,750.00 % after Commission
-
total commission 4.00%
Commission based on Net Margin Collected (100%)
41,277.75
NET CM 41,277.75
1% Com 412.78
2% Com 825.56
41,277.75
41,277.75
412.78
825.56
3% Com 1,238.33 1,238.33 total commission
% 6.00%
Commission/ Incentive
PMD Commission
Total contract
Collected
Legend Hotels - kalookan 263,842.40 Benson Yu 135,000.00 Fortune Tobacco Corp 2,200.00 Clean Living / Armadillo 4,250.00 Kalinisan/ Armadillo 2,025.00
221,532.14 135,000.00 2,200.00 4,250.00 2,025.00
F.R. Sevilla PU Pipe Fab. 59,745.13 (Overriding Commission) O.B. Montessorri 300,000.00 Redgold Logistics 150,000.00 PLDT/ IEEI 53,250.00
59,745.13 300,000.00 150,000.00 53,250.00
Net Collected Margin (CM) Com Received 2% Net collected 197,796.55 63,274.19 3,955.93 120,535.71 19,918.02 2,410.71 1,964.29 1,064.29 39.29 3,794.64 1,769.64 75.89 1,808.04 1,735.76 36.16 1% Net Collected 53,343.87 8,343.87 533.44 .25% Net Collected 267,857.14 135,077.99 669.64 133,928.57 34,228.57 334.82 47,544.64 19,736.29 118.86 P/
Less :w/h tax Total Less :10% reserved fund Net Commission MAA Commission
P/ TOTAL
Total contract
Redgold Logistics 150,000.00 PLDT/IEEI 53,250.00 Implementation Legend Hotels - kalookan 263,842.40
Collected 150,000.00 53,250.00 221,532.14
Net Collected Margin (CM) Com Received 2% net collected 133,928.57 34,228.57 2,678.57 47,544.64 19,736.29 950.89 .25% Net Collected 197,796.55 63,274.19 494.49 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
AJT Commission Implementation Benson Yu Redgold Logistics PLDT/IEEI O.B. Montessorri
Total contract 135,000.00 150,000.00 53,250.00 300,000.00
Collected 135,000.00 150,000.00 53,250.00 300,000.00
Net Collected Margin (CM) Com Received .25% Net Collected 120,535.71 19,918.02 301.34 133,928.57 34,228.57 334.82 47,544.64 19,736.29 118.86 267,857.14 135,077.99 669.64 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
HOUSE ACCOUNT
Total contract
Daruma Corp. Double Share Dos Palmas Arreceffi Arch Vincent Caisip Southcall Builders
39,000.00 32,000.00 326,800.00 16,000.00 9,000.00
Collected 39,000.00 32,000.00 326,800.00 16,000.00 9,000.00
Net Collected Margin (CM) Com Received 2% Net Collected 34,821.43 13379.83 696.43 28,571.43 15795.43 571.43 291,785.71 154443.71 5,835.71 14,285.71 7897.72 285.71 8,035.71 4841.71 160.71 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
TOTAL COMMISSION Commission/Incentive Less: PMD Cash Advance For Check Preparation
P/
Prepared by:
Approved by:
Eugene L. Galanao
G.S. Correa
Note: PMD cash Advance less Payment Mode
Balance
P/ partial pay com 12/11/06 com 01/30/07 com 02/09/07 com 07/02/07
17,231.43 (3,500.00) 13,731.43
45,000.00 (15,000.00) (6,219.07) (5,550.23) (8,857.63) (3,000.00) 6,373.07
TOTAL 3,955.93 2,410.71 39.29 75.89 36.16 533.44 669.64 334.82 118.86 8,174.75 (817.47) 7,357.27 (735.73) 6,621.55 TOTAL 2,678.57 950.89 494.49 4,123.96 (412.40) 3,711.56 (371.16) 3,340.40 TOTAL 301.34 334.82 118.86 669.64 1,424.67 (142.47) 1,282.20 (128.22) 1,153.98 TOTAL 696.43 571.43 5,835.71 285.71 160.71 7,550.00 (755.00) 6,795.00 (679.50) 6,115.50 17,231.43
RSTI - GAISANO Gross Sales
479,964.76 107,094.00 93,600.00 680,658.76
Net sales w/o Tax
428,539.96 95,619.64 83,571.43 607,731.04
Labor Cost
13,053.80
Commission Based on Net Sales LESS TAX AND VAT total commission COLLECTED 612,592.88 546,957.93 68,065.88 60,773.11 UNCOLLECTED TOTAL COMMISSION
Materials Cost Miscellaneous
231,154.00
25,781.41
CM w/ TAX
410,669.55
%
60.33%
337,741.83 COLLECTED 90.00% UNCOLLECTD 10.00% commssion based on collected amount
337,741.83
%
55.57%
Distribution of Com 0.5% com 2% com 2.0% Essel 3,038.66 12,154.62 0.5% PMD commission based on collected amount 90.00% 2,734.79 10,939.16 10.00% 303.87 1,215.46 3,038.66 12,154.62 Net margin afterw/h tax less commission
Commission Based on Net Margin
CM w/o TAX
0.5% com 1,688.71 1,519.84 168.87 1,688.71
2% com 6,754.84 6,079.35 675.48 6,754.84
53.07%
3% com 5% 10,132.25 16,887.09 9,119.03 15,198.38 1,013.23 1,688.71 10,132.25 16,887.09
O.B.MONTESORRI Gross Sales
300,000.00
Net sales w/o Tax
267,857.14
Labor Cost
13,241.33
Materials Cost Miscellaneous
108,294.00
Commission Based on Net Sales
COLLECTED UNCOLLECTED
TOTAL
Err:522 36,000.00 300,000.00
total commission Err:522 88.00% 32,142.86 12.00% 267,857.14 100.00%
11,243.82
0.5% com 1,339.29 1,178.57 160.71 1,339.29
CM w/ TAX
167,220.85
%
55.74%
2% com 5,357.14
0.5% com
2% com
135,077.99
4,714.29 642.86 5,357.14
3% com
%
50.43%
Distribution of Com 2.0% Essel 0.5% PMD
Net margin afterw/h tax less commission Commission Based on Net Margin
CM w/o TAX
47.93% 5%
135,077.99 COLLECTED UNCOLLECTED total commission
88.00% 12.00%
675.39 599.75 75.64 675.39
2,701.56 2,377.37 324.19 2,701.56
4,052.34 3,566.06 486.28 4,052.34
6,753.90 5,943.43 810.47 6,753.90
Paul M.Diaz de Rivera COMMISSION Option 1 COMMISSION BASED ON NET SALES NO. 2 3 4 5 6 7 8 9 10 11 12 13 14
PROJECT
Contract Amount
RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria
680,658.76 300,000.00 135,000.00 263,842.40 90,000.00 145,390.00 33,000.00 150,000.00 8,000.00 4,212.05 326,800.00 3,194.00 770,000.00
Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Net Sales Weight (%)Commission Collected Collected A. CommissionCommission (Total) Amount less 12% VAT (based on CA) (remaining) 607,731.04 0.05% 3,038.66 612,592.88 546,957.93 2,734.79 303.87 267,857.14 0.50% 1,339.29 300,000.00 267,857.14 1,339.29 120,535.71 2.00% 2,410.71 135,000.00 120,535.71 2,410.71 235,573.57 2.00% 4,711.47 221,532.14 197,796.55 3,955.93 755.54 80,357.14 commission 1,607.14 60,000.00 53,571.43 1,071.43 535.71 129,812.50 0.50% 649.06 99,507.50 88,845.98 444.23 204.83 29,464.29 2.00% 589.29 9,900.00 8,839.29 176.79 412.50 133,928.57 0.50% 669.64 150,000.00 133,928.57 669.64 7,142.86 2.00% 142.86 8,000.00 7,142.86 142.86 3,760.76 2.00% 75.22 4,212.05 3,760.76 75.22 291,785.71 2.00% 5,835.71 326,800.00 291,785.71 5,835.71 2,851.79 2.00% 57.04 3,194.00 2,851.79 57.04 687,500.00 2.00% 13,750.00 770,000.00 687,500.00 13,750.00 34,876.08 (3,487.61) (3,487.61) 27,900.87
P/
32,663.63 (3,266.36) (3,266.36) 26,130.90
2,212.45 (221.25) (221.25) 1,769.96
OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO. 1 2 3 4 5 6 7 8 9 10 11 12 13 14
PROJECT Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria
NET CM
79,705.11 0.00 135,077.99 19,918.03 64,812.69 26,873.29 69,618.97 5,547.59 34,228.57 3,948.86 1,735.76 154,443.71 3,948.86 41,277.75
Total Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Weight (%)CommissionCOLLECTED (Total) 2.00% 1,594.10 90.00% 2.00% 90.00% 2.00% 2,701.56 88.00% 2.00% 398.36 100.00 2.00% 1,296.25 84.00% 2.00% 537.47 66.00% 2.00% 1,392.38 66.00% 2.00% 110.95 30.00% 2.00% 684.57 100.00% 2.00% 78.98 100.00% 2.00% 34.72 100.00% 2.00% 3,088.87 100.00% 2.00% 78.98 100.00% 2.00% 825.56 100.00%
12,822.74 (1,282.27) (1,282.27) 10,258.19
CommissionCommission (based on CA) (remaining) 1,434.69 159.41 2,377.37 324.19 398.36 0.00 1,088.85 207.40 354.73 182.74 918.97 473.41 99.86 11.10 684.57 78.98 34.72 3,088.87 78.98 825.56 -
11,464.50 (1,146.45) (1,146.45) 9,171.60
1,358.24 (135.82) (135.82) 1,086.59
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
1 2 3 4 5 6 7 8 9 10 11 12 13 14
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri Benson Yu Legend Hotels - kalookan Metro Stonerich Blue Torch Construction Do all Metal Redgold Logistics Double Share Kalinisan/ Armadillo Dos Palmas arreceffi Arch. Vincent Caisip Robinsons Galleria Total Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
NET CM 79,705.11 0.00 135,077.99 19,918.03 64,812.69 26,873.29 69,618.97 5,547.59 34,228.57 3,948.86 1,735.76 154,443.71 3,948.86 41,277.75
Weight (%)CommissionCOLLECTED (Total) 3.00% 2,391.15 90.00% 3.00% 90.00% 3.00% 4,052.34 88.00% 3.00% 597.54 100.00 3.00% 1,944.38 84.00% 3.00% 806.20 66.00% 3.00% 2,088.57 66.00% 3.00% 166.43 30.00% 3.00% 1,026.86 100.00% 3.00% 118.47 100.00% 3.00% 52.07 100.00% 3.00% 4,633.31 100.00% 3.00% 118.47 100.00% 3.00% 1,238.33 100.00% 17,995.78 (1,799.58) (1,799.58) 14,396.63
NOTE: PLDT/IEEI, Fortune Tobacco, F.R. sevilla/ Holy Angel - rectification/ on-going were not included in this commission scheme. elg/ 06.11.07
CommissionCommission (based on CA) (remaining) 2,152.04 239.12 3,566.06 486.28 597.54 1,633.28 311.10 532.09 274.11 1,378.46 710.11 49.93 116.50 1,026.86 118.47 52.07 4,633.31 118.47 1,238.33 17,096.90 (1,709.69) (1,709.69) 13,677.52
2,137.22 (213.72) (213.72) 1,709.77
ssion
ssion
ssion
Mark Anthony Alejo COMMISSION Option 1 COMMISSION BASED ON NET SALES NO.
PROJECT
Contract AmountNet Sales
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics
263,842.40 145,390.00 33,000.00 150,000.00
Total Commission less ewt Less : 10% reserved Fund Net Commission
235,573.57 129,812.50 29,464.29 133,928.57
Weight (%)Commission Collected Collected A.Commission Commission (Total) Amount less 12% VAT (based on CA) (remaining) 0.50% 1,177.87 221,532.14 197,796.55 988.98 188.89 2.00% 2,596.25 99,507.50 88,845.98 1,776.92 819.33 0.50% 147.32 9,900.00 8,839.29 44.20 103.13 33482.14% 2,678.57 150,000.00 133,928.57 2,678.57 -
6,600.01 (660.00) (660.00) 5,280.01
5,488.67 (548.87) (548.87) 4,390.94
1,111.34 (111.13) (111.13) 889.07
OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO.
PROJECT
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics
NET CM 64,812.69 69,618.97 5,547.59 34,228.57
Total Commission less ewt Less : 10% reserved Fund Net Commission
Weight (%) Commission COLLECTED (Total) (%) 2.00% 1,296.25 84.00% 2.00% 1,392.38 66.00% 2.00% 110.95 30.00% 2.00% 684.57 100.00% 2,799.58 (279.96) (279.96) 2,239.67
Commission Commission (based on CA)(remaining) 1,088.85 207.40 918.97 473.41 33.29 77.67 684.57 0.00 2,041.11 (204.11) (204.11) 1,632.89
758.48 (75.85) (75.85) 606.78
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
1 2 3 4
Legend Hotels - kalookan ** Blue Torch Construction Do all Metal ** Redgold Logistics Total Commission less ewt Less : 10% reserved Fund Net Commission
NOTE: ** - implementation only elg/ 06.11.07
NET CM 64,812.69 69,618.97 5,547.59 34,228.57
Weight (%) Commission COLLECTED (Total) (%) 3.00% 1,944.38 84.00% 3.00% 2,088.57 66.00% 3.00% 166.43 30.00% 3.00% 1,026.86 100.00% 4,199.38 (419.94) (419.94) 3,359.50
Commission Commission (based on CA)(remaining) 1,633.28 311.10 1,378.46 710.11 49.93 116.50 1,026.86 0.00 3,061.66 (306.17) (306.17) 2,449.33
1,137.71 (113.77) (113.77) 910.17
mission aining)
mission
mission
Arvin J. Torres COMMISSION ( for approval) Option 1 COMMISSION BASED ON NET SALES NO. PROJECT Contract Amount Net sales Weight (%)Commission Collected Collected A.Commission Commission (Total) Amount (CA) less 12% Tax(based on CA)(remaining) 1 Ateneo Rockwell Plantbox #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 2 O.B. Montessorri 300,000.00 267,857.14 0.50% 1,339.29 300,000.00 267,857.14 1,339.29 3 Benson Yu 135,000.00 120,535.71 0.00% 602.68 135,000.00 120,535.71 602.68 4 Metro Stonerich 90,000.00 80,357.14 0.50% 401.79 60,000.00 53,571.43 267.86 133.93 5 Blue Torch Construction 145,390.00 129,812.50 ### 649.06 99,507.50 88,845.98 444.23 204.83 6 Redgold Logistics 150,000.00 133,928.57 0.50% 669.64 150,000.00 133,928.57 669.64 Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
P/
#REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF!
OPTION 2 COMMISSION BASED ON NET MARGIN (0.50%) NO. 1 2 3 4 5 6
PROJECT Ateneo Rockwell Plantbox O.B. Montessorri Benson Yu Metro Stonerich Blue Torch Construction Redgold Logistics
NET CM 79,705.11 135,077.99 19,918.03 26,873.29 69,618.97 34,228.57
Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
Weight (%)Commission COLLECTED (Total) (%) 0.50% 398.53 90.00% 0.50% 675.39 88.00% 0.50% 99.59 100.00 0.50% 134.37 66.00% 0.50% 348.09 66.00% 0.50% 171.14 100.00%
P/
1,827.11 (195.76) (182.71) 1,448.64
Commission Commission (based on CA)(remaining) 358.67 39.85 594.34 81.05 99.59 88.68 45.68 229.74 118.35 171.14 1,542.17 (165.23) (154.22) 1,222.72
284.94 (30.53) (28.49) 225.91
OPTION 3 COMMISSION BASED ON NET MARGIN (1.00%) NO. 1 2 3 4 5 6
PROJECT Ateneo Rockwell Plantbox O.B. Montessorri Benson Yu Metro Stonerich Blue Torch Construction Redgold Logistics Commission less w/tax & VAT Less : 10% reserved Fund Net Commission
elg/ 06.11.07
NET CM 79,705.11 135,077.99 19,918.03 26,873.29 69,618.97 34,228.57
Weight (%)Commission COLLECTED (Total) (%) 1.00% 797.05 90.00% 1.00% 1,350.78 88.00% 1.00% 199.18 100.00 1.00% 268.73 66.00% 1.00% 696.19 66.00% 1.00% 342.29 100.00%
P/
3,654.22 (391.52) (365.42) 2,897.27
Commission Commission (based on CA)(remaining) 717.35 79.71 1,188.69 162.09 199.18 177.36 91.37 459.49 236.70 342.29 3,084.35 (330.47) (308.43) 2,445.45
569.87 (61.06) (56.99) 451.83
mmission
mmission
mmission
HOUSE ACCOUNT (for Approval) Option 1 COMMISSION BASED ON NET SALES NO. 1 2 3 4 5 6 7
SALES Daruma Corp Double share Double Share Dos Palmas arreceffi Arch. Vincent Caisip Arch. Vincent Caisip Southcall Builders Inc.
Total contract Net Sales 39,000.00 24,000.00 8,000.00 326,800.00 8,000.00 8,000.00 9,000.00
21,428.57 21,428.57 7,142.86 291,785.71 7,142.86 7,142.86 8,035.71
Collected 39,000.00 24,000.00 8,000.00 326,800.00 8,000.00 8,000.00 9,000.00
Total Commission less Tax & VAT Net Commission
2%
1%
0.50%
428.57 428.57 142.86 5,835.71 142.86 142.86 160.71
214.29 214.29 71.43 2,917.86 71.43 71.43 80.36
107.14 107.14 35.71 1,458.93 35.71 35.71 40.18
7,282.14 (728.21) 6,553.93
3,641.07 (364.11) 3,276.96
1,820.54 (182.05) 1,638.48
Option 2 COMMISSION BASED ON NET MARGIN NO. 1 2 3 4 5 6 7
SALES Daruma Corp Double share Double Share Dos Palmas arreceffi Arch. Vincent Caisip Arch. Vincent Caisip Southcall Builders Inc. Total Commission less Tax & VAT Net Commission
elg/ 06.11.07
Net CM 11,846.57 1,769.64 8,343.87 3,948.86 4,841.71 398.57 209,670.53
Collected 100% 100% 100% 100% 100% 100% 100%
2%
1%
0.50%
236.93 35.39 166.88 78.98 96.83 7.97 4,193.41
118.47 17.70 83.44 39.49 48.42 3.99 2,096.71
59.23 8.85 41.72 19.74 24.21 1.99 1,048.35
4,816.39 (481.64) 4,334.76
2,408.20 (240.82) 2,167.38
1,204.10 (120.41) 1,083.69
Essel M. Calimoso - Commission (for Approval) COMMISSION BASED ON NET SALES NO. 1 2 3
PROJECT
Contract Amount Net SalesWeight (%) CommissionCollected Collected A. Commission Commission Commission (Total) Amount less 12% VAT(received)(based on CA) (remaining) Ateneo Rockwell Plantbox #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! O.B. Montessorri 300,000.00 267,857.14 2.00% 5,357.14 300,000.00 267,857.14 5,357.14 RSTI - Gaisano 680,658.76 607,731.04 ### 12,154.62 612,592.88 546,957.93 10,939.16 1,215.46 Commission less w/tax & VAT Net Commission
P/
#REF! #REF! #REF!
16,296.30 (1,629.63) 14,666.67
#REF! #REF! #REF!
Note : 1 EMC received commission for O.B. Montessori & RSTI amounting Php 13,976.29 (April 2007) 2 But now she have a commission for Ateneo Rockwell Plant boxes amounting Php 12,033.85 OPTION 2 COMMISSION BASED ON NET MARGIN (2.00%) NO. 1 2 3
PROJECT
NET CM
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri
79,705.11 0.00 135,077.99
Commission COLLECTED Weight (%) (Total) 2.00% 1,594.10 90.00% 2.00% 90.00% 2.00% 2,701.56 88.00%
Total Commission less w/tax & VAT Net Commission
4,295.66 (460.25) 3,835.41
Commission Commission (based on CA) (remaining) 1,434.69 159.41
1,434.69 (153.72) 1,280.97
159.41 (17.08) 142.33
OPTION 3 COMMISSION BASED ON NET MARGIN (3.00%) NO.
PROJECT
NET CM
1 2 3
Ateneo Rockwell Plantbox RSTI - Gaisano O.B. Montessorri
79,705.11 0.00 135,077.99
CommissionCOLLECTED Weight (%) (Total) 3.00% 2,391.15 90.00% 3.00% 90.00% 3.00% 4,052.34 88.00%
Total Commission less w/tax & VAT Net Commission
6,443.49 (690.37) 5,753.12
Commission Commission (based on CA) (remaining) 2,152.04 239.12
2,152.04 (230.58) 1,921.46
239.12 (25.62) 213.50
elg/ 06.11.07
Raffy S. Dorado - Commission (for Approval) COMMISSION BASED ON NET SALES NO. 1
PROJECT RSTI - Gaisano Commission less w/tax & VAT Net Commission
Contract Amount Net salesWeight (%) CommissionCollected Collected A. Commission Commission (Total) Amount less 12% VAT (based on CA)(remaining) 680,658.76 607,731.04 0.50% 3,038.66 612,592.88 546,957.93 2,734.79 303.87
P/
3,038.66 (303.87) 2,734.79
2,734.79 (273.48) 2,461.31
303.87 (30.39) 273.48
#REF! #REF! #REF!
OPTION 2 COMMISSION BASED ON NET MARGIN (.50%) NO.
1
PROJECT
RSTI - Gaisano
NET CM
0.00
Total Commission less w/tax & VAT Net Commission
Commission COLLECTED Weight (%) (Total) 0.50%
-
90.00%
-
Commission Commission (based on CA) (remaining) -
-
0.00 0.00
0.00 0.00
OPTION 3 COMMISSION BASED ON NET MARGIN (1.00%) NO. 1
PROJECT RSTI - Gaisano Total Commission less w/tax & VAT Net Commission
elg/ 06.11.07
NET CM 0.00
CommissionCOLLECTED Weight (%) (Total) 1.00% 90.00% 0.00 0.00 0.00
Commission Commission (based on CA) (remaining) 0.00 0.00 0.00
0.00 0.00 0.00
ission ining)
COMMISSION/ INCENTIVE 1. METROSTONE RICH W/H TAX 9,642.86 Commission - based on Net sales GROSS SALES Collected (66.67%) 60,000.00 Uncollected (33.33%) 30,000.00 90,000.00 GROSS SALES 90,000.00
Commission based on Net Margin Collected (66%) 26,873.29 Uncollected (34%) 26,873.29
NET SALES 80,357.14 -
LABOR 14,725.45
NET SALES 53,571.43 26,785.71 80,357.14
MATERIALS 37,615.80
MISCELLANEOUS 1,142.60
2% PMD 1,071.43 535.71 1,607.14 % after Commission
NET CM 1% Com 17,736.37 177.36 9,136.92 91.37 26,873.29 268.73
2% Com 354.73 182.74 537.47
NET CM 26,873.29 -
% 33.44%
0.5% AJT 267.86 commission 133.93 remaining 401.79 30.94% 3% Com 532.09 274.11 806.20 total commission
2. RSTI - GAISANO W/H TAX 72,927.72
NET SALES 607,731.04
LABOR 14,900.00
MATERIALS 231,154.00
Commission - based on Net sales GROSS SALES COLLECTED (90%) 612,592.88 UNCOLLECTED (10%) 68,065.88
NET SALES 546,957.93 60,773.10
2% EMC 10,939.16 1,215.46
0.25% PMD 1,367.39 151.93
680,658.76
607,731.03
12,154.62
GROSS SALES 680,658.76
MISCELLANEOUS 25,781.41
NET CM 335,895.63
% 55.27%
0.25% MAA 1,367.39 commission 151.93 remaining
1,519.33 % after Commission
1,519.33 52.77%
Commission based on Net Margin 335,895.63 335,895.63
NET CM 302,306.06 33,589.56 335,895.63
1% Com 3,023.06 335.90 3,358.96
2% Com 6,046.12 671.79 6,717.91
W/H TAX 32,142.86
NET SALES 267,857.14
LABOR 13,241.33
MATERIALS 108,294.00
Commission - based on Net sales GROSS SALES Collected (100%) 300,000.00
NET SALES 267,857.14
300,000.00
267,857.14
2% EMC 5,357.14 5,357.14
0.25% PMD 669.64 669.64
NET CM 1% Com 135,077.99 1,350.78 135,077.99 1,350.78
2% Com 2,701.56
COLLECTED (90%) UNCOLLECTED (10%)
3% Com 9,069.18 1,007.69 10,076.87 total commission
3. O.B. MONTESSORI GROSS SALES 300,000.00
MISCELLANEOUS 11,243.82
NET CM 135,077.99
% 50.43%
0.25% AJT 669.64 commission 669.64 total commission % after Commission 47.93%
Commission based on Net Margin Collected (100%)
135,077.99
3% Com 4,052.34
2,701.56
4,052.34 total commission
4. BLUE TORCH CONSTRUCTION GROSS SALES 145,390.00
W/H TAX 15,577.50 Commission - based on Net sales GROSS SALES Collected (68.44%) 99,507.50 Uncollected (31.56) 45,882.50
NET SALES 129,812.50 -
LABOR 16,729.35
MATERIALS 41,073.19
NET SALES 88,845.98 40,966.52
2% (MAA) 1,776.92 819.33
0.25% PMD 222.11 102.42
145,390.00
129,812.50
2,596.25
MISCELLANEOUS 2,390.99
324.53
0.25% AJT 222.11 Commission 102.42 remaining 324.53 total commission
% after Commission
51.13%
Commission based on Net Margin NET CM
1% Com
2% Com
NET CM 69,618.97 -
3% Com
% 53.63%
Collected (68.44%) Uncollected (31.56)
69,618.97 69,618.97
47,647.22 21,971.75 69,618.97
476.47 219.72 696.19
952.94 439.43 1,392.38
W/H TAX 28,268.83 Commission - based on Net sales GROSS SALES Collected (84%) 221,532.14 Uncollected (16%) 42,310.26 263,842.40
NET SALES 235,573.57 -
LABOR 16,789.50
MATERIALS 148,965.00
NET SALES 197,796.55 37,777.02 235,573.57
2% PMD 3,955.93 755.54 4,711.47
0.25% MAA 494.49 94.44 588.93
1,429.42 659.15 2,088.57 total commission
5. LEGEND HOTELS - KALOOKAN GROSS SALES 263,842.40
MISCELLANEOUS 6,544.88
NET CM 63,274.19 -
% 26.86%
0.25% RSD 494.49 commission 94.44 remaining 588.93 total commission
% after Commission
24.36%
Commission based on Net Margin Collected (84%) Uncollected (16%)
63,274.19 63,274.19
NET CM 1% Com 53,150.32 531.50 10,123.87 101.24 63,274.19 632.74
2% Com 1,063.01 202.48 1,265.48
3% Com 1,594.51 303.72 1,898.23 total commission
6. DO ALL METAL/ PEARL OF THE ORIENT/ CONSTECH GROSS SALES 33,000.00
W/H TAX NET SALES 3,535.71 29,464.29 Commission - based on Net sales GROSS SALES NET SALES Collected (30%) 9,900.00 8,839.29 Uncollected (70%) 23,100.00 20,625.00 33,000.00 29,464.29
LABOR 4,147.70
MATERIALS 18,546.00
MISCELLANEOUS 1,223.00
NET CM 5,547.59 -
% 18.83%
2% PMD 0.50% MAA 176.79 44.20 commission 412.50 103.13 remaining total commission 589.29 147.32 % after Commission 16.33%
Commission based on Net Margin NET CM 1,664.28 3,883.31 5,547.59
1% of CM 16.64 38.83 55.48
2% Com 33.29 77.67 110.95
W/H TAX 14,464.29 Commission - based on Net sales GROSS SALES Collected (100%)) 135,000.00
NET SALES 120,535.71 -
LABOR 27,298.56
MATERIALS 67,048.53
135,000.00
120,535.71
Collected (30%) Uncollected (70%)
5,547.59 5,547.59
3% Com 49.93 commission 116.50 remaining 166.43 total commission
7. MR. BENSON YU GROSS SALES 135,000.00
NET SALES 120,535.71
MISCELLANEOUS 6,270.60
2% PMD 2,410.71
0.25% AJT 301.34
2,410.71 % after Commission
301.34
NET CM 19,918.02 -
% 16.52%
commission total commission 14.02%
Commission based on Net Margin Collected (100%)
19,918.02
NET CM 1% Com 19,918.02 199.18
2% Com 398.36
3% Com 597.54
19,918.02
19,918.02
199.18
398.36
597.54 total commission
W/H TAX 16,071.43 Commission - based on Net sales GROSS SALES
NET SALES 133,928.57 -
LABOR 15,690.00
MATERIALS 83,810.00
MISCELLANEOUS 2,500.00
NET SALES
2% MAA
0.25% PMD
0.25% AJT
8. REDGOLD LOGISTICS GROSS SALES 150,000.00
NET CM 34,228.57 -
% 25.56%
Collected (100%)
150,000.00
133,928.57
2,678.57
150,000.00
133,928.57
2,678.57
34,228.57
NET CM 34,228.57
1% Com 342.29
2% Com 684.57
34,228.57
34,228.57
342.29
684.57
W/H TAX 5,705.36 Commission - based on Net sales GROSS SALES Collected (56.25%) 29,955.36 Uncollected (43.75) 23,294.64 53,250.00
NET SALES 47,544.64 -
LABOR 13,154.65
MATERIALS 11,081.00
NET SALES 26,745.86 20,798.79 47,544.64
2% MAA 534.92 415.98 950.89
NET CM 19,736.29 19,736.29 19,736.29
1% Com 197.36
2% Com 394.73
197.36
394.73
334.82 commission
334.82 334.82 % after Commission
334.82 total commission 23.06%
Commission based on Net Margin Collected (100%)
3% Com 1,026.86 1,026.86 total commission
9. PLDT/ IEEI GROSS SALES 53,250.00
MISCELLANEOUS 3,572.70
NET CM 19,736.29 -
% 41.51%
0.25% PMD 0.25% AJT 66.86 66.86 Commission 52.00 52.00 Remaining total commission 118.86 118.86 % after Commission 39.01%
Commission based on Net Margin Collected (56.25%) Uncollected (43.75)
19,736.29 19,736.29 19,736.29
3% Com 592.09 commission 592.09 total commission
10. MONOLITH - LANDMARK CONTRACT AMOUNT 108,477.42
W/H TAX 11,622.58 Commission - based on Net sales AMOUNT Collected (89.64) 97,239.97 Uncollected (10.36%) 11,237.45 108,477.42
NET SALES 96,854.84 NET SALES 86,821.40 10,033.44 96,854.84
LABOR MATERIALS MISCELLANEOUS 13,275.17 12,522.00 12,504.22
2% PMD 1,736.43 200.67 1,937.10 NET CM after Commission
0.5% AJT 434.11 50.17 484.27 57.95%
Commission based on Net Margin Collected (89.64) Uncollected (10.36%)
NET CM 58,553.45 -
1% 52,487.31 6,066.14 58,553.45
2% 1,049.75 121.32 1,171.07
3% 1,574.62 Commission 181.98 Remaining 1,756.60 total commission
NET CM 58,553.45 -
% 60.45%
Commission Remaining total commission
9. FORTUNE TOBACCO CONTRACT AMOUNT 3,308,500.00
W/H TAX 354,482.14 Commission - based on Net sales AMOUNT Collected (88.39) 2,924,477.67 Uncollected (11.61%) 384,022.33 3,308,500.00
NET SALES 2,954,017.86 NET SALES 2,611,140.78 342,877.08 2,954,017.86
Commission based on Net Margin 1,343,604.88
LABOR MATERIALS MISCELLANEOUS 138,008.22 1,826,886.90 94,378.00
2% PMD 52,222.82 6,857.54 59,080.36 NET CM after Commission
NET CM ### -
% 40.61%
0.5% MAA 13,055.70 1,714.39 14,770.09 total commission 38.11%
88.39% of CM 1,187,612.35
2% Com 23,752.25
3% Com 35,628.37
LABOR 145,708.74
MATERIALS 482,457.62
MISCELLANEOUS 18,055.89
8. ROBINSONS GALLERIA GROSS SALES 770,000.00
W/H TAX 82,500.00 Commission - based on Net sales GROSS SALES Collected (100%) 770,000.00
NET SALES 687,500.00 NET SALES 687,500.00
770,000.00
687,500.00
NET CM 41,277.75 -
2% Com PMD 13,750.00 13,750.00 % after Commission
-
total commission 4.00%
Commission based on Net Margin Collected (100%)
41,277.75
NET CM 41,277.75
1% Com 412.78
2% Com 825.56
41,277.75
41,277.75
412.78
825.56
3% Com 1,238.33 1,238.33 total commission
% 6.00%
Commission/ Incentive
PMD Commission
Total contract
Collected
Legend Hotels - kalookan 263,842.40 Benson Yu 135,000.00 Fortune Tobacco Corp 2,200.00 Clean Living / Armadillo 4,250.00 Kalinisan/ Armadillo 2,025.00
221,532.14 135,000.00 2,200.00 4,250.00 2,025.00
F.R. Sevilla PU Pipe Fab. 59,745.13 (Overriding Commission) O.B. Montessorri 300,000.00 Redgold Logistics 150,000.00 PLDT/ IEEI 53,250.00
59,745.13 300,000.00 150,000.00 53,250.00
Net Collected Margin (CM) Com Received 2% Net collected 197,796.55 63,274.19 3,955.93 120,535.71 19,918.02 2,410.71 1,964.29 1,064.29 39.29 3,794.64 1,769.64 75.89 1,808.04 1,735.76 36.16 1% Net Collected 53,343.87 8,343.87 533.44 .25% Net Collected 267,857.14 135,077.99 669.64 133,928.57 34,228.57 334.82 47,544.64 19,736.29 118.86 P/
Less :w/h tax Total Less :10% reserved fund Net Commission MAA Commission
P/ TOTAL
Total contract
Redgold Logistics 150,000.00 PLDT/IEEI 53,250.00 Implementation Legend Hotels - kalookan 263,842.40
Collected 150,000.00 53,250.00 221,532.14
Net Collected Margin (CM) Com Received 2% net collected 133,928.57 34,228.57 2,678.57 47,544.64 19,736.29 950.89 .25% Net Collected 197,796.55 63,274.19 494.49 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
AJT Commission Implementation Benson Yu Redgold Logistics PLDT/IEEI O.B. Montessorri
Total contract 135,000.00 150,000.00 53,250.00 300,000.00
Collected 135,000.00 150,000.00 53,250.00 300,000.00
Net Collected Margin (CM) Com Received .25% Net Collected 120,535.71 19,918.02 301.34 133,928.57 34,228.57 334.82 47,544.64 19,736.29 118.86 267,857.14 135,077.99 669.64 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
HOUSE ACCOUNT
Total contract
Daruma Corp. Double Share Dos Palmas Arreceffi Arch Vincent Caisip Southcall Builders
39,000.00 32,000.00 326,800.00 16,000.00 9,000.00
Collected 39,000.00 32,000.00 326,800.00 16,000.00 9,000.00
Net Collected Margin (CM) Com Received 2% Net Collected 34,821.43 13379.83 696.43 28,571.43 15795.43 571.43 291,785.71 154443.71 5,835.71 14,285.71 7897.72 285.71 8,035.71 4841.71 160.71 P/
Less :w/h tax Total Less :10% reserved fund
P/ TOTAL
TOTAL COMMISSION Commission/Incentive Less: PMD Cash Advance For Check Preparation
P/
Prepared by:
Approved by:
Eugene L. Galanao
G.S. Correa
Note: PMD cash Advance less Payment Mode
Balance
P/ partial pay com 12/11/06 com 01/30/07 com 02/09/07 com 07/02/07
17,231.43 (3,500.00) 13,731.43
45,000.00 (15,000.00) (6,219.07) (5,550.23) (8,857.63) (3,000.00) 6,373.07
TOTAL 3,955.93 2,410.71 39.29 75.89 36.16 533.44 669.64 334.82 118.86 8,174.75 (817.47) 7,357.27 (735.73) 6,621.55 TOTAL 2,678.57 950.89 494.49 4,123.96 (412.40) 3,711.56 (371.16) 3,340.40 TOTAL 301.34 334.82 118.86 669.64 1,424.67 (142.47) 1,282.20 (128.22) 1,153.98 TOTAL 696.43 571.43 5,835.71 285.71 160.71 7,550.00 (755.00) 6,795.00 (679.50) 6,115.50 17,231.43
Related Documents
Eugene
November 2019 34
Eugene Paulli
December 2019 16
Eugene Uzamere.resumefinal
May 2020 7
Eugene Collins
May 2020 8
Eugene Sartini
December 2019 11