question archive Net vision uses flexible budgets that are based on the following data: Sales commissions
Subject:AccountingPrice:2.89 Bought3
Net vision uses flexible budgets that are based on the following data:
Sales commissions ............... 10% of sales
Advertising expense .............18% of sales
Miscellaneous selling expense ......... $ 2,800 per month plus 4% of sales
Office salaries expense .............. $ 18,000 per month
Office supplies expense ............. 3% of sales
Miscellaneous administrative expense ...... $2,200 per month plus 2% of sales
Prepare a flexible selling and administrative expenses budget for January 2012 for sales volumes of $ 100,000, $125,000 and $150,000.
|
A |
B |
C |
D |
1 |
NET VISION |
|||
2 |
Flexible Selling and Administrative Expenses Budget |
|||
3 |
For the Month Ending January 31, 2012 |
|||
4 |
Total sales |
$100,000 |
$125,000 |
$150,000 |
5 |
Variable cost: |
|
|
|
6 |
Sales commissions |
$ 10,000 |
$ 12,500 |
$ 15,000 |
7 |
Advertising expense |
18,000 |
22,500 |
27,000 |
8 |
Miscellaneous selling expense |
4,000 |
5,000 |
6,000 |
9 |
Office supplies expense |
3,000 |
3,750 |
4,500 |
10 |
Miscellaneous administrative expense |
2,000 |
2,500 |
3,000 |
11 |
Total variable cost |
$ 37,000 |
$ 46,250 |
$ 55,500 |
12 |
Fixed cost: |
|
|
|
13 |
Miscellaneous selling expense |
$ 2,800 |
$ 2,800 |
$ 2,800 |
14 |
Office salaries expense |
18,000 |
18,000 |
18,000 |
15 |
Miscellaneous administrative expense |
2,200 |
2,200 |
2,200 |
16 |
Total fixed cost |
$ 23,000 |
$ 23,000 |
$ 23,000 |
17 |
Total selling and administrative expenses |
$ 60,000 |
$ 69,250 |
$ 78,500 |