Question

Given the following data, calculate cost of goods sold and the cost of ending inventory. 3...

Given the following data, calculate cost of goods sold and the cost of ending inventory.
3 separate methods, FIFO, LIFO and Weighted Average. You must show ALL calculations.

Date Transaction
1/10 Bought 200 inventory units @ $15

1/20 Bought 200 inventory units @ $17

1/25 Sold 150 inventory units @ $30

1/28 Bought 100 inventory units @ $20

1/31 Sold 120 inventory units @ $30

2/4 Bought 90 inventory units @ $21

Date ?Goods Purchased Cost of Goods sold Inventory Balance

Homework Answers

Answer #1

Answer:

FIFO:

2 LIFO

3 Weighted Average

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
Calculate cost of goods sold and ending inventory under each of the following methods given the...
Calculate cost of goods sold and ending inventory under each of the following methods given the following information about purchases and sales during the year. Jan. 1           Beginning Inventory       300 units @ $3 Jan. 5           Sales                                      100 units Jan. 15        Purchases                           400 units @ $4 Jan. 20        Sales                                      200 units a. FIFO. b. LIFO.
M7-7 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under...
M7-7 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weighted Average Cost (Periodic Inventory) [LO 7-3] Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July. Units Unit Cost July 1 Beginning Inventory 2,500 $ 50...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 30 units at $126 Mar. 10 Purchase 50 units at $138 Aug. 30 Purchase 30 units at $146 Dec. 12 Purchase 90 units at $150 There are 40 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 180 units at $108 Mar. 10 Purchase 224 units at $110 Aug. 30 Purchase 200 units at $116 Dec. 12 Purchase 196 units at $120 There are 208 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the LIFO method, ending inventory is 53 units. (Round your answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 4 $ 3.40 April 10 11 3.90 May 15 11 4.40 July 22 16 4.65 August 19 17 5.40 September 30 21 5.60 November 10 31 5.80 December 15 17 6.20 costs of ending inventory? Cost of goods sold?
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $112 Mar. 10 Purchase 70 units at $120 Aug. 30 Purchase 30 units at $126 Dec. 12 Purchase 60 units at $130 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-8) [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Cost per Unit Total Cost March 1 Beginning inventory 20 $195 $ 3,900 March 5 Sale ($290 each) 15 March 9...
Use the information below to determine the number of units in ending inventory and the ending...
Use the information below to determine the number of units in ending inventory and the ending inventory value using the perpetual inventory system for FIFO. ($) Number Per Date Transaction of units unit Apr. 3 Inventory 30 800 8 Purchase 60 820 11 Sale 40 - 30 Sale 30 - May 8 Purchase 60 850 10 Sale 20 - 19 Sale 15 - 28 Purchase 80 900 Part 2 There are 10 units in ending inventory compute the value of...
Problem 6-1A Calculate ending inventory and cost of goods sold for four inventory methods (LO6-3) [The...
Problem 6-1A Calculate ending inventory and cost of goods sold for four inventory methods (LO6-3) [The following information applies to the questions displayed below.] Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 880 $ 5,280 October 4 Sale 4 October 10 Purchase 5 890 4,450 October 13 Sale 3...
A company's inventory records indicate the following data for the month of September: Sept 1 beginning...
A company's inventory records indicate the following data for the month of September: Sept 1 beginning 250 units at $10 each Sept 5 purchased 150 units at $11 each Sept 10 sold 300 units Sept 20 purchased 400 units at $14 each Sept 25 sold 200 units If the company uses the perpetual inventory system, what would be the cost of its ending inventory and the cost of goods sold for July based on FIFO, LIFO and Weighted Average methods?