would like to check if this is possible:
i would like to forecast COGS based on monthly bases with different percentages monthly , not yearly.
e.g : for raw material ABC the simulated price increase is 5% in January and 10% in February.
This price increase should then be reflected in the cost of final goods and result in higher COGS in February.
is this possible?