Marketing Engineering for Excel Software

Free Trial

University Instructors: Please download the academic version of software from our academic support site.

Resource Allocation Model
What you put in... What you get out...
  • Number of market segments, products, geographies or other basis for resource allocation
  • Current level of spending and associated sales
  • Profit margins
  • Response functions - how sales would change if spending were higher or lower than current spending
  • Constraints (minimum / maximum) for each basis unit
  • Optimal level of total spending
  • Optimal allocation of spending across units
  • Profit associated with optimal plan versus current plan
  • Incremental gain or loss associated with changes from current or optimal plan

Resource Allocation helps optimize resource sizing and resource allocations across segments, products, channels, etc. It answers such questions as

resource allocation

There are four primary steps: