This model will help you to construct a yearly analysis of these costs, helping you to make important financial decisions accordingly.
This one tab worksheet will allow you to calculate:- Direct materials used in production
- Total manufacturing costs
- Cost of goods manufactured for the year
- Cost of goods sold
- Raw materials inventory
- Purchases of raw materials
- WIP inventories