Question

In: Accounting

Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8%...

Digital Solutions Inc. uses flexible budgets that are based on the following data:

Sales commissions 8% of sales
Advertising expense 15% of sales
Miscellaneous administrative expense $10,000 per month plus 4% of sales
Office salaries expense $50,000 per month
Customer support expenses $20,000 per month plus 30% of sales
Research and development expense $75,000 per month

Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use Exhibit 5 as a model.)

Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
Total sales $500,000 $750,000 $1,000,000
Variable cost:
$fill in the blank 2 $fill in the blank 3 $fill in the blank 4
fill in the blank 6 fill in the blank 7 fill in the blank 8
fill in the blank 10 fill in the blank 11 fill in the blank 12
fill in the blank 14 fill in the blank 15 fill in the blank 16
Total variable cost $fill in the blank 17 $fill in the blank 18 $fill in the blank 19
Fixed cost:
$fill in the blank 21 $fill in the blank 22 $fill in the blank 23
fill in the blank 25 fill in the blank 26 fill in the blank 27
fill in the blank 29 fill in the blank 30 fill in the blank 31
fill in the blank 33 fill in the blank 34 fill in the blank 35
Total fixed cost $fill in the blank 36 $fill in the blank 37 $fill in the blank 38
Total selling and administrative expenses $fill in the blank 39 $fill in the blank 40 $fill in the blank 41

Solutions

Expert Solution

Please comment for any explanation,

Thanks,


Related Solutions

Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 15%...
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 $30,000 per month Customer support expenses $14,000 per month plus 20% of sales Research and development expense $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 5 as a model.)...
Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 5%...
Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 5% of sales Advertising expense 25% of sales Miscellaneous administrative expense $1,450 per month plus 2% of sales Office salaries expense $14,000 per month Customer support expenses $2,050 plus 3% of sales Research and development expense 3,600 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $90,000, $115,000, and $135,000. Enter all amounts as positive numbers. Morningside Technologies...
Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15%...
Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15% of sales Advertising expense 18% of sales Miscellaneous administrative expense $8,500 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $32,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.)...
Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 6%...
Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 6% 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. Enter all amounts as positive numbers. Morningside Technologies...
Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15%...
Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15% of sales Advertising expense 18% of sales Miscellaneous administrative expense $5,500 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $30,000 per month Prepare a flexible selling and administrative expenses budget for March 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...
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 Advertising expense 18% of sales Miscellaneous administrative expense $8,000 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $31,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes...
Flexible Budget for Selling and Administrative Expenses Cloud Productivity Inc. uses flexible budgets that are based...
Flexible Budget for Selling and Administrative Expenses Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales Advertising expense 18% of sales Miscellaneous administrative expense $9,000 per month plus 12% of sales Office salaries expense $28,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $31,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes of $400,000, $500,000, and...
Exercise 8-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000...
Exercise 8-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (12,000 units) $ 2,604,000 Cost of goods sold Direct materials $ 300,000 Direct labor 516,000 Production supplies 324,000 Plant manager salary 100,000 1,240,000 Gross profit 1,364,000 Selling expenses Sales commissions 96,000 Packaging 168,000 Advertising 100,000 364,000 Administrative expenses Administrative salaries 150,000 Depreciation—office equip. 120,000 Insurance 90,000 Office rent 100,000...
Fallon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range...
Fallon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $169,900 to $211,000. Variable costs and their percentage relationship to sales are sales commissions 7%, advertising 4%, travel 4%, and delivery 1%. Fixed selling expenses will consist of sales salaries $34,700, depreciation on delivery equipment $7,500, and insurance on delivery equipment $1,900. Prepare a monthly selling expense flexible budget for each $13,700 increment of sales within the relevant range for the year ending...
Bluecap Co. uses a standard cost system and flexible budgets for control purposes. The following budgeted...
Bluecap Co. uses a standard cost system and flexible budgets for control purposes. The following budgeted information pertains to 2019: Denominator volume—number of units 9,000 Denominator volume—percent of capacity 90 % Denominator volume—standard direct labor hours (DLHs) 27,000 Budgeted variable factory overhead cost at denominator volume $ 103,700 Total standard factory overhead rate per DLH $ 15.10 During 2019, Bluecap worked 26,000 DLHs and manufactured 9,100 units. The actual factory overhead cost for the year was $13,000 greater than the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT