nesscourse.com/platform/mod/quiz/attempt.php?attempt -17757618page-1 Menu QUESTI
ID: 2522907 • Letter: N
Question
nesscourse.com/platform/mod/quiz/attempt.php?attempt -17757618page-1 Menu QUESTION 2 Tries remaining 1 Points out of 15.00 P Flag question 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 $120,000 $100,000 $60,000 $40,000 Contribution margin $20,000 Fixed costs Net income $5,000 $12,000 Variable cost ratio 0.50 0.22 Contribution margin ratio Break-even point (dollars) Margin of safety (dollars) s 0.40 $25,000 $20,000 Check Previous page Next pageExplanation / Answer
Answers
Column no.
B
C
D
E
F
2914
Case 1
Case 2
Case 3
Case 4
2915
Sales revenue
$ 1,20,000.00
$ 1,00,000.00
$ 50,000.00
$ 45,000.00
2916
Contribution margin
$ 60,000.00
$ 50,000.00
$ 20,000.00
$ 35,100.00
2917
Fixed Costs
$ 40,000.00
$ 45,000.00
$ 8,000.00
$ 19,500.00
2918
Net Income
$ 20,000.00
$ 5,000.00
$ 12,000.00
$ 15,600.00
2919
variable cost ratio
0.5
0.5
0.6
0.22
2920
Contribution margin ratio
0.5
0.5
0.4
0.78
2921
Break Even points (dollars)
$ 80,000.00
$ 90,000.00
$ 20,000.00
$ 25,000.00
2922
margin of Safety (dollars)
$ 40,000.00
$ 10,000.00
$ 30,000.00
$ 20,000.00
Column no./ Row
B
C
D
E
F
2914
Case 1
Case 2
Case 3
Case 4
2915
Sales revenue
120000
100000
=+E2916/E2920
=+F2921+F2922
2916
Contribution margin
60000
=+D2915*D2920
20000
=+F2915*F2920
2917
Fixed Costs
40000
=+D2916-D2918
=+E2916-E2918
=+F2921*F2920
2918
Net Income
=+C2916-C2917
5000
12000
=+F2916-F2917
2919
variable cost ratio
=1-C2920
0.5
=1-E2920
0.22
2920
Contribution margin ratio
=+C2916/C2915
0.5
0.4
=1-F2919
2921
Break Even points (dollars)
=+C2917/C2920
=+D2917/D2920
=+E2917/E2920
25000
2922
margin of Safety (dollars)
=+C2915-C2921
=+D2915-D2921
=+E2915-E2921
20000
Column no.
B
C
D
E
F
2914
Case 1
Case 2
Case 3
Case 4
2915
Sales revenue
$ 1,20,000.00
$ 1,00,000.00
$ 50,000.00
$ 45,000.00
2916
Contribution margin
$ 60,000.00
$ 50,000.00
$ 20,000.00
$ 35,100.00
2917
Fixed Costs
$ 40,000.00
$ 45,000.00
$ 8,000.00
$ 19,500.00
2918
Net Income
$ 20,000.00
$ 5,000.00
$ 12,000.00
$ 15,600.00
2919
variable cost ratio
0.5
0.5
0.6
0.22
2920
Contribution margin ratio
0.5
0.5
0.4
0.78
2921
Break Even points (dollars)
$ 80,000.00
$ 90,000.00
$ 20,000.00
$ 25,000.00
2922
margin of Safety (dollars)
$ 40,000.00
$ 10,000.00
$ 30,000.00
$ 20,000.00
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.