Under the First in first out (FIFO) method of inventory valuation, Cost of goods sold consists of the units from beginning inventory and earliest purchases. Ending inventory consists of the units from recent purchases.
Cost of goods sold = $1,200 + $2,040 + $1,050 ($2,100/140*70)
= $4,290
Gross margin = Sales - Cost of goods sold
= [(430 - 70) * $27] - $4,290
= $5,430
---------------------------------------------------------------------------
Under the Last in first out (LIFO) method of inventory valuation, Cost of goods sold consists of the units from recent purchases. Ending inventory consists of the units from beginning inventory and earliest purchases.
Cost of goods sold = $2,100 + $2,040 + $500 ($1,200 / 120 * 50)
= $4,640
Gross margin = Sales - Cost of goods sold
= [(430 - 70) * $27] - $4,640
= $5,080
---------------------------------------------------------------------------
Under the Weighted average method of inventory valuation both Cost of goods sold and Ending inventory are valued at average unit cost.
Weighted average cost per unit = Cost of units available for sale / Number of units available for sale
= $5,340 / 430
= $12.42
Gross margin = Sales - Cost of goods sold
= [(430 - 70) * $27] - [(430 - 70) * $12.42]
= $5,249 (rounded to 0 decimal places)
| Gross Margin | ||
| A. | First-in, First-out (FIFO) | $5,430 |
| B. | Last-in, First-out (LIFO) | $5,080 |
| C. | Weighted Average (AVG) | $5,249 |
Catulston Akira Company had the following transactions for the month. 120 Number Total of Units Cost...
The following units of an item were available for sale during the year Jan 1. Inventory 30 units @ $130 Mar 10. Purchase 70 units @ $140 Aug. 15. Purchased 10 units @ $145 Dec 10. Purchased 70 units @$150 There are 80 units of the item remaining in the physical inventory on December 31st. The periodic inventory system was used. Determine the inventory cost and cost of merchandise sold using the three main methods Inventory Method Merchandise Inventory Cost...
Help Save & Check Units Acquired at Cost 120 units $51.40 per unit 235 units @ $56.40 per unit Units Sold at Retail Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals 280 units $86.40 per unit 95 units @ $61.40 per unit 170 units @ $63.40 per unit 620 units 150 units @ $96.40 per unit 430 units 4. Compute gross profit earned by the company...
fifo method using the chart ?
Exercise 5-7 Perpetual Inventory costing methods FIFO and LIFO Pue Henning Co reported the following current year p hases and sales for its only product Units Sold at Retail 150 units Date Activities Units Acquired at Coat In Beginning inventory200 units SIOS 2.000 la 10 Sales Mar 1 Purchase 350 un 515 5.250 Mar is Sales July 0 Pundide 150 unts $20 = 9.000 Oct Oct 26 Purchase um $25 .900 1.100 $18.750 300...
p les and sales for saly product. Units Acquired at Cost SIO = 52.000 Units Soldat Retail y 190510 330 ml $15- 5.250 Date Activities Tan Bening m Ton 10 Sales Mar 14 Purchase Mar. 13 Sales July 30 Purchase Oct Sales Oct 26 Purchase Tetails 300 S40 150 un 50 000 430 units 540 100 mit 1.100 units 535 2.500 $18,750 RB Required He FIR r ses appellimestory system. Deine the costs a nd to ending iwwentory and to...
The transactions below are for Product A occurred during March: Date Product A Units Cost($) Mar. 2 Purchase 1 $ 68 Mar. 14 1 73 Mar. 28 1 75 Mar. 30 Sale ܢܙ 118 A. The company uses the periodic method for accounting for inventory. Calculate the following (a) through (f): Cost of Ending Gross Profit Inventory FIFO (a) (b) LIFO (c) (d) WTD AVG (e) (f) B. Which method gives the highest income? C. Which method saves the most...
Questions:
1. Ending Inventory?
2. Total cost available for sale?
3. Total number of units available for sale?
4. Ending inventory if the company uses LIFO?
5. Gross profit if the company uses FIFO?
6. Cost of goods sold if the company uses average cost?
7. Ending inventory if the company uses average cost?
8. gross profit if the company uses average cost?
Aurora Co. has beginning inventory of 15,000 units at a cost of $34,000. Total sales of 225,000...
Required information Use the following information for the Exercises below [The following information applies to the questions displayed below. Hemming Co. reported the following current-year purchases and sales for its only product. Activities Units Acquired at Cost Date Jan. 1 Beginning inventory Jan. 10 Sales Mar.14 Purchase Mar. 15 Sales July30 Purchase Oct. 5 Sales Oct. 26 Purchase 290 units $13.60 3,944 500 units $18.609,300 490 units $23.60 11,564 190 units $28.605,434 Units Sold at Retail 260 units $43.60 430...
INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan 7 Sale Jan 10 250 Purchase $8 Jan 15 300 Jan 17 Purchase $9 200 Sale 325 Jan 20 Sale Jan 25 100 Jan 28 Purchase $10 175 Smith Corporation uses a perpetual inventory system. Determine the costs assigned to Cost of Goods Sold and Ending Inventory using both FIFO and LIFO methods. DATE ITEM RED16 UNITS COST Beginning Inventory $10 Jan 1 100...
beginning inventory and purchases Sales Date Units Unit Cost Total Date Units Beg. Inv. 6250 3 18750 15-Mar 5000 3.12 15600 3-Feb 5250 10-May 8750 3.3 28875 4-May 4250 12-Aug 6250 3.48 21750 16-Sep 8000 20-Nov 3750 3.72 13950 9-Oct 7250 TOTAL 30000 TOTAL 25000 Beg. Inv 6250 Purchses 23750 (total - beg. Inv) Goods Ava. 30000 Sales 25000 Ending inv. 5000 (purchase-sales) Ending inv. Under specific identification Didn't provide sale so omit this part Ending inv. Under FIFO Sales...
Waterway Company uses a periodic system reports the following for the month of June. Unit Cost $7 8 June 1 12 23 30 Units 300 300 420 310 110 Inventory Purchase Purchase Inventory Total Cost $ 2,100 3,360 2,790 (a) Compute the cost of the ending inventory and the cost of goods sold under FIFO and LIFO. FIFO LIFO Cost of the ending inventory Cost of goods sold