Transcript Mod 4
Mod 4: Planning Style
Assortments for TY
Purpose:
In Mod 3, you developed an open to
buy plan by price point, by month and
class.
We still need to know what we plan to
spend for each shirt style, for each
class.
In Mod 4, we use the unit plan we
developed in Mod 2 to develop our
assortment plan.
Mod 4
Be
sure Mods 2 and 3 have been
corrected.
Be sure total OTB units for Mod 3
are correct. If not, enter into cell
D10 in Mod 3.
Section 1 = 262,151
Section 2 = 264, 705
Data and Formulas for
Class 10 (section 1)
Col. A
Col. B
Col. C
Style
Label (Units from Mod 2
Col. T)
Formula
SOLID
BUTTONDOWNS
Your number (T15)/125059
(T20)
=your
number/125059
SOLID SPREADS
Your number/125059 (T20)
=your
number/125059
FANCY
BUTTONDOWNS
Your number/125059
=your
number/125059
FANCY SPREADS
Your number/125059
=your
number/125059
Data and Formulas for
Class 10 (section 2)
Col. A
Col. B
Style
Label (Units from Mod
2 Col. T)
SOLID
Your number
BUTTONDOWNS
(T15)/128566 (T20)
SOLID SPREADS Your number/ 128566
(T20)
FANCY
Your number/ 128566
BUTTONDOWNS
FANCY
SPREADS
Your number/ 128566
Col. C
Formula
=your
number/128566
=your
number/128566
=your
number/128566
=your
number/128566
Mod 4
Enter
4 labels and 4 formulas for
each class.
Be sure your percentages add up to
100% . If they do not, you have
made an error in entering your
numbers.
Question #1: Examine the basic
stock $ for class 20, SB in Promo.
goods
Basic Stock = minimum amount of
stock necessary to maintain a specific
number of colors and sizes for each
store
6 colors X 5 sizes X 11 stores = 330
(Basic stock units)….convert to dollars
330 units X cost price per unit ($12.50,
Mod3) = $4125 (Basic stock $)
Question #1: Class 20, SB,
Promo. Goods (Col. J)
Basic stock $4125
Basic stock 330units
Month Cost (From Mod 4)
Cost/unit price
Aug.
$4461 - enough?
$4461/12.50 = 356
- enough?
Sept.
$4397
$4397/12.50 =
Oct.
$2798
$2798/12.50 =
Turn in:
Module
4 spreadsheet
No formulas unless %’s do not
equal 100%
Typewritten answers to questions
on P. 63