Perform the following ratio analysis for NSI, Competitor A, and Competitor B for each of the 3 years (for relevant ratios use formulas provided in the textbook): Inventory turnover, days in inventory, reserve for spoilage as % of inventory. Cost of goods sold as a % of sales

Competitor A Competitor B NSI

2021. 2020 2019 2021 2020 2019 2021 2020 2019

Sales $1,500,000 $1,800,000 $1,600,000 $350,000 $450,000 $400,000 $3,200,000 $2,400,000 $2,000,000

COGS. $1,200,000 $1,215,000 $1,080,000 $280,000 $301,500 $268,000 $1,937,500 $1,500,000 $1,250,000

A/R $200,000 $200,000 $200,000. $50,000. $50,000 $50,000 $1,600,000. $800,000 $600,000

Allowance for DA $(8,000) $(8,000) $(8,000) $(2,000) $(2,000) $(2,000) $(50,000). $(50,000) $(50,000)

Inventory $105,000 $102,700 $101,000 $26,000. $24,000. $22,000. $200,000 $100,000 $98,000

Reserve for Spoilage $(10,500) $(5,135) $(5,000) $(2,600) $(1,200) $(1,100) $(10,000) $(5,000) $(3,000)

Answer rating: 100% (QA)

Answer Inventory turnover ratio cost of goods soldinventory NSI Competitor A Competitor B 2021 120... View the full answer