Sales Projection Process Sui Generis Team Process for Sales Projection Process Documentation Template: Item Description Process Title Sales Projection (Sales Forecasting) Process Process # CMPE202-5-Sui1 Date September 29, 2006 Created/Modified By Sui Generis Team Rationale A sales projection is an input for business planning. Definitions: A) Sales Projection A sales projection provides an estimate of a company’s prospective sales for a given timeframe. A sales projection can be prepared for each product and/or service that the company is offering. The figures comprising the sales projection are derived based on past sales figures (when applicable), the current inflation rate, along with reports and statistics regarding pertinent internal and external factors. A sales projection is also known as a sales forecast. B) Sales Projection Time Period The time period (also referred to as frequency or timeframe) for a sales projection defines how much of the future to take into account when computing for the figures. The most commonly used are: o monthly o quarterly o yearly C) Factors Affecting Sales Projection There are various factors that may adversely or positively affect the computation for sales projection based on their director indirect impact in the company’s business plan. These factors include: External Factors · Seasonality of the business · Relative state of economy · Direct and indirect competition · Political events · Styles or fashions · Consumer earnings · Population changes · Productivity changes · Product enhancement and new products Internal Factors · Labor problems · Credit policy changes · Sales motivation plans · Inventory shortages · Working capital shortage · Price changes · Production capability shortage · New product lines · Expected cost of raw materials, storage, shipping · Product past sales · Present market share · Recent trend in Sales Sales Projection Process The typical phases of a sales projection process are as follows: 1 Requisition 1.1 The Finance Manager requests for sales projection figures from the Sales Manager. 1.2 The Sales Manager assigns the tasks of preparing the sales projection from the Sales Analyst. 1.3 The Sales Analysts issues a request to the Researcher for reports and statistics for external and internal factors that may affect the forecast computations. 2 Assessment 2.1 The Researcher identifies the factors that can affect the sales forecast. 2.1.1 The Researcher gathers information regarding the external factors. 2.1.2 The Researcher gathers information regarding the internal factors. 3 Consolidation 3.1 The Researcher consolidates the external and internal factors into reports and statistics and presents these to the Sales Analyst. 3.2 The Sales Analyst verifies the completeness of the submitted reports and statistics from the Researcher. 3.2.1 If all required information is provided,the Analyst proceeds to step 4. 3.2.2 If not, the Analyst requests the Researcher to re-identify the factors that may affect the sales forecast and returns to step 2.1. 4 Calculations 4.1 The Sales Analyst determines if the forecast is being calculated for an existing company or a new one. 4.1.1 If the company is an existing business, Sales Analyst proceeds to step 4.2. 4.1.2 If the company is a new business with no past sales records, the Sales Analyst proceeds to step 4.5. 4.2 The Sales Analyst determines the time period to be used for the calculations and requests the Finance Manager to provide the percentage of inflation factor given that frequency. 4.3 The Finance Manager provides the percentage of inflation factor back to the Sales Analyst. 4.4 The Sales Analyst calculates the sales projection figures for the given time period based on: - reports and statistics provided by the Researcher - actual past sales figures - percentage of the inflation factor 4.5 The Sales Analyst calculates the sales projection figures for the first month based on the reports and statistics provided by the Researcher. 5 Evaluation 5.1 The Sales Manager verifies if the sales projection calculations are acceptable with the Sales Analyst. 5.1.1 If the Sales Manager proposes revisions, the Sales Analyst will reconstruct the projection and re-evaluate the reports and statistics provided by the Researcher and returns to step 3.2. 5.1.2 If there are no revisions required, the Sales Manager forwards the sales projection to the Finance Manager. 6 Acceptance 6.1 The Finance Manager accepts the sales projection provided by the Sales Manager. Roles & How The participants on a sales projection process and a general description of their responsibilities are as follows: Finance Manager • The Finance Manager requests for sales projection figures from the Sales Manager whenever business planning is required. • The Finance Manager provides the percentage of inflation factor to the Sales Manager based on thefrequency specified by the Sales Manager. • The Finance Manager accepts the sales projection once available from the Sales Manager. Sales Manager • The Sales Manager assigns the task of computing for the sales projection figures to the Sales Analyst. • The Sales Manager reviews the output from the Sales Analyst and proposes revisions to the calculated sales projection figures whenever required. • The Sales manager presents the final sales projection figures to the Finance Manager. Sales Analyst • The Sales Analyst requests for reports and statistics for factors that may affect the sales forecast from the Researcher. • The Sales Analyst reviews the reports and statistics provided by the Reseacher and requests for additional information if required. • The Sales Analyst calculates the sales projection for the given time period. • The Sales Analyst reviews the calculations with the Finance Manager and revises the calculations if requested. Researcher • The Researcher gathers information on the internal and external factors that may affect the sales forecast. o The Researcher conducts market research from online sources, trade journals, and other related publications. o The Researcher coordinates with various other teams within the company (i.e. Marketing, Sales, Finance, Production/Inventory, HR/Legal). • The Researcher consolidates