2. Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05...

2. Copy and paste the following data into Excel:

P	Q
$140.25	5375
$137.45	5616
$136.05	5641
$133.25	5744
$130.45	5806
$123.44	6055
$122.04	6368
$119.24	6382

a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is the point price elasticity of demand when P=$140.25? What is the point price elasticity of demand when P=$135.50? d. To maximize total revenue, what would you recommend if the company was currently charging P=$122.04? If it was charging P=$135.50? e. Use your first demand function to determine an equation for TR and MR as a function of Q, and create a graph of P and MR on the vertical and Q on the horizontal axis. f. What is the total-revenue maximizing price and quantity, and how much revenue is earned there? (Round your price to the nearest cent, your quantity to the nearest whole unit, and your TR to the nearest dollar.) Compare that to the TR when P = $140.25 and P = $135.50.

Expert Solution

(a) The regression results is presented below. The estimated regression looks reasonable to capture the effect. The coefficients are individually statistically singnificant as evident from the corresponding p-values. Also, 95% variations in price is explained by the independent variable.

Rahul Sunny answered 2 years ago

2. Copy and paste the following data into Excel: P Q $15.25 125 $14.79 133 $14.33...

2. Copy and paste the following data into Excel: P Q $15.25 125 $14.79 133 $14.33 140 $13.57 141 $12.96 147 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is the point price elasticity of...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513 $195.30 4655 $191.10 4696 $182.70 4949 $172.20 5142 $163.80 5313 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What...

Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05 5641...

Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05 5641 $133.25 5744 $130.45 5806 $123.44 6055 $122.04 6368 $119.24 6382 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513 $195.30 4655 $191.10 4696 $182.70 4949 $172.20 5142 $163.80 5313 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is...

Copy and paste the following data into Excel: P Q $87.50 370 $82.25 399 $81.38 410...

Copy and paste the following data into Excel: P Q $87.50 370 $82.25 399 $81.38 410 $76.13 438 $70.88 444 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is the point price elasticity of demand...

Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data...

Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data fixed cost 16,000 Units 1,050 variable cost per unit 4.75 revenue =D2*B4 sell price per unit 6.5 expenses =B2+(B3*D2) profit =D3-D4 Use Excel's Goal Seek to answer the following question. Assuming that demand is fixed at 1,050 units, what is the sell price per unit that results in break even? Enter only the numerical solution. Do

No Copy Paste, No Handwritten Here are the 2 questions. Pl, solve these using the data...

No Copy Paste, No Handwritten Here are the 2 questions. Pl, solve these using the data given below. The explanation should be very clear and each step has to be shown. Operating costs (excl. depreciations & amortization): $4.5m Depreciation and amortization: $1.5m Interest: $0.7m Net Income: $2.8m Tax Rate: 35% 1 Find out the EBITDA 2 calculate the sales level which would give a net income of $4.2million for the following year, given that operating costs (given above) will get...

The following data are related to Copy, Paste, and Attach (CPA) Corp’s Ending Inventory (Inventory is...

The following data are related to Copy, Paste, and Attach (CPA) Corp’s Ending Inventory (Inventory is valued as of December 31 of each year provided, which is CPA Corp’s year-end): Year Price Index Inventory at End-of-Year Prices 2015 100 $159196 2016 125 $263594 2017 150 $304976 Using the dollar-value LIFO method, what is the value of CPA Corp’s ending inventory on December 31, 2017?

1. Determine if the following deduction rule is valid: p∨q ¬p _______ ∴ q 2. Determine...

1. Determine if the following deduction rule is valid: p∨q ¬p _______ ∴ q 2. Determine if the following is a valid deduction rule: (p∧q)→r ¬ p ∨ ¬ q ________ ∴ ¬r 3. Suppose p and q are (possibly molecular) propositional statements. Prove that p and q are logically equivalent if any only if p↔q is a tautology.

Note: Strictly no copy paste, write in your language. Q. What are the best case studies...

Note: Strictly no copy paste, write in your language. Q. What are the best case studies and examples of Lean practice?

Question