Question

In: Accounting

Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. Perpetual...

Determine the costs assigned to ending inventory and to cost of goods sold using FIFO.

Perpetual FIFO:
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
January 1 290 @ $13.60 = $3,944.00
January 10 260 @ $13.60 = $3,536.00 30 @ $13.60 = $408.00
March 14 500 @ $18.60 30 @ $13.60 = $408.00
500 @ $18.60 = 9,300.00
$9,708.00
March 15 60 @ $13.60 = $816.00 0 @ $13.60 =
200 @ $18.60 = 3,720.00 300 @ $18.60 = $5,580.00
$4,536.00 $5,580.00
July 30 490 @ $23.60 0 @ $13.60
300 @ $18.60 = 5,580.00
490 @ $23.60 = 11,564.00
$17,144.00
October 5 0 @ $13.60 = $0.00 0 @ $13.60
190 @ $18.60 = 3,534.00 0 @ $18.60
300 @ $23.60 = 7,080.00 190 @ $23.60 = 4,484.00
$10,614.00 $4,484.00
October 26 190 @ $28.60 0 @ $13.60
0 @ $18.60
190 @ $23.60 = 4,484.00
190 @ $28.60 = 5,434.00
Totals $18,686.00 $9,918.00

+

Choose your template

FPOspreadsheet

FPOgeneral journal

FPO

Hemming Co. reported the following current-year purchases and sales for its only product.
    

Date Activities Units Acquired at Cost Units Sold at Retail
Jan. 1 Beginning inventory 290 units @ $13.60 = $ 3,944
Jan. 10 Sales 260 units @ $43.60
Mar. 14 Purchase 500 units @ $18.60 = 9,300
Mar. 15 Sales 430 units @ $43.60
July 30 Purchase 490 units @ $23.60 = 11,564
Oct. 5 Sales 470 units @ $43.60
Oct. 26 Purchase 190 units @ $28.60 = 5,434
Totals 1,470 units $ 30,242 1,160 units

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.

Solutions

Expert Solution

Solution 1:

Computation of ending inventory and Issue cost under FIFO
Date Beginning Inventory Purchase Cost of goods sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 290 $13.60 $3,944.00 0 $0.00 $0.00 0 $0.00 $0.00 290 $13.60 $3,944.00
10-Jan 290 $13.60 $3,944.00 0 $0.00 $0.00 260 $13.60 $3,536.00 30 $13.60 $408.00
14-Mar 30 $13.60 $408.00 500 $18.60 $9,300.00 0 $0.00 $0.00 30 $13.60 $408.00
500 $18.60 $9,300.00
15-Mar 30 $13.60 $408.00 0 $0.00 $0.00 30 $13.60 $408.00 100 $18.60 $1,860.00
500 $18.60 $9,300.00 400 $18.60 $7,440.00
30-Jul 100 $18.60 $1,860.00 490 $23.60 $11,564.00 0 $0.00 $0.00 100 $18.60 $1,860.00
490 $23.60 $11,564.00
5-Oct 100 $18.60 $1,860.00 0 $0.00 $0.00 100 $18.60 $1,860.00 120 $23.60 $2,832.00
490 $23.60 $11,564.00 370 $23.60 $8,732.00
26-Oct 120 $23.60 $2,832.00 190 $28.60 $5,434.00 0 $0.00 $0.00 120 $23.60 $2,832.00
190 $28.60 $5,434.00
Total 1160 $21,976.00 310 $8,266.00

Solution 2:

Computation of ending inventory and Issue cost under LIFO
Date Beginning Inventory Purchase Cost of goods sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 290 $13.60 $3,944.00 0 $0.00 $0.00 0 $0.00 $0.00 290 $13.60 $3,944.00
10-Jan 290 $13.60 $3,944.00 0 $0.00 $0.00 260 $13.60 $3,536.00 30 $13.60 $408.00
14-Mar 30 $13.60 $408.00 500 $18.60 $9,300.00 0 $0.00 $0.00 30 $13.60 $408.00
500 $18.60 $9,300.00
15-Mar 30 $13.60 $408.00 0 $0.00 $0.00 430 $18.60 $7,998.00 30 $13.60 $408.00
500 $18.60 $9,300.00 70 $18.60 $1,302.00
30-Jul 30 $13.60 $408.00 490 $23.60 $11,564.00 0 $0.00 $0.00 30 $13.60 $408.00
70 $18.60 $1,302.00 70 $18.60 $1,302.00
490 $23.60 $11,564.00
5-Oct 30 $13.60 $408.00 0 $0.00 $0.00 470 $23.60 $11,092.00 30 $13.60 $408.00
70 $18.60 $1,302.00 70 $18.60 $1,302.00
490 $23.60 $11,564.00 20 $23.60 $472.00
26-Oct 30 $13.60 $408.00 190 $28.60 $5,434.00 0 $0.00 $0.00 30 $13.60 $408.00
70 $18.60 $1,302.00 70 $18.60 $1,302.00
20 $23.60 $472.00 20 $23.60 $472.00
190 $28.60 $5,434.00
Total 1160 $22,626.00 310 $7,616.00

Solution 3:

Computation of Gross Profit
Particulars FIFO LIFO
Sales $50,576 $50,576
Cost of goods sold $21,976 $22,626
Gross Profit (Sales - COGS) $28,600 $27,950

Related Solutions

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.
  Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 140 units @ $ 6.00 = $ 840               Jan. 10 Sales                   100 units @ $ 15   Jan. 20 Purchase 60 units @ $ 5.00 =   300              ...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale   15 blank
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO,...
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO, LIFO, and weighted average assuming a perpetual inventory system is in place. Beginning Balance - 90 units at $11 March 3 - Purchase 300 units for $15 April 4 - Sell 240 units for $28 June 30 - Purchase 250 units for $18 August 16 - Sell 180 units for $30
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 36 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 43 $ 7.10 $ 305.30 April 1 38 6.35 241.30 June 1 53 6.10 323.30 September 1 48 6.60 316.80 Total 182 $ 1,186.70 Cost of...
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the...
How can i calculate Cost of goods sold and ending inventory using FIFO, LIFO and the periodic system given the information below? On December 1, 2017, Ivanhoe Company had the account balances shown below. Debits Credits Cash $5,180 Accumulated Depreciation—Equipment $1,460 Accounts Receivable 4,230 Accounts Payable 2,710 Inventory (2,900 x $0.60) 1,740 Common Stock 10,200 Equipment 21,400 Retained Earnings 18,180 $32,550 $32,550 The following transactions occurred during December. Dec. 3 Purchased 3,900 units of inventory on account at a cost...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 38 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 54 $ 7.50 $ 405.00 April 1 49 6.75 330.75 June 1 64 6.50 416.00 September 1 59 7.00 413.00 Total 226 $ 1,564.75. FIFO $...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 33 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 41 $ 7.80 $ 319.80 April 1 36 7.05 253.80 June 1 51 6.80 346.80 September 1 46 7.30 335.80 Total 174 $ 1,256.20 Cost of...
1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 60 $ 52 $ 3,120 Apr. 7 Purchase 140 54 7,560 Jul. 16 Purchase 210 57 11,970 Oct. 6 Purchase 120 58 6,960 530 $ 29,610 For the entire year, the company sells 450 units of inventory for $70 each.   1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT