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: value of inventory using first in first out method under periodic inventory system.
(1)
Explanation of Solution
The tabular column showing inventory cost is presented as follows:
Model | Quantity ($) | Unit cost ($) | Total cost ($) |
C55 | 3 | 1,070 | 3,210 |
1 | 1,060 | 1,060 | |
D11 | 6 | 675 | 4,050 |
5 | 666 | 3,330 | |
F32 | 1 | 280 | 280 |
1 | 260 | 260 | |
H29 | 4 | 317 | 1,268 |
K47 | 6 | 542 | 3,252 |
2 | 549 | 1,098 | |
S33 | 2 | 232 | 464 |
X74 | 7 | 39 | 273 |
Total | 18,545 |
Hence, the ending inventory under First in First out Method is $18,545.
(2)
value of inventory using last in first out method under periodic inventory system.
(2)
Explanation of Solution
The tabular column showing inventory cost is presented as follows:
Model | Quantity ($) | Unit cost ($) | Total cost ($) |
C55 | 3 | 1,040 | 3,210 |
1 | 1,054 | 1,054 | |
D11 | 9 | 639 | 5,751 |
2 | 645 | 1,290 | |
F32 | 2 | 240 | 480 |
H29 | 4 | 305 | 1,220 |
K47 | 6 | 520 | 3,120 |
2 | 531 | 1,062 | |
S33 | 2 | 222 | 444 |
X74 | 4 | 35 | 140 |
3 | 36 | 108 | |
Total | 17,789 |
Hence, the ending inventory under Last in First out Method is $17,789.
(3)
value of inventory using weighted average method under periodic inventory system.
(3)
Answer to Problem 6.5BPR
The tabular column showing inventory cost is presented as follows:
Model | Quantity ($) | Unit cost ($) | Total cost ($) |
C55 | 4 | 1,056 (1) | 4,224 |
D11 | 11 | 654 (2) | 7,194 |
F32 | 2 | 252 (3) | 504 |
H29 | 4 | 311 (4) | 1,244 |
K47 | 8 | 534 (5) | 4,272 |
S33 | 2 | 227 (6) | 454 |
X74 | 7 | 37 (7) | 259 |
18,151 |
Explanation of Solution
Working notes:
Computation of unit cost for Model C55:
Computation of unit cost for Model D11:
Computation of unit cost for Model F32:
Computation of unit cost for Model H29:
Computation of unit cost for Model K47:
Computation of unit cost for Model S33:
Computation of unit cost for Model X74:
Hence, the ending inventory under weighted average cost Method is $18,151.
4
(a)
To discuss: the method that would be preferred for income tax purposes in the period of rising prices.
4
(a)
Explanation of Solution
Solution:
During the period of rising prices, the last in first out method will result in lower cost of inventory, the cost of merchandise sold will be higher, and net income would be lower than other two methods. Therefore, the LIFO method would be preferred for the current year because it would effect in lower income tax.
Want to see more full solutions like this?
Chapter 6 Solutions
Financial & Managerial Accounting, Loose-Leaf Version
- 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 Determine the Cost of the inventory on December 31, 20Y7, by the last-in. first-out method, following the procedures indicated in (1).arrow_forwardInventory 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 Determine the cost of the inventory on December 31, 20Y7, h the average cost method, using the columnar headings indicated in (1).arrow_forwardLIFO 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_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. 20Y7. of Amsterdam Appliances are summarized as follows: Instructions Determine the cost of the inventory on December 31, 2O7, by the first-in, first-out method. Present data in columnar form. using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase.arrow_forwardFIFO perpetual inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. 2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. 3. Determine the gross profit from sales for the period. 4. Determine the ending inventory cost on June 30. 5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?arrow_forwardADJUSTMENT FOR MERCHANDISE INVENTORY USING T ACCOUNTS: PERIODIC INVENTORY SYSTEM Matt Henry owns a business called Henrys Sporting Goods. His beginning inventory as of January 1, 20--, was 45,000, and his ending inventory as of December 31, 20--, was 57,000. Set up T accounts for Merchandise Inventory and Income Summary and perform the year-end adjustment for Merchandise Inventory.arrow_forward
- Beginning 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_forwardPerpetual inventory using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 90 units at 54 8 Sale 75 units 15 Purchase 125 units at 60 27 Sale 80 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (A) the cost of goods sold on July 27 and (B) the inventory on July 31.arrow_forwardJessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December. RE7-11 Using the information from RE7-10, calculate Jessie Storess inventory on December 31 and its cost of goods sold for December using the LIFO method.arrow_forward
- Beginning 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_forwardJessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December.arrow_forwardInventory Costing Methods Crandall Distributors uses a perpetual inventory system and has the following data available for inventory, purchases, and sales for a recent year. Required: 1. Compute the cost of ending inventory and the cost of goods sold using the specific identification method. Assume the ending inventory is made up of 40 units from beginning inventory, 30 units from Purchase 1, 80 units from Purchase 2, and 40 units from Purchase 3. 2. Compute the cost of ending inventory and cost of goods sold using the FIFO inventory costing method. 3. Compute the cost of ending inventory and cost of goods sold using the LIFO inventory costing method. 4. Compute the cost of ending inventory and cost of goods sold using the average cost inventory costing method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 5. CONCEPTUAL CONNECTION Compare the ending inventory and cost of goods sold computed under all four methods. What can you conclude about the effects of the inventory costing methods on the balance sheet and the income statement?arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage LearningCorporate Financial AccountingAccountingISBN:9781305653535Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning