Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion.

Return to question

Weller Company's budgeted unit sales for next year are provided below:

$\backslash$begin$\{$tabular$\}\{$ccccc$\}$

& $1$st Quarter & $2$nd Quarter & $3$rd Quarter & $4$th Quarter $\backslash \backslash$

Budgeted unit sales & $15,000$ & $16,000$ & $14,000$ & $13,000$

$\backslash$end$\{$tabular$\}$

The company's variable selling and administrative expense per unit is $\backslash (\backslash$$ $2\mathrm{.}50\backslash ).$ Fixed selling and administrative expenses include advertising expenses of $\backslash (\backslash$$ $8,000\backslash )$ per quarter, executive salaries of $\backslash (\backslash$$ $35,000\backslash )$ per quarter, and depreciation of $\backslash (\backslash$$ $20,000\backslash )$ per quarter. In addition, the company will make insurance payments of $\backslash (\backslash$$ $5,000\backslash )$ in the first quarter and $\backslash (\backslash$$ $5,000\backslash )$ in the third quarter. Finally, property taxes of $\backslash (\backslash$$ $8,000\backslash )$ will be paid in the second quarter.

Required:

Prepare the company's selling and administrative expense budget for next year.

Note: Round "Per Unit" answers to $2$ decimal places.

Answer is not complete.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$c$|\}\{$Weller Company$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$c$|\}\{$Selling and Administrative Expense Budget$\}\backslash \backslash$

$\backslash$hline & $1$st Quarter & $2$nd Quarter & $3$rd Quarter & $4$th Quarter & Year $\backslash \backslash$

$\backslash$hline Budgeted unit sales & $15,000\backslash (>\backslash )$ & $16,000$ & $14,000$ & $13,000$ & $58,000\backslash \backslash$

$\backslash$hline Variable selling and administrative expense per unit & $\backslash$$ $2\mathrm{.}50$ & $\backslash$$ $2\mathrm{.}50$ & $2\mathrm{.}50$ & $\backslash$$ $2\mathrm{.}50>$ & $\backslash$$ $2\mathrm{.}50\backslash \backslash$

$\backslash$hline Variable selling and administrative expense & $\backslash$$ $37,500$ & $\backslash$$ $40,000$ & $\backslash$$ $35,000$ & $32,500$ & $\backslash$$ $145,000\backslash \backslash$

$\backslash$hline Fixed selling and administrative expenses: & & & & & $\backslash \backslash$

$\backslash$hline Advertising $($ & $8,000$ & $8,000$ & $8,000$ & $8,000$ & $32,000\backslash \backslash$

$\backslash$hline Executive salaries $\backslash (>\backslash )$ & $35,000$ & $35,000$ & $35,000$ & $35,000$ & $140,000\backslash \backslash$

$\backslash$hline Depreciation $($ & $20,000$ & $20,000$ & $20,000$ & $20,000$ & $80,000\backslash \backslash$

$\backslash$hline & & & & & $\backslash \backslash$

$\backslash$hline & & & & & $\backslash \backslash$

$\backslash$hline Total fixed selling and administrative expenses & $63,000*$ & $63,000*$ & $63,000*$ & $63,000\backslash (\backslash$cdot $\backslash )$ & $252,000*\backslash \backslash$

$\backslash$hline Total selling and administrative expenses & & & & & $\backslash \backslash$

$\backslash$hline & & & & & $\backslash \backslash$

$\backslash$hline Cash disbursements for selling and administrative expenses & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$