Accounting!

0 comments

 

APPLY THE CONCEPTS: LIFO inventory calculation

Click here to review an illustrated example of the LIFO calculation. The steps illustrated in the example are recapped below.

1. Start with beginning inventory.
2. Add inventory layers as purchases are made.
3. Compute the cost of merchandise sold as sales occur. Use only the cost of merchandise available for sale as of the sales date.
4. Update the inventory balance after each transaction. (Be sure you do not use an amount more than once.)
5. Determine the ending inventory for the period.

Below is the data for the month of January, 2011.

1/1 Beg. Inv. 150 Units @ $10
1/8 Purchase 120 Units @ $12
1/14 Sale 84 Units
1/22 Purchase 100 Units @ $8
1/25 Sale 124 Units

Compute the LIFO layers amounts for the cost of merchandise available for sale after each purchase and sale.

After 1/8 Purchase

Layer 1 [removed] units   $[removed] price per unit   $[removed] value of the layer
Layer 2 [removed] units   $[removed] price per unit   $[removed] value of the layer

After 1/14 Sale

Layer 1 [removed] units   $[removed] price per unit   $[removed] value of the layer
Layer 2 [removed] units   $[removed] price per unit    $[removed] value of the layer

After 1/22 Purchase

Layer 1 [removed] units   $[removed] price per unit   $[removed] value of the layer
Layer 2 [removed] units   $[removed] price per unit   $[removed] value of the layer
Layer 3 [removed] units   $[removed] price per unit   $[removed] value of the layer

After 1/25 Sale

Layer 1 [removed] units   $[removed] price per unit   $[removed] value of the layer
Layer 2 [removed] units   $[removed] price per unit   $[removed] value of the layer

 

Based on your answers above, complete the worksheet below.

LIFO Inventory Worksheet
Transaction Purchases   Cost of Merchandise Sold Inventory balance
1/1 Beg. Inv. 150 Units @ $10       $1,500
1/8 Purchase 120 Units @ $12 $ [removed]     $ [removed]
           
           
1/14 Sale 84 Units     $ [removed] $ [removed]
1/22 Purchase 100 Units @ $8 $ [removed]     $ [removed]
1/25 Sale 124 Units     $ [removed] $ [removed]
Total   $ [removed]   $ [removed] $ [removed]

  Hide    

APPLY THE CONCEPTS: Recording changes in inventory under LIFO valuation

Under the perpetual system, two journal entries are are required to record sales; one to record the sale and one to record the cost of merchandise sold. Click on the links below to review the journal entries for purchases and sales transactions.

Purchase Sales

After a purchase or sale occurs, the transaction must be recorded or journalized. In the following journal, record the purchases and sales for the month, assuming that all inventory purchases were made with cash and all sales were made on account at a fixed unit price of $22 per unit. Several facts to remember: (1) All inventory purchases are made with cash and cash only; (2) All sales are made on account and on account only; and (3) when recording sales, Schiphol wants you to record the revenue portion of the transaction first.

If an amount box does not require an entry leave it blank.

Not sure about the account title? Click here to view the chart of accounts.
+ Assets
+ Liabilities
+ Equity
+ Revenues/Gains
+ Expenses/Losses
GENERAL JOURNAL
page
 
 
             DATE         DESCRIPTION  DOC. 
NO.
 POST. 
REF.
 DEBIT   CREDIT      
1
[removed]
Jan. 08
[removed]
 
 
[removed]
                 
  1
2
[removed]
          
[removed]
 
 
 
[removed]
                 
2
3
[removed]
          
 
 
 
    3
4
[removed]
Jan. 14 Record sale
[removed]
 
 
[removed]
                 
  4
5
[removed]
          
[removed]
 
 
 
[removed]
                 
5
6
[removed]
          
 
 
 
    6
7
[removed]
Jan. 14 Record cost
[removed]
 
 
[removed]
                 
  7
8
[removed]
          
[removed]
 
 
 
[removed]
                 
8
9
[removed]
          
 
 
 
    9
10
[removed]
Jan. 22
[removed]
 
 
[removed]
                 
                 
10
11
[removed]
          
[removed]
 
 
 
[removed]
                 
11
12
[removed]
          
 
 
 
    12
13
[removed]
Jan. 25 Record sale
[removed]
 
 
[removed]
                 
  13
14
[removed]
          
[removed]
 
 
 
[removed]
                 
14
15
[removed]
          
 
 
 
    15
16
[removed]
Jan. 25 Record cost
[removed]
 
 
[removed]
                 
  16
17
[removed]
          
[removed]
 
 
 
[removed]
                 
17
18
[removed]
          
 
 
 
    18
               

 

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}