![Page 1: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/1.jpg)
Sales Forecasting
by MAHSINA, SE, MSi,.
Facebook: mahsina se
Twitter: @mahsina_se
Email: [email protected]
Blog: http://mahsina.wordpress.com
Mobile Phone: 08123049187 03177740888
WA: 082115522262
Pin: 25CE534A
Universitas Bhayangkara (UBHARA)
SURABAYA
![Page 2: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/2.jpg)
The Functions of Management
George R Terry L.F Orwick
Planning
Organizing
Actuating
Controlling
Forecasting
Planning
Organizing
Commanding
Coordinating
Controlling
![Page 3: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/3.jpg)
The Activity Process of forecasting the
future sales in a certain circumstances and
created base on the past data
SALES FORECAST
2 (TWO) METHOD
Qualitative Method Quantitative Method
![Page 4: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/4.jpg)
Qualitative method
SALES STAFF OPINION METHOD MANAGERS DIVISION OPINION METHOD Executive Opinion Method Expert Opinion Method Consumer Survey Method
![Page 5: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/5.jpg)
SALES STAFF OPINION
METHOD
STRENGTH WEAKNESSES
Putting the Responsibility
and Senses Of Belonging
Forecasting is made by the
individual who directly
connected by Consumer
Initial plans is approved by
the authorized person who
responsible to the Target
Sales
Over Optimistic/
Pessimistic on Sales
Forecasting
The variables is too narraw
Limited to Short Term of
Tactical Sales forecasting
![Page 6: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/6.jpg)
MANAGER DIVISION
OPINION METHOD
STRENGTH WEAKNESSES
Applicable for all
companies of all size
Good to those company
who has limited Sales Staff
Need a special experience
and wide knowledge
Provide forecasting that
less accountable
![Page 7: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/7.jpg)
EXECUTIVE OPINION
METHOD
STRENGTH WEAKNESSES
Simply, directly and
economically
Need a special experience
and wide knowledge
Provide forecasting that
less accountable
![Page 8: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/8.jpg)
CONSUMER OPINION
METHOD
STRENGTH WEAKNESSES
Objective Research apply to only
sample not all the
consumers
![Page 9: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/9.jpg)
QUANTITATIVE
METHOD TREND OF STRAIGTH LINE METHOD (Least Square Method) (Moment Method) NON OF STRAIGTH LINE METHOD Parabol Square Method Exponential Trend Method Changeable Exponential Method
![Page 10: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/10.jpg)
QUANTITATIVE
METHOD
PRODUCT LINE ANALYSIS On a Sales Forecasting whether strategical or tactical should include
temporary decision for the introduced new product line, old path of
product line would be removed, its innovation and mix product
PROBABILITY DISTRIBUTION METHOD PDM is use to forecast the sales by using the assessment related with product variance sold TREND ANALYSIS Trend Analysis is a kind of statistical tools in order to forecast the sales REGRESSION ANALYSIS Regression analysis is also kind of statistical tools that often use to forecast the sales
![Page 11: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/11.jpg)
Expected
Amount
Define the probability
is depending to the
management
assessment
![Page 12: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/12.jpg)
Trend
Trend is a long term slow motion and
lean to one direction (increase or
decrease) in a data time series
![Page 13: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/13.jpg)
Least Square Method
![Page 14: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/14.jpg)
Example
![Page 15: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/15.jpg)
We also define a by the following formulations:
Let’s insert data to define b with the following formulations:
Therefore, the equation of trend of straight line of Y = a + bX
Whereas = the forecasting of sales on 2016 = 132 + 10(5)
= 182 units
![Page 16: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/16.jpg)
Therefore, the equation of trend of straight line of Y = a + bX
Whereas = the forecasting of sales on 2016 = 157,5 + 4,5(5)
= 180 units
Other Formulations
![Page 17: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/17.jpg)
How if the data ‘number of n’ is odd ??
Therefore, the equation of trend of straight line of Y = a + bX
Whereas = the forecasting of sales on 2016 = 157,5 + 4,5(5)
= 180 units
![Page 18: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/18.jpg)
Moment Method
Sales forecasting using moment method with the
following formulations :
Elimination Method
Substitution
Method
![Page 19: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/19.jpg)
Elimination method:
b
![Page 20: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/20.jpg)
Substitution method:
![Page 21: BUDGETING (PENGANGGARAN PERUSAHAAN) fileThe Activity Process of forecasting the future sales in a certain circumstances and created base on the past data SALES FORECAST 2 (TWO) METHOD](https://reader030.vdocuments.us/reader030/viewer/2022040113/5d4eb8ea88c99335038bd47a/html5/thumbnails/21.jpg)
Therefore, the equation of Moment Method a =Ȳ– X̅
= 152 – 10 x 2
= 152 – 20
= 132 Therefore, the equation of trend of straight line of Y = a + bX
Whereas = the forecasting of sales on 2016 = 132 + 10(5)
= 182 units