Skip to content
  • There are no suggestions because the search field is empty.

A GUIDE TO KRUNCHBOX REPORTS

Comprehensive Overview of Krunchbox Reports and Their Functions. 

This document provides a detailed list of all Krunchbox reports, along with a description of each report's functionality.

Classic Sales Report (0101)

  • Gives overview of entire business.
  • Users can adjust measures.
  • Filter for products or results.
  • See reports at store or product level
  • Summarize by product or store attribute.

Some examples of use include:

  • Sales by product.
  • Sales by store.
  • Sales by price point.
  • Top stores by region.
  • The Weekly Sales Report (0101) is the most versatile and easiest to use report.
  • It gives you an overview of your entire business.
  • This is a great report to start with for new Krunchbox users.

 

Quarterly Sales Report (S2)

  • Provides overview of sales results and sell through.
  • Displays week, month to date, quarter to date and year to date.
  • Closing stock and sell through is always valued.
  • In volume only.
  • Simple view – limited number of measures.
  • The Quarterly Sales (S2) Report is specifically designed to provide a simple view of quarterly sales.
  • It’s great for identifying trends!

 

Product/Store Attribute Report (0218)

This report deviates from the usual hierarchy drill down and allows users to create a view on any product or store Attribute.

  • Used for small groups of stores or small groups of products.
  • See products and stores on the same screen using subtotal drill downs - This ability makes it one of the most popular reports.
  • Because of the simple defaults, try using this as a 'build your own' report.
  • Because of the simple defaults, you can build your own report!
  • Allows users to create a view based on any product or store attribute.

 

Weekly Trend Report (S12)

See performance trends over time by the week.

  • Shows when seasonality trends kick in.
  • Shows peaks and troughs.
  • Use chart to easily see trends.
  • Used in conjunction with Allocator.

Use this report with Allocator as it helps to determine which weeks to select as a representation of the sales levels expected to achieve.

 

Sales by Store Report (0109)

  • Provides a view of store results.
  • Displays last 4 weeks of data to see sales trends, provide store inventory levels and sell through.
  • Users can add sales reps into report.
  • Great for regional managers to see their store's current 4 week trend compared to last year.
  • Stock adjustment is showing how inventory has changed on the period chosen.
  • The Sales by Store (0109) is the perfect store summary report.

 

Sales and Stock Trend Report (0132)

  • The Sales and Stock Trend Report (132) is a great way to see sales and stock on the same chart.
  • Used to compare results to last year across weeks.
  • Moving average, stock turn, stock, sales, variances can be reviewed to identify exceptions and changes over time.
  • Chart to compare sales to stock.
  • Shown stock and sales on the same chart.
  • Shows sales trends compared to last year in sales and stock perspective.
  • No Drill Down.
  • Attributes cannot be added.
  • Easy to change from units to dollars.

 

Sales by Retailer Report (0112)

  • Provides a dashboard of results by retailer.
  • Can drill down to store, product and brand.
  • Shows a quick summary of sales by retailer.
  • Similar to the Classic Sales Report (0101).
  • This report is great for CEO's as it gives a quick summary of sales by retailer.

 

Time Period Comparison Report (S9)

  • This report gives you a clear understanding of changes in performance over a period of time.
  • Compare performance for four periods.
  • Default time periods are last week, last 4 weeks, last 13 weeks and year to date.

 

Attribute Time Period Report (S10)

  • Shows performance year on year and share of business across multiple time periods.
  • User can identify trend changes across the full periods of time.
  • Flexibility to view any product or store attribute to view any product or store attribute.
  • This report not only shows how certain attribute trend but also share of the business total.
  • Users can put product and store on the same page.

 

Warehouse and Supply Chain Report (0108)

Only use 108 Ranked Sales Report if you have warehouse inventory and stock loaded into Krunchbox.

  • The Ranked Sales Report gives visibility to view what is selling in stores compared to what is left in the warehouse.
  • You will be able to identify if there is enough stock in the warehouse to distribute and fill stock orders.
  • Warehouse vs. Store comparison.
  • See sales rate and how it compares to warehouse inventory and stock on order.
  • Filter for specific products.
  • See results from a store or product level.
  • Summarize by product or store attribute.

 

Share of Business Report (S3)

The S3 Share of Business Report offers period to period comparison and provides insight of the business from a Sales and Stock perspective with Sell Through as a measure of performance.

  • Similar to Classic Sales Report (0101).
  • Includes Sell Through percentage for any product selected.
  • Focus is on Units but Dollar measures can be added.
  • Drill down to product and store attributes.
  • Filter for a specific product or result.
  • See results at a store or product level.
  • Summarize by product or store attribute.

 

Retailer Performance Trend (0104)

  • See the last 4 weeks trend and compare to other periods selected.
  • Similar to the Sales by Store Report (0109).
  • Filter for specific product or results.
  • See results from a store or product level.
  • Sale shown in units and can be easily changed to dollars.
  • Measures in this report are not flexible.

 

Month Summary Report (0201)

The Month Summary Report (0201) is a great financial report which shows performance by month with a number of preselected measures. Data is dependent on if the Product Master is updated with pricing.

  • Shows performance by month with a number of preselected measures.
  • The profit margins displayed are related to retailers’ results.
  • Users have the ability to drill down product or store attributes for a particular month.
  • Use advanced filters for specific products ore stores.
  • Restricted number of measures.

 

12 Month Trend Report (0202)

The 12 Month Trend Report (0202) is a great way to see how products are trending and to predict the seasonality of products.

  • Shows sales units over a 12 month period.
  • Can easily be switch from units to dollars.
  • Because this report groups the data into a monthly view, users can drill down to a product to help with forecasting.
  • The monthly bucketing is dependent on the calendar supplied.

 

By Store by Product Report (0121)

The Attribute by Attribute Report (0121) is great for seeing if a certain store is low or out of stock.

  • See how your products are selling in stores.
  • Report brings product and store on the same page in a matrix format.
  • Can be changed to week, 4 weeks, 12 weeks and 52 weeks.
  • Shows if a certain store is low or out of stock for a particular product.
  • Shows how products are selling across stores.
  • Designed to be exported.
  • Sort by attributes only in this report.
  • Be specific on selection with this report as this report can take some time to run if pulling all data.

 

Out of Stock Report (S1)

The Out of Stock Report (S1) shows you your top 10 products and out of stock information.

  • Allows users to qualitatively estimate the opportunity cost of being out of stock
  • Shows total sales and average weekly sales of best sellers that are now out of stock at store level.
  • Provides strong indication of the sales that are being missed out on through stock outs.
  • Report is dependent on if price is populated in the product master.
  • No Graph.

 

Store Product Trend Report (S8)

  • Provides a product trend across store in matrix format.
  • Measures are displayed in row level.
  • Designed to be exported.
  • Cannot be charted.
  • The Product Trend Report is designed to be exported as it is in a matrix format.

 

Multi Week GMROI Report (S11)

Only Available if Bunnings is a retailer

  • A Gross Margin Return On Investment (GMROI) is an inventory profitability evaluation ratio that analyses a firm's ability to turn inventory into cash above the cost of the inventory. It is calculated by dividing the gross margin by the average inventory cost and is used often in the retail industry.
  • GMROI, is one of the most important profitability metrics in retail. It measures how productively you're turning inventory into gross profit. A GMROI ratio greater than 1 means you're selling inventory at a price greater than the cost of acquiring it.

 

For improving GMROI there are basically 2 main leverages:

  • Improve gross profit. Raise prices. Reduce COGS. Better management of markdowns.
  • Improving inventory turnover. increasing sales volumes with the same inventory level reducing inventory levels and keeping the same sales volumes.
  • Gross margin is a company's total sales revenue minus its cost of goods sold (COGS), divided by total sales revenue, expressed as a percentage.
  • The retailer doesn’t provide the calculated gross profit. The Gross Profit is calculated from the Net sales $ less the cost of goods sold which are both provided by the retailer.
  • The Gross Profit % (margin) is then calculated by dividing the profit by the net sales $.
  • The cost of inventory is provided by the retailer.
  • The results are annualized to provide a familiar comparison.

The Formula is: ((([Net Sales $ ExclTax]/No_Of_Weeks)*52)/[Avg Closing stock at cost (ex Tax)])*[GP%]

Breaking down the formula:

  • Net Sales $ / No of Weeks in selection to get weekly average.
  • Average weekly sales $ multiplied by 52 to annualize the weekly sales results.
  • Annualized sales results divided by Avg Closing stock at cost to determine the relationship between sales and stock.
  • Multiplied by GP% to get the profitability of the result.

This report is flexible with time periods. This report can be run for:

  • The last 4 weeks
  • Last 12 weeks
  • The last 52 weeks
  • Month to date
  • Season to date
  • Year to date

You can run these periods can be compared with Same Period Last Year or Previous Period.

This report shows how changes in business can affect the GMROI.

 

If you have any questions or need support, contact us at: support@krunchbox.com