I have sales info for approx 25 items. Every month I get a sales report (and corresponding inventory report). I have data for 12+ months. I need to be able to analyse the sales rates, with visuals after I put the sales rates in.
In summary, I need a spreadsheet whereby
*I can load the weekly/monthly sales & Stock on Hand that will in turn show me sales rate.
*I also want to be able to have drop down boxes so I can select each sku/supplier to view. (I will have 6 or 7 names of suppliers with a few specific sku's per supplier)
*I need a Purchases section (column) whereby I can input what I have purchased and yet to arrive and have the spreadsheet amend the sales rate until stock runs out (adjusted sales rate based on shipping time - months).
*Reporting page with some pictures/graphs (not sure what I need to show).
*If possible, and separate to the above, I want to be able to load in sales throughout the year to show an annualised sales graph - In other words, I'd like to see for each sku, where the sales are happening throughout the year (graph by month/quarter).
Basically I need something I can easily upload sales data into that will spit out my sales rates over a given period, weigh up how much stock I have left at current sales rates and adjust for stock on order so I can be ahead of my inventory control.