Jan. 2

Purchased 12 gallons @ $2.20 each

Jan. 6

Purchased 2 gallons @ $2.55 each

Jan. 8

Sold 4 gallons of milk to a customer

Jan. 13

Purchased 4 gallons @ $2.60 each

Jan. 14

Sold 5 gallons of milk to a customer

Part 2

Requirement 2. Determine the amount that would be reported in ending merchandise inventory on

January

15 using the LIFO inventory costing method.

Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX. Enter the oldest inventory layers first.)

	Purchases			Cost of Goods Sold			Inventory on Hand
		Unit	Total		Unit	Total		Unit	Total
Date	Quantity	Cost	Cost	Quantity	Cost	Cost	Quantity	Cost	Cost
Jan. 2	12	$2.20	$26.40				12	$2.20	$26.40
6	2	$2.55	$5.10				12	$2.20	$26.40
							2	$2.55	$5.10
8				2	$2.55	$5.10	10	$2.20	$22.00
				2	$2.20	$4.40
13	4	$2.60	$10.40				10	$2.20	$22.00
							4	$2.60	$10.40
14				4	$2.60	$10.40	9	$2.20	$19.80
				1	$2.20	$2.20
Totals	18		$41.90	9		$22.10	9		$19.80

Part 3

Requirement 3. Determine the amount that would be reported in ending merchandise inventory on

January

15 using the weighted-average inventory costing method.

Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX.)

	Purchases			Cost of Goods Sold			Inventory on Hand
		Unit	Total		Unit	Total		Unit	Total
Date	Quantity	Cost	Cost	Quantity	Cost	Cost	Quantity	Cost	Cost
Jan. 2	12	$2.20	$26.40				12	$2.20	$26.40
6	2	$2.55	$5.10				14	$2.25	$31.50
8				4	2.32	9.28	10	2.32	23.2
13	4	$2.60	$10.40				14	1.75	24.50
14				5	1.75	8.75	9	1.75	15.75
Totals	18		$41.90	9		18.77	9		15.75