Question

provide the missing data in the following table for a distributor of martial arts products

Provide the missing data in the following table for a distributor of martial arts products: (Enter "Turnover" and "ROI" answers to 1 decimal place.) Division Charlie Bravo Alpha $ 256,000 Sales 57,720 35,840 $ $ Net operating income Average operating assets Margin Turnover Return on investment (ROI) $ 474,000 13% 7 % % 4.0 19.5 % % 28.0 %

Answer 1

Particulars Alpha Sales Division Bravo 18,96,000 S 2,56,000 1,32,720 S 35.840 4.74.000 $ 1.28,000 7% 14% S s Net operating Income Average Operating Assets Margin Turnover Return on Investment (ROI) Charlie S 4.44.000 S 57.720 $ 2.96.000 13% 1.5 19.50% 28% 28% Formulae margin =Net operating income/sales Turnover =sales/average operating assets ROI =Net operating income/Average operating assets

Workings ALPHA BRAVO CHARLIE ROI Turn over = sales average operating assets =Net operating income average Operating assets Sales 4 = sales 474000 Average operating assets=Net operating income ROI =$35.840 28% =$1,28,000 Margin =Net operating income Sales =Net operating Income Margin =$57.720 13% =$4,44,000 Sales = 4*$4,74,000 = $18,96,000 b) Margin ROI -Net operating Income Average operating Assets Margin =Net operating income Sales Net operating income =margin* sales =7%*$18.96.000 =$1,32,720 =Net operating income Sales =$35.840 $2,56,000 =14% Average Operating Assets =Net operating income ROI =$57.720 19.50% =52,96,000 C) ROI =Net operating Income Average operating Assets =$1.32.720 $474,000 = 28% Tum over = sales average operating assets =S2.56.000 $1,28,000 Turn over = sales average operating assets =54.44.000 $2,96,000 =1.5