| Royal Company Master Budget | 2021 |
| April | | units |
| May | | units |
| June | | units |
| July | | units |
| August | | units |
| SALES BUDGET |
| | April | May | June | Quarter | July | August |
| Budgeted sales (units) |
| Selling price per unit |
| Total sales |
| SCHEDULE OF EXPECTED CASH COLLECTIONS |
| | April | May | June | Quarter |
| Accounts receivable beginning balance |
| April sales |
| April |
| May |
| May sales |
| May |
| June |
| June sales |
| June |
| Total cash collections |
| PRODUCTION BUDGET |
| | April | May | June | Quarter | July | August |
| Budgeted sales |
| Add desired ending inventory |
| Total needs |
| Less beginning inventory |
| Required production |
| DIRECT MATERIALS BUDGET |
| | April | May | June | Quarter | July | August |
| Required production in units |
| Raw materials per unit (pounds) |
| Production needs (pounds) |
| Add desired ending inventory (pounds) |
| Total needs (pounds) |
| Less beginning inventory (pounds) |
| Raw materials to be purchased (pounds) |
| Cost of raw materials to be purchased at $0.40 per pound |
| SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR MATERIAL |
| | April | May | June | Quarter |
| Accounts payable beginning balance |
| April purchases: |
| April |
| May |
| May purchases: |
| May |
| June |
| June purchases: |
| June |
| Total cash disbursements for materials |
| DIRECT LABOR BUDGET |
| | April | May | June | Quarter |
| Required production |
| Direct labor-hours per unit |
| Total direct labor–hours needed |
| Direct labor cost per hour |
| Total direct labor cost |
| MANUFACTURING OVERHEAD BUDGET |
| | April | May | June | Quarter |
| Budgeted direct labor-hours |
| Variable manufacturing overhead rate |
| Variable manufacturing overhead |
| Fixed manufacturing overhead |
| Total manufacturing overhead |
| Less depreciation |
| Cash disbursements for manufacturing overhead |
| ENDING FINISHED GOODS INVENTORY BUDGET |
| Computation of absorption unit product cost: |
| | Quantity | | Cost | | Total |
| Direct materials | | pounds | | per pound |
| Direct labor | | hours | | per hour |
| Manufacturing overhead | | hours | | per hour* |
| Unit product cost |
| Predetermined Overhead Rate = | Total manufacturing overhead = |
| | Total direct labor hours |
| Budgeted ending finished goods inventory: |
| Ending finished goods inventory in units |
| Unit product cost |
| Ending finished goods inventory in dollars |
| SELLING AND ADMINISTRATIVE EXPENSE BUDGET |
| | April | May | June | Quarter |
| Budgeted sales in units |
| Variable selling and administrative expense per unit |
| Variable selling and administrative expense |
| Fixed selling and administrative expense |
| Total selling and administrative expense |
| Less depreciation |
| Cash disbursements for selling and administrative expenses |
| CASH BUDGET |
| | Royal Company |
| | Cash Budget |
| | For the Quarter Ending June 30 |
| | April | May | June | Quarter |
| Cash balance, beginning |
| Add receipts: |
| Cash collections |
| Total cash available |
| Less disbursements: |
| Direct materials |
| Direct labor |
| Manufacturing overhead |
| Selling & administrative |
| Equipment purchases |
| Dividends |
| Total disbursements |
| Excess (deficiency) of cash available over disbursements |
| Financing: |
| Borrowings |
| Repayments |
| Interest* |
| Total financing |
| Cash balance, ending |
| Interest |
| BUDGETED INCOME STATEMENT |
| Royal Company |
| Budgeted Income Statement |
| For the Quarter Ending June 30 |
| Net sales | | | Computation of net sales |
| Cost of goods sold | | | Sales |
| Gross margin | | | Less uncollectible amounts |
| Selling & administrative expenses | | | Net sales |
| Net operating income |
| Interest expense |
| Net income | | | Computation of cost of goods sold |
| | | | Budgeted sales (units) |
| | | | Unit product cost |
| | | | Cost of goods sold |
| BEGINNING BALANCE SHEET | (Based on information given, beginning balances and calculations) |
| Royal Company |
| Balance Sheet |
| 31-Mar |
| Current assets: |
| Cash |
| Accounts receivable |
| Raw materials inventory |
| Finished goods inventory |
| Plant and equipment: |
| Land |
| Buildings and equipment |
| Accumulated depreciation |
| Total assets |
| Liabilities: |
| Accounts payable |
| Stockholders’ equity: |
| Common stock |
| Retained earnings |
| Total liabilities and stockholders’ equity |
| Royal Company |
| Budgeted Balance Sheet |
| 30-Jun |
| Current assets: |
| Cash |
| Accounts receivable |
| Raw materials inventory |
| Finished goods inventory |
| Plant and equipment: |
| Land |
| Buildings and equipment |
| Accumulated depreciation |
| Total assets |
| Liabilities: |
| Accounts payable |
| Stockholders’ equity: |
| Common stock |
| Retained earnings |
| Total liabilities and stockholders’ equity |
zykeria112
BudgetExTemplateBlank.xlsx
