Question

In: Accounting

Kingsley Company uses the periodic inventory system to account for its inventories. Here are Kingsley’s inventory...

Kingsley Company uses the periodic inventory system to account for its inventories. Here are Kingsley’s inventory records for January and February of 2017:

Date

Event

Quantity

Cost per unit

Total Cost

January 1

Inventory on hand

15 units

$10/unit

$150

8

Purchase

20 units

$11/unit

$220

12

Purchase

40 units

$12/unit

$480

29

Purchase

50 units

$13/unit

$650

31

Ending inventory

20 units

?

?

February 8

Purchase

15 units

$14/unit

$210

15

Purchase

40 units

$15/unit

$600

22

Purchase

25 units

$16/unit

$400

28

Ending Inventory

24 units

?

?

  1. Assume that Kingsley has consistently used the FIFO method.   Compute the total cost of the 24 units in the ending inventory as of February 28, and compute the cost of goods sold for the month of February (only).
  2. Assume that Kingsley has consistently used the LIFO method.   Compute the total cost of the 24 units in the ending inventory as of February 28, and compute the cost of goods sold for the month of February (only).
  3. Assume that Kingsley has consistently used the Weighted Average Cost method.   Compute the total cost of the 24 units in the ending inventory as of February 28, and compute the cost of goods sold for the month of February (only).

Solutions

Expert Solution

1. FIFO:

Beginning inventory as on Feb 1 = 20*$13 = $260

Sales units for Feb = 20+15+40+25-24 = 76 units

Ending inventory = 24*$16 = $384

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

Cost of goods available for sale = $260+210+600+400 = $1,470

Cost of goods sold = $1,470 - 384 = $1,086

2. LIFO:

Beginning inventory as on Feb 1 = 15*$10 + 5*$11 = $205

Sales units for Feb = 20+15+40+25-24 = 76 units

Ending inventory = $205 + 4*$14 = 261

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

Cost of goods available for sale = $205+210+600+400 = $1,415

Cost of goods sold = $1,415 - 261 = $1,154

3.

Weighted average cost per unit (January ) = $150+220+480+650 / 125 = $12 per unit

Ending inventory as on January = 20*$12 = $240

Weighted average cost per unit (February) = $240+210+600+400 / 100 = $14.5

Ending inventory (February 28) = 24*$14.5 = $348

Cost of goods sold = 76*$14.5 = $1,102


Related Solutions

Part 2 -McCubbin Company uses the periodic inventory system to account for inventories. Information related to...
Part 2 -McCubbin Company uses the periodic inventory system to account for inventories. Information related to McCubbin Company's inventory at October 31 is given below: October       1      Beginning inventory                               300    units @ $10.00 =           $ 3,000                       8      Purchase                                                   900    units @ $10.40 =               9,360                     16      Purchase                                                   500    units @ $10.80 =               5,400                     24      Purchase                                                   300    units @ $11.60 =            3,480                                         Total units and cost                   2,000    units                                $21,240 Instructions 1.    Show calculations to value the ending...
LEFO Company uses the periodic inventory system to account for inventories. Information related to LEFO Company's...
LEFO Company uses the periodic inventory system to account for inventories. Information related to LEFO Company's inventory at March 31 is given below: Date - Description - Units - Unit Cost March 1 - Beg. Inventory - 10 units - $100 March 8 - Purchase - 10 units - $110 March 17 - Purchase - 10 units - $120 March 24 - Purchase - 10 units - $125 March 30 - Purchase - 10 units - $130 a. Calculate the...
Sunland Company uses a periodic inventory system. Details for the inventory account for the month of...
Sunland Company uses a periodic inventory system. Details for the inventory account for the month of January 2022 are as follows: Units Per unit price Total Balance, 1/1/2022 290 $5.00 $1450 Purchase, 1/15/2022 140 ..5.10 714 Purchase, 1/28/2022 140 ..5.30 742 An end of the month (1/31/2022) inventory showed that 230 units were on hand. If the company uses FIFO and sells the units for $10 each, what is the gross profit for the month? $1695 $1705 $3400 $2300
1. Effie Company uses a periodic inventory system. Details for the inventory account for the month...
1. Effie Company uses a periodic inventory system. Details for the inventory account for the month of January, 2013 are as follows: Units Per unit price Total Balance, 1/1/13 200 $5.00 $1,000 Purchase, 1/15/13 100 5.30 530 Purchase, 1/28/13 100 5.50 550 An end of the month (1/31/13) inventory showed that 140 units were on hand. If the company uses LIFO, what is the value of the ending inventory? A. $742 B. $728 C. $762 D. $700 2. A company...
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.
Tom Wholeseller uses the perpetual inventory system to record its inventories.   June 5th. Sold, on account,...
Tom Wholeseller uses the perpetual inventory system to record its inventories.   June 5th. Sold, on account, merchandises valued at $45,000 to Joe Customer. The merchandises had originally cost Tom Wholeseller $15,000. Credit terms were 2/10, n/30. June 11th. Joe Customer returned merchandises valued at $8,000. Tom Wholeseller had originally purchased those merchandises for 3,500. June 14th. Joe Customer settled the account. Prepare the 3 journal entries in the Diagonal Box for Tom Wholeseller.
he Kali Company uses the periodic inventory system for its merchandise inventory. The June 1 inventory...
he Kali Company uses the periodic inventory system for its merchandise inventory. The June 1 inventory for one of the items in the merchandise inventory consisted of 60 units with a unit cost of $45. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $50 per unit 13 Sold 50 units @ $95 per unit 25 Purchased 40 units @ $53 per unit 29 Sold 20 units@ $110 per unit Required a. Compute the...
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...
Splish Brothers Inc. uses a periodic inventory system. Details for the inventory account for the month...
Splish Brothers Inc. uses a periodic inventory system. Details for the inventory account for the month of January 2022 are as follows: Units Per unit price Total Balance, 1/1/2022 360 $6.00 $2160 Purchase, 1/15/2022 180 ..6.40 1152 Purchase, 1/28/2022 180 ..6.60 1188 An end of the month (1/31/2022) inventory showed that 290 units were on hand. If the company uses LIFO, what is the value of the ending inventory? $1836 $1740 $1892 $2760
Inventory Costing Methods - Periodic Method Fortune Stores uses the periodic inventory system for its merchandise...
Inventory Costing Methods - Periodic Method Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $355. Transactions for this item during April were as follows: Required a. Calculate the cost of goods sold and the ending inventory cost for the month of April using the weighted-average cost method. Do not round until your final answers. Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT