First I should mention I have just started to use SAP. I am currently working on a postponement strategy for a product. The whole idea is to reduce the number of SKUs (variants) in the business plan forecast and create SKUs later on in the warehouse.
Any ideas what data I should consider to compare the actual is-scenario with the future postponement scenario?
I was thinking about
+ Production costs
+ Storage costs = SUM((Costs per product per day*Products in warehouse per day)/(Products sold))
+ Shipping costs = (Total shipping costs of all SKUs [variants])/(Products sold)
+ Interest = SUM(((Capital in warehouse)/(day)) * ((Interest rate)/(365)))
I have most of the figures. However I cannot find a suitable transaction in SAP that gives a table with columns for the number of products in the warehouse (e.g. five columns for five products) and the date from 01/01/2013 - 31/12/2013 in the rows.Date SKU1 SKU2 SKU3 01/01/2013 5 10 ... 02/01/2013 10 70 ... 03/01/2013 5 5 ... ... ... ... ... 31/12/2013 20 0 ...
Eventually I would be interested in creating a query to do the whole analysis for me. At this stage I am more focused on getting the data at all and come up with a accurate model.
Any ideas are appreciated.