Sales forecast, cash transactions, average basket, retail business, drive sales, sales points, Hyères, ZI ST MARTIN
Reader
Abstract
Extract
of 8
Abstract
Analysis of sales data and forecast for N+1, including cash transactions and average basket size.
Extract
[...] The number of cash transactions has also increased significantly so the average basket has very slightly increased, only by 1.35% whereas the number of cash transactions in the 3 sales points has decreased overall. The more the number of cash transactions decreases, the more the average basket increases. This is why the implementation of Drive is therefore interesting to increase the sales figure even more. In addition, the average basket in the 3 sales points combined has increased at least 2 times more than that of the ZI ST MARTIN (+2.93% against 1.35%). [...]
[...] The sales figure having already increased in Hyères, the Drive will allow to strengthen the sales figure for a stable number of cash transactions, therefore cost savings. 3. Objectives sales figure and number of cash transactions N+1. Sales figure of the 3 sales points: (sales figure * 1.10, i.e.: 674 007,78 * 1,10 = 741 408,56 ? Increase in average basket by i.e.: 28.71 * 1.02 = 29.29 ? Number of cash transactions in Sales figure / Average basket = 741 408,56 / 29,29 = 25 313 Rate of evolution of cash transactions (25 315 - 23 474) / 23 474 = 7,84%. [...]
[...] Prepare Periodic Accounting Operations - Dashboards PLAYFUN 1. Appendix A. Dashboard Average Basket = Gross Sales / Number of Cashier Passages For the 3 sales points: average basket = 673,306.60 / 24,136 = 30.98 ? For the ZI ST MARTIN area: average basket = 388,868.42 / 12,553 = 27.90 ? 3 sales points: average basket = 674,007.78 / 23,474 = 31.40 ? ZI ST MARTIN: average basket = 423,418.34 / 13,486 = 28.71 ? [...]
[...] The rate of change in cash transactions in Hyères is changing very little compared to the N/N-1 rate, no doubt thanks to the establishment of the Drive. 4. Forecast Dashboard Dashboard N+1 Indicators Scope Unit N-1 N Objective N+1 Evolution N+1/N % Real 09/N+1 Real 10/N+1 etc. [...]
