Use this chart to keep track of inventory vallles Purchases Sales Balance Date Quantity Unit Cost Value Quantity Unit Cost Value Quantity Unit Cost Value Sept 30 500 25.50 12,750.00 1-Oct 1,000 30.00 30,000.00 1,500 28.50 42,750.00 2-Oct 700 28.50 19,950.00 800 28.50 22,800.00 5-Oct 600 25.00 15,000.00 1.400 27.00 37,800.00 7-Oct -200 25,00 -5,000.00 1,200 27.33 32,800.00 Note: You need to deduct the cost of any goods returned to inventory from the Purchases(Value)and Balance Value) columns above