Question

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 2,300 units at $37 May 10 1,150 units at $39 May 12 1,610 units
May 20 1,035 units at $41 May 14 1,380 units
May 31 690 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 the data in the form illustrated in Exhibit 3. 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.

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
May 1 $ $
May 10 $ $
May 12 $ $
May 14
May 20
May 31
May 31 Balances $

Homework Answers

Answer #1

Solution:

Schedule of Cost of Goods Sold
FIFO Method
Prepaid Cell Phones
Date Purchases Quantity Purchases Unit Cost Purchases Total Cost Cost of Goods Sold Quantity Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
May. 1 2300 $37.00 $85,100.00
May. 10 1150 $39.00 $44,850.00 2300 $37.00 $85,100.00
1150 $39.00 $44,850.00
May. 12 1610 $37.00 $59,570.00 690 $37.00 $25,530.00
1150 $39.00 $44,850.00
May. 14 690 $37.00 $25,530.00 460 $39.00 $17,940.00
690 $39.00 $26,910.00
May. 20 1035 $41.00 $42,435.00 460 $39.00 $17,940.00
1035 $41.00 $42,435.00
May. 31 460 $39.00 $17,940.00 805 $41.00 $33,005.00
230 $41.00 $9,430.00
May. 31 Balances $139,380.00 805 $33,005.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 2,300 units at $21 May 10 1,150 units at $23 May 12 1,610 units May 20 1,035 units at $25 May 14 1,380 units May 31 690 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...
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,500 units at $31 May 10 1,750 units at $33 May 12 2,450 units May 20 1,575 units at $35 May 14 2,100 units May 31 1,050 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...
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 1,800 units at $40 May 10 900 units at $42 May 12 1,260 units May 20 810 units at $44 May 14 1,080 units May 31 540 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...
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,400 units at $40 May 10 1,700 units at $42 May 12 2,380 units May 20 1,530 units at $44 May 14 2,040 units May 31 1,020 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...
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 1,600 units at $32 May 10 800 units at $34 May 12 1,120 units May 20 720 units at $36 May 14 960 units May 31 480 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...
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 1,550 units at $44 May 10 720 units at $45 May 12 1,200 units May 20 1,200 units at $48 May 14 830 units May 31 1,000 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...
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 1,600 units at $26 May 10 800 units at $28 May 12 1,120 units May 20 720 units at $30 May 14 960 units May 31 480 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...
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,200 units at $27 May 10 1,100 units at $29 May 12 1,540 units May 20 990 units at $31 May 14 1,320 units May 31 660 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 2,700 units at $26 May 10 1,350 units at $28 May 12 1,890 units May 20 1,215 units at $30 May 14 1,620 units May 31 810 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 2,500 units at $34 May 10 1,250 units at $36 May 12 1,750 units May 20 1,125 units at $38 May 14 1,500 units May 31 750 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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT