Mod 3 assortment planning by price and month
Download
1 / 10

- PowerPoint PPT Presentation


  • 210 Views
  • Uploaded on

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).

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '' - wirt


An Image/Link below is provided (as is) to download presentation

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.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Mod 3 assortment planning by price and month l.jpg
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 l.jpg
Steps to complete Mod 3 (p.48 & 49)

  • C10: total OTB units 20_X (LY) D10: total OTB units 20_Y (TY)

  • Complete the table on page 48 in manual. (Use page 39 to gather information.)



Steps to complete mod 3 l.jpg
Steps to complete Mod 3

3. Enter formulas in Col. C & D

Ex: C18=C10*.18

D18=D10*.155

  • Enter % allocation for each class (get from Mod 2, column U) (G4, L4, Q4, V4)

  • Estimate the % of merchandise each month to allocate for the 3 price points.(Use p.40 to complete p.50 worksheet.)


Steps to complete mod 35 l.jpg
Steps to complete Mod 3

6. Develop formulas which will allocate OTB $$ by class, month, cost/retail and price points.

  • Each formula will have 4 components:

    % allocation for each class

    # units for each month

    price (Retail and Cost)

    % allocation by price (Reg., Pro., Res.)


Steps mod 3 f19 class 10 aug retail regular l.jpg
Steps - Mod 3, F19 (class 10, Aug., retail, regular)

Class%units/mo.R/Cprice pt.

G$4 * $d$18 * F$7 * .56

Row (4)remains row & column

same, column remain same

changes


Steps mod 3 f20 class 10 aug cost regular l.jpg
Steps - Mod 3, F20 (class 10, Aug., cost, regular)

Class%units/mo.R/Cprice pt.

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


Steps mod 3 f22 class 10 sep retail regular l.jpg
Steps - Mod 3, F22 (class 10, Sep., retail, regular)

Class%units/mo.R/Cprice pt.

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.


Steps mod 3 g19 class 10 aug retail promo l.jpg
Steps - Mod 3 – G19 (class 10, Aug., retail, promo.)

Class%units/mo.R/Cprice pt.

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.


Assignment l.jpg
Assignment

  • Mod 3 spreadsheet

  • Mod 3 price changed spreadsheet

    • Decrease $1 from retail, reserves for all classes

    • Decrease $.45 from cost, reserves for all classes

  • Mod 3 formula sheet (CTRL +E)

  • Typewritten answers for mod 3 questions