![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
![**Perpetual Inventory Using FIFO**
*Beginning inventory, purchases, and sales data for portable game players are as follows:*
- **Apr. 1**
- Inventory: 73 units @ $91
- **Apr. 10**
- Sale: 48 units
- **Apr. 15**
- Purchase: 43 units @ $96
- **Apr. 20**
- Sale: 31 units
- **Apr. 24**
- Sale: 20 units
- **Apr. 30**
- Purchase: 37 units @ $100
The business maintains a perpetual inventory system, costing by the first-in, first-out method.
**Instructions:**
a. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.](https://content.bartleby.com/qna-images/question/9c89cc18-04af-4526-9496-6a509716cba2/29f0267d-501a-47f9-8b51-d52953041853/1g9xiao_thumbnail.jpeg)
Transcribed Image Text:**Perpetual Inventory Using FIFO**
*Beginning inventory, purchases, and sales data for portable game players are as follows:*
- **Apr. 1**
- Inventory: 73 units @ $91
- **Apr. 10**
- Sale: 48 units
- **Apr. 15**
- Purchase: 43 units @ $96
- **Apr. 20**
- Sale: 31 units
- **Apr. 24**
- Sale: 20 units
- **Apr. 30**
- Purchase: 37 units @ $100
The business maintains a perpetual inventory system, costing by the first-in, first-out method.
**Instructions:**
a. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.
![**Perpetual Inventory Account: First-in, First-out Method - Portable Game Players**
This table is designed to track the perpetual inventory account using the First-in, First-out (FIFO) method for portable game players.
**Columns:**
1. **Date** - Indicates when transactions occur.
2. **Quantity Purchased** - The number of items purchased on each date.
3. **Purchases Unit Cost** - The cost per unit for the items purchased.
4. **Purchases Total Cost** - Total cost paid for the purchases.
5. **Quantity Cost of Merchandise Sold** - Quantity of merchandise sold on a date.
6. **Cost of Merchandise Sold Unit Cost** - Cost per unit of merchandise sold.
7. **Cost of Merchandise Sold Total Cost** - Total cost of the units sold.
8. **Inventory Quantity** - Quantity of items remaining in inventory after a transaction.
9. **Inventory Unit Cost** - Cost per unit of the remaining inventory.
10. **Inventory Total Cost** - Total cost value of the remaining inventory.
**Rows (Dates):**
- **Apr. 1**: Initial status before any activity.
- **Apr. 10**: Activity where 48 units are potentially sold. Costs need to be calculated.
- **Apr. 15**: 43 units are purchased at $96 per unit.
- **Apr. 20**: Another sale occurs; number of units sold needs to be considered.
- **Apr. 24**: 20 units are potentially sold.
- **Apr. 30**: 37 units purchased at $100 per unit.
- **Apr. 30 Balances**: Final balances of inventory need to be calculated.
This table is intended to help in understanding the movements and costs of inventory in an educational setting.](https://content.bartleby.com/qna-images/question/9c89cc18-04af-4526-9496-6a509716cba2/29f0267d-501a-47f9-8b51-d52953041853/703q3h_thumbnail.jpeg)
Transcribed Image Text:**Perpetual Inventory Account: First-in, First-out Method - Portable Game Players**
This table is designed to track the perpetual inventory account using the First-in, First-out (FIFO) method for portable game players.
**Columns:**
1. **Date** - Indicates when transactions occur.
2. **Quantity Purchased** - The number of items purchased on each date.
3. **Purchases Unit Cost** - The cost per unit for the items purchased.
4. **Purchases Total Cost** - Total cost paid for the purchases.
5. **Quantity Cost of Merchandise Sold** - Quantity of merchandise sold on a date.
6. **Cost of Merchandise Sold Unit Cost** - Cost per unit of merchandise sold.
7. **Cost of Merchandise Sold Total Cost** - Total cost of the units sold.
8. **Inventory Quantity** - Quantity of items remaining in inventory after a transaction.
9. **Inventory Unit Cost** - Cost per unit of the remaining inventory.
10. **Inventory Total Cost** - Total cost value of the remaining inventory.
**Rows (Dates):**
- **Apr. 1**: Initial status before any activity.
- **Apr. 10**: Activity where 48 units are potentially sold. Costs need to be calculated.
- **Apr. 15**: 43 units are purchased at $96 per unit.
- **Apr. 20**: Another sale occurs; number of units sold needs to be considered.
- **Apr. 24**: 20 units are potentially sold.
- **Apr. 30**: 37 units purchased at $100 per unit.
- **Apr. 30 Balances**: Final balances of inventory need to be calculated.
This table is intended to help in understanding the movements and costs of inventory in an educational setting.
Expert Solution
![Check Mark](/static/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Beginning inventory, purchases, and sales for Item XJ-56 are as follows: May 1 Beginning inventory 90 units @ $36 each May 6 Sold 75 units @ $50 each May 15 Purchased 125 units @ $38 each May 24 Sold 80 units @ $51 each What is the value of ending inventory for May using a FIFO inventory costing method in a perpetual inventory system? Please show calculations in order to receive credit.arrow_forwardBeginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units @ $10 11 Purchase 26 units @ $12 14 Sale 36 units 21 Purchase 18 units @ $15 25 Sale 20 units Assuming the business maintains a periodic inventory system; calculate the cost of merchandise sold and ending inventory under the following assumptions: FIFO LIFO Average cost In your computations, round the average cost per unit to two decimal places and round your final answers to the nearest dollar.arrow_forwardBeginning inventory, purchases, and sales data for tennis rackets are as follows: April 3 Inventory 22 units @ $16 11 Purchase 17 units @ $14 14 Sale 26 units 21 Purchase 10 units @ $20 25 Sale 19 units Complete the inventory record assuming the business maintains a perpetual inventory system, and determine the cost of goods sold and ending inventory using FIFO. Cost of Goods Sold Cost of Goods Sold Cost of Goods Sold Total Cost Qty Unit Cost Date April 3 11 14 21 25 Balances Purchases Qty Purchases Unit Cost Purchases Total Cost 00 A FA 00 00 00 Inventory Qty 0000 000 Inventory Unit Cost 000 0000 $ S Inventory Total Costarrow_forward
- Beginning inventory, purchases, and sales data for tennis rackets are as followsarrow_forwardThe following data regarding purchases and sales of a commodity were taken from the related inventory account (perpetual inventory system is used): May 1 Balance 25 units at $41 6 Sale 20 units 8 Purchase 20 units at $42 16 Sale 10 units 20 Purchase 20 units at $43 23 Sale 25 units 30 Purchase 15 units at $45 (a) Determine the total cost of the inventory balance at May 31, using the first-in, first-out method. Also, identify the quantity, unit price, and total cost of each lot/layer in the ending inventory. (b) Determine the total cost of the inventory balance at May 31, using the last-in, first-out method. Also, identify the quantity, unit price, and total cost of each lot/layer in the ending inventory. (a) FIFO (b) LIFOarrow_forwardThe cost of merchandise sold and merchandise inventory is determined from the inventory cost flow assumption. To illustrate, beginning inventory, purchases and sales of shoes are shown below for Grant Co., using a perpetual inventory system. 1. In the table below, fill in the March 24 quantity, unit cost, and total cost in the spaces provided for determining Cost of Merchandise Sold (COMS) and Merchandise Inventory under the FIFO cost flow assumption, assuming 32 shoes are sold on March 24. Determine the COMS and Merchandise inventory final balances. If units are in inventory or are listed under cost of merchandise sold at two different costs, enter the units that were purchased earliest first. 2. In the table below, fill in the March 24 quantity, unit cost, and total cost in the spaces provided for determining Cost of Merchandise Sold (COMS) and Merchandise Inventory under the LIFO cost flow assumption, assuming 32 shoes are sold on March 24. Determine the COMS and Merchandise…arrow_forward
- Beginning inventory, purchases, and sales data for tennis rackets are as follows: April 3 Inventory 18 units @ $16 11 Purchase 17 units @ $14 14 Sale 23 units 21 Purchase 8 units @ $18 25 Sale 12 units Complete the inventory cost card assuming the business maintains a perpetual inventory system and determine the cost of goods sold and ending inventory using LIFO. Cost of Purchases Goods Sold Inventory Date Qty. Unit Cost Total Cost Qty. Unit Cost Total Cost Qty. Unit Cost Total Cost April 3 11 14 21 25 Total Cost of goods sold Ending inventory value 00arrow_forwardBeginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 35 units @ $72 10 Sale 25 units 15 Purchase 46 units @ $75 20 Sale 26 units 24 Sale 8 units 30 Purchase 28 units @ $80 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Merchandise Sold LIFO Method Portable Game Players Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost…arrow_forwardSport Box sells a wide variety of sporting equipment. The following is information on the purchases and sales of their top selling hockey stick. The hockey stick sells for $130. Description Mar. 1 Beginning Inventory Mar. 3 Purchase Mar. 6 Purchase Mar. 17 Sale Mar. 23 Purchase Mar. 31 Sale 1. FIFO Units. 19 64 114 59 58 148 2. Moving weighted average Required: Calculate the cost of goods sold and ending inventory under the perpetual inventory system using the following methods. (Do not round your "Unit Cost" answers. Round all other intermediate and final answers to nearest whole dollar.) Unit Cost $44 $49 $54 Cost of Goods Sold $54 Ending Inventory < Prev www 2 of 8 --- Nexarrow_forward
- Required information [The following information applies to the questions displayed below.] Total Date March 1 March 5 March 9 March 18 March 25 March 29 Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Beginning inventory Purchases: March 5 March 18 March 25 Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals Saved Required: 1. Compute cost of goods available for sale and the number of units available for sale. # of units Cost per Unit Units Acquired at Cost 100 units @ $51.00 per unit 225 units @ $56.00 per unit 130 units @ $96.00 per unit 390 units Subnarrow_forwardGiven the following, calculate: Cost of goods available for sale, the ending inventory at retail, the estimated cost of goods sold and estimated ending inventory using the gross profit method. Cost Beginning inventory: $ 29,000.00 Net Purchases: $ 3,900.00 Net sales at retail: $ 17,000.00 Gross profit on sale: 55% Required: Using the information above complete the highlighted cells in the chart: Cost of goods available for sale: Ending inventory at retail: Estimated cost of goods sold: Estimated ending inventory:arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education