1 2 5 5 3 4 12 14 15 10 7. 15 11 8 14 12...

Transcribed Image Text:

1 2 5 5 3 4 12 14 15 10 7. 15 11 8 14 12 2. Writing Excel formulas in cells C3 through C11 in a spreadsheet like the following, calculate the values of TR = 320 -202 for values of Q from 0 to 8. (a) What is the revenue-maximizing quantity? (b) Now subtract TC = 30 + 0.5Q- Q2 from the TR function in (a) to get a profit function. Calculate profit for values of Q from 0 to 8. What is the profit-maximizing quantity? B. C D E 2. TR TR-TC 2 3 7 4 8 6. 10 7 11 8 12 1 2 5 5 3 4 12 14 15 10 7. 15 11 8 14 12 2. Writing Excel formulas in cells C3 through C11 in a spreadsheet like the following, calculate the values of TR = 320 -202 for values of Q from 0 to 8. (a) What is the revenue-maximizing quantity? (b) Now subtract TC = 30 + 0.5Q- Q2 from the TR function in (a) to get a profit function. Calculate profit for values of Q from 0 to 8. What is the profit-maximizing quantity? B. C D E 2. TR TR-TC 2 3 7 4 8 6. 10 7 11 8 12

Answer rating: 100% (QA)

A D E a b Profit TR TC 2 Q TR 32Q 2Q2 05Q3 Q2 3... View the full answer