Concept explainers
Question #6:
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:
Inventory | Purchases | Sales | |||
May 1 | 1,550 units at $44 | May 10 | 720 units at $45 | May 12 | 1,200 units |
20 | 1,200 units at $48 | 14 | 830 units | ||
31 | 1,000 units |
Assume that the business maintains a perpetual inventory system, costing by the first-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 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.
Schedule of Cost of Merchandise SoldFIFO MethodPrepaid Cell Phones
Date |
Quantity Purchased |
Purchases Unit Cost |
Purchases Total Cost |
Cost of Merchandise Sold Quantity |
Cost of Merchandise Sold Unit Cost |
Cost of Merchandise Sold Total Cost |
Inventory Quantity |
Inventory Unit Cost |
Inventory Total Cost |
May 1 | |||||||||
May 10 | |||||||||
May 12 | |||||||||
May 14 | |||||||||
May 20 | |||||||||
May 31 | |||||||||
May 31 | Balances |
fifo is an accounting method in which inventories are valued on the first comes and first out basis. thus it is the common method used to estimate the value
Trending nowThis is a popular solution!
Step by stepSolved in 2 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_forwardRequired 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…arrow_forwardplease dont provide answer in image format thank youarrow_forward
- The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 55 $ 10 July 13 Purchase 275 11 July 25 Sold (100 ) $ 14 July 31 Ending Inventory 230 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under FIFO. Assume a periodic inventory system is used. How would i creat a FIFO periodic table?arrow_forwardBeginning inventory, purchases, and sales data for tennis rackets are as followsarrow_forwardes W Required information [The following information applies to the questions displayed below.] (a Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date March 1 March 5 March 9 March 18 here to search 2 March 25 March 29 Sales Less: Cost of goods sold Gross profit Gross Margin 13 # Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals 4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, units sold include 140 units from beginning inventory, 270 units from the March 5 purchase, 120 units from the March 18 purchase, and 160 units, from the March 25 purchase. Note: Round weighted average cost per unit to two decimals and final answers to nearest whole dollar. 3 Ri $ FIFO $ 64,210 $ IDI 4 LIFO 99+ 15 % Units Acquired at Cost 250 units. @ $54.00 per unit 300 units @ $59.00 per unit 160 units 300 units 5 1,010 units 64,210 $ @…arrow_forward
- Please help me with all I will give upvote thankuarrow_forwardUse the following inventory table to find the cost of goods sold using the first-in, first-out (FIFO) inventory method. Date of purchase Units purchased Cost per unit Retail price per unit Beginning inventory 42 $860 $965 February 5 25 $1,770 $2,115 February 9 19 $945 $1,208 March 3 27 $490 $600 Units sold 81 Question content area bottom Part 1 The cost of goods sold is $enter your response here. (Type an integer or a decimal.)arrow_forwardBeginning 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_forward
- 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…arrow_forwardPlease don't give image formatarrow_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