Provide the missing data in the following table for a distri

Provide the missing data in the following table for a distributor of martial arts products: (Enter \"ROI\" answers to one decimal place.) Division Bravo $ 393,000 $ 31,440 Charlie Alpha Sales Net operating income Average operating assets Margin Turnover Return on investment $45,850 356,000 71% 41% 6.0 times times times 24.0% 17.5% ROI

Solution

Alpha

Asset Turnover = Net sales / Total Assets

6 = Net sales / 356000

Net sales = 356000*6=2136000

Margin = Net Operating income/Net sales

4%=Net Operating income/2136000

Net Operating income = 2136000*4%=85440

Return on investment = Net Operating income/Total Asset

=85440/356000=24%

Bravo

Margin = Net Operating income/Net sales

=31440/393000=8%

Return on investment = Net Operating income/Total Asset

24%=31440/Total Asset

Total Assets = 31440/24%=131000

Turnover = Net sales / Total Assets

=393000/131000=3

Charlie

Margin = Net Operating income/Net sales

Net Sales = Net Operating income/Margin

45850/7%=655000

Return on investment = Net Operating income/Total Asset

17.5%=45850/ Total Asset

Total Asset = 45850/17.5%=262000

Turnover = Net sales / Total Assets

=655000/262000=2.5