Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need it in Excel Please Create an Excel worksheet with formulas that show the calculations needed to determine the price p of product given

I need it in Excel Please

Create an Excel worksheet with formulas that show the calculations needed to determine the price p of product given a demand function, the cost to product a unit is fixed at $3/unit and the profit is pq-2q. Assume the demand function is q=20-2*p.

Use any technique to find the maximum profit when the linear demand is q=20-2*p and a fixed cost of production $3 a unit.

Create a graph that shows profit is maximized at the given price.

A screenshot of a suggested layout follows

image text in transcribed

Marion's Profit 50 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 50 Optimual Production Quantity is 6 or 7 units Maximum Profit is S24 when either 6 or 7 units are produced 100 150 200

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Principles Of International Auditing And Assurance

Authors: Rick Hayes, Philip Wallage, Peter Eimers

4th Edition

9463720065, 978-9463720069

More Books

Students also viewed these Accounting questions

Question

1. Describe the types of power that effective leaders employ

Answered: 1 week ago