Question

In: Accounting

Is there a difference in terms of cost of sales when you are using fifo under...

Is there a difference in terms of cost of sales when you are using fifo under perpetual inventory system and using fifo under period inventory system?
if so, could you please give me an example that demostrates such difference?
Thank you!

Solutions

Expert Solution

In perpetual method , we record each and every stock movement as and when they occur and maintain details of inventory , cost of goods sold at all the times. So Inventory and Cost of Sales keeps on changing for every transaction.

Whereas in periodic method , stock movements will be recorded periodical basis on physical verification of stocks and then cost of sales will be calculated by adding purchases to the opening stock value and reducing the inventory value. Inventory value is taken as the value of latest stock purchased.

Lets take the following Example

Stock statement as per perpetuity method
Purchases Sales Inventory
DATE Qty Unit Cost($) Total Cost($) Qty Unit Cost($) Total Cost($) Qty Unit Cost($) Total Cost($)
Jul-02 600 12 7200 600 12 7200
Jul-05 200 13 2600 600 12 7200
200 13 2600
Jul-13 100 12 1200 500 12 6000
200 13 2600
Jul-21 325 14 4550 325 12 3900 175 12 2100
200 13 2600
325 14 4550
Total 14350 5100 9250
Now lets calculate COGS as per periodic method
Units left in Stock 700
so value of inventory @ latest stock receipts 325*14= 4550
200*13= 2600
175*12= 2100
Total 9250
Value of cost of sales = Opening Stock+ Purchases -Inventory = 0 + 14350 -9250 = 5100
So , Ultimate impact and result on cost of sales is same in both the cases but it is recommendatory to use perpetuity method as we can have more details about stock movements

Related Solutions

E5.7 Calculate inventory and cost of sales using FIFO, LIFO and average cost.
E5.7 Calculate inventory and cost of sales using FIFO, LIFO and average cost. Fenning Pty Ltd reports the following for the month of June: Required a. Calculate cost of the ending inventory and the cost of sales under (1) FIFO, (2) LIFO and (3) average cost b. Which costing method gives the highest ending inventory and the highest cost of sales? Why? c. How do the average cost values for ending inventory and cost of sales compare with ending inventory and cost of sales for FIFO and...
1.a.)When using FIFO for inventories, market value generally refers to ________ under U.S. GAAP and ________...
1.a.)When using FIFO for inventories, market value generally refers to ________ under U.S. GAAP and ________ under IFRS. A) current replacement cost; historical cost B) historical cost; net realizable value C) historical cost; current replacement cost D) net realizable value; net realizable value b. Margaret Company reported the following information for the current year: Net sales $3,000,000 Purchases $1,957,000 Beginning Inventory $245,000 Ending Inventory $115,000 Cost of Goods Sold 65% of sales Industry Averages available are: Inventory Turnover 5.29 Gross...
Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO,...
Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO, and LIFO Undew Inc.’s inventory records showed the following data for an item it sells regularly. Date Units Unit Cost Jan 1 Inventory 2,000 $10.00 Jan 3 Purchases 18,000 10.40 Jan 7 Sales (at $26 per unit) 7,000 Jan 20 Purchases 6,000 11.00 Jan 22 Sales (at $27 per unit) 16,000 Jan 30 Purchases 3,000 12.00 a. Assuming that Undew maintains a periodic inventory...
Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs...
Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs Inc, has the following production data for the month of June 20xx. DEPARTMENT I DEPARTMENT II QUANTITY SCHEDULE Units Percentage of completion Units Percentage of completion Work-in process, beginning 15,000 2/3 complete    9,000 1/3 complete Transferred to next department 30,000 ? Work-in process, end    5,000 2/5 complete    8,000 7/8 complete COST ANALYSIS DEPARTMENT I DEPARTMENT II Work-in process, beginning Cost from...
Process Costing using the FIFO Method A process cost system is used when a company produces...
Process Costing using the FIFO Method A process cost system is used when a company produces a product that is homogeneous-that is, individual units are indistinguishable from each other. Costs flow from one production department to the next and materials, labor and overhead are added until the final product is moved to finished goods inventory ready to be sold. The flowchart illustrates the flow of costs into Work in Process and Finished Goods in a process costing system. Cost Flows...
Process Costing using the FIFO Method A process cost system is used when a company produces...
Process Costing using the FIFO Method A process cost system is used when a company produces a product that is homogeneous-that is, individual units are indistinguishable from each other. Costs flow from one production department to the next and materials, labor and overhead are added until the final product is moved to finished goods inventory ready to be sold. The flowchart illustrates the flow of costs into Work in Process and Finished Goods in a process costing system. Cost Flows...
how do you calculate ending inventory or cost of goods sold under LIFO and FIFO    ...
how do you calculate ending inventory or cost of goods sold under LIFO and FIFO     how do you use the Gross Profit Method to estimate a loss of inventory how do you use the relative sales value method of allocating cost to items purchased What are the common disclosures required for inventory?
Explain any difference between the cost per equivalent unit in the Assembly Department under the weighted-average method and the FIFO method.
FIFO method (continuation of 17-30). Do Problem 17-30 using the FIFO method of process costing. Explain any difference between the cost per equivalent unit in the Assembly Department under the weighted-average method and the FIFO method.
1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 60 $ 52 $ 3,120 Apr. 7 Purchase 140 54 7,560 Jul. 16 Purchase 210 57 11,970 Oct. 6 Purchase 120 58 6,960 530 $ 29,610 For the entire year, the company sells 450 units of inventory for $70 each.   1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT