Question

In: Accounting

Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for December...

  1. Perpetual Inventory Using LIFO

    Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows:

    Inventory Purchases Sales
    Dec. 1 3,100 units at $33 Dec. 10 1,550 units at $35 Dec. 12 2,170 units
    Dec. 20 1,395 units at $37 Dec. 14 1,860 units
    Dec. 31 930 units

    a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

    Schedule of Cost of Goods Sold
    LIFO Method
    Prepaid Cell Phones
    Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
    Dec. 1 $ $
    Dec. 10 $ $
    Dec. 12 $ $
    Dec. 14
    Dec. 20
    Dec. 31
    Dec. 31 Balances $ $

Solutions

Expert Solution

Answer)

Calculation of Cost of Goods Sold and Value of ending inventory using LIFO Method, perpetual inventory System

Date

Quantity Purchased

Purchases Unit Cost

Purchases Total Cost

Quantity Sold

Cost of Goods Sold Unit Cost

Cost of Goods Sold Total Cost

Inventory Quantity

Inventory Unit Cost

Inventory Total Cost

Dec'1

            3,100

$        33.00

$ 102,300.00

Dec'10

           1,550

$        35.00

$     54,250.00

            3,100

$        33.00

$ 102,300.00

            1,550

$        35.00

$     54,250.00

Dec'12

        1,550

$            35.00

$         54,250.00

            2,480

$        33.00

$     81,840.00

           620

$            33.00

$         20,460.00

Dec'14

        1,860

$            33.00

$         61,380.00

                620

$        33.00

$     20,460.00

Dec'20

           1,395

$        37.00

$     51,615.00

                620

$        33.00

$     20,460.00

            1,395

$        37.00

$     51,615.00

Dec'31

           930

$            37.00

$         34,410.00

                620

$        33.00

$     20,460.00

                465

$        37.00

$     17,205.00

Total

           2,945

$ 105,865.00

        4,960

$     170,500.00

            1,085

$     37,665.00

Cost of Goods sold = $ 170,500

Value of Ending Inventory = $ 37,665


Related Solutions

Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 2,400 units at $22 May 10 1,200 units at $24 May 12 1,680 units May 20 1,080 units at $26 May 14 1,440 units May 31 720 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 1,200 units at $33 May 10 600 units at $35 May 12 840 units May 20 540 units at $37 May 14 720 units May 31 360 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,800 units at $29 May 10 1,900 units at $31 May 12 2,660 units May 20 1,710 units at $33 May 14 2,280 units May 31 1,140 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 4,000 units at $21 May 10 2,000 units at $23 May 12 2,800 units May 20 1,800 units at $25 May 14 2,400 units May 31 1,200 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,600 units at $32 May 10 1,800 units at $34 May 12 2,520 units May 20 1,620 units at $36 May 14 2,160 units May 31 1,080 units Assume that the business maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance...
Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory...
Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Purchases Sales Dec. 1 2,900 units at $34 Dec. 10 1,450 units at $36 Dec. 12 2,030 units Dec. 20 1,305 units at $38 Dec. 14 1,740 units Dec. 31 870 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the...
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory...
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,300 units at $32 May 10 1,650 units at $34 May 12 2,310 units May 20 1,485 units at $36 May 14 1,980 units May 31 990 units Assume that the business maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 66 units @ $57 10 Sale 44 units 15 Purchase 79 units @ $60 20 Sale 43 units 24 Sale 13 units 30 Purchase 30 units @ $64 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable DVD players are as...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 Inventory 45 units @ $50 10 Sale 32 units 15 Purchase 60 units @ $53 20 Sale 33 units 24 Sale 10 units 30 Purchase 24 units @ $56 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 56 units @ $98 10 Sale 43 units 15 Purchase 73 units @ $104 20 Sale 42 units 24 Sale 11 units 30 Purchase 28 units @ $110 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT