EDI 852 files
are typically provided on a weekly basis. These
files are usually referred to as "product activity
data." The challenge is that each retailer uses
a slightly different format, data descriptions,
and code identifiers. EDI 852 files routinely
contain the following information.
For each item
- Item description
- Item UPC
Data can be summarized by:
- Store
- Distribution center
Key product activity measures
- Quantity sold ($)
- Quantity sold (units)
- Quantity on hand ($)
- Quantity on hand (units)
- Quantity on order ($)
- Quantity on order (units)
- Quantity received ($)
- Quantity received (units)
Key forecast measures
- Quantity ($)
- Quantity (units)
Key metrics which can be calculated to evaluate
performance against goal
- Days supply
- Weeks supply
- Sell-thru percentage (%)
- Sales to forecast variance
- Month to date (MTD)sales
- Quarter to date (QTD) sales
- Year to date (YTD) sales
- This month vs. last month
- This quarter vs. last quarter
- This year vs. last year
Work efficiently with EDI 852 data requires
a good analysis tool like Accelerated Analytics.
Otherwise the merchandise planner is left to
sort through line after line of data to find
problems and opportunities. By using Accelerated
Analytics the routine tasks of formatting and
consolidating data are eliminated, and exception
logic can be used to save time.
The Accelerated Analytics teams understands
how to work with EDI 852 data. We eliminate all
the headaches and give you the preformatted reports
you need to run your business.
Request
more information about Accelerated Analytics
|