Simulation based on monthly not yearly

Hi All,

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?

Regards,

Nagaveni