MEGA Report - Shooting Outs

This worksheet can help a store with a low shooting outs metric find outs that should have been "shot" (counted). Listed SKUs sold and were at zero on hand for 7 (or more) consecutive days without being counted. If your store has a policy of shooting outs every week then these SKUs should have been counted. Many SKUs (more than 30-50, depending on store size) indicate an inconsistent shooting outs process and/or can indicate a store procedure which does not update last physical inventory while shooting outs (all peg/hook zero counts should be entered into PIP, even if there is no variance).

Steps to process your Shooting Outs worksheet

1. Determine which day(s) your store has a policy of shooting outs.
2. Type the listed SKU into Inventory Maintenance.
3. Look at the SKU's transaction history (click on Qty. on Hand to launch ITR).
4. Ask your inventory coordinator why the SKU was not counted during its shooting outs window.

Your goal is to discover and fix a procedural or personnel issue that is getting in the way of shooting outs consistently. 

*Note: RSC PERCENT DAYS OUT column indicates the percentage of days the SKU was also out at your store's warehouse. This column can be helpful if using this report to investigate outs issues.