BudgetExTemplateBlank1.xlsx

    0

    Input

    Royal Company Master Budget
    Input Section
    Sales Budget
    Expected unit sales in the first quarter
    Selling price
    Cash Collections
    Beginning Balance
    Collected in month of sale
    Collected in the month following sale
    Uncollectible amount
    Production Budget
    Desired ending inventory % of next month's sales
    Beginning Inventory units
    Raw Materials Budget
    Raw materials per unit pounds
    Cost per pound
    Desired ending inventory
    Beginning inventory pounds
    Cash payments
    Beginning balance
    Paid in month of purchase
    Paid in the month following purchase
    Direct Labor Budget
    Direct labor hours per unit
    Direct labor cost per hour
    Manufacturing Overhead Budget
    Variable Manufacturing Overhead Rate per hour
    Fixed Manufacturing Overhead Rate per month
    Depreciation per month
    Selling and Administrative Expense Budget
    Variable Selling & Admin Rate per unit
    Fixed Selling & Admin Rate per month
    Depreciation per month
    Cash Budget
    Beginning balance
    Dividends first month
    Purchase of equipment second month
    Purchase of equipment third month
    Interest Rate

    Ex Template Blank

    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

                                                                                                                                      Order Now