Please enable JavaScript.

Coggle requires JavaScript to display documents.

ASP/AUC/GM Tool, Net Sales $ Plan #, Plan Price Type Sales Penetration #,…

- - - - Reg Sales ASP
        
        Reg Sales U
- - - - Pro Sales ASP
        
        Pro Sales U
        
        Ttl Net Sales ASP Forecast
- - - - Clear Sales ASP
        
        Clear Sales U
- - - - Reg/Pro BOP % Penetration
        
        Clear BOP % Penetration Derived
- - - - GM Planner #
        
        Clear MD $
        
        Reg/Perm MD $
- - - - Ttl Net Sales ASP #
        
        Planned Return ASP
        
        Gross Sales $/U
        
        Projected AUR
        
        MD $
        
        Rcpt $/U
        
        Next Week
        
        :recycle:
- - - - Does sales penetration move 1:1 with inv penetration?
        
        :question: Can regression analysis help to predict this relationship given assumed inventory?
  - - - Does Promo Eligible Inventory play a part?
        
        :grey_question:Is history available to know this?
        
        :pencil2: Base inventory tables will show 0 for Promo inventory, will have to look at Reg/Pro together
        
        :question:During CTR do Sales from Clear inv fall into Promo Bucket?
  - - - :question: Can we use Trend
        
        :question: How far into the future is trend relevant?
      - :question:Can we calc similar to AUR?
        
        :warning:We would need to know of each MD how much will add to inv penetration (1st MD) and how much inv is being moved from Reg/Pro to Clear inv (value of inventory vs. MD $)
        
        :question: Can we use historical relationships of 1st MD vs 2nd MD to predict additions to Clear Inv penetration?
        
        :question: How far into the future is historical relationship relevant?
      - :question:Can we use history?
        
        :question: Can we use MD plan compared to historical MDs?
- - - - Net Sls ASP =$90
- - - - :memo:Returns ASP
        
        Returns U
        
        Gross Sales U
        
        MFP Gross Sales % Demand Total U
        
        :memo:Demand U
        
        :memo:Demand ASP
    - - MFP Gross Sales % Demand Total $
        
        :memo:Demand $
- - - - :question:Adjust down until desired GM % is achieved?