Small business sales lead tracker2

xlsx

School

Purdue Global University *

*We aren’t endorsed by this school

Course

400

Subject

Business

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by DrDinosaurPerson735

Page 1 of 3 COMPANY NAME Olson Harris Ltd. | Confidential DETAILED LEADS TRACKER 12/28/2023 Lead name Lead contact Lead source Lead region Lead type Chance of sale Forecast close Weighted forecast Adatom Corporation Madison Butler Website North Strategic $300,000.00 90% January $270,000.00 Adventure Works Jozi Kos Networking event South Strategic $200,000.00 10% February $20,000.00 Alpine Ski House Ashlee Barnes Networking event North Tactical $100,000.00 20% March $20,000.00 Total $600,000.00 $310,000.00 Potential opportunity LOGO GOES HERE

Page 2 of 3 Realtor Data FORECASTED SALES 12/28/2023 375,400 385,900 396,400 410,000 405,700 404,100 392,800 391,800 3 month moving average $385,900 $397,433 $404,033 $406,600 $400,866 $396,233 |Error| MAD $24,100 $8,267 $67 -$13,800 -$9,066 MAD=11,060 3MWA 0.5, 0.3, 0.2 $388,850 $401,010 $405,130 $405,760 $398,770 $394,560 |Error| MAD $21,150 $4,690 -$1,030 -$12,960 -$6,970 MAD=9,960 Exponential Smoothing a=0.5 $396,400 $403,200 $404,450 $404,275 $398,537 $395,168 |Error| MAD $13,600 $2,500 -$350 -$11,475 -$6,737 MAD=6,932 LAST 8 CONSECUTIVE VALUES Next Period Prediction

COMPANY NAME MONTHLY WEIGHTED FORECAST 1 2 3 4 5 6 7 8 $0 $2 $4 $6 $8 $10 $12 Monthly Cumulative Month Forecast Revenue LOGO GOES HERE

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Small business sales lead tracker2

Related Documents