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