Enroll in the Master Course 👉👉 [ Ссылка ]

If you like this video, enroll now to receive UNLIMITED LIFETIME ACCESS to more than 800+ videos, 1,500+ downloadable files, certificate of completion, and unlimited access to ALL future content.

As Microsoft Excel releases new functions and formulas, you will automatically receive access to the videos, so you won't need to purchase multiple courses to get new updates/features.

Harvard asked Dr. Winston to design their course, and Microsoft asked him to write their book. In this video Dr. Winston discusses how to use the Excel Solver to build a model that will help determine the maximum price to set in order to maximize profit.

This is the problem: Determining the optimal price for a product is something that virtually all companies struggle with. If you set the price too high, then you will miss out on sales, but if you set the price too low, then you will squeeze your margins. Knowing how to set the optimal price to have the highest margin and most sales, is something every company is trying to figure out.

This is why it is important for you to solve it: If you could help your company maximize profit based on the optimal price to charge, then not only would your company become more profitable, but your expertise would.

This is how Dr. Winston solves it: Dr. Winston uses the Excel Solver to create constraints and uses the Trend Curve Polynomial Feature to come up with a price that maximizes profit.

If you like this video, it comes from his excel 2019 book, you can get it here:

Excel Data Analysis and Business Modeling 👉 [ Ссылка ]

Marketing Analytics 👉👉 [ Ссылка ]

Analytic Stories 👉👉 [ Ссылка ]

For the book, Power Pricing: How Managing Price Transforms the Bottom Line 👉👉 [ Ссылка ]

Follow us on social media:

Instagram 👉👉 [ Ссылка ]
Facebook 👉👉 [ Ссылка ]
LinkedIn 👉👉 [ Ссылка ]

To follow along to this video with the starting and ending files, you can download the files here:

Start File 👉👉 [ Ссылка ]
Finish File 👉👉 [ Ссылка ]

Free 21-Day course 👉👉 [ Ссылка ]

*Some of the links and other products that appear on this video are from companies which we will earn an affiliate commission or referral bonus.

#PROFIT #MAXIMIZINGPRICE #NONLINEAR #TRENDCURVE #EXCELSOLVER #DATAANALYSIS #POLYNOMIAL #DATASCIENCE #EXCEL #MICROSOFTEXCEL #EXCELTIPS #EXCELTRICKS #EXCELHACKS #TOPEXCELTIPS #BUSINESSMODELING #PIVOTTABLES #PIVOTTABLES #POWERBI #BUSINESSINTELLIGENCE #BI #DATA #BIGDATA #FORECASTING #RETIREMENTFUND #STATISTICS #LINEARMODEL #DATAMODELING #DATAMODEL #REGRESSION #MULTIPLEREGRESSION #OPERATIONS #SUPPLYANDDEMAND #MAXIMIZING_PRICE #NON_LINEAR #TREND_CURVE #EXCEL_SOLVER #DATA_ANALYSIS #DATA_SCIENCE #MICROSOFT_EXCEL #EXCEL_TIPS #EXCEL_TRICKS #EXCEL_HACKS #TOP_EXCEL_TIPS #BUSINESS_MODELING #BUSINESS_INTELLIGENCE #BIG_DATA #RETIREMENT_FUND #LINEAR_MODEL #DATA_MODELING #DATA_MODEL #MULTIPLE_REGRESSION #SUPPLY_AND_DEMAND

свернуть