2003 Budget spreadsheet with expenses and income data for three months.

The image shows a spreadsheet titled "2003 Budget" with data for expenses and income over three months (January, February, March), along with totals. The task appears to be calculating the total expenses, total income, and balance for each month and overall.

Let’s go step-by-step to solve this problem:

---

🔹 Step 1: Calculate Total Expenses for Each Month

We sum up all the expense items (Rent, Car Payment, Electrical Bill, Telephone Bill, Food, Gas, Snowboarding) for each month.

#### January:
- Rent: 350
- Car Payment: 235
- Electrical Bill: 100
- Telephone Bill: 50
- Food: 200
- Gas: 80
- Snowboarding: 125
Total = 350 + 235 + 100 + 50 + 200 + 80 + 125 = 1,140

#### February:
- Rent: 350
- Car Payment: 235
- Electrical Bill: 95
- Telephone Bill: 35
- Food: 215
- Gas: 60
- Snowboarding: 150
Total = 350 + 235 + 95 + 35 + 215 + 60 + 150 = 1,140

#### March:
- Rent: 350
- Car Payment: 235
- Electrical Bill: 85
- Telephone Bill: 40
- Food: 195
- Gas: 50
- Snowboarding: 125
Total = 350 + 235 + 85 + 40 + 195 + 50 + 125 = 1,140

✔ So, Total Expenses for each month is $1,140.

> Note: All months have the same total expenses — likely intentional or a pattern.

---

🔹 Step 2: Calculate Total Income for Each Month

Sum of Parents, Part-time Job, and Scholarships.

#### January:
- Parents: 800
- Part-time Job: 300
- Scholarships: 200
Total = 800 + 300 + 200 = 1,300

#### February:
- Parents: 800
- Part-time Job: 250
- Scholarships: 250
Total = 800 + 250 + 250 = 1,300

#### March:
- Parents: 800
- Part-time Job: 215
- Scholarships: 200
Total = 800 + 215 + 200 = 1,215

So:
- January: $1,300
- February: $1,300
- March: $1,215

---

🔹 Step 3: Calculate Balance for Each Month

Balance = Total Income – Total Expenses

#### January:
- Income: 1,300
- Expenses: 1,140
→ Balance = 1,300 – 1,140 = $160

#### February:
- Income: 1,300
- Expenses: 1,140
→ Balance = 1,300 – 1,140 = $160

#### March:
- Income: 1,215
- Expenses: 1,140
→ Balance = 1,215 – 1,140 = $75

---

🔹 Step 4: Calculate Totals Column (Overall)

Now, sum across the three months.

#### Total Expenses (Column F, Row 13):
- January: 1,140
- February: 1,140
- March: 1,140
→ Total = 1,140 × 3 = $3,420

#### Total Income (Column F, Row 23):
- January: 1,300
- February: 1,300
- March: 1,215
→ Total = 1,300 + 1,300 + 1,215 = $3,815

#### Overall Balance (Row 26):
- Total Income – Total Expenses = 3,815 – 3,420 = $395

---

✔ Final Answer Summary

| Category | January | February | March | Totals |
|------------------|--------|----------|-------|------------|
| Total Expenses | 1,140 | 1,140 | 1,140 | 3,420 |
| Total Income | 1,300 | 1,300 | 1,215 | 3,815 |
| Balance | 160 | 160 | 75 | 395 |

---

📌 Instructions for Excel:

To fill in the cells:

- F5 (Total Expenses): `=SUM(B5:D5)` → copy down to F12
- F13 (Total Expenses): `=SUM(F5:F12)`
- F19 (Total Income): `=SUM(B19:D19)` → copy down to F22
- F23 (Total Income): `=SUM(F19:F22)`
- G13: `=SUM(B13:D13)` → but better to use formula: `=SUM(F5:F12)`
- G23: `=SUM(F19:F22)`
- G26 (Balance): `=F23 - F13` → gives $395

You can also compute monthly balances in row 26:
- B26: `=B23-B13` → 160
- C26: `=C23-C13` → 160
- D26: `=D23-D13` → 75

---

✔ Conclusion:

The overall balance for the three-month period is $395.

This means after covering all expenses, there is a surplus of $395 for the quarter.

Let me know if you want the formulas inserted into the spreadsheet!