# Perpetual Inventory Using LIFO**Beginning inventory, purchases, and sales data for portable game players are as follows:**- **April 1** - Inventory: 69 units @ $93- **April 10** - Sale: 52 units- **April 15** - Purchase: 84 units @ $99- **April 20** - Sale: 48 units- **April 24** - Sale: 13 units- **April 30** - Purchase: 37 units @ $103**The business maintains a perpetual inventory system, costing by the last-in, first-out method (LIFO).**Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the format 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. The image depicts a table layout designed for tracking inventory and sales data over the month of April. Below is a detailed transcription and explanation of the table components:### Table OverviewThe table is meant to track various aspects of inventory and sales, including purchases and sales of merchandise, and calculates costs and balances associated with these activities.#### Table Columns1. **Date**: Dates in April (e.g., Apr. 1, Apr. 10, Apr. 15, etc.)2. **Quantity Purchased**: Number of items purchased.3. **Purchases Unit Cost**: Cost per unit for the purchased items.4. **Purchases Total Cost**: Total cost of purchases (calculated by multiplying Quantity Purchased by Purchases Unit Cost).5. **Quantity Sold**: Number of items sold.6. **Merchandise Sold Unit Cost**: Cost per unit for the items sold.7. **Merchandise Sold Total Cost**: Total cost of merchandise sold (calculated by multiplying Quantity Sold by Merchandise Sold Unit Cost).8. **Inventory Quantity**: Number of items remaining in inventory.9. **Inventory Unit Cost**: Cost per unit remaining in inventory.10. **Inventory Total Cost**: Total cost of remaining inventory (calculated by multiplying Inventory Quantity by Inventory Unit Cost).#### Rows- Dates listed include Apr. 1, Apr. 10, Apr. 15, Apr. 20, Apr. 24, and Apr. 30, indicating when transactions occurred.- An additional row labeled "Apr. 30 Balance" appears to summarize or conclude inventory balances at the end of the month.### Features- **CengageNOWv2 Header**: The document is linked to CengageNOWv2, an online teaching and learning resource from Cengage Learning, indicating its educational purpose. - **URL Reference**: A URL is present at the top, possibly indicating where the original assignment or data set can be accessed online.This table would typically be used in an educational setting to teach accounting principles, particularly in tracking inventory and sales transactions over a specified period.

Name: # Perpetual Inventory Using LIFO**Beginning inventory, purchases, and
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: # Perpetual Inventory Using LIFO**Beginning inventory, purchases, and sales data for portable game players are as follows:**- **April 1** - Inventory: 69 units @ $93- **April 10** - Sale: 52 units- **April 15** - Purchase: 84 units @ $99- **April

Answered: Image /qna-images/answer/6ad776f1-592e-4207-8bc3-c199093e8e4a.jpg

Business

Accounting

3. EX.07.04.ALGO (Algorithmic) Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 69 units @ $93 10 Sale 52 units 15 Purchase 84 units @ $99 20 Sale 48 units 24 Sale 13 units 30 Purchase 37 units @ $103 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

3. EX.07.04.ALGO (Algorithmic) Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 69 units @ $93 10 Sale 52 units 15 Purchase 84 units @ $99 20 Sale 48 units 24 Sale 13 units 30 Purchase 37 units @ $103 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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Submit it in excel form
Beginning inventory, purchases, and sales data for DVD players are as follows: Date Line Item Description Units and Cost Nov. 1 Inventory 140 units at $29 10 Sale 110 units 15 Purchase 150 units at $30 20 Sale 120 units 24 Sale 35 units 30 Purchase 140 units at $34 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of goods 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 Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. LIFO MethodDVD Players Date QuantityPurchased PurchasesUnit Cost PurchasesTotal Cost QuantitySold Cost ofGoods SoldUnit Cost Cost ofGoods SoldTotal Cost InventoryQuantity InventoryUnit Cost InventoryTotal Cost Nov. 1 Nov. 1 Nov. 1 Nov. 1…
Required Information [The following information applies to the questions displayed below] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March S March 9 March 18 March 25 March 29 Gross Margin Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals Sales Less: Cost of goods sold Gross profit 69 60 FIFO LIFO Units Acquired at Cost 27.312 S 27.312 17.037 17.817 x 10,275 $ 9.495 S 60 units 265 units 65 units 110 units 4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, units sold include units from beginning inventory, 175 units from the March 5 purchase, 25 units from the March 18 purchase, and 65 units from the M 25 purchase. Note: Round weighted average cost per unit to two decimals and final answers to nearest whole dollar. 440 units Weighted Average @ $50.20 per unit @$55.20 per unit 17.291 10,021 @ $60.20 per…
please dont provide answer in image format thank you
Beginning inventory, purchases, and sales data for tennis rackets are as follows
Use FIFO in perpetual inventory system to prepare the following based on transactions 1-4 Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost 1-Mar 400 30.00 12,000.00 5-Mar 15-Mar 20-Mar 31-Mar Balances 1 March 5 Purchased 200 units at $31.50. 2 March 15 sold 500 units at $45.00 3 March 20 purchased 300 units at $32.50 4 Provide final balance for Cost of Goods Sold and March 31 Inventory
Required information The following information applies to the questions displayed below] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March 5 Harch 9. March 18 March 25 March 29 Total Perpetual FIFO Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals Date March 1 March 5 March 18 March 25 Complete this question by entering your answers in the tabs below. Perpetual LIFO 3. Compute the cost assigned to ending inventory using (a) FIFO. (b) LIFO. (c) weighted average, and (d) specific identification. For specific identification, units sold include 80 units from beginning inventory. 340 units from the March 5 purchase. 40 units from the March 18 purchase, and 120 units from the March 25 purchase. Weighted Average Goods Available for Sale # of units 400 120 200 720 Specific Id Compute the cost assigned to ending inventory using specific identification. For specific…
Beginning 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…
Please don't give image format
Sport 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 --- Nex