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 14% of sales Miscellaneous administrative expense $9,500 per month plus 6% of sales Ofce salaries expense $47,000 per month Customer support expenses $20,000 per month plus 29% 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. Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $800,000, and $1,200,000. (Use Exhibit 5 as a model.) Enter all amounts as positive numbers. } Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $800,000, and $1,200,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 $400,000 $800,000 $1,200,000 Variable cost: Sales commissions 28,000 56,000 84,000 Advertising expense 56,000 112,000 168,000 Miscellaneous administrative expense V V 33,500 X 57,500 X 81,500 X Customer support expenses 136,000 X 252,000 X 368,000 X Total variable cost 253,000 X $ 477,500 $ 701,500 X Fixed cost: Miscellaneous administrative expense Office salaries expense 47,000 47,000 47,000 Customer support expenses Research and development expense 79,000 79,000 V 79,000 Total fixed cost Total selling and administrative expenses