Use the template provided to create the following:

Schedule 5: Cash Purchases Budget

Schedule 6: Direct Labor Budget

Schedule 7: Overhead Budget

Schedule 8: Selling and Administrative Expense Budget

Schedule 9: Ending Finished goods

Schedule 10: Budgeted cost of goods sold

Schedule 11: Cash Budget

Schedule 12: Budgeted Income Statement

Schedule 13: Budgeted Statement of Retained Earnings

Schedule 14: Budgeted Balance Sheet

Schedule 5: Cash Purchases Budget

Current Quarter Purchases: Cash

Purchases Payable: Cash Payments

Total Cash Outlay per Quarter:

Schedule 6: Direct Labor Budget

Units to be produced

DL needed per unit

DL hours needed

cost per hour

Total Budgeted Direct Labor (dollars)

Schedule 7: Overhead Budget

DL hours needed

VOH rate /hour

Budgeted variable OH

Depreciation

Other fixed costs

Budgeted fixed OH

Total budgeted OH expense

Schedule 8: SG&A Budget

Units sold

Variable Selling & Administrative Rate

Budgeted Variable Selling & Administrative Costs

Depreciation

Other SG&A

Budgeted Fixed Selling & Administrative Costs

Total budgeted SG&A expense

Schedule 9: Ending Finished goods

Ending Balances: Inventory - DM, DL

DM - Cement

DM - Plaster

Direct Labor

Total Per Unit Inventory Costs:

Units in Ending Inventory:

Ending Inventory: DM, DL

Ending Balance: Inventory - Overhead

Variable Overhead

Fixed Overhead

Total Per Unit Inventory Costs:

Units in Ending Inventory:

Ending Inventory: Overhead

Total Ending Inventory Balance: Finished Goods

Schedule 10: Budgeted COGS

Beginning Balance: Finished Goods

Costs incurred during the period

Direct materials used - cement

Direct materials used - plaster

Direct labor used

Overhead - total

Cost of Goods Available For Sale

Ending Inventory

Cost of Goods Sold

Schedule 11: Cash Budget

Cash Sources:

Beginning Balance: Cash

Cash Receipts

Cash available for use

Cash Uses:

Disbursements for purchases

Direct Labor

Overhead payments

Sales & General Administrative Payments

Taxes Paid

Dividends paid

Equipment purchases

Total Cash Disbursements

Cash Balance - pre debt

Loans (repayments)

Interest Payments on Loans

Net Borrowing Impact on Cash

Ending Balance: Cash

Schedule 12: Budgeted income statement

Sales

Cost of Goods Sold

Gross Margin

Selling and General Administrative Expenses

Interest Expense

Net Income before Taxes

Tax Expense

Net Income

Schedule 13: Budgeted Retained Earnings

Retained Earnings Calculation

Beginning Balance: RE

Plus: Net Income

Less: Dividends Paid

Retained Earnings

Schedule 14: Budgeted Balance sheet

Cash

Accounts Receivable

Inventory

Raw materials

Finished Goods

PP&E

Land

Building and Equipment

Accumulated Depreciation

Acct Payable

Tax Payable

Capital stock

RE

Total L&SE