buddyosher
New Member
- Joined
- Jan 15, 2012
- Messages
- 31
<html>
<head>
<p class=MsoNormal>I am looking to create a formula to calculate progressive
commission payouts. Can I create a payout that separates a full amount ($12,000
sale) in to 3 levels of payouts? See the example below, if I sell $12,000, and
the first $5,000 is paid at 5%, from $5,001-$10,000 I am paid 10% and from
$10,000-$12,000 I am paid 15%. The long hand calculations are below, but
creating a formula that would calculate would be great.* Can this be done?</p>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=521
style='width:390.45pt;margin-left:4.65pt;border-collapse:collapse;border:none'>
<tr style='height:15.0pt'>
<td width=277 colspan=3 rowspan=2 valign=bottom style='width:207.75pt;
border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Sale of $12,000 = progressive payout* </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Pay</span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Rate</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 5,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>5%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>12k SOLD</span></b></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Commission</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Payout</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$**** 10,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>10%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 5,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>5%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 250 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$**** 15,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>15%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 5,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>10%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 500 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.75pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 2,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>15%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 300 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
</tr>
<tr style='height:30.0pt'>
<td width=79 style='width:59.25pt;border:solid windowtext 1.0pt;border-top:
none;background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*Total Sales </span></b></p>
</td>
<td width=87 valign=bottom style='width:65.3pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='color:black'>weighted
AVG %</span></b></p>
</td>
<td width=111 style='width:83.2pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='color:black'>*Total
Commiss </span></b></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
</tr>
<tr style='height:15.75pt'>
<td width=79 valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*$* 12,000 </span></b></p>
</td>
<td width=87 valign=bottom style='width:65.3pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'> </span></b></p>
</td>
<td width=111 valign=bottom style='width:83.2pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*$*** 1,050 </span></b></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
</tr>
</table>
<p class=MsoNormal> </p>
</div>
</body>
</html>
<head>
<p class=MsoNormal>I am looking to create a formula to calculate progressive
commission payouts. Can I create a payout that separates a full amount ($12,000
sale) in to 3 levels of payouts? See the example below, if I sell $12,000, and
the first $5,000 is paid at 5%, from $5,001-$10,000 I am paid 10% and from
$10,000-$12,000 I am paid 15%. The long hand calculations are below, but
creating a formula that would calculate would be great.* Can this be done?</p>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=521
style='width:390.45pt;margin-left:4.65pt;border-collapse:collapse;border:none'>
<tr style='height:15.0pt'>
<td width=277 colspan=3 rowspan=2 valign=bottom style='width:207.75pt;
border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Sale of $12,000 = progressive payout* </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Pay</span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Rate</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 5,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>5%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>12k SOLD</span></b></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Commission</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>Payout</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$**** 10,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>10%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 5,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>5%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 250 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$**** 15,000 </span></p>
</td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>15%</span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.0pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 5,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>10%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 500 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.0pt'></td>
</tr>
<tr style='height:15.75pt'>
<td width=79 nowrap valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$*** 2,000 </span></p>
</td>
<td width=87 nowrap valign=bottom style='width:65.3pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal align=right style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='color:black'>15%</span></p>
</td>
<td width=111 nowrap valign=bottom style='width:83.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='color:black'>*$******* 300 </span></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
</tr>
<tr style='height:30.0pt'>
<td width=79 style='width:59.25pt;border:solid windowtext 1.0pt;border-top:
none;background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*Total Sales </span></b></p>
</td>
<td width=87 valign=bottom style='width:65.3pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='color:black'>weighted
AVG %</span></b></p>
</td>
<td width=111 style='width:83.2pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='color:black'>*Total
Commiss </span></b></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td>
</tr>
<tr style='height:15.75pt'>
<td width=79 valign=bottom style='width:59.25pt;border:solid windowtext 1.0pt;
border-top:none;background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*$* 12,000 </span></b></p>
</td>
<td width=87 valign=bottom style='width:65.3pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'> </span></b></p>
</td>
<td width=111 valign=bottom style='width:83.2pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
background:#F2F2F2;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='color:black'>*$*** 1,050 </span></b></p>
</td>
<td width=22 nowrap valign=bottom style='width:16.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=116 nowrap valign=bottom style='width:86.75pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=84 nowrap valign=bottom style='width:63.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
<td width=22 nowrap valign=bottom style='width:16.2pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td>
</tr>
</table>
<p class=MsoNormal> </p>
</div>
</body>
</html>