Actual vs Forecast Question

[Yandeez]

Hi-

Attached is a simple worksheet that shows Actual vs Forecast # of Accounts and the corresponding volume in terms of dollars. Based on the contracts forecast in B5, how would one determine the contract # forecast based on the info provided. The right side shows target # of Accounts and Contract $. Thanks in advance.

 

[Hui]

You have a choice to make

Your Actual Average Contract $ based on the January Actuals is shown in D4 = $50,028

Your Target Average Contract $ based on the Target is shown in = $40,364 or =H5/H4

So For the forecast you have 12,000 contracts

You can multiply the 12,000 by either the January Actual using
=B5*D4
=$600,331,065

or you can multiply it by the Target Average using
=B5*H5/H4
=$484,363,636

 

[Yandeez]

TY HUI! Went with your first suggestion.