dsevey
Number of posts: 8 Location: Rogers, AR Company: Ocean Spray Registration date: 2007-05-22
 | Subject: Days of Supply Wed Oct 17, 2007 8:34 am | |
| What would be the best way to go about pulling data from Retail Link to do a Days of Supply Analysis in ProSpace? |
|
Eric Liberatore Admin


Number of posts: 429 Location: Bentonville, Akansas, USA Company: Clorox Registration date: 2006-11-16
 | Subject: Re: Days of Supply Wed Oct 17, 2007 9:12 am | |
| From Store Detail pull Modular Plan Desc, UPC, Avg Price and Units Per Store Per Week with zeros. Then you will need to take this data and create a product library. Map Mod Plan Desc to Planogram Alias, Avg Price to Price and USW to Unit Movement. Then once you've updated from this library you can create a table that uses a field called Actual Days Supply(Performance). For instructions on creating the product library click here |
|