Question: I need this question answered in an Excel Sheet, please send me the excel file , I need follwoing columns in Excel Quantity Price Revenue

I need this question answered in an Excel Sheet, please send me the excel file , I need follwoing columns in Excel

Quantity Price Revenue Total Costs Profits Marginal Revenue

Suppose that managers at Honda are deciding how to price the new Honda Accord. The managers estimate that their total costs increase by $20,000 for each car they produce. They also estimate the demand curve they face; it is described by the equation: Q = -0.4 P + 16,000, where Q represents the quantity of Honda Accords they will sell and P represents the price they charge in US dollars. We can re-write that demand curve as: P = 40,000 - 2.5 Q. Take every possibly quantity that the managers might choose between 0 and 7,000 in units of 100. For each possible quantity, calculate the associated price the managers would need to charge, the revenue they would earn, and the total costs. You can then calculate profits for each level of quantity. Highlight the cell that contains the highest value of profit. Finally, you can also approximate marginal revenue here as the change in total revenue after the next 100 cars are produced. At what quantity does marginal revenue roughly equal marginal cost? Highlight that level of marginal revenue.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!