Title Page
-
Document No.
-
Audit Title
-
Client / Site
-
Conducted on
-
Prepared by
-
Location
-
Personnel
Stock routines 2017
-
All gaps are scanned once per day on food areas (Mon-Sat)
-
You will need:
Last four weeks Stock Control Dashboards. The store are not required to file these but they can be printed from G Drive:\\ukroi.tesco.org\dfsroot\uk\starwood\top1500\shops\shops\stock control\Simpler Stock Control Reports\2017
Check the number of red days on the 'Gap Scan Completion' measure for both Fresh and Grocery areas. This highlights any days where the store have scanned less than 50% of their average number of gaps, and indicates that a full scan was not completed. The store must not have exceeded four red days on Fresh or four red days on Grocery. -
Add media
-
The Gap-Scan 'Found in Store' function is being used correctly for food lines.
-
You will need:
The I Can Get What I Want Report for the previous day. The store are not required to file these but they can be printed from SBO option 5,3,5.
Review the Status column of the I Can Get What I Want Report to determine which products have been coded as 'instore'.
Select up to ten food products which have been set to 'instore' and have not had a delivery in the last three days. To check if the product has had a delivery in the last three days review the delivery column of the product profile (option 5,1,1).
Check these lines to ensure that the store can produce stock.
If there are not ten lines set to 'instore' that have not had a delivery in the last three days, then complete the test on the sample available. If there are no lines to review then score the test as N/A. -
Add media
-
All gaps are scanned once per day on General Merchandise areas (Mon-Sat).
-
You will need:
Last four weeks Stock Control Dashboards. The store are not required to file these but they can be printed from G Drive:\\ukroi.tesco.org\dfsroot\uk\starwood\top1500\shops\shops\stock control\Simpler Stock Control Reports\2017
Check the number of red days on the 'Gap Scan Completion' measure for General Merchandise areas. This highlights any days where the store have scanned less than 50% of their average number of gaps, and indicates that a full scan was not completed. The store must not have exceeded four red days on GM areas. -
Add media
-
The Gap-Scan 'Found in Store' function is being used correctly on Non Food Lines
-
You will need:
The I Can Get What I Want Report for the previous day. The store are not required to file these but they can be printed from SBO option 5,3,5.
Review the Status column of the I Can Get What I Want Report to determine which products have been coded as 'instore'.
Select up to ten GM products which have been set to 'instore' and have not had a delivery in the last three days. To check if the product has had a delivery in the last three days review the delivery column of the product profile (option 5,1,1).
Check these lines to ensure that the store can produce stock.
If there are not ten lines set to 'instore' that have not had a delivery in the last three days, then complete the test on the sample available. If there are no lines to review then score the test as N/A. -
Add media
-
Stock records have been corrected for all General Merchandise stock which is not found in store.
-
You will need:
The GM I Can Get What I Want Report for the previous day. The store are not required to file these but they can be printed from SBO option 5,3,5.
Only products coded as 'instore' should have a positive stock record. Positive stock records are signified by a '*' between the oos and status columns. If a product is not set to 'instore' then the stock record should have been counted to zero.
Review all GM lines on the Report to identify any lines with a positive stock record which have not been set to 'instore'. From these select a sample of ten lines. Check on SBO (option 5,1,1) that the product has not been delivered in the last three days. If there has been no delivery on the line in the last three days, and the stock record has not been set to zero, then the line would be non-complaint. -
Add media
-
A minimum of 98% compliance has been achieved on High Loss Targeted Counts.
-
You will need:
The last four weeks stock Control Dashboards.
Review High Loss Targeted count compliance over the last four weeks to ensure the store has achieved a minimum of 98% in each of the weeks under review. -
Add media
-
The Fresh Food Lows and Overs routine has been completed to the required standard.
-
You will need:
The last four weeks Stock Control Dashboards
This check is in parts:
1). Check the 'Lows and Overs Range Investigated' column for the last four weeks, to ensure that the store have investigated as required.
2). On the second page of the report check the OSI and LSI sections to ensure that Fresh Food Fill Errors are not above 50% in any of the four weeks. -
Add media
-
The Grocery Lows and Overs routine has been completed to the required standard.
-
You will need:
The last four weeks Stock Control Dashboards
This check is in parts:
1). Check the 'Lows and Overs Range Investigated' column for the last four weeks, to ensure that the store have investigated as required.
2). On the second page of the report check the OSI and LSI sections to ensure that Grocery Fill Errors are not above 50% in any of the four weeks. -
Add media
-
The GM Lows and Overs routine had been completed to the required standard.
-
You will need:
The last four weeks Stock Control Dashboards
This check is in parts:
1). Check the 'Lows and Overs Range Investigated' column for the last four weeks, to ensure that the store have investigated as required.
2). On the second page of the report check the OSI and LSI sections to ensure that GM Fill Errors are not above 50% in any of the four weeks. -
Add media
-
Ambient Stock Record Movement reports have been printed daily and show evidence of review.
-
You will need:
The stores filed SRM reports.
Check that a report is filed each day for all departments. Reports should be printed daily for the previous day's SRM and should not be backdated.
Check each report for evidence of re-counts on all lines in the top twenty or down to the value of £10. -
Add media
-
General Merchandise Stock Record Movement reports have been printed daily and show evidence of review.
-
You will need:
The stores filed SRM reports.
Check that a report is filed each day for all departments. Reports should be printed daily for the previous day's SRM and should not be backdated.
Check each report for evidence of re-counts on all lines in the top twenty or down to the value of £10. -
Add media
-
All required Stock Record Movement correction counts have been completed.
-
You will need:
The stores filed SRM reports used for the previous tests and access to the SBO system.
Select a maximum of ten lines from Ambient and ten lines from General Merchandise where a count correction has been identified. Use the History Stock Record Movement option on SNO (5,5,1,3) to validate that a correction count had been submitted by the store. -
Add media
-
All Emergency Product Withdrawals are filed and fully completed.
-
Method:
Sign into My Actions to view which EPWs which have been issued to the store.
Check the EPW folder to ensure that all EPWs issued to the store (including non-stocked products) are filed and have been fully completed. All reports must indicate whether the line was stocked, the number of singles withdrawn and the signature of the person who has completed the EPW. -
Add media
-
All Delivery Summary System Reports are filed and all Tesco Receipt Notes are accounted for on the DSS (Store and PFS).
-
You will need:
A four week sample of the stores filed DSS reports.
Check the TRN numbers for the Store and PFS to ensure that none are missing in the four weeks under review. TRN numbers are sequential and all should be entered on to the DSS. -
Add media
-
No deliveries have auto confirmed or been left unconfirmed on the Delivery Summary System in the weeks under review.
-
You will need:
The four week sample of DSS reports for the store and PFS used in the previous test.
This test is in two parts
1). Check the confirmation time of paper receipted deliveries on the DSS reports, and ensure that none have been allowed to apply to stock records at diary entry time. This element applies only to paper receipted deliveries and not electronic notes.
2). Check the right hand side of the DSS reports to ensure that all deliveries show as 'confirmed' or 'extended'. No deliveries should show as 'unconfirmed'. This element applies to both electronic and paper receipted deliveries. Branch to branch transfer activity does not need to be confirmed and does form part of this test. -
Add media
-
Completed RP documentation has been entered onto the Delivery Summary System.
-
You will need:
The RP388 Return to Supplier books and RP728 Claims books for all areas (stores will often have a separate book for Backdoor, Opticians, PFS and Pharmacies) and the four week sample of DSS reports used in the previous tests.
Review all entries in all books available for the last four weeks. For any entry in the books during the last four weeks check that there is a corresponding entry on the DSS. For claims the entries will be on the 'ins' reports, for Returns the entries will be on the 'outs' reports.
The value recorded on any returns forms must match the value entered onto the DSS 'outs'. -
Add media
-
All completed RP documentation has been sent to Cardiff for processing.
-
You will need:
The RP388 Return to Supplier books and the RP728 Claims books for all areas.
Check all entries for the last four weeks in the Claims and Returns books. Ensure that all white copies of the paperwork are no longer retained in the book. -
Add media
