# Simple Marketing Budget Optimisation

This tool maximises output given a marketing spend function. The function should take the shape
$Y=f(spend,channels)$
such that total spend is constant. We use the function
$Y=a+b\ln(x_1)+c\ln(x_2)+...$,
where Y is output and x are the marketing channels, a, b and c are estimated parameters. You need to estimate these parameters in Excel, SAS, R or similar software. The ln() function ensures diminishing returns.
Total budget
a constant
b channel 1
c channel 2
d channel 3
e channel 4
f channel 5

Parameters b-f need to be positive.
Back to home