Develop a spreadsheet for the following three months hypothetical budget.

$1.$ Enter the data.

$2.$ Put formulas in the shaded cells.

$3.$ Answer the following $$what$-$if$$ questions by changing the values put into the appropriate cells.

a$.$ What is the effect on overall Gain$/$Loss if the sale of the current car actually is $$2500?$

b$.$ What is the effect on the February Gain$/$Loss if February utilities are actually $$170?$

c$.$ What is the effect on overall Gain$/$Loss if savings increases from $7\%$ to $9\%$ each month?

WINTER QUARTER BUDGET

January February March Totals

Budget Item

Salary Income $$4,000$ $$4,000$ $$4,000$ $$12,000$

Sale of current car $$3,000$ $$3,000$

Apartment rent $$1,300$ $$1,300$ $$1,300$ $$3,900$

Groceries $$450$ $$420$ $$450$ $$1,320$

Gasoline $$60$ $$40$ $$90$ $$190$

Insurance $$200$ $$100$ $$100$ $$400$

New tires $$300$ $$300$

Parking $$85$ $$85$ $$85$ $$255$

Restaurants $$150$ $$130$ $$150$ $$430$

Utilities $$130$ $$130$ $$110$ $$370$

Savings investment at $7\%$ of salary $$280$ $$280$ $$280$ $$840$

Down payment on new car $$5,000$ $$5,000$

Gain$/$Loss $$1,345$ $$1,515$