Optimal Advertising

This example illustrates two uses of Evolver. In the Parameter Estimation sheet, historical monthly values of sales and advertising are used to estimate the parameters of a sales function. Evolver is used to find the parameters that minimize the sum of squared errors between actual and forecasted sales. Then in the Optimization Model sheet, Evolver is used to maximize the NPV of net profits by choosing monthly advertising levels.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram