- Value at the beginning of the month: A (inventory value in your statement)
- Value at the end of the month: B (GEM-CAR report)
- Inventory variation C: B-A
E.g.: Starting inventory 30,000, GEM-CAR inventory 100,000, Variation 70,000
GL Accounting Transaction
- 1535 parts in inventory 70 0000 CREDIT
- 5020 cost of merchandise DEBIT 70 0000
Cost of merchandise sold:
- Parts sales: D
- Parts purchases: E
- Inventory variation: F
- Cost of parts sold G: E - F
E.g.: D: 230,000, E: 240,000, F: 70,000, G: 170,000
- Profit on parts: 230,000 – 170,000 = 60,000
- Profit margin: 60,000 / 230,000 = 26.1% (what margin should I have on my parts? FAQ )