Inventory valuation, Accounting Basics

The Kauai Surf Company sells high-end surfboards to tourists.  The inventory is purchased from a manufacturer in Honolulu.                                                                                                           

At the beginning of 2010, the company had 20 surfboards on hand which they had purchased at a cost of $50 each.  During 2010, they purchased an additional          40 surfboards at a cost of $60 each on June 12 and another 70 surfboards at a cost of $80 each.  At the end of the year, there were 30 unsold urfboards in ending inventory.  The company uses the periodic method of inventory.                                                                                   

For each of the following inventory valuation methods, determine (a) the ending            inventory value and (b) the cost of goods sold:                                                                                        

a) FIFO                                                                 

b) LIFO                                                                 

c) Weighted Average Cost                                                                          

                                                                Amount in $                      

Answers:                             Units (a)               cost price per unit (b)     Total cost (a*b)                

                Opening inventory          20           50           1000                      

                Purchased           40           60           2400                      

                Purchased           70           80           5600                      

                Total      130                         9000                      

                Less: Closing stock           30                                                          

                Sales      100                                                        

a)            Under FIFO                                                                        

 

                Computation of Cost of goods sold and closing inventory:                                            

                                                                Amount in $                      

                                Units (a)               cost price per unit (b)     Total cost (a*b)                

                Cost of goods sold           20           50           1000                      

                                40           60           2400                      

                                40           80           3200                      

                                                                6600                      

 

                Closing inventory             30           80           2400      

b)            Under LIFO                                                                        

 

                Computation of Cost of goods sold and closing inventory:                                            

                                                                Amount in $                      

                                Units (a)               cost price per unit (b)     Total cost (a*b)                

                Cost of goods sold           70           80           5600                      

                                30           60           1800      

                                                                7400      

                Closing inventory             10           60           600                        

                                20           50           1000                      

                                                                1600                      

c)            Under Weighted average method          

                Computation of Cost of goods sold and closing inventory:                                            

                                                                Amount in $                      

                                Units (a)               cost price per unit (b)     Total cost (a*b)                

                Opening inventory          20           50           1000                      

                Purchased           40           60           2400                      

                Purchased           70           80           5600                      

                Total      130                         9000                      

                Therefore weighted average cost per unit =9000/130                                    

                                                                         69.23                                           

                Cost of goods sold           =69.23*100                            6,923.08                                          

                Closing inventory             =69.23*30                              2,076.92           

Posted Date: 7/12/2012 3:07:19 AM | Location : United States







Related Discussions:- Inventory valuation, Assignment Help, Ask Question on Inventory valuation, Get Answer, Expert's Help, Inventory valuation Discussions

Write discussion on Inventory valuation
Your posts are moderated
Related Questions
After the accounts are adjusted and closed at the end of the fiscal year, Accounts Receivable has a balance of $673,400, and Allowance for Doubtful Accounts has a balance of $11,90

Q. Show payment of a liability? Accountants are able to easily measure some changes in assets and liabilities such as the acquisition of an asset on credit and the payment of a

#quthe books of deven verma could not be tallied.the accountant transferred the difference of Rs.1270 in the suspense account on the debit side the following mistakes were found la

what is meaning by parallel accounts

Cash Flow Statement Vs Funds Flow Statement:   together the Cash Flow Statement and Funds Flow Statement give approximately comparable picture of the firm. They don't be different

The Dividends account increases (debited) as well as an asset cash decreases (credited) by USD 3000. Transaction 15 brings to a close the analysis of the Micro Train Company transa

The open items of an account can only be cleared once you post an identical offsetting amount to the account. In other words, the balance of the items assigned to every other must

A high school counselor needs to show whether the teenage pregnancy rate at her school is disimilar from the rate nationwide. She knows that the rate nationwide is 15 %. She random

An accounting perspective Business insight Accounting is essential for all three types of business organizations and every company must follow generally accepted accounting pri

Corporations frequently invest in securities issued by other corporations. Some investments are acquired to secure a favorable business relationship with another company. On the ot