Spreadsheet: 267845d1380235949-lookup-vlookup-hlookup-test
Sheet: IRR

Inventory Recap Report
Period: AUG
Year End: 2014
Author | STADASI | Last Changed by | STADASI
Query Technical Name | ZPUSMGL01_GL_RB0233 | InfoProvider | ZPUSMGL01
Key Date | 08/31/2013 | Query Description | [NAME]: Inventory Recap Report w/SBU
Current User | RDKEENO | Changed At | 02/27/2012 11:35:42
Status of Data | 07/23/2013 14:41:56 | Last Refreshed | 09/19/2013 14:27:27
Relevance of Data (Date) | 07/23/2013 | Status of Data From | 07/23/2013 14:41:56
Relevance of Data (Time) | 14:41:56 | Status of Data To | 09/19/2013 13:34:00
Variables selected at start |  | Further Navigation
Currency Type | Company code currency | Company Code
Fiscal Year Variant | WM Feb-Jan Julian | Profit Center
Merchandising Division | Empty Demarcation | [NAME] (As of Month End)
Fiscal Year Period | AUG | Format
Fiscal Year Period | 007/2014 | Sub-division (As of Month End)
Department(s) | Empty Demarcation | Region  (As of Month End)
Company Code(s) | Not assigned, Wal-Mart Stores, Inc., Beaver Lake Aviation, Inc, Vudu Entertainment, Inc., Benchmark Realty Advisors... | Market  (As of Month End)
Format(s) | Empty Demarcation | [NAME] | WAL-MART STORES INC., TIRE & LUBE EXPRESS, PHARMACY, JEWELRY, WAL-MART SHOES, MEAT, PRODUCE...
Profit Center | 00141 FORT SMITH, AR | Department
Banners (As of Month End) | Empty Demarcation | Sales Class
[NAME] (As of Month End) | Empty Demarcation | SBU
Profit Center
 |  |  |  | Current Month  Purchases - Retail | YTD Initial Margin % | Current Month  Markdowns | Current Month  Merchandise & Service Sales | [NAME] | YTD  Merchandise & Service Sales | Current Month Inventory - Retail (Incl. Shrink) | PI Inventory - Retail | PI vs Financial Inventory | YTD  Shrink Adjustment at Retail
[NAME] | Department | Department No |  | $ | % | $ | $ | $ | $ | $ | $ | $ | $
WAL-MART STORES INC. | HEALTH & BEAUTY AIDS | 2 | Prev YR | 216997.16 | 26.1982542760122 | 1024.16 | 214430.98 | 15676.94 | 1448735.82 | 205930.33 | 205769 | 161.33 | 2332.61
 |  |  | Curr YR | 215980.33 | 26.119155042536 | 675.75 | 216402.03 | 17230.62 | 1454198.25 | 203098.5 | 203089 | 9.5 | -1659.98
 |  |  | LY SC Avg | 232041.603358586 | 26.2105349603411 | 1431.80556818182 | 223498.869924242 | 16899.1687878788 | 1464121.26748737 | 242476.810606061 | 234829.773989899 | 7647.03661616162 | -21546.5176010101
 |  |  | TY SC Avg | 224417.472679659 | 26.0796903374773 | 1557.68705237515 | 221459.648306943 | 18670.2462971985 | 1422293.90437272 | 237166.390840438 | 227513.974421437 | 9652.41641900122 | -20821.0843361754
 | STATIONERY & PARTY G | 3 | Prev YR | 76393.22 | 39.8686373781965 | 12967.14 | 192743.74 | 33893.17 | 460581.93 | 163122.92 | 175235 | -12112.08 | 4702.13
 |  |  | Curr YR | 75071.06 | 40.6382226958338 | 9685.42 | 179654.93 | 28227.77 | 439050.97 | 167765.74 | 179668 | -11902.26 | -1807.25
 |  |  | LY SC Avg | 90573.8549596309 | 39.2805638948208 | 6910.37162629758 | 179554.298500577 | 23635.8858246828 | 462644.750253749 | 164579.846770473 | 174032.341407151 | -9452.4946366782 | -2896.27008073818
 |  |  | TY SC Avg | 79029.240754717 | 40.0679593639762 | 5661.69714761376 | 180650.455305216 | 25461.8575027747 | 452442.753163152 | 166383.542352941 | 172768.580466149 | -6385.03811320755 | -4857.36562708102
 | PAPER GOODS | 4 | Prev YR | 157407.31 | 26.7506580025233 | 417.46 | 156674.45 | 3645.45 | 1054866.67 | 49245.79 | 53999 | -4753.21 | -240.35
 |  |  | Curr YR | 158157.7 | 25.8916637443726 | 402.41 | 162757.91 | 4992.73 | 1079457.65 | 48164.36 | 54504 | -6339.64 | 1244.66
 |  |  | LY SC Avg | 185807.887103896 | 26.7303245166349 | 824.371103896104 | 183440.844363636 | 4749.37277922078 | 1184986.87790909 | 56399.6105844156 | 56920.9415584416 | -521.330974025974 | -1583.84305194805
 |  |  | TY SC Avg | 174838.721314791 | 25.9908533156052 | 650.378381795196 | 180182.750922882 | 4227.8682300885 | 1148840.8847914 | 52028.9930720607 | 52359.2932996207 | -330.300227560051 | -2572.94226295828
 | ELECTRONICS | 5 | Prev YR | 127769.63 | 22.0965278985546 | 6793.81 | 105784.81 | 52586.73 | 877339.22 | 302316.56 | 301720 | 596.56 | -14038.71
 |  |  | Curr YR | 129722.55 | 22.3889489917082 | 7288.47 | 99294.22 | 49473.11 | 821889.78 | 296598.59 | 303301 | -6702.41 | -25908.99
 |  |  | LY SC Avg | 161304.354988235 | 21.7800795717124 | 7744.56414117647 | 120156.946129412 | 55924.7098705882 | 941474.732341176 | 380801.519494118 | 356842.46 | 23959.0594941176 | -47463.4586235294
 |  |  | TY SC Avg | 122459.288083624 | 22.274103118269 | 6121.02918699187 | 107319.342520325 | 50578.2940998839 | 818056.786480836 | 343428.627084785 | 331666.775842044 | 11761.851242741 | -55368.102311266
 | TOYS & HOBBIES | 7 | Prev YR | 167666.21 | 35.1518167431748 | 22147.3 | 71704.15 | 57536.6 | 617538.86 | 337431.44 | 334217 | 3214.44 | 5457.18
 |  |  | Curr YR | 154823.85 | 36.0293788264441 | 25580.02 | 71536.58 | 78618.85 | 602220.17 | 306525.13 | 307201 | -675.87 | 965.64
 |  |  | LY SC Avg | 150909.579732394 | 34.5916307231699 | 25132.1661408451 | 79244.4663661972 | 75531.6103661972 | 649918.770760563 | 337010.673492958 | 345434.276056338 | -8423.60256338028 | -4950.66347887324
 |  |  | TY SC Avg | 141344.228241758 | 34.938277850889 | 25805.0467032967 | 78901.3766208791 | 78047.6726236264 | 609123.353626374 | 343720.177651099 | 354183.266483516 | -10463.0888324176 | -6111.32766483516
 | PETS & SUPPLIES | 8 | Prev YR | 198363.44 | 30.1852960162217 | 1130.57 | 195168.08 | 13930.75 | 1375001.09 | 133572.56 | 119208 | 14364.56 | -19790.43
 |  |  | Curr YR | 203775.37 | 29.0283257760319 | 1826.99 | 208805.38 | 22283 | 1454165.59 | 132095.16 | 120921 | 11174.16 | -17748.61
 |  |  | LY SC Avg | 223292.877438272 | 29.5317557348365 | 2360.5787962963 | 216425.499243827 | 22554.3640895062 | 1486220.66868827 | 154772.871929012 | 146697.179012346 | 8075.69291666667 | -15252.5293518519
 |  |  | TY SC Avg | 212637.224873323 | 28.976422058642 | 2735.77071535022 | 215545.484307004 | 24566.1073770492 | 1467858.18530551 | 151503.7095231 | 144658.621460507 | 6845.08806259315 | -18454.1985245902
 | SPORTING GOODS | 9 | Prev YR | 138005.37 | 32.1715580723014 | 6335.27 | 106270.77 | 48517.08 | 762592.16 | 399883.15 | 404167 | -4283.85 | 1782.89
 |  |  | Curr YR | 157341.74 | 31.0878161155312 | 5875.4 | 109091.49 | 47875.22 | 872358.11 | 403468.24 | 422255 | -18786.76 | -5251.35
 |  |  | LY SC Avg | 165992.821377331 | 34.6222749751611 | 2794.92400286944 | 131232.665265423 | 30040.3858393113 | 930962.597804878 | 397925.310344333 | 398586.723098996 | -661.412754662841 | -20450.1053228121
 |  |  | TY SC Avg | 153268.838216735 | 34.637099396039 | 4278.84146776406 | 138437.367146776 | 27752.2169821674 | 924034.855624143 | 387800.42781893 | 391056.890260631 | -3256.46244170096 | -24415.5569958848
 | HARDWARE | 10 | Prev YR | 80017.13 | 38.1889845168118 | 6763.8 | 66953.52 | 28434.68 | 525516.62 | 197280.93 | 197102 | 178.93 | -12636.91
 |  |  | Curr YR | 63771.81 | 38.6518763572733 | 4979.75 | 69481.81 | 27763.27 | 507934.71 | 182456.03 | 196709 | -14252.97 | -8179.09
 |  |  | LY SC Avg | 76220.982936345 | 38.0756861718713 | 3027.86697125257 | 70058.1754414784 | 19128.694301848 | 523880.299075975 | 188225.532340862 | 184491.658110883 | 3733.87422997947 | -10205.021724846
 |  |  | TY SC Avg | 58794.5680425964 | 38.6286782536481 | 4633.7264198783 | 72912.5412880325 | 22198.3479513185 | 520639.464036511 | 194396.220020284 | 197110.668356998 | -2714.448336714 | -12183.6355780933
 | PAINT & ACCESS | 12 | Prev YR | 22940.36 | 40.8177560558997 | 711.39 | 22585 | 4263.35 | 168986.83 | 71557.79 | 68541 | 3016.79 | -703.37
 |  |  | Curr YR | 21473.49 | 42.0291489747028 | 451.1 | 26029 | 7130.29 | 182700.48 | 71622.68 | 71771 | -148.32 | -2688.31
 |  |  | LY SC Avg | 25482.5335755258 | 41.3897409278933 | 641.633919694073 | 28774.1923422562 | 4045.43369024857 | 199150.271615679 | 70838.4600382409 | 69492.8393881453 | 1345.6206500956 | -2147.50518164436
 |  |  | TY SC Avg | 24301.8428418231 | 42.3314425956392 | 374.505075960679 | 27960.1014745308 | 5614.62235924933 | 183941.622636282 | 72019.9926630921 | 71392.4977658624 | 627.494897229669 | -2504.25792672029
 | HOUSEHOLD CHEMICALS | 13 | Prev YR | 165012.2 | 22.1728265828412 | 1079.67 | 163152.76 | 8378.45 | 1102992.83 | 101173.9 | 103104 | -1930.1 | -4589.81
 |  |  | Curr YR | 165621.52 | 22.5536310539878 | 157.7 | 167991.97 | 8346.27 | 1115221.93 | 104290.85 | 112874 | -8583.15 | -1488.12
 |  |  | LY SC Avg | 207947.961884422 | 22.159037748691 | 1147.5258040201 | 200566.410929648 | 9277.16645728643 | 1269059.69908291 | 112941.063090452 | 109519.379396985 | 3421.68369346734 | -6664.56793969849
 |  |  | TY SC Avg | 182901.225346651 | 22.6370524892874 | 1210.96267920094 | 188297.915934195 | 8736.47839012926 | 1182996.89054054 | 105242.262314924 | 102315.220916569 | 2927.04139835488 | -8169.68274970623
 | HOUSEWARE | 14 | Prev YR | 66502.5 | 36.1091142194358 | 5307.09 | 56706.86 | 28925.38 | 431171.77 | 144425.71 | 140817 | 3608.71 | 82.42
 |  |  | Curr YR | 68172.3 | 36.734454192621 | 3511.3 | 62669.47 | 31146.12 | 462648.68 | 159614.01 | 160342 | -727.99 | 393.03
 |  |  | LY SC Avg | 70679.1591313789 | 35.9897541779354 | 3906.5790228013 | 60967.6563735071 | 25160.9934744843 | 421328.220401737 | 128114.891606949 | 132342.971769815 | -4228.08016286645 | -2498.39371335505
 |  |  | TY SC Avg | 68980.2975622969 | 36.8529722928868 | 2785.45704225352 | 68795.1327410618 | 26693.3568689057 | 451607.364918743 | 143209.033575298 | 148843.790899242 | -5634.75732394366 | -4258.86608884074
 | ELECTRICAL APPLIANCE | 15 | Prev YR |  | 0 |  | 78.86 |  | 71.6 | -71.6 |  | -71.6 | 174.36
 |  |  | Curr YR |  | 0 |  |  |  | 38.19 | -67.7 |  | -67.7 | 93.77
 |  |  | LY SC Avg | 0 | 179.342492407547 | 0 | 0.87994318181818 | 9.98319602272727 | 15.2220738636364 | -73.2914488636364 | 58.5255681818182 | -131.817017045455 | 70.5032386363636
 |  |  | TY SC Avg | 0 | -628.76180765886 | 0 | -7.55944237918216 | 7.65122676579926 | -48.8291078066914 | 37.8805576208178 | 61 | -23.1194423791822 | -37.4486431226766
 | HORTICULTURE | 16 | Prev YR | 25952.76 | 30.36223808454 | 21466.79 | 63727.8 | 61396.38 | 850399.38 | 139079.11 | 135306 | 3773.11 | -4057.38
 |  |  | Curr YR | 29009.02 | 31.0189314464877 | 14738.15 | 69458.59 | 60446.84 | 796577.58 | 77942.7 | 81646 | -3703.3 | -5132.92
 |  |  | LY SC Avg | 37941.5669820972 | 31.4692872137228 | 14729.8411636829 | 65952.3903324808 | 38889.7612276215 | 763716.242953964 | 164265.244526854 | 169161.845268542 | -4896.60074168798 | -4563.42056265985
 |  |  | TY SC Avg | 38484.0209962169 | 32.3140799435582 | 10263.4089911728 | 66852.1903656999 | 42774.6611349306 | 742255.884981085 | 164605.432862547 | 170082.151324086 | -5476.71846153846 | -4775.99514501892
 | CANDLES/HOME DECOR | 17 | Prev YR | 61362.27 | 50.953107286632 | 4337.54 | 46147.01 | 15122.2 | 308103.38 | 151539.44 | 153253 | -1713.56 | -256.43
 |  |  | Curr YR | 48985.47 | 51.2961719166768 | 6393.01 | 46226.16 | 24432.02 | 314142.22 | 159304.16 | 167152 | -7847.84 | -5382.5
 |  |  | LY SC Avg | 59702.1650289017 | 50.7849368066795 | 3145.93268208092 | 50845.6554450867 | 15382.1840578035 | 334126.180150289 | 132402.781676301 | 135690.402312139 | -3287.62063583815 | -4073.92520231214
 |  |  | TY SC Avg | 56913.3366586826 | 51.6944333497983 | 4128.50094610778 | 53422.8987305389 | 19943.6548502994 | 345485.475245509 | 141997.020550898 | 146982.897005988 | -4985.87645508982 | -5354.2951497006
 | SEASONAL | 18 | Prev YR | 3485.01 | 53.5388523878496 | 12.22 | -13.2 | 18822.29 | 69021.91 | 2523.09 | 1529 | 994.09 | 11400.67
 |  |  | Curr YR | 53380.34 | 54.7304117488042 | 26.88 | 1389.23 | 8279.51 | 69078.07 | 49858.09 | 33332 | 16526.09 | 20722.29
 |  |  | LY SC Avg | 5960.74318918919 | 53.3396739390171 | 41.0344864864865 | 66.5900405405405 | 13998.3856891892 | 44566.7470675676 | 4815.57440540541 | 23702.3810810811 | -18886.8066756757 | 673.326675675676
 |  |  | TY SC Avg | 32413.7688317107 | 54.3319934136498 | 41.3036578581363 | 1117.01545201669 | 10073.7036717663 | 47546.223852573 | 30295.7343393602 | 26738.6968011127 | 3557.03753824757 | 664.284158553547
 | PIECE GOODS & SEWING | 19 | Prev YR | 31620.75 | 52.4396621916079 | 1432.55 | 21833.93 | 12329.49 | 151592.22 | 84473.54 | 86766 | -2292.46 | 6941.66
 |  |  | Curr YR | 36776.17 | 52.7953858263223 | 2220.51 | 27871.15 | 24938.05 | 169393.34 | 152634.31 | 164614 | -11979.69 | -451.61
 |  |  | LY SC Avg | 24102.435421286 | 51.9563161147218 | 1202.50885809313 | 17403.787616408 | 13845.6379046563 | 123013.325476718 | 93642.0661862528 | 95557.876940133 | -1915.81075388027 | -3346.5128713969
 |  |  | TY SC Avg | 30449.677518797 | 52.4745713443319 | 1780.51255639098 | 23051.3394486216 | 17486.734047619 | 151526.551428571 | 129022.251441103 | 134202.674185464 | -5180.4227443609 | -2297.0728320802
 | DOMESTIC GOODS | 20 | Prev YR | 16442.1 | 47.9301136992355 | 960.29 | 19961.98 | 8486.29 | 155598.64 | 56330.8 | 56459 | -128.2 | 10898.94
 |  |  | Curr YR | 18587.08 | 47.0221789685756 | 3867.71 | 25201.41 | 14090.23 | 163428.85 | 62429.86 | 65142 | -2712.14 | -3270.16
 |  |  | LY SC Avg | 22485.1076758045 | 47.8912736513492 | 1156.37606674613 | 23678.6879856973 | 9336.96461263409 | 160113.878033373 | 49351.8476638856 | 51260.505363528 | -1908.65769964243 | -727.634433849821
 |  |  | TY SC Avg | 20146.5271741512 | 47.9885264353717 | 1008.42384446878 | 23704.3956297919 | 7375.91906900329 | 149986.136407448 | 49029.9453778751 | 51756.2376779847 | -2726.29230010953 | -752.021248630887