A. A company incurs selling expenses composed of a fixed amount per quarter and
ID: 2482713 • Letter: A
Question
A. A company incurs selling expenses composed of a fixed amount per quarter and a variable commission based on sales volume (shown below). What is the fixed quarterly sales expense and the commission % given only the following data? Please give an explanation.
Sales Selling Expense
Q1 20,000,000 2.050.000
Q2 12.500.000 1,400,000
Q3 22,000,000 2,000,000
Q4 16,000,000 1,000,000
B.If Management decides to increase sales commission by 35% and decrease fixed quarterly selling expenses by 30%, also assuming a 10% growth in sales compared to the prior year, what will next four quarters sales and selling expenses amount to as shown above?
Sales Selling Expense
Q1 ? ?
Q2 ? ?
Q3 ? ?
Q4 ? ?
Explanation / Answer
(A) We can find out unit variable cost based on high-low method.
Total cost, C = F + VQ where F: Fixed cost, V: Unit Selling commission, Q: Quantity
When output is highest (Q = 22,000,000):
2,000,000 = F + 22,000,000 x V ......(1)
When output is lowest (Q = 12,500,000):
1,400,000 = F + 12,500,000 x V ......(2)
(1) - (2) results: 600,000 = 9,500,000 x V
V = 0.0632, or 6.32%
F = 2,000,000 - (22,000,000 x 0.0632) = 2,000,000 - 1,390,400 = 609,600 (Fixed component)
(B)
New V = 6.32% x 1.35 = 0.0853 = 8.53%
New F = $609,600 x 70% = $426,720
(1) Q1
Sales = 20,000,000 x 1.1 = 22,000,000
Selling expense ($) = 426,720 + 0.0853 x 22,000,000 = 426,720 + 1,876,600 = 2,302,320
(2) Q2
Sales = 12,500,000 x 1.1 = 13,750,000
Selling expense ($) = 426,720 + 0.0853 x 13,750,000 = 426,720 + 1,172,875 = 1,599,595
(3) Q3
Sales = 22,000,000 x 1.1 = 24,200,000
Selling expense ($) = 426,720 + 0.0853 x 24,200,000 = 426,720 + 2,064,260 = 2,490,980
(4) Q4
Sales = 16,000,000 x 1.1 = 17,600,000
Selling expense ($) = 426,720 + 0.0853 x 17,600,000 = 426,720 + 1,501,280 = 1,928,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.