$12.99
Document provided by...
pagosspreadsheetzone
www.spreadsheetzone.com
About This Document
Sales Pipeline is a method that is used for estimating the revenues of the existing opportunities. Each opportunity is classified into up to 10 items, like contract, lead, qualitied lead, etc. Each item defines a probability that the sales process will be successfully completed. This file contains 10 commonly used items and the corresponding probabilities. However, this items and probabilities may be edited by the user. The opportunities are entered on a sheet. Determining the type of opportunities leads the calculation of expected return from the opportunity. Adding up the expected returns, an estimation of revenues from the existing opportunites is calculated. Up to 100 opportunities may be recorded on this sheet. However, this number may be increased easily, just by adding rows and copy-pasting the formulas. Finally a report of the existing opportunities is provided on another sheet. Distribution of the expected revenues over quarters and sales stages are displayed both on tables and charts.
Stats
Type:
Excel Spreadsheet
Size:
92 kb
Pages:
13
Views:
1368
Posted:
08/02/09
Categories
DocStore > Templates > Spreadsheets
Tags
pipeline management, sales pipeline management, sales pipeline, prospect management pipeline

Sales Pipeline

View, download, and print this entire document by purchasing it for only $12.99
Contact Lead Qualified Lead Opportunity SALES PIPELINE MANAGEMENT 10% Potential Opportunity A, Inc. B Insurance C Publishing D, Inc. E Fine Art F Coffee G Design H Consultancy I Travel J Traders K, Inc. L Travel M Insurance N, Inc. O Design P Publishing Salesperson A. Green A. Green M. Brown A. Green A. Green F. Paul F. Paul A. Green M. Brown M. Brown M. Brown M. Brown A. Green F. Paul F. Paul F. Paul … … … … … … … … … … … … … … … … … … … … 20% 30% 40% 50% Pipeline Stage Negotiation Phase Verbal Approval Contract Purchase Order Contact Lead Qualified Lead Opportunity Executive Sponsorship Proposal Discussed Negotiation Phase Verbal Approval Contact Executive Sponsorship Proposal Discussed Contract … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … Qualified Lead Opportunity Executive Sponsorship Proposal Discussed Negotiation Phase Verbal Approval Contract Purchase Order 60% 70% 80% 90% 100% Forecast Close Q4 Q1 Q3 Q1 Q4 Q4 Q2 Q1 Q2 Q1 Q4 Q4 Q4 Q4 Q2 Q3 … … … … … … … … … … … … … … … … … … … … Potential Revenue 200,000.00 100,000.00 500,000.00 300,000.00 400,000.00 200,000.00 100,000.00 200,000.00 300,000.00 300,000.00 400,000.00 200,000.00 500,000.00 300,000.00 200,000.00 200,000.00 Weight 70.00% 80.00% 90.00% 100.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 10.00% 50.00% 60.00% 90.00% Weighted Forecast 140,000.00 80,000.00 450,000.00 300,000.00 40,000.00 40,000.00 30,000.00 80,000.00 150,000.00 180,000.00 280,000.00 160,000.00 50,000.00 150,000.00 120,000.00 180,000.00 … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … SALES PIPELINE MANAGEME 3000000 2500000 2000000 1500000 1000000 500000 Periodic 700000 600000 500000 400000 300000 200000 Cumulative 100000 0 0 Q1 Q2 Q3 Q4 Period Q1 Q2 Q3 Q4 Ex'd Sales 640,000.00 300,000.00 630,000.00 860,000.00 1 2 1 2 3 4 5 6 Stage Contact Lead Qualified Lead Opportunity Executive Sponsorship Proposal Discussed MANAGEMENT 3 4 5 6 7 8 9 10 ead y Spon