Creating a Grocery Sales Tracker Template in Excel
Whether or not a product is on a rotational sales cycle can be tested by simply keeping track of the price of the product over time. Use these instructions to create your own template or fill-in and complete the blank template located here in the media gallery.
1. Open a new Excel worksheet.
2. Label the rows with the names of the products.
3. Label the columns as week 1, week 2, week 3, etc.
3. Fill in the cells in each row with the product’s price for the corresponding week.
4. Under the Insert tab choose Chart to start the Chart Wizard.
5. Select Line as your chart type and "chart that displays trends for categories" as your sub-chart and select next.
6. Click on the data range box icon at the end of the fill-in box and then highlight the cells to add to the chart. Be sure to include the cells with the product names.
7. Click the chart icon to confirm the data range and hit next and the chart will appear.
8. After hitting next again, label the Title "Grocery Sales Tracker", the X axis "Weeks," and Y axis "Price".
9. Hit next and choose the setting "place chart as object in sheet 1," which will be your default setting.
In the example above, the yellow line represents a seasonal sales item, the pink line shows a stable price product, and the blue line reveals the best candidate for rotational shopping. Notice the periodic waves -- the tell-tale sign of a rotational sales cycle. By adding rotational shopping as part of your budget plan, along with these other grocery budget ideas, you will begin to see the savings start to add up each week.