Notice: Please visit Enginius.biz for our latest Marketing Engineering software
Marketing Engineering for Excel has reached end of life and is no longer receiving updates. Please visit Enginius.biz to explore our newest online marketing analytics platform which is designed to replace the Marketing Engineering for Excel add-in.
Students: If your instructor has specifically told you to use Marketing Engineering for Excel software, please continue on this site.

Instructor Newsletters

Segmentation/Targeting Model (Classification)

Posted in Software Models

What you put in... What you get out...
  • Customers' importance ratings for each measure of value for offerings in a product class
  • Customer descriptors (demographic or firmographic variables)
  • Number, size, and profile of needs-based market segments
  • Identification of factors that differentiate segments, both in terms of needs and descriptors
  • Classification tool to allocate any potential customer to a segment based on customer descriptors

Resource Allocation Model

Posted in Software Models

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

Positioning Analysis and Perceptual Mapping Model

Posted in Software Models

What you put in... What you get out...
  • Customers' rating of focal brand and key competitors on dimensions of merit
  • Individual customer preference ratings of all competitors
  • Perceptual map, showing which brands are closest to one another
  • Attributes that differentiate brands
  • Locations of individual customer preferences
  • Projected market share associated with current and new positions on the map

GE/McKinsey Portfolio Matrix Model

Posted in Software Models

What you put in... What you get out...
  • SBU, product, or segment ratings on key attributes
  • Importance of these attributes to the firm
  • Visual representation of relative attractiveness of SBUs, products, or market segments on a 2-dimensional map
  • Sensitivity of map to attribute importance scores

Customer Lifetime Value

Posted in Software Models

What you put in... What you get out...
  • Observed churn rates
  • Customer acquisition cost
  • Number of customers/segments
  • Gross margins by segment
  • Customer transition probabilities across segments
  • Value of current customer base
  • Time required to recoup customer investments
  • ROI on customer/segment investments
  • Size and profitability of customer segments over time; sensitivity to marketing investment plan