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

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...
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 )
Provide an analysis regarding the opportunities in the Airline Industry. Using your analysis of the industry,...
Provide an analysis regarding the opportunities in the Airline Industry. Using your analysis of the industry, prepare a thorough list of opportunities in the industry. For example, weak competitive rivalry would be an opportunity in the industry. Be sure to explain why each is an opportunity for the industry.
Provide an analysis regarding the threats in the Airline industry. Using the industry analysis completed to...
Provide an analysis regarding the threats in the Airline industry. Using the industry analysis completed to this point, prepare a thorough list of threats in the industry. For example, a strong competitive rivalry would be a threat in the industry. Be sure to explain why each is a treat to the industry.
Industry and company analysis are essential tools of fundamental analysis for equity valuation. Explain how you...
Industry and company analysis are essential tools of fundamental analysis for equity valuation. Explain how you would use this type of analysis when developing the inputs in an equity valuation forecast model.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT