sales forecasting and material planning with bista's cloud erp
TRANSCRIPT
SALES FORECASTING AND MATERIAL PLANNING IN CLOUD ERP
Bista Solutions Inc USA 1
Bista Solutions Inc USA2
POINTERS1) What is sales forecasting ?
2) Importance of sales forecasting?
3) Step by Step process of Sales Forecasting
4) Material Planning in ERPinCloud
Bista Solutions Inc USA3
WHAT IS SALES FORECASTING ?
Sales forecasting is the prediction of the future sales of a particular product over a specific period of time based on past performance of the product, inflation rates, unemployment, consumer spending patterns, market trends, and interest rates.
Bista Solutions Inc USA4
In the preparation of a comprehensive marketing plan, sales forecasts help the marketer develop a marketing budget, allocate marketing resources, and monitor the competition and the product environment.
Sales forecasting uses past sales figures to predict the short-term or long-term future performance to enable sound financial planning.
Bista Solutions Inc USA5
IMPORTANCE OF SALES FORECASTING
Financial planning of a business.
Self-assessment tool.
Uses past and current sales statistics.
Accurate sales forecast.
You can plan for the future
6
SALES FORECASTING IN OPEN ERP
Bista Solutions Inc USA
Navigate as follows Sales>> Sales Forecasts>>Create Sales Forecasts
See below
Bista Solutions Inc USA7
Bista Solutions Inc USA8
a) Create a period for which the forecast is to be made.
b) The warehouse for which the forecast is to be made.
c) The location for which the forecast is to be made.
d) The product category for which the forecast is to be made.
Bista Solutions Inc USA9
Bista Solutions Inc USA10
Now after the sales forecast is created by clicking on the create button.
Navigate as follows :
Sales >> Sales Forecasts >> Sales Forecasts
Bista Solutions Inc USA11
Bista Solutions Inc USA12
Now, open each record one by one and manually enter the “forecast quantity” for each product according to the requirements for forecasting and click on save.
Bista Solutions Inc USA13
Bista Solutions Inc USA14
Navigate to
Warehouse >> MRP Analysis >> Run MRP Analysis
Bista Solutions Inc USA15
Bista Solutions Inc USA16
Now, create a new Run MRP Analysis and :
Give a name for Analysis reference
In the Analysis type, choose “Analysis from Sales Forecasts” for the sales forecast feature to work and click on save.
Bista Solutions Inc USA17
Bista Solutions Inc USA18
Now give the period that was created by the user and click “Get Sales forecasts” button.
By doing this all the sales forecasts items appear in the tree view.
After getting the list of items, click “Analysis” button.
Bista Solutions Inc USA19
Bista Solutions Inc USA20
Now, click “Get Analysis Results”.
Adding filters for the output is optional.
Bista Solutions Inc USA21
Bista Solutions Inc USA22
A new form appears which shows the analysis results.
Analysed items can be seen in the first tab.
Bista Solutions Inc USA23
Bista Solutions Inc USA24
In, the next tab i.e.“Sub-assemblies Raw materials Analysis", we can see
items that are to be procured.
Select according to the requirements and click “Procure All” button.
Bista Solutions Inc USA25
Bista Solutions Inc USA26
A wizard opens which shows us the clubbed line items that contains both, items
to be purchased and items to be manufactured or either of them.
Click “Procure” to proceed.
Bista Solutions Inc USA27
Bista Solutions Inc USA28
Now,see the third tab, i.e. “Procured Sub-assemblies Raw materials”
It contains the Purchased and Produced items.
Bista Solutions Inc USA29
Bista Solutions Inc USA30
Now Navigate to
Purchase >> Request for Quotations
A RFQ gets generated for the items to be purchased.
Bista Solutions Inc USA31
Bista Solutions Inc USA32
Open the record and see the record, source document contains the forecast that was created.
Bista Solutions Inc USA33
Bista Solutions Inc USA34
Navigate to
Manufacturing >> Manufacturing >>Manufacturing Orders
Two manufacturing orders are created from items to be produced.
Bista Solutions Inc USA35
Bista Solutions Inc USA36
Open any on record and see,
Bista Solutions Inc USA37
Bista Solutions Inc USA38
Email ID - [email protected] – www.bistasolutions.com
THANK YOU
Bista Solutions Inc USA 39