step$-$by$-$step solutions for every section of the budget and all quarters. Schedule $12$: Cash Budget detailed solutions to the budget $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline Schedule $8$: Selling and Administrative Expense Budget & Q$1$ & Q$2$ & Q$3$ & Q$4$ & Total $\backslash \backslash$

$\backslash$hline Units sold & & & & & $\backslash \backslash$

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

$\backslash$hline Budgeted variable S$\backslash$&A & & & & & $\backslash \backslash$

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

$\backslash$hline Other S$\backslash$&A & & & & & $\backslash \backslash$

$\backslash$hline Budgeted fixed S$\backslash$&A & & & & & $\backslash \backslash$

$\backslash$hline Total budgeted S$\backslash$&A expense & & & & & $\backslash \backslash$

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

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

$\backslash$hline Schedule $9$: Ending Finished goods & & & & & $\backslash \backslash$

$\backslash$hline & Amt. & Cost per & Total & & $\backslash \backslash$

$\backslash$hline Direct materials$-$cement & & & & & $\backslash \backslash$

$\backslash$hline Direct materials$-$plaster & & & & & $\backslash \backslash$

$\backslash$hline Direct labor & & & & & $\backslash \backslash$

$\backslash$hline Variable overhead & & & & & $\backslash \backslash$

$\backslash$hline Fixed overhead & & & & & $\backslash \backslash$

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

$\backslash$hline Units in El & & & & & $\backslash \backslash$

$\backslash$hline Cost of ending inventory & & & & & $\backslash \backslash$

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

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Schedule $10$: Budgeted cost of goods sold$\}$ & & & & $\backslash \backslash$

$\backslash$hline Direct materials used $-$ cement & $0$ & & & & $\backslash \backslash$

$\backslash$hline Direct materials used $-$ plaster & $0$ & & & & $\backslash \backslash$

$\backslash$hline Direct labor used & & & & & $\backslash \backslash$

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

$\backslash$hline Costs added & & & & & $\backslash \backslash$

$\backslash$hline Beginning FG inventory & & & & & $\backslash \backslash$

$\backslash$hline Available for sale & & & & & $\backslash \backslash$

$\backslash$hline Less El & & & & & $\backslash \backslash$

$\backslash$hline Cost of goods sold & & & & & $\backslash \backslash$

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

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Schedule $11$: Budgeted income statement$\}$ & & & & $\backslash \backslash$

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

$\backslash$hline less COGS & & & & & $\backslash \backslash$

$\backslash$hline Gross margin & & & & & $\backslash \backslash$

$\backslash$hline Selling and admin & & & & & $\backslash \backslash$

$\backslash$hline Interest expense & & & & & $\backslash \backslash$

$\backslash$hline Net income before tax & & & & & $\backslash \backslash$

$\backslash$hline Tax expense & & & & & $\backslash \backslash$

$\backslash$hline Net income & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline Schedule $12$: Cash Budget & Q$1$ & Q$2$ & Q$3$ & Q$4$ & Total $\backslash \backslash$

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

$\backslash$hline Beg Bal. Cash & & & & & $\backslash \backslash$

$\backslash$hline Cash Receipts & & & & & $\backslash \backslash$

$\backslash$hline Cash Available & & & & & $\backslash \backslash$

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

$\backslash$hline Cash disbursements & & & & & $\backslash \backslash$

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

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

$\backslash$hline S$\backslash$&A & & & & & $\backslash \backslash$

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

$\backslash$hline Dividends & $1,500$ & $1,500$ & $1,500$ & $1,500$ & $\backslash \backslash$

$\backslash$hline Purchase equip & & & & & $\backslash \backslash$

$\backslash$hline Total disbursements & & & & & $\backslash \backslash$

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

$\backslash$hline Ending cash balance & & & & & $\backslash \backslash$

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

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

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

$\backslash$hline Cash at end of peiod & & & & & $\backslash \backslash$

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

$\backslash$hline Total Borrowing & & & & & $\backslash \backslash$

$\backslash$hline

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