The formula to calculate the Beginning Inventory is:
\[ \text{Beginning Inventory} = \text{Cost of Goods Sold} - \text{Purchases} + \text{Ending Inventory} \]
Where:
Beginning Inventory is the recorded cost of inventory in a company's accounting records at the start of an accounting period.
Let's assume the following values:
Using the formula:
\[ \text{Beginning Inventory} = 40000 - 25000 + 18000 \]
Evaluating:
\[ \text{Beginning Inventory} = 33000 \]
The Beginning Inventory is 33000.
| Cost of Goods Sold | Purchases | Ending Inventory | Beginning Inventory |
|---|---|---|---|
| 30000 | 20000 | 15000 | 25,000.00 |
| 30000 | 20000 | 17500 | 27,500.00 |
| 30000 | 20000 | 20000 | 30,000.00 |
| 30000 | 25000 | 15000 | 20,000.00 |
| 30000 | 25000 | 17500 | 22,500.00 |
| 30000 | 25000 | 20000 | 25,000.00 |
| 30000 | 30000 | 15000 | 15,000.00 |
| 30000 | 30000 | 17500 | 17,500.00 |
| 30000 | 30000 | 20000 | 20,000.00 |
| 35000 | 20000 | 15000 | 30,000.00 |
| 35000 | 20000 | 17500 | 32,500.00 |
| 35000 | 20000 | 20000 | 35,000.00 |
| 35000 | 25000 | 15000 | 25,000.00 |
| 35000 | 25000 | 17500 | 27,500.00 |
| 35000 | 25000 | 20000 | 30,000.00 |
| 35000 | 30000 | 15000 | 20,000.00 |
| 35000 | 30000 | 17500 | 22,500.00 |
| 35000 | 30000 | 20000 | 25,000.00 |
| 40000 | 20000 | 15000 | 35,000.00 |
| 40000 | 20000 | 17500 | 37,500.00 |
| 40000 | 20000 | 20000 | 40,000.00 |
| 40000 | 25000 | 15000 | 30,000.00 |
| 40000 | 25000 | 17500 | 32,500.00 |
| 40000 | 25000 | 20000 | 35,000.00 |
| 40000 | 30000 | 15000 | 25,000.00 |
| 40000 | 30000 | 17500 | 27,500.00 |
| 40000 | 30000 | 20000 | 30,000.00 |
| 45000 | 20000 | 15000 | 40,000.00 |
| 45000 | 20000 | 17500 | 42,500.00 |
| 45000 | 20000 | 20000 | 45,000.00 |
| 45000 | 25000 | 15000 | 35,000.00 |
| 45000 | 25000 | 17500 | 37,500.00 |
| 45000 | 25000 | 20000 | 40,000.00 |
| 45000 | 30000 | 15000 | 30,000.00 |
| 45000 | 30000 | 17500 | 32,500.00 |
| 45000 | 30000 | 20000 | 35,000.00 |
| 50000 | 20000 | 15000 | 45,000.00 |
| 50000 | 20000 | 17500 | 47,500.00 |
| 50000 | 20000 | 20000 | 50,000.00 |
| 50000 | 25000 | 15000 | 40,000.00 |
| 50000 | 25000 | 17500 | 42,500.00 |
| 50000 | 25000 | 20000 | 45,000.00 |
| 50000 | 30000 | 15000 | 35,000.00 |
| 50000 | 30000 | 17500 | 37,500.00 |
| 50000 | 30000 | 20000 | 40,000.00 |