JC Penney EDI 852 Reporting

If you are a vendor supplying to JC Penney, you are eligible to receive product sales activity and inventory data via EDI 852. Preparing to setup and receive the EDI 852 files can be confusing, and creating usable reports for your team can be very time consuming. Fortunately, Accelerated Analytics® provides a simple, outsourced service… Read more »

Home Depot EDI 852 Reporting

If you are a Home Depot vendor, you are eligible to receive product sales activity and inventory data via EDI 852. Preparing to setup and receive the EDI 852 files can be confusing, and creating usable reports for your team can be very time consuming. Fortunately, Accelerated Analytics® provides a simple, outsourced service for all… Read more »

POS Analysis – Analysis and Reporting Made Easy

Still messing with manual? If you are a vendor supplying to a retailer, you are no doubt receiving POS and inventory data. Sorting out all of that data can be a real headache, considering the files can be different for each retailer. Your team probably spends hours each week manually entering data, creating spreadsheets and… Read more »

Supply Chain Analytics: Challenges and Solutions

Retailers and vendors in today’s retail market face the unenviable challenge of reducing costs and maintaining margins, despite falling overall sales and slow-to-recover consumer demand. One of the areas in which retailers are pushing back onto vendors is inventory management, which for vendors too often translates into retail partners that reduce overall inventories and require… Read more »

You’re not the only one

I sat down with an analyst at a consumer products company the other day, and had an in depth conversation with her about the process she goes through to export data from Retail Link and transform the data into reports for her management. I’ve been working with Walmart vendors for a long time, so I… Read more »

BI in the Supply Chain

I read this very good article yesterday and wanted to share it.  Business Intelligence and Performance Management Rising to the Top of the Supply Chain Executive’s Agenda By Viktoriya Sadlovska and Nari Viswanathan In the context of today’s complex demand-supply networks, in which visibility into key performance indicators across the entire network is key to business… Read more »

Calculating Weeks of Supply

A metric fundamental to managing the retail supply chain is weeks of supply (WOS). Weeks of supply tells the inventory manager how long the current on hand will last, based on current sales demand.  By keeping your eye on weeks of supply, you can avoid inventory stock outs and lost sales.  The basic calculation for… Read more »

Retail Replenishment – How tuned in are you?

I spent about 9 hours yesterday analyzing sales, order and forecast data for Walmart, Home Depot and Lowe’s vendors, and I am somewhat surprised by my observations.  It’s pretty clear that there are some min/max rules in place, as I can see patterns to the order quantities based on the OH inventory and the order… Read more »

Store Level Merchandising Analysis Using EDI 852

The following is a step by step process to aid replenishment vendors in identifying stores on an item level basis, that are losing sales due to inventory stock outs or inventory that is present but unavailable for sale.  Such unavailable inventory may include lost or damaged items or items on the shelf but not available… Read more »

Poor Weather Causes Out of Stocks

According to the WSJ, the snowstorms that blanketed much of the country in the past week caught apparel retailers in short-sleeves. Most clothing chains have very little winter clothing left on their racks, the result of tightly managed inventories and better-than-expected holiday sales. But, with nearly 70% of the country covered in snow, store shelves… Read more »