2:46 Week 4 - Assignment A 1. EX.08.04.ALGO 2. BE.08.01.ALGO 3. EX.08.02.ALGO 4. EX.08.03.ALGO 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 15% of sales 20% of sales $5,500 per month plus 12% of sales $30,000 per month $14,000 per month plus 20% of sales $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 Variable cost: Total variable cost Fixed cost: $400,000 $500,000 $600,000 Total fixed cost Total selling and administrative expenses $ QQQ 2:46 Week 4 - Assignment A 1. EX.08.04.ALGO 2. BE.08.01.ALGO 3. EX.08.02.ALGO 4. EX.08.03.ALGO 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 20 minutes $135,000 per month $30,000 per month $18 per hour Prepare a flexible budget for 15,000, 19,000, and 23,000 filing cabinets for the month ending February 28 in the Assembly Department similar to Exhibit 5. Round your final answers to the whole dollar, if required. Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data) Units of production 15,000 19,000 23,000 Variable cost: Total variable cost Fixed cost: Total fixed cost Total department costs Progress: 1/4 items Next 2:46 Week 4 - Assignment A 1. EX.08.04.ALGO 2. BE.08.01.ALGO 3. EX.08.02.ALGO 4. EX.08.03.ALGO Flexible Budgeting At the beginning of the period, the Fabricating Department budgeted direct labor of $117,000 and equipment depreciation of $45,000 for 7,800 hours of production. The department actually completed 10,500 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.