Weighted Average Method
			Running Total	Price		Running Total
1-Sep	Beg Inv	13	13	$ 105.00	$ 1,365	$ 1,365.00
12-Sep	Purchase	44	57	$ 107.00	$ 4,708	$ 6,073.00
19-Sep	Purchase	51	108	$ 109.00	$ 5,559	$ 11,632.00
26-Sep	Purchase	20	128	$ 112.00	$ 2,240	$ 13,872.00
		128	Sold 101/27 Available		$ 13,872
		Average Cost Per Unit = $13,872/128 units or				$ 108.38
COGS Transfer will equal=		101	sold times * average cost per unit			$ 108.38	=	$ 10,945.88
Ending Inventory =		27	$ 108.38	$ 2,926.13
Check Figure =		$ 13,872	= Total Inventory Investment

FIFO Method
COGS Transfer is calculated assuming the units sold to customers (101) are the first units brought into the inventory.
Ending Inventory = remaining units, or the most recent purchases.
SOLD 101 UNITS - FIFO			Remaining		Price	COGS Transfer		Remaining Inventory $
1-Sep	Beg Inv	13	Sold		$ 105.00	$ 1,365.00		$ -
12-Sep	Purchase	44	Sold		$ 107.00	$ 4,708.00		$ -
19-Sep	Purchase	51	44 Sold 7 Available		$ 109.00	$ 4,796.00		$ 763.00
26-Sep	Purchase	20	20 Available		$ 112.00	$ -		$ 2,240.00
		128	101 Sold/27 Available			$ 10,869		$ 3,003	$ 13,872
		FIFO COGS - 101 Units =		$ 10,869		$ -
		FIFO End Inv - 27 units =		$ 3,003
		Check Figure =		$ 13,872	= Total Inventory Investment

I need remaining inventory on dates Sep 1, Sept 12 and the COGS transfer on sept 26