70.2K

Verified Solution

Link Copied!

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 $10,500 per month plus 4% of sales Office salaries expense $55,000 per month Customer support expenses $18,000 per month plus 32% of sales Research and development expense $73,000 per month This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your weathe question below X HL Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000 $900,000, and $1.200.000 Enter all amounts as positive numbers Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, 5900,000, and $1,200,000. (Use Exhibit 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 $500,000 $900,000 Variable cost: $1,200,000 Sales commissions 35,000 $ 63,000 84,000 Advertising expense 75,000 135,000 180,000 Miscellaneous administrative expense 30,500 x 46,500 x 58,500 x Customer support expenses 178,000 X 306,000 X 102,000 x Total variable cost 318,500 X 550,500 X 5 724,500 X Fixed cost: Miscellaneous administrative expense 10,500 10,500 5 10,500 Office salaries expense 55,000 55,000 55,000 18,000 Customer support expenses 18.000 18,000 73,000 Research and development expense 71000 73,000 156,500 156,500 156,500 Totalfixed cost 475,000 X 707.000 x 1.000 x Total selling and administrative expenses

Answer & Explanation Solved by verified expert

See Answer