Question

In: Accounting

Elbert Company classifies its selling and administrative expense budget into variable and fixed components. Variable expenses...

Elbert Company classifies its selling and administrative expense budget into variable and fixed components. Variable expenses are expected to be $25,830 in the first quarter, and $5,100 increments are expected in the remaining quarters of 2017. Fixed expenses are expected to be $42,100 in each quarter.

Prepare the selling and administrative expense budget by quarters and in total for 2017.


Quarter

1

2

3

4

Year

Variable expenses

$ $ $ $ $

Fixed expenses

Total selling and administrative expenses

$ $ $ $ $

Solutions

Expert Solution

Solution

ELBERT COMPANY
Selling and Administrative Expense Budget
For the Year Ending December 31, 2017
Quarter
1 2 3 4 Year
Variable Expenses $         25,830.00 $        30,930.00 $        36,030.00 $       41,130.00 $     133,920.00
Fixed Expenses $         42,100.00 $        42,100.00 $        42,100.00 $       42,100.00 $     168,400.00
Total Selling and Administrative Expenses $         67,930.00 $        73,030.00 $        78,130.00 $       83,230.00 $     302,320.00

Related Solutions

Brief Exercise 9-7 Elbert Company classifies its selling and administrative expense budget into variable and fixed...
Brief Exercise 9-7 Elbert Company classifies its selling and administrative expense budget into variable and fixed components. Variable expenses are expected to be $26,770 in the first quarter, and $5,240 increments are expected in the remaining quarters of 2020. Fixed expenses are expected to be $41,680 in each quarter. Prepare the selling and administrative expense budget by quarters and in total for 2020. ELBERT COMPANY Selling and Administrative Expense Budget Quarter 1 2 3 4 Year $ $ $ $...
irkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget....
irkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,800 units quarter 1; 22,100 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,900, office salaries $6,160, depreciation $4,490, insurance $2,080, utilities $880, and repairs expense $670. 4. Unit selling price: $24....
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary...
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses $0 $0 $0 Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6 [The following information applies to the questions displayed below.] Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2008, the following data are developed:       Sales:                                                                20,000 units Unit selling price:                                                       RM35 Variable costs per RM of sales:             Sales commissions                                                 6%             Delivery expense                                                   2%             Advertising                                                            4% Fixed costs per quarter:             Sales salaries                                             RM24,000             Office salaries                                                  17,000             Depreciation                                                      6,000             Insurance                                                            2,000             Utilities                                                              1,000 Prepare a selling and administrative...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2016, the following data are developed: 1.   Sales: 20,000 units; unit selling price:                       $35 2.   Variable costs per dollar of sales:             Sales commissions                                                6%             Delivery expense                                                   2%             Advertising                                                             4% 3.   Fixed costs per quarter:             Sales salaries                                                $24,000             Office salaries                                                  17,000             Depreciation                                                       5,000             Insurance                                                           1,000             Utilities                                                               2,000 Instructions Prepare a selling...
Terrible Two's Inc. combines its operating expenses for budget purposes in a selling and administrative expenses...
Terrible Two's Inc. combines its operating expenses for budget purposes in a selling and administrative expenses budget. For the last six months of 2017, the following data are available: 1. Sales: 31,500 units in Quarter 3; 51,500 units in Quarter 4 2. Variable costs per dollar of sales; sales commissions 2.40%; delivery expenses 3.45%; and advertising 4.55% 3. Fixed costs per quarter: sales salaries $16,000; office salaries $3,050; depreciation $4,350; insurance $2,500; utilities $400, and repairs $250 4. Unit selling...
Exercise 22-12 Oriole Company combines its operating expenses for budget purposes in a selling and administrative...
Exercise 22-12 Oriole Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,500 units quarter 1; 22,200 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,500, office salaries $6,250, depreciation $4,340, insurance $2,000, utilities $860, and repairs expense $690. 4. Unit selling...
Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative...
Exercise 9-12 Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,800 units quarter 1; 22,100 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,900, office salaries $6,160, depreciation $4,490, insurance $2,080, utilities $880, and repairs expense $670. 4. Unit selling...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,200 units are planned to be sold in December. The variable selling and administrative expense is $3.10 per unit. The budgeted fixed selling and administrative expense is $60,800 per month, which includes depreciation of $6,720 per month. The remainder of the fixed selling and administrative expense represents current cash flows.Calculate the budgeted cash disbursements for selling and administrative expenses for December. Give your...
Which of the following statements is false with respect to the selling and administrative expense budget?...
Which of the following statements is false with respect to the selling and administrative expense budget? Multiple Choice It includes depreciation expense even though it is not a cash flow. It estimates the cash disbursements for selling and administrative expenses that appear in the cash budget. It includes estimated variable and fixed selling and administrative expenses. It impacts the budgeted cost of goods sold reported on the income statement.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT