Hi everyone,
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.
Regards
Roman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.