Using Inventory Analysis ToolsAutoZone and O'Reilly are two competitors in the retail automotive parts industry.AutoZoneO'ReillyAverage 2015 Inventory $3,290,867 $2,602,9012015 Sales10,265,1178,044,4512015 Cost of goods sold4,860,3093,804,031Average 2014 Inventory $3,010,556 $2,474,9172014 Sales9,553,090 7,293,8582014 Cost of goods sold4,540,406 3,507,180Use the information above to compute the companies' gross profit margin and days inventory outstanding for both years.Round answers to one decimal place (ex: 0.2345 = 23.5%).Gross Profit MarginAutoZoneO'Reilly20152014Round to answers to one decimal place.Days Inventory OutstandingO'ReillyAutoZone20152014

Answered: Image /qna-images/answer/45201d17-3a29-4f18-abb8-597c469a124a.jpg

Answered: Using Inventory Analysis Tools AutoZone…

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 12E

See similar textbooks

Similar questions

Inventory analysis Costco Wholesale Corporation (COST) and Wal-Mart Stores Inc. (WMT) compete against each other in general merchandise retailing, gas stations, pharmacies, and optical centers. Below is selected financial information for both companies from a recent year's financial statements (in millions): a. Determine for bom companies (1) the inventory turnover and (2) the days' sales in inventory. Round to one decimal place. b. Compare and interpret the inventory metrics computed in (a).
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?
Kulsrud Company would like to estimate the current inventory level. Using the gross profit method and the following information, estimate the current inventory level for Kulsrud Company. Goods available for sale 100,000 Net sales 150,000 Normal gross profit as a percent of sales 40%
Inventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?
A large manufacturer of truck and car tires recently changed its cost-flow assumption method for inventories at the beginning of 2014. The manufacturer has been in operation for almost 40 years, and for the last decade it has reported moderate growth in revenues. The firm changed from the LIFO method to the FIFO method and reported the following information (amounts in millions): REQUIRED Calculate the inventory turnover ratio for 2014 using the LIFO and FIFO cost-flow assumption methods. Explain why the costs assigned to inventory under LIFO at the end of 2013 and 2014 are so much less than they are under FIFO.
Lower of Cost or Market Shaw Systems sells a limited line of specially made products, using television advertising campaigns in large cities. At year end, Shaw has the following data for its inventory: Required: 1. Compute the carrying value of the ending inventory using the lower of cost or market rule applied on an item-by-item basis. 2. Prepare the journal entry required to value the inventory at lower of cost or market. 3. CONCEPTUAL CONNECTION What is the impact of applying the lower of cost or market rule on the financial statements of the current period? What is the impact on the financial statements of a subsequent period in which the inventory is sold?
LIFO and Inventory Pools On January 1, 2016, Grover Company changed its inventory cost flow method to the LIFO cost method from the FIFO cost method for its raw materials inventory. It made the change for both financial statement and income tax reporting purposes. Grover uses the multiple-pools approach under which it groups substantially identical raw materials into LIFO inventory pools. It uses weighted average costs in valuing annual incremental layers. The composition of the December 31, 2018, inventory for the Class F inventory pool is as follows: Inventory transactions for the Class F inventory pool during 2019 were as follows: On March 2, 2019, 4,800 units were purchased at a unit cost of 13.50 for 64,800. On September 1, 2019, 7,200 units were purchased at a unit cost of 14.00 for 100,800. A total of 15,000 units were used for production during 2019. The following transactions for the Class F inventory pool took place during 2020: On January 11, 2020, 7,500 units were purchased at a unit cost of 14.50 for 108,750. On May 14, 2020, 5,500 units were purchased at a unit cost of 15.50 for 85,250. On December 29, 2020, 7,000 units were purchased at a unit cost of 16.00 for 112,000. A total of 16,000 units were used for production during 2020. Required: 1. Prepare a schedule to compute the inventory (units and dollar amounts) of the Class F inventory pool at December 31, 2019. Show supporting computations in good form. 2. Prepare a schedule to compute the cost of Class F raw materials used in production for the year ended December 31, 2019. 3. Prepare a schedule to compute the inventory (units and dollar amounts) of the Class F inventory pool at December 31, 2020. Show supporting computations in good form.
Effects of Inventory Costing Methods Refer to the information for Tyler Company above. Required: 1. Which inventory costing method produces the highest amount for net income? 2. Which inventory costing method produces the lowest amount for taxes? 3. Which inventory costing method produces the highest amount for ending inventory? 4. How would your answers to Requirements 1-3 change if inventory prices declined during the period?
Lower of Cost or Market Garcia Company uses FIFO, and its inventory at the end of the year was recorded in the accounting records at $17,800. Due to technological changes in the market, Garcia would be able to replace its inventory for $16,500. Required: 1. Using the lower of cost or market method, what amount should Garcia report for inventory on its balance sheet at the end of the year? 2. Prepare the journal entry required to value the inventory at the lower of cost or market.
Inventory Write-Down Stiles Corporation uses the FIFO cost flow assumption and is in the process of applying the LCNRV rule for each of two products in its ending inventory. A profit margin of 30% on the selling price is considered normal for each product. Specific data for each product are as follows: Inventory Write-Down Use the information in E8-1. Assume that Stiles uses the LIFO cost flow assumption and is applying the LCM rule. Required: 1. What is the correct inventory value for each product? 2. Next Level With regard to requirement 1, what effect does the imposition of the constraints on market value have on the inventory valuations?
Continuing problem Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account Balances for Palisade Creek Co. as of May 1, 2016 (unless otherwise indicated), are as follows: 110 Cash 83,600 112 Accounts Receivable 233,900 115 Merchandise Inventory 624,400 116 Estimated Returns Inventory 28,000 117 Prepaid Insurance 16,800 118 Store Supplies 11,400 123 Store Equipment 569,500 124 Accumulated DepreciationStore Equipment 56,700 210 Accounts Payable 96,600 211 Salaries Payable 212 Customers Refunds Payable 50,000 310 Common Stock 100,000 311 Retained Earnings 585,300 312 Dividends 135,000 313 Income Summary 410 Sales 5,069,000 510 Cost of Merchandise Sold 2,823,000 520 Sales Salaries Expense 664,800 521 Advertising Expense 281,000 522 Depreciation Expense 523 Store Supplies Expense 529 Miscellaneous Selling Expense 12,600 530 Office Salaries Expense 382,100 531 Rent Expense 83,700 532 Insurance Expense 539 Miscellaneous Administrative Expense 7,800 During May, the last month of the fiscal year, the following transactions were completed: May 1. Paid rent for May, 5,000. 3. Purchased merchandise on account from Martin Co. terms 2/10t n/30, FOB shipping point, 36,000. 4. Paid freight on purchase of May 3, 600. 6. Sold merchandise on account to Korman Co., terms 2/10, n/30, FOB shipping point, 68,500. The cost of the merchandise sold was 41,000. 7. Received 22,300 cash from Halstad Co. on account. 10. Sold merchandise for cash, 54,000. The cost of the merchandise sold was 32,000. 13. Paid for merchandise purchased on May 3- 15. Paid advertising expense for last half of May, 11,000. 16. Received cash from sale of May 6. 19. Purchased merchandise for cash, 18,700. 19. Paid 33,450 to Buttons Co. on account 20. Paid Korman Co. a cash refund of 13,230 for returned merchandise from sale of May 6. The invoice amount of the returned merchandise was 13,500 and the cost of the returned merchandise was 8,000. Record the following transactions on Page 21 of the journal: 20. Sold merchandise on account to Crescent Co., terms 1/10, n/30, FOB shipping point, 110,000. The cost of the merchandise sold was 70,000. 21. For the convenience of Crescent Co., paid freight on sale of May 20. 2,300. 21. Received 42,900 cash from Gee Co. on account. May 21. Purchased merchandise on account from Osterman Co., terms 1/10, n/30, FOB destination. 88,000. 24. Returned of damaged merchandise purchased on May 21, receiving a credit memo from the seller for 5,000. 26. Refunded cash on sales made for cash. 7,500. The cost of the merchandise returned was 4,800. 28. Paid sales salaries of 56,000 and office salaries of 29,000. 29. Purchased store supplies for cash, 2,400. 30. Sold merchandise on account to Turner Co., terms 2/10, n/30, FOB shipping point, 78,750. The cost of the merchandise sold was 47,000. 30. Received cash from sale of May 20 plus freight paid on May 21. 31. Paid for purchase of May 21. less return of May 24. Instructions 1. Enter the balances of each of the accounts in the appropriate balance column of a four-column account. Write Balance in the item section, and place a check mark () in the Posting Reference column. Journalize the transactions for July, starting on Page 20 of the journal. 2. Post the journal to the general ledger, extending the month-end balances to the appropriate balance columns after all posting is completed. In this problem, you are not required to update or post to the accounts receivable and accounts payable subsidiary ledgers. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete (5) and (6). a. Merchandise inventory on May 31 570,000 b. Insurance expired during the year 12,000 c. Store supplies on hand on May 31 4,000 d. Depreciation for the current year 14,000 e. Accrued salaries on May 31: Sales salaries 7,000 Office salaries 6,600 13,600 f. The adjustment for customer returns and allowances is 60,000 for sales and 35,000 for cost of merchandise sold. 5. (Optional) Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 22 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a retained earnings statement, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 23 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. Insert the new balance in the retained earnings account. 10. Prepare a post-closing trial balance.

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

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

Publisher:

South-Western College Pub

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

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

Publisher:

South-Western College Pub

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS