Mod 3 – Assortment Planning by Price and Month. To calculate planned purchases (open to buy “$”) for men’s dress shirts by: Class (10, 20, 30, 40) Month in selling season (Aug. to Jan.) At cost and retail Price point (regular, promotional, reserves). Steps to complete Mod 3 (p.48 & 49).
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
3. Enter formulas in Col. C & D
6. Develop formulas which will allocate OTB $$ by class, month, cost/retail and price points.
% allocation for each class
# units for each month
price (Retail and Cost)
% allocation by price (Reg., Pro., Res.)
G$4 * $d$18 * F$7 * .56
Row (4)remains row & column
same, column remain same
G$4 $d$18 F$10 .56
Only price (R/C) changes. Cell F20 is for COST, but we are still in Class 10 and still in August and still in Regular Price point
G$4 $d$21 F$7 .65
Units/month changes because we are in September, but F22 is a Retail row, so F changes back to F$7, and we must enter a new price point % because of September.
G$4 $d$18G$7 .27
Units change to $d$18 because we are back in August, R/C changes because we have a new $price pt. The price pt. % is also new.