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 14% of sales 20% of sales $5,500 per month plus 12% of sales $28,000 per month $13,000 per month plus 20% of sales $32,000 per month Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.)

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 6% of sales Advertising expense 14% of sales Miscellaneous administrative expense $11,000 per month plus 4% of sales Office salaries expense $52,000 per month Customer support expenses $18,000 per month plus 31% 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. Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $600,000, $900,000, and $1,000,00o. (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 $900,000 $1,000,000 Variable cost:…

Preparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $19,800,000. There is a 4% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses Fixed expenses: Salaries Utilities Office spacе Advertising Total fixed expenses Total selling and administrative expenses

Refer to the picture for the problem and template.

Flexible Budget for Selling and Administrative Expenses for a Service Company

(2) Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales Advertising expense 16% of sales Miscellaneous administrative expense $8,000 per month plus 5% of sales Office salaries expense $50,000 per month Customer support expenses $18,000 per month plus 32% of sales Research and development expense $73,000 per month   Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $900,000, and $1,100,000. (Use Exhibit 5 as a model.) Enter all amounts as positive numbers.

Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 9% of sales Advertising expense 15% of sales Miscellaneous administrative expense $1,450 per month plus 3% of sales Office salaries expense $14,000 per month Customer support expenses $2,050 plus 4% of sales Research and development expense $4,500 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $90,000, $115,000, and $135,000. Daybreak Technologies Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending April 30 Total sales $90,000 $115,000 $135,000 Variable cost: Sales commissions 8,100 10,350 12,150 Advertising expense 13,500 17,250 20,250 Miscellaneous administrative expense 2,700 3,450 4,050 Customer support expenses 3,600 4,600 5,400 Total variable cost Fixed cost: Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Total fixed cost…

Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000, $350,000, and $480,000, based on the following data: Sales commissions 7% of sales Sales manager's salary $62,000 per month Advertising expense $70,000 per month Shipping expense 2% of sales Miscellaneous selling expense $2,500 per month plus 1/2% of sales Podism Company Monthly Selling Expense Budget Sales volume $270,000 $350,000 $480,000 Variable expense: Sales commissions х X Shipping expense X Miscellaneous selling expense Total variable expense Fixed expense: Sales manager's salary x $ Advertising expense X Miscellaneous selling expense Total fixed expense %$4 Total selling expense $ X

Please help me

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 15% of sales Advertising expense 18% of sales Miscellaneous administrative expense $9,000 per month plus 12% of sales Office salaries expense $29,000 per month Customer support expenses $12,000 per month plus 20% of sales Research and development expense $32,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Total sales $400,000 $500,000 $600,000 Variable cost:         $ $ $                         Total variable cost $ $ $ Fixed cost:         $ $ $                         Total fixed cost $ $ $ Total selling and administrative…