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 LIFO
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:
Inventory | Purchases | Sales | |||
May 1 | 3,400 units at $29 | May 10 | 1,700 units at $31 | May 12 | 2,380 units |
20 | 1,530 units at $33 | 14 | 2,040 units | ||
31 | 1,020 units |
Question Content Area
a. Assuming that the perpetual inventory system is used, costing by the LIFO 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.
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 |
Inventory Total Cost |
May 1 | fill in the blank cad21809afebf98_1 | $fill in the blank cad21809afebf98_2 | $fill in the blank cad21809afebf98_3 | ||||||
May 10 | fill in the blank cad21809afebf98_4 | $fill in the blank cad21809afebf98_5 | $fill in the blank cad21809afebf98_6 | fill in the blank cad21809afebf98_7 | fill in the blank cad21809afebf98_8 | fill in the blank cad21809afebf98_9 | |||
fill in the blank cad21809afebf98_10 | fill in the blank cad21809afebf98_11 | fill in the blank cad21809afebf98_12 | |||||||
May 12 | fill in the blank cad21809afebf98_13 | $fill in the blank cad21809afebf98_14 | $fill in the blank cad21809afebf98_15 | fill in the blank cad21809afebf98_16 | fill in the blank cad21809afebf98_17 | fill in the blank cad21809afebf98_18 | |||
fill in the blank cad21809afebf98_19 | fill in the blank cad21809afebf98_20 | fill in the blank cad21809afebf98_21 | |||||||
May 14 | fill in the blank cad21809afebf98_22 | fill in the blank cad21809afebf98_23 | fill in the blank cad21809afebf98_24 | fill in the blank cad21809afebf98_25 | fill in the blank cad21809afebf98_26 | fill in the blank cad21809afebf98_27 | |||
May 20 | fill in the blank cad21809afebf98_28 | fill in the blank cad21809afebf98_29 | fill in the blank cad21809afebf98_30 | fill in the blank cad21809afebf98_31 | fill in the blank cad21809afebf98_32 | fill in the blank cad21809afebf98_33 | |||
fill in the blank cad21809afebf98_34 | fill in the blank cad21809afebf98_35 | fill in the blank cad21809afebf98_36 | |||||||
May 31 | fill in the blank cad21809afebf98_37 | fill in the blank cad21809afebf98_38 | fill in the blank cad21809afebf98_39 | fill in the blank cad21809afebf98_40 | fill in the blank cad21809afebf98_41 | fill in the blank cad21809afebf98_42 | |||
fill in the blank cad21809afebf98_43 | fill in the blank cad21809afebf98_44 | fill in the blank cad21809afebf98_45 | |||||||
May 31 | Balances | $fill in the blank cad21809afebf98_46 |
Expert Solution
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 3 steps
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
- 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…arrow_forwardplease dont provide answer in image format thank youarrow_forwardPlease do not give solution in image format thankuarrow_forward
- Beginning inventory, purchases, and sales data for tennis rackets are as followsarrow_forwardUse 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 Inventoryarrow_forwardPlease do not give solution in image format thankuarrow_forward
- Use 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_forwardPlease do not give solution in image format thankuarrow_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 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…arrow_forward
- Perpetual 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_forwardPlease don't give image formatarrow_forwardsanjayarrow_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
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education