Skip to Content
0
Former Member
Oct 16, 2014 at 10:16 AM

Evaluating postponement strategy

59 Views

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