Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. Calculate the days in inventory for 2020, 2021, and 2022: (in millions)202020212022Beginning inventory$2,000$2,400$2,600Ending inventory2,4002,6002,700Cost of goods sold17,60019,50019,080Sales revenue39,20042,30042,210

Inventory refers to all of the items, goods, merch, and materials held by a company for the purpose…

Answered: (in millions) 2020 2021 2022 Beginning…

Business

Accounting

(in millions) 2020 2021 2022 Beginning inventory $2,000 $2,400 $2,600 Ending inventory 2 400 2 600 2 700

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Sunland Company had ending inventory at end-of-year prices of $108,000 at December 31, 2019; $129.492 at December 31, 2020; and $145,200 at December 31, 2021. The year-end price indexes were 100 at 12/31/19,110 at 12/31/20, and 120 at 12/31/21. Compute the ending inventory for Sunland Company for 2019 through 2021 using the dollar-value LIFO method. 2019 2020 2021 Ending Inventory %24 24 24
A company uses the dollar-value LIFO method of computing inventory. An external price index is used to convert ending inventory to base year. The company began operations on January 1, 2024, with an inventory of $120,000 Year-end inventories at year-end costs and cost indexes for its one inventory pool were as follows: Year Ended December 31 2024 2025 2026 2027 Date Required: Calculate inventory amounts at the end of each year Note: Round intermediate calculations and final answers to the nearest whole dollars. 01/01/2024 12/31/2024 12/31/2025 12/31/2026 Ending Inventory at Cost Index (Relative to Year-End Costs Base Year) $ 198,000 261,800 243,600 240,800 12/31/2027 Inventory Layers Converted to Base Year Cost Inventory at Year End Cost Inventory Layers at Base Year Cost Inventory Layers Converted to Cost Inventory Layers Converted to Cost Base Base 2024 Base 2024 2025 Base 1.10 1.19 1.16 1.12 2024 2025 2026 Base 2024 2025 2026 2027 Inventory Layers at Base Year Cost Inventory DVL…
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (c) (in millions) Beginning inventory Ending inventory Cost of goods sold Sales revenue (a) Inventory turnover ratio Your answer is correct. Inventory turnover ratio 2020 Days in inventory $116,000 317,500 895,000 1,120,000 1,595,500 1,195,000 eTextbook and Medial Calculate the inventory turnover for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2.) Gross profit rate 2020 2021 2020 $317,500 2020 410,500 Calculate the inventory turnover for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2.) 4.1 times 4.1 times 2020 2022 89 days $410,500 476,500 1,297,500 1,894,000 Calculate the days in inventory for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2.) 2021 % 2021 3.1 times. 2021 3.1 Calculate the gross profit rate for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2 %) 2021 times 117 days 2022 2022 2022 2022 125 2.9 2.9 times times…
UMET's Stores had the following inventory transactions in 2020: Transaction Units Cost per unit 1/1 Balance 50 $6 2/14 Sale 25 5/23 Purchase 100 8 8/21 Sale 50 11/5 Purchase 25 12 11/18 Sale 95 Required: Compute tge cost of goods sold and the ending inventory using the periodic inventory system for each of the following cost flow assumptions: a. FIFO b. LIFO c. Weighted average
Presented below is information related to Splish Company. December 31, 2022 December 31, 2023 December 31, 2024 December 31, 2025 December 31, 2026 December 31, 2027 2022 2023 Date 2024 2025 2026 2027 $ $ $ $ $ Ending Inventory (End-of-Year Prices) $ $83,600 117,832 Compute the ending inventory for Splish Company for 2022 through 2027 using the dollar-value LIFO method. 116,501 131,709 157,765 190,224 Ending Inventory 83,600 207,802 Price Index 100 100 104 119 129 139 144
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) Beginning inventory Ending inventory Cost of goods sold Sales revenue (a) 2020 Inventory turnover $1,700 2,200 15,015 38,600 2021 $2,200 $2,500 2,500 2022 45,100 2020 17,860 17,595 2,600 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 45,000 times 2021 times 2022 times
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
Mist Company uses a PERIODIC inventory system. Mist had the following inventory purchases and sales during 2021: 2021 Beginning Inventory (purchased in 2020) Purchases: 60 units @ $20 per unit Purchase 1 on 3/8/21 140 units @ $28 per unit Purchase 2 on 8/5/21 50 units @ $32 per unit Sales: Sale 1 on 5/8/21 80 units @ $90 per unit Sale 2 on 9/13/21 125 units @ $90 per unit Of the items sold on 5/8/2021, 60 units were from the beginning inventory and 20 units were from 3/8/21 purchase. The 9/13/21 sale included 85 units from the 3/8/21 purchase and 40 units from the 8/5/21 purchase. Show how Mist's Balance Sheet and Income Statement would look under each of the inventory cost flow assumptions. Compute Ending Inventory, Sales, COGS, and Gross Profit under Specific Identification, Weighted Average Cost, FIFO and LIFO. Fill in your answers on the table below. SHOW YOUR WORK. Round per…
Presented below is information related to Kingbird, Inc. End-of-Year Inventory Price Date (End-of-Year Prices) Index December 31, 2017 $ 1,200,000 100 December 31, 2018 1,522,500 105 December 31, 2019 1,562,000 110 December 31, 2020 1,813,500 117 Compute the ending inventory for Kingbird, Inc. for 2017 through 2020 using the dollar-value LIFO method. Ending Inventory 2017 2018 2019 2020 $ %24 %24
Patel Company adopted the dollar-value inventory method on 12/31 / 20 . Inventory data are as follows: Inventory Price Year at Yr End Index 2020 5,785 1.00 2021 9,2501.23 202211,225 1.36 20238,575 1.25 2024 16,425 1.40 Instructions : Calculate the inventory for must show your work . 20, 2021, 2022, 20 and 2024.
A company adopted dollar - value LIFO on January 1, 2024, when the inventory value was $367,000 and the cost index was 1.35. On December 31, 2024, the inventory was valued at year-end cost of $402,000 and the cost index was 1.40. The company would report a LIFO inventory of: Note: Round your final answer to the nearest whole dollar amount.
Presented below is information related to Sheffield Company. December 31, 2022 December 31, 2023 December 31, 2024 December 31, 2025 December 31, 2026 December 31, 2027 2022 2023 2024 2025 Date 2026 2027 Ending Inventory (End-of-Year Prices) $ $82,100 117,104 114,835 129,516 154,985 183,168 Compute the ending inventory for Sheffield Company for 2022 through 2027 using the dollar-value LIFO method. Price Index Ending Inventory 100 104 119 129 139 144