Suppose this information is available for PepsiCo, Inc. for 2023, 2024, and 2025. (in millions) Beginning inventory Ending inventory Cost of goods sold Sales revenue (a) 2023 2024 $1,800 $2,300 2,300 2,600 15,170 17,885 39,300 43,300 Inventory turnover 2025 $2,600 2,700 2023 17,490 Calculate the inventory turnover for 2023, 2024, and 2025. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 43,180 times 2024 times. 2025

Required: 1. Estimate the 2024 and 2025 ending inventory and cost of goods sold using the dollar-value LIFO retail method.(Calculate the estimated ending inventory at retail, estimated ending inventory at cost, and estimated cost of goods sold) 2. Estimate the 2024 ending inventory and cost of goods sold using the average cost retail method. (Calculate the estimated ending inventory at retail, estimated ending inventory at cost, and estimated cost of goods sold) 3. Estimate the 2024 ending inventory and cost of goods sold using the conventional retail method. (Calculate the estimated ending inventory at retail, estimated ending inventory at cost, and estimated cost of goods sold)    do not give answer in image format

Use the following information relating to Medinas Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.

Use a spreadsheet and the following excerpts from Hileah Companys financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days sales in inventory, for the year 2018.

( Appendix 6B) Inventory Costing Methods Jet Black Products uses a periodic inventory system. For 2018 and 2019, Jet Black has the following data: All purchases and sales are for cash. Required: 1. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using FIFO. 2. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using LIFO. 3. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using the average cost method. ( Note: Use four decimal places for per unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes? 5. CONCEPTUAL CONNECTION Which method produces the most realistic amount for income? For inventory? Explain your answer. 6. CONCEPTUAL CONNECTION What is the effect of purchases made later in the year on the gross margin when LIFO is employed? When FIFO is employed? Be sure to explain why any differences occur. 7. CONCEPTUAL CONNECTION If you worked Problem 6-68A, compare your answers. What are the differences? Be sure to explain why any differences occurred.

( Appendix 6B) Inventory Costing Methods Grencia Company uses a periodic inventory system. For 2018 and 2019, Grencia has the following data (assume all purchases and sales are for cash): Required: 1. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using FIFO. 2. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using LIFO. 3. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using the average cost method. ( Note: Use four decimal places for per unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes? 5. CONCEPTUAL CONNECTION Which method produces the most realistic amount for income? For inventory? Explain your answer. 6. CONCEPTUAL CONNECTION What is the effect of purchases made later in the year on the gross margin when LIFO is employed? When FIFO is employed? Be sure to explain why any differences occur. 7. CONCEPTUAL CONNECTION If you worked Problem 6-68B, compare your answers. What are the differences? Be sure to explain why any differences occurred.

The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?

Refer to the information for Morgan Inc. above. If Morgan uses a perpetual inventory system, what is the cost of ending inventory under FIFO at April 30? a. $32,500 b. $38,400 c. $63,600 d. $69,500

Company Elmira reported the following cost of goods sold but later realized that an error had been made in ending inventory for year 2021. The correct inventory amount for 2021 was 32,000. Once the error is corrected, (a) how much is the restated cost of goods sold for 2021? and (b) how much is the restated cost of goods sold for 2022?