Question

Profitability Analysis Kolby Enterprises reports the following information on its income statement: L04 Net sales ......... . ......... . $250,000 150,000 50,000 Administrative expenses ...... . . $10,000 15,000 10,000 Cost of goods sold .. . . .. . . .. . . Other income .. . . .. . . .. . .. . . . Selling expenses ............ . Other expense .............. . Required Calculate Kolby 's gross profit percentage and return on sales ratio. Explain what each ratio tells us about Kolby 's performance. Kolby is planning to add a new product and expects net sales to be $45,000 and cost of goods to be $38,000. No other income or expenses are expected to change. How will this affect Kolby 's gross profit percentage and return on sales ratio

Answer 1

Answer:

Gross profit percentage = Gross profit / Net sales

= (Net sales - COGS) / Net sales

= (250,000 - 150,000) / 250,000

= 40%

Return on sales ratio = EBIT / Net sales

= (Gross profit + other income - Administrative expenses - Other expense - Selling expenses) / Net sales

= (250,000 - 150,000 + 15,000 - 10,000 - 10,000 - 50,000) / 250,000

= 18%

With new product:

Gross profit percentage = Gross profit / Net sales

= (Net sales - COGS) / Net sales

= (250,000 + 45,000  - 150,000 - 38,000) / (250,000 + 45,000)

= 36.3%

Return on sales ratio = EBIT / Net sales

= (Gross profit + other income - Administrative expenses - Other expense - Selling expenses) / Net sales

= (250,000 + 45,000  - 150,000 - 38,000 + 15,000 - 10,000 - 10,000 - 50,000) / (250,000 + 45,000)

= 52,000 / 295,000

= 17.6%