Compute the value of inventory and cost of goods

Assignment Help Accounting Basics
Reference no: EM13728906

Methods of valuation of inventories

First In First Out (FIFO) Method .

Average Cost Method.

Last In Last Out (LIFO) Method .

Base Stock Method

Weighted Average Method.

Specific Identification Method

Standard Cost

Adjusted Selling Price

Latest Purchase Price

Next In First Out (NIFO) Method

Highest In First Out (HIFO) Method

1. FIRST IN FIRST OUT METHOD:
The First In First Out Method is based on the assumptions that the goods which are received first are issued first. This assumption is made for the purpose of the assigning costs and not for the purposes of the physical flow of goods. The physical flow of goods therefore need not necessarily coincide with the pattern of cost flow assumption. The goods sold therefore , consist of the earliest lots and are valued at the price paid for such lots. The ending inventory consists of the latest lots and is valued at the price paid for such lots.

Required: Compute the value of inventory and cost of goods sold as on Jan 5, 2014 by FIFO Method.


Statement Showing the Value of Inventory and Cost of Goods Sold under FIFO Method (using Periodic System)
Solution:
A. Opening Inventory 100
B. Add: Purchase (Rs 600 + Rs1030) 1630
Refer W.N.1
C. Less: Ending Inventory (250*2.06) (515)
Refer W.N.2
D. Cost of Goods Sold (A+B-C) 1215
Working note1
Purchase=400*1.5=600 +500*2.06=1630
Working Note2
Ending Inventory in units=
100+400+500-450-300=250

FIFO Method (using Perpetual System)
A. Opening Inventory 100
B. Add: Purchases (Rs 600 +Rs 1030) 1630
C. Less: Cost of Goods Sold (1215)
(Rs 100+Rs 525+Rs 75+Rs515)
D. Ending Inventory (A+B+C) 515
Stock ledger under FIFO Method
(Using Perpetual System)

C

               Receipts


                         Issued 


                       Balance



Umits

Rate

Amount

Units

Rate

Amount

Units

Rate

Amount

.










01/01/2014







100

1

100

02/01/2014

400

1.5

600




100

1

100








400

1.5

600

03/01/2014




100

1

100








350

1.5

525

50

1.5

75

04/01/2014

500

2.06

1030




50

1.5

75








500

2.06

1030

05/01/2014




50

1.5

75








250

2.06

515

250

2.06

515


LAST IN FIRST OUT METHOD (LIFO)
The Last in First Out Method is based on the assumption that the goods which are purchased last are issued first. Thus LIFO assigns the cost of newer inventory to cost of goods sold and cost of older inventory to ending inventory account.
.

Illustration same as above:

Statement Showing the Value of Inventory and Cost of Goods Sold under LIFO Method (using Periodic System)
Solution:
A. Opening Inventory 100
B. Add: Purchase (Rs 600 + Rs1030) 1630
Refer W.N.3
C. Less: Ending Inventory (100+225) (325)
Refer W.N.4
D. Cost of Goods Sold (A+B-C) 1405

Stock ledger under LIFO Method
(Using Perpetual System)

 

Date     

               Receipts


                         Issued 


                       Balance



Units

Rate

Amount

Units

Rate

Amount

Units

Rate

Amount

.










01/01/2014







100

1

100

02/01/2014

400

1.5

600




100

1

100








400

1.5

600

03/01/2014




400

1.5

600








50

         1.0

50

50

1.0

50

04/01/2014

500

2.06

1030




50

1.0

50








500

2.06

1030

05/01/2014




300

2.06

618

      50

1.0

50








250

2.06

412

LAST IN FIRST OUT METHOD (LIFO)

The Last in First Out Method is based on the assumption that the goods which are purchased last are issued first. Thus LIFO assigns the cost of newer inventory to cost of goods sold and cost of older inventory to ending inventory account. 

Illustration same as above:

Statement Showing the Value of Inventory and Cost of Goods Sold under LIFO Method (using Periodic System)
Solution:
A. Opening Inventory 100
B. Add: Purchase (Rs 600 + Rs1030) 1630
Refer W.N.3
C. Less: Ending Inventory (100+225) (325)
Refer W.N.4
D. Cost of Goods Sold (A+B-C) 1405

Stock ledger under LIFO Method  (Using Perpetual System)

Reference no: EM13728906

Questions Cloud

Pocess of a program development : Summarize the process of a program's development based on the program scenario you have used throughout the course from Appendix B.
Complete a three period moving average forecast : Complete a three period MOVING AVERAGE Forecast for periods 4 through 11. Complete a WEIGHTED MOVING AVERAGE Forecast for periods 4 - 11 using the weights assigned to your data set
What are some good resources : What are some good resources? Once you decide on the business form, how do you go about making the change? What is the process?
Why did the renaissance start in italy : Why did the Renaissance start in Italy? Describe the role of the aristocratic courts of such powerful figures as the de Medicis and the papacy in engendering and sustaining this cultural revival.
Compute the value of inventory and cost of goods : Compute the value of inventory and cost of goods sold as on Jan 5, 2014 by FIFO Method.
How the events caused intense cultural conflicts : Analyze how the events of the period of the 1920s caused intense cultural conflicts. in your response, focus on two of te following: america idenity, prohibition, religion, economics.
Improve their online advertising : You are an e-marketing and e-commerce consultant. Mary and Joe Johnson, the owners of Book Bunker have hired you in the past to help them improve their sales both online and in their store and improve their online advertising and create the ability..
Write an essay on the industrial revolution : The Industrial Revolution not only transformed British industry and society, it called forth a multifaceted reform effort to cope with the societal problems created by industrialization.
Analyze the historical and contemporary causes of the event : Analyze the historical and contemporary causes of the event. Analyze different historical interpretations of the event. Evaluate the positive and negative outcomes of the event.

Reviews

Write a Review

Accounting Basics Questions & Answers

  David greenes muffler shop uses a normal costing system

david greenes muffler shop uses a normal costing system. overhead and labor hours were estimated at 42000 and 6000

  All materials are added at the beginning of the process

the curing department of carmon company reported the following information for the month of novemberunitsconversion

  On january 1 2010 metco inc had issued an outstanding

on january 1 2010 metco inc. had issued an outstanding 574600 shares of 2 par value common stock. on march 15 2010

  What is the book value per share of the common stock at

inkaid co. is incorporated at the beginning of this year and engages in a number of transactions. the following journal

  Assume that x company has decided to switch to an

assume that x company has decided to switch to an activity-based costing allocation system. it has identified three

  If you were the accountant in selecting a method what

discuss the three common methods of estimating bad debt expense using the allowance method.which method do you think is

  Sec accounting and auditing enforcement release aaer no 108

sec accounting and auditing enforcement release aaer no. 108 specifies certain conditions or criteria that a bill and

  On january 1 2013 sweetwater furniture company leased

on january 1 2013 sweetwater furniture company leased office space under a 21-year operating lease agreement. the

  Tiger equipment inc a manufacturer of construction

tiger equipment inc. a manufacturer of construction equipment prepared the following factory overhead cost budget for

  For each of the following scenarios provide an explanation

for each of the following scenarios provide an explanation that focuses on the critical performance factors highlighted

  Several years ago a multilateral treaty came into effect

several years ago a multilateral treaty came into effect among some 45 countries including most of the major developed

  You currently pay 10000 per year in rent to a landlord for

you currently pay 10000 per year in rent to a landlord for a 100000 house which you are considering purchasing. you can

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