Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions