Operating Budgets

In this Operating Budget section, we will discuss the following budgets:

  1. Sales Budget
  2. Production Budget
  3. Cost of Goods Sold Budget
  4. Selling and Administrative Expense Budget
  5. Income Statement

Sales budget The cornerstone of the budgeting process is the sales budget because the usefulness of the entire operating budget depends on it. The sales budget involves estimating or forecasting how much demand exists for a company’s goods and then determining if a realistic, attainable profit can be achieved based on this demand. Sales forecasting can involve either formal or informal techniques, or both.  The video below illustrates a sales budget (watch the first 4 minutes of the video only for the sales budget).

Formal sales forecasting techniques often involve the use of statistical tools. For example, to predict sales for the coming period, management may use economic indicators (or variables) such as the gross national product or gross national personal income, and other variables such as population growth, per capita income, new construction, and population migration.

To use economic indicators to forecast sales, a relationship must exist between the indicators (called independent variables) and the sales that are being forecast (called the dependent variable). Then management can use statistical techniques to predict sales based on the economic indicators.

Management often supplements formal techniques with informal sales forecasting techniques such as intuition or judgment. In some instances, management modifies sales projections using formal techniques based on other changes in the environment. Examples include the effect on sales of any changes in the expected level of advertising expenditures, the entry of new competitors, and/or the addition or elimination of products or sales territories. In other instances, companies do not use any formal techniques. Instead, sales managers and salespersons estimate how much they can sell. Managers then add up the estimates to arrive at total estimated sales for the period.

Usually, the sales manager is responsible for the sales budget and prepares it in units and then in dollars by multiplying the units by their selling price. The sales budget in units is the basis of the remaining budgets that support the operating budget.

We will be illustrating the step-by-step preparation of a master budget for Leed Company, which manufactures low-priced running shoes.  Most companies develop the sales budget in units and sales dollars because the remaining budgets will use both sales units and sales dollars.

To illustrate this step, assume that Leed’s management forecasts sales for the year at 100,000 units (each pair of shoes is one unit). Quarterly sales are expected to be 15,000, 40,000, 20,000, and 25,000 units, reflecting higher demand for shoes in the late spring and again around Christmas.  The selling price for each pair of shoes forecasted at $40. Leed’s sales budget would be prepared as by showing the sales unit for each quarter x budgeted sales price to get the sales in dollars.  The totals for the year are added from each quarter.

 

Leed Company     
Sales Budget     
Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR
Sales in Units 15,000 40,000 20,000 25,000 100,000
Budgeted price     x $40  x $40 x $40 x $40
Sales in Dollars $600,000 $1,600,000 $800,000 $1,000,000 $4,000,000

Production budget The production budget considers the units in the sales budget and the company’s inventory policy. Managers develop the production budget in units and then in dollars. Determining production volume is an important task. Companies should schedule production carefully to maintain certain minimum quantities of inventory while avoiding excessive inventory accumulation. The principal objective of the production budget is to coordinate the production and sale of goods in terms of time and quantity.

Companies using a just-in-time inventory system need to closely coordinate purchasing, sales, and production. In general, maintaining high inventory levels allows for more flexibility in coordinating purchases, sales, and production. However, businesses must compare the convenience of carrying inventory with the cost of carrying inventory; for example, they must consider storage costs and the opportunity cost of funds tied up in inventory.  Watch this video for an example of how to create a production budget.

Firms often subdivide the production budget into budgets for materials, labor, and manufacturing overhead, which we will discuss in the manufacturing budgets. Usually materials, labor, and some elements of manufacturing overhead vary directly with production within a given relevant range of production. Fixed manufacturing overhead costs do not vary directly with production but are constant in total within a relevant range of production. To determine fixed manufacturing overhead costs accurately, management must determine the relevant range for the expected level of operations.

For our example company, Leed Company, we assume the company’s policy is to maintain 40% of next quarters sales in ending inventory.  Finished goods inventory on January 1 is 10,000 units (Note:  You should be given this information but if you do not have the beginning inventory, you can assume the company followed the same ending inventory policy.  This means, you can calculate beginning finished goods inventory as Quarter 1 sales x 40% since we can assume the company followed this policy and the ending inventory of 4th quarter last year is the beginning inventory of this year).  We anticipate the December 31 ending inventory to be 6,000 units. From this data, we can prepare the schedule of planned production using the Sales budget as our starting place.

Leed Company     
Production Budget     
  Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR
Sales in Units    15,000    40,000    20,000    25,000   100,000
Add: Desired Ending Inventory  16,000   8,000  10,000   6,000    6,000
(Next Qtr Sales x 40%) (40,000 x 40%) (20,000 x 40%) (25,000 x 40%) (given)
Total Units Needed    31,000    48,000    30,000    31,000   106,000
Less: Beginning Inventory  10,000  16,000    8,000   10,000   10,000
Units to be Produced    21,000    32,000    22,000    21,000    96,000

Important things to note:

  1. Desired ending inventory is calculated as next quarter sales units x 40% in Leed’s case since the company policy is to maintain 40% of next quarters sales in ending inventory.
  2. Quarter 4 ending inventory is the same number used for ending inventory for the year.
  3. Quarter 1 beginning inventory is the same number used for beginning inventory for the year.
  4. Quarter 2 beginning inventory is quarter 1’s ending inventory since the balance rolls over the to next period.  This means, quarter 3 beginning inventory is quarter 2’s ending inventory and quarter 4 beginning inventory is quarter 3’s ending inventory.
  5. Inventory refers to Finished Goods Inventory for a manufacturer.

For a merchandiser, this budget would be called a Purchases Budget and would show how many units we would need to purchase for each quarter.  The inventory in this case would refer to merchandise inventory.  You can see an example of a purchases budget in the Budgets for a Merchandiser section later in this chapter.

Cost of Goods Sold budget The cost of goods sold budget establishes the forecast for the inventory expense and is usually one of the largest expenses on an income statement.  A cost of goods sold budget would not be necessary for a service company since they do not sell a product.  Management must now prepare a schedule to forecast cost of goods sold, the next major amount in the planned operating budget. We need to understand the costs for making the product.  Leed Company has the following costs:

Direct Materials $  10 per unit
Direct Labor $  6 per unit
Variable Overhead  $  0.75 per unit
Fixed Overhead $75,000 per quarter

The cost of goods sold budget would use the sales budget in units.  We will take each of our variable costs (direct materials, direct labor and variable overhead) x budgeted sales units.  The cost of goods sold budget would look like:

 

Leed Company          
Cost of Goods Sold Budget          
  Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR
Sales in Units 15,000 40,000 20,000 25,000 100,000
Direct Materials ($10 per unit) $150,000 $400,000 $200,000 $250,000 $1,000,000
Direct Labor ($6 per unit) 90,000 240,000 120,000 150,000 600,000
Variable Overhead ($0.75 per unit) 11,250 30,000 15,000 18,750 75,000
Fixed Overhead    75,000 75,000 75,000 75,000 300,000
Cost of Goods Sold $326,250 $745,000 $410,000 $493,740  $1,975,000

After managers forecast cost of goods sold, they prepare a separate budget for all selling and administrative expenses.

Selling and administrative expense budget  The costs of selling a product are closely related to the sales forecast. Generally, the higher the forecast, the higher the selling expenses. Administrative expenses are likely to be less dependent on the sales forecast because many of the items are fixed costs (e.g. salaries of administrative personnel and depreciation of administrative buildings and office equipment). Managers must also estimate other expenses such as interest expense, income tax expense, and research and development expenses.

For Leed Company, we need to know the following information:

  • Selling expenses are $2 per unit sold
  • Administrative expenses are $100,000 per quarter

We can calculate Leed Company’s Selling and Administrative Expense Budget using the information above and the sales budget.  For selling expenses, we will take the sales in units x $2 variable selling expense per unit.  Administrative expenses are fixed so they will not change based on volume.  Fixed expenses include depreciation on the office building of $20,000 per quarter.

Leed Company     
Selling and Administrative Budget     
  Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR
Selling Expenses 30,000 80,000 40,000 50,000 200,000
 (Current qtr units sold x $2 per unit) (15,000 units x $2) (40,000 units x $2) (20,000 units x $2) (25,000 units x $2)
Administrative Expenses  100,000 100,000  100,000 100,000  400,000
Total Selling and Admin Expenses $130,000 $180,000 $140,000 $150,000 $600,000
Less: Office Bldg Depreciation (20,000) (20,000) (20,000) (20,000) (80,000)
Total Cash payments for selling and admin. expenses $110,000 $160,000 $120,000 $130,000 $520,000

Notice, depreciation is subtracted from the total budget to get total cash payments — why?  Because, depreciation is a non-cash expense and is not paid with cash so we will remove it from the other cash payments to use in the cash budget.  The next step is to prepare the budgeted income statement.

Budgeted Income Statement

We will use a standard multi-step income statement showing sales minus gross profit is gross profit (or gross margin).  Gross profit minus operating expenses is the income from operations.  We will need the Sales budget, Cost of goods sold budget, and the Selling and Administrative expense budgets.

We will use the information from the sales budget, cost of goods sold budget, and selling and administrative expense budget.  Note:  Remember, to use the full budget amount for selling and administrative expenses and not the cash payments amount.  Leed Company pays a 40% income tax rate (multiply income from operations x 40% for each quarter).

 

Leed Company
Budgeted Income Statement
Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR  
Sales (in dollars) $600,000 1,600,000 800,000 1,000,000 4,000,000  from Sales budget
Less: Cost of goods sold 326,250 745,000 410,000 493,750 1,975,000 from Cost of Goods Sold budget
Gross Profit 273,750 855,000 390,000 506,250 2,025,000 (Sales – Cost of good sold)
Operating Expenses:  
Selling Expenses 30,000 80,000 40,000 50,000 200,000 from Selling and Admin budget 
Administrative Expenses 100,000 100,000 100,000 100,000 400,000
Income from operations $143,750 675,000 250,000 356,250 $1,425,000 (Gross Profit – Selling and Admin expense)
Less: Income tax expense (40%) 57,500 270,000 100,000 142,500 570,000
Net Income $86,250 $405,000 $150,000 $213,750 $855,000

We look look at the manufacturing budgets and cash budget next.