Bunnings D & R Dashboard

Why this Dashboard Matters

Investigating a few minutes here gives you real actionable payback:

• Validate D&R forecasts: See balance between what’s already in store vs what’s on the way, and check if it matches your expectations.
• Plan for seasonal surges: Compare to last years forward 8 weeks, so you are not caught short when demand repeats.
• Protect sales: Spot lines at risk of going out of stock before it happens.
• Reduce overstocks: Identify product that have too much stock in store or pipeline
• Focus on what only matters: Quickly filter to “live with no stack and no forecast” so you don’t waste time on noise

In short, this dashboard helps you get ahead of supply issues, make smarter decisions and spend less time firefighting.

 

Key Terms Explained

• Optimum Stock: Stock level you believe should carry to achieve sales potential
• Based on Weeks Cover (how many weeks of stock you want to hold to absorb sales fluctuations to avoid running out).
• Formula: Weeks Cover x Average Weekly Sales (at store/product level)
• Note: When sales are very low or zero, the calculated Optimum Stock may be unrealistically low. Ise Min and Max fields to set sensible limits.
• The weeks selected for weeks cover, and the number of weeks used for the weekly average sales comes from the Admin > Dashboard Allocator Settings.
• Average Weekly Sales: Simple calculation = Total Sales ÷ Number of weeks selected.
• Total Stock = Closing Stock (what’s in store now) + 4-week D&R replenishment forecast.
• Total Sales = the sum of sales from the weeks selected in Admin > Dashboard Allocator Settings.
• 4wk D&R Forecast: The next 4 weeks of replenishment from the D&R file. (Elsewhere in krunchbox this appears as SOO – Stock on Order)
• Stock Under Optimum: Where Total Stock (Closing + 4wk D&R) is less than Optimum Stock. Highlights gaps where stores may already be, or soon may be , understocked.

 

How to Get the Most from the Dashboard

• Set your Weeks Cover
• Use a higher number (e.g. 8) to see maximum desired stock levels.
• Use a lower number (e.g. 2-4) to model minimum safety stock.
• Optimum stock does not include lead time requirements.
• Check What’s Missing: Any store/product with no stock and no sales in the period will not appear here. If you want to view these gaps, use Allocator or the Gap options in Dashboards.
• Spot Trends from Last Year
• The Last 8-week Forward View identify whether seasonal demand is about to hit again (e.g. if you’re on Week 10 now, it shows Weeks 11-18 last year).
• Compare current stock to last year’s sales to check readiness.
• Review Current vs Forecast
• Weeks stock on Hand (WSOH) shows how long current stock will last if the current avg persists.
• WSOH based on Last Year Forward Sales shows how long stock would last if sales repeat last year’s trend.
• Use this to decide which measure better represents your needs.
• Focus on Live Gaps
• Use the Live Status Filter to highlight products currently set to Live, or see Stock holdings where not Live
• The “Out of Stock + No D&R Forecast” view pinpoints critical risk lines with no pipeline coverage.

 

Filtering Your Dashboard

Advanced Filters: Like all krunchbox dashboards, this one includes advanced filters to help you focus on the specific data you need.

Here's how to use them:

 

• Report Selection Filter: Choose the starting date for your dashboard view.
• Product Filter: Select the specific product(s) you want to see results for.
• Store Filter: Choose the store(s) you want to include in your results.

Important: After setting your filters, remember to click the Krunch button to process and apply your selections.

 

Within the Dashboard Filters: This dashboard includes filters that are specific to it.

Here's how to use them effectively:

• Retail Filter: Select the retailer you want to view results for.
• Store Filter: If you want to see results for a particular store, use this filter to choose the store.
• Category Filter: Use this to narrow down results to specific product categories.
• Live Status Filter: Filter products based on their status—either Live or Not Live.

Note: You do not need to click the Krunch button when using these filters. The dashboard will update automatically as you make selections.

              

Stock Review Product Tab: Stock under Optimum measures for you where the current stock Commitment (Closing plus the next 4 weeks D&R forecast) is less than the Optimum Stock (the amount of stock you want to hold).

Because the current stock commitment includes D&R, be aware of which portion of the stock is already in store vs potentially on the way (D&R forecast)

Click on the Products to see results by Store.

 

Stock Review Store Tab: This tab shows thew same data, but the data starts at the store level.

Click on the Store to see results by Product.

 

What Happened the Last Year? Tab: Knowing what is coming up is tricky, nut can have a profound impact on your business when you sell seasonal product. Reviewing stock levels on current performance is good, but what about expected fluctuations? If your products have carried over year on year, and you are expecting similar trends coming up, this mat help you understand whether you have enough product in the pipeline.

Compare the Current WSOG (weeks stock on hand) to the WSOH based on LY next 8 weeks. Determine which best represents your needs and use this to identify opportunities to be better prepared.

Use the Live Status filter to focus on current needs.

 

Live Status No Stock Tab: Only showing status Live and Out of Stock and no D&R forecast in the next 4 weeks.