Digital Solutions Inc. uses flexible budgets that are based on the following data:

Sales commissions

Advertising expense

Miscellaneous administrative expense

Office salaries expense

Customer support expenses

Research and development expense

$9\%$ of sales

$17\%$ of sales

$$8,000$ per month plus $3\%$ of sales

$$49,000$ per month

$$23,000$ per month plus $28\%$ of sales

$$71,000$ per month

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

Prepare a flexible selling and administrative expenses budget for October for sales volumes of $$600,000,$$$900,000,$ and $$1,200,000.($Use Exhibit $4$ as a model.$)$ Enter all amounts as positive numbers.

Digital Solutions Inc.

Flexible Selling and Administrative Expenses Budget

For the Month Ending October $31$

Total sales

Variable cost:

Sales commissions $$

Miscellaneous administrative expense $$

Office salaries expense $$

Customer support expenses $$

Research and development expense $$

Total fixed cost

Total selling and administrative expenses