dsevey
Number of posts : 8 Location : Rogers, AR Company : Ocean Spray Registration date : 2007-05-22
| Subject: Days of Supply Wed Oct 17, 2007 9: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 : 494 Location : Bentonville, Akansas, USA Company : Clorox Title : Planogram Development Manager Registration date : 2006-11-16
| Subject: Re: Days of Supply Wed Oct 17, 2007 10: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 | |
|