**Spreadsheet #2: Budget
and Indifference Curve Model**

Create a spreadsheet illustrating the determination of a consumer's utility maximization bundle.

[Here's an example: Indifference & Budget Spreadsheet ]

**Step 1: ** To begin, chose your own values for the parameters below in
order to create your budget and indifference curves.

I = P_{b}*B + P_{c}*C |
Budget Equation |

U = B*C | Utility Function |

Where B and C are the amounts of two goods. The parameter values to be chosen are:

I = Consumer Income

P_{b} = Price of good B

P_{c} = Price of good C

U = Utility level

**Step 2: ** Create a table containing the quantities of good C and
B-Budget and B-Utility. Under the good C column, simply enter data
beginning with 0 and increasing by increments of, say, 5. Under
the good B-Budget column, enter a formula that solves the budget
equation for B. Under the B-Utility column, enter a formula that
solves the utility function for B. Use this table to create an
X-Y chart (not a line graph!) showing the budget and indifference curves. In creating
your table, please make sure that you "anchor" the
parameter values to ones chosen in Step 1. (By doing this, your
graphs and calculations will adjust automatically whenever you
change any of the parameter values). Your graph should have good
C plotted on the x-axis and good B on the y-axis.

Be sure that you properly format the chart and completely label all axes and curves. Please organize your spreadsheet so as to minimize the amount of scrolling that a user must do.

**Step 3: ** Create a table to organize your answers to the following
questions:.

Q1: Given your initial parameter values for the budget line, what is the maximum utility that can be obtained? Approximately (to the nearest whole number) how many units of good B and good C are chosen at this bundle?

Q2: What happens to your answer to Q1 if the consumer's income increases by 25%? Is good C a normal or inferior good? Is good B a normal or inferior good?

Q3: What happens to your answer to Q1 if the price of good B decreases by 25%?

Q4: What happens to your answer to Q1 if the price of good C increases by 25%?

Q5: What happens to your answer to Q1 if the consumer's income increases by 25% and the prices of good B and C also increase by 25%?

**Step 4:** Save your spreadsheet to a file named as NAME_SS2.xls
(e.g., delemeester_ss2.xls) and email it to me by deadline.