Question

In: Accounting

The inventory records for Tiny Tim Creations Inc. indicate the following activity for the month of...

The inventory records for Tiny Tim Creations Inc. indicate the following activity for the month of January:

January 1 balance,

1000 units @ $7.20 each

Purchases:

January 10: 600 units @ $7.25 each

January 16: 800 units @ $7.30 each

January 23: 600 units @ $7.35 each

Sales:

January 5: 400 units

January 14: 700 units

January 20: 500 units

January 26: 700 units

1. January 31st ending inventory using unit LIFO in a perpetual inventory system is:

A) $4,960

B) $5,060

C) $5,080

D) $5,140

Solutions

Expert Solution

The right option is " B) $5,060 ".

Ending inventory using unit LIFO in a perpetual inventory system:

Opening inventory Purchases Sales Ending inventory
Date units Cost per unit Total cost units Cost per unit Total cost units Cost per unit Total cost units Cost per unit Total cost
January 1 1,000 units $7.20 $7,200 - - - - - - 1,000 units $7.20 $7,200
January 5 1,000 units $7.20 $7,200 - - - 400 units $7.20 $2,880 600 units $7.20 $4,320
january 10 600 units $7.20 $4,320 600 units $7.25 $4,350 - - - 600 units $7.20 $4,320
600 units $7.25 $4,350
"january 14 600 units $7.20 $4,320 - - - 600 units $7.25 $4,350 500 units $7.20 $3,600
600 units $7.25 $4,350 100 units $7.20 $720
january 16 500 units $7.20 $3,600 800 units $7.30 $5,840 - - - 500 units $7.20 $3,600
800 units $7.30 $5,840
"january 20 500 units $7.20 $3,600 - - - 500 units $7.30 $3,650 500 units $7.20 $3,600
800 units $7.30 $5,840 300 units $7.30 $2,190
January 23 500 units $7.20 $3,600 600 units $7.35 $4,410 - - - 500 units $7.20 $3,600
300 units $7.30 $2,190 300 units $7.30 $2,190
600 units $7.35 $4,410
January 23 500 units $7.20 $3,600 - - - 600 units $7.35 $4,410 500 units $7.20 $3,600
300 units $7.30 $2,190 100 units $7.30 $730 200 units $7.30 $1,460
600 units $7.35 $4,410

Total cost of ending inventory = ( 500 units @ $7.20 ) + ( 200 units @ $7.30 ) = $5,060


Related Solutions

Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of June: Units Cost/Unit Inventory, June 1 200 $3.20 Purchases:       June 3 200 3.50       June 17 250 3.60       June 24 300 3.65 Sales:       June 6 300       June 21 200       June 27 150 Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of June: Units Cost/Unit Inventory, June 1 200 $3.20 Purchases: June 3 200 3.50 June 17 250 3.60 June 24 300 3.65 Sales: June 6 300 June 21 200 June 27 150 Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the...
Park Company's perpetual inventory records indicate the following transactions in the month of June:
Alternative Inventory MethodsPark Company's perpetual inventory records indicate the following transactions in the month of June:UnitsCost/UnitInventory, June 1200$3.20Purchases:      June 32003.50      June 172503.60      June 243003.65Sales:      June 6300      June 21200      June 27150Required:1.Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the nearest dollar.FIFOCost of Goods Sold$  fill in the blank 1Ending Inventory$  fill in the blank 2LIFO (Round your intermediate calculations and final answers to the nearest cent.)Cost of...
A company's inventory records indicate the following data for the month of April: April 1 Beginning...
A company's inventory records indicate the following data for the month of April: April 1 Beginning 350 units at $18 each April 5 Purchase 290 units at $20 each April 9 Sale 500 units at $55 each April 14 Purchase 250 units at $22 each April 20 Sale 200 units at $55 each April 30 Purchase 240 units at $25 each The company uses the perpetual inventory system What would be the cost of the ending inventory under the following...
The following information was collected from the inventory records of a company for the month of...
The following information was collected from the inventory records of a company for the month of March, 2010. During March the company sold 90 units of its product at $25 per unit. Date Units Unit Cost Total Cost Beginning inventory March 1 15 $10.00 $150 Purchase March 5 35 $12.00 $420 Purchase March 10 70 $14.00 $980 Purchase March 17 25 $15.00 $375 Determine cost of goods sold under LIFO for the month of March. answer choices: 1285, 640, 1130,...
Case D. Stewart Company reports the following inventory records for November:      INVENTORY Date Activity #...
Case D. Stewart Company reports the following inventory records for November:      INVENTORY Date Activity # of Units Cost/Unit November 1 Beginning balance 125 $ 16 November 4 Purchase 330 17 November 7 Sale (@ $57 per unit) 210 November 13 Purchase 510 19 November 22 Sale (@ $57 per unit) 505 Selling, administrative, and depreciation expenses for the month were $15,500. Stewart’s tax rate is 30 percent.     1. Calculate the cost of ending inventory and the cost of goods...
The periodic inventory records of Flexon Prosthetics indicate the following at October 31: Oct.1 Beginning inventory...
The periodic inventory records of Flexon Prosthetics indicate the following at October 31: Oct.1 Beginning inventory 9 units @ $60 8 Purchase 4 units @ 60 15 Purchase 10 units @ 70 26 Purchase 3 units @ 80 At October 31 Flexon counts 8 units of inventory on hand. Requirements: Compute ending inventory and cost of goods sold, using each of the following methods: 1. Average cost (round average unit cost to the nearest cent) 3. FIFO 4. LIFO
The following information is taken from the inventory records of the CNB Company for the month...
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 6,300 units @ $11.00 Purchases: 9/7 4,200 units @ $11.60 9/25 10,500 units @ $12.20 Sales: 9/10 5,000 units 9/29 6,000 units 10,000 units were on hand at the end of September. Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory....
The following information is taken from the inventory records of the CNB Company for the month...
The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 7,000 units @ $10.00 Purchases: 9/7 3,000 units @ $11.00 9/25 10,000 units @ $11.50 Sales: 9/10 4,000 units 9/29 5,000 units 11,000 units were on hand at the end of September. Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory....
Hess Company's inventory records show the following data for the month of September:                             &
Hess Company's inventory records show the following data for the month of September:                                                                                       Units                          Unit Cost Inventory, September 1                     100                            $3.00 Purchases: September 8                   450                              3.50                    September 18                    300                              3.70 A physical inventory on September 30 shows 150 units on hand. a. Calculate the value of ending inventory and cost of goods sold if the company uses FIFO inventory costing and a periodic inventory system. b. Calculate the value of ending inventory and cost of goods sold if...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT