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

[@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]

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

[@toke5559]

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

[@RetailDogma]

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.

[@juanka96jv]

You can also do TY/LY-1

[@mbmanav5782]

Most important video for measuring

[@mbmanav5782]

Helpful 👍

[@jabcode]

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

[@RetailDogma]

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

[@mbmanav5782]

Can it be related to comparable store sales ?

[@RetailDogma]

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

[@AnilKumar-xt5or]

No sound

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

Post more video