Flexible budget for selling and administrative expenses for a service company

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

Sales commissions 7% of sales

Advertising expense 15% of sales

Miscellaneous administrative expense $8,000 per month plus 5% of sales

Office salaries expense $48,000 per month

Customer support expenses $17,000 per month plus 28% of sales

Research and development expense $79,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.

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