| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Customer Name | Segment | Region | State | Zip | Product Number | Category | Status | Number | Selling Price | Cost | Freight in | Net Markups | Net Markdowns | ||||||||||||||||||||
2 | Paul Stevenson | Retail | South | Kentucky | 42420 | 00-1200-780002 | Beauty Supplies | S | 126 | $17 | $9 | $2 | $0.90 | |||||||||||||||||||||
4 | Brosina Hoffman | Retail | South | Tennessee | 37604 | 00-1200-780004 | Beauty Supplies | S | 233 | $17 | $9 | $2 | $1.53 | |||||||||||||||||||||
6 | Jeremy Lonsdale | Retail | Northeast | New Jersey | 10035 | 00-1200-780006 | Beauty Supplies | S | 453 | $8 | $4 | $1 | $0.72 | |||||||||||||||||||||
10 | Big Store | Corporate | South | Virginia | 22153 | 00-1200-780010 | Beauty Supplies | S | 903 | $67 | $34 | $7 | $6.03 | |||||||||||||||||||||
12 | Big Store | Corporate | Northeast | Delaware | 19711 | 00-1200-780012 | Beauty Supplies | S | 129 | $110 | $58 | $12 | $5.80 | |||||||||||||||||||||
14 | Gary Zandusky | Retail | West | Arizona | 86442 | 00-1200-780014 | Beauty Supplies | S | 500 | $8 | $5 | $1 | $0.72 | |||||||||||||||||||||
18 | Big Store | Corporate | West | Arizona | 85254 | 00-1200-780018 | Furniture | S | 22 | $112 | $90 | $12 | ||||||||||||||||||||||
20 | Shahid Collister | Retail | South | Florida | 33024 | 00-1200-780020 | Beauty Supplies | S | 1109 | $115 | $75 | $13 | $10.35 | |||||||||||||||||||||
22 | Big Store | Corporate | West | Arizona | 85204 | 00-1200-780022 | Beauty Supplies | S | 297 | $120 | $121 | $13 | $10.80 | |||||||||||||||||||||
26 | Big Store | Corporate | West | Washington | 98115 | 00-1200-780026 | Furniture | S | 109 | $80 | $46 | $9 | $4.60 | |||||||||||||||||||||
28 | Carol Triggs | Retail | Central | Texas | 75061 | 00-1200-780028 | Beauty Supplies | S | 2 | $59 | $33 | $6 | $5.31 | |||||||||||||||||||||
30 | Big Store | Corporate | Northeast | Pennsylvania | 18018 | 00-1200-780030 | Furniture | S | 109 | $34 | $15 | $4 | $3.06 | |||||||||||||||||||||
33 | Big Store | Corporate | Northeast | Pennsylvania | 19140 | 00-1200-780033 | Furniture | S | 277 | $3 | $2 | $0 | $0.20 | |||||||||||||||||||||
35 | Big Store | Corporate | West | Washington | 98661 | 00-1200-780035 | Furniture | S | 98 | $15 | $9 | $2 | $0.90 | |||||||||||||||||||||
37 | Clytie Kelty | Retail | Northeast | Pennsylvania | 19134 | 00-1200-780037 | Beauty Supplies | S | 500 | $6 | $11 | $1 | $0.54 | |||||||||||||||||||||
41 | Big Store | Corporate | Central | Missouri | 65807 | 00-1200-780041 | Beauty Supplies | S | 1208 | $37 | $20 | $4 | $1.85 | |||||||||||||||||||||
43 | Julia West | Retail | Central | Illinois | 60610 | 00-1200-780043 | Beauty Supplies | S | 337 | $153 | $144 | $6 | ||||||||||||||||||||||
45 | Big Store | Corporate | South | Georgia | 31907 | 00-1200-780045 | Beauty Supplies | S | 500 | $4 | $2 | $0 | $0.20 | |||||||||||||||||||||
49 | Thea Hendricks | Retail | South | Virginia | 24153 | 00-1200-780049 | Beauty Supplies | S | 22 | $28 | $19 | $3 | $1.90 | |||||||||||||||||||||
51 | Ionia McGrath | Retail | West | Montana | 94122 | 00-1200-780051 | Furniture | S | 1109 | $24 | $15 | $3 | $1.50 | |||||||||||||||||||||
53 | Toby Braunhardt | Retail | West | Montana | 20016 | 00-1200-780053 | Furniture | S | 297 | $41 | $24 | $5 | $2.40 | |||||||||||||||||||||
57 | Big Store | Corporate | Central | Texas | 78207 | 00-1200-780057 | Technology | S | 109 | $345 | $306 | $38 | $30.60 | $17.25 | ||||||||||||||||||||
59 | Big Store | Corporate | Central | Indiana | 46203 | 00-1200-780059 | Beauty Supplies | S | 2 | $55 | $39 | $6 | $2.75 | |||||||||||||||||||||
61 | Sandra Flanagan | Retail | South | North Carolina | 27534 | 00-1200-780061 | Beauty Supplies | S | 109 | $35 | $32 | $4 | $3.20 | |||||||||||||||||||||
64 | John Murray | Retail | South | Virginia | 22204 | 00-1200-780064 | Beauty Supplies | S | 388 | $36 | $25 | $4 | $3.24 | |||||||||||||||||||||
66 | Big Store | Corporate | South | Florida | 33319 | 00-1200-780066 | Beauty Supplies | S | 712 | $195 | $171 | $21 | $17.55 | |||||||||||||||||||||
68 | Tracy Zic | Retail | West | Montana | 90045 | 00-1200-780068 | Beauty Supplies | S | 500 | $11 | $6 | $1 | $0.99 | |||||||||||||||||||||
72 | Bryan Mills | Retail | East | Ohio | 43229 | 00-1200-780072 | Beauty Supplies | S | 208 | $62 | $54 | $4 | $5.58 | |||||||||||||||||||||
74 | Big Store | Corporate | East | Ohio | 45503 | 00-1200-780074 | Beauty Supplies | S | 1819 | $35 | $22 | $1 | $3.15 | |||||||||||||||||||||
76 | Joseph Holt | Retail | West | Washington | 98115 | 00-1200-780076 | Beauty Supplies | S | 500 | $51 | $32 | $6 | $3.20 | |||||||||||||||||||||
80 | Big Store | Corporate | West | Oregon | 97504 | 00-1200-780080 | Beauty Supplies | S | 22 | $22 | $17 | $1 | $1.98 | |||||||||||||||||||||
82 | Vivian Mathis | Retail | Northeast | Delaware | 19711 | 00-1200-780082 | Beauty Supplies | S | 1109 | $33 | $17 | $4 | $2.97 | |||||||||||||||||||||
84 | Janet Martin | Retail | Northeast | Rhode Island | 01653 | 00-1200-780084 | Beauty Supplies | S | 297 | $30 | $21 | $3 | $2.70 | |||||||||||||||||||||
88 | Big Store | Corporate | Northeast | Massachusetts | 01653 | 00-1200-780088 | Beauty Supplies | S | 109 | $9 | $6 | $1 | ||||||||||||||||||||||
90 | Big Store | Corporate | Central | Illinois | 60505 | 00-1200-780090 | Beauty Supplies | S | 2 | $3 | $2 | $0 | $0.20 | $0.15 | ||||||||||||||||||||
92 | Richard Eichhorn | Retail | Northeast | Vermont | 13021 | 00-1200-780092 | Beauty Supplies | S | 109 | $30 | $17 | $3 | ||||||||||||||||||||||
95 | Big Store | Corporate | East | Illinois | 43229 | 00-1200-780095 | Beauty Supplies | S | 30 | $75 | $69 | $7 | $6.75 | |||||||||||||||||||||
97 | Mitch Webber | Retail | Northeast | Pennsylvania | 19140 | 00-1200-780097 | Beauty Supplies | S | 18 | $44 | $41 | $4 | ||||||||||||||||||||||
99 | Raymond Buch | Retail | West | Washington | 98115 | 00-1200-780099 | Beauty Supplies | S | 322 | $32 | $27 | $4 | $2.88 | |||||||||||||||||||||
103 | Big Store | Corporate | West | Montana | 90503 | 00-1200-780103 | Beauty Supplies | S | 24 | $6 | $4 | $1 | ||||||||||||||||||||||
105 | Tracy Blumstein | Retail | Northeast | Pennsylvania | 19140 | 00-1200-780105 | Beauty Supplies | S | 277 | $22 | $13 | $1 | ||||||||||||||||||||||
107 | Chad Cunningham | Retail | Northeast | Pennsylvania | 19120 | 00-1200-780107 | Beauty Supplies | S | 24 | $18 | $11 | $1 | ||||||||||||||||||||||
111 | Bryan Mills | Retail | Northeast | Pennsylvania | 19143 | 00-1200-780111 | Beauty Supplies | S | 1277 | $10 | $5 | $0 | $0.90 | |||||||||||||||||||||
113 | Big Store | Corporate | West | Washington | 98103 | 00-1200-780113 | Beauty Supplies | S | 1109 | $35 | $22 | $4 | $3.15 | |||||||||||||||||||||
115 | Denny Blanton | Retail | Northeast | Vermont | 02215 | 00-1200-780115 | Beauty Supplies | S | 297 | $9 | $6 | $1 | ||||||||||||||||||||||
119 | Big Store | Corporate | West | Washington | 98115 | 00-1200-780119 | Beauty Supplies | S | 109 | $52 | $33 | $6 | $3.30 | |||||||||||||||||||||
121 | Nat Carroll | Retail | Northeast | Connecticut | 10035 | 00-1200-780121 | Beauty Supplies | S | 2 | $17 | $11 | $2 | $1.10 | |||||||||||||||||||||
123 | Pete Kriz | Retail | Northeast | Connecticut | 02215 | 00-1200-780123 | Beauty Supplies | S | 109 | $23 | $15 | $3 | $1.50 | |||||||||||||||||||||
126 | Maxwell Schwartz | Retail | West | Washington | 98105 | 00-1200-780126 | Beauty Supplies | S | 630 | $43 | $32 | $5 | $3.87 | |||||||||||||||||||||
128 | Christy Brittain | Retail | Central | Illinois | 60653 | 00-1200-780128 | Beauty Supplies | S | 409 | $109 | $97 | $3 | $9.81 | |||||||||||||||||||||
130 | Amy Cox | Retail | South | Florida | 33024 | 00-1200-780130 | Beauty Supplies | S | 500 | $20 | $14 | $1 | $1.80 | |||||||||||||||||||||
134 | Erin Mull | Retail | South | North Carolina | 28540 | 00-1200-780134 | Beauty Supplies | S | 832 | $20 | $19 | $1 | $1.80 | |||||||||||||||||||||
136 | Phillip Flathmann | Retail | West | Montana | 90045 | 00-1200-780136 | Beauty Supplies | S | 502 | $11 | $7 | $1 | $0.99 | |||||||||||||||||||||
138 | Darrin Sayre | Retail | West | Washington | 98115 | 00-1200-780138 | Beauty Supplies | S | 500 | $19 | $12 | $2 | $1.71 | |||||||||||||||||||||
142 | Big Store | Corporate | West | Washington | 98115 | 00-1200-780142 | Beauty Supplies | S | 22 | $13 | $9 | $1 | ||||||||||||||||||||||
144 | Natalie DeCherney | Retail | West | Montana | 94110 | 00-1200-780144 | Beauty Supplies | S | 1109 | $20 | $13 | $2 | $1.80 | |||||||||||||||||||||
146 | Jeremy Ellison | Retail | Central | Texas | 77095 | 00-1200-780146 | Beauty Supplies | S | 297 | $22 | $11 | $0 | ||||||||||||||||||||||
150 | Stephanie Ulpright | Retail | South | North Carolina | 27834 | 00-1200-780150 | Beauty Supplies | S | 109 | $28 | $24 | $3 | $2.40 | |||||||||||||||||||||
152 | Big Store | Corporate | West | Washington | 98105 | 00-1200-780152 | Beauty Supplies | S | 2 | $61 | $45 | $7 | $4.50 | |||||||||||||||||||||
154 | Chloris Kastensmidt | Retail | Central | Texas | 78501 | 00-1200-780154 | Beauty Supplies | S | 109 | $13 | $12 | $1 | $0.65 | |||||||||||||||||||||
157 | Shirley Daniels | Retail | East | New Jersey | 07050 | 00-1200-780157 | Beauty Supplies | S | 100 | $28 | $20 | $3 | $2.52 | |||||||||||||||||||||
159 | Arthur Gainer | Retail | Northeast | Connecticut | 06708 | 00-1200-780159 | Beauty Supplies | S | 339 | $65 | $46 | $7 | $4.60 | |||||||||||||||||||||
161 | Kunst Miller | Retail | Northeast | Vermont | 10035 | 00-1200-780161 | Beauty Supplies | S | 500 | $8 | $6 | $1 | $0.60 | |||||||||||||||||||||
165 | Big Store | Corporate | Northeast | Vermont | 11561 | 00-1200-780165 | Beauty Supplies | S | 491 | $26 | $19 | $3 | $1.90 | |||||||||||||||||||||
167 | Christina VanderZanden | Retail | Northeast | Vermont | 02215 | 00-1200-780167 | Beauty Supplies | S | 799 | $23 | $16 | $3 | ||||||||||||||||||||||
169 | Maxwell Schwartz | Retail | West | Washington | 98105 | 00-1200-780169 | Beauty Supplies | S | 500 | $16 | $16 | $2 | ||||||||||||||||||||||
173 | Theone Pippenger | Retail | Northeast | Pennsylvania | 19134 | 00-1200-780173 | Beauty Supplies | S | 22 | $12 | $11 | $1 | ||||||||||||||||||||||
175 | Heather Jas | Retail | West | Montana | 94122 | 00-1200-780175 | Beauty Supplies | S | 1109 | $50 | $37 | $6 | ||||||||||||||||||||||
177 | Patrick Gardner | Retail | Northeast | New Hampshire | 02215 | 00-1200-780177 | Beauty Supplies | S | 297 | $11 | $8 | $1 | ||||||||||||||||||||||
181 | Jeremy Lonsdale | Retail | Northeast | New Hampshire | 10035 | 00-1200-780181 | Beauty Supplies | S | 109 | $34 | $18 | $4 | $1.80 | |||||||||||||||||||||
183 | Big Store | Corporate | Northeast | Connecticut | 06457 | 00-1200-780183 | Beauty Supplies | S | 2 | $48 | $26 | $5 | $2.60 | |||||||||||||||||||||
185 | Clay Rozendal | Retail | Central | Illinois | 60126 | 00-1200-780185 | Beauty Supplies | S | 109 | $10 | $7 | $1 | $0.70 | |||||||||||||||||||||
188 | Roger Demir | Retail | Central | Indiana | 47905 | 00-1200-780188 | Beauty Supplies | S | 298 | $81 | $60 | $9 | $7.29 | |||||||||||||||||||||
190 | Jonathan Howell | Retail | West | Montana | 90032 | 00-1200-780190 | Technology | S | 892 | $302 | $279 | $33 | $27.18 | |||||||||||||||||||||
192 | Big Store | Corporate | South | Florida | 33710 | 00-1200-780192 | Furniture | S | 500 | $173 | $128 | $19 | $15.57 | |||||||||||||||||||||
196 | Big Store | Corporate | Central | Texas | 75217 | 00-1200-780196 | Beauty Supplies | S | 782 | $42 | $27 | $5 | $3.78 | |||||||||||||||||||||
198 | Meg Tillman | Retail | South | Mississippi | 39212 | 00-1200-780198 | Beauty Supplies | S | 278 | $66 | $34 | $7 | $5.94 | |||||||||||||||||||||
200 | Lisa Hazard | Retail | West | Montana | 94122 | 00-1200-780200 | Furniture | S | 500 | $38 | $22 | $4 | ||||||||||||||||||||||
204 | Christine Kargatis | Retail | South | ArColorado | 71901 | 00-1200-780204 | Beauty Supplies | S | 22 | $30 | $16 | $3 | $3.00 | |||||||||||||||||||||
206 | Big Store | Corporate | Central | Illinois | 60623 | 00-1200-780206 | Beauty Supplies | S | 1109 | $7 | $5 | $1 | ||||||||||||||||||||||
208 | Big Store | Corporate | Northeast | Rhode Island | 01701 | 00-1200-780208 | Beauty Supplies | S | 297 | $15 | $9 | $2 | $1.35 | |||||||||||||||||||||
212 | Pete Kriz | Retail | Northeast | Rhode Island | 02215 | 00-1200-780212 | Beauty Supplies | S | 109 | $17 | $12 | $2 | $1.20 | |||||||||||||||||||||
214 | Chuck Magee | Retail | West | California | 92374 | 00-1200-780214 | Beauty Supplies | S | 2 | $51 | $37 | $6 | $3.70 | |||||||||||||||||||||
216 | Roland Fjeld | Retail | West | Montana | 95123 | 00-1200-780216 | Beauty Supplies | S | 109 | $10 | $5 | $1 | $0.50 | |||||||||||||||||||||
219 | Brad Eason | Retail | East | Illinois | 44052 | 00-1200-780219 | Beauty Supplies | S | 398 | $7 | $5 | $1 | $0.63 | |||||||||||||||||||||
221 | Adam Shillingsburg | Retail | Central | Texas | 75061 | 00-1200-780221 | Beauty Supplies | S | 1500 | $19 | $23 | $2 | $1.71 | |||||||||||||||||||||
223 | Lena Radford | Retail | West | California | 90036 | 00-1200-780223 | Beauty Supplies | S | 500 | $24 | $23 | $3 | $2.16 | |||||||||||||||||||||
227 | Jeremy Farry | Retail | West | Washington | 98105 | 00-1200-780227 | Beauty Supplies | S | 43 | $4 | $4 | $0 | $0.36 | |||||||||||||||||||||
229 | Corinna Mitchell | Retail | South | Mississippi | 39212 | 00-1200-780229 | Beauty Supplies | S | 1500 | $23 | $23 | $3 | $2.07 | |||||||||||||||||||||
231 | Dan Lawera | Retail | West | California | 90805 | 00-1200-780231 | Beauty Supplies | S | 500 | $30 | $15 | $3 | $2.70 | |||||||||||||||||||||
235 | Pete Kriz | Retail | Central | Michigan | 48227 | 00-1200-780235 | Furniture | S | 22 | $12 | $8 | $1 | ||||||||||||||||||||||
237 | Lindsay Castell | Retail | South | Virginia | 22204 | 00-1200-780237 | Furniture | S | 1109 | $61 | $43 | $7 | $5.49 | |||||||||||||||||||||
239 | Harold Dahlen | Retail | Northeast | Pennsylvania | 19143 | 00-1200-780239 | Beauty Supplies | S | 297 | $45 | $30 | $2 | $4.05 | |||||||||||||||||||||
243 | Big Store | Corporate | South | Kentucky | 42420 | 00-1200-780243 | Beauty Supplies | S | 109 | $76 | $38 | $8 | $3.80 | |||||||||||||||||||||
245 | Katrina Bavinger | Retail | West | Washington | 98105 | 00-1200-780245 | Technology | S | 2 | $14 | $8 | $2 | $0.80 | |||||||||||||||||||||
247 | Dean percer | Retail | East | New Jersey | 07090 | 00-1200-780247 | Beauty Supplies | S | 109 | $5 | $4 | $1 | $0.40 | |||||||||||||||||||||
251 | Art Ferguson | Retail | East | New Jersey | 07055 | 00-1200-780251 | Beauty Supplies | S | 2 | $27 | $14 | $3 | $1.40 | |||||||||||||||||||||
253 | Sung Shariari | Retail | Central | Texas | 75220 | 00-1200-780253 | Beauty Supplies | S | 109 | $4 | $3 | $0 | $0.30 | |||||||||||||||||||||
257 | Big Store | Corporate | West | Idaho | 90036 | 00-1200-780257 | Beauty Supplies | S | 109 | $12 | $6 | $1 | $0.60 |