FIFO and LIFO costs under perpetual inventory systemThe following units of an item were available for saleduring the year:The firm uses the perpetual inventorysystem, and there are 8, 100 units of the item on handat the end of the year. This information has beencollected in the Microsoft Excel Online file. Open thespreadsheet, perform the required analysis, and inputyour answers in the questions below. Openspreadsheet What is the total cost of the endinginventory according to FIFO? Round your answer to thenearest dollar.$ fill in the blank 2What is the total costof the ending inventory according to LIFO? Round youranswer to the nearest dollar.$ fill in the blank 3

To accurately determine the total cost of the ending inventory using FIFO (First In, First Out) and…

Answered: FIFO and LIFO costs under perpetual…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 5M

See similar textbooks

Similar questions

Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Periodic Inventory System Raynolde Company uses a periodic inventory system. At the end of the year, the following information is available: Required: Prepare a schedule to compute Raynoldes cost of goods sold.
Trini Company had the following transactions for the month. Calculate the ending inventory dollar value for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Pappas Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Calculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost 2. Next Level What can you conclude about the effects of the inventory cost flow assumptions on the financial statements?
Trini Company had the following transactions for the month. Calculate the cost of goods sold dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Akira Company had the following transactions for the month. Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Data on the physical inventory of Katus Products Co. as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed as an example.
Solve it by creating tables in average cost and fifo lifo method Harbor Company uses a periodic inventory system. The company’s records show the beginning inventory of product no. T-12 on January 1 and the purchases of this item during the current year to be as follows: Date Purchases Units Unit cost Total cost January 1 Beginning inventory 800 11.25 9,000 February 23 Purchase 1,000 13.20 13,200 April 20 Purchase 3,200 10.50 33,600 May 4 Purchase 3,800 12.21 46,398 November 30 Purchase 1,100 10.64 11,704 Totals 9,900 units $113,902 A physical count indicates 1,500 units in inventory at year-end. Determine the cost of the ending inventory based on each of the following methods of. Inventory valuation Average cost method FIFO LIFO Harbor Company uses a periodic inventory system. The company’s records show the beginning inventory of product no. T-12 on January 1 and the purchases of…
Teradyne Labs uses the perpetual inventory system and recorded the following transactions last year: Date Units Unit Cost May 2 Beginning Inventory 100 1 May 8 Purchase # 1 6 2 May 10 Sale # 1 45 May 22 Purchase #2 72 4 May 25 Sale #2 83 Build a table for the purchases and sales during the month of May. Find ending cost of goods sold using LIFO.
Perpetual inventory using LIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,300 units at $42 Apr. 19 Sale 2,000 units June 30 Purchase 4,800 units at $47 Sept. 2 Sale 6,600 units Nov. 15 Purchase 2,400 units at $49 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Round your answers for quantity values to the nearest whole number, for unit cost values to the nearest cent, and for total cost values to…

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Century 21 Accounting Multicolumn Journal

Accounting

ISBN:

9781337679503

Author:

Gilbertson

Publisher:

Cengage

SEE MORE TEXTBOOKS