Question

Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by...

Determine Colour ending inventory and cost of goods sold under the LIFO perpetual basis. Begin by preparing Colour perpetual inventory record under the​ last-in, first-out​ (LIFO) method for the year

Transaction

Units

Sales in Units

Unit Cost

Total Cost

Beginning inventory 1/1

5,500

$51

$280,500

Purchases

March 30

4,500

67

301,500

July 15

850

70

59,500

September 1

6,600

Total available for sale

10,850

$641,500

Units sold September 1

(6,600)

Ending inventory

4,250

LIFO:

Cost of

Cost of

Units

Unit

Total

Units

Goods Sold

Goods

Inventory

Transaction

Purchased

Cost

Cost

Sold

Per Unit

Sold

Balance

Beginning inventory 1/1

Purchase - March 30

Purchase - July 15

Sale - September 1

Homework Answers

Answer #1

Answer- Ending inventory under LIFO method = $216750.

Cost of goods sold under LIFO method = $424750

Explanation-

LIFO Method
Goods purchased Cost of goods sold Inventory balance
Date # of units Cost per unit # of units sold Cost per unit Cost of goods sold # of units Cost per unit Inventory balance
Jan-01 5500 51 280500
Mar-30 4500 67 5500 51 280500
4500 67 301500
Jul-15 850 70 5500 51 280500
4500 67 301500
850 70 59500
Sep-01 850 70 59500 4250 51 216750
4500 67 301500
1250 51 63750
Totals 6600 424750 4250 216750
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
Determine Trumpana ending inventory and cost of goods sold under the FIFO perpetual basis. Begin by...
Determine Trumpana ending inventory and cost of goods sold under the FIFO perpetual basis. Begin by preparing Trumpana perpetual inventory record under the​ first-in, first-out​ (FIFO) method for the year. Transaction Units Sales in Units Unit Cost Total Cost Beginning inventory 1/1 2,500 $53 $132,500 Purchases March 30 3,000 68 204,000 July 15 850 76 64,600 September 1 3,600 Total available for sale 6,350 $401,100 Units sold September 1 (3,600) Ending inventory 2,750 FIFO: Cost of Cost of Units Unit...
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...
2. Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows:...
2. Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 80 units @ $34 8 Sale 64 units 15 Purchase 89 units @ $36 27 Sale 75 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of goods sold on July 27 and (b) the inventory on July 31. a. Cost of goods sold on July 27 $ b. Inventory on July 31...
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?
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 49 units. (Round your answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 5 $ 2.00 April 10 10 2.50 May 15 12 3.00 July 22 15 3.25 August 19 18 4.00 September 30 20 4.20 November 10 32 4.40 December 15 16 4.80 Costs of ending inventory? Costs of goods sold?
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...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 42 units at $99 10 Sale 33 units 15 Purchase 54 units at $105 20 Sale 31 units 24 Sale 9 units 30 Purchase 33 units at $111 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows:...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 120 units at $39 10 Sale 90 units 15 Purchase 140 units at $40 20 Sale 110 units 24 Sale 45 units 30 Purchase 160 units at $43 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: March...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: March 1 Inventory 84 units @ $22 5 Sale 67 units 11 Purchase 93 units @ $25 21 Sale 78 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on March 21 and (b) the inventory on March 31. a. Cost of merchandise sold on March 21 $ b. Inventory on March 31 $
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item HM46 are as follows: March...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item HM46 are as follows: March 1 Inventory 84 units @ $15 5 Sale 67 units 11 Purchase 93 units @ $17 21 Sale 78 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on March 21 and (b) the inventory on March 31. a. Cost of merchandise sold on March 21 b. Inventory on March 31