I have a requirement to calculate the average daily demand by month for each product line.
Each Manufacturing Org has the list of working days for the month.
|Mfg Org||Month||Working days|
The data for demand in fact table is by day, Item, Org, Dem Qty
Item rolls into Product Line
Based on when the MRP plan was run the number of working days for the month reduces.
So for eg if the MRP plan was run on 15 Jan then the number of working days reduced to 13 days.
Then the average demand for Jan will be all demand in Janurary/ # of working days left in January ie 13
The the average demand for Feb will be all demand in February/# of working days in February.
So how can I dynamically calculate the average daily demand by Org and product line based on when MRP plan completion date
Any pointer highly appreciated