Inventory valuation, Accounting Basics

Assignment Help:

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           


Related Discussions:- Inventory valuation

Prepare a trial balance, Case Study : Briana Hope has had a long-standin...

Case Study : Briana Hope has had a long-standing love affair with technology and an appetite for apps. She believes that business owners that are not taking advantage of apps to

How to create account for barter transactions?, How to create account for b...

How to create account for barter transactions? As My Company is providing a service to another company and that company is reimbursing us with his service.

Show transactions affecting the income statement, Q. Show Transactions affe...

Q. Show Transactions affecting the income statement? To continue to exist a business must be profitable. This signifies that the revenues earned by providing goods and services

Materiality concept, Materiality Concept: There are several events in ...

Materiality Concept: There are several events in business that are trivial or insignificant in nature. The cost of reporting and recording such events will not be justified th

Explain about predictive value and feedback value, Q. Explain about Predict...

Q. Explain about Predictive value and feedback value? Several suggest using a different valuation basis such as current cost in reporting such assets. Predictive value and feed

Explain horizontal analysis and using the financial results, Q. Explain hor...

Q. Explain horizontal analyses and using the financial results? The computation of dollar and or percentage changes from one year to the next in an item on financial statements

General principles of accounting, Q. General principles of accounting? ...

Q. General principles of accounting? Organizations that have contributed towards the development of the principles are the 1)American Institute of Certified Public Accountants

Provision for taxation and proposed dividend in fund flow, Treatment of Pro...

Treatment of Provision for Taxation and Proposed Dividend: As preparing the Funds Flow Analysis, the treatment of condition for Taxation and planned Dividend is very significa

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd