Question

In: Accounting

Provide the missing data in the following table for a distributor of martial arts products: (Round...

Provide the missing data in the following table for a distributor of martial arts products: (Round "Turnover" and "ROI" answers to 1 decimal place.)

Alpha Bravo Charlie

Sales ? $350,000 ?

Net Operating Income ? $35,000 $36,540

Average Operating Assets $473,000 ? ?

'Margin 5%   ? 9%

Turnover 5.0 ?   ?

Return on investment ? 25.0% 18%

Solutions

Expert Solution

For Alpha

Net operating income = ?

Sales = ?

Average operating assets = $473,000

Margin = 5%

Turnover = 5

Return on investment = ?

Return on investment = Margin x Turnover

= 5 x 5

= 25%

Return on investment = Net operating income/Average operating assets

25% = Net operating income/473,000

Net operating income = 473,000 x 25%

= $118,250

Margin = Net operating income/Sales

5% = 118,250/Sales

Sales = 118,250/5%

= $2,365,000

For Bravo

Net operating income = 35,000

Sales = $350,000

Average operating assets = ?

Margin = ?

Turnover = ?

Return on investment = 25%

Return on investment = Net operating income/Average operating assets

25% = 35,000/Average operating assets

Average operating assets = $140,000

Margin = Net operating income/Sales

= 35,000/350,000

= 10%

Turnover = Sales/Average operating assets

= 350,000/140,000

= 2.5

For charlie

Net operating income = 36,540

Sales = ?

Average operating assets = ?

Margin = 9%

Turnover = ?

Return on investment = 18%

Margin = Net operating income/Sales

9% = 36,540/Sales

Sales = $406,000

Return on investment = Net operating income/Average operating assets

18% = 36,540/Average operating assets

Average operating assets = 36,540/18%

= $203,000

Turnover = Sales/Average operating assets

= 406,000/203,000

= 2


Related Solutions

Provide the missing data in the following table for a distributor of martial arts products: (Enter...
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 Alpha Bravo Charlie Sales $347,500 Net operating income $48,650 $60,580 Average operating assets $477,000 Margin 7 % % 13 % Turnover 5.0 Return on investment (ROI) ROI for B 35.0% and for C 26.0%
Provide the missing data in the following table for a distributor of martial arts products: (Enter...
Provide the missing data in the following table for a distributor of martial arts products: (Enter "ROI" answers to one decimal place.) Division Alpha Bravo Charlie Sales $390,000 Net operating income $54,600 $95,550 Average operating assets $473,000 Margin 7 % % 13 % Turnover 6.0 times times times Return on investment (ROI) % 42.0 % 32.5 %
Provide the missing data in the following table for a distributor of martial arts products: (Enter...
Provide the missing data in the following table for a distributor of martial arts products: (Enter "ROI" answers to one decimal place.) Division Alpha Bravo Charlie Sales $305,000 Net operating income $30,500 $47,160 Average operating assets $426,000 Margin 5 % % 9 % Turnover 5.0 times times times Return on investment (ROI) % 25.0 % 18.0 %
Cost-Volume-Profit Relations: Fill in Missing Data Following are data from 4 different companies. Provide the missing...
Cost-Volume-Profit Relations: Fill in Missing Data Following are data from 4 different companies. Provide the missing data in each case Case A Case B Case C Case D Unit Sales 1,000 800 Answer Answer Sales revenue $20,000 $Answer $Answer $60,000 Variable cost per unit $10 $2 $14 $Answer Contribution margin $Answer $800 $Answer $Answer Fixed Costs $8,300 $Answer $100,000 $Answer Net income $Answer $600 $Answer $Answer Unit contribution margin $Answer $Answer $Answer $12 Break-even point (units) Answer Answer 4,000 2,000...
Fill in the missing values for this ANOVA summary table round to two decimal places: S.S....
Fill in the missing values for this ANOVA summary table round to two decimal places: S.S. d.f. M.S. F Between 2371.488 6 Within TOTAL 5843.488 37 S.S. d.f. M.S. F Between 576.45 3 Within TOTAL 2276.45 37 S.S. d.f. M.S. F Between 107.07 Within 5160 TOTAL 5695.35 65 S.S. d.f. M.S. F Between 7.664 Within 430 10 TOTAL 50
ROI: Fill in the Unknowns Provide the missing data in the following situations: Eastern Division Western...
ROI: Fill in the Unknowns Provide the missing data in the following situations: Eastern Division Western Division Southern Division Sales Answer $6,000,000 Answer Net operating income $180,000 $ 360,000 $120,000 Operating assets Answer Answer $600,000 Return on investment 25% 18% Answer % Return on sales 0.05 Answer 0.08 Investment turnover Answer Answer 2.5
Fill in the missing numbers in the following income statement: (Do not round intermediate calculations and...
Fill in the missing numbers in the following income statement: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g. 32.)    Sales   $ 644,000 Costs 345,500 Depreciation 96,200 EBIT $ Taxes (40%) Net income$ What is the OCF? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g. 32.)    OCF $    What is the depreciation tax shield? (Do not round intermediate calculations and round your answer to...
Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to...
Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into— Selling price Down payment Amount mortgage Rate Years Monthly payment Interest Principal Balance at end of month $150,000 $30,000 $120,000 7% 30 $ $ $ $
Cost-Volume-Profit Relations: Missing Data Following are data from 4 separate companies. Supply the missing data in...
Cost-Volume-Profit Relations: Missing Data Following are data from 4 separate companies. Supply the missing data in each independent case Case A Case B Case C Case D Unit Sales 1,000 800 Answer Answer Sales revenue $20,000 Answer Answer $60,000 Variable cost per unit $10 $2 $10 Answer Contribution margin Answer $800 Answer Answer Fixed Costs $8,100 Answer $60,000 Answer Net income Answer $600 Answer Answer Unit contribution margin Answer Answer Answer $13 Break-even point (units) Answer Answer 4,000 2,000 Margin...
Cost-Volume-Profit Relations: Missing Data Following are data from 4 separate companies. Supply the missing data in...
Cost-Volume-Profit Relations: Missing Data Following are data from 4 separate companies. Supply the missing data in each independent case. Case 1 Case 2 Case 3 Case 4 Sales revenue $90,000 $150,000 Answer Answer Contribution margin $45,000 Answer $40,000 Answer Fixed costs $30,000 Answer Answer Answer Net income Answer $15,000 $24,000 Answer Variable cost ratio Answer 0.40 Answer 0.60 Contribution margin ratio Answer Answer 0.25 Answer Break-even point (dollars) Answer Answer Answer $150,000 Margin of safety (dollars) Answer Answer Answer $125,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT