Create an inventory template for a company with data in sales and stock
I'd like to see the inventory numbers that need to be ordered along with trend analysis for each product line and ideal reorder numbers for the line items
You need to make an analysis of items which are available in all 12 months
The numbers you see represent stock/ in transit levels end of each month in year. You can perform the analysis on about 100 items that have data for the whole 12 month period and also propose an ideal reorder point and projected sales for the following 6 months with a confidence interval of 95%.