I am stumped when it comes to creating a formula for the following scenario: I have forecasted demand for the time frame in question. What I am attempting to do is to determine the optimal mix of 4 of our different inventory items (Products A, B, C, & D) that are variable depending on demand that are needed to make a the sale. For instance, I forecast that account # 12347 will service 693 customers from 9/1-9/15. I need to know how many of each products that I need to send them for this period. For this example, I would send that account location 1 of Product A (supplies for 400 of the 693 customers) and 1 of Product B (supplies for an additional 300 customers). They would have enough supplies for 700 customers (7 more than they are projected to need). With thousands of accounts, I need to come up with a formula that would give me the optimal mix of Products A-D to service their projected amount of customers for 9/1-9/15. Your help would be a huge time saver!
adding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {border:.5pt solid windowtext; white-space:normal;} .xl25 {mso-number-format:"Short Date"; border:.5pt solid windowtext;} .xl26 {color:#DD0806; border:.5pt solid windowtext; background:#FCF305; mso-pattern:auto none; white-space:normal;} .xl27 {border:.5pt solid windowtext;} ruby {ruby-align:left;} rt {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-char-type:none; display:none;} --> </style> <table style="border-collapse: collapse" border="0" cellpadding="0" cellspacing="0" width="977"> <colgroup><col style="mso-width-source:userset;mso-width-alt:1755" width="48"> <col style="mso-width-source:userset;mso-width-alt:2084" width="57"> <col style="mso-width-source:userset;mso-width-alt:1609" width="44"> <col style="mso-width-source:userset;mso-width-alt:1536" span="6" width="42"> <col style="mso-width-source:userset;mso-width-alt:1536" width="42"> <col style="mso-width-source:userset;mso-width-alt:1792" span="6" width="49"> <col style="mso-width-source:userset;mso-width-alt:1901" width="52"> <col style="mso-width-source:userset;mso-width-alt:1718" span="4" width="47"> </colgroup><tbody><tr height="39"> <td class="xl24" height="39" width="48">Account ID</td> <td class="xl25" align="right" width="57">9/1/12</td> <td class="xl25" align="right" width="44">9/2/12</td> <td class="xl25" align="right" width="42">9/3/12</td> <td class="xl25" align="right" width="42">9/4/12</td> <td class="xl25" align="right" width="42">9/5/12</td> <td class="xl25" align="right" width="42">9/6/12</td> <td class="xl25" align="right" width="42">9/7/12</td> <td class="xl25" align="right" width="42">9/8/12</td> <td class="xl25" align="right" width="42">9/9/12</td> <td class="xl25" align="right" width="49">9/10/12</td> <td class="xl25" align="right" width="49">9/11/12</td> <td class="xl25" align="right" width="49">9/12/12</td> <td class="xl25" align="right" width="49">9/13/12</td> <td class="xl25" align="right" width="49">9/14/12</td> <td class="xl25" align="right" width="49">9/15/12</td> <td class="xl24" width="52">TOTAL DEMAND</td> <td class="xl26" width="47">PROD A COUNT</td> <td class="xl26" width="47">PROD B COUNT</td> <td class="xl26" width="47">PROD C COUNT</td> <td class="xl26" width="47">PROD D COUNT</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12345</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">58</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">58</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">727</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12346</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">26</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">38</td> <td class="xl27" align="right">37</td> <td class="xl27" align="right">33</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">756</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12347</td> <td class="xl27" align="right">29</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">59</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">70</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">34</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">693</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12348</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">55</td> <td class="xl27" align="right">30</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">33</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">44</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">34</td> <td class="xl27" align="right">43</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">668</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12349</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">46</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">40</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">44</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">715</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12350</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">59</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">26</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">747</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12351</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">69</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">29</td> <td class="xl27" align="right">38</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">754</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12352</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">47</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">70</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">736</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12353</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">40</td> <td class="xl27" align="right">69</td> <td class="xl27" align="right">47</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">725</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12354</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">221</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12355</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">229</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12356</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">251</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12357</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">241</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12358</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">206</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12359</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">195</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12360</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">217</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12361</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">242</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12362</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">145</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12363</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">124</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12364</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">4</td> <td class="xl27" align="right">4</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">107</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> </tbody></table>
- Product A: Has enough supplies to service 400 customers
- Product B: Has enough supplies to service 300 customers
- Product C: Has enough supplies to service 200 customers
- Product D: Has enough supplies to service 100 customers
adding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {border:.5pt solid windowtext; white-space:normal;} .xl25 {mso-number-format:"Short Date"; border:.5pt solid windowtext;} .xl26 {color:#DD0806; border:.5pt solid windowtext; background:#FCF305; mso-pattern:auto none; white-space:normal;} .xl27 {border:.5pt solid windowtext;} ruby {ruby-align:left;} rt {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-char-type:none; display:none;} --> </style> <table style="border-collapse: collapse" border="0" cellpadding="0" cellspacing="0" width="977"> <colgroup><col style="mso-width-source:userset;mso-width-alt:1755" width="48"> <col style="mso-width-source:userset;mso-width-alt:2084" width="57"> <col style="mso-width-source:userset;mso-width-alt:1609" width="44"> <col style="mso-width-source:userset;mso-width-alt:1536" span="6" width="42"> <col style="mso-width-source:userset;mso-width-alt:1536" width="42"> <col style="mso-width-source:userset;mso-width-alt:1792" span="6" width="49"> <col style="mso-width-source:userset;mso-width-alt:1901" width="52"> <col style="mso-width-source:userset;mso-width-alt:1718" span="4" width="47"> </colgroup><tbody><tr height="39"> <td class="xl24" height="39" width="48">Account ID</td> <td class="xl25" align="right" width="57">9/1/12</td> <td class="xl25" align="right" width="44">9/2/12</td> <td class="xl25" align="right" width="42">9/3/12</td> <td class="xl25" align="right" width="42">9/4/12</td> <td class="xl25" align="right" width="42">9/5/12</td> <td class="xl25" align="right" width="42">9/6/12</td> <td class="xl25" align="right" width="42">9/7/12</td> <td class="xl25" align="right" width="42">9/8/12</td> <td class="xl25" align="right" width="42">9/9/12</td> <td class="xl25" align="right" width="49">9/10/12</td> <td class="xl25" align="right" width="49">9/11/12</td> <td class="xl25" align="right" width="49">9/12/12</td> <td class="xl25" align="right" width="49">9/13/12</td> <td class="xl25" align="right" width="49">9/14/12</td> <td class="xl25" align="right" width="49">9/15/12</td> <td class="xl24" width="52">TOTAL DEMAND</td> <td class="xl26" width="47">PROD A COUNT</td> <td class="xl26" width="47">PROD B COUNT</td> <td class="xl26" width="47">PROD C COUNT</td> <td class="xl26" width="47">PROD D COUNT</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12345</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">58</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">58</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">727</td> <td class="xl27"> </td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12346</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">26</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">38</td> <td class="xl27" align="right">37</td> <td class="xl27" align="right">33</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">65</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">756</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12347</td> <td class="xl27" align="right">29</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">59</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">70</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">34</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">693</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12348</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">55</td> <td class="xl27" align="right">30</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">33</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">44</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">34</td> <td class="xl27" align="right">43</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">668</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12349</td> <td class="xl27" align="right">39</td> <td class="xl27" align="right">46</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">40</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">44</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">66</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">715</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12350</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">59</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">26</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">747</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12351</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">69</td> <td class="xl27" align="right">68</td> <td class="xl27" align="right">29</td> <td class="xl27" align="right">38</td> <td class="xl27" align="right">36</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">48</td> <td class="xl27" align="right">41</td> <td class="xl27" align="right">53</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">754</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12352</td> <td class="xl27" align="right">63</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">25</td> <td class="xl27" align="right">27</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">56</td> <td class="xl27" align="right">61</td> <td class="xl27" align="right">47</td> <td class="xl27" align="right">54</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">64</td> <td class="xl27" align="right">70</td> <td class="xl27" align="right">35</td> <td class="xl27" align="right">45</td> <td class="xl27" align="right">736</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12353</td> <td class="xl27" align="right">32</td> <td class="xl27" align="right">31</td> <td class="xl27" align="right">57</td> <td class="xl27" align="right">42</td> <td class="xl27" align="right">67</td> <td class="xl27" align="right">60</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">40</td> <td class="xl27" align="right">69</td> <td class="xl27" align="right">47</td> <td class="xl27" align="right">52</td> <td class="xl27" align="right">49</td> <td class="xl27" align="right">51</td> <td class="xl27" align="right">28</td> <td class="xl27" align="right">725</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12354</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">221</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12355</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">229</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12356</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">251</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12357</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">241</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12358</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">16</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">206</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12359</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">23</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">14</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">195</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12360</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">22</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">217</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12361</td> <td class="xl27" align="right">20</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">19</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">24</td> <td class="xl27" align="right">21</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">17</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">15</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">18</td> <td class="xl27" align="right">242</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12362</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">8</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">145</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12363</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">9</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">6</td> <td class="xl27" align="right">13</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">124</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> <tr height="13"> <td class="xl27" align="right" height="13">12364</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">11</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">10</td> <td class="xl27" align="right">5</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">7</td> <td class="xl27" align="right">4</td> <td class="xl27" align="right">4</td> <td class="xl27" align="right">3</td> <td class="xl27" align="right">12</td> <td class="xl27" align="right">107</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> <td class="xl27">
</td> </tr> </tbody></table>
