From the course: Excel: Market Research Strategies
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Price or volume? The big trade-off - Microsoft Excel Tutorial
From the course: Excel: Market Research Strategies
Price or volume? The big trade-off
- [Instructor] Inherently, all businesses have to choose between price and quantity sold. That's the fundamental truth behind the demand curve, but how do you balance these two factors? Let's take a look at an example of what I call the power of price using Excel. I'm in the 02_04_Begin Excel file. Now, we're looking at the 02_04 price versus volume sheet, and what this shows is, for a hypothetical product with unit sales of 1,000, a price of 45, meaning a revenue of 45,000, and then, unit cost of $16, cost of goods sold of 16,000 then, an overhead of 8,000, we have a profit of 21,000. Now, for the firm, our goal is to maximize profit. As a market researcher, your role is to help the firm to understand how they can go about maximizing that profit by making changes to the product, its features, its price, its attributes, et cetera. So, what if you were presented with an opportunity to either have a 1% improvement in price,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Product pricing basics4m 13s
-
(Locked)
Products with pricing power3m 59s
-
(Locked)
Products without pricing power4m 22s
-
(Locked)
Price or volume? The big trade-off4m 59s
-
(Locked)
Price differentiation and wholesaling4m 16s
-
(Locked)
Advertising attribution and identity5m 36s
-
(Locked)
Hedonic shoppers and price4m 59s
-
(Locked)
A/B testing and Excel5m 49s
-
(Locked)
-
-
-