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 Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense 14% of sales 18% of sales Print Item $5,000 per month plus 12% of sales $28,000 per month $13,000 per month plus 20% of sales $30,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 4 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Line Item Description Total sales Variable cost: Total variable cost Fixed cost: Amount Amount Amount $400,000 $500,000 $600,000 888 Check My Work 4 more Check My Work uses remaining eBook Office salaries expense Customer support expenses Research and development expense Show Me How $28,000 per month Print Item $13,000 per month plus 20% of sales $30,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 4 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Line Item Description Total sales Variable cost: Total variable cost Fixed cost: Total fixed cost Total selling and administrative expenses Amount Amount Amount $400,000 $500,000 $600,000 1000000 0000000000 00000000000 Flexible budget for assembly department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet Supervisor salaries Depreciation Direct labor rate 30 minutes $144,000 per month $16,000 per month $15 per hour Prepare a flexible budget for 11,000, 14,000, and 17,000 filing cabinets for the month ending February 28 in the Assembly Department, similar to Exhibit 4. Round your final answers to the whole dollar, if required. Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data) Line Item Description Amount Amount Amount 11,000 14,000 17,000 Units of production Variable cost: Total variable cost Fixed cost 38 Total fixed cost Total department costs 10000 0000 0000