Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods

The units of an item available for sale during the year were as follows:

Jan. 1	Inventory	5	units at $3,600	$18,000
Aug. 7	Purchase	19	units at $3,800	72,200
Dec. 11	Purchase	15	units at $3,900	58,500
		39	units	$148,700

There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar).

a.	First-in, first-out (FIFO)	$fill in the blank 1
b.	Last-in, first-out (LIFO)	$fill in the blank 2
c.	Weighted average cost	$fill in the blank 3

1. Inventory Turnover and Days' Sales in Inventory

   Financial statement data for years ending December 31 for Amsterdam Company follow:

   	20Y4				20Y3
   Cost of merchandise sold	$3,598,900				$3,015,630
   Inventories:
   Beginning of year	593,000				589,600
   End of year	648,000				593,000

   a. Determine the inventory turnover for 20Y4 and 20Y3. Round to one decimal place.

   	Inventory Turnover
   20Y4	fill in the blank 1
   20Y3	fill in the blank 2

   b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and final answers to one decimal place.

   	Days' Sales in Inventory
   20Y4	fill in the blank 3 days
   20Y3	fill in the blank 4 days

   c. Does the change in the inventory turnover and the days' sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?

Check My Work