Last version published: 06/11/2018 16:51
Publication number: ELQ-56576-2
View all versions & Certificate
Pricing Analytics PPT: Find the optimal price of your product
Estimating Demand Curves Without Price Elasticity to determine the optimal price that maximizes your profit margin.
The most common way of constructing demand curves depends on the product’s price elasticity. But what if that input is not available, or the figures cannot be obtained for a given product?
Another way to do this is by making reasonable estimates of the demand for a product at its high, median and low price points, which then allows you to construct an estimate of the demand curve over the range of those given prices.
The following downloadable presentation shows how you can use Excel’s line fitting and solver functionality to construct an estimate of the demand curve, without having to know the price elasticity of the product at hand.
This will allow you to determine the optimal price for the product, which will maximize your profit margin.
The attached PDF Document includes 33 slides which you can use as a support to the YouTube video attached.
-> Best price – price that yields max profits, not necessarily max
-> Excel’s Solver tool can be used to construct useful pricing
Solver tries all reasonable solutions that fit the specified model
-> Chooses optimal solution – values for variable cells that
produce best value for target cell
- Michael Lamont
This business tool includes
1 PDF File + 1 video
Michael Lamont offers you this business tool for free!
read for free
Add to bookmarks
- Bruno Cavazzuti(last updated: 14/10/2018 21:26)
- Maryyam Khan(last updated: 03/10/2018 11:57)
- Umer Farooq(last updated: 20/09/2018 16:24)
- Tram Dinh(last updated: 29/08/2018 16:57)
- Abdelrahman Zaki(last updated: 01/08/2018 06:13)
- Firas Eideh(last updated: 23/07/2018 14:07)
- Balaknath Datta(last updated: 22/07/2018 08:51)
- MA(last updated: 19/06/2018 08:26)
People using this tool also downloaded
Pricing Your Product: Product Costing Excel TemplateExcel spreadsheet to calculate how much it costs to produce your product.productmarketingpricingcoststemplateexcelpricefreedownload12,366 remove_red_eye
Cash Sweep Concepts Excel TemplateUnderstand the four concepts of cash sweeping.financemodeltemplateexceldownloadcash sweepconcepts888 remove_red_eye
Simple GANTT Chart Template for Kick-offsThe GANTT chart template used by Paua Ventures to kick off meetings with our new investments.ganttchartinvestorstemplateexcelvcfreedownloadxls764 remove_red_eye
Investor Pitch Deck for StartupsHere’s the winning formula designed to raise hundreds of millions of dollars.investorstartupexcelfreedownloadpitch deckpitch deck samplepitch deck templatefundraising tool883 remove_red_eyefreeby Donna Griffit
SaaS Metrics Excel TemplateA standard SaaS reporting excel template for entrepreneurs to customize.startupsaaskpistemplateexceldownloadreportingrecurring revenue model4,174 remove_red_eyefreeby Amit Karp
Financial Report Template: Waterfall ChartTrack your financial performance and forecast more efficientlyfinancialperformancetoolreportforecasttemplateexcelfreedownload413 remove_red_eyefreeby Brian Ascher
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis3,458 remove_red_eye$9.00by Alexander Jarvis
Financial Model for Mobile Payment StartupIncludes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.income statementfinancemodelbalance sheetstartuptemplateexcelfreedownloadmobile1,960 remove_red_eyefreeby Tayfun Uslu
Virtual World Freemium Business Model TemplateA business model excel spreadsheet to help companies make business decisions and understand how variables interact.business planstartupfreemiumrevenue modeltemplateexcelspreadsheetfreedownloadvirtual worldgaming708 remove_red_eye
Sensitivity & Scenario Analysis Excel TemplateHow to use an excel data table for sensitivity and scenario analysis for you financial model.modelsensitivity analysistemplateexceldownloadscenario analysisway tables4,426 remove_red_eye
Discussion feed for Pricing Analytics PPT: Find The Optimal Price Of Your Product
The user community and author are here to help. Go ahead!
- Hey it says Ijust downloaded the file but I dont see it, why is that?1arrow_drop_uparrow_drop_downReply reply
- Hey Lorraine,
Thanks for your message. Sure! So here is the process to access your PDF file:
1/ Go to https://www.eloquens.com/account/products
2/ Then click on the Blue Title
3/ Then click on the big Blue "Download" Button
4/ Go to your "Downloads" folder on your PC/Mac and access the PDF file from here
Hope this helps!
The Eloquens Support Teamarrow_drop_uparrow_drop_downReply reply