Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / The beginning inventory at Dunne Co

The beginning inventory at Dunne Co

Accounting

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows:

Date TransactionNumber

of UnitsPer UnitTotalApr. 3Inventory90$ 375$ 33,7508Purchase18045081,00011Sale1211,250151,25030Sale761,25095,000May 8Purchase15050075,00010Sale901,250112,50019Sale451,25056,25028Purchase15055082,500June 5Sale901,315118,35016Sale1201,315157,80021Purchase270600162,00028Sale1351,315177,525

Required:

1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4 , using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

 

2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.

 

3.Determine the ending inventory cost on June 30.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Ans.1 DUNNE CO.
  Schedule of Cost Of Merchandise Sold
  LIFO Method
  For the Three Months Ended June 30
    Purchase Cost of Goods Sold Balance
  Date Quantity Unit cost Total cost Quantity Unit cost Total cost Quantity Unit cost Total cost
  03-Apr 90 375 33750       90 375 33750
                     
  08-Apr 180 450 81000       90 375 33750
                180 450 81000
                     
  11-Apr       121 450 54450 90 375 33750
                59 450 26550
                     
  30-Apr       59 450 26550      
          17 375 6375 73 375 27375
                     
  08-May 150 500 75000       73 375 27375
                150 500 75000
                     
  10-May       90 500 45000 73 375 27375
                60 500 30000
                     
  19-May       45 500 22500 73 375 27375
                15 500 7500
                     
  28-May 150 550 82500       73 375 27375
                15 500 7500
                150 550 82500
                     
  05-Jun       90 550 49500 73 375 27375
                15 500 7500
                60 550 33000
                     
  16-Jun       60 550 33000      
          15 500 7500      
          45 375 16875 28 375 10500
                     
  21-Jun 270 600 162000       28 375 10500
                270 600 162000
                     
  28-Jun       135 600 81000 28 375 10500
                135 600 81000
                     
  Total       677   342750 163   91500
                     
  In Perpetual inventory method of LIFO, the units that purchase last are sold first one.        
                     
Ans.2 Total Sales   868675              
  Less: Cost of Goods Sold 342750              
  Gross Profit   525925              
                     
  *Calculation of Total Sales:                
                     
  Date Units Rate Total sales            
  11-Apr 121 1250 151250            
  30-Apr 76 1250 95000            
  10-May 90 1250 112500            
  19-May 45 1250 56250            
  05-Jun 90 1315 118350            
  16-Jun 120 1315 157800            
  28-Jun 135 1315 177525            
  Total     868675            
                     
Ans.3 Cost of Ending Inventory    =    $91,500