Smith Corporation | ||||
Date | Item | units | Cost/ unit ($) | |
Jan-01 | Beginning Inventory | 120 | 6 | |
Jan-07 | Purchase | + 200 | 7 | |
Jan-10 | Sale | - 250 | ||
Jan-15 | Purchase | + 300 | 8 | |
Jan-17 | Purchase | + 200 | 9 | |
Jan-20 | Sale | - 325 | ||
Jan-25 | Sale | - 100 | ||
Jan-28 | Purchase | + 175 | 10 | |
Dec-31 | Ending Inventory | 320 | ||
Ending inventory as per FIFO = 145 units @ 9 + 175 units @ 10 | ||||
= 3055 | ||||
Cost of Goods Sold as per FIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-10 | Sale | 120 | 6 | 720 |
130 | 7 | 910 | ||
Jan-20 | Sale | 70 | 7 | 490 |
255 | 8 | 2040 | ||
Jan-25 | Sale | 45 | 8 | 360 |
55 | 9 | 495 | ||
Total | 675 | 5015 | ||
Ending inventory as per LIFO = 120 units @ 6 + 200 units @ 7 | ||||
= 2120 | ||||
Cost of Goods Sold as per LIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-10 | Sale | 250 | 8 | 2000 |
Jan-20 | Sale | 50 | 8 | 400 |
200 | 9 | 1800 | ||
75 | 10 | 750 | ||
Jan-25 | Sale | 100 | 10 | 1000 |
Total | 675 | 5950 | ||
Ronald Corporation | ||||
Date | Item | units | Cost/ unit ($) | |
Jan-01 | Beginning Inventory | 100 | 10 | |
Jan-07 | Sale | -90 | ||
Jan-08 | Purchase | 250 | 15 | |
Jan-10 | Sale | -140 | ||
Jan-13 | Purchase | 400 | 20 | |
Jan-20 | Sale | -300 | ||
Jan-31 | Purchase | 600 | 25 | |
Dec-31 | Ending Inventory | 820 | ||
Ending inventory as per FIFO = 220 units @ 20 + 600 units @ 25 | ||||
= 19400 | ||||
Cost of Goods Sold as per FIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-07 | Sale | 90 | 10 | 900 |
Jan-10 | Sale | 10 | 10 | 100 |
130 | 15 | 1950 | ||
Jan-20 | Sale | 120 | 15 | 1800 |
180 | 20 | 3600 | ||
Total | 530 | 8350 | ||
Ending inventory as per LIFO = 70 units @ 25 + 400 units @ 20 + 250 units @ 15 + 100 units @ 10 | ||||
= 14500 | ||||
Cost of Goods Sold as per LIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-07 | Sale | 90 | 25 | 2250 |
Jan-10 | Sale | 140 | 25 | 3500 |
Jan-20 | Sale | 300 | 25 | 7500 |
Total | 530 | 13250 | ||
Northridge Company | ||||
Date | Item | units | Cost/ unit ($) | |
Jan-01 | Beginning Inventory | 170 | 6 | |
Jan-10 | Sale | -75 | ||
Mar-07 | Purchase | 150 | 7 | |
Mar-15 | Sale | -140 | ||
Jul-28 | Purchase | 350 | 8 | |
Oct-03 | Purchase | 380 | 9 | |
Oct-05 | Sale | -475 | ||
Dec-19 | Purchase | 80 | 10 | |
Dec-31 | Ending Inventory | 440 | ||
Ending inventory as per FIFO = 80 units @ 10 + 360 units @ 9 | ||||
= 4040 | ||||
Cost of Goods Sold as per FIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-10 | Sale | 75 | 6 | 450 |
Mar-15 | Sale | 95 | 6 | 570 |
45 | 7 | 315 | ||
Oct-05 | Sale | 105 | 7 | 735 |
350 | 8 | 2800 | ||
20 | 9 | 180 | ||
Total | 690 | 5050 | ||
Ending inventory as per LIFO = 170 units @ 6 + 150 units @ 7 + 120 units @ 8 | ||||
= 3030 | ||||
Cost of Goods Sold as per LIFO | Units | Cost/ unit ($) | Total cost ($) | |
Jan-10 | Sale | 75 | 10 | 750 |
Mar-15 | Sale | 5 | 10 | 50 |
135 | 9 | 1215 | ||
Oct-05 | Sale | 245 | 9 | 2205 |
230 | 8 | 1840 | ||
Total | 690 | 6060 |
INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan...
Number of Units Unit Cost Date Transaction Jan. 1 Beginning inventory Apr. 7 Purchase Jul.16 Purchase Oct. 6 Purchase Total Cost $ 2,484 6,432 10,404 5,928 $25,248 SOG For the entire year, the company sells 440 units of inventory for $64 each. 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit Cost of Goods Available for Sale LIFO Ending Inventory Cost of Goods Sold Cost per Cost per unit # of units Cost of...
Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 190 units @ $ 7.00 = $ 1,330 Jan. 10 Sales 150 units @ $ 16.00 Jan. 20 Purchase 110 units @ $ 6.00 = 660 Jan. 25 Sales 130 units @ $ 16.00 Jan. 30 Purchase 280 units @ $ 5.50 = 1,540 Totals 580 units $ 3,530 280 units The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 300...
Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 54 Oct. 9 Purchase 128 Oct. 11 Sale 104 Oct. 17 Purchase 108 Oct. 22 Sale 64 Oct. 25 Purchase 75 Oct. 29 Sale 103 Calculate ending inventory, cost of goods sold, gross profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round answers to decimal place, e.g. 125.) LIFO FIFO AVERAGE-COST $ The ending inventory The cost of goods sold $ Gross profit
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 50 units at $122 Mar. 10 Purchase 70 units at $134 Aug. 30 Purchase 10 units at $140 Dec. 12 Purchase 70 units at $142 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...
Inventory Date Activity Units Unit Cost Balance 1-Mar Beginning Balance 250 $14 $3,500 3-Mar Sale (200) - - 0 10-Mar Purchase 200 15 ...
Units Unit Cost or Selling Price Date Description Oct. 1 Beginning inventory Oct. 9 Purchase Oct 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $ 89.753 e Textbook and Media List of Accounts Calculate ending inventory, cost of goods sold, gross profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round answers to...
2 Exercise 5-7 Perpetual: Inventory costing methods-FIFO and LIFO LO P1 art 1 of 2 Required: Hemming uses a perpetual Inventory system. 1. Determine the costs assigned to ending Inventory and to cost of goods sold using FIFO. 2. Determine the costs assigned to ending Inventory and to cost of goods sold using LIFO. 3. Compute the gross margin for FIFO method and LIFO method. ints eBook Complete this questions by entering your answers in the below tabs. Hint Required...
units sold is 290 Date Units Unit Cost Total Cost Beginning Inventory Purchase January 1 January 15 January 24 $ 80 140 $11,200 29,700 27,500 330 90 Purchase 250 110 Required: 1. Calculate the number and cost of goods available for sale. 2. Calculate the number of units in ending inventory. 3. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, Complete this question by entering your answers in the tabs below....
Exercise 6-7 Perpetual: Inventory costing methods-FIFO and LIFO LO P1 Required: Hemming uses a perpetual inventory system. 1. Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. 2. Determine the costs assigned to ending inventory and to cost of goods sold using LIFO. 3. Compute the gross margin for FIFO method and LIFO method. Units Sold at Retail Units Acquired at Cost 245 units @ $11.80 = $ 2,891 190 units @ $41.80...
Hemming Co. reported the following current-year purchases and sales for its only product. Units Acquired at Cost 245 units @ $11.80 - $ 2,891 Units Sold at Retail 190 units @ $41.80 390 units @ $16.80 - 6,552 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Mar.14 Purchase 2.15 Sales ly 30 Purchase Oct. 5 Sales Oct.26 Purchase Totals 350 units @ $41.80 445 units @ $21.80 - 9,701 430 units @ $41.80 145 units @ $26.80 - 1,225...