Construct the sales budget Year $1,$ Quarter Year $1,$ Totals

$1234$

Budgeted unit sales $?????$

Selling price per unit $?????$

Total sales $?????$

Construct the schedule of expected cash collections Year $1,$ Quarter

$1234$ Year

Beginning balance accounts receivable $??$

First$-$quarter sales $???$

Second$-$quarter sales $???$

Third$-$quarter sales $???$

Fourth$-$quarter sales $??$

Total cash collections $?????$

Construct the production budget Year $1,$ Quarter

$1234$ Year

Budgeted unit sales $?????$

Add desired ending finished goods inventory $?????$

Total needs $?????$

Less beginning finished goods inventory $?????$

Required production in units $?????$

Construct the Direct Materials purchases budget Year $1,$ Quarter

$1234$ Year

Required production $($units$)?????$

Raw materials required to produce one unit $($pounds$)?????$

Production needs $($pounds$)?????$

Add desired ending inventory of raw materials $($pounds$)?????$

Total needs $($pounds$)?????$

Less beginning inventory of raw materials $($pounds$)?????$

Raw materials to be purchased $($pounds$)?????$

Cost of raw materials per pound $?????$

Cost of raw materials to be purchased $?????$

Construct the Direct Labor budget Year $1,$ Quarter

$1234$ Year

Required production in units $?????$

Direct Labor Hours per unit $?????$

Direct Labor Hours required for Production $?????$

Cost per DLHr $?????$

Total Cost of Direct Labor to be paid $?????$

Construct the Manufacturing Overhead Budget Year $1,$ Quarter

$1234$ Year

Budgeted Direct Labor Hours $?????$

Variable Overhead Rate $?????$

Variable Overhead Cost $?????$

Fixed Manufacturing Overhead $?????$

Total Manufacturing Overhead $?????$

Less Depreciation $?????$

Cash Disbursements for Manufacturing Overhead $?????$

Construct the schedule of expected DM cash payments Year $1,$ Quarter

$1234$ Year

Beginning balance accounts payable $??$

First$-$quarter purchases $???$

Second$-$quarter purchases $???$

Third$-$quarter purchases $???$

Fourth$-$quarter purchases $??$

Total cash disbursements for Direct Materials $?????$

Schedule of Expected Cash Flows Year $1,$ Quarter

$1234$ Year

Beginning Cash Balance $?????$

Expected Cash Inflows:

Cash from Customers $?????$

Cash from Bond Issuance $??$

Total Cash Available $?????$

Less cash disbursements:

Direct Materials $?????$

Direct Labor $?????$

Manufacturing Overhead $?????$

Selling & Administrative Expenses $?????$

Interest Paid on Bonds $???$

Total of Cash Disbursements $?????$

Ending Balance of Cash $?????$