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

Internal audit, Accounting is a significant service activity in business an...

Accounting is a significant service activity in business and is concerned along with collecting, evaluating, communicating and recording the results of past events. The history of

Submitted assignment, I submitted an assignment this morning and have heard...

I submitted an assignment this morning and have heard nothing back

What is time orientation - financial accounting, What is Time orientation ...

What is Time orientation Financial accounting reports reflect position and performance of business for the past period. Essentially, they are backward looking. Management accou

Sap memory and abap memory, Difference between SAP MEMORY and ABAP MEMORY? ...

Difference between SAP MEMORY and ABAP MEMORY?  Ans) SAP Memory: Global, user-related memory that enlarges beyond transaction limits. Access to the SAP memory is through SPA/GPA

What do you mean by supplies on hand, Q. What do you mean by Supplies on ha...

Q. What do you mean by Supplies on hand? Supplies on hand approximately each business uses supplies in its operations. It may classify supplies merely as supplies to include al

The magnitude of operating leverage for perkins corporation, The magnitude ...

The magnitude of operating leverage for Perkins Corporation is 3.4 when sales are $100,000, if sales increase to $110,000, profits would be expected to increase by what percent?

Interpret the coefficients , A Use the CPS data to calculate mean log(wage)...

A Use the CPS data to calculate mean log(wage) for women and men. log(wage) is coded as the variable LNWAGE and the variable FE is coded 1 for female and 0 for male.) First use the

What is the change fund, What is the change fund Business that have man...

What is the change fund Business that have many cash transactions generally establish this fund, which is an amount of money which is placed in the cash register drawer and is

Illustrating the recording of sales returns, Q. Illustrating the recording ...

Q. Illustrating the recording of sales returns? Following are two instances illustrating the recording of sales returns in the Sales Returns and Allowances account - Suppose

Abc company uses cash basis accounting for its records., ABC Company uses c...

ABC Company uses cash basis accounting for its records. During 2010, ABC collected $400,000 from its customers, made payments of $300,000 to its suppliers for inventory, and paid

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