Question: how to calculate ending raw materials inventory balance?
Answer: Add the number of units you manufactured (or purchased in the case of supplies and raw materials) during the period to the number of units in beginning (existing) inventory. ... 
Subtract the number of units sold from inventory during the period.