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!
</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
</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>