Handout 1 Unlocked
Handout 1 Unlocked
Budgeting Process
Let us define the following terminologies:
1. Budget Period. It is the period for which a budget is prepared and used, which may then be subdivided
into control periods. Before preparing a budget, the organization should decide the budget period. While
there are no clear-cut rules on selecting a budget period, budgeting must be related to a specific period.
Generally, a budget period depends upon the nature and type of business. Some companies prepare a
budget for more than one (1) year, while others limit the period to one (1) year. The budget period should
neither be too long nor too short. Also, there must be sufficient time to prepare and implement the
budget. Most businesses usually prepare an annual budget to be easily compared with the financial
accounting year.
2. Operating Budgets. It ordinarily covers a one (1) year period corresponding to the company’s fiscal year.
Many companies divide their annual budget into four (4) quarters. A continuous budget is a 12-month
budget that rolls forward one (1) month or quarter as the current month or quarter is completed.
3. Budget Manual. The budget manual is a collection of instructions governing the responsibilities of persons
and the procedures, forms, and records relating to the preparation and use of budgetary data. It is likely
to contain the objectives of the budgetary process.
Generally, budgets are prepared according to the organization's objectives in the budget manual. Each
executive's responsibility and functions regarding budgets are shown in the budget manual to avoid
duplication or overlapping duties. The budget manual is prepared to give complete information to every
employee of an organization relating to budgets to avoid misunderstandings.
The managers or heads of various departments in a company are responsible for carrying out the
departmental or functional budgets in the ordinary course of their duties. The following managers usually
prepare functional budgets:
• The sales manager prepares the sales budget;
• The production manager prepares the production budget;
• Purchasing manager prepares the direct materials budget;
• Various cost center heads prepare their individual production, administration, and distribution cost
center budgets for their cost centers; and
• The finance manager consolidates all these budgets and then prepares the cash budget, budgeted
income statement, and budgeted balance sheet.
Budget coordination and administration are usually the budget committee's responsibilities. The budget
committee is often assisted by a budget officer, typically an accountant. Every part of the company should be
represented in the committee. The budget committee is responsible for preparing the budget manual,
allocating the responsibilities for preparing functional budgets, issuing timetables, finalizing the budget, and
communicating with the appropriate managers. The budget committee is also responsible for comparing the
actual results with the budget and investigating variances until the budget period ends.
Operating Budget
The step-by-step budgeting procedures may vary among different organizations, depending on the size of the
complexity of a business entity. Most businesses follow the steps below:
1. Identification of Principal Budget Factor (sales is usually the principal budget factor);
2. Preparation of a Sales Budget, assuming that sales are the principal budget factor (in units and value
for each product, based on a sales forecast);
3. Preparation of Ending Inventory Budget;
4. Preparation of Production Budget;
5. Preparation of Direct Materials, Direct Labor and Overhead Budget;
6. Preparation of Cash Budget; and
7. Preparation of a Master Budget.
Sales Budget
For many organizations, the budgeting process starts with establishing the sales volume. The sales volume is
known as the principal budget factor because it sets the limit for an organization. Preparing a sales budget is
a planning tool that enables management to set a standard for all organizational departments, such as sales,
finance, production, purchasing, etc. When the sales budget is approved, other budgets can then be prepared.
The following factors must be considered by the sales team when preparing a sales budget:
• Past sales performance;
• Market trends;
• Seasonal fluctuations; and
• Market research on sales price of the industry.
All of these may be used to generate a sales forecast. In addition, the following resources must be considered
as well:
• Production capacity;
• Availability of raw materials; and
• Financial capability to support capital expenditures and raw materials acquisition (especially if the
operating cycle is long).
Since the sales budget sets the target or quota for the sales team to achieve, management must consider
setting an achievable target within the means and resources of the company yet challenging enough to allow
healthy growth for the organization.
A sales budget may be prepared monthly, quarterly, or yearly. The sales budget depends on the gathered data
by the company’s sales team when they are in a planning meeting together with a management accountant.
A sales budget may include a plan for a sales increase every year of 10%, either through a price increase or a
production increase. Below is a sample of a monthly sales budget.
Formulas to remember:
Production (Finished Goods) Direct Materials (Raw Materials)
Forecasted Sales xx Required Raw Materials Usage xx
Add: Ending inventory xx Add: Ending inventory xx
Less: Beginning inventory xx Less: Beginning inventory xx
Budgeted Production xx Budgeted Purchases xx
The above formulas are derived from the computation of ending finished goods inventory and ending raw
materials inventory. The computation is as follows:
Note: The above computations can be used for peso values and units.
Finished Goods First Quarter Second Quarter Third Quarter Fourth Quarter
Forecasted Unit Sales 3,000 4,000 5,000 7,500
Add: Ending inventory 350 350 350 350
Total Production Required 3,350 4,350 5,350 7,850
Less: Beginning Inventory 350 350 350 350
Units to be Produced 3,000 4,000 5,000 7,500
Note: The overhead budget is almost similar to the direct labor budget.
Cash Budget
The term "cash budget" refers to managing a company's cash inflows and outflows over a specified period.
These calculations determine if the organization has enough cash and cash equivalents to cover its operating
requirements in the short term. This budget almost resembles the cash flow statements but contains only the
projected cash flows, not the actual ones (Vaidya, 2023).
Master Budget
A master budget is a key planning tool that summarizes the company's financial situation by summarizing
financial statements, cash flow predictions, and the financial strategy (Carlson, 2022).
Given that the production level has been set according to the key budget factor, it is crucial to forecast
production costs. In obtaining the highest and lowest cost, calculate the projected cost using a simple linear
equation as follows:
y = a + bx
Total Cost
b
a Fixed Cost
The High-Low Method requires information on costs incurred at various levels of output. This data can predict
the costs incurred at other output levels.
Illustration: For the past five (5) years, ABC Company has recorded the following costs:
Year Output (units) Cost (Php)
20X1 32,000.00 505,000.00
20X2 38,000.00 590,000.00
20X3 49,000.00 750,000.00
20X4 53,000.00 820,000.00
20X5 50,000.00 800,000.00
Required: Using the High-Low Method, project the total cost for 20x6 when the company’s production budget
expects to deliver 52,000 units.
Step 1: Identify the highest and lowest output and the corresponding costs.
Output (units) Cost (Php)
High 53,000.00 820,000.00
Low 32,000.00 505,000.00
Step 2: Subtract the lowest output/costs from the highest output/costs.
Output (units) Cost (Php)
High 53,000.00 820,000.00
Low 32,000.00 505,000.00
21,000.00 315,000.00
Step 3: Calculate the variable cost per unit (in management accounting, this is computed by dividing the total
variable costs by the number of units produced).
Step 4: Calculate the fixed cost by substituting the variable cost into either one of the cost equations (high or
low).
High (Php) Low (Php)
Total Cost 820,000.00 505,000.00
Less: variable cost 795,000.00 480,000.00
Fixed cost Php25,000.00 Php25,000.00
Step 5: Determine the cost equation and calculate the projected cost.
y = 15x + 25,000
To calculate the projected cost of 52,000 units (this is an example):
x = 52,000 units
y = 15 (52,000) + 25,000 = Php805,000.
Linear Regression
One major drawback of the high-low method is that it only utilizes two (2) historical data sets as the basis for
projecting costs. Further, it assumes that the cost function is a straight line. In most cases, however, this
relationship is not always a straight line. Hence, we can use a scatter graph to show the relationship between
two variables (CIMA Operational Paper, 2019).
Illustration:
Let us say you wanted to analyze the relationship between the advertisement expense and the sales volume
of a particular product. The following data shows the advertising expense and sales volume for the previous
months:
Month 1 2 3 4 5 6 7 8
Advertising expense ('000) 24 13 9 42 31 16 12 35
Sales units ('000) 13 10 9 18 16 9 13 20
The scatter graph shows that the relationship between advertising expense and sales level is not straight. Even
then, you may notice that the plotted dots, although scattered, resembles a rising trend, with higher sales
volume at higher levels of advertising expense.
We can draw a trend line if a trend can be seen in a scatter graph. We can use the equation of that line of best
fit to make our sales predictions. We can achieve this using regression analysis. Regression analysis is also
known as the method of least squares. It is a more accurate technique to estimate the line of best fit.
Regression analysis is a more sophisticated technique as it includes all the data in the projection. To calculate
the values of a and b for the straight-line expression y = a + bx, the following formulas are used:
𝑛∑𝑥𝑦 − 𝛴𝑥𝛴𝑦
𝑏=
𝑛∑𝑥 2 − (𝛴𝑥)2
𝑎 = 𝑦̅ − 𝑏𝑥̅
Where 𝑦̅ and 𝑥̅ means the average of the values of y and x, respectively.
Illustration: The method of least squares, the advertising and sales data are as follows:
Month x Y xy x2 y2
1 24 13 312 576 169
2 13 10 130 169 100
3 9 9 81 81 81
4 42 18 756 1,764 324
5 31 16 496 961 256
6 16 9 144 256 81
7 12 13 156 144 169
8 35 20 700 1,225 400
Total 182 108 2,775 5,176 1,580
Average 23 14
𝑦 = 6.9367 + 0.3071𝑥
This equation is known as the regression line or line of best fit. Linear regression can also be used to evaluate
the strength of the relationship. In applying linear regression, determine how close the plotted dots are to the
line, also known as the degree of correlation. Two (2) variables might be perfectly correlated, partly
correlated, or uncorrelated in determining the degree of correlation.
The degree of correlation can be measured by computing the correlation coefficient (r) without using a scatter
graph.
𝑛 ∑ 𝑥𝑦 − ∑ 𝑥 ∑ 𝑦
𝑟=
√[𝑛 ∑ 𝑥 2 − (∑ 𝑥)2 ][𝑛 ∑ 𝑦 2 − (∑ 𝑦)2 ]
The value r can range between negative one (-1) to one (1), with stronger relationships having values closer
to negative one (-1) or one (1) and weaker relationships near 0.
Illustration: Calculate the correlation coefficient using the same data in linear regression.
Month x y xy x2 y2
1 24 13 312 576 169
2 13 10 130 169 100
3 9 9 81 81 81
4 42 18 756 1,764 324
5 31 16 496 961 256
6 16 9 144 256 81
7 12 13 156 144 169
8 35 20 700 1,225 400
Total 182 108 2,775 5,176 1,580
8𝑥2775−182𝑥108 2,544
𝑟= = = 0.89
√[8𝑥5176−1822 ][8𝑥1580−1082 ] √[8284][976]
The question is, will the equation derived using linear regression be suitable for forecasting? Since the
correlation coefficient is close to 1, r demonstrates a high correlation. In simple terms, a high correlation
means that one variable is highly sensitive to the other variable. In this case, the advertising expense and the
sales volume are the variables. Having a high correlation, any change in advertising expense can directly affect
the sales volume resulting in an almost proportionate change. As advertising expenses increase, the sales
volume increases.
Having established the strong correlation between advertising expense (x) and sales volume (y), such
correlation may be due to chance or a reason. If there is a reason, it may not be causal. For instance, ice cream
sales and sunscreen are well correlated, not because of a direct causal link, but because the weather influences
both variables. But even if there is a causal explanation for a correlation, it does not follow that the variations
noted in one variable will cause variations in the value of the other. The successful application of the linear
regression model depends on x and y being closely linearly related. The coefficient of determination measures
the variation in y that appears to be explained by variation in x.
For example, if r = 0.70, you may think the linear relationship between the two (2) variables is quite strong.
But r2 = 0.49 shows that only half of the variations in the dependent variable can be explained by a linear
relationship with the independent variable. The low figure may suggest a non-linear relationship is a better
model for the data, or other factors must be considered. The rule of thumb is that r2 > 80% indicates that a
linear regression may be applied for forecasting.
When calculating a line of best fit, there will be a range of values for x. Depending on the degree of correlation
between x and y, we might safely use the estimated line of best fit to forecast the values of y, provided that
the value of x remains within the range of data. It is called interpolation. Interpolation is using a line of best
fit to predict a value within two (2) extreme points of a given range. It will be on less safe ground if the equation
to predict a value for y outside the range is used because we would have to assume that the costs behave the
same way outside the range of values of x to establish the line in the first place. It is called extrapolation.
Extrapolation uses a line of best fit to predict a value outside the two (2) extreme points. As a general rule,
interpolation is generally considered safer than extrapolation.
Illustration: The first two (2) components, let us say a product manager of a fast-food chain is contemplating
whether to continue or discontinue its fish burger in its menu. Consider the following histogram showing the
number of fish burgers served by the fast-food chain over the past four (4) years:
Histogram
1000
800
600
400
200
0
Orders Trend
Figure 5: Histogram
Source: CIMA Operational Paper P1, 2019, p. 114.
In this histogram, there would appear to be a sizeable seasonal fluctuation for fish burgers. Also, it shows a
basic upward trend in demand for the product, which shows the opportunities to retain the fish burger on the
menu. The third component of the time series, cyclical variations, are medium-term results changes caused
by circumstances that repeat in cycles. These are commonly associated with economic cycles, booms and
slumps, often lasting a few years. Cyclical variations are longer than seasonal variations. The fourth component
of the time series refers to random variations. Unforeseen circumstances, such as natural calamities,
pandemics, war, changes in government policy, changes in technology, fire, etc., cause these.
The High-Low method and Linear Regression were already discussed in the first parts of this handout. The
moving average will be discussed next. However, the discussion will focus on the simple moving average. The
simple moving average is an average of the results of a fixed number of periods. It can remove seasonal
variations from a time series due to the averaging process, so the remaining figures represent the trend only.
Required: Calculate the moving average for a period of three (3) years to determine the trend.
Moving
Year Sales (units) Average Formula
1 390
2 380 410 (390+380+460)/3
3 460 430 (380+460+450)/3
4 450 460 (460+450+470)/3
5 470 453 (450+470+440)/3
6 440 470 (470+440+500)/3
7 500 487 (440+500+520)/3
8 520
Note that the moving average series has six (6) figures showing an upward sales trend.
o Variety – Different types of data require various ways to process. Some data may be stored in the
form of images, sound recordings, social media posts, videos, etc., and each medium may require
an investment to process them.
o Veracity – The challenge is to keep the information free from bias, which is often difficult to
remove. For example, social media posts about a product may provide data on how customers
perceive a product. It may not help predict sales because the age profile of the users may act as a
bias, thus distorting the data collected.
Companies can use big data analytics to analyze opportunities to improve products, increase product offerings,
or reduce costs. It can develop and maintain broader key performance indicators (KPIs) and improve
forecasting quality.
With all the technologies available to improve forecasting techniques, we must acknowledge that all forecasts
are subject to error. It may be partly due to trends, and seasonal variations may not continue, or random
variations may highly affect the pattern of trends and seasonal variations (CIMA Operational Paper, 2019).
References