Concept explainers
(1)
Periodic Inventory System:
Periodic inventory system is a system, in which the inventory is updated in the accounting records on a periodic basis such as at the end of each month, quarter or year. In other words, it is an accounting method which is used to determine the amount of inventory at the end of each accounting period.
First-in-First-Out:
In First-in-First-Out method, the costs of the initially purchased items are considered as cost of goods sold, for the items which are sold first. The value of the ending inventory consists of the recent purchased items.
Last-in-Last-Out:
In Last-in-First-Out method, the costs of last purchased items are considered as the cost of goods sold, for the items which are sold first. The value of the closing stock consists of the initial purchased items.
Weighted-average cost method:
Under Weighted average cost method, the company calculates a new average cost after every purchase is made. It is determined by dividing the cost of goods available for sale by the units on hand.
To determine: The inventory on June 30, 2016 and cost of merchandise sold using first in first out method under periodic inventory system.
(1)
Explanation of Solution
The value of ending inventory on June 30, 2016 is calculated as follows:
Calculate the cost of merchandise sold is as follows:
Amount ($) | |
Beginning inventory, April 1, 2016 | 30,000 |
Add: Purchases Table (3) | 313,640 |
Merchandise available for sale | 343,640 |
Less: Ending inventory, June 30, 2016 | 32,864 |
Cost of merchandise sold | 310,776 |
Table (1)
Working notes:
Calculate the units in ending inventory as follows:
Units | |
Units in beginning inventory and purchased | 275 |
Less: Units sold | 249 |
Units in ending inventory | 26 |
Table (2)
Calculate the merchandise purchases as follows:
Purchases | |||
Date | Quantity | Unit cost | Total |
08-Apr | 75 | $1,240 | $93,000 |
08-May | 60 | $1,260 | $75,600 |
28-May | 80 | $1,260 | $100,800 |
21-Jun | 35 | $1,264 | $44,240 |
$313,640 |
Table (3)
Hence, the ending inventory on June 30, 2016 under First in First out Method is $32,864 and cost of merchandise sold is $310,776.
(2)
To determine: The value of inventory on June 30, 2016 and cost of merchandise sold using last in first out method under periodic inventory system.
(2)
Explanation of Solution
The value of ending inventory on June 30, 2016 is calculated as follows:
Calculate the cost of merchandise sold is as follows:
Amount ($) | |
Beginning inventory, April 1, 2016 | 30,000 |
Add: Purchases Table (3) | 313,640 |
Merchandise available for sale | 343,640 |
Less: Ending inventory, June 30, 2016 | 31,240 |
Cost of merchandise sold | 312,400 |
Table (4)
Hence, the ending inventory on June 30, 2016 under Last in First out Method is $31,240 and cost of merchandise sold is $312,400.
(3)
The value of inventory on June 30, 2016 and cost of merchandise sold using weighted average method under periodic inventory system.
(3)
Explanation of Solution
The value of ending inventory is calculated by multiplying ending inventory with weighted average cost per unit.
Calculate the cost of merchandise sold is as follows:
Amount ($) | |
Beginning inventory, April 1, 2016 | 30,000 |
Add: Purchases Table (3) | 313,640 |
Merchandise available for sale | 343,640 |
Less: Ending inventory, June 30, 2016 | 32,500 |
Cost of merchandise sold | 311,140 |
Table (5)
Working note:
The weighted average unit cost is calculated as follows:
Hence, the ending inventory on June 30, 2016 under weighted average cost Method is $32,500 and cost of merchandise sold is $311,140.
(4)
To compare: The gross profit and ending inventories on June 30, 2016 of all the three methods.
(4)
Explanation of Solution
The table showing all the three methods of inventory is as follows:
FIFO ($) |
LIFO ($) |
Weighted average ($) | |
Sales | $ 525,250 | $ 525,250 | $ 525,250 |
Less: Cost of merchandise sold | $ 310,776 | $ 312,400 | $ 311,140 |
Gross Profit | $ 214,474 | $ 212,850 | $ 214,110 |
Ending Inventory, June 30, 2016 | $ 32,864 | $ 31,240 | $ 32,500 |
Table (6)
Working notes:
Calculate the total sales for the three-month period:
Sales | |||
Date | Quantity | Unit cost | Total |
11-Apr | 40 | $2,000 | $80,000 |
30-Apr | 30 | $2,000 | $60,000 |
10-May | 50 | $2,000 | $100,000 |
19-May | 20 | $2,000 | $40,000 |
5-Jun | 40 | $2,250 | $90,000 |
16-Jun | 25 | $2,250 | $56,250 |
28-Jun | 44 | $2,250 | $99,000 |
Total | $525,250 |
Table (7)
Want to see more full solutions like this?
Chapter 6 Solutions
FINANCIAL+MAN.ACCT.-WKPPRS.,V.1-W/CODE
- LIFO perpetual inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 6-1B. Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. 3. Determine the ending inventory cost on June 30.arrow_forwardAlternative Inventory Methods Park Companys perpetual inventory records indicate the following transactions in the month of June: Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places and other amounts to the nearest dollar.) 2. Next Level Why are the cost of goods sold and ending inventory amounts different for each of the three methods? What do these amounts tell us about the purchase price of inventory during the year? 3. Next Level Which method produces the most realistic amount for net income? For inventory? Explain your answer. 4. Next Level If Park uses IFRS, which of the previous alternatives would be acceptable and why?arrow_forwardBeginning inventory, purchases, and sales for Item Zebra 9x are as follows: Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on April 27 and (b) the inventory on April 30.arrow_forward
- The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Instructions 1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 3. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the dollar. 4. Compare the gross profit and June 30 inventories using the following column headings:arrow_forwardPERPETUAL: LIFO AND MOVING-AVERAGE Kelley Company began business on January 1, 20-1. Purchases and sales during the month of January follow. REQUIRED Calculate the total amount to be assigned to cost of goods sold for January and the ending inventory on January 31, under each of the following methods: 1. Perpetual LIFO inventory method. 2. Perpetual moving-average inventory method.arrow_forwardBeginning inventory, purchases, and sales for Item Foxtrot are as follows: Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on March 27 and (b) the inventory on March 31.arrow_forward
- Inventory by three cost flow methods Details regarding the inventory of appliances on January 1, 20Y7, purchases invoices during the year, and the inventory count on December 31. 2O’7. of Amsterdam Appliances are summarized as follows: Instructions Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.arrow_forwardBeginning inventory, purchases, and sales for Item ProX2 are as follows: Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on January 25 and (b) the inventory on January 31.arrow_forwardBeginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the October 22 purchase, (b) the cost of goods sold on October 29, and (c) the inventory on October 31.arrow_forward
- Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the October 22 purchase, (b) the cost of the merchandise sold on October 29, and (c) the inventory on October 31.arrow_forwardCalculate the cost of goods sold dollar value for A66 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning