Retail Management Question

Description

Objective: To simulate an actual Collection Buy, choosing the styles from the attached vendor [Nike] line sheet, merchandising them on the fixtures and adding up the total buy at cost and retail and inserting on the excel purchase order sample .

Don't use plagiarized sources. Get Your Custom Assignment on
Retail Management Question
From as Little as $13/Page

Step One

Attached is the line list from Nike Girls activewear delivery. Review the styles and
the assortment. You will make decisions on what styles you want to buy based on LY [Last Year] history, the forecasting sites and your great taste for fashion!
Your job will be to BUY the best assortment of styles to fill 2-four ways and 3-T Stands
and one wall bar.
You may eliminate any style. Remember you cannot buy it all -please back up your decision with trend /forecast research.

Customer Profile: An upper middle class older Millennial woman who wants her little girl to look fashionable and trendy in Nike branded activewear.
Create a brief powerpoint [submitted as a PDF] illustrating the buy.

Step Two

Show by style # and picture cad how you will merchandise each style on the floor. See Excel Spreadsheet for Fixture setup.
Below is an example of how you will set up the merchandise on the fixtures and the total amount of units that will fit on a fixture arm. (You can change the layout but not the fixtures). Base quantities to buy are 12 pieces per arm per T-stand and 18 pieces per arm per 4-way. There is also one wall bar with 12 pieces as the capacity.
Note: You do not have to buy only one style per arm. You may split up quantities. For example 6 tops and 6 bottoms, or 12 bottoms and 6 jackets. (Work in increments of 6 since most styles in these price points are purchased in dozens or half dozens). Merchandise the collection, that is the fun part – so use your creativity! (See Excel Worksheet for visual of fixtures).

Step Three

1.You are a chain of small stores in New Jersey You have 6 stores, On the purchase order fill in total quantity by style purchased, and total quantity by 6 stores. (Use a real or made up retailer name).

2.Reminder- You have ONE ‘cluster’ so create ONE buy and multiply by 6 stores to get total cost and retail for your purchase order calculations. Assume all doing the same volume. (Hint: that means that you will multiply your total initial store layout by 6).

3.Fill in retail price point from line sheet. You have negotiated a 50% markup for the collection. Calculate all costs with this markup and fill in to the cost on purchase order. Calculate markup for each style and cumulative markup at the bottom of the purchase order. MU= Retail-Cost Retail Step Four

Create a classification analysis by units in Excel for TY (this year) buy and compare it to LY (last year). Use the chart below as a guideline. Units can be approximate when you are working in $.
2. Create a tops to bottom ratio % by units.(review the powerpoint if needed).
Sum how many tops and divide in to total units. Sum total bottoms and divide in to total units. Top divided by bottom = the %.
P.O Details: This delivery is early Fall 9/1-9/15 in-store.
PO # is 3452312 and the vendor number is 329.
You may use a (real) retailer name of your choice or that which you have been researching in prior assignments!


Unformatted Attachment Preview

Nike Collections Fall 24
Buyers use – Little Girls 4-6X
Retail MSRP’s included on line sheets
Create cost prices for purchase order
9/1-9/15
Child addition style #36G932 $44.00
FASHION INSTITUTE OF TECHNOLOGY **
FM206
Prof Ostroff
FBM DEPARTMENT
Assignment created by Catherine Geib
COLLECTION BUY
Objective
To simulate an actual Collection Buy, choosing the styles from the attached Vendor line
sheet , merchandising them on the fixtures and adding up the total buy at cost and retail
and inserting on the excel purchase order sample .
Step One
Attached is the line list from Nike Girls activewear delivery. Review the styles and
the assortment. You will make decisions on what styles you want to Buy based on LY history
the forcasting sites and your great taste for fashion!
Your job will be to BUY the best assortment of styles to fill 2-four ways and 3-T Stands
and one wall bar . Remember these are 2 groups from many on the selling floor .
You may eliminate any style , remember you cannot buy it all -please back up your decision.
Customer ProfileA upper middle class woman who wants her little girl to look fashionable
and trendy in Nike Branded activwear.
Since the assignment will be done online you will create a powerpoint illustrating the buy.
Step Two
Show by style # and picture cad how you will merchandise each style on the floor.
Below is an example of how you will set up the merchandise on the fixtures and the total
amount of units that will fit on a fixture arm. (You can change the layout but not the fixtures)
Base quantities to buy are 12 pieces per arm per T-stand and 18 pieces per arm per 4-way.
There is also one wall bar with 12 pieces as the capacity.
Note :You do not have to Buy only one style per arm. You may split up quantities. For
example 6 tops and 6 bottoms, or 10 bottoms and 8 jackets. Merchandise the collection, that
is the fun part – so use your creativity!
2 Four Ways
4 arms
Note you can have more than one style on a fixture- split the units
18pcs.
18pcs
18pcs.
18pcs.
12pcs.
12pcs.
18pcs.
18pcs.
wall bar 12 pieces
18pcs.
18pcs.
12pcs
12pcs
12pcs
3 T-Stands
2 arms
12pcs
Step Three
1.You are a chain of small stores in New Jersey You have 6 stores. On the
purchase order fill in total quantity by style purchased, and total quantity by 6 stores.
2.Reminder- You have ONE cluster so create ONE buy and multiply by 6 stores to get total cost
and retail for your purchase order calculations.
3.Fill in retail price point from line sheet. You have negotiated a 60% markup for the collection.
Calculate all costs with this Markup and fill in to the cost on Purchase order. Calculate Markup for
each style and cumulative markup at the bottom of the purchase order.
Step Four
1. Create a classification analysis by units in Excel for TY buy and compare it to last year .
Use the chart below as a guideline. Remember units can be approximate.
2. Create a tops to bottom ratio % by units.(review powerpoint if needed) Paste class analysis
and tops to bottom ratio to back of board . Online class – include in powerpoint
Sum how many tops and divide in to total units. Sum
total bottoms and divide in to total units. Top / bottom is the percentage.
Details This delivery is early Fall 7/30 7/01- 7/15 in store
PO number is 3452312 and the vendor number is 329
You may make up the store name !
Step 5
Online students – submit to the drop box with a full explanation of your buy included on powerpoint
Excel purchase order on tab 4 and charts on tab 2 and 3
Nike Girls Activewear Class Analysis
Classification Analysis in Units and in Dollars
Attached is Last Years Class sales analysis from
Fall 2021. Use these % as a guideline when considering the buy for this year
This is LY selling , take into consideration 2022 trend ( check forecasting )
Hint: calculate LY units to give you a Guideline for this year
Units can change based on trend and what you want to buy.
Class # Classifications
2022
2022
2021
$
16 TOPS
%
UNITS
% LY UNIT SELLING
35%
18 LEGGINGS
20%
20 SHORTS
5%
22 JACKETS
20%
24 DRESSES
5%
28 SETS
15%
Total
100%
Tops to Bottoms Ratio
Tops to Bottom Ratio as a Percentage% (for separates)
Category
Units % to total Dollars $
% to total
Tops
Bottoms
Total
0
100%
0
100%
PO#:
STORE
DEPT:
VENDOR:
VND #:
DELIVERYMONTH
START Date
Cancel Date
STYLE # STYLE DESCRIPTION
COLOR
CLASS #
unit
unit
COST
RETAIL
MU%
TOTAL Units
Total COST
Total RETAIL
Total Cum MU%
# Door Clusters
6 stores
GRAND
TOTAL
GRAND
TOTAL
A
UNITS
COST
GRAND
TOTAL
RETAIL
PO#:
fb85136cea57480a398300a74a46b6b8
Blank Purchase order
3/22/20242:04 AM
STORE
DEPT:
VENDOR:
VND #:
DELIVERYMONTH
START
CANCEL
DISC %
STYLE # STYLE DESCRIPTION
# Door Clusters
COLOR
CLASS
SUB CL
unit
unit
COST
RETAIL
TOTAL
COST
RETAIL
MU%
MU%
A
B
C
D
GRAND
TOTAL
GRAND
TOTAL
GRAND
TOTAL
UNITS
COST
RETAIL
Example of a Collections buy.
Purchase Order and Classification analysis can be submitted to the Power
point as last two slides or as separate excel document.
Add trend analysis
 Directional trends for time period
Four Way Displays – Fixture One with units and Retail price points
10 Units
8 Units
10 Units
12 Units
6 Units
12 Units
8 Units
6 Units
Fourway Fixture Two with units and Retail price
12 Units
6 Units
10 Units
8 Units
12 Units
12 Units
6 Units
6 Units
Fourway Fixture Three with units and Retail price
18 Units
18 Units
18 Units
18 Units
T-stand Fixture One with units and retail prices
6 Units
6 Units
6 Units
6 Units
T-stand Fixture Two with units and retail prices
12 Units
7 Units
5 Units
T-stand Fixture Three with units and retail prices
12 Units
12 Units
Eliminated Styles
These styles were not chosen to be a
part of the assortment for this store.
The Morgan coverup is too closely
similar to the Silhouette of Willow
and the pattern of Amelia/Haley. I felt
it was best to keep this style in the
solid black over the patterns because
it is more likely to sell. I also wanted
to keep a variety of silhouettes on
display.
Purchase order and Classification breakdown can be added
here

Or submitted as separate excel documents
Explanations Top to Bottom Ratio from
separates Tops 61% Bottoms 39%
 I bought more tops than bottoms because from experience, I see a lot
of women wearing a patterned bathing suit top with a solid bottom.
So for this assignment I bought some solid navy bottoms, some solid
black bottoms and a few different patterned bottoms. A customer
can buy multiple different tops to pair with 1 soilid color bottom that
matches the print. Alot of these Vera Bradley tops and bottoms are
reversible too so they can easily be mixed and matched.
Example of a Collections buy.
Purchase Order and Classification analysis can be submitted to the Power
point as last two slides or as separate excel document.
Add trend analysis
 Directional trends for time period
Four Way Displays – Fixture One with units and Retail price points
10 Units
8 Units
10 Units
12 Units
6 Units
12 Units
8 Units
6 Units
Fourway Fixture Two with units and Retail price
12 Units
6 Units
10 Units
8 Units
12 Units
12 Units
6 Units
6 Units
Fourway Fixture Three with units and Retail price
18 Units
18 Units
18 Units
18 Units
T-stand Fixture One with units and retail prices
6 Units
6 Units
6 Units
6 Units
T-stand Fixture Two with units and retail prices
12 Units
7 Units
5 Units
T-stand Fixture Three with units and retail prices
12 Units
12 Units
Eliminated Styles
These styles were not chosen to be a
part of the assortment for this store.
The Morgan coverup is too closely
similar to the Silhouette of Willow
and the pattern of Amelia/Haley. I felt
it was best to keep this style in the
solid black over the patterns because
it is more likely to sell. I also wanted
to keep a variety of silhouettes on
display.
Purchase order and Classification breakdown can be added
here

Or submitted as separate excel documents
Explanations Top to Bottom Ratio from
separates Tops 61% Bottoms 39%
 I bought more tops than bottoms because from experience, I see a lot
of women wearing a patterned bathing suit top with a solid bottom.
So for this assignment I bought some solid navy bottoms, some solid
black bottoms and a few different patterned bottoms. A customer
can buy multiple different tops to pair with 1 soilid color bottom that
matches the print. Alot of these Vera Bradley tops and bottoms are
reversible too so they can easily be mixed and matched.
FASHION INSTITUTE OF TECHNOLOGY **
FM206
FBM DEPARTMENT
COLLECTION BUY
Objective
To simulate an actual Collection Buy, choosing the styles from the attached Vendor line
sheet , merchandising them on the fixtures and adding up the total buy at cost and retail
and inserting on the excel purchase order sample .
Step One
Attached is the line list from Nike Girls activewear delivery. Review the styles and
the assortment. You will make decisions on what styles you want to Buy based on LY history
the forcasting sites and your great taste for fashion!
Your job will be to BUY the best assortment of styles to fill 2-four ways and 3-T Stands
and one wall bar . Remember these are 2 groups from many on the selling floor .
You may eliminate any style , remember you cannot buy it all -please back up your decision.
Customer ProfileA upper middle class woman who wants her little girl to look fashionable
and trendy in Nike Branded activwear.
Since the assignment will be done online you will create a powerpoint illustrating the buy.
Step Two
Show by style # and picture cad how you will merchandise each style on the floor.
Below is an example of how you will set up the merchandise on the fixtures and the total
amount of units that will fit on a fixture arm. (You can change the layout but not the fixtures)
Base quantities to buy are 12 pieces per arm per T-stand and 18 pieces per arm per 4-way.
There is also one wall bar with 12 pieces as the capacity.
Note :You do not have to Buy only one style per arm. You may split up quantities. For
example 6 tops and 6 bottoms, or 10 bottoms and 8 jackets. Merchandise the collection, that
is the fun part – so use your creativity!
2 Four Ways
4 arms
Note you can have more than one style on a fixture- split the units
18pcs.
18pcs
18pcs.
18pcs.
12pcs.
12pcs.
18pcs.
18pcs.
wall bar 12 pieces
18pcs.
18pcs.
12pcs
12pcs
12pcs
3 T-Stands
2 arms
12pcs
Step Three
1.You are a chain of small stores in New Jersey You have 6 stores. On the
purchase order fill in total quantity by style purchased, and total quantity by 6 stores.
2.Reminder- You have ONE cluster so create ONE buy and multiply by 6 stores to get total cost
and retail for your purchase order calculations.
3.Fill in retail price point from line sheet. You have negotiated a 60% markup for the collection.
Calculate all costs with this Markup and fill in to the cost on Purchase order. Calculate Markup for
each style and cumulative markup at the bottom of the purchase order.
Step Four
1. Create a classification analysis by units in Excel for TY buy and compare it to last year .
Use the chart below as a guideline. Remember units can be approximate.
2. Create a tops to bottom ratio % by units.(review powerpoint if needed) Paste class analysis
and tops to bottom ratio to back of board . Online class – include in powerpoint
Sum how many tops and divide in to total units. Sum
total bottoms and divide in to total units. Top / bottom is the percentage.
Details This delivery is early Fall 7/30 7/01- 7/15 in store
PO number is 3452312 and the vendor number is 329
You may make up the store name !
Step 5
Online students – submit to the drop box with a full explanation of your buy included on powerpoint
Excel purchase order on tab 4 and charts on tab 2 and 3
Nike Girls Activewear Class Analysis
Classification Analysis in Units and in Dollars
Attached is Last Years Class sales analysis from
Fall 2021. Use these % as a guideline when considering the buy for this year
This is LY selling , take into consideration 2022 trend ( check forecasting )
Hint: calculate LY units to give you a Guideline for this year
Units can change based on trend and what you want to buy.
Class # Classifications
2022
2022
2021
$
16 TOPS
%
UNITS
% LY UNIT SELLING
35%
18 LEGGINGS
20%
20 SHORTS
5%
22 JACKETS
20%
24 DRESSES
5%
28 SETS
15%
Total
100%
Tops to Bottoms Ratio
Tops to Bottom Ratio as a Percentage% (for separates)
Category
Units % to total Dollars $
% to total
Tops
Bottoms
Total
0
100%
0
100%
PO#:
STORE
DEPT:
VENDOR:
VND #:
DELIVERYMONTH
START Date
Cancel Date
STYLE # STYLE DESCRIPTION
COLOR
CLASS #
unit
unit
COST
RETAIL
MU%
TOTAL Units
Total COST
Total RETAIL
Total Cum MU%
# Door Clusters
6 stores
GRAND
TOTAL
GRAND
TOTAL
A
UNITS
COST
GRAND
TOTAL
RETAIL
PO#:
3289961448d8d4585d2aa5abdbb31cf8
Blank Purchase order
3/22/20242:03 AM
STORE
DEPT:
VENDOR:
VND #:
DELIVERYMONTH
START
CANCEL
DISC %
STYLE # STYLE DESCRIPTION
# Door Clusters
COLOR
CLASS
SUB CL
unit
unit
COST
RETAIL
TOTAL
COST
RETAIL
MU%
MU%
A
B
C
D
GRAND
TOTAL
GRAND
TOTAL
GRAND
TOTAL
UNITS
COST
RETAIL
Nike Collections Fall 24
Buyers use – Little Girls 4-6X
Retail MSRP’s included on line sheets
Create cost prices for purchase order
9/1-9/15
Child addition style #36G932 $44.00

Purchase answer to see full
attachment