Fleoble budget fr seling and adminstiative expenses for a service company Digital Sonons inc u fesibie...

Transcribed Image Text:

Fleoble budget fr seling and adminstiative expenses for a service company Digital Sonons inc u fesibie udgets that are besed on the fotowing data Sales commistiore 8% of sales Advertising expense 15% of sales Mecelaneous administrative expeme $9,000 per month plus S of sales Office saleries experse $51,000 par month Customer support expenses Research and development expense $22,000 per month plus 20% of sales $72,000 per month Ths formation has been collected in the Microsoft Excel Online e Open the spreadsheet, pertorm the required analysis, and input your anewers in the question below. Open sereedhe rapara fesible oetling and edminstrative expenses budget for Dctober for sales volumes of s400,000, s00,000, end 1.000,000. (Ve Eshibit 5 ana mode) Enter all amounts as postive nembers Digital Solutions Inc. Fiexible Selling and Administrative Expenses ludget For the Month Ending October 31 Ttal ale $400,000 SH00.000 $1,000,000 Variabie cost nales commisions Advertising ergense Minsellaneousdministative pense Customer support expe es Total variable cost Fed ct Advertising spenss MiscellaneeuIs administrative expense Customer support expenses Total variable cost Foxed cost Miscellancous administrative expense office salaries expense Customer suppert expenses Research and development expense Total fixed cost Total selling and edministrative expenses Fleoble budget fr seling and adminstiative expenses for a service company Digital Sonons inc u fesibie udgets that are besed on the fotowing data Sales commistiore 8% of sales Advertising expense 15% of sales Mecelaneous administrative expeme $9,000 per month plus S of sales Office saleries experse $51,000 par month Customer support expenses Research and development expense $22,000 per month plus 20% of sales $72,000 per month Ths formation has been collected in the Microsoft Excel Online e Open the spreadsheet, pertorm the required analysis, and input your anewers in the question below. Open sereedhe rapara fesible oetling and edminstrative expenses budget for Dctober for sales volumes of s400,000, s00,000, end 1.000,000. (Ve Eshibit 5 ana mode) Enter all amounts as postive nembers Digital Solutions Inc. Fiexible Selling and Administrative Expenses ludget For the Month Ending October 31 Ttal ale $400,000 SH00.000 $1,000,000 Variabie cost nales commisions Advertising ergense Minsellaneousdministative pense Customer support expe es Total variable cost Fed ct Advertising spenss MiscellaneeuIs administrative expense Customer support expenses Total variable cost Foxed cost Miscellancous administrative expense office salaries expense Customer suppert expenses Research and development expense Total fixed cost Total selling and edministrative expenses

Answer rating: 100% (QA)

Digital Solution Inc Flexible Selling and Administrative Expenses Bud... View the full answer