Store BA Review 2023

Title Page

Site conducted
Conducted On
Conducted By
Leader Worked With

Store Review

Previsit/Retail Operations

CASH.7 Are Over/Short Variances reported appropriately? http://posdashboard.cable.comcast.com/POSDashboard/services
MOB.3a Physical Count (All Physical Counts Completed Within Past 6 Months) Review prior fiscal month physical inventory counts. Was the count performed on the required date for the month? - Review detail of the counts in Xinventory to ensure count was completed for all items. *** If store is part of trial, physical count must be done w/in the week designated *** https://cceis.mintek.com/xInventory/dashboard
MOB.3b Are any discrepancies accounted for and properly reported? Is there evidence of research for discrepancies? - - If device was a 'Miscount' it requires proof that the item(s) were cycled back into inventory. (Review subsequent cycle counts to ensure devices are cycled back in to inventory or request ROM provide evidence.) - If device was 'Lost/Stolen' validate that the mySupport ticket # and proof of region security involvement, such as an email to security (Security Case #) is available. https://cceis.mintek.com/xInventory/dashboard
MOB.4a Did the store complete their weekly cycle counts for last 30 days? Review Inventory Scorecard: Refer to Supporting Links: CGA Reliance > Store & CSC Program > Program Resources > Inventory Scorecard - Section = Counting, Count Compliance - Following Compliance % points, take 1 pt for each bracket below 100% = 2 pts 75-99% = 1 pt <75% = 0 pts https://cceis.mintek.com/xInventory/dashboard
MOB.4b Are human error variances kept to a minimum? 2. Following the Compliance Grid, take 1 pt. for each variance - No variance = 3 pts - 1 = 2 pts - 2 = 1pts - 3+ = 0 pts https://cceis.mintek.com/xInventory/dashboard
MOB.6 Was Xstore closed properly the previous night and ready for sales at the start of business? Pull 4 weeks of information and save as "MOB.6 Xstore Close". Take one point for each day where the store was open, but Xstore was not closed properly. If you arrive at the store after opening and Xstore is not opened, take all 3 points https://posdashboard.cable.comcast.com/POSDashboard/rollingStoreCloseReport
MOB.8a Are upgrade shipments being sent to Assurant weekly? Pull the last full month of the Inventory Scorecard published by Retail Operations and review 'Shipping' section for Upgrades - (column Q) 'Upgrade Compliance Pts. Earned') - 100% = 5 pts - 90-99.99% = 4 pts - 85-85.99% = 3 pts - 80-84.9% = 2 pts - 75-79.9% = 1 pt - <75% = 0 pts https://data.comcast.com/#/workbooks/32208/views
- 100%
- 90-99.99%
- 85-85.99%
- 80-84.9%
- 75-79.9%
- <75%
MOB.8b Are return shipments being sent to CTDI weekly? Pull the last full month of the Inventory Scorecard published by Retail Operations and review 'Shipping' section for Returns - (column S) 'Returns Compliance Pts. Earned') - 100% = 5 pts - 90-99.99% = 4 pts - 85-85.99% = 3 pts - 80-84.9% = 2 pts - 75-79.9% = 1 pt - <75% = 0 pts https://data.comcast.com/#/views/Returns45DayRollingReport/AllStoreReturns90DayRolling?:iid=1
- 100%
- 90-99.99%
- 85-85.99%
- 80-84.9%
- 75-79.9%
- <75%
MOB.9 Was inventory received entered into Xstore within operational guidelines? Pull the last full month of the Inventory Scorecard published by Retail Operations. - Review under the “Receiving” section, the column “Compliant Points Earned (Column I)" - 100% = 5 pts - 95-99% = 4 pts - 90-94.9% = 3 pts - 85-89.9% = 2 pts - 80-84.9% = 1 pt <80% = 0 pts

Cash Handling

CASH.1 Are all bills $20 and above checked for counterfeit? Confirm that counterfeit detection tools (e.g. pens, UV lights) are present and available to employees handling cash - do you check for counterfeit bills, and if so, how? -at what point in the process do you check? -which denominations of currency do you check? -what do you do wen you find potential counterfeit currency?
CASH.2a Are monthly cash reconciliations being performed?
CASH.2b Does the store have at least one cash drawer open and was dual verification performed prior to opening?
CASH.2c Was the expected change fund balance accurate when compared to the change fund in-store? Ensure the store has one cash drawer open for business each day. Observe the opening procedures and ensure the dual verification process was followed. If unable to verify opening process, review cash drawers for opening tape to see if 2 signatures are present and it has the current date.
CASH.2d Were all store cash drawers full account for and reconciled appropriately?
CASH.3b Is the change fund being properly maintained and reconciled by store management? Ensure change fund is appropriately secured. It should be located in a locked bank bag/cash box and secured in locked drawer or safe, with limited access. Review the last 3 months of the Change Fund Log. (Note: for sites on the Bill Pay platform, pull the Xstore transaction summary for the past 3 months)
CASH.4a Are manual receipt books present, secured and only accessible to employees?
CASH.4b If the billing system is not functioning, are SC providing a manual pre-numbered receipt to customers and processing the transaction immediately upon billing system functioning?
CASH.5a Is all cash secured during business hours?
CASH.5b Is the cash safe secured and are combinations changed when required?
CASH.5c Is dual control exercised when the safe is accessed and is the Safe Access log completed?
CASH.6a Were store deposits prepared and recorded accurately?
CASH.6b Is the Paid-In function being used appropriately?
CASH.6c Are Cash Pickups/Sweeps performed when required per policy?
CASH.6d Is daily paperwork accurate & complete? . Randomly select 5 days from the past 30 days and use closing paperwork, including Store Bank Receipt and Cash Drawer Reconciliation Reports to test the following: -Do deposit amounts in Courier Log, deposit slip, and Store Bank Report and combined totals of Cash Drawer Reconciliation Reports for each drawer? -Are plastic tear-off deposit tags included with the EOD paperwork and do the tag numbers match the bag number in the log and have dual signatures by Sales Consultant and Independent Verifier ? -Are deposit slips initialed by 2 employees? -Does Cash Drawer Reconciliation Report have dual signatures of the same 2 employees? 2. Using randomly selected 5 days from closing paperwork selected above, test the following: -Does total of each Kiosk Cash Payment Summary equal the Paid-In Amount on Paid-In Receipt ? -Does the Paid-In Receipt have dual signatures by 2 closing employees ? -Does the Paid-In Amount match the deposit slip for the kiosk deposit?
CASH.9a Is Payment Kiosk locked at all times and secured to the building structure?
CASH.9b Is dual control exercised when the kiosk is accessed and is the Kiosk Access log completed? Ensure log is filled out completely and reasonably for the past 30 days. You should see an entry each day. Take 1 point for each day missed or filled out incorrectly.
CASH.9c Are all POS Transaction devices and kiosks free of foreign devices or card skimmers?
- Pass
- Fail
- N/A

CPE Management

CPE.1 Are all CPE boxes organized and secured appropriately?
CPE.2 Has Quarterly CPE audit been completed in accordance with AF – 7.4 CPE Control and Recordkeeping?
CPE.3 Is the location ensuring that full CPE scans are accurate and lost product is minimal? min of 93% accuracy
CPE.4 Are Customer CPE returns processed immediately per policy?
CPE.5a Are all BAPIS orders packed and in the designated location for customer pickup?
CPE.5b Are there BAPIS orders in Retail 360 that were not processed correctly?

Mobile Inventory Controls

MOB.1a Are all accessories/SIM cards not currently displayed on the sales floor secured in locked cage or other secure area?
MOB.1b Is the Device Safe/Room Locked at all times?
MOB.1c Are Demo Phones/Accessories properly secured on display tables?
MOB.2 Are Store personnel with access to device safe/room access active employees and are the employees utilizing their unique codes/badge access to access the device safe/room to retrieve handsets for sale?
MOB.5 Does current on-hand inventory accurately reflect inventory records in Xstore?
MOB.7a Is the store set up with the current XVIP Planogram, with accurate pricing and displays?
MOB.7b Are Demo Phones working properly and ready for customer interactions?
MOB.8c Are customer trade-in/upgrade devices being processed timely?
MOB.8e Are customer trade-in/upgrade device values received as quoted? compare quoted upgrade/trade-in value for all returns within the last 90 days with amount received from Assurant. If the total amount received compared to the quoted amount is less than 95% note as an exception

EHS & Regulations

REG.1a Are batteries managed and disposed of per regulatory standards?
REG.2 Are OSHA regulations posted in the store?
REG.3a Are Fire Extinguishers up to date and ready for use?
REG.3b Are Fire Alarm Pull Stations free of obstruction?
REG.4a Does the store have a Fire and Emergency Plan available?
REG.4b Are employees aware of the store's Fire and Emergency Plan? validate that store employees are aware of emergency evacuation procedures. This can be completed by obtaining evidence of an evacuation drill in the past year or by inquiry with 2 employees.
REG.5a Does the location have the required State Business Licenses?
REG5b Does the location have the required State/Local Tax Business Licenses? (If applicable)
REG.6 Are store personnel following CPNI/PII requirements? -Are shred bins locked and used to shred customer PII? -Are unlocked/unsecured trash receptacles free of PII? -Are all work stations and public areas free of PII? -Are work station areas free of employee login information and passwords? -Are work station computers locked when unattended?

Physical Security

SEC.1 Are all external doors properly marked and secured?
SEC.3a Are keys logs being maintained for all physical keys and is an audit of keys performed monthly? 1) Obtain key log(s) for all physical keys (may include entrance, rollaway cage/storage cabinets, kiosks, safe, and cash drawers) and reconcile keys issued to employees, ensuring all are accounted for. 2) Inquire with management about the process for auditing keys (monthly audit required).
SEC.3b Are all physical keys controlled? 1. Ensure that keys for cash tills, rollaway cage/storage and kiosks are secured (restricted access) and are not taken home by employees. 2. Ensure the cash safe and product room/safe key are on-site and functional (do they open the safe/room?)
SEC.4a Are interior doors locked and access restricted to authorized personnel?
SEC.4b Are critical store areas badge controlled?
Are duress buttons located in appropriate areas of the store and are they operational?
SEC.8 Are visitors' logs effectively maintained by store management? 1) Review 3 months of the visitors log. 2) Is it being completed on a regular basis and do visitors seem appropriate for the location? 3) Review log for the following items: visitor name, date, time of entry, departure time and person responsible for the visitor.