Log in
Accounting
1
answer
0
watching
453
views

Perpetual Inventory Using FIFO

Beginning inventory, purchases, and sales data for prepaid cellphones for August are as follows:

Inventory Purchases Sales
August 1 2,200 units at $20 August 10 1,100 units at $22 August 12 1,540 units
August 20 990 units at $24 August 14 1,320 units
August 31 660 units
Hide

Assuming that the perpetual inventory system is used, costing bythe FIFO method, determine the cost of the merchandise sold foreach sale and the inventory balance after each sale.

Schedule of Cost of Merchandise Sold

FIFO Method

Prepaid Cell Phones

Date

Purchases Quantity

Purchases Unit Cost

Purchases Total Cost

Cost of Merchandise Sold Quantity

Cost of Merchandise Sold Unit Cost

Cost of Merchandise Sold Total Cost

Inventory Quantity

Inventory Unit Cost

Inventory Total Cost

Aug. 1

2,200

$ 20

$ 44,000

Aug. 10

$

$

Aug.12

$

$

Aug. 14

Aug. 20

Aug. 31

Aug. 31

Balances

$

$

Watch
1
answer
0
watching
453
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Casey Durgan
Casey DurganLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 Inventory 36 units @ $45 10 Sale 30 units 15 Purchase 17 units @ $47 20 Sale 12 units 24 Sale 8 units 30 Purchase 40 units @ $49 The business maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3. a. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column. Cost of the Merchandise Sold Schedule First-in, First-out Method Portable DVD Players Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost Apr. 1 $ $ Apr. 10 $ $ Apr. 15 $ $ Apr. 20 Apr. 24 Apr. 30 Apr. 30 Balances $ $ b. Based upon the preceding data, would you expect the inventory to be higher or lower using the last-in, first-out method?

Perpetual Inventory Using FIFO

Beginning inventory, purchases, and sales data for portable DVD players are as follows:

Apr. 1 Inventory 36 units @ $45
10 Sale 30 units
15 Purchase 17 units @ $47
20 Sale 12 units
24 Sale 8 units
30 Purchase 40 units @ $49

The business maintains a perpetual inventory system, costing by the first-in, first-out method.

Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3.

a. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Cost of the Merchandise Sold Schedule
First-in, First-out Method
Portable DVD Players
Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
Apr. 1 $ $
Apr. 10 $ $
Apr. 15 $ $
Apr. 20
Apr. 24
Apr. 30
Apr. 30 Balances $ $

b. Based upon the preceding data, would you expect the inventory to be higher or lower using the last-in, first-out method?

Perpetual Inventory Using LIFO

Beginning inventory, purchases, and sales data for portable DVDplayers are as follows:

June 1 Inventory 46 units @ $45
6 Sale 39 units
14 Purchase 58 units @ $48
19 Sale 32 units
25 Sale 9 units
30 Purchase 24 units @ $51

The business maintains a perpetual inventory system, costing bythe last-in, first-out method.

Determine the cost of merchandise sold for each sale and theinventory balance after each sale, presenting the data in the formillustrated in Exhibit 4.

Hide

Under LIFO, if units are in inventory at two different costs,enter the units with the HIGHER unit cost first in the Cost ofMerchandise Sold Unit Cost column and LOWER unit cost first in theInventory Unit Cost column.

Schedule of Cost of Merchandise Sold

LIFO Method

Portable DVD Players

Date

Quantity Purchased

Purchases Unit Cost

Purchases Total Cost

Quantity Sold

Cost of Merchandise Sold Unit Cost

Cost of Merchandise Sold Total Cost

Inventory Quantity

Inventory Unit Cost

Inventory Total Cost

June 1

46

$ 45

$ 2,070

June 6

$

$

June 14

$

$

June 19

June 25

June 30

June 30

Balance

$

21. Altira Corporation uses a periodic inventory system. Thefollowing information related to its merchandise inventory duringthe month of August 2016 is available:

Aug.1 Inventory onhand—2,000 units; cost $6.10 each.
8 Purchased 10,000units for $5.50 each.
14 Sold 8,000 units for$12.00 each.
18 Purchased 6,000units for $5.00 each.
25 Sold 7,000 units for$11.00 each.
31 Inventory onhand—3,000 units.
Required:

Determine the inventory balance Altira would report in itsAugust 31, 2016, balance sheet and the cost of goods sold it wouldreport in its August 2016 income statement using each of thefollowing cost flow methods: (Round "Average Cost per Unit"to 2 decimal places.)

FIFO Cost of Goods Available for Sale Cost of Goods Sold - Periodic FIFO Ending Inventory - Periodic FIFO
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost perunit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
BeginningInventory 2,000 $6.10 $12,200 2,000 $6.10 $12,200 $6.10 $0
Purchases:
August 8 10,000 $5.50 55,000 $5.50 $5.50 0
August 18 6,000 $5.00 30,000 3,000 $5.00 15,000 $5.00
Total 18,000 $97,200 5,000 $27,200 0 $0
AverageCost Cost ofGoods Available for Sale Cost ofGoods Sold - Average Cost EndingInventory - Average Cost
# of units Average Cost per unit Cost of Goods Available for Sale # of units sold Average Cost per Unit Cost of Goods Sold # of units in ending inventory Average Cost per unit Ending Inventory
Beginning Inventory
Purchases:
August 8
August 18
Total 0 $0 $0 $0
LIFO Cost of Goods Available for Sale Cost of Goods Sold - Periodic LIFO Ending Inventory - Periodic LIFO
# ofunits Cost perunit Cost ofGoods Available for Sale # of unitssold Cost perunit Cost ofGoods Sold # of unitsin ending inventory Cost perunit EndingInventory
Beginning Inventory 2,000 $6.10 $12,200 $6.10 $0 $6.10
Purchases:
August 8 10,000 $5.50 55,000 $5.50 $5.50
August 18 6,000 $5.00 30,000 $5.00 $5.00 0
Total 18,000 $97,200 0 $0 0 $0

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in