Forecast based off a changing % of spend

AdamPriest

New Member
Joined
Oct 28, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi,

I'm trying to forecast daily spend for an advertising campaign and would like to know if it's possible to 'pivot' the data based off a %.

I have four different budgets amounts to share between two products and would like to pivot my data based off different % splits between the two i.e. what would my projected sales be if put 40% of the budget into product A and 60% into Product B. Ideally I'd like to be able to update these %'s on the go and have sheet recalculate as i do so.

My data is based off budget amounts of;
  • £250
  • £500
  • £750
  • £1000
An example of my set up is on the image below
  • 92 Day campaign
  • The daily spend figures are currently calculated off a 50% split, which I've simply done by dividing the budget amount by 92 and then 2 i.e =A6/92/2
Is it instead possible to run the calculations for daily spend off the % in cell B2?

1603883566309.png


Thanks,

Adam
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,234
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try

Book1
AB
1A40%
2B60%
3Days92
4
5ForcastB
6BudgetDaily
72501.63
85003.26
97504.89
1010006.52
Sheet1
Cell Formulas
RangeFormula
B2B2=1-B1
B7:B10B7=A7*VLOOKUP($B$5,$A$1:$B$2,2,0)/$B$3
Cells with Data Validation
CellAllowCriteria
B5List=$A$1:$A$2
 
Solution

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,234
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
you're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,118,597
Messages
5,573,127
Members
412,504
Latest member
Confused exl
Top