Summary
Highlights
The video starts by introducing the concept of the service rate (taux de service) as an indicator that helps measure the availability of products to consumers at a point of sale.
The presenter demonstrates how to calculate the absolute service rate by dividing the number of products available by the total number of products for each family. For example, for Cosmetic products, if 7 out of 11 are available, the rate is 63.64%. Similar calculations are shown for other product families with a summary of the overall absolute service rate calculated by summing available products across families and dividing by the total planned products. The overall absolute service rate for the first example comes out to be 68.75%.
Next, the video explains the calculation of the relative service rate. This involves using sales data (chiffre d'affaires) for available and total products. For example, for Cosmetic products, with available sales of 5394 and total planned sales of 11712, the relative service rate is 46.06%. This process is repeated for other product families, and a weighted average is then calculated which is 57.85%.
The video then moves on to calculating the value of the stock in question and the financial contribution of each product family. This involves multiplying the sales of available products by their prices. For example, for product A, it's 5394 * 0.53, yielding 2,856,912 dirhams. The total value of available stock is calculated by summing these values for all families: 24,935,666 dirhams. The contribution of each family to the overall stock is then determined. For product A, this is (2,856,912 / 24,935,666) * 100 which is 11.46%.
The video concludes by summarizing the results. The absolute service rate of 68.75% means that 68.75% of the total product range is available. The relative service rate of 57.85% indicates that 57.85% of the total sales value (chiffre d'affaires total) is available. The analysis shows the contribution of each product family. For example, product C contributes 30.65% to total sales, highlighting its importance to the store's overall performance. This helps the store understand which products are most valuable and need to be kept stocked.