What it is
Amounts of different items purchased per member per week. This is aimed at providing statistical information for the purposes of determining how much will be needed in the future (if you project on your future expectations of membership). Please note that this report only works on calendar weeks (running from Sunday to Saturday), so when you select your date range, the report will use all calendar weeks which intersect with your selection. This report will work with legacy (before centralized inventory) sales data and select items based on their delivery date. It will also work with centralized inventory sales data and it will select that data based on time of inventory change: time of delivery finalization matters here instead of date of delivery.
Parameters
Start Date: Selects the starting date. Because this report works on calendar weeks (Sunday to Saturday), this will self-adjust to the Sunday prior if a Sunday is not selected.
End Date: Selects the ending date. Because this report works on calendar weeks (Sunday to Saturday), this will self-adjust to the Saturday after if a Saturday is not selected.
Output
The output will be an Excel (.xlsx) file with four sheets:
Variants - Stats* aggregated to the level of Variant
Farm Products - Stats* aggregated to the level of Farm Product
Base Products - Stats* aggregated to the level of Base Product
Report Parameters - The parameters of your report. Start Date and End Date will be shown here as the effective dates of the report, as they may have been adjusted to conform to calendar weeks.
Stats
Count of Weeks Available - Number of calendar weeks in which the item was purchased at least once
Total Amount Sold - Total amount of the item that was sold. For legacy inventory, this is the calculated sum of all items in our records of shares and extras items which were delivered in the date range. For centralized inventory, this is the calculated sum of inventory sales in the date range for the item.
Average Sold per week - This is Total Amount Sold / Count of Weeks Available
Average Number of Members in Weeks - A total count of unique members is tallied up for all of the weeks contributing to Count of Weeks Available. This total is then divided by Count of Weeks Available to find the average number of unique members in those weeks.
Average Item Count Per Member Per Week - This is Average Sold per week / Average Number of Members in Weeks.
Interpretation
Average Item Count Per Member Per Week is often the primary point of interest in this report: this gives the statistical average amount of a particular item that each member received in a single week. If you know how many members you expect to have in a future week, you can make a prediction about how many of that item you will need.
For example, suppose I ran this report and saw that each week, the average member was buying 0.70 cartons of eggs (almost 3 for every 4 members). I expect that next week I will have 450 members, so I can project that I will need about 0.70 * 450 = 315 cartons of eggs.
Sometimes you may want to look at the data at a more general level. Maybe you are adding a new product and you want to know how much you may need, but (because it is new) you won't have historical data to refer to. You could perhaps try to infer from the historical data of other related products, which is why this report has statistics aggregated at the less specific levels: Farm Products and Base Products.