Question

In: Finance

Using Inventory Analysis Tools AutoZone and O'Reilly are two competitors in the retail automotive parts industry....

Using Inventory Analysis Tools
AutoZone and O'Reilly are two competitors in the retail automotive parts industry.

AutoZone O'Reilly
Average 2018 Inventory $3,912,878 $3,101,572
2018 Sales 11,221,077 9,536,428
2018 Cost of goods sold 5,247,331 4,496,462
Average 2017 Inventory $3,757,001 $2,894,388
2017 Sales 10,888,676 8,977,726
2017 Cost of goods sold 5,149,056 4,257,043


Use 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 Margin
AutoZone O'Reilly
2018 Answer Answer
2017 Answer Answer



Round to answers to nearest whole number (day).

Days Inventory Outstanding
AutoZone O'Reilly
2018 Answer Answer
2017 Answer Answer

Solutions

Expert Solution

Note formula of gross profit margin =

SALES - COGS/ SALES

INVENTORY DAY OUTSTANDING =

(AVERAGE INVENTORY/ COGS )*365

PLEASE CHECK THE SALES FIGURES OF 2017 I THINK I PICK THE CORRECT VALUE . IF NOT CORRECT THEN RECTIFIED ACCORDINGLY .

BECAUSE OF SALES AMOUNT OF 2017 ARE MIXUP IN THE Q .


Related Solutions

AutoZone and O'Reilly are two competitors in the retail automotive parts industry. AutoZone O'Reilly Average 2015...
AutoZone and O'Reilly are two competitors in the retail automotive parts industry. AutoZone O'Reilly Average 2015 Inventory $3,280,868 $2,592,902 2015 Sales 10,187,340 7,966,674 2015 Cost of goods sold 4,860,309 3,804,031 Average 2014 Inventory $3,000,557 $2,464,918 2014 Sales 9,475,313 7,216,081 2014 Cost of goods sold 4,540,406 3,507,180 Use 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 Margin AutoZone O'Reilly 2015...
Jillian is the president of a company that makes small parts for the automotive industry. Customers...
Jillian is the president of a company that makes small parts for the automotive industry. Customers are primarily auto manufacturers. Jillian's cousin, Frank, works at the company as a sales representative. A promotion to the sales manager position is open. Frank has applied and so has Lisa, another sales representative. While both Frank and Lisa are good employees, they are skilled in different areas, but Lisa has better evaluations from supervisors. Lisa is great with technology and with placing orders....
Jillian is the president of a company that makes small parts for the automotive industry. Customers...
Jillian is the president of a company that makes small parts for the automotive industry. Customers are primarily auto manufacturers. Jillian's cousin, Frank, works at the company as a sales representative. A promotion to the sales manager position is open. Frank has applied and so has Lisa, another sales representative. While both Frank and Lisa are good employees, they are skilled in different areas, but Lisa has better evaluations from supervisors. Lisa is great with technology and with placing orders....
Sharpton Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a...
Sharpton Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labour-hours. On December 10, 2015, the company’s controller made a preliminary estimate of the predetermined overhead rate for 2016. The new rate was based on the estimated total manufacturing overhead cost of $3,402,000 and the estimated 63,000 total direct labour-hours for 2016: Predetermined overhead rate = 3,402,000/63,000 = $54 per direct labour...
Sharpton Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a...
Sharpton Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. On December 10, 2015, the company's controller made a preliminary estimate of the predetermined overhead rate for 2016. The new rate was based on the estimated total manufacturing overhead cost of $3,402,000 and the estimated 63,000 total direct labor-hours for 2016:             Predetermined overhead rate = $2,475,000/52,000 hours                                                            =...
Gibson Fabricators Corporation Gibson Fabricators Corporation manufactures a variety of parts for the automotive industry. The...
Gibson Fabricators Corporation Gibson Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labour-hours. On the December 10, 2019, the company’s controller made a preliminary estimate of the predetermined overhead rate for 2020. The new rate was based on the estimated total manufacturing overhead cost of $2,475,000 and the estimated 52,000 total direct labourhours for 2020: Predetermined overhead rate = $2,475,000/ 52,000...
Johnson Inc. is a wholesale company selling special parts for the automotive industry. The company uses...
Johnson Inc. is a wholesale company selling special parts for the automotive industry. The company uses weighted-average and a perpetual inventory system. Its inventory records for part SA-123 show the following transactions for the month of May 2020: Date Transaction Units Purchased Unit Cost Units Sold Unit Selling Price May 1 Balance 120 $7.00 May 10 Purchase 500 $7.20 May 15 Sale (100) $12.40 May 21 Sale (150) $12.50 May 23 Purchase 250 $7.30 Required: Assuming Johnson Inc. makes all...
ompare the 2014 inventory turnover results for two or more publicily traded companies. Examples: 1)AutoZone (a...
ompare the 2014 inventory turnover results for two or more publicily traded companies. Examples: 1)AutoZone (a Memphis based company with Advance Auto, . Write an executive summary(two pages) detaling the respective inventory turnover ratios for the given period, giving the equivalent number of days of inventory for each company, and the potential financial impact if the under-performing company could match the inventory turnover ratio of the higher-performing company. Assume a 25% carrying cost ratio. Be careful to use the correct...
Compare the 2014 inventory turnover results for two or more publicily traded companies. Examples: 1)AutoZone (a...
Compare the 2014 inventory turnover results for two or more publicily traded companies. Examples: 1)AutoZone (a Memphis based company with Advance Auto, 2) Apple, Dell, And Best Buy, 3) Walmart and Target. Write an executive summary(two pages) detaling the respective inventory turnover ratios for the given period, giving the equivalent number of days of inventory for each company, and the potential financial impact if the under-performing company could match the inventory turnover ratio of the higher-performing company. Assume a 25%...
Conduct the stock analysis as well as done in this firm "US automotive industry" , discussion...
Conduct the stock analysis as well as done in this firm "US automotive industry" , discussion Detailed on the stock replenishment methods and Detailed on the reasons and ways to control stock. (500 word only )
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT