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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started