Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year Ending inventory Cost of goods sold FIFO Units 1,860 LIFO 5,100 2,840 4,080 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods. (Round "Average cost per unit" to 2 decimal places and final answers to nearest whole dollar amount.) Unit Cost $3 5 6 Average Cost

Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year Ending inventory Cost of goods sold FIFO Units 1,860 LIFO 5,100 2,840 4,080 Required: Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods. (Round "Average cost per unit" to 2 decimal places and final answers to nearest whole dollar amount.) Unit Cost $3 5 6 Average Cost

Name: E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average CostLO7-2Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, theaccounting recor

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 11E

See similar textbooks

Similar questions

The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.
Analyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?
Dell Incorporated is the leading manufacturer of personal computers. In a recent year, it reported the following in millions of dollars: Net sales revenue Cost of sales Beginning inventory Ending inventory $ 76,141 58,344 1,700 1,880 Required: Determine the inventory turnover ratio and average days to sell inventory for the current year. Note: Use 365 days a year. Round "Inventory turnover" to 2 decimal places and "Average days to sell inventory" to 1 decimal place. Inventory turnover Average days to sell inventory days
Perez Corporation has the following financial data for the years 20X1 and 20X2: Sales Cost of goods sold Inventory 20X1 20X2 20X1 $ 5,221,000 3,632,000 454,000 a. Compute the inventory turnover for each year using the formula Sales/Inventory. Note: Round your answers to 1 decimal place. Inventory Turnover Ratio times times 20X2 $ 6,578,000 4,862,000 572,000 b. Compute inventory turnover based on an alternative calculation that is used by many financial analysts, Cost of goods sold/Inventory, for each year. Note: Round your answers to 1 decimal place.
Arrow Distributing Corp. likes to track inventory by using weeks of supply as well as by inventory turnover. Arrow Distributing Corp. Net Revenue Cost of sales Inventory Total assets a) What is its weeks of supply? weeks (round your response to two decimal places). b) What is Arrow's inventory turnover? times per year (round your response to two decimal places). $16,830 $14,240 $920 $9,270 c) Suppose a manufacturer has an inventory turnover of 13.5 times per year. Arrow's supply chain performance relative to the manufacturer's, as measured by inventory turnover, is
1. Find the inventory turnover at retail of Walker Manufacturing. The starting inventory at retail was $630,300 and the ending inventory at retail was $417,600. Sales for the year totaled $2,388,870. Round your answer to the nearest tenth. _____ 2. The cost of goods sold for Veltron International last year amounted to $534,600, and the average inventory at cost was $213,840. The published inventory turnover at cost is 6.6. Calculate the inventory turnover at cost, and if it is less than the published rate, calculate the target average inventory at cost (in $). (If the actual turnover is greater than the published rate, enter "above" for target average inventory.) Inventory turnover at cost _____ Target average inventory at cost$ ____
Oshkosh B'Gosh, Inc., uses LIFO. Recent financial statements included the following data (del lars in thousands): PROBLEM 8.12 What If They'd Used FIFO? LO 1,7 $ 81,554 Average inventory (throughout the year) Current assets (at year-end) Current Habilities (at year-end) 115.852 27,175 315.076 Net sales 209,006 Cost of goods sold Gross profit 106,070 A note accompanying these statements indicated that had the company used the FIFO inventorry method (dollars in thousands): 1. Average inventory would have been $88,474 (S6,920 higher than the LIFO amount). 2. Ending inventory would have been valued at a cost of $96,115 ($6,781 higher than the LIFO cost). 3. The cost cf goods,sold would have been $209,284 ($278 higher than that reported in the com- pany's income statement). Instructions & Using the data contained in the company's financial statements (based on the LIFO method), compute the following analytical measurements. (Round to the nearest tenth.) 1. Inventory tumover rate 2. Current…
The following data were extracted from the income statement of Brecca Systems Inc.: Current Year Preceding Year Sales $1,533,000 $1,377,915 Beginning inventories 150,275 135,275 Cost of goods sold 876,000 835,100 Ending inventories 124,275 150,275 a. (1). Determine for each year the inventory turnover. Round to one decimal place. Current year fill in the blank 1 Preceding year fill in the blank 2 (2). Determine for each year the number of days' sales in inventory. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers to one decimal place. Current year fill in the blank 3 days Preceding year fill in the blank 4 days
Use the following information to complete the calculations below. Cost of goods sold $195,640 Inventory: Beginning of year 20,500 End of year 18,628 a. Compute inventory turnover. b. Compute average daily cost of goods sold using a 365 day year. c. Compute number of days' sales in inventory. Round your answer to one decimal place. days
A recent annual report of Gateway $2000 , Inc. , shows : cost of goods sold. $4,072; inventory at the beginning of the year, $225; and inventory at the end of the year. $278. (These dollar amounts are in millions) . Compute the inventory turnover rate for the year ( round to the nearest tenth) . Using the assumption of 365 days in a year , compute the number of days required for the pany to sell the amount of its average inventory ( round to the nearest day). Assume that an average of 30 days is required for Gateway to collect its accounts receivable What is the length of Gateway's operating cycle?
1. PAKIALAMERA KO Company provided the following data for the current year: Inventory, January 1 P2,000,000, Purchases P7,500,000, Purchase Returns and Allowances P500,000, Sales returns and allowances P750,000, Inventory, December 31 P2,800,000, Gross profit rate 20%. What is the amount of Cost of goods sold?
Use the following information: Net sales $ 205,000 Cost of goods sold 144,000 Beginning inventory 46,000 Ending inventory 36,000 a. Calculate the inventory turnover ratio. (Round your answer to 1 decimal place.) b. Calculate the average days in inventory. (Assume 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.) c. Calculate the gross profit ratio. (Round your answer to 2 decimal place.)