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

Limitations of ratio analysis, Limitations of Ratio Analysis :  In spit...

Limitations of Ratio Analysis :  In spite of the a variety of uses of ratio analysis, it go through from certain limitations, some of which are as under; 1.    Limited use

Find out debt to equity ratio, Current Assets are $70,000, non-current asse...

Current Assets are $70,000, non-current assets are $150,000, current liabilities are $40,000 and long term liabilties are $30,000. What is the debt to equity ratio? 0.47 Stock h

A firm is evaluating two machines, A firm is evaluating two machines. The f...

A firm is evaluating two machines. The first costs $250,000 and will require annual maintenance of $30,000 per year for 10 years. At the end of 10 years, the salvage value will b

Explain double-entry procedure, Q. Explain double-entry procedure? The ...

Q. Explain double-entry procedure? The double-entry procedure maintains the accounting equation in balance. The dual recording process generates two sets of accounts those with

Calculate current ratio, Compute each of the following amounts Company repo...

Compute each of the following amounts Company reported current assets of $80,000, non-current assets of $350,000, current liabilites of $32,000 and long term liabilities of $120,00

Describe how the quickzoom feature of quickbooks, Describe how the QuickZoo...

Describe how the QuickZoom feature of QuickBooks does or does not provide the same help in the statement of cash flows as it does in the income statement.

Show accounting deception situations, Q. Show accounting deception situatio...

Q. Show accounting deception situations? In 2002 The Sarbanes-Oxley Act was approved. The Act was approved as one result of the large losses to the employees and investors from

Hello, Hello, I'm having trouble understanding Direct Cost, Overhead Cost a...

Hello, I'm having trouble understanding Direct Cost, Overhead Cost and Indirect Cost. ***Also Period cost and Product cost. please can anyone explain it and give examples for eac

Show double-entry procedure or duality, Q. Show double-entry procedure or d...

Q. Show double-entry procedure or duality? In every business transaction we record the total dollar amount of debits must equal the total dollar amount of credits. While we deb

Explain about perpetual inventory procedure, Q. Explain about perpetual inv...

Q. Explain about perpetual inventory procedure? When discussing inventory we require clarifying whether we are referring to the physical goods on hand or the Merchandise Invent

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