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