How to find how much output to produce given a cost function in Google Sheets

Опубликовано: 22 Апрель 2026
на канале: Econ Examples Travis Klein
416
1

Assume that a competitive firm has the total cost function:

TC = 1q^3 - 40q^2 + 820q + 1900

Suppose the price of the firm's output (sold in integer units) is $600 per unit.

Create tables (but do not use calculus) with columns representing cost, revenue, and profit to find a solution.

How many units should the firm produce to maximize profit?

Please specify your answer as an integer.