REQUIRED] Chapter 22 Homework 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 10% of sales Advertising expense 17% of sales Miscellaneous administrative expense $11,500 per month plus 6% of sales Office salaries expense $47,000 per month Customer support expenses $23,000 per month plus 32% of sales Research and development expense $78,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. X Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $600,000, $700,000, and $1,000,000. (Use Exhibit 5 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 $600,000 $700,000 $1,000,000 Total sales $600,000 $700,000 $1,000,000 Variable cost: Sales commissions Advertising expense Miscellaneous administrative expense II Customer support expenses Total variable cost $ $ Fixed cost: Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Total fixed cost Total selling and administrative expenses $