Spreadsheet: 92066d1291740026-excel-2007-tie-breakers-in-excel-weekly-update-pub
Sheet: Sheet2

# of Stores
 | PASTE HERE ------> |  |  | Store Report (UAP).
 |  |  |  | Weekly Update
 |  |  |  | 4 Wall Revenue & Margin Store Level
 |  |  |  | 4 Wall Revenue Excludes:
 |  |  |  | 600.6020.20 DVD SW (Movies)
 |  |  |  | 670 Builder
 |  |  |  | 780 Service
 |  |  |  | 981.9810.10/20/40 Non Revenue
 |  |  |  | 990 Non Inventory
 |  |  |  | Start Date: 26-NOV-2010, End Date: 28-NOV-2010, Include Trailing Credits: Y
 |  |  |  | Run Date: 07-DEC-10 09.10.05 AM
 | MUST LINE UP WITH REGION ---> |  |  | Region:<All> | Order Detail Close Dt:<All> | Markdown Code:<All> | Dept Disp:<All> | Distribution Code:<All> | Item Type:APPLIANCE | New Item:<All>
Rank
MG% | UPG% | [NAME] |  |  | 4 Wall Revenue | 4 Wall Frozen Cost | Trailing Credit $ | 4 Wall FZ + TC | 4 Wall MG $ | 4 Wall MG % | 4 Wall Sign | 4 Wall Sign MG $ | 4 Wall Sign MG % | 4 Wall Discount From Sign $ | 4 Wall Discount From Sign % | UPG $ | Install $ | UPG%
 |  |  |  | Store 1 | 19098 | 15799.68 | -1249.59 | 14550.09 | 4548 | 0.2381 | 20199.17 | 5649.08 | 0.2797 | 1101.26 | 0.0545 | 1420 | 0
 |  |  |  | Store 2 | 14003 | 13039.01 | -1618.27 | 11420.74 | 2582 | 0.1844 | 15815.37 | 4394.63 | 0.2779 | 1812.57 | 0.1146 | 1108 | 0
 |  |  |  | Store 3 | 27454 | 24535.73 | -2519.58 | 22016.15 | 5438 | 0.1981 | 29073.02 | 7056.87 | 0.2427 | 1619.29 | 0.0557 | 1307 | 0
 |  |  |  | Store 4 | 17504 | 16695.82 | -2350.6 | 14345.22 | 3159 | 0.1805 | 19027.26 | 4682.04 | 0.2461 | 1522.89 | 0.08 | 420 | 0
 |  |  |  | Store 5 | 26081 | 23409.56 | -2495.54 | 20914.02 | 5167 | 0.1981 | 28892.01 | 7977.99 | 0.2761 | 2810.92 | 0.0973 | 1290 | 0
 |  |  |  | Store 6 | 10442 | 9290.2 | -1789.13 | 7501.07 | 2941 | 0.2817 | 11189.53 | 3688.46 | 0.3296 | 747.34 | 0.0668 | 370 | 0
 |  |  |  | Store 7 | 56672 | 53272.77 | -7345.37 | 45927.4 | 10745 | 0.1896 | 59020.35 | 13092.95 | 0.2218 | 2348.35 | 0.0398 | 3320 | 0
9 |  |  |  | Store 8 | 33938 | 30305.39 | -3048.92 | 27256.47 | 6682 | 0.1969 | 34435.27 | 7178.8 | 0.2085 | 496.91 | 0.0144 | 1560 | 0
 |  |  |  | Store 9 | 38045 | 33751.87 | -3621.89 | 30129.98 | 7915 | 0.2081 | 39438.29 | 9308.31 | 0.236 | 1392.96 | 0.0353 | 2760 | 0
 |  |  |  | Store 10 | 17699 | 16083.4 | -1765.35 | 14318.05 | 3381 | 0.191 | 18223.23 | 3905.18 | 0.2143 | 524 | 0.0288 | 700 | 0
 |  | 39 |  | Store 11 | 39296 | 36433.92 | -4090.69 | 32343.23 | 6953 | 0.1769 | 40705.92 | 8362.69 | 0.2054 | 1410.12 | 0.0346 | 2365 | 0
 |  |  |  | Store 12 | 33842 | 31573.5 | -4141.12 | 27432.38 | 6410 | 0.1894 | 37174.72 | 9742.34 | 0.2621 | 3332.36 | 0.0896 | 3090 | 0
 |  |  |  | Store 13 | 17669 | 17317.44 | -1881.5 | 15435.94 | 2233 | 0.1264 | 17818.87 | 2382.93 | 0.1337 | 149.99 | 0.0084 | 735 | 0
 |  |  |  | Store 14 | 44426 | 42921.96 | -6656.75 | 36265.21 | 8161 | 0.1837 | 45686.86 | 9421.65 | 0.2062 | 1260.74 | 0.0276 | 2900 | 0
 |  |  |  | Store 15 | 23013 | 23172.41 | -2840.87 | 20331.54 | 2682 | 0.1165 | 23383.34 | 3051.8 | 0.1305 | 370.14 | 0.0158 | 725 | 0
 |  |  |  | Store 16 | 10360 | 10496.61 | -1958.98 | 8537.63 | 1822 | 0.1759 | 10767.98 | 2230.35 | 0.2071 | 408.29 | 0.0379 | 890 | 0
 |  |  |  | Store 17 | 16720 | 15672.46 | -1635.19 | 14037.27 | 2683 | 0.1604 | 16879.87 | 2842.6 | 0.1684 | 159.99 | 0.0095 | 1365 | 0
 |  |  |  | Store 18 | 14636 | 14015.36 | -1641.04 | 12374.32 | 2262 | 0.1545 | 15197.43 | 2823.11 | 0.1858 | 561.06 | 0.0369 | 880 | 0
 |  |  |  | Store 19 | 34285 | 28566.24 | -1117.91 | 27448.33 | 6836 | 0.1994 | 37093.13 | 9644.8 | 0.26 | 2808.54 | 0.0757 | 2346 | 0
 |  |  |  | Store 20 | 26276 | 24646.03 | -3070.42 | 21575.61 | 4700 | 0.1789 | 26262.99 | 4687.38 | 0.1785 | -13.06 | -0.0005 | 2055 | 0
 |  |  |  | Store 21 | 25022 | 24455.29 | -4305.02 | 20150.27 | 4871 | 0.1947 | 25193.53 | 5043.26 | 0.2002 | 172.02 | 0.0068 | 1610 | 0
 |  |  |  | Store 22 | 9294 | 9022.72 | -1741.39 | 7281.33 | 2013 | 0.2165 | 9077.07 | 1795.74 | 0.1978 | -216.77 | -0.0239 | 625 | 0
 |  |  |  | Store 23 | 19206 | 17313.7 | -1796.83 | 15516.87 | 3689 | 0.1921 | 19693.21 | 4176.34 | 0.2121 | 486.93 | 0.0247 | 1755 | 0
 |  |  |  | Store 24 | 11351 | 12206.05 | -2279.76 | 9926.29 | 1425 | 0.1255 | 12046.54 | 2120.25 | 0.176 | 695.53 | 0.0577 | 555 | 0
 |  |  |  | Store 25 | 16688 | 16095.27 | -2455.61 | 13639.66 | 3048 | 0.1827 | 17141.78 | 3502.12 | 0.2043 | 453.99 | 0.0265 | 1200 | 0
 |  |  |  | Store 26 | 49243 | 43729.22 | -2979.3 | 40749.92 | 8494 | 0.1725 | 49710.32 | 8960.4 | 0.1803 | 466.85 | 0.0094 | 2330 | 0
 |  |  |  | Store 27 | 8947 | 8554.27 | -498.41 | 8055.86 | 891 | 0.0996 | 9106.53 | 1050.67 | 0.1154 | 159.97 | 0.0176 | 220 | 0
10 |  |  |  | Store 28 | 15363 | 13438.59 | -1072.06 | 12366.53 | 2997 | 0.1951 | 17166.11 | 4799.58 | 0.2796 | 1802.7 | 0.105 | 990 | 0
 |  |  |  | Store 29 | 11107 | 10417.2 | -1208.43 | 9208.77 | 1899 | 0.1709 | 12465.5 | 3256.73 | 0.2613 | 1358.18 | 0.109 | 990 | 0
 |  |  |  | Store 30 | 22723 | 18020.5 | -1018.11 | 17002.39 | 5720 | 0.2517 | 24085.97 | 7083.58 | 0.2941 | 1363.4 | 0.0566 | 1091 | 0
 |  |  |  | Store 31 | 13389 | 11240.85 | -648.75 | 10592.1 | 2797 | 0.2089 | 14036.24 | 3444.14 | 0.2454 | 646.88 | 0.0461 | 40 | 0
 |  |  |  | Store 32 | 17338 | 16682.39 | -1185.88 | 15496.51 | 1841 | 0.1062 | 18752.43 | 3255.92 | 0.1736 | 1414.45 | 0.0754 | 1225 | 0
 |  |  |  | Store 33 | 14042 | 13477.89 | -1552.89 | 11925 | 2117 | 0.1508 | 15330.25 | 3405.25 | 0.2221 | 1288.21 | 0.084 | 420 | 0
 |  |  |  | Store 34 | 10733 | 9542.37 | -733.98 | 8808.39 | 1925 | 0.1794 | 11114.51 | 2306.12 | 0.2075 | 381.02 | 0.0343 | 465 | 0
 |  |  |  | Store 35 | 20265 | 18917.48 | -1364.38 | 17553.1 | 2712 | 0.1338 | 20714.99 | 3161.89 | 0.1526 | 449.83 | 0.0217 | 1035 | 0
 |  |  |  | Store 36 | 6404 | 5897.73 | -315.04 | 5582.69 | 821 | 0.1282 | 7176.51 | 1593.82 | 0.2221 | 772.95 | 0.1077 | 550 | 0
 |  |  |  | Store 37 | 20638 | 20069.68 | -1764.85 | 18304.83 | 2333 | 0.113 | 22171.9 | 3867.07 | 0.1744 | 1534.28 | 0.0692 | 555 | 0
 |  |  |  | Grand Total | 813213 | 750080.56 | -83759.4 | 666321.16 | 146892 | 0.1806 | 851268 | 184946.84 | 0.2173 | 38055.08 | 0.0447 | 47259 | 0