History of Fixed and Variable Costs

Hi All,

Is there a simple way of going back and obtaining all costs for all raw, semi and finished goods and being able to determine how much of every ton we consume is fixed and how much is variable cost? I could do the current month but then the cumulative inventory is carrying older costs.

Please advise

Thanks