Docstoc

Sales Forecasting Tool

Document Sample
Sales Forecasting Tool Powered By Docstoc
					Sales Forecasting Tool: Sales and Customer Service

(Instructions: The sales rep should fill in only the white cells. The blue cells either have text or formulas and should not be replaced.)

Representative:              Bill Hardy       Quota:            $ 20,000.00                                       Forecast
Month / Year                 Nov 2011         MTD Sold:         $ 5,250.00                     Current Week Forecast:               $ 6,000.00
Week of (Monday):               11/7          % to Quota:             26.3%                    Monthly Forecast:                    $ 21,500.00



Opportunities
                                                                 Product 1        Product 2       Product 3      Total Expected
   Account Name            Contact / Title         Phone                                                                                Lost ($)        Pushed ($)
                                                                Revenue ($)      Revenue ($)     Revenue ($)      Revenue ($)

ABC Company             John Smith / COO      555-555-5555      $    1,000.00   $ 2,000.00      $    3,000.00    $       6,000.00
XYZ Company             Jane Smith / Director 444-444-4444      $    2,000.00   $ 1,000.00      $    5,000.00    $       8,000.00
Acme Inc.                                     333-333-3333
                        Sue Longstreet / Manager                $         -     $      -        $         -      $            -     $    7,500.00
Buzz Corp.              Mark Reynolds / Buyer 222-222-2222      $         -     $      -        $         -      $            -                     $      6,075.00
Crest LLC               Phil Sommers / Owner111-111-1111        $      750.00   $ 1,500.00      $    3,000.00    $       5,250.00
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                                 $            -
                                                                                                     
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:1145
posted:1/4/2012
language:English
pages:6
Description: This template spreadsheet should be used by sales representatives to track and record sales opportunities. The sales representative should input data for: the account name, contact, product revenue expected, lost amount, pushed amount, and next step actions. The spreadsheet will automatically calculate totals for: expected revenue, amount sold, amount lost, amount pushed, active opportunities, and monthly play. Companies seeking a standardized form to help sales representatives stay organization and accurately track sales opportunities should use this form.
This document is also part of a package 10 Documents to Start Your Company 10 Documents Included