Question

Perpetual Inventory Using FIFO
Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows:
Inventory Purchases Sales
Dec. 1 310 units at $88 Dec. 10 144 units at $90 Dec. 12 240 units
Dec. 20 240 units at $96 Dec. 14 166 units
Dec. 31 200 units
Assume that the business maintains a perpetual inventory system, costing by the first-in, first-out 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.
Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Answer 1

The cost of sales and the inventory balance at the given dates are:
Date         Cost of sales        Inventory Balance

Dec 12       $21,120                               214

Dec 14        $14,800                         48

Dec 31        $22,752                            14

What is FIFO?

FIFO means first in, first out. It means that it is the first purchased inventory that is the first to be sold.

The items sold on Dec 12 would be taken from the beginning inventory.

Inventory left = (310 - 240) + 144 = 214

Cost of goods sold = 88 x 240 =   $21,120      

The items sold on Dec 14 would be taken from the beginning inventory and the items bought on Dec 10.

Inventory left = 214 - 166 = 48

Cost of goods sold = (88 x 70) + [(166 - 70) x 90] =

6160 +8640 = $14,800

The items sold on Dec 31 would be taken from the inventory purchase on Dec 10 and 20.

Inventory left = (48 + 240) - 200 = 88

Cost of good sold = (48 x 90) + [(240 - 48) x 96) =

4320 + 18,432 = $22,752

To learn more about FIFO, please check: https://brainly.com/question/294129

#SPJ1