Raw material consumed is generally calculated as Opening Stock plus Purchases minus Closing Stock of raw materials. Work-in-progress is treated separately, though material content within WIP may need bifurcation for accurate costing and inventory valuation.
23 May 2011
MY COMPANY IS CALCULATING RAW MATERIAL CONSUMED BY USING THE FOLLOWING FORMULA: OPENING WIP XX ADD: RAW MATERIAL ISSUED XX LESS: CLOSING WIP XX
23 May 2011
WIP has no relation with raw material consumed. You will just have to consider Op Stock of Raw Materials, Purchase and Cl. Stock of raw materials. Once Raw Materials are issued whether the same has been converted in finished goods or WIP it is not a matter. Just apply this formula---
Raw Mat Consumed=Op. Stock of Raw Materials+Purchase of Raw Materials-Cl. Stock of Raw Materials.