From the course: Excel: Market Research Strategies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Price differentiation and wholesaling

Price differentiation and wholesaling - Microsoft Excel Tutorial

From the course: Excel: Market Research Strategies

Start my 1-month free trial

Price differentiation and wholesaling

“

- [Instructor] Market research is inherently a quantitative exercise in exploring a market. That means we need to be able to effectively model profits and unit sales for a product, based on a variety of different factors or choices. One instance might be a change in the business model. For instance, we could talk about simply selling a product in a standard retail fashion where we charge a price and people pay for it on a unit sales basis. An alternative to this might be a wholesale type model or a club pricing type model similar to that followed by something like Sam's Club, or Walmart, or many of the other wholesale firms that are out there. Let's take a look at how we might model that in Excel. I'm in the zero two, zero five begin Excel file. Now what we have here is a wholesale pricing example where we've got the equivalent of a price club. We've got a particular product that's being sold. We've got a number of…

Contents