Saturday, 12 March 2016

During 2015, TRC Corporation has the following inventory transactions.

Exercise 6-4 Calculate inventory amounts when costs are rising (LO3)
[The following information applies to the questions displayed below.]


During 2015, TRC Corporation has the following inventory transactions.


  Date Transaction Number
of Units
  Unit
  Cost
Total Cost
  Jan. 1       Beginning inventory 48      $ 40       $ 1,920    
  Apr. 7       Purchase 128      42         5,376    
  Jul. 16       Purchase 198      45         8,910    
  Oct. 6       Purchase 108      46         4,968    
   
 

    482        $ 21,174    
   

 






For the entire year, the company sells 427 units of inventory for $58 each.
Required:
1.
Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

 save image
Explanation:
1.
 Date Transaction Number
of Units
Unit
Cost
Ending Inventory
Oct. 6 Purchase 55 $ 46        $ 2,530
   

 


  Date Transaction Number
of Units
Unit
Cost
Cost of
Goods Sold
  Jan. 1      Beginning inventory 48     $ 40         $ 1,920    
  Apr. 7      Purchase 128     42           5,376    
  Jul. 16      Purchase 198     45           8,910    
  Oct. 6      Purchase 53     46           2,438    
   
 

    427*       $ 18,644    
   

 





*First 427 units purchased are assumed sold

Sales revenue = 427 units × $58 = $24,766

Gross profit = Sales revenue − Cost of goods sold
  = $24,766 − $18,644 = $6,122

Exercise 6-4 Part 2
2.
Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
 save image
Explanation:
2.
  Date Transaction Number
of Units
Unit
Cost
Ending Inventory
Jan. 1     Beginning Inventory 48 $ 40       $ 1,920     
Apr. 07   7 $42       $294     
   
 
    55   $ 2,214     
   

 




  Date Transaction Number
of Units
Unit
Cost
Cost of Goods Sold
  Apr. 7 Purchase 121 $ 42        $   5,082     
  Jul. 16 Purchase 198 45        8,910     
  Oct. 6 Purchase 108 46        4,968     
   
 
     427*   $ 18,960     
   

 



* Last 427 units purchased are assumed sold


Sales revenue = 427 units × $58 = $24,766


Gross profit = Sales revenue – Cost of goods sold
  = $24,766 ? $18,960 = $5,806

Exercise 6-4 Part 3
3.
Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round your average cost per unit to 4 decimal places.)
 save image

Explanation:
3.
  Date Transaction Number
of Units
Unit
Cost
Total Cost
  Jan. 1       Beginning inventory 48       $ 40         $ 1,920   
  Apr. 7       Purchase 128       42            5,376   
  Jul. 16       Purchase 198       45           8,910   
  Oct. 6       Purchase 108       46           4,968   
   
 

    482         $ 21,174   
   

 




   
Weighted-average cost = $21,174/482 units = $43.9295 (rounded to 4 decimal places).
    
Ending inventory = 55 units × $43.9295 = $2,416
    
Cost of goods sold = 427 units × $43.9295 = $18,758 ($1 rounding error)
    
Sales revenue = 427 units × $58 = $24,766
    
Gross profit = Sales revenue − Cost of goods sold
  = $24,766 − $18,758 = $6,008

No comments:

Post a Comment