Question

In: Accounting

Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...

Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:

Units Unit Cost
Inventory, December 31, prior year 1,890 $ 5
For the current year:
Purchase, March 21 5,080 7
Purchase, August 1 3,000 8
  Inventory, December 31, current year 4,180

Required:

Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods. (Round "Average cost per unit" to 2 decimal places and final answers to nearest whole dollar amount.)

Solutions

Expert Solution

FIFO

LIFO

Weighted Average

Ending Inventory

$    32,260.00

$            25,480.00

$               28,926

Cost of Goods Sold

$    36,750.00

$            43,530.00

$               40,067

  • Workings

FIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

1890

$                   5.00

$                        9,450.00

1890

$                 5.00

$                 9,450.00

0

$                   5.00

$                         -  

Purchases:

21-Mar

5080

$                   7.00

$                      35,560.00

3900

$                 7.00

$               27,300.00

1180

$                   7.00

$            8,260.00

01-Aug

3000

$                   8.00

$                      24,000.00

0

$                 8.00

$                              -  

3000

$                   8.00

$          24,000.00

TOTAL

9970

$                      69,010.00

5790

$               36,750.00

4180

$          32,260.00

LIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

1890

$                   5.00

$                        9,450.00

0

$                 5.00

$                              -  

1890

$                   5.00

$            9,450.00

Purchases:

21-Mar

5080

$                   7.00

$                      35,560.00

2790

$                 7.00

$               19,530.00

2290

$                   7.00

$          16,030.00

01-Aug

3000

$                   8.00

$                      24,000.00

3000

$                 8.00

$               24,000.00

0

$                   8.00

$                         -  

TOTAL

9970

$                      69,010.00

5790

$               43,530.00

4180

$          25,480.00

Average Method

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

1890

$                   5.00

$                        9,450.00

Purchases:

21-Mar

5080

$                   7.00

$                      35,560.00

01-Aug

3000

$                   8.00

$                      24,000.00

TOTAL

9970

$                6.922

$                      69,010.00

5790

$             6.9200

$               40,066.80

4180

$              6.9200

$          28,925.60


Related Solutions

Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:                                                  Units  Cost  Inventory, December 31, prior year 2,000 Unit $3For the current year: Purchase, March 21                     5,190  5Purchase, August 1   ...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Inv Dec 31 prior year Units 2000 - $5 (unit cost) Puchase march 21 : 5000 - $6 Purchase August 1: 3000 - $8 Inventory December 31 current year 4000: (blank) Ending inventory (FIFO/LIFO/AVG COST) Cost of goods sold (FIFO/LIFO/Avg Cost)
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost Inventory, December 31, prior year 2,000 $ 5 For the current year: Purchase, March 21 5,000 6 Purchase, August 1 3,000 8 Inventory, December 31, current year 4,000 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost Inventory, December 31, prior year 1,960 $ 5 For the current year: Purchase, March 21 5,020 7 Purchase, August 1 2,900 8   Inventory, December 31, current year 4,080 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost Inventory, December 31, prior year 1,940 $ 4 For the current year: Purchase, March 21 5,110 6 Purchase, August 1 2,860 7   Inventory, December 31, current year 4,160 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost Inventory, December 31, prior year 1,950 $ 5 For the current year: Purchase, March 21 5,070 7 Purchase, August 1 2,960 8   Inventory, December 31, current year 4,070 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average...
Nittany Company uses a periodic inventory system. At the endof the annual accounting period, December...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:                                         Units  Unit Cost Inventory, December 31, prior year  1,890  $ 7For the current year: Purchase, March 21                      5,150     9         ...
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year
Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods. 
Emily Company uses a periodic inventory system. At the end of the annual accounting period, December...
Emily Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 2: Units Unit Cost Inventory, December 31, prior year 2,890 $ 12 For the current year: Purchase, April 11 8,860 13 Purchase, June 1 7,930 18 Sales ($55 each) 10,860 Operating expenses (excluding income tax expense) $ 191,500 2. Compute the difference between the pretax income and the ending inventory...
Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December...
Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost Inventory, December 31, prior year 2,000 $ 5 For the current year: Purchase, March 21 6,000 4 Purchase, August 1 4,000 2 Inventory, December 31, current year 3,000 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT