There is no Optimal selling price!!

Hi all,

 

I have never come across a skewed issue like deriving optimal selling price. Can you explain why the Quantity demanded and Price forecasted does not generate profits with different levels of inputs?

Problem in excel file

 

Txs


Attached File : 2750458 20201124230506 demand forecasting.xlsx downloaded: 140 times
Replies (1)

ok, thanks for all your help and replies. I have sorted out the problem today and found out 

Regression Cost function Y= a + b X forecasts total costs but they are not equal to MC=MR derived from demand curve equation MR=MC. 

Also, found out that, Constants a, b from regression output will not give accurate results when used to define MR=MC function.

txs

 

Can download the excel answer

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
13 November 2026
Charted Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA Final

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details