Home > Operational Level > Level 1 - IRA > Shooting Outs
Shooting Outs with Mango Your Shooting Outs metric gauges how thoroughly and frequently your store is shooting outs. This metric shows the percentage of countable outs that were physically counted during the month. A SKU must be at zero on hand for 7 (or more) consecutive days to be included as "countable." Assuming a store is shooting outs weekly then (in a perfect world) 100% of countable SKUs would receive a Last Physical Inventory date update. A listing of countable SKUs not counted is available online in your MEGA Report Shooting Outs tab. If your store is not familiar with the process of Shooting outs then Ace's Retailer Library (AWOR) is a great place to get up to speed: Acenet >> AWOR >> Search: Shooting Outs Mango has several reports that work in conjunction with your Shooting Outs process and can help stores reduce labor, ease training requirements and enhance the effectiveness of the process. Mango has several reports that work in concert with your Shooting Outs process. Mango's Count Sheets: the MC and XX Count Type help you account for SKUs your Shooting Outs process is missing (due to missing tags, overlapping SKUs, etc.). Exceptions - Eternal Outs: this report is highly collaborative with your shooting outs process showing SKUs that are counted at zero over and over again and not being repurchased. This report enables your counters to concentrate on getting a good count only and not worry about checking codes in Inventory Maintenance. This can speed up the shooting outs process and reduces training burden as your counters do not need to learn the nuances of Inventory Maintenance fields. SKUs with codes or warehouse issues will be trapped in your Exception - Eternal Outs report! Exceptions - Days Zero: this report helps improve sales through better in-stock position and can also reduce the labor required to count outs as a side benefit! Exceptions - Shooting Outs: this report shows the SKUs that were missed (were not counted) during your store's weekly shooting outs process. Shooting Outs Metric: Mango reports a metric indicating how frequently and thoroughly your store is shooting outs. MEGA Report - Shooting Outs tab: this tab located your Excel-based In Stock report shows countable SKUs for the month and the SKU's Las Physical Inventory Date. You can use this report to research why a zero was not counted in your store. Guidance: Read over Ace's AWOR Shooting Outs document. (Acenet >> AWOR >> Search: Shooting Outs) PIP all zero counts, even SKUs with zero variances. For example, a SKU showing zero quantity on hand and a shelf quantity of zero should still be PIP'ed. This will ensure the SKU's Last Physical Date is updated which in turn feeds Mango's Eternal Outs exception report. Logging zero variances for the typical store should not downgrade your Operational Level 4 - Efficiency; if it does then your store might be spending more on labor counting outs than you would by filling hooks with inventory (Productivity Level 1 - In Stock). Monitor your Shooting out metric (Review Email >> Charts.pdf >> Page 2) Troubleshooting your metric Are you PIP'ing all zero counts? Mango relies on the Date of Last Physical to know that a SKU was counted and "shot out." If the computer says you have 2 but you have an empty peg, obviously you're going to fix the count in PIP. Additionally, if the computer says you have 0 and the peg is empty, enter that count into PIP as well guaranteeing the Last Physical Date is updated. Are you Shooting Outs weekly? To achieve a high shooting outs percentage it's a best practice to shoot out on a weekly basis Are you Shooting Outs on a consistent day? If a SKU goes 7 or more consecutive days of being out without being counted it scores against you. If you shoot out this week on a Monday but not again until next Thursday that allows for a SKU to sell to 0 on Tuesday and go 7+ days without being counted. Consider researching previously missed SKUs to determine a source or pattern In your MEGA Report (Action Report Email >> Direct Download Link) there is a workbook called Shooting Outs. This is NOT a count list, the ship has already sailed. The SKUs on this list were out last month, didn't get shot out, and therefore scored against you metric. The purpose is to determine WHY they were missed to help improve your process. Are they isolated to a certain department, location, person, week of the month? Targets: 0% - 14% - No regular shooting outs procedure. 15% - 24% - Monthly or bi monthly shooting outs. 25% - 34% - Almost weekly shooting outs. 35% - 100% - Weekly and thorough shooting outs.
Shooting Outs with Mango
Your Shooting Outs metric gauges how thoroughly and frequently your store is shooting outs. This metric shows the percentage of countable outs that were physically counted during the month. A SKU must be at zero on hand for 7 (or more) consecutive days to be included as "countable." Assuming a store is shooting outs weekly then (in a perfect world) 100% of countable SKUs would receive a Last Physical Inventory date update. A listing of countable SKUs not counted is available online in your MEGA Report Shooting Outs tab. If your store is not familiar with the process of Shooting outs then Ace's Retailer Library (AWOR) is a great place to get up to speed: Acenet >> AWOR >> Search: Shooting Outs
Mango has several reports that work in conjunction with your Shooting Outs process and can help stores reduce labor, ease training requirements and enhance the effectiveness of the process.
Mango's Count Sheets: the MC and XX Count Type help you account for SKUs your Shooting Outs process is missing (due to missing tags, overlapping SKUs, etc.). Exceptions - Eternal Outs: this report is highly collaborative with your shooting outs process showing SKUs that are counted at zero over and over again and not being repurchased. This report enables your counters to concentrate on getting a good count only and not worry about checking codes in Inventory Maintenance. This can speed up the shooting outs process and reduces training burden as your counters do not need to learn the nuances of Inventory Maintenance fields. SKUs with codes or warehouse issues will be trapped in your Exception - Eternal Outs report! Exceptions - Days Zero: this report helps improve sales through better in-stock position and can also reduce the labor required to count outs as a side benefit! Exceptions - Shooting Outs: this report shows the SKUs that were missed (were not counted) during your store's weekly shooting outs process. Shooting Outs Metric: Mango reports a metric indicating how frequently and thoroughly your store is shooting outs. MEGA Report - Shooting Outs tab: this tab located your Excel-based In Stock report shows countable SKUs for the month and the SKU's Las Physical Inventory Date. You can use this report to research why a zero was not counted in your store.
Guidance:
Are you PIP'ing all zero counts?
Mango relies on the Date of Last Physical to know that a SKU was counted and "shot out." If the computer says you have 2 but you have an empty peg, obviously you're going to fix the count in PIP. Additionally, if the computer says you have 0 and the peg is empty, enter that count into PIP as well guaranteeing the Last Physical Date is updated.
Are you Shooting Outs weekly?
To achieve a high shooting outs percentage it's a best practice to shoot out on a weekly basis
Are you Shooting Outs on a consistent day?
If a SKU goes 7 or more consecutive days of being out without being counted it scores against you. If you shoot out this week on a Monday but not again until next Thursday that allows for a SKU to sell to 0 on Tuesday and go 7+ days without being counted.
Consider researching previously missed SKUs to determine a source or pattern
In your MEGA Report (Action Report Email >> Direct Download Link) there is a workbook called Shooting Outs. This is NOT a count list, the ship has already sailed. The SKUs on this list were out last month, didn't get shot out, and therefore scored against you metric. The purpose is to determine WHY they were missed to help improve your process. Are they isolated to a certain department, location, person, week of the month?
Targets: 0% - 14% - No regular shooting outs procedure. 15% - 24% - Monthly or bi monthly shooting outs. 25% - 34% - Almost weekly shooting outs. 35% - 100% - Weekly and thorough shooting outs.
Print the Level 1 Checklist here! Next Step - Cashier Testing Previous Step - Count Sheets