Mod 4 Planning Style Assortments for TY n

Mod 4: Planning Style Assortments for TY n Purpose: n In Mod 3, you developed an open to buy plan by price point, by month and class. n We still need to know what we plan to spend for each shirt style, for each class. n In Mod 4, we use the unit plan we developed in Mod 2 to develop our assortment plan.

Mod 4 n Be sure Mods 2 and 3 have been corrected. n Be sure total OTB units for Mod 3 are correct. If not, enter into cell D 10 in Mod 3. n Section 1 = 262, 151 n 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 (T 15)/125059 (T 20) =your number/125059 SOLID SPREADS Your number/125059 (T 20) =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 (T 15)/128566 (T 20) Col. C Formula =your number/128566 SOLID SPREADS Your number/ 128566 (T 20) =your number/128566 FANCY BUTTONDOWNS Your number/ 128566 =your number/128566 FANCY SPREADS Your number/ 128566 =your number/128566

Mod 4 n Enter 4 labels and 4 formulas for each class. n 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 n 6 colors X 5 sizes X 11 stores = 330 (Basic stock units)…. convert to dollars n 330 units X cost price per unit ($12. 50, Mod 3) = $4125 (Basic stock $) n

Question #1: Class 20, SB, Promo. Goods (Col. J) Basic stock $4125 Basic stock 330 units Month Cost (From Mod 4) Cost/unit price Aug. $4461 - enough? $4461/12. 50 = 356 - enough? Sept. $4397/12. 50 = Oct. $2798/12. 50 =

Turn in: n Module 4 spreadsheet n No formulas unless %’s do not equal 100% n Typewritten answers to questions on P. 63