Question

In: Accounting

Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The...

  1. Building the Master Budget involve:
    1. The Sales Budget.
    2. The Production Budget
    3. Expected Cash Collections Budget
    4. The Direct Materials Budget
    5. Expected Cash Disbursement Budget
    6. The Direct Labor Budget
    7. Manufacturing Overhead Budget
    8. Ending Finished Goods Inventory Budget
    9. Selling and Administrative Expense Budget
    10. The Cash Budget
    11. The Budgeted Income Statement
    12. The Budgeted Balance Sheet

Full Explanations

Solutions

Expert Solution

Master Budget

The master budget is a one-year budget planning document for the firm encompassing all other budgets. It coincides with the fiscal year of the firm and can be divided  into quarters and further into months. If the firm plans for the master budget are to be an ongoing document, rolling from year to year, then normally a month is added to the end of the budget to facilitate planning. It is called continuous budgeting.

The budget committee usually develops the master budget for each year, which is handled by  Budget Director, who is usually the Controller of the company.

Major Parts

Depend  on the size of the firm, the master budget is a comprehensive budget planning document. It usually has two parts; the operating budget and the financial budget. The operating budget reflects  the income-generating activities of the firm, including revenues and expenses. The result is a budgeted income statement.

The financial budget reflects  the inflows and outflows of cash and other elements of the firm's financial position. The inflows and outflows of cash come from the cash budget. As such, the result of the financial budget is the budgeted balance sheet. Operating budgets are made first as information from the operating budgets is needed for the financial budgets.

Operating Budget

The operating budget is composed of eight supporting budget planning schedules. They are interrelated and come together to develop a budgeted income statement based on the operating budget.

The budgeted income statement is the result of the eight schedules. Take note that operating income is not the same as net income. In order to get net income, you have to subtract out Financial Budget.

Sales Budget

The first schedule to develop is the sales budget, which is based on the sales forecast. The sales budget is not usually the same as the sales forecast but it is somewhere  adjusted based on managerial judgment and other data.

Production Schedule

The second schedule for budget planning is the production schedule. The company should:

  • Determine the number of sales the company expects to make in the future ie next year or next quarter
  • It reflects  how many sales in units it needs to make to meet the sales budget and meet-ending inventory requirements.

Most companies have an ending inventory they want to meet every month or quarter so that they don't stock out.

Direct Materials, Labor, and Overhead Budget

The next schedules are the direct materials purchases budget which refers to the raw materials the firm uses in its production process, the direct labor budget, and the overhead budget. The overhead budget includes both fixed and variable overhead costs.

Finished Goods Inventory and Cost of Goods Sold Budget

The ending finished goods inventory budget is necessary to complete the cost of goods sold budget and the balance sheet. This budget directly  assigns a value to every unit of product produced based on raw materials, direct labor, and overhead.

Administrative Budget

The selling and administrative expense budget deal with cost associated with sales ie non manufacuturing costs  such as freight or supplies.

Cash Budget, Budgeted Balance Sheet, and Capital Expenditures

three remaining budgets found in the financial budget portion of the master budget. They are  cash budget, the budgeted balance sheet, and the budget for capital expenditures. The cash budget shows cash inflows and outflows, expected borrowing, and expected to invest, usually on a monthly basis. Any item that is not in cash, such as depreciation, is ignored by the cash budget.

The budgeted balance sheet shows the ending balances of the asset, liability, and equity accounts if budgeting plans hold true during the budgeting time period.

The budget for capital expenditures contains budgetary figures for the large, expensive fixed assets for the business firm.

These are the most often used budgets within the master budget of business firms. Some firms may not use one or another of the budgets, but most use some form of all of them. Service firms, for example, do not typically use production budgets.

Schedule of Expected Cash Collections. Schedule of expected cash collections from customers shows the budgeted cash collections on sales during a period. It is a component of master budget and it is prepared after the preparation of sales budget and before the preparation of cash budget


Related Solutions

1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the...
1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are...
how to calculate sales budget/cash collection budget for a master budget case?
how to calculate sales budget/cash collection budget for a master budget case?
Renfro Company is preparing its master budget for May. Renfro’s sales budget shows expected sales for...
Renfro Company is preparing its master budget for May. Renfro’s sales budget shows expected sales for May of 100,000 units. The beginning finished goods inventory is an estimated 12,000 units and the desired ending inventory is 9,000 units. Materials are expected to be purchased at $2 per pound and each unit of product requires 3 pounds of material. Beginning and ending materials inventories are expected to be 24,000 and 20,000 pounds, respectively. Direct labor for each unit produced requires 0.5...
How do you calculate: Sales budget, schedules of expected cash flows, Production budget, Materials budget, Direct...
How do you calculate: Sales budget, schedules of expected cash flows, Production budget, Materials budget, Direct labor budget & Cash budget?
Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the...
Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the first quarter of 2017: January February March Sales budget $ 215,000 $ 235,000 $ 258,000    Credit sales are collected as follows:    55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale.    The accounts receivable balance at the end of the previous quarter was $99,000 ($69,000 of...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following...
Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable...
Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable balance, monthly cash disbursements, net cash flows, and cash surplus / deficit at the end of each month in the third quarter of 2018 (July - September 2018). Do not allow your firm to have a cash balance below the minimum cash balance and only borrow what you need. a. In June 2018 credit sales were $50,000. b. The firm’s total sales in 2017...
Problem 16-10 Calculating Cash Collections [LO 3] The following is the sales budget for Segura, Inc.,...
Problem 16-10 Calculating Cash Collections [LO 3] The following is the sales budget for Segura, Inc., for the first quarter of 2013: January February March   Sales budget $138,000 $151,000 $163,000 Credit sales are collected as follows: 65 percent in the month of the sale 20 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $94,000 ($69,000 of which was uncollected December...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT