Hull Company’s record of transactions concerning part X for the month of April was as follows.

Purchases Sales
April 1 (balance on hand) 100 @ $5.00 April 5 300
4 400 @ 5.10 12 200
11 300 @ 5.30 27 800
18 200 @ 5.35 28 150
26 600 @ 5.60
30 200 @ 5.80

Compute the inventory at April 30 on each of the following bases. Assume that perpetual inventory records are kept in units only.

(1) First-in, first-out (FIFO).
(2) Last-in, first-out (LIFO).
(3) Average-cost.

1. $7720  

2. $7945

3. $7758

Explanation:1. First in First out method which means the first inventory to be purchased by company will be the first to be sold.  

Total cost of Sales   = Total number of units Sold * Total Cost of inventory sold    

                                  = 100units*$5+ 300units*$5.30+ 200units*$5.35 + 450units*$5.60

                                   =$7720

Total units sold=1450  we started from first inventory which was the balance of inventory of 100 units downwards up to the 1450th unit sold that was purchased on the 26th of April by the company.

2. Last in first out method is where the last bought inventory is sold first.

Total cost of sales= Total number of units sold * Total cost of units sold =200units$*5.80+ 600units*$5.60+ 200units*$5.35+300units*$5.30+150units*$5.1

=$7945

Total units sold still 1450 but we calculated the cost from the last purchased unit from 30th April to the 1450th unit sold which was on the 12th of April.

3. Average Cost = (Sum of all costs/Total number of costs)* total units sold

                     = (($5+$5.1+$5.3+$5.35+$5.6+$5.8)/6)* 1450

=$7769.58