December 2022 Report Run

• UPC engine upgrade - better blank UPC detection, deeper x-link detection
• EOQ engine upgrade - fewer oscillating suggestions for stores with a lot of shelf cap. (Loc 3)
• New Office Exception - Blank QOH
• New Office Exception - Zero Max Stock
• New Floor Exception - Missing Shelf Capacity, for stores utilizing back stock.  

November 2022 Report Run

• ARMA - Priority button and dept. filters added.
• MEGA - New worksheet - SKUs Missing Shelf Cap (loc3).
• MEGA - New worksheet - Inventory Value Changes.
• MEGA - Can/Rep report - added peer selling % and estimated annual sales units for replacement SKUs.
• Westlake Eagle integration.

October 2022 Report Run

• New ​Daily Metrics site for stores.
• Variable Order Multiple (VOM) data feed work. 
• Back stock without Loc3 report work.
• ARMA Back Stock work - Priority list, additional filters, etc.

September 2022 Report Run

• ​Launch of Back Stock on ARMA
• Work on VOM (variable order multiple) engine.
• Propello integration work.
• 90 new stores added to the program

​

August 2022 Report Run

• ​Show Buying Report work
• Pilot testing for back stock on ARMA
• New backstock videos and help content for the launch

June 2022 Report Run

• Back stock Ace Mobile App development and testing.
• Variable Order Multiple Engine development and tuning.
• New Office Exception Report - EOQ Shelf Capacity.
• Excel Email - KIM Report depreciated. 
• Excel Email - to be entirely depreciated for stores with sufficient Eagle levels to utilize automation and integrations. 

May 2022 Report Run

• Continued work to sunset the Mango_KIM file. More info can be found here.
• MEGA Report -> In Stock tab now defaults to hide data that can be actioned on RAD.
• MEGA Report -> Discontinued Mismatch to include SKUs not orderable in your RSC, with the wrong Disc flag.
• Office Exceptions -> New RAD Checklist to replace In-Stock reports.
• Office Exceptions -> Stopped building In Stock pages that can be actioned on RAD.
• Help Center -> continued Propello Help.
• Special Fee Codes - Paint Care - included New York Paint Care file, Updated ME Pesticide list.
• ROP Protect Exceptions - enhanced engine. 
• Backstock -> ARMA App. integration work.

March 2022 Report Run 

• Show Buying Report work
• Continued Propello work with Beta Stores
• Launched EOQ on RAD

February 2022 Report Run 

• MEGA Report - Index worksheet updated.
• MEGA Report - Key Metrics worksheet started.
• KIM Report - This report will be discontinued in the future as functionality has been replicated and improved in the MEGA report. 
• EOQ (min/max) - Integration live on Acenet RAD.
• Propello integration:
  • Live stores.
  • Daily back stock.

January 2022 Report Run 

• MIN OP Reduction in RAD - updated help.
• Overview video for Operational and Productivity Levels.
• Add 2 new peer groups - TEXGC (Texas Gulf Coast) and BAMA (Alabama).
• Cleaned up stores in mismatched peer groups.
• Default NEW location - updated help to utilize Epicor utility.
• MEGA -> Fixed small bug on macro open.
• MEGA -> Location Exceptions -> Added new columns.
• Updated Ace MOP list to reflect 2022 candidates.
• Updated Paint Care to 2021 list.
• Internal -> Propello integration work.
• Internal -> better shelf capacity internals.

 December 2021 Report Run 

• Help Center - New Onboarding Training Module.
• Charts - Inventory Accuracy Scorecard - Added Shooting Outs Metric.
• Fixed Discontinued Flag Mismatch when chain served from multiple RSCs 
• Testing Multi-Store RAD (future).
• Testing EOQ/Max Stock RAD integration (future).
• Min/Max engine tweaks (suggesting more inexpensive, low-cube items).
• Epicor Propello integration work.

November 2021 Report Run 

• MEGA: Added check-boxes to index page.
• MEGA: Added Invalid UPC, RPA Audit, and all other Master Exceptions.
• Epicor Propello integration work.
• Ace RAD integration work for Max Stock (EOQ), Min OP Reductions, etc.
• Mobile Count Sheet assignment bug fixed.

September 2021 Report Run 

• MEGA: added prime vendor mismatch tab.
• Future Acenet In-stock enhancement work.
• Level 2 and 3 min order points incorporated into Min OP Reductions.
  
  

July 2021 Report Run 

• Closeout Management Labels update
• Mobile Count Sheets via Zebra
• Future enhancements with Ace

May 2021 Report Run 

• Excel MEGA Report - added Eternal Outs worksheet
• Excel MEGA Report - added Item Setup Issues worksheet
• Excel MEGA Report - added Cross Merchandise Suggestions worksheet
• Back Stock - added intelligence to spot transfers and ID them on report
• Executive Summary - renamed In Stock Fusion to OP Fusion to better reflect what the metric is measuring
• Special Fee Code - won't report PDF when using Related SKU field instead

April 2021 Report Run 

• Paint Care - Added Washington State to Paint Care Fee audit. (Office Exceptions, MEGA).
• AH.COM - Bug fix for Eagle Level 30 stores and .com transactions/dollars mapping into Mango.
• MEGA Shooting Outs tab - added Dept. column.
• Back Stock - Added Location 4 as Back Stock Location (optional).
• Internal work to monitor/report Realtime Count Sheet Completion.
• Product Mix Report - added Loc2-6, Dept, Mfg Num, Vendor Num, Item Detail Hyperlink, Google Search hyperlink

March 2021 Report Run 

• Show Buying Report
  • S21 deal set incorporated. Better internal deal set automation, QA, and analysis processes.
  • New "Fill Shelf" Scoring Category.
  • Excel - Show Buying Report updates (new columns, buttons).
  • Video and help documentation updated.
  • Direct Download link in Action, Review, and Excel email.
• MEGA Report
  • MEGA Report - In Stock - Added ROP Protect too high to ROP Protect changes.
  • MEGA Report - Shooting Outs -Updated sort order and added print button.
• Internal
  • Better UPC X-link QA processes.
  • Better multi-location sales suggestions engine for suggesting SKUs that sell better merchandised in multiple locations. 

February 2021 Report Run 

• Excel MEGA Report - Added Promo Residue worksheet - currently in an experimental phase.
• Excel MEGA Report - minor bug fixes to the main macro.
• Excel MEGA Report - added Times Reported column to In Stock tab, added outs data (times, days) to CTX min op type.
• Excel MEGA Report - added CS XX - Store Closeout Check - consider setting store closeout = Y on some XX Count Type items.
• Excel Non-Ace Product Mix - minor bug fixes to the macro.
• Closeout Management - added a 4th step to MIP & Label to help keep MIP clean.
• Excel Mango_IVA - usability upgrade with Avg/Rep Cost buttons, print button. Ability to see IVA Overview with either Avg. or Rep. cost.
• Office Exception - Added Count Type XX - Store Closeout Check.  (SKUs you might want to set to SC=Y if zeroed when count sheet processing).
• Excel Delete Report - now macro enabled with easy export button for data files.
• Show buying report Spring 21 initial work on dealset. 
• Stop Sales & Recalls - old data cleanup.
• Work with Ace/Epicor to help with Acenet and AHCOM QOH quality. 
• Underlying work for future Option ID report.
• Eagle Mobile+ Physical List -  Mango list bug fixes and enhancements.

January 2021 Report Run

• Excel MEGA Report - Added ROP Protect Exceptions to In Stock tab (consumes the separate ROP Protect tab).
• Excel MEGA Report - Added Back Stock Shelf Capacity tab.
• Excel MEGA Report - Added Back Stock - Top Back Stock tab.
• Office PDF - Refreshed ROP Protect Exceptions to include other exception types (blocking min op, max op mismatch), made report part of the In-Stock class.
• Floor PDF - Eternal Outs shows ICMBlok when a persistent out is a replacement ICM SKU being blocked from replenishment due to the replaced SKU having quantity-on-hand.
• Daily Back Stock Report - Shelf Capacity and Top Back Stock tabs moved to the Mega report.
• Max Stock Engine - tweaked the bias towards increasing max on lower-cube units and less max on higher cube units, especially at the 1-Add / 2-Review threshold of 400 cu. in.
• Excel - Promo Residue Report - Experimental version of a promotional residue report.  Located in the Data Import+Multi-Store directory.  

December 2020 Report Run

• Excel MEGA Report - combined All Store Exception and All Store KIM into one report.
• Excel MEGA Report - enabled "Direct Download". Allows report to be downloaded with one click from email or Action PDFs.
• Excel MEGA Report - available at time of report email (no build delay).
• Excel MEGA Report - combined all order point recommendations (including Max Stock) into In Stock tab.
• Excel MEGA Report - added UPC x-links to report.
• Max Stock Engine - further min/max refinement and a new recommended "Max Removal" engine.
• Office/Master Exception PDFs - Direct Download of MEGA report by clicking on Excel icon.
• Executive Summary/Key Metrics PDF - In Stock Fusion metric now includes Max Stock, and a 3-month in stock weighting.
• Executive Summary PDF - new In Stock sub metric showing adoption of individual metrics (in stock, min op, and max stock).
• OL0 - Count Sheet Completion metric to daily Back Stock email. 

November 2020 Report Run

• Excel - All Store Exception - New Missed SKUs tab. Shows Count Sheet SKUs not counted over the last three months.
• Excel - Fiscal Shrink workbook now macro enabled for column formatting.
• Excel - IVA workbook now macro enabled for column formatting.
• Max Stock - Continued tweaking max engine: reduced suggested max on high-volume SKUs., Times Reported on Excel report.
• Max Stock - Cubic Inches override QA process; where vendor data is bad.
• Daily QOH from stores and quality check. 
• Fixed API integration issue for very large chains.
• Quarterly Paint Care fee listing update.

October 2020 Report Run

• Enhanced min and max order level engine.
• Enhanced Max Stock Excel and PDF reports.
• Better canceled/replaced SKUs with Suggested, Direct, Multi suggestion types.
• Back Stock Replenishment now included in Mango subscription

September 2020 Report Run

• Fall 2020 Show Buying Reports 
  • New "Scoring Category" for score grouping 
  • Re-tuned scoring engine
  • Added Deal Cubic Foot and Savings per Cubic Foot data 
  • Report data integrated into Mobile and Acenet Digital Convention apps

August 2020 Report Run

• Acenet/Eagle Integrations are live!  
• Assortment Report Engine tune up. 
• Maine Pesticide Special Codes Listing

July 2020 Report Run

• Added AH COM Ship-To Transaction and Sales Units to Excel Product Mix and Excel KIM Assortment tab.
• Added On Order but not Replenished to Excel - All Store Exceptions. Added Times Reported (TR) to Office Exceptions PDF.
• Added Times Reported (TR) to Floor Exception PDF Store Closeout Check page. 
• Added Number of Bin Labels (facings) to Floor Exception PDF Multi Location page.
• Operational Level 0 Webinar - refreshed and live
• Operational Level 1 Webinar - refreshed and live
• New Integrations Sneak Peek Video
• Mango Daily Back Stock Webinar

June 2020 Report Run

• Refreshed PO Season Code help.
• ​Min/Max Order Point - Refreshed selection engine.
• Office Exceptions - Reinstated Top Promo and Discount exception trap utilizing AHCOM transactions.

May 2020 Report Run 

• All Store Exceptions - added print buttons to many workbook tabs.
• All Store Exceptions - added Discovery Code audit to the Cat Diff - SKUs tab.
• Product Mix - converted to a macro enabled workbook.
• Closeout Management RAD - step-by-step videos created for MIP & Label process.
• Closeout Management - new video for printing bin labels using the COM Labels .csv file.
• In Stock Webinar - new webinar video recorded and ready for launch of the Epicor/Acenet integrations.
• Closeout Management Webinar - new webinar video ready for launch of Epicor/Acenet integrations.
• AH.COM transaction history accumulation.
• AH.COM added to Shrink Reason in Shrink Report if item was part of an AH.COM transaction recently.
• AH.COM tab added to All Store Exceptions report.

April 2020 Report Run 

• Epicor/Acenet integrations and functionality tested and ready for release when appropriate.
• All Store Exceptions - added "Ratings" tab showing Google store ratings and listed store hours.
• Show Buying Report - rebuilt with March 31 store data. 

March 2020 Report Run 

• Bug Fixed - Office Exceptions RSC Discounts - Corrected RSC linking (was using wrong RSC for many stores). 
• Assortment Report (KIM) - better filtering of state/county product restrictions.
• Bug Fixed - Stop Sales & Recall - California light bulb bug fixed.
• COM - MIP Import automation testing via Eagle Level 29.0 and 29.1. Cool!! 
• Acenet - COM & In-Stock integration testing. Cool! 
• Show Buying Reports built and updated.
• Show Buying Report scoring integrated into Ace's retailer mobile app.
• Metrics - Store's Google rating and number of ratings being captured (testing)
• All Store KIM - Vendor Number column added to Assortment Tab. 
• "RENT" Location Code forces SKUs to be treated as placeholders.

February 2020 Report Run

• Product Stewardship - WA Lightbulb codes corrected, paint 5-gal code corrected, Chalk Paint corrected.
• Ace Data - Better National Central and Source RSC data.
• Ace Min OP List - updated to Ace's new 2020 list.
• Internal work -> Show Bulletin integration with Ace Ordering App., Show Bulletin scoring engine work.
• Internal work -> Closeout (COM), Min OP, In-Stock integrations being tested with Acenet/Mango/Eagle integrations.
• Mango Daily - Backstock report system available (extra monthly subscription).
• Mango Daily - Help Center content created.
• Mango Daily - Backstock report - Shelf Qty and Order Point suggestions report, top Back Stock and inventory dollar/number figures added.

January 2020 Report Run

• Excel - Catalog Differences merged into All Store Exceptions (to reduce the number of Excel files to open/manage).
• Excel - All Store Exceptions: added "Export" buttons to easily export CSV files for the purpose of Data Import or Network Access Import.
• Excel - All Store KIM: added "Export" button (In-Stock) to easily export CSV files for the purpose of Data Import or Network Access Import.
• Floor Exceptions - added "RSC Days Out Percentage" to Shooting Outs tab for easier outs research.
• Internal work -> Acenet In-Stock data quality and adjusting TRIDMT queues in affected organizations. 
• Internal work -> COM integration! Coming soon! 
• Internal work -> Acenet In-Stock integration.
• Internal: better data gathering for organizations with over 2.1 million SKUs.
• Daily Back Stock Replenishment Report in testing.

December 2019 Report Run

• Shrink Report - Defective Listing - Changed sort order to Defective Policy first.
• Office Exceptions - Added Store Closeout Check when a SKU is added from the Assortment Report but Store Closeout is set to Y.
• Office Exceptions - Added exception looking for SKUs only differing by "oh" and zero. E.g. 0332 and O332. These types of SKUs can cause sales, shrink, and purchasing errors.
• Paint Care and WA Lightbulbs lists updated for product stewardship states.
• Internal work on Mango -> Acenet In-Stock integration.
• Internal work on Mango -> Eagle COM integration.
• Internal work on Mango -> Ace Show Ordering App integration (Show Bulletin).
• Internal & remote store work on In-Stock and Shooting Outs data quality. Working with stores, Epicor, and Ace to improve data quality for nightly transmittal of inventory information. 

November 2019 Report Run

• Excel Show Bulletin - the next Show Bulletin report will include Merchant Specials along with an enhanced scoring engine: better deal scoring, better bulletin selection based on seasonal start date for store. 
• Count Sheets - fixed a bug that was showing the same SKU multiple times for some stores. 
• Master Exceptions - OM Variance, will not report SKUs with store OM higher than RSC when the store's OM is reasonable based on sales. This allows stores to set OM to case/pallet quantity without Mango suggesting to override. Note: all OM variances will still be reported on the All-Store Exception workbook. 
• Excel Location and Class Productivity - added department to location tab, Related classes and finelines now show for non-Ace classes/finelines. 
• Integrations - work continues on future Acenet and Eagle integrations of the Excel KIM workbook (assortment, in-stock, and COM tab), along with COM MIP and Label import. 

October 2019 Report Run

• Count Sheets - Refactored to re-report (TI, XX, MC) SKUs until counted, instead of skipping the SKU for several months.
• Count Sheets - XX Count Type to focus less on in-process MDR/COM SKUs and more on SKUs about to become obsolete. 
• Count Sheets - Better RC Count Type selection for stores with limited number of Ace SKUs. 
• Acenet - Assortment Report integration to go live in mid October!
• Excel All Store Exceptions - added columns to COM Pinned to also show removal candidates.
• Eagle - Level 29 now has option ID 1876 which should be set to "Yes" so that SKUs in Physical Lists show as counted when RPI is run (even without the list designation). This change makes it much better for stores who use Directed Count and/or use Physical Lists in PIP to track completion progress! 

September 2019 Report Run

• Show Bulletin - Fall show deals loaded and scored.
• Acenet - Assortment Report integration testing (upcoming integration that will be very cool). 

August 2019 Report Run

• RCIN - Shrink bug fixed.
• Excel Catalog Differences Report - Vendor Number and Vendor Mfg# are now RSC-specific.
• Charts PDF - Executive Summary: reworked "Margin Potential" to show margin point increase/decrease from last year. This metric shows if your store is keeping pace with cost inflation. 

July 2019 Report Run

• Shrink & RCIN - Enhanced Mango's ability to deal with RCINs and its impact on shrink reports and metrics. 
• Delete Report - added help links to class, finelines, mvg vendors.
• Multi-Store Resources - continued development for MS help. Not quite ready for prime time, stay tuned.

June 2019 Report Run

• Excel Catalog Differences Report - Added Acenet Direct tab.
• Excel Catalog Differences Report - Added help on how to copy/paste SKUs into Acenet to request hotsheet updates. (this is a great feature!).
• Excel Product Mix Report - Added Discovery ID and explicit Last Purchase and Last Sale dates for sorting and filtering.
• COM - Built API for future closeout management integration into Eagle (automatic MIP import, automatic label file).
• Worked on identifying and requesting fixes to various data quality issues surrounding catalog and drop ship catalog data.
• Excel All Store Exceptions - Discontinued Flag Mismatches, updated help to show how to request hotsheets via Acenet.
• Infrastructure upgrades.

May 2019 Report Run

• Fixed - Average Transaction showing incorrectly for some SKUs in CTX report. 
• Option ID Audit Report - a lot of work was done develop an Eagle Option ID report, testing this month! 
• Retail Pricing Analysis Report - work on developing a retail pricing analysis report...more work needed. 

April 2019 Report Run

• Excel All-Store Exception Can/Rep tab - worked on recommended actions, added columns.
• Acenet Integration - worked on KIM integration with Retail Analytics Dashboard.
• Excel Cat Diff Report - worked on hotsheet integration.

March 2019 Report Run

• Excel Show Bulletin - Spring Convention buying report created. Enhancements made to the scoring system.
• Excel Show Bulletin - Direct email of the workbook when Power Buys are orderable. 
• Count Sheets - Enhanced MC Count Type engine to be more sensitive and react more quickly.
• Cat Diff Excel - Work in progress to include Dept. alignment.
• Updated Paint Care and Light Bulb SKUs for states required to charge product stewardship fees.
• Excel Multi-Store KIM - In Stock column simplification. 
• Major internal database enhancements.

February 2019 Report Run

• Excel - Inventory Changes Refresh - Inventory changes workbook has been refreshed to make identifying large inventory change easier.
• Ace Min OP - Updated "Ace Recommended" Minimum Order Points to Ace's 2019 List. 
• Excel - Catalog Differences now includes Departments.
• Excel - Catalog Differences Help updated.
• Help Center - Updated RPA Audit help.
• Internal - Upgraded servers and platforms!
• Excel - Added "Blank Location or Class" tab to Location and Class Productivity report
• Excel - Added "Blank Vendor" tab to Vendor Analysis report.

January 2019 Report Run

• Office Exceptions - New High Returns Ratio exception to ensure store policy is being followed in high-risk transactions.  
• Excel All-Store Exceptions - Discontinued Flag Mismatches now show all mismatches.
• Excel Catalog Differences - Updated Help for Data Import and Macros.

December 2018 Report Run

• Help Center Best Practice - Updated content with Inventory Coordinator Checklist. 
• Office Exceptions - Low Stock Check has a new section showing good RSC discounts. 
• Master Exceptions PDF - fixed bug affecting some multi-stores not displaying all stores.
• Master Exception PDF - is now located in Data Import & Multi-Store folder online. 
• In Stock - corrected errant ROI calculation.

November 2018 Report Run

• Charts.pdf - Fixed GMROI TTM calculation bug.
• Excel In Stock - incorporated all tabs into the All-Store Exceptions located in the Data Import directory (Excel In Stock file is no longer made)
• Office Exceptions - added Canceled and Replaced Exception trap
• Exception Report PDF - this file has now been broken into two files to help with processing workflow
  • Office Exceptions - exception taking office work to accomplish
  • Floor Exceptions - exceptions taking floor work to accomplish
• Floor Exceptions - added Store Closeout Check exception report to identify errant Store Closeout flags.
• Executive Summary - GMROI - fixed errant peer group calculation for some groups.
• COM - increased discount delay for higher-priced SKUs and lowered the delay threshold.
• Master Exceptions - Setup Issues: increased the sensitivity for this trap to report more issues.
• Eagle Level 28 - Automatic creation of Mango Count Sheets physical list for PIP and Mobile Counting.

October 2018 Report Run

• Transfer Reports - included Quantity on Order and Future On Order to transfer engine. The report now excludes SKUs with Loc6 = EXTR.
• Excel: All-Store Exceptions - Started consolidating full and multi-store exceptions into one workbook.
  • added: Cost & QOH Exceptions, Store Supply, Persistent Negative, Location Code Exceptions, Discontinued Flag and Order Indicator Mismatches.
  • added: UPC Coverage (moved from Product Mix)
  • added: OM Variances, Ghost Promos, ROP Protect to Zero, UnSync Retail Prices
• Excel: Added - All-Store KIM: a multi-store KIM report. Consolidated Data Import COM file and Data Import OP file into the new workbook.
• Online Report Structure - a new online report directory structure was implemented to make it easier to find Data Import and Multi-Store Files.
• Multi-Location Engine: enhanced the engine that picks up on SKUs that sell better when sold in multiple locations.
• Count Sheets - Location Maintenance - added unique pages and help for Multi-location maintenance, COM - Labels, COM - Remove pages. 
• Added Excel logo to Exceptions PDFs to indicate a full, Multi-Store listing is available online.
• Eagle Integration - Level 28, automated Mango Count Sheet List (generation and deletion) in PIP and Directed Counts.

September 2018 Report Run

• Discovery Express (EXP) format showing in Assortment and Product Mix Excel Reports. 
• Product Stewardship - Light Recycle environmental handling charges updated for Washington retailers.

August 2018 Report Run

• New Savings Showcase and Power Buy files.

July 2018 Report Run

• Ace Data Quality Improvements - better source RSC and cost resolution. Makes In-Stock reporting better for central warehouse SKUs and other functionality.
• Ace Data Quality Improvements - better non-stock status and Discover Code quality.

June 2018 Report Run

• Excel Data Import - New Catalog Differences Excel file that shows missing class/fineline/vendor hierarchy data and SKU-level catalog differences.
• Master Exception - Classes without 'NEW' now shows Class Name in case the store does not have the name set up in their system.
• Excel Vendor Analysis - Fixed bug where some vendors were showing up twice. 
• Excel Data Import OP - Removed Min/Max from OP tab, made a new Min/Max tab with Min/Max recommendations since this is a different import and evaluation process.
• Metric - In Stock Fusion - Tweaked to include Ace Min OP suggestions where annual Peer Median units are greater than 1 OR (this is new) the store sells the Min OP quantity annually. 
• Excel Data Import - New "Chain Boundary" report that shows full store/SKU listing of Boundary issues (Cost QOH Errors, Store Supply, Negative Value).
• Help Center - moved hosting location of the Mango help center. Links in PDF & Excel, etc. reports updated.

• Mango KIM - Added Mfg Vendor Number to Obsolete tab (column AE).
• Transfer Report PDF - Stopped printing "From" PO documents including From Master and individual store POs. 
• Development of communication interface for future integration with the Eagle system (Count Sheet and COM deployment).
• Data Import - made new Data Import Location Exception report, for importing location exceptions into Data Import/Macros for all stores. This report was previously housed in the Location Exceptions tab of the Location and Class PProductivityExcel report. 

• WA - Light Bulb Special Fee Code list updated to the new list (January 2018) 
• Excel Show Bulletin - Power Buys tab added
• Product Restriction root data - State and County SKU-level process transformed and will stay current going forward

• Excel Show Bulletin - Enhanced the single and multi-store report so that it can be copy/pasted into Event Planner, enhanced help pages, enhanced quality assurance process of deal import.
• PDF Key Metrics - Can be run by chain-specific districts (for large chains separated into districts)
• Email delivery changes to accommodate Westlake GM packet
• Refreshed associated SKU data (assortment report)
• Fixed a bug which delayed (for too long), obsolete lists for lower volume stores

• Incorporated Ace's 2018 Minimum Order Point listing.
• Excel Elasticity Analysis - Added Ace Retail to Cost Too High/Low columns.
• Master Exception/Excel Product Mix-UPC Coverage - Acenet Direct - Better UPC Coverage matching.
• Excel Non-Ace Product Mix - Added Acenet Direct SKU column.

• Master Exception - UPC/Direct Coverage - added Ace/Direct and Store Replacement Cost columns. 
• Exception Report - New Special Fee Code Audit exception that suggests adding, changing or removing Special Fee Codes for stores in states required to charge fees for certain SKUs, such as PaintCare^® fees. 
• Exception Report - Shooting Outs bug fixed. The report is now showing SKUs that were not shot out! 

• New IRA Validation Workbook and help for stores with IRA validation alerts.
• Updated Inventory Accuracy Scorecard help.
• New Charts.pdf Webinar videoized.
• Updated Excel Location & Class productivity report (Unproductive and Outs columns fixed).
• New Multi Location Report tab in Excel Location and Class productivity report.
• Updated help for Exception Report Placeholder and Fastener Dump SKU Margin.
• Added Fastener Dump SKU set Margin to annual Placeholder Value Exception Report.

• Neg QOH metric on Inventory Accuracy Scorecard replaced with new metric (times negative/times out) for IRA validation.
• Better QOO issues detection when errant or vendor canceled order QOO is blocking a SKU from reordering -> Exception.pdf In Stock Eternal Outs
• Fixed Completion metric for stores making up missed counts in October.
• Added a "+" to Count Sheets when stores utilize Location 3 for Backstock Shelf Qty and QOH > Shelf Qty to indicate more in back stock.
• Added manufacturer part number to Count Sheets.
• Added ability to list more than one secondary location code to Count Sheets.
• New Operational Level 2 help with checklist. 
• 2015/16 Get Credit For Value Min Order Points are taken into account in Min OP reduction reports.
• Added Inventory Accuracy Scorecard alert when Count Sheet Completion falls below 75% for twelve trailing months.
• Updated Location Code reference including Location 2 and Location 3 guidance, and bin label help.
• Updated Boundary Exception Report help pages (Cost/QOH Errors, Store Supply, Negative Value).
• Developed data feed for Acenet Direct SKUs (for future reporting).
• Deployed PCI access patch to all Mango Stores.

• Count Sheets: Removed QOH from Count Sheets to reduce variance/logging confusion and by many retailer requests. 
• Count Sheets: Added Count Sheet Count Types definition text to separator page between Ace and Non-Ace Skus on Count Sheets.
• Transfer report: Allow Store Closeout SKUs to be transferred out (to zero on hand) to a store without Store Closeout status.
• Added ability to use Eagle 3-digit Store numbers for large chains. (e.g. Store j = Store 035).
• Changed all report file names from unique Mango IDs (e.g. 5O7LRLIx) to numeric Ace Store numbers.
• Added Orientation Webinar video (Reference -> Webinars).
• Resolved SBC & ATT email delivery issue.
• Fixed Charts.pdf printing error (non-Chrome users) on pages 4,5,6.
• Revised Operational Level 0 and Level 0 help with checklists

• Added Suggested Min OP Column to Excel KIM and In Stock Days zero report. (replaced Units to Add)

• Enhanced RCIN and Shrink detection to better exclude RCIN's in Shrink Report / Metrics.
• Tweaked Overstock SKU selection criteria which was picking up Obsolete non-Ace SKUs in certain cases.
• Added an Inventory Value Year-over-year (YOY) column to Key Metrics Report.
• Added Productivity Level to Key Metrics report.
• Addition of Obsolete section in Exception Report - Unproductive.
• Reorganization of help center to include Productivity Levels. 
• Reorganization of Executive Summary page to include Productivity Levels and a Mango section to show explicit Mango ROI.
• Introduction to the Inventory Dashboard report showing two Inventory Levels: Operational and Productivity.
• Rename Accuracy Level to Operation Level to better reflect the operational focus of achieving accuracy and shrink control.
• Introduction to Inventory Productivity Levels (0 - 3) to "levelize" key productivity metrics.
• Incorporate overstock inventory into Unproductive Inventory key metric (Unproductive = Obsolete + Overstock).
• Bug fix in IRA validation code.
• Increased filtering to exclude low GMROI SKUs from Assortment Opportunity list/metric.

• New and enhanced "internal IRA" calculation based on daily quantity-on-hand data feed to increase IRA validation accuracy.
• Addition of Overstock tab in Excel KIM report.

• Internal speed and scale enhancements
• Upgraded Exchange clients 
• Utilizing daily negative QOH in data feed  

• Internal scale and performance improvements to physical server
• Coordination with vendors: billing, PCI compliance, key metrics platform
• Nick graduated from College - congratulations Nick! lots of videos in store now...

• Internal scale and performance improvements to database engine
• Working on store weighted margin over time analysis to produce future actionable reports

• Refactored Mango's Average Transaction engine: produces higher quality peer group SKU-level average transaction which is used in many report engines.
• Added ability to identify and make consistent, SKUs selling in different multiples across stores. e.g. wire nuts, some stores sell by the each some by the box, this affects average units per transaction.
• Fixed bug in Exception Report: In Stock - CTX (Common Transaction Quantity) report. 
• Fixed bug in persistent unsynchronized retail prices where the retail price was showing for the incorrect store.

• Added SKU-level "Fastener & Bulk" tab in Excel IVA report.
• Weighting of non-Ace SKUs in Count Sheet Completion metric to full weighting.
• Enhanced the number of non-Ace SKUs reported on Count Sheets to match store size better.
• Fixed bug in Delete Report for multi-stores--column "Safe to Delete in All Stores" was not accurate for all stores.
• New Eternal Outs - Replenishment Exception trap, looking for continuously reordered inventory with no replenishment.
• Incorporated better restriction and stop sales data, including county-level restrictions for California stores.

• Fixed formatting bug in Master Exception Persistent unsynchronized retail prices report.
• Started to tally maximum consecutive days out allowing a more accurate "Shooting Outs" metric.
• Started to tally the number of times a SKU sells to zero on hand during the month.
• Updated In Stock - Days Zero report (added Sug Min OP column, Times Out, removed GP Opp, Months Out), more refined filtering.
• Replaced Excel Kim/In-Stock Days zero column Q: "Number of Months at zero" to "Times sold to zero"
• Added Baseline Inventory Value Worksheet to Excel IVA Report as an awesome way to see a reasonable value your store's inventory.
• Min OP PDF Reductions are now filtered to actionable SKUs only (Calculated OP SKUs are excluded)
• Excel In Stock - Min OP Reductions worksheet has a new column indicating if an OP was calculated or fixed/static. 
• Added "Times Reported" and PO Season column to Eternal Outs PDF Exception Report.
• Refreshed Count Sheet Progress Viewer Video
• Refreshed Help Content: Boundary Exceptions
• Added 2015 Ace Min OP List

 December 2014 Report Run      

• Refined and increased sensitivity in Minimum Order Point Reductions
• Refined Min/Max recommendations to not suggest Min/Max values already within 20% of recommendation
• Updated color bar thresholds in Excel KIM
• Internal data loading fixes: 3-digit MSU codes, better Class, Fineline and Manufacturer header data
• Added order point to Excel Assortment Report

• Retooled PDF In Stock - Days Zero to filter out slower moving inventory
• Retooled Min OP Reduction engine to be more sensitive; shows about 30 times more SKU candidate reductions than before.
• Min OP Reduction value being tracked as a possible Unproductive metric.
• Worked extensively with Ace refining the 2015 Min OP listing.
• Internal modifications to accommodate performance groups and stores with 445 fiscal calendar EOM/EOY rolls.

• Added Discovery column to KIM Unproductive Excel Report.
• Added full SKU listing of Location Exceptions to the Location and Class Productivity Excel Report.
• Improved "calculated location" column in Excel Assortment Report, Assortment Report tab.
• Updated help for Excel Assortment Report.
• Added Shooting Outs metric to Key Metrics Count Metrics page.
• Combined Count Results header pages into Shrink Report, Removed Count Results PDF report from Review Email
• Removed Class Overview from Assortment Report PDF (available in Location & Class Productivity Excel Report)
• Added functionality to better identify pending ICM (inventory change management) items
• Fixed bug in Shrink calculation in Inventory Value Change chart (page 4 of Charts Report).

• Changed Master RPA Audit column headings/help for easier report processing.
• Added Closeout Management (Assortment Report) inventory value and count by discount type.
• New Mango Report Overview video.

• Internal database structure improvements to speed up report processing. 

July 2014 Report Run     

• New Video: Shrink Report - helps understand the Shrink Report and how to use it to perform variance research.
• Added MANGO CSV progress viewer file Excel email.
• Updated Shrink Report Help Center
• Refreshed Shrink Report: better headings, research bolding, reasons (added Count Type, Zeroed, Correction, DISC)
• New Video: Eternal Outs
• New Exception Report - Eternal Outs - helps stores identify outs not being reordered. increases in stock and reduces counting labor demands.
• Added Shooting Out and Metric Help/Guidance into Help Center
• New Video: Excel KIM - Unproductive Inventory
• Added Shooting Out % Metric on Executive Summary page (Charts.PDF) Other Metrics
• Added the multiple defective policies to Shrink Report - Defective Items (Policy C items are now shown as Policy C instead of just blanks)
• Fixed bug in Excel Assortment Report column showing inaccurate replacement SKU Active (Y/N) column.

June 2014 Report Run

• Online Report Archive (12-month historical pdf reports) added to online reports. Archive directory.
• Corrected bug in key metrics, reporting too-low unproductive and overstock inventory for some stores (affects stores with large boundary issues).
• Corrected bug in Margin Potential metric.
• Corrected bug where closeout markdown management was picking up current non-closeout promos in some cases.
• Renamed Excel report "Inventory Value Analysis" to "Mango_IVA".
• Created Excel report Mango_KIM (Key Inventory Metrics) with help content.
• Launched Mango KIM, 5 Key Inventory Metrics along with help content and videos.
• New monthly mango email showing Mango's 5 KIMs with Mango_KIM excel report.
• Added Sales per Sq. Ft. to Executive Summary, In Stock section.
• California peer group into 3 groups.
• Florida peer group into 3 groups.

• New Key Metrics: Accuracy Level, Adjusted Shrink, In Stock Opportunity, Assortment Opportunity, Unproductive Inventory
• Key Metrics column definitions in Help & Support Center
• Updated Executive Summary report with fewer metrics, new text and new key metrics.
• Updated Key Metrics PDF with refreshed metrics. Refreshed Count Metrics (Page 2, added help).
• Accommodate non-similar item with Ace SKU match (for stores who use Ace SKUs for non-Ace, non-similar items)
• Fixed a case where coupon a SKU could show in Count Sheets

• Excel Delete Report to exclude new replacement SKUs added via ICM with old Date Added date
• Updated In Stock percentages to annualize twelve trailing months rather than only current month (refreshed In Stock report and help)
• Updated ROI% in In Stock, started to suggest additional quantity to cure out-of-stock (in process)
• Updated In Stock Exception PDF to no longer print SKUs caused by warehouse service level. This info is being sent to Ace now
• Fixed issue with ICM replacement SKUs showing as Swell in some situations
• Fixed Common Transaction Quantity (CTX) to not show crazy suggestions. (Newly added stores were skewing this metric due to a bug)
• Mango Exchange Client updated to accommodate SSH connection to Eagle for pure PCI compliance. New client services, code updater and libraries updated in all stores. whew!
• Updated Exchange Service control panel (used internally) for better usability (you're welcome Nick).
• Moved Help & Support Center to hosted environment for better reliability
• Added Inventory Change Management (ICM) tracking for future possible exception reports.

March 2014 Report Run 

• Added column to In Stock PDF report showing the number of months a SKU sold to zero (non warehouse out affected)
• Updated RPA Audit Master Exception Report to display an "Alert" for out-of-sequence or other RPA filter/grouping issues, removed unnecessary "Store Target" column
• Added Location and Estimated Location to Quick Assortment Report (Exception Report)
• Updated IKM and In-Stock Excel reports with better column help and data quality
• Updated Cost/QOH Exception Report and Static (Fixed/Placeholder) Exception Reports to accommodate large format stores (Costs & Retails > 9,999) 
• Fixed bug in Negative Value reported in Inventory Value Analysis Excel Report

February 2014 Report Run 

• Updated Excel IKM and In-Stock reports Zero Days tabs to include more detail
• Created better tracking/accounting of outs caused by warehouse out-of-stocks

 January 2014 Report Run

• New How to Count Video with "Lines of Defense", Tips before you PIP cards.
• Consolidated Excel reports: Inventory Value Changes into Inventory Changes. Added TTM (twelve trailing months) value change, changed new and deleted SKUs to TTM. 
• Consolidated Excel reports, Class Overview and Location Productivity into Location and Class Productivity.
• New Excel Report (Experimental: inventory IKM) showing two key inventory productivity metrics with actionable SKUs, one of Mango's key reports going forward.
• New Master Exception Report: Kit Record Header Issues for misconfigured Kit Records causing inventory/reorder issues.
• Established new email service for more reliable report delivery, tracking and follow up.
• Fixed Gmail delivery text/html issue with inline CSS.
• New Online Report access system; new users/passwords. New instructional video for Online Reports.
• Added columns to In Stock Days Zero PDF/Excel report: OP, (Twelve Trailing months) TTM Outs.
• Corrected warehouse active SKUs and UPC issues with new Ace data feed.
• Completed new article/warehouse/store data loading processes (Oct/Nov/Dec).
• Added Key Metrics PDF Report to all stores in chain (instead of primary only) in Online Reports.
• Added two new Peer Groups: WISC, PENN.
• Incorporated long-format costs/retails (above 9,999) into data and exception reports.