Northshore Freight Co.
Find a variable
PERIOD 1
PERIOD 2
ASSUMPTIONS 14
PIPELINE FUNNEL
#Inbound enquiries
#Inbound enquiriesprevious period ×
ƒ
412
431
#Enquiry calls held
#Inbound enquiriesthis period ×
ƒ
188
203
#Outbound calls held
18
#Outbound touches sent×
ƒ
64
71
#Total calls held
#Outbound calls held+
ƒ
252
274
#Site walkthroughs
#Total calls heldthis per…
ƒ
96
104
ACCOUNT BUILD
#New accounts
#Site walkthroughst-Sales cycle (months…
ƒ
31
34
#Renewed accounts
#Accounts due to renewthi…
ƒ
27
29
#Lapsed accounts
−roundup(#Accounts due to r…
ƒ
9
11
#Total accounts
#Total accountsprevious per…
ƒ
1,284
1,318
#Accounts due to renew
#New accountst-Contract le…
ƒ
#Carried-over accounts
#Total accountsthis period
ƒ
1,275
1,307
BOOKINGS BUILD
$New ACV
#New accountsthis period
ƒ
$86.4k
$91.2k
$Lapsed ACV
#Lapsed accountsthis per…
ƒ
−$7.8k
−$9.1k
$Renewed ACV
#Renewed accountsthis per…
ƒ
$52.3k
$54.9k
$Total ACV
#Total accountsthis period
ƒ
$1.94m
$2.01m