Concept explainers
Perpetual Inventory Using FIFO
Beginning inventory, purchases, and sales data for portable DVD players are as follows:
Apr. 1 | Inventory | 57 units @ $47 | |
10 | Sale | 37 units | |
15 | Purchase | 30 units @ $49 | |
20 | Sale | 25 units | |
24 | Sale | 17 units | |
30 | Purchase | 24 units @ $51 |
The business maintains a perpetual inventory system, costing by the first-in, first-out method.
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.
a. 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.
Cost of the Merchandise Sold Schedule | |||||||||
First-in, First-out Method | |||||||||
Portable DVD Players | |||||||||
Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Cost of Merchandise Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
Apr. 1 | $ | $ | |||||||
Apr. 10 | $ | $ | |||||||
Apr. 15 | $ | $ | |||||||
Apr. 20 | |||||||||
Apr. 24 | |||||||||
Apr. 30 | |||||||||
Apr. 30 | Balances | $ | $ |
b. Based upon the preceding data, would you expect the inventory to be higher or lower using the last-in, first-out method?
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 1 images
- Beginning 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_forwardBeginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Purchases Sales Dec. 1 3,800 units at $23 Dec. 10 1,900 units at $25 Dec. 12 2,660 units Dec. 20 1,710 units at $27 Dec. 14 2,280 units Dec. 31 1,140 units Question Content Area a. Assuming that the perpetual inventory system is used, costing by the LIFO 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. Schedule of Cost of Goods SoldLIFO MethodPrepaid Cell Phones Date QuantityPurchased PurchasesUnit Cost PurchasesTotal Cost QuantitySold Cost ofGoods SoldUnit Cost Cost ofGoods SoldTotal Cost InventoryQuantity InventoryUnit…arrow_forward
- Beginning inventory, purchases, and sales data for tennis rackets are as followsarrow_forwardBeginning inventory, purchases, and sales for an inventory item are as follows: Sep. 1 Beginning Inventory 24 units @ $15 5 Sale 15 units 17 Purchase 25 units @ $18 30 Sale 16 units Assuming a perpetual inventory system and the last-in, first-out method: a. Determine the cost of the goods sold for the September 30 sale. b. Determine the inventory on September 30.arrow_forwardPerpetual inventory using LIFO and FIFO In the spaces provided below, determine the cost of good sold and ending inventory under the FIFO and LIFO method for Kimbrell Corporation which uses a perpetual inventory system. Below is the data for the October: Beginning inventory 120 units @ $39 each October 2 purchase 100 units @ $41 each October 8 sale 80 units October 15 purchase 200 units @ $42 each October 22 sale 250 units FIFO Purchases Cost of Goods Sold Inventory Balance Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost…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_forwardPlease help me. Thankyou.arrow_forward
- sanjayarrow_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_forwardRequired 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_forward
- 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