Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sorry for asking again, but I am trying to create the graphs by the instructions given to me from a previous Q&A. I was asking

Sorry for asking again, but I am trying to create the graphs by the instructions given to me from a previous Q&A. I was asking how I can make the following code given to me into excel graphs:

a)

Price (P) ^ | 60,000 + demand (P(x) = 60,000 - 30x) |\ | \ | \ | \ 45,000 + \____________ | / \ | / \ | / cost (TK = 29.5x^2 + 500x + 50,000) 30,000 + / | / |/ 0 -----|-----------------|--------> Quantity (x) 0 500

b) Price (P) ^ | 45,000 + A C |\ / / | \ / / | \ / / | \ / / D 29,500 + \/ / | /\ / | / \/ | / B | / 0 -----|---------------> Quantity (x) 0 500

I was given the following instructions to make a table in excel:

a) In Column A (Quantity), input values from 0 to 500, in increments of your choice (e.g., 1, 5, or 10).

b) In Column B (Price), input the formula for demand (P(x) = 60,000 - 30x) in the first cell (B2), with x being the corresponding value in Column A. Drag this formula down to calculate the values for the entire range of x.

c) In Column C (Cost), input the formula for cost (TK = 29.5x^2 + 500x + 50,000) in the first cell (C2), with x being the corresponding value in Column A. Drag this formula down to calculate the values for the entire range of x.

how do I write point b) and c) into the cell?

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

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

Recommended Textbook for

A Framework For Internal Auditings Entity Wide Opinion On Internal Control

Authors: Wanda A. Wallace, Thomas White

1st Edition

0894135317, 978-0894135316

More Books

Students also viewed these Accounting questions

Question

Explain what diversity does not represent.

Answered: 1 week ago

Question

Conduct a needs assessment. page 269

Answered: 1 week ago