Question

Periodic Inventory System. Using FIFO calculate the inventory balance for the month shown below. Show Your...

Periodic Inventory System.

Using FIFO calculate the inventory balance for the month shown below. Show Your Work & Explain your answer.

Cost of goods available for sale:
Date # Units Cost per unit
1/1 Beginning Inventory 40 $60
1/4 Purchased 30 $50
1/15 Purchased 10 $40
1/25 Purchased 12

$55

Retail SOG:
Date Sold # of units sold Price per unit
1/13 25 $65
1/24 45 $85

Homework Answers

Answer #1

As we know FIFO method means first in first out ,is an inventory costing method that companies use to track the cost of inventory that is sold by assuming that the first product purchased is the first product sold. Hence the first product in the door is the first product out of the door.

Total no of units sold are 70 units. so it is assumed that these are sold from the inventory dated 1/1 and 1/4 first in first out.so the reminig inventory dated on 1/15 and 1/25 .which are 22 units.

the value of inventory

1/15 purchased 10 units *$40 per unit =$400

1/25 purchased 12 units * $55 per unit =$660

total ending inventory based on fifo method :400+660 = $1040.

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
Cog of Goods Available for Sale June 1 Beginning Inventory of 30 units at $50 per...
Cog of Goods Available for Sale June 1 Beginning Inventory of 30 units at $50 per unit June 5 Purchased 20 units at $55 per unit June 16 Purchased 25 units at $58 per unit June 28 Purchased 15 units at $60 per unit Retail Sale of Goods: June 14 Sold 35 units at $75 per unit June 27 Sold 40 units at $75 per unit Assuming a periodic inventory system, calculate Red Rock's cost of goods sold for June...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per unit. ABC Company had the following inventory information available for the month of May: May 1 Beginning inventory 1,600 units @ $12 cost per unit May 8 Sold 1,100 units May 13 Purchased 1,700 units @ $24 cost per unit May 18 Sold 1,000 units May 21 Purchased 1,500 units @ $18 cost per unit May 28 Sold 800 units May 30 Purchased 1,200...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 55 units at $82 10 Sale 45 units 15 Purchase 31 units at $87 20 Sale 14 units 24 Sale 13 units 30 Purchase 24 units at $91 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
Beta company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases...
Beta company uses the periodic inventory system. The beginning balance of inventory and subsequent inventory purchases made by the company during the month of July 2019 are given below: July 01: Beginning inventory, 500 units @ $20 per unit. July 18: Inventory purchased, 800 units @ $24 per unit. July 25: Inventory purchased, 700 units @ $26 per unit. The Beta company sold 1,600 units during the month of July. Required: Compute the cost of goods sold and ending inventory...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 40 units at $65 10 Sale 32 units 15 Purchase 19 units at $69 20 Sale 13 units 24 Sale 9 units 30 Purchase 24 units at $73 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the goods sold for each sale and the inventory balance after each sale, presenting the...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 11 units at $24 $264 Aug. 7 Purchase 18 units at $27 486 Dec. 11 Purchase 14 units at $28 392 43 units $1,142 There are 19 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of...
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of June 2018:   Date Transactions Units Cost per Unit Total Cost   June 1 Beginning inventory 17     $240     $ 4,080        June 7 Sale 12       June 12 Purchase 13     230     2,990        June 15 Sale 11       June 24 Purchase 14     220     3,080        June 27 Sale 15       June 29 Purchase 8     210     1,680      $11,830...
Happy Company employs a periodic inventory system and and reported the following inventory information for the...
Happy Company employs a periodic inventory system and and reported the following inventory information for the month of September: September 1 Beginning inventory 3,800 units @ $22 cost per unit September 8 Purchased 2,700 units @ $39 cost per unit September 19 Purchased 1,500 units @ $17 cost per unit September 24 Purchased 2,200 units @ $44 cost per unit September 29 Purchased 3,100 units @ $29 cost per unit Happy Company sold 5,600 units of inventory to customers during...
Periodic System— Calculating Ending Inventory and Cost of Sales using FIFO The following information is available...
Periodic System— Calculating Ending Inventory and Cost of Sales using FIFO The following information is available for Water Inc. Date Units Unit Cost January 1, 2020 (beginning inventory) 100 $50.00 Purchases: January 10, 2020 75 52.00 January 15, 2020 150 52.50 January 30, 2020 100 55.00 The company maintains a periodic inventory system. A physical count shows 125 units in stock on January 31. What is (a) ending inventory on January 31, and (b) cost of goods sold for January,...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: June 1 Inventory 74 units @ $78 6 Sale 55 units 14 Purchase 30 units @ $81 19 Sale 27 units 25 Sale 14 units 30 Purchase 25 units @ $86 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...