Microsoft Office Tutorials and References

In Depth Information

**Nonlinear Example Using the Solver**

FIGURE 35.4
Options Menu

are fixed

so you can ignore the negligible variable costs. Following your Economics

class, you were able to figure out that his revenue

—

—

based on the demand function

and the number of memberships he will sell

—

would be:

06P
2

R

¼

0

:

þ

50P

This equation is not a straight line.

Using the formula in Excel, you were able to calculate the different levels of

revenue for different price levels. See Figure 35.6.