Question

In: Accounting

Exercise 8-6 Selling and Administrative Expense Budget Weller Company's budgeted unit sales for the upcoming fiscal...

Exercise 8-6 Selling and Administrative Expense Budget

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Budgeted unit sales 15,000 16,000 14,000 13,000

The company’s variable selling and administrative expense per unit is $2.50. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $35,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $8,000 will be paid in the second quarter.

Required:

Prepare the company’s selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.)

Weller Company
Selling and Administrative Expense Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Budgeted unit salesselected answer correct 15,000selected answer correct 16,000selected answer correct 14,000selected answer correct 13,000selected answer correct 58,000selected answer correct
Variable selling and administrative expense per unit $2.50selected answer correct $2.50selected answer correct $2.50selected answer correct $2.50selected answer correct $2.50selected answer correct
Variable selling and administrative expense $37,500selected answer correct $40,000selected answer correct $35,000selected answer correct $32,500selected answer correct $145,000selected answer correct
Fixed selling and administrative expenses:
Advertisingselected answer correct 8,000selected answer correct 8,000selected answer correct 8,000selected answer correct 8,000selected answer correct 32,000selected answer correct
Executive salariesselected answer correct 35,000selected answer correct 35,000selected answer correct 35,000selected answer correct 35,000selected answer correct 140,000selected answer correct
Depreciationselected answer correct 20,000selected answer correct 20,000selected answer correct 20,000selected answer correct 20,000selected answer correct 80,000selected answer correct
Insuranceselected answer correct 5,000selected answer correct 0selected answer correct 0selected answer correct
Property taxesselected answer correct 0selected answer correct 8,000selected answer correct 0selected answer correct 0selected answer correct 8,000selected answer correct
Total fixed selling and administrative expenses 68,000selected answer correct 71,000selected answer correct 63,000selected answer correct
Total selling and administrative expenses 105,500selected answer correct 111,000selected answer correct 95,500selected answer correct
Less: Depreciationselected answer correct
Cash disbursements for selling and administrative expenses

Solutions

Expert Solution


Related Solutions

Exercise 8-6 Selling and Administrative Expense Budget [LO8-7] Weller Company's budgeted unit sales for the upcoming...
Exercise 8-6 Selling and Administrative Expense Budget [LO8-7] Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 21,000 28,000 19,000 19,000 The company’s variable selling and administrative expense per unit is $2.00. Fixed selling and administrative expenses include advertising expenses of $14,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of...
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...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 35,000 37,000 28,000 33,000 The company’s variable selling and administrative expense per unit is $3.40. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $34,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 21,000 28,000 19,000 19,000 The company’s variable selling and administrative expense per unit is $2.00. Fixed selling and administrative expenses include advertising expenses of $14,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 31,000 33,000 24,000 29,000 The company’s variable selling and administrative expense per unit is $3.00. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $50,000 per quarter, and depreciation of $30,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
The budgeted unit sales of Weller Company for the upcoming fiscal year are provided below: 1st...
The budgeted unit sales of Weller Company for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter   Budgeted unit sales 24,000 25,000 21,000 22,000 The company’s variable selling and administrative expense per unit is $2.30. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $23,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and...
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...
he budgeted unit sales of ToneV Company for the upcoming fiscal year are provided below: 1St...
he budgeted unit sales of ToneV Company for the upcoming fiscal year are provided below: 1St Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted Unit Sale 22,000 21,000 24,000 23,000 The company’s variable selling and administrative expenses per unit are $1.80. Fixed selling and administrative expenses include advertising expenses of $18,000 per quarter, executive salaries of $47,000 per quarter, and depreciation of $14,000 per quarter. In addition, the company will make insurance payments of $8,000 in the 2nd quarter and...
Prepare a sales, production, direct materials, direct labor, overhead, and selling & administrative expense budget by...
Prepare a sales, production, direct materials, direct labor, overhead, and selling & administrative expense budget by quarter for the year 2020 for the Budgets R Us Co. using the following assumptions: Sales quantity by quarter: 10,000, 11,000, 12,000, 13,000, 14,000, 15,000. Selling price per unit = $20. Ending FG inventory = 10%. RM pounds per unit = 4. Ending RM inventory = 20%. RM price per pound = $2 Direct labor hours per unit = 2 Direct labor hourly rate...
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 $ $ $ $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT