|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Three's Company
2003 Expenses |
|
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
|
| Robert
Britt |
|
|
Auto |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Insurance |
|
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
|
|
Gas |
|
$60 |
$55 |
$46 |
$76 |
$80 |
$85 |
$81 |
$78 |
$67 |
$65 |
$68 |
$100 |
|
|
Oil Change |
|
$25 |
$0 |
$0 |
$30 |
$0 |
$0 |
$29 |
$0 |
$0 |
$35 |
$0 |
$0 |
|
|
Lube |
|
$0 |
$0 |
$40 |
$0 |
$0 |
$0 |
$0 |
$40 |
$0 |
$0 |
$0 |
$0 |
|
|
Replacement
parts |
$15 |
$0 |
$20 |
$0 |
$17 |
$0 |
$120 |
$0 |
$0 |
$25 |
$0 |
$0 |
|
|
Payments |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Carwash |
|
$16 |
$18 |
$19 |
$17 |
$20 |
$21 |
$15 |
$0 |
$24 |
$19 |
$21 |
$14 |
|
|
School |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tuition |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Books |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Parking Permit |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
School Supplies |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Snacks |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Home |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rent/Mortgage |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$350 |
$350 |
$350 |
$350 |
$350 |
|
|
Utilities |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$60 |
$65 |
$75 |
$80 |
$77 |
|
|
Garbage |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$20 |
$20 |
$20 |
$20 |
$20 |
|
|
Repairs |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$125 |
$0 |
$0 |
|
|
Maintenance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Insurance |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$50 |
$50 |
$50 |
$50 |
$50 |
|
|
Groceries |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$180 |
$200 |
$195 |
$222 |
$225 |
|
|
Laundry |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$25 |
$20 |
$24 |
$21 |
$23 |
|
|
Personal
Hygiene |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$35 |
$30 |
$33 |
$34 |
$65 |
|
|
Pet Food |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Cleaning Supplies |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$15 |
$16 |
$20 |
$24 |
$18 |
|
|
Miscellaneous |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Clothing |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$300 |
$150 |
$200 |
$125 |
$215 |
|
|
Entertainment |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$200 |
$240 |
$215 |
$230 |
$210 |
|
|
Vacation |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$800 |
$0 |
$0 |
$0 |
$400 |
|
|
Life Insurance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$20 |
$20 |
$20 |
$20 |
$20 |
|
|
Health Insurance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Veteranarian bills |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Cigarettes |
|
$100 |
$95 |
$87 |
$93 |
$110 |
$114 |
$120 |
$105 |
$130 |
$100 |
$115 |
$140 |
|
|
|
|
|
|
|
|
|
| Three's Company
2003 Expenses |
|
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
|
| Renae
Young |
|
|
|
Auto |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Insurance |
|
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
$95 |
|
|
Gas |
|
$60 |
$70 |
$64 |
$75 |
$84 |
$85 |
$88 |
$90 |
$65 |
$80 |
$75 |
$79 |
|
|
Oil Change |
|
$0 |
$0 |
$35 |
$0 |
$0 |
$40 |
$0 |
$0 |
$44 |
$0 |
$0 |
$35 |
|
|
Lube |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$35 |
$0 |
$0 |
$0 |
$0 |
|
|
Replacement
parts |
$7 |
$0 |
$0 |
$15 |
$0 |
$0 |
$0 |
$0 |
$200 |
$0 |
$0 |
$15 |
|
|
Payments |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Carwash |
|
$7 |
$10 |
$15 |
$0 |
$7 |
$0 |
$10 |
$0 |
$16 |
$15 |
$9 |
$3 |
|
|
School |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tuition |
|
$150 |
$118 |
$130 |
$125 |
$130 |
$140 |
$110 |
$130 |
$80 |
$144 |
$165 |
$100 |
|
|
Books |
|
$250 |
$0 |
$180 |
$0 |
$0 |
$110 |
$0 |
$0 |
$0 |
$128 |
$0 |
$0 |
|
|
Parking Permit |
$25 |
$0 |
$25 |
$0 |
$0 |
$20 |
$0 |
$0 |
$0 |
$25 |
$0 |
$0 |
|
|
School Supplies |
$30 |
$21 |
$10 |
$0 |
$0 |
$15 |
$0 |
$0 |
$0 |
$22 |
$0 |
$8 |
|
|
Snacks |
|
$19 |
$18 |
$23 |
$27 |
$14 |
$16 |
$23 |
$22 |
$20 |
$27 |
$16 |
$11 |
|
|
Home |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rent/Mortgage |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Utilities |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Garbage |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Repairs |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Maintenance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Insurance |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Groceries |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food |
|
$60 |
$57 |
$55 |
$49 |
$68 |
$38 |
$29 |
$41 |
$57 |
$54 |
$62 |
$58 |
|
|
Laundry |
|
$15 |
$17 |
$14 |
$21 |
$19 |
$18 |
$24 |
$22 |
$20 |
$17 |
$24 |
$23 |
|
|
Personal
Hygiene |
$28 |
$39 |
$18 |
$40 |
$21 |
$39 |
$41 |
$42 |
$27 |
$30 |
$42 |
$30 |
|
|
Pet Food |
|
$21 |
$2 |
$6 |
$24 |
$3 |
$7 |
$19 |
$4 |
$1 |
$31 |
$9 |
$4 |
|
|
Cleaning Supplies |
$3 |
$0 |
$7 |
$0 |
$0 |
$13 |
$0 |
$0 |
$20 |
$0 |
$0 |
$16 |
|
|
Miscellaneous |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Clothing |
|
$160 |
$25 |
$16 |
$40 |
$230 |
$110 |
$170 |
$140 |
$110 |
$43 |
$26 |
$10 |
|
|
Entertainment |
$42 |
$79 |
$68 |
$53 |
$54 |
$66 |
$72 |
$85 |
$70 |
$57 |
$60 |
$80 |
|
|
Vacation |
|
$0 |
$0 |
$0 |
$0 |
$450 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$300 |
|
|
Life Insurance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Health Insurance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Veteranarian bills |
$42 |
$0 |
$0 |
$60 |
$0 |
$0 |
$0 |
$35 |
$0 |
$0 |
$0 |
$85 |
|
|
Cigarettes |
|
$60 |
$54 |
$48 |
$40 |
$57 |
$63 |
$72 |
$59 |
$53 |
$52 |
$61 |
$73 |
|
|
|
|
|
|
|
|
|
| Three's Company
2003 Expenses |
|
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
|
| Kristie
LeGore |
|
|
|
Auto |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Insurance |
|
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
$140 |
|
|
Gas |
|
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
$60 |
|
|
Oil Change |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Lube |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Replacement
parts |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Payments |
|
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
$240 |
|
|
Carwash |
|
$0 |
$12 |
$0 |
$0 |
$9 |
$0 |
$8 |
$24 |
$5 |
$0 |
$0 |
$0 |
|
|
School |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tuition |
|
$125 |
$153 |
$58 |
$97 |
$110 |
$206 |
$194 |
$145 |
$63 |
$0 |
$0 |
$0 |
|
|
Books |
|
$80 |
$65 |
$23 |
$12 |
$18 |
$54 |
$10 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Parking Permit |
$32 |
$34 |
$22 |
$18 |
$0 |
$18 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
School Supplies |
$12 |
$15 |
$17 |
$11 |
$19 |
$17 |
$14 |
$12 |
$16 |
$0 |
$0 |
$0 |
|
|
Snacks |
|
$4 |
$3 |
$6 |
$5 |
$9 |
$5 |
$6 |
$3 |
$5 |
$0 |
$0 |
$0 |
|
|
Home |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rent/Mortgage |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Utilities |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Garbage |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Repairs |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Maintenance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Insurance |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Groceries |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food |
|
$56 |
$59 |
$44 |
$34 |
$51 |
$40 |
$53 |
$36 |
$52 |
$55 |
$57 |
$82 |
|
|
Laundry |
|
$12 |
$0 |
$0 |
$15 |
$0 |
$0 |
$16 |
$0 |
$9 |
$0 |
$0 |
$11 |
|
|
Personal
Hygiene |
$8 |
$18 |
$9 |
$15 |
$20 |
$13 |
$7 |
$12 |
$16 |
$10 |
$14 |
$21 |
|
|
Pet Food |
|
$0 |
$0 |
$8 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$15 |
$0 |
$0 |
|
|
Cleaning Supplies |
$0 |
$15 |
$0 |
$22 |
$8 |
$9 |
$0 |
$0 |
$0 |
$0 |
$14 |
$0 |
|
|
Miscellaneous |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Clothing |
|
$42 |
$0 |
$115 |
$0 |
$76 |
$0 |
$29 |
$0 |
$80 |
$54 |
$48 |
$68 |
|
|
Entertainment |
$64 |
$45 |
$51 |
$62 |
$54 |
$42 |
$66 |
$72 |
$67 |
$93 |
$137 |
$114 |
|
|
Vacation |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$255 |
$0 |
$0 |
$0 |
|
|
Life Insurance |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
$23 |
|
|
Health Insurance |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Veteranarian bills |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
Cigarettes |
|
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$97 |
$98 |
$82 |
|
|
|
|
|
|
|
|
|
| Three's Company 2003 Expenses |
|
|
| Totals and Formulas |
|
|
Totals for Robert |
|
|
|
Totals for Robert |
|
|
|
|
|
|
Auto |
|
|
$2,901 |
|
Auto |
|
|
=SUM(D45:O51) |
|
|
|
School |
|
$0 |
|
School |
|
=SUM(D53:O57) |
|
|
|
Home |
|
|
$2,582 |
|
Home |
|
|
=SUM(D59:O64) |
|
|
|
Groceries |
|
$1,425 |
|
Groceries |
|
=SUM(D66:O70) |
|
|
|
Miscellaneous |
|
$4,694 |
|
Miscellaneous |
|
=SUM(D72:O78) |
|
|
|
Total Expenses |
|
$11,602 |
|
Total Expenses |
|
=SUM(E167:E171) |
|
|
|
|
|
|
Totals for Renae |
|
|
|
Totals for Renae |
|
|
|
|
|
|
Auto |
|
|
$2,573 |
|
Auto |
|
|
=SUM(D85:O91) |
|
|
|
School |
|
$2,627 |
|
School |
|
=SUM(D93:O97) |
|
|
|
Home |
|
|
$0 |
|
Home |
|
|
=SUM(D99:O104) |
|
|
|
Groceries |
|
$1,449 |
|
Groceries |
|
=SUM(D106:O110) |
|
|
|
Miscellaneous |
|
$3,530 |
|
Miscellaneous |
|
=SUM(D112:O118) |
|
|
|
Total Expenses |
|
$10,179 |
|
Total Expenses |
|
=SUM(E175:E179) |
|
|
|
|
|
|
Totals for Kristie |
|
|
|
Totals for Kristie |
|
|
|
|
|
|
Auto |
|
|
$5,338 |
|
Auto |
|
|
=SUM(D125:O131) |
|
|
|
School |
|
$1,716 |
|
School |
|
=SUM(D133:O137) |
|
|
|
Home |
|
|
$0 |
|
Home |
|
|
=SUM(D139:O144) |
|
|
|
Groceries |
|
$936 |
|
Groceries |
|
=SUM(D146:O150) |
|
|
|
Miscellaneous |
|
$2,925 |
|
Miscellaneous |
|
=SUM(D152:O158) |
|
|
|
Total Expenses |
|
$10,915 |
|
Total Expenses |
|
=SUM(E183:E187) |
|
|
|
|
Group Statistics |
|
|
|
Group Statistics |
|
|
|
|
|
|
Group Total |
|
$32,696 |
|
Group Total |
|
=SUM(E172+E180+E188) |
|
|
Group Average Total |
$10,899 |
|
Group Average Total |
=AVERAGE(E172,E180,E188) |
|
|
Least Spent |
|
$10,179 |
|
Least Spent |
|
=MIN(E172,E180,E188) |
|
|
Most Spent |
|
$11,602 |
|
Most Spent |
|
=MAX(E172,E180,E188) |
|
|
|
Pie Chart Data |
|
|
Combined |
|
|
Auto |
$10,812 |
|
Robert |
$11,602 |
|
|
School |
$4,343 |
|
Renae |
$10,179 |
|
|
Home |
$2,582 |
|
Kristie |
$10,915 |
|
|
Groceries |
$3,810 |
|
|
Misc |
$11,149 |
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
|
Robert |
$336 |
$288 |
$332 |
$336 |
$347 |
$340 |
$485 |
$2,398 |
$1,502 |
$1,691 |
$1,500 |
$2,047 |
|
|
Renae |
$1,074 |
$605 |
$809 |
$664 |
$1,232 |
$875 |
$753 |
$800 |
$878 |
$820 |
$644 |
$1,025 |
|
|
Kristie |
$980 |
$964 |
$898 |
$836 |
$919 |
$949 |
$948 |
$849 |
$1,113 |
$787 |
$831 |
$841 |
|
|
Group Total |
$2,390 |
$1,857 |
$2,039 |
$1,836 |
$2,498 |
$2,164 |
$2,186 |
$4,047 |
$3,493 |
$3,298 |
$2,975 |
$3,913 |
|
|
|
Spring |
Summer |
Fall |
Winter |
|
|
Robert |
$1,015 |
$3,223 |
$4,693 |
$2,671 |
|
|
Renae |
$2,705 |
$2,428 |
$2,342 |
$2,704 |
|
|
Kristie |
$2,653 |
$2,746 |
$2,731 |
$2,785 |
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
|
Renae |
$60 |
$54 |
$48 |
$40 |
$57 |
$63 |
$72 |
$59 |
$53 |
$52 |
$61 |
$73 |
|
|
Kristie |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$82 |
$97 |
$98 |
$82 |
|
|
Robert |
$100 |
$95 |
$87 |
$93 |
$110 |
$114 |
$120 |
$105 |
$130 |
$100 |
$115 |
$140 |
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
|
Kristie |
$56 |
$59 |
$44 |
$34 |
$51 |
$40 |
$53 |
$36 |
$52 |
$55 |
$57 |
$82 |
|
|
Renae |
$60 |
$57 |
$55 |
$49 |
$68 |
$38 |
$29 |
$41 |
$57 |
$54 |
$62 |
$58 |
|
|
Robert |
|
|
$180 |
$200 |
$195 |
$222 |
$225 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|