Carlene Hatcher Across the board Markup % The VBA code is currently not written for the APPLY button, so when you enter a markup % for an individual item, the original formula will be overwritten. Simply type in the values you want to use.
Capability Examples
Mackie's Clothing Boutique
START WITH A STANDARD MARKUP HERE 
150.00%
Inventory Item List
THEN YOU CAN CHANGE INDIVIDUAL ITEM MARKUPS HERE
APPLY
=B9&", "&C9&", "&D9&", "&E9&", "&F9&", "&G9
 
UPC Category Item Style Group Size Color Full Description Supplier Cost Markup % Markup Diff than ATB% Retail Price with 150% markup Days of Lagtime QOH
100 Clothing Pant Dress Mens S Black Clothing, Pant, Dress, Mens, S, Black   $10.00 155.00% * $25.50 5 2
101 Clothing Pant Dress Mens S Brown Clothing, Pant, Dress, Mens, S, Brown   $10.00 150.00% $25.00 5 2
102 Clothing Pant Dress Mens S Tan Clothing, Pant, Dress, Mens, S, Tan   $10.00 150.00% $25.00 5 4
103 Clothing Pant Dress Mens M Black Clothing, Pant, Dress, Mens, M, Black   $13.00 150.00% $32.50 5 0
104 Clothing Pant Dress Mens M Brown Clothing, Pant, Dress, Mens, M, Brown   $13.00 150.00% $32.50 5 2
105 Clothing Pant Dress Mens M Tan Clothing, Pant, Dress, Mens, M, Tan   $13.00 150.00% $32.50 5 1
106 Clothing Pant Dress Mens L Black Clothing, Pant, Dress, Mens, L, Black   $16.00 150.00% $40.00 5 -1
107 Clothing Pant Dress Mens L Brown Clothing, Pant, Dress, Mens, L, Brown   $16.00 150.00% $40.00 5 1
108 Clothing Pant Dress Mens L Tan Clothing, Pant, Dress, Mens, L, Tan   $16.00 150.00% $40.00 5 4
109 Clothing Pant Dress Womens S Black Clothing, Pant, Dress, Womens, S, Black   $10.00 150.00% $25.00 5 3
110 Clothing Pant Dress Womens S Brown Clothing, Pant, Dress, Womens, S, Brown   $10.00 150.00% $25.00 5 2
111 Clothing Pant Dress Womens S Tan Clothing, Pant, Dress, Womens, S, Tan   $10.00 150.00% $25.00 5 2
112 Clothing Pant Dress Womens M Black Clothing, Pant, Dress, Womens, M, Black   $13.00 150.00% $32.50 5 5
113 Clothing Pant Dress Womens M Brown Clothing, Pant, Dress, Womens, M, Brown   $13.00 150.00% $32.50 5 2
114 Clothing Pant Dress Womens M Tan Clothing, Pant, Dress, Womens, M, Tan   $13.00 150.00% $32.50 5 -1
115 Clothing Pant Dress Womens L Black Clothing, Pant, Dress, Womens, L, Black   $16.00 150.00% $40.00 5 3
116 Clothing Pant Dress Womens L Brown Clothing, Pant, Dress, Womens, L, Brown   $16.00 150.00% $40.00 5 4
117 Clothing Pant Dress Womens L Tan Clothing, Pant, Dress, Womens, L, Tan   $16.00 150.00% $40.00 5 2
118 Clothing Pant Dress Boys S Black Clothing, Pant, Dress, Boys, S, Black   $7.00 150.00% $17.50 5 1
119 Clothing Pant Dress Boys S Brown Clothing, Pant, Dress, Boys, S, Brown   $7.00 150.00% $17.50 5 2
120 Clothing Pant Dress Boys S Tan Clothing, Pant, Dress, Boys, S, Tan   $7.00 150.00% $17.50 5 3
121 Clothing Pant Dress Boys M Black Clothing, Pant, Dress, Boys, M, Black   $8.50 150.00% $21.25 5 3
122 Clothing Pant Dress Boys M Brown Clothing, Pant, Dress, Boys, M, Brown   $8.50 150.00% $21.25 5 2
123 Clothing Pant Dress Boys M Tan Clothing, Pant, Dress, Boys, M, Tan   $8.50 150.00% $21.25 5 3
124 Clothing Pant Dress Boys L Black Clothing, Pant, Dress, Boys, L, Black   $10.00 150.00% $25.00 5 1
125 Clothing Pant Dress Boys L Brown Clothing, Pant, Dress, Boys, L, Brown   $10.00 150.00% $25.00 5 0
126 Clothing Pant Dress Boys L Tan Clothing, Pant, Dress, Boys, L, Tan   $10.00 150.00% $25.00 5 3
127 Clothing Pant Dress Girls S Black Clothing, Pant, Dress, Girls, S, Black   $7.00 150.00% $17.50 5 2
128 Clothing Pant Dress Girls S Brown Clothing, Pant, Dress, Girls, S, Brown   $7.00 150.00% $17.50 5 1
129 Clothing Pant Dress Girls S Tan Clothing, Pant, Dress, Girls, S, Tan   $7.00 150.00% $17.50 5 1
130 Clothing Pant Dress Girls M Black Clothing, Pant, Dress, Girls, M, Black   $8.50 150.00% $21.25 5 2
131 Clothing Pant Dress Girls M Brown Clothing, Pant, Dress, Girls, M, Brown   $8.50 150.00% $21.25 5 2
132 Clothing Pant Dress Girls M Tan Clothing, Pant, Dress, Girls, M, Tan   $8.50 150.00% $21.25 5 2
133 Clothing Pant Dress Girls L Black Clothing, Pant, Dress, Girls, L, Black   $10.00 150.00% $25.00 5 0
134 Clothing Pant Dress Girls L Brown Clothing, Pant, Dress, Girls, L, Brown   $10.00 150.00% $25.00 5 2
135 Clothing Pant Dress Girls L Tan Clothing, Pant, Dress, Girls, L, Tan   $10.00 150.00% $25.00 5 2
136 Clothing Pant Casual Mens S Green Clothing, Pant, Casual, Mens, S, Green   $17.50 150.00% $43.75 5 5
137 Clothing Pant Casual Mens S Blue Clothing, Pant, Casual, Mens, S, Blue   $17.50 150.00% $43.75 5 3
138 Clothing Pant Casual Mens S White Clothing, Pant, Casual, Mens, S, White   $17.50 150.00% $43.75 5 1
139 Clothing Pant Casual Mens M Green Clothing, Pant, Casual, Mens, M, Green   $22.00 150.00% $55.00 5 8
140 Clothing Pant Casual Mens M Blue Clothing, Pant, Casual, Mens, M, Blue   $22.00 150.00% $55.00 5 4
141 Clothing Pant Casual Mens M White Clothing, Pant, Casual, Mens, M, White   $22.00 150.00% $55.00 5 7
142 Clothing Pant Casual Mens L Green Clothing, Pant, Casual, Mens, L, Green   $28.00 150.00% $70.00 5 2
143 Clothing Pant Casual Mens L Blue Clothing, Pant, Casual, Mens, L, Blue   $28.00 150.00% $70.00 5 2
144 Clothing Pant Casual Mens L White Clothing, Pant, Casual, Mens, L, White   $28.00 150.00% $70.00 5 2
145 Clothing Pant Casual Womens S Green Clothing, Pant, Casual, Womens, S, Green   $17.50 150.00% $43.75 5 3
146 Clothing Pant Casual Womens S Blue Clothing, Pant, Casual, Womens, S, Blue   $17.50 150.00% $43.75 5 3
147 Clothing Pant Casual Womens S White Clothing, Pant, Casual, Womens, S, White   $17.50 150.00% $43.75 5 2
148 Clothing Pant Casual Womens M Green Clothing, Pant, Casual, Womens, M, Green   $22.00 150.00% $55.00 5 7
149 Clothing Pant Casual Womens M Blue Clothing, Pant, Casual, Womens, M, Blue   $22.00 150.00% $55.00 5 8
150 Clothing Pant Casual Womens M White Clothing, Pant, Casual, Womens, M, White   $22.00 150.00% $55.00 5 12
151 Clothing Pant Casual Womens L Green Clothing, Pant, Casual, Womens, L, Green   $28.00 150.00% $70.00 5 5
152 Clothing Pant Casual Womens L Blue Clothing, Pant, Casual, Womens, L, Blue   $28.00 150.00% $70.00 5 2
153 Clothing Pant Casual Womens L White Clothing, Pant, Casual, Womens, L, White   $28.00 150.00% $70.00 5 4
154 Clothing Pant Casual Boys S Green Clothing, Pant, Casual, Boys, S, Green   $10.00 150.00% $25.00 5 4
155 Clothing Pant Casual Boys S Blue Clothing, Pant, Casual, Boys, S, Blue   $10.00 150.00% $25.00 5 3
156 Clothing Pant Casual Boys S White Clothing, Pant, Casual, Boys, S, White   $10.00 150.00% $25.00 5 3
157 Clothing Pant Casual Boys M Green Clothing, Pant, Casual, Boys, M, Green   $14.50 150.00% $36.25 5 1
158 Clothing Pant Casual Boys M Blue Clothing, Pant, Casual, Boys, M, Blue   $14.50 150.00% $36.25 5 6
159 Clothing Pant Casual Boys M White Clothing, Pant, Casual, Boys, M, White   $14.50 150.00% $36.25 5 8
160 Clothing Pant Casual Boys L Green Clothing, Pant, Casual, Boys, L, Green   $19.00 150.00% $47.50 5 2
161 Clothing Pant Casual Boys L Blue Clothing, Pant, Casual, Boys, L, Blue   $19.00 150.00% $47.50 5 2
162 Clothing Pant Casual Boys L White Clothing, Pant, Casual, Boys, L, White   $19.00 150.00% $47.50 5 2
163 Clothing Pant Casual Girls S Green Clothing, Pant, Casual, Girls, S, Green   $10.00 150.00% $25.00 5 2
164 Clothing Pant Casual Girls S Blue Clothing, Pant, Casual, Girls, S, Blue   $10.00 150.00% $25.00 5 1
165 Clothing Pant Casual Girls S White Clothing, Pant, Casual, Girls, S, White   $10.00 150.00% $25.00 5 2
166 Clothing Pant Casual Girls M Green Clothing, Pant, Casual, Girls, M, Green   $14.50 150.00% $36.25 5 4
167 Clothing Pant Casual Girls M Blue Clothing, Pant, Casual, Girls, M, Blue   $14.50 150.00% $36.25 5 8
168 Clothing Pant Casual Girls M White Clothing, Pant, Casual, Girls, M, White   $14.50 150.00% $36.25 5 10
169 Clothing Pant Casual Girls L Green Clothing, Pant, Casual, Girls, L, Green   $19.00 150.00% $47.50 5 2
170 Clothing Pant Casual Girls L Blue Clothing, Pant, Casual, Girls, L, Blue   $19.00 150.00% $47.50 5 3
171 Clothing Pant Casual Girls L White Clothing, Pant, Casual, Girls, L, White   $19.00 150.00% $47.50 5 2
172 Clothing Skirt Flare Womens S Blue Clothing, Skirt, Flare, Womens, S, Blue   $25.00 150.00% $62.50 5 2
173 Clothing Skirt Flare Womens S Yellow Clothing, Skirt, Flare, Womens, S, Yellow   $25.00 150.00% $62.50 5 3
174 Clothing Skirt Flare Womens S Pink Clothing, Skirt, Flare, Womens, S, Pink   $25.00 150.00% $62.50 5 4
175 Clothing Skirt Flare Womens M Blue Clothing, Skirt, Flare, Womens, M, Blue   $29.50 150.00% $73.75 5 1
176 Clothing Skirt Flare Womens M Yellow Clothing, Skirt, Flare, Womens, M, Yellow   $29.50 150.00% $73.75 5 4
177 Clothing Skirt Flare Womens M Pink Clothing, Skirt, Flare, Womens, M, Pink   $29.50 150.00% $73.75 5 1
178 Clothing Skirt Flare Womens L Blue Clothing, Skirt, Flare, Womens, L, Blue   $34.00 150.00% $85.00 5 1
179 Clothing Skirt Flare Womens L Yellow Clothing, Skirt, Flare, Womens, L, Yellow   $34.00 150.00% $85.00 5 2
180 Clothing Skirt Flare Womens L Pink Clothing, Skirt, Flare, Womens, L, Pink   $34.00 150.00% $85.00 5 1
181 Clothing Skirt & Top Set Playtime Girls S Flowered Clothing, Skirt & Top Set, Playtime, Girls, S, Flowered   $10.00 150.00% $25.00 5 2
182 Clothing Skirt & Top Set Playtime Girls S Butterflies Clothing, Skirt & Top Set, Playtime, Girls, S, Butterflies   $10.00 150.00% $25.00 5 4
183 Clothing Skirt & Top Set Playtime Girls S Animals Clothing, Skirt & Top Set, Playtime, Girls, S, Animals   $10.00 150.00% $25.00 5 0
184 Clothing Skirt & Top Set Playtime Girls M Flowered Clothing, Skirt & Top Set, Playtime, Girls, M, Flowered   $11.50 150.00% $28.75 5 1
185 Clothing Skirt & Top Set Playtime Girls M Butterflies Clothing, Skirt & Top Set, Playtime, Girls, M, Butterflies   $11.50 150.00% $28.75 5 5
186 Clothing Skirt & Top Set Playtime Girls M Animals Clothing, Skirt & Top Set, Playtime, Girls, M, Animals   $11.50 150.00% $28.75 5 3
187 Clothing Skirt & Top Set Playtime Girls L Flowered Clothing, Skirt & Top Set, Playtime, Girls, L, Flowered   $13.00 150.00% $32.50 5 2
188 Clothing Skirt & Top Set Playtime Girls L Butterflies Clothing, Skirt & Top Set, Playtime, Girls, L, Butterflies   $13.00 150.00% $32.50 5 3
189 Clothing Skirt & Top Set Playtime Girls L Animals Clothing, Skirt & Top Set, Playtime, Girls, L, Animals   $13.00 150.00% $32.50 5 5
190 Footwear Shoes SlipOns Mens S Black Footwear, Shoes, SlipOns, Mens, S, Black   $2.50 150.00% $6.25 5 2
191 Footwear Shoes SlipOns Mens S Red Footwear, Shoes, SlipOns, Mens, S, Red   $2.50 150.00% $6.25 5 1
192 Footwear Shoes SlipOns Mens S White Footwear, Shoes, SlipOns, Mens, S, White   $2.50 150.00% $6.25 5 0
193 Footwear Shoes SlipOns Mens M Black Footwear, Shoes, SlipOns, Mens, M, Black   $5.50 150.00% $13.75 5 2
194 Footwear Shoes SlipOns Mens M Red Footwear, Shoes, SlipOns, Mens, M, Red   $5.50 150.00% $13.75 5 4
195 Footwear Shoes SlipOns Mens M White Footwear, Shoes, SlipOns, Mens, M, White   $5.50 150.00% $13.75 5 -1
196 Footwear Shoes SlipOns Mens L Black Footwear, Shoes, SlipOns, Mens, L, Black   $8.50 150.00% $21.25 5 4
197 Footwear Shoes SlipOns Mens L Red Footwear, Shoes, SlipOns, Mens, L, Red   $8.50 150.00% $21.25 5 3
198 Footwear Shoes SlipOns Mens L White Footwear, Shoes, SlipOns, Mens, L, White   $8.50 150.00% $21.25 5 2
199 Footwear Shoes SlipOns Womens S Black Footwear, Shoes, SlipOns, Womens, S, Black   $2.50 150.00% $6.25 5 2
200 Footwear Shoes SlipOns Womens S Red Footwear, Shoes, SlipOns, Womens, S, Red   $2.50 150.00% $6.25 5 3
201 Footwear Shoes SlipOns Womens S White Footwear, Shoes, SlipOns, Womens, S, White   $2.50 150.00% $6.25 5 2
202 Footwear Shoes SlipOns Womens M Black Footwear, Shoes, SlipOns, Womens, M, Black   $5.50 150.00% $13.75 5 4
203 Footwear Shoes SlipOns Womens M Red Footwear, Shoes, SlipOns, Womens, M, Red   $5.50 150.00% $13.75 5 2
204 Footwear Shoes SlipOns Womens M White Footwear, Shoes, SlipOns, Womens, M, White   $5.50 150.00% $13.75 5 2
205 Footwear Shoes SlipOns Womens L Black Footwear, Shoes, SlipOns, Womens, L, Black   $8.50 150.00% $21.25 5 3
206 Footwear Shoes SlipOns Womens L Red Footwear, Shoes, SlipOns, Womens, L, Red   $8.50 150.00% $21.25 5 3
207 Footwear Shoes SlipOns Womens L White Footwear, Shoes, SlipOns, Womens, L, White   $8.50 150.00% $21.25 5 4
208 Footwear Shoes SlipOns Boys S Black Footwear, Shoes, SlipOns, Boys, S, Black   $4.50 150.00% $11.25 5 2
209 Footwear Shoes SlipOns Boys S Red Footwear, Shoes, SlipOns, Boys, S, Red   $4.50 150.00% $11.25 5 3
210 Footwear Shoes SlipOns Boys S White Footwear, Shoes, SlipOns, Boys, S, White   $4.50 150.00% $11.25 5 4
211 Footwear Shoes SlipOns Boys M Black Footwear, Shoes, SlipOns, Boys, M, Black   $2.50 150.00% $6.25 5 4
212 Footwear Shoes SlipOns Boys M Red Footwear, Shoes, SlipOns, Boys, M, Red   $2.50 150.00% $6.25 5 -1
213 Footwear Shoes SlipOns Boys M White Footwear, Shoes, SlipOns, Boys, M, White   $2.50 150.00% $6.25 5 2
214 Footwear Shoes SlipOns Boys L Black Footwear, Shoes, SlipOns, Boys, L, Black   $5.50 150.00% $13.75 5 2
215 Footwear Shoes SlipOns Boys L Red Footwear, Shoes, SlipOns, Boys, L, Red   $5.50 150.00% $13.75 5 1
216 Footwear Shoes SlipOns Boys L White Footwear, Shoes, SlipOns, Boys, L, White   $5.50 150.00% $13.75 5 5
217 Footwear Shoes SlipOns Girls S Black Footwear, Shoes, SlipOns, Girls, S, Black   $4.50 150.00% $11.25 5 1
218 Footwear Shoes SlipOns Girls S Red Footwear, Shoes, SlipOns, Girls, S, Red   $4.50 150.00% $11.25 5 4
219 Footwear Shoes SlipOns Girls S White Footwear, Shoes, SlipOns, Girls, S, White   $4.50 150.00% $11.25 5 2
220 Footwear Shoes SlipOns Girls M Black Footwear, Shoes, SlipOns, Girls, M, Black   $2.50 150.00% $6.25 5 2
221 Footwear Shoes SlipOns Girls M Red Footwear, Shoes, SlipOns, Girls, M, Red   $2.50 150.00% $6.25 5 4
222 Footwear Shoes SlipOns Girls M White Footwear, Shoes, SlipOns, Girls, M, White   $2.50 150.00% $6.25 5 5
223 Footwear Shoes SlipOns Girls L Black Footwear, Shoes, SlipOns, Girls, L, Black   $5.50 150.00% $13.75 5 4
224 Footwear Shoes SlipOns Girls L Red Footwear, Shoes, SlipOns, Girls, L, Red   $5.50 150.00% $13.75 5 2
225 Footwear Shoes SlipOns Girls L White Footwear, Shoes, SlipOns, Girls, L, White   $5.50 150.00% $13.75 5 5
226 Accessories Tie Clip Mens One Size Gold Accessories, Tie Clip, , Mens, One Size, Gold   $2.50 150.00% $6.25 5 4
227 Accessories Tie Clip Mens One Size Silver Accessories, Tie Clip, , Mens, One Size, Silver   $2.50 150.00% $6.25 5 4
228 Accessories Cuff Links Mens One Size Gold Accessories, Cuff Links, , Mens, One Size, Gold   $2.50 150.00% $6.25 5 3
229 Accessories Cuff Links Mens One Size Silver Accessories, Cuff Links, , Mens, One Size, Silver   $2.50 150.00% $6.25 5 3
230 Accessories Hair Accessories Ponytail Ties Women Women Assorted Set Accessories, Hair Accessories, Ponytail Ties, Women, Women, Assorted Set   $4.50 150.00% $11.25 5 3
231 Accessories Hair Accessories Headbands Women Women Assorted Set Accessories, Hair Accessories, Headbands, Women, Women, Assorted Set   $4.50 150.00% $11.25 5 2
232 Accessories Hair Accessories Ponytail Ties Girls Girls Assorted Set Accessories, Hair Accessories, Ponytail Ties, Girls, Girls, Assorted Set   $4.50 150.00% $11.25 5 1
233 Accessories Hair Accessories Headbands Girls Girls Assorted Set Accessories, Hair Accessories, Headbands, Girls, Girls, Assorted Set   $4.50 150.00% $11.25 5 3
234 Accessories Jewelry Necklace Women 18" Gold Accessories, Jewelry, Necklace, Women, 18", Gold   $17.50 150.00% $43.75 5 2
235 Accessories Jewelry Necklace Women 18" Silver Accessories, Jewelry, Necklace, Women, 18", Silver   $17.50 150.00% $43.75 5 3
236 Accessories Jewelry Necklace Girls 10" Gold Accessories, Jewelry, Necklace, Girls, 10", Gold   $14.50 150.00% $36.25 5 0
237 Accessories Jewelry Necklace Girls 10" Silver Accessories, Jewelry, Necklace, Girls, 10", Silver   $14.50 150.00% $36.25 5 4
238 Accessories Jewelry Bracelet Women 8" Gold Accessories, Jewelry, Bracelet, Women, 8", Gold   $4.00 150.00% $10.00 5 4
239 Accessories Jewelry Bracelet Women 8" Silver Accessories, Jewelry, Bracelet, Women, 8", Silver   $4.00 150.00% $10.00 5 2
240 Accessories Jewelry Bracelet Girls 5" Gold Accessories, Jewelry, Bracelet, Girls, 5", Gold   $4.50 150.00% $11.25 5 5
241 Accessories Jewelry Bracelet Girls 5" Silver Accessories, Jewelry, Bracelet, Girls, 5", Silver   $4.50 150.00% $11.25 5 4
242 Hats Sun hat Eyelet Women Women White Hats, Sun hat, Eyelet, Women, Women, White   $5.50 150.00% $13.75 5 2
243 Hats Sun hat Eyelet Women Women Blue Hats, Sun hat, Eyelet, Women, Women, Blue   $5.50 150.00% $13.75 5 0
244 Hats Sun hat Eyelet Girls Girls White Hats, Sun hat, Eyelet, Girls, Girls, White   $4.00 150.00% $10.00 5 1
245 Hats Sun hat Eyelet Girls Girls Blue Hats, Sun hat, Eyelet, Girls, Girls, Blue   $4.00 150.00% $10.00 5 2
246 Hats Ball cap Cotton Mens Mens Blue Hats, Ball cap, Cotton, Mens, Mens, Blue   $2.50 150.00% $6.25 5 3
247 Hats Ball cap Cotton Mens Mens Green Hats, Ball cap, Cotton, Mens, Mens, Green   $2.50 150.00% $6.25 5 2
248 Hats Ball cap Cotton Mens Mens Red Hats, Ball cap, Cotton, Mens, Mens, Red   $2.50 150.00% $6.25 5 3
249 Hats Ball cap Cotton Womens Womens Blue Hats, Ball cap, Cotton, Womens, Womens, Blue   $2.50 150.00% $6.25 5 2
250 Hats Ball cap Cotton Womens Womens Green Hats, Ball cap, Cotton, Womens, Womens, Green   $2.50 150.00% $6.25 5 2
251 Hats Ball cap Cotton Womens Womens Red Hats, Ball cap, Cotton, Womens, Womens, Red   $2.50 150.00% $6.25 5 1
252 Hats Ball cap Cotton Kids Kids Blue Hats, Ball cap, Cotton, Kids, Kids, Blue   $2.50 150.00% $6.25 5 4
253 Hats Ball cap Cotton Kids Kids Green Hats, Ball cap, Cotton, Kids, Kids, Green   $2.50 150.00% $6.25 5 2
254 Hats Ball cap Cotton Kids Kids Red Hats, Ball cap, Cotton, Kids, Kids, Red   $2.50 150.00% $6.25 5 2