mikayla colwell portfolio - wordpress.com · 2019-07-26 · about me my name is mikayla colwell i...
TRANSCRIPT
MIKAYLA COLWELL
PORTFOLIOUPDATED AS OF JULY 26, 2019
ABOUT ME
My name is Mikayla Colwell
I am currently a Senior at Bowling Green State University, studying Apparel Merchandising
and Product Development with a minor in Marketing
My expected graduation date is December 14th, 2019
Currently seeking a post graduation full time position in the buying, merchandising, or planning departments.
My most recent jobs include:
May 2019-August 2019 Buying intern at The Home Shopping Network (HSN)
March 2017-Present as the Choreographer/Production Manager for the USA National Miss Ohio and Michigan Pageant
January 2018-May 2019 as an Undergraduate Teaching Assistant at Bowling Green State University for the Merchandising Math Class
May 2018-January 2019 as a leader in training at Buckle
March 2017-January 2018 as a sales associate for White House Black Market
SPRING SEMESTER 2018- 20TH CENTURY FASHION 1970’S PROJECT
SPRING SEMESTER 2017- MERCHANDISING MATH
Answer to Question 1A (2 points):
Gross Sales 180,000.00$
Customer Returns 8,500.00$
BOM 39,000.00$
Purchases 94,000.00$ Answer to Question 1B (2 points):
Freight 900.00$
Alt/workroom expenses 950.00$
Cash Discounts 7,500.00$
EOM 45,000.00$
Direct Expenses 48,000.00$
Indirect Expenses 40,000.00$
$ AMOUNT % AMOUNT
Net Sales 171,500.00$ 100.00%
Cost of Goods 82,350.00$ 48.02%
Gross Margin 89,150.00$ 51.98%
Operating expenses 88,000.00$ 51.31%
Profit/Loss Statement 1,150.00$ 0.67%
Data Given
If purchases increase than the profit will increase, this is because purchases gets added in
with the Cost of Goods and if COG gets larger than so will GM, which in turn effects profit
since OE will stay the same.
Gross Margin wouldn't change if direct expenses increase, because the two don’t have a
relationship. If direct expenses increases, it would effect profit though.
Skeletal Profit and Loss Statement
PURCHASE ORDER
Vendor Name Order Date Bill To: Children's Store
Delivery Date Main Street
Home Town, NJ 12345 Hometown, OH 22222
Terms: 3% Net 30
Style No. Description Cost per Color Total Total
Unit XS S M L Quantity Cost
1234 V-necks 7.31$ Blue 3 6 6 3 18 131.58$
1235 Crew 7.31$ Green 3 6 6 3 18 131.58$
1236 Long sleeve 8.24$ Red 3 6 6 3 18 148.32$
1237 Cropped 7.93$ Blue 3 6 6 3 18 142.74$
1238 Boat-neck 7.93$ Green 3 6 6 3 18 142.74$
1239 Henley 8.67$ Red 3 6 6 3 18 156.06$
1240 Wicking Crew 9.33$ Blue 3 6 6 3 18 167.94$
1241 Wicking V-neck 9.33$ Green 3 6 6 3 18 167.94$
1242 Wicking Boat-neck 9.33$ Red 3 6 6 3 18 167.94$
1243 Sleveless 9.33$ Blue 3 6 6 3 18 167.94$
1244 V-necks 7.31$ Orange 3 6 6 3 18 131.58$
1245 Crew 7.31$ White 3 6 6 3 18 131.58$
1246 Long sleeve 8.24$ Black 3 6 6 3 18 148.32$
1247 Cropped 7.93$ Orange 3 6 6 3 18 142.74$
1248 Boat-neck 7.93$ White 3 6 6 3 18 142.74$
1249 Henley 8.67$ Black 3 6 6 3 18 156.06$
1250 Wicking Crew 9.33$ Orange 3 6 6 3 18 167.94$
1251 Wicking V-neck 9.33$ White 3 6 6 3 18 167.94$
1252 Wicking Boat-neck 9.33$ Black 3 6 6 3 18 167.94$
1253 Sleveless 9.33$ Orange 3 6 6 3 18 167.94$
1254 V-necks 7.31$ White 3 6 6 3 18 131.58$
1255 Crew 7.31$ Black 3 6 6 3 18 131.58$
1256 Long sleeve 8.24$ Orange 3 6 6 3 18 148.32$
1257 Cropped 7.93$ White 3 6 6 3 18 142.74$
Totals 72 144 144 72 432 3,603.78$
17% 33% 33% 17% 100.00% 0.00%
Sizes (in units)
XYZ Company
Percent of Totals:
Last Year Plan Actual
53.34% 53.42%
Department Name: 13.00% 12.70%
1.77% 1.90%
Department Number: 1.00% 1.30%
46.50% 46.90%
Merchandise Manager: 42.00% 41.80%
4.50% 5.10%
Buyer: 2.2 2.5
$99,289 $91,372
Period: 1.04 1.17
August September October November December January SEASON TOTALS
$30,478 $34,876 $29,870 $45,876 $51,456 $30,567 $223,123
$36,556 $31,987 $31,987 $47,980 $50,265 $29,702 $228,478
19.94% -8.28% 7.09% 4.59% -2.31% -2.83% 2.40%
15.88% 14.33% 13.68% 20.76% 22.43% 12.92% 100.00%
16.00% 14.00% 14.00% 21.00% 22.00% 13.00% 100.00%
$101,988 $90,891 $100,765 $127,827 $83,006 $102,867 $607,344
$95,961 $84,765 $100,759 $99,525 $63,860 $103,343 $548,212
$6,091 $4,641 $4,931 $4,641 $4,931 $3,771 $29,006
$6,674 $5,223 $4,643 $3,772 $4,353 $4,353 $29,017
9.6% 12.5% -5.8% -18.7% -11.7% 15.4% 0.03692%
21.0% 16.0% 17.0% 16.0% 17.0% 13.0% 100.00%
23.0% 18.0% 16.0% 13.0% 15.0% 15.0% 100.00%
$87,677 $101,988 $90,891 $100,765 $127,827 $83,006 $592,154
$91,391 $95,961 $84,765 $100,759 $99,525 $63,860 $536,261
2.50 3.00 2.65 2.10 1.98 2.15 2.65
2.50 3.00 2.65 2.10 1.98 2.15 2.3471
$50,880 $28,420 $44,675 $77,579 $11,566 $54,199 $267,319
$47,800 $26,014 $52,623 $50,519 $18,952 $73,538 $269,446
$23,743 $13,262 $20,847 $36,201 $5,397 $25,291 $124,741
$22,267 $12,119 $24,514 $23,534 $8,829 $34,257 $125,519
PLANNED
PURCHASES
AT RETAIL
LY Purchases @ Retail
PL Purchases @ Retail
Revised
Actual
PLANNED
PURCHASES
AT COST
LY Purchases @ Cost
PL Purchases @ Cost
Revised
Actual
BOM STOCK LY BOM Stock
PL BOM Stock
Revised
Actual
LY Stock/Sales Ratio
PL Stock/Sales Ratio
MARKDOWNS LY Markdowns
PL Markdowns
Revised
Actual
% Change
% of LY Mardowns
% of PL Markdowns
% Change
% of LY Sales
% of PL Sales
EOM STOCK LY EOM Stock
PL EOM Stock
Revised
Actual
SALES LY SALES
PL Sales
Revised
Actual
Average Stock
Fall 2016 GMROI
FALL
Julie P. % operating expense
% net profit
Monika S. Season Turnover
% alteration expense
353 % cash discount
% gross margin
SIX-MONTH MERCHANDISING PLAN
% initial markup
Junior's Sportswear % markdowns
Profit and Loss Statement
Six Month Merchandising Plan
Purchase Order
SPRING SEMESTER 2018-OMNICHANNEL RETAILING
Project on Kroger’s technology
of the Scan-and-go technologies
and the self-checkout lanes. The
goal of this was to understand
what these types of technologies
can do for stores.
SPRING 2018-FASHION FORECASTING
SPRING 2018-FASHION FORECASTING
Core Concepts Project
SPRING 2018-FASHION FORECASTING
Styling Project with
Local Boutique
SPRING 2018- FASHION FORECASTING
Pendulum project for
the classic item
which is Skinny Jeans
SPRING SEMESTER 2018-FASHION FORECASTING
Commercial, Directional,
and Essential
products/textiles/and prints
project
FALL SEMESTER 2018-MERCHANDISING SOFT GOODSPURCHASE ORDER
Nice Inc. Order Date Bill To: Buckle
Delivery Date Main Street
Home Town, NJ 12345 Kearne, NE 22222
Terms: 3% Net 30
Style No. Description Cost per Color Total Total
Unit 34 36 38 40 42 44 Quantity Cost
24-66-12 Otamy 98.00$ Black 7 16 31 15 11 4 84 8,232.00$
24-66-13 Otamy 98.00$ Red 10 26 44 23 16 5 124 12,152.00$
24-66-14 Otamy 98.00$ Taupe 6 14 26 13 9 4 72 7,056.00$
24-65-12 Orilike 78.00$ black 3 11 21 10 7 3 55 4,290.00$
24-65-13 Orilike 78.00$ red 6 17 31 15 10 4 83 6,474.00$
24-65-14 Orilike 78.00$ taupe 4 10 16 9 6 2 47 3,666.00$
24-51-18-1 Leanda 61.00$ Blue wash 16 39 70 35 25 11 196 11,956.00$
24-51-18-2 Leanda 61.00$ blue stone 8 17 30 15 14 5 89 5,429.00$
24-50-18-1 Sherry 57.00$ blue wash 29 73 130 65 47 18 362 20,634.00$
24-50-18-2 Sherry 57.00$ blue stone 12 31 58 28 22 8 159 9,063.00$
24-28-11 Tropp 43.00$ white 7 18 32 16 11 4 88 3,784.00$
24-28-12 Tropp 43.00$ black 6 15 27 13 10 4 75 3,225.00$
24-28-13 tropp 43.00$ red 3 7 12 6 4 2 34 1,462.00$
24-29-11 telt 53.00$ white 5 12 21 11 8 3 60 3,180.00$
24-29-12 telt 53.00$ black 4 10 18 9 6 2 49 2,597.00$
24-29-13 telt 53.00$ red 2 4 10 6 3 2 27 1,431.00$
128 320 577 289 209 81 1604 104,631.00$
7.98% 19.95% 35.97% 18.02% 13.03% 5.05% 100.00%
Compare to 8% 20% 36% 18% 13% 5% Total Qty Total Cost
XYZ Company
Sizes (in units)
Totals
Percent of Total
PURCHASE ORDER
Bossy & Co. Order Date Bill To: Buckle
Delivery Date Main Street
Home Town, NJ 12345 Kearne, NE 22222
Terms: 3% Net 30
Style No. Description Cost per Color Total Total
Unit 32 34 36 38 40 42 44 46 Quantity Cost
103 wakita 57.00$ charcoal 2 4 5 7 6 2 2 1 29 1,653.00$
107 wakita 57.00$ black 6 10 11 16 14 6 5 3 71 4,047.00$
103 wamiela 103.00$ charcoal 2 3 4 5 5 2 3 2 26 2,678.00$
107 wamiela 103.00$ black 5 9 10 14 12 6 4 2 62 6,386.00$
103 Cadet 74.00$ charcoal 2 4 3 4 4 2 1 1 21 1,554.00$
108 Cadet 74.00$ white 3 9 11 14 12 6 5 2 62 4,588.00$
107 Cadet 74.00$ black 2 3 4 5 5 2 2 1 24 1,776.00$
103 korine 61.00$ charcoal 1 2 2 3 3 1 1 1 14 854.00$
108 korine 61.00$ white 4 5 7 9 8 4 3 2 42 2,562.00$
107 korine 61.00$ black 2 2 3 4 3 1 1 1 17 1,037.00$
101 Sue 94.00$ blue 4 6 7 10 9 4 3 2 45 4,230.00$
103 Sue 94.00$ charcoal 5 8 10 13 12 5 4 2 59 5,546.00$
107 sue 94.00$ black 7 12 12 18 17 7 6 2 81 7,614.00$
101 Shila 98.00$ blue 1 2 2 2 2 2 1 0 12 1,176.00$
103 Shila 98.00$ charcoal 1 2 2 3 3 2 1 1 15 1,470.00$
107 Shila 90.00$ black 2 3 3 6 5 2 1 1 23 2,070.00$
49 84 96 133 120 54 43 24 603 49,241.00$
8.13% 13.93% 15.92% 22.06% 19.90% 8.96% 7.13% 3.98% 100.00%
Compare to 8% 14% 16% 22% 20% 9% 7% 4% Total Qty Total Cost
Sizes (in units)
XYZ Company
Totals
Percent of Total
Original/Should be:
Total Amount Spent 153,866.00$
Dollar amount and % of total
spent on:$ Amount %
Nice, Inc. $ 104,631.00 68.00% 104,629.04$ 68%
Category 1 only (Outerwear) $ 41,870.00 40.02% 41,851.62$ 40%
Category 2 only (Jeans) $ 47,082.00 45.00% 47,083.07$ 45%
Category 3 only (Jersey) $ 15,679.00 14.99% 15,694.36$ 15%
Bossy & Co. $ 49,241.00 32.00% 49,237.20$ 32%
Category 1 only (Knitwear) $ 14,764.00 29.98% 14,771.16$ 30%
Category 2 only (Blouses) $ 12,371.00 25.12% 12,309.30$ 25%
Category 3 only (Trousers) $ 22,106.00 44.89% 22,156.74$ 45%
SUMMARY OF MARKET EXPENDITURES
(Complete this section based on the Purchase orders you placed)
$ 153,872.00
SUMMARY CHARTS OF DISTRIBUTION OF SELECTION FACTORS
Category 32 34 36 38 40 42 44 46 Total % of Total
Bossy & Co. Knitwear
15 26 30 42 37 16 14 8 188 31%
Bossy & Co. Blousers
14 25 30 39 35 16 13 8 180 30%
Bossy & Co. Trousers
20 33 36 52 48 22 16 8 235 39%
Total 49 84 96 133 120 54 43 24 603 100%
% of Total Sizes 8% 14% 16% 22% 20% 9% 7% 4% 100%
Category 34 36 38 40 42 44 Total % of Total
Nice, Inc. Outerwear 36 94 169 85 59 22 465 29%
Nice, Inc. Jeans 65 160 288 143 108 42 806 50%
Nice, Inc. Jersey 27 66 120 61 42 17 333 21%
Total 128 320 577 289 209 81 1604 100%
% of Total Sizes 8% 20% 36% 18% 13% 5% 100%
Distribution of Sizes by Category
Distribution of Sizes by Category
Category Black Charcoal Blue White Total % of Total
Bossy & Co. Knitwear
133 55 0 0 188 31%
Bossy & Co. Blouses
41 35 0 104 180 30%
Bossy & Co. Trousers
104 74 57 0 235 39%
Total 278 164 57 104 603 100%
% of Total Colors 46% 27% 9% 17% 100%
Category Black Red Taupe Blue wash Blue stone White Total% of Total
Nice, Inc. Outerwear
139 207 119 0 0 0 465 29%
Nice, Inc. Jeans 0 0 0 558 248 0 806 50%
Nice, Inc. Jersey 124 61 0 0 0 148 333 21%
Total 263 268 119 558 248 148 1604 100%
% of Total Colors 16% 17% 7% 35% 15% 9% 100%
Distribution of Colors by Category
Distribution of Colors by Category
Buying
Project-
Purchase
Orders,
Summary of
Market
Expenditures,
and
Distribution
by Variables
SPRING 2019- PHOTOSHOP
Mood Board and Inspiration for the final project
SPRING 2019- PHOTOSHOP CONTINUED
SPRING 2019- PHOTOSHOP CONTINUED
SPRING 2019-VISUAL MERCHANDISING
WORK EXPERIENCE- BUCKLE, STYLING MANNEQUINS
WORK EXPERIENCE- BUCKLE, TABLE DISPLAYS
CONTACT INFORMATION:
Cell Phone: (513) 967-5777
Email: [email protected]
LinkedIn: www.linkedin.com/in/mikayla-colwell