Sales Budget


Sales Budget:

Learning Objectives:

  1. Define and explain sales budget.
  2. Give and example of sales budget.

Contents:

  1. Definition and explanation of sales budget
  2. Example

Definition and Explanation:

sales budget is a detailed schedule showing the expected sales for the budget period; typically, it is expressed in both dollars and units of production. An accurate sales budget is the key to the entire budgeting in some way. If the sales budget is sloppily done then the rest of the budgeting process is largely a waste of time.

The sales budget will help determine how many units will have to be produced. Thus, the production budget is prepared after the sales budget. The production budget in turn is used to determine the budgets for manufacturing costs including the direct materials budget, the direct labor budget, and the manufacturing overhead budget. These budgets are then combined  with data from the sales budget and the selling and administrative expenses budget to determine the cash budget. In essence, the sales budget triggers a chain reaction that leads to the development of the other budgets. The selling and administrative expenses budget is both dependent on and a determinant of the sales budget. This reciprocal relationship arises because sales will in part be determined by the funds committed for advertising and sales promotion.

The sales budget is the starting point in preparing the master budget. All other items in the master budget including production, purchase, inventories, and expenses, depend on it in some way. The sales budget is constructed by multiplying the budgeted sales in units by the selling price.

Example or Sample of a Sales Budget:

Following is the sales budget of Hampton Freeze Inc. (see explanation of this budget)

 

Hampton Freeze, Inc.
Production Budget
For the Year Ended December 31, 2009
Quarter Year
1 2 3 4
Budgeted sales in cases $ 10000 $ 30000 $ 40000 $ 20000 $ 100000
Selling price per case $ 20000 $ 20000 $ 20000 $ 20000 $ 20000
———— ———— ———— ———— ————
Total sales $200000 $600000 $80000 $400000 $2000000
Percentage of sales collected in the period of the sales 70%
Percentage of sales collected in the period after the sales 30%
70% 30%

 

Schedule of Expected Cash Collections
1 Accounts receivable, beginning balance $90,000 $90,000
2 First quarter sales 140,000 $60,000 200,000
3 Second quarter sales 420,000 $240,000 800,000
4 Third quarter sales 560,000 $240,000
5 Fourth quarter sales 280,000 280,000
———– ———– ———– ———– ———–
6 Total cash collections $230,000 $480,000 $740,000 $520,000 $1,970,000
====== ====== ====== ====== ======
1 Cash collections from last years fourth-quarter sales.
2 $200,000 × 70%; $200,000 × 30%
3 $600,000 × 70%; $600,000 × 30%
4 $800,000 × 70%; $800,000 × 30%
5 $400,000 × 70%

This example contains the sales budget for Hampton Freeze for the year 2009, by quarters. Notice from the example that the company plans to sell 100,000 cases of popsicles during the year, with sales peaking in the third quarter.

Explanation of sales budget for Hampton Freeze Inc.

After preparing sales budget, a schedule of expected cash collections is also prepared such as the one that appear in our example. Cash collections consists of sales made to customers in prior periods plus collections on sales made in the current budget period. In our example, 70% of sales are collected in the quarter in which the sales are made and the remaining 30% are collected in the following quarter. For example, 70% of the first quarter sales of $200,000 (or 140,000) is collected during the first quarter and 30% (or $60,000) is collected during the second quarter.

You may also be interested in other articles from “Budgeting and planning” chapter:

  1. Profit Planning
  2. Participative or Self Imposed budgeting
  3. Human Factors in Budgeting
  4. Zero Based Budgeting (ZBB)
  5. Budget Committee
  6. Master Budget
  7. Sales Budget
  8. Production Budget
  9. Inventory Purchases Budget for a Merchandising Firm
  10. Material Budgeting | Direct Materials Budget
  11. Labor Budget
  12. Manufacturing Overhead Budget
  13. Ending Finished Goods Inventory Budget
  14. Selling and Administrative Expense Budget
  15. Cash Budget
  16. Budgeted Income Statement
  17. Budgeted Balance Sheet
  18. International Aspects of Budgeting

Other Related Accounting Articles:

Recommended Books !



Or

Download E accounting book in MS-word format for just 20 $ - Click here to Download

Leave a Reply

Your email address will not be published. Required fields are marked *