Learn why Average Items Carried is important in this previous post. Even though Average Items Carried is pretty straightforward, here are some questions (and answers!) that often come up when the measure is new to an organization. Can I add together Average Items Carried across periods or geographies? NO! It is a non-additive fact , since it is […]
AIS
How to Calculate Average Items Carried
If Average Items Carried (or Average Items Selling) is not available on your database, it is easy to calculate in Excel. It is just the sum of % ACV Distribution of all the items divided by the % ACV Distribution of the brand. Here is an example: Say a brand is made up of 4 […]