EXCELL

Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: 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 seling and administrative expenses budget for October for sales volumes of $500,000,$900,000, and $1,200,000. (Use Exhibit 4 as a model.) Enter all amounts as positive numbers. \$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 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{l} Total sales \\ Voriable cost: \end{tabular} & \multicolumn{3}{|c|}{$500,000} & \multicolumn{2}{|l|}{$900,000} & \multicolumn{2}{|l|}{$1,200,000} \\ \hline Sales commissions & $ & 500,000 & x & 900,000 & x & 1,200,000 & x \\ \hline Advertising expense - & & 45,000 & x & 81,000 & x & 108,000 & x \\ \hline Miscellaneous administrative expense - & & 85,000 & x & 153,000 & x & 204,000 & x \\ \hline Customer support expenses - & & 25,000 & x & 45,000 & x & 60,000 & x \\ \hline Total variable cost & s & 155,000 & x & 279,000 & x & 372,000 & x \\ \hline \end{tabular} Fixed cost: Miscellaneous administrative expense : Office salaries expense - Customer support expenses - Research and develonment expense - Total fixed cost Total selling and administrative expenses