Detailed Sales Forecast

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Detailed Sales Forecast as PDF for free.

More details

  • Words: 531
  • Pages: 3
Detailed Sales Forecast Company Confidential Instructions: Enter values into the white and yellow cells only. Opportunity Sales Sales Name Agent Region A. Datum Corporation Sales Agent 1 US - Northeast Adventure Works Sales Agent 2 US - Southeast Alpine Ski House Sales Agent 3 US - North Central Baldwin Museum of Science Sales Agent 4 US - South Central Blue Yonder Airlines Sales Agent 5 US - Northwest City Power & Light Sales Agent 1 US - Southwest Coho Vineyard Sales Agent 3 Canada - East Coho Winery Sales Agent 5 Canada - West Contoso, Ltd. Sales Agent 3 EMEA - France Contoso Pharmaceuticals Sales Agent 4 EMEA - Germany Consolidated Messenger Sales Agent 5 EMEA - Italy Fabrikam, Inc. Sales Agent 4 EMEA - Other Fourth Coffee Sales Agent 3 APSA - Asia Graphic Design Institute Sales Agent 2 APSA - Pacific Humongous Insurance Sales Agent 1 APSA - Mexico Litware, Inc. Sales Agent 2 APSA - Australia Lucerne Publishing Sales Agent 5 APSA - Other Margie's Travel Sales Agent 4 US - Northeast Northwind Traders Sales Agent 3 US - South Central Proseware, Inc. Sales Agent 4 Canada - East School of Fine Art Sales Agent 3 EMEA - France Southridge Video Sales Agent 5 EMEA - UK Tailspin Toys Sales Agent 1 APSA - Australia TOTAL

Sales Category Consulting Products Training Mixture Prof. Services Support Mixture Training Mixture Products Products Consulting Training Services Support Prof. Services Services Support Prof. Services Mixture Services Mixture Products

Forecast Amount $150,000 $145,200 $162,500 $147,500 $148,000 $175,000 $149,000 $142,000 $172,500 $163,500 $155,500 $166,000 $180,000 $140,000 $155,000 $173,200 $146,500 $156,750 $162,000 $157,000 $173,000 $171,000 $168,000 $3,659,150

Sales Phase Formal Approval Opportunity Identified Need Sponsorship Budget Validated Needs Analysis Solution Proposed Written Proposal Verbal Approval Sponsorship Formal Approval Opportunity Budget Validated Solution Proposed Sponsorship Needs Analysis Solution Proposed Written Proposal Verbal Approval Formal Approval Budget Validated Needs Analysis Solution Proposed

Probability of Sale 90% 10% 20% 30% 40% 50% 60% 70% 90% 20% 100% 10% 30% 60% 30% 50% 60% 70% 90% 100% 40% 50% 60%

Forecast Close January February March April May June July August October November December January March May June October December November February March April August September

Weighted Forecast $135,000 $14,520 $32,500 $44,250 $59,200 $87,500 $89,400 $99,400 $155,250 $32,700 $155,500 $16,600 $54,000 $84,000 $46,500 $86,600 $87,900 $109,725 $145,800 $157,000 $69,200 $85,500 $100,800 $1,948,845

Detailed Sales Forecast Company Confidential

January Forecast $135,000 $$$$$$$$$$$16,600 $$$$$$$$$$$$151,600 $151,600

February Forecast $$14,520 $$$$$$$$$$$$$$$$$145,800 $$$$$160,320 $311,920

March Forecast $$$32,500 $$$$$$$$$$54,000 $$$$$$$157,000 $$$$243,500 $555,420

April Forecast $$$$44,250 $$$$$$$$$$$$$$$$$69,200 $$$113,450 $668,870

May Forecast $$$$$59,200 $$$$$$$$$84,000 $$$$$$$$$$143,200 $812,070

June Forecast $$$$$$87,500 $$$$$$$$$46,500 $$$$$$$$$134,000 $946,070

July Forecast $$$$$$$89,400 $$$$$$$$$$$$$$$$$89,400 $1,035,470

August Forecast $$$$$$$$99,400 $$$$$$$$$$$$$$85,500 $$184,900 $1,220,370

September Forecast $$$$$$$$$$$$$$$$$$$$$$$100,800 $100,800 $1,321,170

October Forecast $$$$$$$$$155,250 $$$$$$$86,600 $$$$$$$$241,850 $1,563,020

November Forecast $$$$$$$$$$32,700 $$$$$$$$109,725 $$$$$$142,425 $1,705,445

December Forecast $$$$$$$$$$$155,500 $$$$$$87,900 $$$$$$$243,400 $1,948,845

Detailed Sales Forecast Company Confidential

Forecast Revenue

Monthly Weighted Forecast $2,000,000 $1,900,000 $1,800,000 $1,700,000 $1,600,000 $1,500,000 $1,400,000 $1,300,000 $1,200,000 $1,100,000 $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $-

Colum Colum Colum Colum Colum Colum Colum Colum Colum Colum Colum Colum nA nB nC nD nE nF nG nH nI nJ nK nL Month

Related Documents

Detailed Sales Forecast
November 2019 10
Sales Forecast
November 2019 21
Sales Forecast Worksheet
October 2019 19
Sales Plan / Forecast
April 2020 7
12month Sales Forecast
November 2019 15