Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022.(in millions)202020212022Beginning inventory$1,900$2,200$2,400Ending inventory2,2002,4002,500Cost of goods sold18,04020,01019,600Sales revenue41,00042,30042,240 Calculate the days in inventory for 2020, 2021, and 2022. (Round days in inventory to 1 decimal place, e.g. 5.1.)202020212022Days indaysdaysdaysinventory

Days in inventory are also known as days inventory outstanding. It measures the number of days that…

Answered: Calculate the days in inventory for…

Calculate the days in inventory for 2020, 2021, and 2022. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Days in inventory days days days

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Bonita, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past 3 years…

A: Date Inventory atEnd-of-year Prices Price Index Inventory at Base-year Prices Changefrom Prior Year…

Q: Presented below is information related to Nash Company. Date Ending Inventory (End-of-Year…

A: Under dollar value LIFO method, the goods are taken collectively into the form of pools and then…

Q: What is the 2025 inventory balance using dollar-value LIFO?

A: Inventory Valuation is a method of calculating the value of stock at the end of an accounting…

Q: Income Statement Calculations Taylor Company uses a periodic inventory system. The following is…

A: Since, Cost of goods sold = opening stock + Net purchases - closing stock

Q: Whispering Company had ending inventory at end-of-year prices of $104,000 at December 31, 2019;…

A: Year Inventory at end of year prices Price index Inventory at base year prices Change from Prior…

Q: 31, 2022, the records indicated a cost of $70,700 ar ne year.

A: Answer : Direct method : Date Account title Debit Credit Dec.31,2022 Cost of good sold ($70,700…

Q: A company uses the dollar-value LIFO method of computing inventory. An external price index is used…

A: Inventory includes all the items, merchandise, and raw materials that are used by the business…

Q: Presented below is information related to Sunland Company. Ending Inventory Price Date (End-of-Year…

A: This method is used by retailers to estimate the value of their inventory for financial reporting…

Q: Abshire Corp uses the periodic inventory system. The following table shows beginning inventory and…

A: Inventory valuation is based on the method of flow used by the organization. It can be the first in…

Q: Suppose this information is available for PepsiCo, Inc. for 2025, 2024, and 2023. (in millions)…

A: Days in Inventory - Days in Inventory ratios show the time required to sell the inventory lying in…

Q: Calculate the ending inventory balance for Oriole Ltd., assuming the company uses a perpetual…

A: Here, the calculation is taken place by dividing the total costs from the number of items in stock.…

Q: The cost of goods sold computations for Sheridan Company and Windsor Company are shown below.…

A: Inventory turnover ratio also commonly referred to as stock turnover ratio indicates the extent to…

Q: A company adopted dollar-value LIFO on January 1, 2020, when the inventory value was $365,000 and…

A: The dollar-value method of valuing LIFO inventories is a method of determining cost by using…

Q: Use the follwing information for questions 14 and 15 The following information was available for…

A: The inventory turnover ratio is used to figure out, how efficiently the inventory is managed.

Q: You have the following information for Waterway Industries for the month ended October 31, 2022.…

A: "LIFO" stands for last-in, first-out, meaning that the recently purchased inventory items are…

Q: Days Sales in Inventory Accounts Receivable Turnover Calcute each ratio from the data for 2019 and…

A: Day sales in inventory= Average inventory/COGS*365 days Average inventory = (Beginning inventory+…

Q: Calculate the ending inventory balance for Blossom Ltd.. assuming the company uses a perpetual…

Q: The following information relates to the George Robinson Company. Ending Inventory Price Date…

A: To compute the ending inventory for Robinson Company using the dollar-value LIFO method, we'll need…

Q: Current Attempt in Progress The following information is available for Marigold Company at December…

A: INVENTORY TURNOVER RATIOInventory Turnover Ratio is the Ratio Between Cost of Goods Sold &…

Q: ane Company started operations on January 1, 2020, and has used the FIFO method of inventory…

A: The net income of the business that remains after the necessary dividends are distributed to…

Q: Presented below is information related to Blossom Company. December 31, 2022 December 31, 2023…

A: LIFO is the method of determining the ending balance of inventory where the cost of inventory is…

Q: During 2021, a company sells 500 units of inventory for $88 each. The company has the following…

A: The inventory valuation is based on the flow of inventory. The firm can adopt the LIFO method, FIFO…

Q: The following inventory transactions took place for Blossom Ltd. for the year ended December 31,…

A: Perpetual inventory system Perpetual inventory system continuously estimates the inventory based on…

Q: During 2021, a company sells 460 units of inventory for $87 each. The company has the following…

A: To use the weighted average model, one divides the cost of the goods that are available for sale by…

Q: Computing Ending Inventory using Dollar-Value LIFO On January 1, 2020, Benn Company changed from…

A: GIVEN Computing Ending Inventory using Dollar-Value LIFO On January 1, 2020, Benn Company changed…

Q: Presented below is information related to Splish Company. Price Ending Inventory (End-of-Year…

A: Last-in, First-out method, also known as LIFO, is the method used for inventory valuation. This…

Q: Mercury Company has only one inventory pool. On December 31, 2021, Mercury adopted the dollar-value…

A: Solution: To compute dollar value LIFO inventory, first we compute price index for every year by…

Q: Take me to the text Suppose that on November 20, 2021, both Company A and Company B sold inventory…

A: The objective of this question is to calculate the value of inventory as at November 20 for both…

Q: The following data were taken from the financial records of Crane Company. Net Sales Beginning…

A: Average inventory = Beginning inventory+ Ending inventory 2 2021 =…

Q: A company uses the dollar-value LIFO method of computing inventory. An external price index is used…

A: LIFO (Last in, first out) is the inventory valuation method according to which the recently…

Q: Presented below is information related to Crane Company. Date Ending Inventory (End-of-Year…

A: Date Ending Inventory(End-of-Year Prices) PriceIndex Inventory at base year price Change from the…

Q: On January 1, 2024, a company adopted the dollar-value LIFO method. The inventory value for its one…

A: The inventory can be valued using various methods as LIFO, FIFO and average method. Using LIFO…

Q: Dollar-Value LIFO Belstock Company manufactures one product. On December 31, 2018, Belstock adopted…

A: Dollar Value LIFO Method: It is a method in accounting, where the inventory is valued as per the…

Q: A company uses the dollar-value LIFO method of computing inventory. An external price index is used…

A: LIFO stands for Last in first out. Using dollar-value LIFO method, the cost is determined by using…

Q: On January 1, 2024, a company adopted the dollar-value LIFO method. The inventory value for its one…

A: The inventory can be valued using various methods as LIFO, FIFO and average method. Using LIFO…

Q: View Policies Current Attempt in Progress The adjusted trial balance of Windsor, Inc. at the end of…

A: Cost of goods sold is part of income statement. It is calculated by using purchase cost and…

Q: Baldwin, Inc. had the following balances and transactions during 2026: Beginning Merchandise…

A: Cost of goods sold is the amount of cost incurred by the entity on the making of the goods sold in…

Q: On January 1, 2024, a company adopted the dollar-value LIFO method. The inventory cost on this date…

A: Answer:- Inventory meaning:- The products and supplies that a company keeps on hand for…

Q: Sheffield Hardware Limited reported the following amounts for its cost of goods sold and Inventory:…

A: The question is based on the concept of Cost Accounting. Cost of goods sold is calculated by adding…

Q: 17. On January 2020, Roel Corp. Has the following inventory purchases. January Units Amount 2 5,750…

A: Date Units Amount January 2 5750 P7500 7 5100 5850 15 7600 6300 25 6600 4950 Total…

Question

Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022.
(in millions)
2020
2021
2022
Beginning inventory
$1,900
$2,200
$2,400
Ending inventory
2,200
2,400
2,500
Cost of goods sold
18,040
20,010
19,600
Sales revenue
41,000
42,300
42,240

Calculate the days in inventory for 2020, 2021, and 2022. (Round days in inventory to 1 decimal place, e.g. 5.1.)
2020
2021
2022
Days in
days
days
days
inventory

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2 - Solution

VIEW

Step 3 - Show formula version of the same sheet

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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

J
Do not give image format
Use the following information regarding Skysong, Inc. and Kingbird, Inc. to answer the question “Which amount is equal to Skysong, Inc.'s "days in inventory" for 2022 (to the closest decimal place)?” (Use 365 days for calculation.) * Year Inventory Turnover Ending Inventory Skysong, Inc. 2020 * $26800 * 2021 10.6 $31400 * 2022 10.2 $32400 * Kingbird, Inc. 2020 * $26340 * 2021 8.5 $25230 * 2022 9.2 $23010
Inventory Turnover Calculate the company's inventory turnover for 2020 and compare the result to the industry average.
Adjusting Balance Sheet and Income Statement for LIFO to FIFO In its December 2019 10-K, Phillips 66 reported the following information ($ millions). 2019 Assets 2019 Inventories 2019 LIFO Reserve 2018 LIFO Reserve Tax Rate $52,848 $3,398 $3,870 $2,610 22% a. Determine the necessary adjustments to the following balance sheet line items for 2019. Note: Round your answers to the nearest whole dollar. Adjustment (S in millions) Inventories $4 6,008 x Total assets %24 Deferred tax liabilkies $ 54,108 x 277 x Equity 0 x b. Determine the necessary adjustments to the following income statement line items for 2019. Note: Round your answers to the nearest whole dollar. Adjustment ($ in millions) Cost of goods sold %24 0 x Pretax income %24 0 x Income tax expense $ 0 x Net income %24
Waterway, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past 3 years follow. Year EndedDecember 31 Inventory atCurrent-Year Cost PriceIndex 2019 $20,600 100 2020 22,470 105 2021 27,492 116 Compute the value of the 2020 and 2021 inventories using the dollar-value LIFO method. 2020 2021 Inventory under LIFO
Metlock Corporation adopted the dollar-value LIFO retail inventory method on January 1, 2024. At that time the inventory had a cost of $43,000 and a retail price of $100,000. The following information is available. Year-End Inventory at Retail Current Year Cost-Retail% Year-End Price Index 2024 $127,200 59% 106 2025 149,850 62% 111 2026 128,800 63% 115 2027 165,000 60% 125 The price index at January 1, 2024, is 100. Compute the ending inventory at December 31 of the years 2024-2027. (Round ratios for computational purposes to O decimal places, e.g. 78% and final answers to O decimal places, e.g. 28,987.) Ending inventory $ 2024 $ 2025 2026 $ $ 201
On January 1, 2019, Lexor Company adopted the dollar-value-LIFO method of inventory costing. Lexor's ending inventory records appear as follows: Year Current cost Index 2019 $ 42,000 100 (1.00) 2020 58,000 110 (1.10) 2021 60,100 120 (1.20) 2022 68,200 130 (1.30) Compute the ending inventory for the years 2019, 2020, 2021, and 2022, using the dollar-value LIFO method. Round to the nearest dollar. Show all work. You can use the previous homework template that you used for
Sunland Company adopted the dollar-value LIFO method of inventory valuation on December 31, 2019. Its inventory at that date was $1109000 and the relevant price index was 100. Information regarding inventory for subsequent years is as follows: Date December 31, 2020 December 31, 2021 December 31, 2022 Inventory at Current Prices $1285000 1460000 1625000 Current Price Index 106 124 129 What is the cost of the ending inventory at December 31, 2021 under dollar-value LIFO?
Subject: accounting
A company reports the following: Cost of merchandise sold $1,460,000 Average merchandise inventory 182,500 Determine (a) the inventory turnover and (b) the number of days sales in inventory. Assume a 365-day year. Round your answers to one decimal place. a. Inventory turnover b. Number of days' sales in inventory days Previous Next 1:00 PM 18 se g 12/11/2020 a
(b) Your answer is correct. Calculate the days in inventory for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2.) (c) 2020 86.9 days eTextbook and Media 2021 121.7 days 2022 125.9 days Attempts: unlimited Calculate the gross profit rate for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2%.) Gross profit rate eTextbook and Media Save for Later 2020 % 2021 % 2022 Attempts: unlimited Submit Answer