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

Q. Describe about Borrowed money? The company lent USD 6000 from Chaney's father. Chaney signs the note for the company. The note turn off no interest and the company promised

Windsor Company will receive $100,000 in 7 years. If the appropriate interest rate is 10%, the present value of the $100,000 receipt is ? Answer: PV = FV (PVIF) = $100,000 x 0.5132

Q. Explain FOB shipping point freight collect? FOB shipping point freight collect - Buyer both initially pays and incurs the freight chargers. The proper party (buyer) paid the

If partners do not draw up a partnership agreement, the provisions of the Partnership Act apply on which statement is true like a provision of the Partnership Act? A Interest on

1. Fill in the table below.  Assume TC stands for Total Cost, TFC as Total Fixed Cost, TVC as Total Variable Cost, ATC as Average Total Cost, AFC as Average Fixed Cost, AVC as Aver

An example of a committed fixed cost would be: a) taxes on real estate b) management development programs c) public relations d) advertising programs

The career paths outlined above don't nearly cover all of the many professional options available to tax specialists. For instance are you concerned that a traditional tax accounti

Q. Example of accumulated depreciation account? The accumulated depreciation account doesn't represent cash that is being set aside to change the worn out asset. The un-depreci

A bond sinking fund investment is started on January 5, 2010, by transferring $10,000 in cash to the fund. This $10,000 is invested and earns $1,100 during 2010. The entry to rec