In: Accounting
Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions | 8% of sales |
Advertising expense | 15% of sales |
Miscellaneous administrative expense | $10,000 per month plus 4% of sales |
Office salaries expense | $50,000 per month |
Customer support expenses | $20,000 per month plus 30% of sales |
Research and development expense | $75,000 per month |
Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use Exhibit 5 as a model.)
Digital Solutions Inc. | |||
Flexible Selling and Administrative Expenses Budget | |||
For the Month Ending October 31 | |||
Total sales | $500,000 | $750,000 | $1,000,000 |
Variable cost: | |||
$fill in the blank 2 | $fill in the blank 3 | $fill in the blank 4 | |
fill in the blank 6 | fill in the blank 7 | fill in the blank 8 | |
fill in the blank 10 | fill in the blank 11 | fill in the blank 12 | |
fill in the blank 14 | fill in the blank 15 | fill in the blank 16 | |
Total variable cost | $fill in the blank 17 | $fill in the blank 18 | $fill in the blank 19 |
Fixed cost: | |||
$fill in the blank 21 | $fill in the blank 22 | $fill in the blank 23 | |
fill in the blank 25 | fill in the blank 26 | fill in the blank 27 | |
fill in the blank 29 | fill in the blank 30 | fill in the blank 31 | |
fill in the blank 33 | fill in the blank 34 | fill in the blank 35 | |
Total fixed cost | $fill in the blank 36 | $fill in the blank 37 | $fill in the blank 38 |
Total selling and administrative expenses | $fill in the blank 39 | $fill in the blank 40 | $fill in the blank 41 |