Question: 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

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!