calculate opening stock and closing stock using loop
hi,
i have data which is moth wise as well as model wise ...i have opening stock of the first month,now i want to calculate the stock received and the closing stock of the first and next 11 months,also the forecast opening stock from next month ....also previous months closing stock will b the next months opening stock i.e closing stock(April)=opening stock(May) and i want to calculate opening stock ,stock received as well as closing stock for 12 months....here i need loop....
Given:Opening Stock of the first month
achieve: Stock received and closing stock of the first Month
forecast opening Stock, Stock received and closing stock from the next month .
