Carlene Hatcher
Capability Examples
Mackie's Clothing Boutique
Inventory Reconcilition
="Purchases ("&InvPurchQtysTotal&" items)"
         '=IF(H9<>N9,H9-N9,0) Total Net Adjusts From "Inv Purch Qty by UPC" From "Sales Qtys by UPC" Total Ending Inventory
$2,879     $5,130
Inv Count & Reconciliation Q1 2021 Inventory Activity by Item FINAL, TRUE INVENTORY FOR QTR
UPC Category Item Style Group Size Color Physical Count Adjust Calc'd Inv By Value of Net Adjs Beg Inv Purchases (1427 items) Sales                 (1256 items) Calculated End Inv Actual Final EOQ Inventory Cost Ending Inventory Value
100 Clothing Pant Dress Mens S Black 2 0 $0 0 4 2 2 2 $10 $20
101 Clothing Pant Dress Mens S Brown 2 2 $20 0 8 8 0 2 $10 $20
102 Clothing Pant Dress Mens S Tan 4 3 $30 0 5 4 1 4 $10 $40
103 Clothing Pant Dress Mens M Black 0 1 $13 0 17 18 -1 0 $13 $0
104 Clothing Pant Dress Mens M Brown 2 2 $26 0 14 14 0 2 $13 $26
105 Clothing Pant Dress Mens M Tan 1 2 $26 0 9 10 -1 1 $13 $13
106 Clothing Pant Dress Mens L Black -1 2 $32 0 17 20 -3 -1 $16 ($16)
107 Clothing Pant Dress Mens L Brown 1 2 $32 0 13 14 -1 1 $16 $16
108 Clothing Pant Dress Mens L Tan 4 0 $0 0 8 4 4 4 $16 $64
109 Clothing Pant Dress Womens S Black 3 1 $10 0 4 2 2 3 $10 $30
110 Clothing Pant Dress Womens S Brown 2 2 $20 0 10 10 0 2 $10 $20
111 Clothing Pant Dress Womens S Tan 2 2 $20 0 10 10 0 2 $10 $20
112 Clothing Pant Dress Womens M Black 5 2 $26 0 9 6 3 5 $13 $65
113 Clothing Pant Dress Womens M Brown 2 2 $26 0 12 12 0 2 $13 $26
114 Clothing Pant Dress Womens M Tan -1 2 $26 0 17 20 -3 -1 $13 ($13)
115 Clothing Pant Dress Womens L Black 3 2 $32 0 11 10 1 3 $16 $48
116 Clothing Pant Dress Womens L Brown 4 2 $32 0 6 4 2 4 $16 $64
117 Clothing Pant Dress Womens L Tan 2 0 $0 0 4 2 2 2 $16 $32
118 Clothing Pant Dress Boys S Black 1 2 $14 0 7 8 -1 1 $7 $7
119 Clothing Pant Dress Boys S Brown 2 2 $14 0 8 8 0 2 $7 $14
120 Clothing Pant Dress Boys S Tan 3 2 $14 0 5 4 1 3 $7 $21
121 Clothing Pant Dress Boys M Black 3 2 $17 0 11 10 1 3 $9 $26
122 Clothing Pant Dress Boys M Brown 2 0 $0 0 6 4 2 2 $9 $17
123 Clothing Pant Dress Boys M Tan 3 0 $0 0 5 2 3 3 $9 $26
124 Clothing Pant Dress Boys L Black 1 2 $20 0 9 10 -1 1 $10 $10
125 Clothing Pant Dress Boys L Brown 0 2 $20 0 8 10 -2 0 $10 $0
126 Clothing Pant Dress Boys L Tan 3 2 $20 0 9 8 1 3 $10 $30
127 Clothing Pant Dress Girls S Black 2 2 $14 0 6 6 0 2 $7 $14
128 Clothing Pant Dress Girls S Brown 1 2 $14 0 7 8 -1 1 $7 $7
129 Clothing Pant Dress Girls S Tan 1 2 $14 0 9 10 -1 1 $7 $7
130 Clothing Pant Dress Girls M Black 2 2 $17 0 6 6 0 2 $9 $17
131 Clothing Pant Dress Girls M Brown 2 2 $17 0 8 8 0 2 $9 $17
132 Clothing Pant Dress Girls M Tan 2 2 $17 0 10 10 0 2 $9 $17
133 Clothing Pant Dress Girls L Black 0 2 $20 0 8 10 -2 0 $10 $0
134 Clothing Pant Dress Girls L Brown 2 2 $20 0 10 10 0 2 $10 $20
135 Clothing Pant Dress Girls L Tan 2 0 $0 0 6 4 2 2 $10 $20
136 Clothing Pant Casual Mens S Green 5 2 $35 0 5 2 3 5 $18 $88
137 Clothing Pant Casual Mens S Blue 3 2 $35 0 7 6 1 3 $18 $53
138 Clothing Pant Casual Mens S White 1 0 $0 0 7 6 1 1 $18 $18
139 Clothing Pant Casual Mens M Green 8 4 $88 0 20 16 4 8 $22 $176
140 Clothing Pant Casual Mens M Blue 4 4 $88 0 18 18 0 4 $22 $88
141 Clothing Pant Casual Mens M White 7 2 $44 0 17 12 5 7 $22 $154
142 Clothing Pant Casual Mens L Green 2 2 $56 0 8 8 0 2 $28 $56
143 Clothing Pant Casual Mens L Blue 2 0 $0 0 6 4 2 2 $28 $56
144 Clothing Pant Casual Mens L White 2 0 $0 0 6 4 2 2 $28 $56
145 Clothing Pant Casual Womens S Green 3 2 $35 0 5 4 1 3 $18 $53
146 Clothing Pant Casual Womens S Blue 3 0 $0 0 5 2 3 3 $18 $53
147 Clothing Pant Casual Womens S White 2 0 $0 0 4 2 2 2 $18 $35
148 Clothing Pant Casual Womens M Green 7 2 $44 0 13 8 5 7 $22 $154
149 Clothing Pant Casual Womens M Blue 8 2 $44 0 12 6 6 8 $22 $176
150 Clothing Pant Casual Womens M White 12 2 $44 0 14 4 10 12 $22 $264
151 Clothing Pant Casual Womens L Green 5 2 $56 0 5 2 3 5 $28 $140
152 Clothing Pant Casual Womens L Blue 2 2 $56 0 6 6 0 2 $28 $56
153 Clothing Pant Casual Womens L White 4 2 $56 0 6 4 2 4 $28 $112
154 Clothing Pant Casual Boys S Green 4 2 $20 0 8 6 2 4 $10 $40
155 Clothing Pant Casual Boys S Blue 3 2 $20 0 9 8 1 3 $10 $30
156 Clothing Pant Casual Boys S White 3 2 $20 0 5 4 1 3 $10 $30
157 Clothing Pant Casual Boys M Green 1 2 $29 0 23 24 -1 1 $15 $15
158 Clothing Pant Casual Boys M Blue 6 4 $58 0 16 14 2 6 $15 $87
159 Clothing Pant Casual Boys M White 8 2 $29 0 14 8 6 8 $15 $116
160 Clothing Pant Casual Boys L Green 2 2 $38 0 6 6 0 2 $19 $38
161 Clothing Pant Casual Boys L Blue 2 2 $38 0 6 6 0 2 $19 $38
162 Clothing Pant Casual Boys L White 2 2 $38 0 6 6 0 2 $19 $38
163 Clothing Pant Casual Girls S Green 2 0 $0 0 6 4 2 2 $10 $20
164 Clothing Pant Casual Girls S Blue 1 2 $20 0 9 10 -1 1 $10 $10
165 Clothing Pant Casual Girls S White 2 0 $0 0 6 4 2 2 $10 $20
166 Clothing Pant Casual Girls M Green 4 0 $0 0 18 14 4 4 $15 $58
167 Clothing Pant Casual Girls M Blue 8 4 $58 0 18 14 4 8 $15 $116
168 Clothing Pant Casual Girls M White 10 2 $29 0 14 6 8 10 $15 $145
169 Clothing Pant Casual Girls L Green 2 2 $38 0 10 10 0 2 $19 $38
170 Clothing Pant Casual Girls L Blue 3 2 $38 0 7 6 1 3 $19 $57
171 Clothing Pant Casual Girls L White 2 2 $38 0 6 6 0 2 $19 $38
172 Clothing Skirt Flare Womens S Blue 2 0 $0 0 6 4 2 2 $25 $50
173 Clothing Skirt Flare Womens S Yellow 3 2 $50 0 7 6 1 3 $25 $75
174 Clothing Skirt Flare Womens S Pink 4 2 $50 0 6 4 2 4 $25 $100
175 Clothing Skirt Flare Womens M Blue 1 2 $59 0 25 26 -1 1 $30 $30
176 Clothing Skirt Flare Womens M Yellow 4 2 $59 0 22 20 2 4 $30 $118
177 Clothing Skirt Flare Womens M Pink 1 2 $59 0 23 24 -1 1 $30 $30
178 Clothing Skirt Flare Womens L Blue 1 0 $0 0 7 6 1 1 $34 $34
179 Clothing Skirt Flare Womens L Yellow 2 0 $0 0 6 4 2 2 $34 $68
180 Clothing Skirt Flare Womens L Pink 1 2 $68 0 7 8 -1 1 $34 $34
181 Clothing Skirt & Top Set Playtime Girls S Flowered 2 2 $20 0 12 12 0 2 $10 $20
182 Clothing Skirt & Top Set Playtime Girls S Butterflies 4 2 $20 0 12 10 2 4 $10 $40
183 Clothing Skirt & Top Set Playtime Girls S Animals 0 2 $20 0 18 20 -2 0 $10 $0
184 Clothing Skirt & Top Set Playtime Girls M Flowered 1 2 $23 0 25 26 -1 1 $12 $12
185 Clothing Skirt & Top Set Playtime Girls M Butterflies 5 4 $46 0 29 28 1 5 $12 $58
186 Clothing Skirt & Top Set Playtime Girls M Animals 3 2 $23 0 27 26 1 3 $12 $35
187 Clothing Skirt & Top Set Playtime Girls L Flowered 2 2 $26 0 6 6 0 2 $13 $26
188 Clothing Skirt & Top Set Playtime Girls L Butterflies 3 0 $0 0 5 2 3 3 $13 $39
189 Clothing Skirt & Top Set Playtime Girls L Animals 5 2 $26 0 5 2 3 5 $13 $65
190 Footwear Shoes SlipOns Mens S Black 2 2 $5 0 6 6 0 2 $3 $5
191 Footwear Shoes SlipOns Mens S Red 1 2 $5 0 9 10 -1 1 $3 $3
192 Footwear Shoes SlipOns Mens S White 0 2 $5 0 8 10 -2 0 $3 $0
193 Footwear Shoes SlipOns Mens M Black 2 0 $0 0 8 6 2 2 $6 $11
194 Footwear Shoes SlipOns Mens M Red 4 2 $11 0 8 6 2 4 $6 $22
195 Footwear Shoes SlipOns Mens M White -1 2 $11 0 15 18 -3 -1 $6 ($6)
196 Footwear Shoes SlipOns Mens L Black 4 2 $17 0 4 2 2 4 $9 $34
197 Footwear Shoes SlipOns Mens L Red 3 2 $17 0 5 4 1 3 $9 $26
198 Footwear Shoes SlipOns Mens L White 2 0 $0 0 6 4 2 2 $9 $17
199 Footwear Shoes SlipOns Womens S Black 2 2 $5 0 6 6 0 2 $3 $5
200 Footwear Shoes SlipOns Womens S Red 3 0 $0 0 5 2 3 3 $3 $8
201 Footwear Shoes SlipOns Womens S White 2 2 $5 0 6 6 0 2 $3 $5
202 Footwear Shoes SlipOns Womens M Black 4 2 $11 0 8 6 2 4 $6 $22
203 Footwear Shoes SlipOns Womens M Red 2 0 $0 0 8 6 2 2 $6 $11
204 Footwear Shoes SlipOns Womens M White 2 0 $0 0 8 6 2 2 $6 $11
205 Footwear Shoes SlipOns Womens L Black 3 0 $0 0 5 2 3 3 $9 $26
206 Footwear Shoes SlipOns Womens L Red 3 2 $17 0 11 10 1 3 $9 $26
207 Footwear Shoes SlipOns Womens L White 4 2 $17 0 4 2 2 4 $9 $34
208 Footwear Shoes SlipOns Boys S Black 2 2 $9 0 10 10 0 2 $5 $9
209 Footwear Shoes SlipOns Boys S Red 3 0 $0 0 5 2 3 3 $5 $14
210 Footwear Shoes SlipOns Boys S White 4 2 $9 0 6 4 2 4 $5 $18
211 Footwear Shoes SlipOns Boys M Black 4 2 $5 0 8 6 2 4 $3 $10
212 Footwear Shoes SlipOns Boys M Red -1 2 $5 0 15 18 -3 -1 $3 ($3)
213 Footwear Shoes SlipOns Boys M White 2 0 $0 0 8 6 2 2 $3 $5
214 Footwear Shoes SlipOns Boys L Black 2 2 $11 0 10 10 0 2 $6 $11
215 Footwear Shoes SlipOns Boys L Red 1 2 $11 0 7 8 -1 1 $6 $6
216 Footwear Shoes SlipOns Boys L White 5 2 $11 0 5 2 3 5 $6 $28
217 Footwear Shoes SlipOns Girls S Black 1 2 $9 0 7 8 -1 1 $5 $5
218 Footwear Shoes SlipOns Girls S Red 4 2 $9 0 4 2 2 4 $5 $18
219 Footwear Shoes SlipOns Girls S White 2 2 $9 0 10 10 0 2 $5 $9
220 Footwear Shoes SlipOns Girls M Black 2 2 $5 0 14 14 0 2 $3 $5
221 Footwear Shoes SlipOns Girls M Red 4 2 $5 0 8 6 2 4 $3 $10
222 Footwear Shoes SlipOns Girls M White 5 2 $5 0 5 2 3 5 $3 $13
223 Footwear Shoes SlipOns Girls L Black 4 2 $11 0 4 2 2 4 $6 $22
224 Footwear Shoes SlipOns Girls L Red 2 2 $11 0 8 8 0 2 $6 $11
225 Footwear Shoes SlipOns Girls L White 5 2 $11 0 5 2 3 5 $6 $28
226 Accessories Tie Clip 0 Mens One Size Gold 4 2 $5 0 4 2 2 4 $3 $10
227 Accessories Tie Clip 0 Mens One Size Silver 4 2 $5 0 4 2 2 4 $3 $10
228 Accessories Cuff Links 0 Mens One Size Gold 3 2 $5 0 9 8 1 3 $3 $8
229 Accessories Cuff Links 0 Mens One Size Silver 3 2 $5 0 7 6 1 3 $3 $8
230 Accessories Hair Accessories Ponytail Ties Women Women Assorted Set 3 0 $0 0 5 2 3 3 $5 $14
231 Accessories Hair Accessories Headbands Women Women Assorted Set 2 2 $9 0 14 14 0 2 $5 $9
232 Accessories Hair Accessories Ponytail Ties Girls Girls Assorted Set 1 2 $9 0 17 18 -1 1 $5 $5
233 Accessories Hair Accessories Headbands Girls Girls Assorted Set 3 2 $9 0 7 6 1 3 $5 $14
234 Accessories Jewelry Necklace Women 18" Gold 2 2 $35 0 14 14 0 2 $18 $35
235 Accessories Jewelry Necklace Women 18" Silver 3 2 $35 0 7 6 1 3 $18 $53
236 Accessories Jewelry Necklace Girls 10" Gold 0 2 $29 0 16 18 -2 0 $15 $0
237 Accessories Jewelry Necklace Girls 10" Silver 4 2 $29 0 8 6 2 4 $15 $58
238 Accessories Jewelry Bracelet Women 8" Gold 4 0 $0 0 6 2 4 4 $4 $16
239 Accessories Jewelry Bracelet Women 8" Silver 2 2 $8 0 10 10 0 2 $4 $8
240 Accessories Jewelry Bracelet Girls 5" Gold 5 2 $9 0 5 2 3 5 $5 $23
241 Accessories Jewelry Bracelet Girls 5" Silver 4 2 $9 0 8 6 2 4 $5 $18
242 Hats Sun hat Eyelet Women Women White 2 0 $0 0 8 6 2 2 $6 $11
243 Hats Sun hat Eyelet Women Women Blue 0 2 $11 0 12 14 -2 0 $6 $0
244 Hats Sun hat Eyelet Girls Girls White 1 2 $8 0 9 10 -1 1 $4 $4
245 Hats Sun hat Eyelet Girls Girls Blue 2 2 $8 0 14 14 0 2 $4 $8
246 Hats Ball cap Cotton Mens Mens Blue 3 0 $0 0 5 2 3 3 $3 $8
247 Hats Ball cap Cotton Mens Mens Green 2 2 $5 0 10 10 0 2 $3 $5
248 Hats Ball cap Cotton Mens Mens Red 3 0 $0 0 5 2 3 3 $3 $8
249 Hats Ball cap Cotton Womens Womens Blue 2 0 $0 0 4 2 2 2 $3 $5
250 Hats Ball cap Cotton Womens Womens Green 2 2 $5 0 8 8 0 2 $3 $5
251 Hats Ball cap Cotton Womens Womens Red 1 2 $5 0 7 8 -1 1 $3 $3
252 Hats Ball cap Cotton Kids Kids Blue 4 2 $5 0 8 6 2 4 $3 $10
253 Hats Ball cap Cotton Kids Kids Green 2 0 $0 0 6 4 2 2 $3 $5
254 Hats Ball cap Cotton Kids Kids Red 2 2 $5 0 6 6 0 2 $3 $5