How to Calculate Same Store Sales (Comps) in Excel | Retail Dogma

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

Комментарии • 13

  • @toke5559
    @toke5559 2 месяца назад

    Thank you for the video! What about when store 3 closes? How would you account for that for future year?

    • @RetailDogma
      @RetailDogma  2 месяца назад

      It would be excluded from the calculation like the new store in this video. In order for a store to be included in the same store sales calculations, it must have traded throughout the two periods that are being compared.

  • @avryund
    @avryund Год назад

    Thank you for making these retail videos! I was an S. M. @ Tommy Hilfiger for 5+ years and now I am working for a fantastic new cannabis company and have been creating systems like this and the retail maps 🙏💯 thank you for the refresher!

    • @RetailDogma
      @RetailDogma  Год назад

      Thank you for watching and for your comment, Wes!
      All the best in your career

  • @juanka96jv
    @juanka96jv 5 месяцев назад +1

    You can also do TY/LY-1

  • @mbmanav5782
    @mbmanav5782 Год назад

    Most important video for measuring

  • @jabcode
    @jabcode Год назад

    hi , plz how to calculate de LY when i know ca for now in excel?

    • @RetailDogma
      @RetailDogma  Год назад

      Hello,
      LY (last year) is not calculated. It is actual figures from the system reports of the previous year's sales

  • @mbmanav5782
    @mbmanav5782 Год назад

    Helpful 👍

  • @mbmanav5782
    @mbmanav5782 Год назад

    Can it be related to comparable store sales ?

    • @RetailDogma
      @RetailDogma  Год назад

      Yes, same store sales are also called comparable sales or comps

  • @AnilKumar-xt5or
    @AnilKumar-xt5or 2 года назад

    No sound

  • @कॉम्पिटिशन_एग्जाम

    Post more video