FINANCIAL+MANAG.ACCT.(LL)-W/ACCESS
9th Edition
ISBN: 9781264624829
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Need a,b,c,d
Suppose that a firm has an ending inventory of $121,000 as of December 31, 2012. The accounting information for 2013 has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Question S
A. What is the monthly inventory turnover ratio for each of the twelve months for 2013? Round your answers to two decimal places.
B. What is the total cost of goods sold for the year? Round your answer to the nearest dollar.
C. What is the average monthly inventory? Round your answer to the nearest cent.
D. What is the annual inventory turnover ratio? Do not round intermediate calculations. Round your answer to two decimal places.
Accounting
Compute for the net sales that would be
reported in LIVA company's Income Statement.
You are to be assigned to prepare the financial
statement of LIVA Company for the year 2021.
The following data were made available for you:
Ending Inventory at Cost - 739, 160
Goods Available for Sale at retail - 3, 930, 000
Sales Discount - 16, 000
Net markdowns - 48, 500
Net markups - 30, 000
Beginning inventory at retail - 1, 450, 000
Purchases at retail - 2, 422, 000
The company adopts the average cost approach
to estimate the value of its inventory and the
cost ratio is computed at 68%.
Compute for the net sales that would be reported in LIVA company's
Income Statement.
You are assigned to prepare the financial statements of LIVA
Company for the year 2021. The following data were made
available for you:
Ending Inventory at Cost
739,160
Goods Available for Sale at retail
3,930,000
16,000
48,500
Sales Discount
Net markdowns
Net markups
30,000
Beginning inventory at retail
1,450,000
Purchases at retail
2,422,000
The company adopts the average cost approach to estimate
the value of its inventory and the cost ratio is computed at
68%.
Chapter 5 Solutions
FINANCIAL+MANAG.ACCT.(LL)-W/ACCESS
Ch. 5 - Prob. 1QSCh. 5 - Prob. 2QSCh. 5 - Prob. 3QSCh. 5 - Prob. 4QSCh. 5 - Perpetual: Inventory costing with FIFO P1 A...Ch. 5 - Prob. 6QSCh. 5 - Prob. 7QSCh. 5 - Prob. 8QSCh. 5 - Prob. 9QSCh. 5 - A Periodic: Inventory costing with weighted...
Ch. 5 - Prob. 11QSCh. 5 - Prob. 12QSCh. 5 - Perpetual: Inventory costing with weighted average...Ch. 5 - Prob. 14QSCh. 5 - Prob. 15QSCh. 5 - Prob. 16QSCh. 5 - Prob. 17QSCh. 5 - Prob. 18QSCh. 5 - Prob. 19QSCh. 5 - Prob. 20QSCh. 5 - Prob. 21QSCh. 5 - Prob. 22QSCh. 5 - Prob. 23QSCh. 5 - Prob. 24QSCh. 5 - Prob. 25QSCh. 5 - Prob. 26QSCh. 5 - Prob. 1ECh. 5 - Prob. 2ECh. 5 - Exercise 5-3 Perpetual: Inventory costing methods...Ch. 5 - Prob. 4ECh. 5 - Prob. 5ECh. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - Prob. 10ECh. 5 - Prob. 11ECh. 5 - Prob. 12ECh. 5 - Prob. 13ECh. 5 - Prob. 14ECh. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Prob. 19ECh. 5 - Prob. 20ECh. 5 - Prob. 21ECh. 5 - Prob. 1PSACh. 5 - Prob. 2PSACh. 5 - Prob. 3PSACh. 5 - Problem 5-4AA Periodic: Alternative cost flows...Ch. 5 - Prob. 5PSACh. 5 - Prob. 6PSACh. 5 - Prob. 7PSACh. 5 - Prob. 8PSACh. 5 - Prob. 9PSACh. 5 - Prob. 10PSACh. 5 - Prob. 1PSBCh. 5 - Prob. 2PSBCh. 5 - Prob. 3PSBCh. 5 - Prob. 4PSBCh. 5 - Prob. 5PSBCh. 5 - Prob. 6PSBCh. 5 - Prob. 7PSBCh. 5 - Problem 5-8BA Periodic: Income comparisons and...Ch. 5 - Prob. 9PSBCh. 5 - Prob. 10PSBCh. 5 - Prob. 5SPCh. 5 - Prob. 1.1AACh. 5 - Prob. 1.2AACh. 5 - Prob. 1.3AACh. 5 - Prob. 1.4AACh. 5 - Prob. 2.1AACh. 5 - Prob. 2.2AACh. 5 - Prob. 2.3AACh. 5 - Prob. 3.1AACh. 5 - Prob. 3.2AACh. 5 - Prob. 3.3AACh. 5 - Describe how costs flow inventory to cost of goods...Ch. 5 - Where is the amount of merchandise inventory...Ch. 5 - Prob. 3DQCh. 5 - Prob. 4DQCh. 5 - Prob. 5DQCh. 5 - Prob. 6DQCh. 5 - What factors contribute to (or cause) inventory...Ch. 5 - Prob. 8DQCh. 5 - Prob. 1BTNCh. 5 - Prob. 2BTNCh. 5 - Prob. 3BTNCh. 5 - Prob. 5BTN
Knowledge Booster
Similar questions
- 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.arrow_forwardUse 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.arrow_forwardQuestion: Calculate and interpret liquidity ratios Calculate the inventory turnover, days in inventory, Accounts receivable turnover and the Average Collection period for the years ending June 30, 2020, and 2019 for the Green Construction Supplies Company. Assuming that they have a 60-day credit policy, evaluate their accounts receivable management and recommend ways to improve it. Evaluate their inventory management and suggest ways to improve it. Selected information ($) 2020 2019 2018 Net Sales (80% on credit) 430,000 720,000 640,000 Cost of Goods Sold 250000 350000 320000 Accounts Receivable 220,000 110,000 76,000 Allowance for doubtful accounts 35000 18000 14000 Bad debt expense 30000 12000 9000 Inventory 150000 100000 80000arrow_forward
- Compute for the net sales that would be reported in LIVA company's Income Statement. You are assigned to prepare the financial statements of LIVA Company for the year 2021. The following data were made available for you: Ending Inventory at Cost 739,160 3,930,000 16,000 Goods Available for Sale at retail Sales Discount Net markdowns 48,500 Net markups 30,000 1,450,000 2,422,000 Beginning inventory at retail Purchases at retail The company adopts the ayverage cost approach to estimate the value of its inventory and the cost ratio is computed at 68%.arrow_forwardUse the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Year 2021 Year 2022 Year 2023 Year 2022 Year 2023 Sales $260,000 305,000 333,000 Cost of Goods Sold $187,500 241,250 242,250 Inventory Turnover Average Inventory $25,000 30,000 38,000 Gross Margin Days' Sales in Inventoryarrow_forwardUse the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Cost of Average Sales Goods Sold Inventory Year 2021 $260,000 $177,500 $25,000 Year 2022 305,000 221,250 30,000 Year 2023 343,000 242,250 35,000 Inventory Gross Days' Sales Turnover Margin in Inventory Year 2022 Year 2023arrow_forward
- The following information was available for the year ended December 31, 2019: Net sales $821,250 Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end 602, 250 39,100 30,400 166,000 157,575 Required: a. Calculate the inventory turnover for 2019. (Round your answer to 2 decimal places.) b. Calculate the number of days' sales in inventory for 2019, using year-end inventories. (Use 365 days a year. Round your answer to 1 decimal place.) c. Calculate the accounts receivable turnover for 2019. (Round your answer to 1 decimal place.) d. Calculate the number of days' sales in accounts receivable for 2019, using year-end accounts receivable. (Use 365 days a year. Round your answer to 1 decimal place.) a. Inventory turnover b. Number of days' sales in Inventory c. Accounts receivable turnover d. Number of days' sales in accounts receivable times days times daysarrow_forwardSuppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) Beginning inventory Ending inventory Cost of goods sold Sales revenue 2020 2021 $1,900 $2,300 $2,500 2,300 2,500 2,600 21,840 21,420 Inventory turnover 19,320 40,000 44,300 2022 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 44,260 times 2021 times 2022 timesarrow_forwardThe financial statements of Crane, Inc's. 2025 annual report disclose the following information: (in millions) May 24, 2025 $250 ttempt in Progress Inventories Sales Cost of goods sold Net income (a) (b) 2025 Fiscal Year $3,900 1,300 320 May 25, 2024 $240 Inventory turnover 2024 $3,900 1,300 Compute Crane's (a) inventory turnover and (b) the average days to sell inventory for 2025 and 2024. (Round inventory turnover to 2 decimal places, e.g. 7.63 and average days to sell inventory to 1 decimal place, e.g. 65.1.) 300 Average days to sell inventory May 26, 2023 $200 2025 times days 2024 times daysarrow_forward
- What should Cake report as cost of goods sold for 2022? * Cake Company sells one product which it purchases from various suppliers. The trial balance on December 31, 2022 included the following accounts: Sales (100,000 units at P150) Sales discount Purchase Purchase discount The inventory purchases during 2022 were as follows: Beginning inventory, January 1 Purchases, quarter ended March 31 Purchases, quarter ended June 30 Purchases, quarter ended Sept. 30 Purchases, quarter ended Dec. 31 Units 20,000 30,000 40,000 50,000 10,000 150,000 Unit cost 60 65 70 75 15,000,000 1,000,000 9,300,000 400,000 80 Total cost 1,200,000 1,950,000 2,800,000 3,750,000 800,000 10,500,000 Cake's accounting policy is to report inventory in its financial statements at the lower of cost or net realizable value. Cost is determined under the first-out method. Cake has determined that, on December 31, 2022, the replacement cost of its inventory was P70 per unit and the net realizable value was P72 per unit. The…arrow_forwardSuppose 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…arrow_forwardH. Richards Company, a calendar yearend company, reported the following balances: Inventory Accounts payable December 31, 2021 $65,000 18,750 December 31, 2020 $72,500 12,500 Richards paid suppliers $122,500 during 2021. What was Richards' 2021 cost of goods sold?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning