Question

In: Accounting

Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 440 pairs of shoes at $73...

Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 440 pairs of shoes at $73 each in June, 960 pairs in August at $75 each, and 620 pairs in December at $78 each. Zippy sold 1,880 pairs of shoes during the year.


Required:

Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods.

  1. FIFO
  2. LIFO
  3. Weighted Average

Solutions

Expert Solution

Number of units available for sale = 440 + 960 + 620

= 2,020

Units in ending inventory = Number of units available for sale - Units sold

= 2,020 - 1,880

= 140

Cost of units available for sale = (440 units * $73) + (960 units * $75) + (620 units * $78)

= $32,120 + $72,000 + $48,360

= $152,480

------------------------------------------------------------------------------------------

Under the First in first out (FIFO) method of inventory valuation, Cost of goods sold consists of the units from beginning inventory and earliest purchases. Ending inventory consists of the units from recent purchases.

140 units in ending inventory consists of December purchases.

Ending inventory = 140 units * $78

= $10,920

Cost of goods sold = Cost of units available for sale - Ending inventory

= $152,480 - $10,920

= $141,560

------------------------------------------------------------------------------------------

Under the Last in first out (LIFO) method of inventory valuation, Cost of goods sold consists of the units from recent purchases. Ending inventory consists of the units from beginning inventory and earliest purchases.

140 units in ending inventory consists of June purchases.

Ending inventory = 140 units * $73

= $10,220

Cost of goods sold = Cost of units available for sale - Ending inventory

= $152,480 - $10,220

= $142,260

------------------------------------------------------------------------------------------

Under the Weighted average method of inventory valuation both Cost of goods sold and Ending inventory are valued at average unit cost.

Weighted average cost per unit = Cost of units available for sale / Number of units available for sale

= $152,480 / 2,020

= $75.49 (rounded to 2 decimal places)

Ending inventory = 140 units * $75.49 = $10,569 (rounded to 0 decimal places)

Cost of goods sold = 1,880 units * $75.49 = $141,921 (rounded to 0 decimal places)


Related Solutions

Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 405 pairs of shoes at $65...
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 405 pairs of shoes at $65 each in June, 965 pairs in August at $67 each, and 610 pairs in December at $70 each. Zippy sold 1,875 pairs of shoes during the year. Required: Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods. FIFO LIFO Weighted Average
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 415 pairs of shoes at $71...
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 415 pairs of shoes at $71 each in June, 980 pairs in August at $73 each, and 640 pairs in December at $76 each. Zippy sold 1,895 pairs of shoes during the year. Required: Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods. FIFO LIFO Weighted Average
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 430 pairs of shoes at $69...
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 430 pairs of shoes at $69 each in June, 990 pairs in August at $71 each, and 620 pairs in December at $74 each. Zippy sold 1,895 pairs of shoes during the year. Required: Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods. FIFO LIFO Weighted Average
SAP Co. uses a periodic inventory system. It records show the following for the month of...
SAP Co. uses a periodic inventory system. It records show the following for the month of February: Date Units UnitPrice Total Cost 2/1 40 $20.00 $800 2/15 Purchases 130 22.00 2,860 2/24 Purchases 110 23.50 2,585 Totals   280 $6,245 2/20 Sales 100 47.00 2/27 Sales 130 47.00 Given the information above, please calculate COGS,Ending Inventory, and Gross Profit under each of the following methods. (Please explain) 1) FIFO: 2) LIFO: 3) Average Cost:
1. Bombay Co. uses a periodic inventory system. Beginning inventory on January 1 was overstated by...
1. Bombay Co. uses a periodic inventory system. Beginning inventory on January 1 was overstated by $32,000, and its ending inventory on December 31 was understated by $62,000. These errors were not discovered until the next year. As a result, Bombay's cost of goods sold for this year was: A. Overstated by $30,000. B. Understated by $30,000. C. Understated by $94,000. D. Overstated by $94,000. 2. Which of the following best demonstrates the full disclosure principle? A. The company's tax...
Periodic Inventory by Three MethodsDymac Appliances uses the periodic inventory system. Detailsregarding the inventory...
Periodic Inventory by Three MethodsDymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows:Required:1. Determine the cost of the inventory on December 31 by the first-in, first-out method.If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each...
Capwell Corporation uses a periodic inventory system
Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2011, its fiscal-year end, based on a physical count, was determined to be $326,000. Capwell's unadjusted trial balance also showed the following account balances: Purchases, $620,000; Accounts payable; $210,000; Accounts receivable, $225,000; Sales revenue, $840,000. The internal audit department discovered the following items:1. Goods valued at $32,000 held on consignment from Dix Company were included in the physical count but not recorded as a purchase.2. Purchases...
Broadhead Company uses a periodic inventory system.
Broadhead 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: Required: 1. Prepare a separate income statement through pretax income that details cost of goods sold for (a) Case A: FIFO and (b) Case B: LIFO.
Exercise 2: Inventory-Related Calculations in a Periodic System The Travalent Company uses the periodic inventory system.  The...
Exercise 2: Inventory-Related Calculations in a Periodic System The Travalent Company uses the periodic inventory system.  The following information is taken from their records. Certain data have been intentionally omitted. Required: Compute the missing numbers. 2018 2019 2020 Sales $4,000 $4,200 Sales Discounts (20) (25) (30) Sales Returns (10) (20) (15) Net Sales Beginning Inventory 1,000 1,345 Purchases 3,000 2,700 Freight-In 150 200 250 Purchase Returns (200) (250) (200) Purchase Discounts (100) (150) Net Purchases 3,000 Cost of Goods Available for...
Periodic Inventory by Three Methods Dymac Appliances uses the periodic inventory system. Details regarding the inventory...
Periodic Inventory by Three Methods Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Purchases Invoices Model Inventory, January 1    1st    2nd    3rd    Inventory Count, December 31 A10 __ 4 at $ 64 4 at $ 70 4 at $ 76 6 B15 8 at $ 176 4 at 158 3 at 170 6 at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT