Question
In: Accounting
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.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Solutions
Expert Solution
Division A:
Turnover = Sales / Average operating assets
5 = Sales / 426,000
Sales = 5 × 426,000
= $2,130,000 (Answer)
Margin = (Net operating income / Sales) × 100
5 = (Net operating income / 2,130,000) × 100
0.05 = Net operating income / 2,130,000
Net operating income = 0.05 × 2,130,000
= $106,500 (Answer)
ROI = (Net operating income / Average operating assets) × 100
= (106,500 / 426,000) × 100
= 25.0 % (Answer)
Division B:
Margin = (Net operating income / Sales) × 100
= (30,500 / 305,000) × 100
= 10% (Answer)
ROI = (Net operating income / Average operating assets) × 100
25 = (30,500 / Average operating assets) × 100
0.25 = 30,500 / Average operating assets
Average operating assets = 30,500 / 0.25
= $122,000 (Answer)
Turnover = Sales / Average operating assets
= 305,000 / 122,000
= 2.5 (Answer)
Division C:
Margin = (Net operating income / Sales) × 100
9 = (47,160 / Sales) × 100
0.09 = 47,160 / Sales
Sales = 47,160 / 0.09
= $524,000 (Answer)
ROI = (Net operating income / Average operating assets) × 100
18 = (47,160 / Average operating assets) × 100
0.18 = 47,160 / Average operating assets
Average operating assets = 47,160 / 0.18
= $262,000
Turnover = Sales / Average operating assets
= 524,000 / 262,000
= 2 (Answer)
ekkarill92 answered 11 months agoRelated 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: (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%
(a) Fill in the missing blanks on the following ANOVA table. (Enter your answers as whole...
(a) Fill in the missing blanks on the following ANOVA table.
(Enter your answers as whole numbers except for the test statistic
value. Round the test statistic value to three decimal
places.)
ANOVA
Source
DF
SS
MS
F-Statistic
Regression
2
8
Error
(Residual)
180
Total
92
(b) How many explanatory variables were in this model? (Enter your
answer as a whole number.)
(c) What was the sample size of the data set this model was built
upon? (Enter your answer...
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...
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
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
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
$100,000
$90,000
Answer
Answer
Contribution margin
$40,000}
Answer
$20,000
Answer
Fixed Costs
$24,000
Answer
Answer
Answer
Net income
Answer
$7,000
$9,000
Answer
Variable cost ratio
Answer
0.50
Answer
0.20
Contribution margin ratio
Answer
Answer
0.40
Answer
Break-even point (dollars)
Answer
Answer
Answer
$20,000
Margin of safety (dollars)
Answer
Answer
Answer
$30,000
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance...
- TreeSetDemo IN JAVA PLEASE The following program can be done all in the main method. It...
- “I know headquarters wants us to add that new product line,” said Dell Havasi, manager of...
- A corporation made a coupon payment yesterday on its 9.8%-coupon, $1000 par value bonds that make...
- There are three securities in the market. The following chart shows their possible payoffs: State...
- A pension fund manager is considering three mutual funds. The first is a stock fund, the...
- The project manager develops a process improvement plan to encourage continuous process improvement during the life...
ADVERTISEMENT