www.colinLmiller.com

EXPENSE REPORT

Intro June 10 June 11 June 12 June 13 June 14 June 15 June 16 June 17 June 18 June 19 June 20 June 21 June 22 June 23 June 24 June 25 June 26 Expense Report

COST PER DAY (17 DAYS)

TOTAL CATEGORY COST PER DAY (Total/17)
$2,479.69 TRANSPORTATION $145.86
$1,341.81 LODGING $78.93
$388.83 SUPPLIES $22.87
$169.97 FOOD $10.00
$345.16 TOURIST $20.30
$54.28 COMMUNICATIONS $3.19
$0 ENTERTAINMENT $0
$34.22 MISC $2.01
$26.43 RESEARCH $1.55
$4,840.40   $284.73

The three largest expenses were Travel (51.23%), Lodging (27.72%), and Supplies (8.03%), totalling 86.98%


TRANSPORTATION EXPENSE BREAKDOWN:

TRAVEL CATEGORYTOTAL / %COST PER DAY (Total/17)
Air $1368.53.00 / 00.00% $80.50
Rental Car $0.00 / 0.00% $0.00
Rail $919.23 / 0.00% $54.07
Insurance $85.54 / 0% $5.03
Government (Passport) $0.00 / 0% $0.00
Airport Parking $79.21 / 0.00% $4.66
London Underground (Tube) $15.10 / 0.00% $0.89
Rental Car - Parking $0.00 / 0% $0.00
Bus $12.08 / 0% $0.71


TRAVEL EXPENSES

COSTITEMCATEGORY
$11.96ATM feesBanking
$22.26Leftover coinsBanking
$15.10Vending machine, SIM cardCommunication
$8.98BT OPEN ZONE LONDON NEWCAS GBR phoneCommunication
$30.20Martin McColl newsstand, top-upCommunication
$7.85Houston IAH Wendy'sFood & Supplies
$2.88Houston IAH Paradies Airport Shops, water bottleFood & Supplies
$12.67Sainsbury's (Newcastle) snacksFood & Supplies
$4.36McD (NCL)Food & Supplies
$16.22Boots Peterborough, headache medicationsFood & Supplies
$1.51Flag Fen, sodaFood & Supplies
$5.42McD (PBO)Food & Supplies
$5.87McD (NCL)Food & Supplies
$0.00Sainsbury's Local (6/14)Food & Supplies
$2.73McD (NCL)Food & Supplies
$7.55SubwayFood & Supplies
$7.53McDFood & Supplies
$7.55McDFood & Supplies
$7.69SubwayFood & Supplies
$10.57SubwayFood & Supplies
$5.74SubwayFood & Supplies
$10.78Tesco Express, ChichesterFood & Supplies
$6.58Tesco ExpressFood & Supplies
$5.72McDFood & Supplies
$5.72McDFood & Supplies
$2.52Sainsbury's (Marble Arch) snacksFood & Supplies
$9.45Subway (Canterbury)Food & Supplies
$6.46Houston IAH Panda ExpressFood & Supplies
$12.06Boots Heathrow, Imigran RecoveryFood & Supplies
$4.51LHR Newsstand, water, candyFood & Supplies
$415.28lastminute.com - County Hotel by Thistle, 4 nightsLodging
$69.46EVIIVO Ltd - Hunter's Lodge, prepayLodging
$286.90Lastminute.com - Grand Royale London Hyde Park prepayLodging
$68.85paypal - Welland house, 1 night prepayLodging
$203.85Welland House B&B, Worcester, 3 nightsLodging
$158.55Park House Guest House, 3 nightsLodging
$138.92Hunters Lodge, Southampton, 3 nightsLodging
$25.67Gloucestershire Archives, copiesResearch
$0.76Bath Library, photocopyResearch
$3.02Vindolanda, gift shopTourist
$14.93Vindolanda, admission, guide bookTourist
$17.50Birdoswald, admission, guide bookTourist
$17.79Chesters Roman Fort, admission, guide booksTourist
$7.25Housesteads Roman Fort, admissionTourist
$13.27Birdoswald, admission, guide book?Tourist
$13.51Housesteads Roman Fort, gift shopTourist
$3.02Peterborough Cathedral, gift shopTourist
$7.55Flag Fen, admissionTourist
$3.02Worcester TICTourist
$4.53Worcester Cathedral, gift shopTourist
$10.57Gloucester Cathedral, guidebook, post cardsTourist
$9.06Christ Church, Oxford admissionTourist
$1.81Christ Church, Oxford postcardsTourist
$4.08Oxford TICTourist
$7.55Warwick Castle, Dungeon, souvenir photoTourist
$34.65Warwick Castle + DungeonTourist
$8.98Stratford Butterfly FarmTourist
$33.22National Sea Life, Birmingham, admission, guideTourist
$1.51Birmingham Cathedral, guidebookTourist
$1.81Gift shopTourist
$23.01Winchester Cathedral, tower tour, guideTourist
$2.27Winchester Cathedral, gift shopTourist
$5.96Fishbourne Roman Palace gift shopTourist
$2.64Chichester TICTourist
$14.50Fishbourne Roman Palace, admissionTourist
$7.55Bath Abbey, tower tourTourist
$11.14Bath Abbey, gift shopTourist
$4.08Dover Castle, gift shopTourist
$2.42Canterbury Cathedral, gift shopTourist
$6.04Canterbury Cathedral, guide bookTourist
$12.08Canterbury Cathedral, admissionTourist
$27.01Dover Castle, admission, guide bookTourist
$7.81Pitkin Guide - Worcester CathedralTourist
$1,368.53Plane ticket, TUS-IAH-LHR, LHR-IAH-TUS ($977.00 + $396.20 taxes & fees)Transportation
$85.54Travel insuranceTransportation
$1.99Parking Shuttlevan, tipTransportation
$151.01Rail: East Coast, KGX-NCLTransportation
$15.10OysterCardTransportation
$12.08Classic Bus, AD122 Rover TicketTransportation
$19.48Rail: CAR-NCLTransportation
$126.39Rail: NCL-PBO-NCLTransportation
$28.69Rail: NCL-NAL-NCLTransportation
$17.97RAIL: NAL-NCLTransportation
$138.92Rail: NCL-WOFTransportation
$15.25Rail: WOF-GCR-WOFTransportation
$21.90Rail: WOF-OXF-WOFTransportation
$15.25Rail: WOF-WRWTransportation
$7.25Rail: WRW-SAV-WRWTransportation
$9.82Rail: WRW-BSW-WRWTransportation
$75.50Rail: WRW-SOUTransportation
$16.16Rail: SOU-CCH-SOUTransportation
$73.01Rail: First Great Western, PAD-BTH-PADTransportation
$75.50Chiltern Railways, WRW-SOUTransportation
$49.38Southwest Trains, SOU-WATTransportation
$50.28Rail: STP-DVPTransportation
$27.49Rail: Southeastern, DVP-VICTransportation
$1.99Parking Shuttlevan, tipTransportation
$75.22Long-term parking, 17 daysTransportation
$19.93DaypackTRAVEL SUPPLIES
$29.90ClothesTRAVEL SUPPLIES
$7.97UmbrellaTRAVEL SUPPLIES
$19.93ShoesTRAVEL SUPPLIES
$182.71Kodak Zi8TRAVEL SUPPLIES
$25.25Kodak KLIC-7004 Li-Ion batteryTRAVEL SUPPLIES
$2.36Kodak KLIC-7004 / Fuji Np-50 / Pentax DL-I68 CompatibleTRAVEL SUPPLIES
$30.42Transcend 8 GB Class 6 microSDHC with USB 2.0 Card Reader TS8GUSDHC6-P3TRAVEL SUPPLIES
$42.18Transcend 16 GB Class 6 SD $42.32TRAVEL SUPPLIES
$7.61Transcend P5 9-in-1 USB2 card readerTRAVEL SUPPLIES
$20.57A-DATA Turbo 8 GB Class 6 microSDHC Flash Memory Card with SD AdapterTRAVEL SUPPLIES
$4,840.40

Items only for the trip:

COSTITEMCOMMENTS
$1,373.20Plane ticket, ContinentalCost $505.20 more than last year for the same flight.
$84.83Travel insuranceGood to have, this time, due to the Iceland volcano.
$1,458.03

Items that can be used beyond the trip itself:

COST ITEM COMMENTS
$20.00 Daypack, small, Victorinox Just big enough for the netbook to fit in. Many little compartments and pockets.
$30.00 Clothes Cheap Walmart stuff.
$8.00 Umbrella Didn't use it.
$20.00 Shoes Very cheap, very low quality Walmart shoes. Lasted long enough to get through the trip before the rubber sole cracked and separated, letting water in, and side detailing cracking and falling off leaving ugly gaps.
$183.33 Kodak Zi8 Good for video and still images, and as a backup camera. Easy recharge via built-in USB.
$25.34 Kodak KLIC-7004 Li-Ion battery Brand-name battery, expensive.
$2.37 Kodak KLIC-7004 / Fuji Np-50 / Pentax DL-I68 Compatible Good extra spare battery, very inexpensive.
$30.52 Transcend 8 GB Class 6 microSDHC with USB 2.0 Card Reader TS8GUSDHC6-P3 Good for storing data and backups.
$42.32 Transcend 16 GB Class 6 SD $42.32 For main storage on the Kodak Zi8.
$7.64 Transcend P5 9-in-1 USB2 card reader For connecting the microSD cards to the netbook.
$20.64 A-DATA Turbo 8 GB Class 6 microSDHC Flash Memory Card with SD Adapter Can't have too much extra storage...
$390.16

COST COMPARISON BETWEEN 2009 & 2010 TRIPS

CATEGORY20092010DIFFERENCE
TRANSPORTATION$1,972.57 $2,479.69 ($507.12)
LODGING$1,757.17 $1,341.81 $415.36
SUPPLIES$1,533.99 $388.83 $1,145.16
FOOD$278.84 $169.97 $108.87
TOURIST$267.71 $345.16 ($77.45)
COMMUNICATIONS$109.08 $54.28 $54.80
ENTERTAINMENT$102.91 $0.00 $102.91
MISC$89.60 $34.22 $55.38
RESEARCH$33.46 $26.43 $7.03
Total$6,145.33 $4,840.39 $1,304.94

The biggest change from 2009 was the cost of the plane ticket, costing $507.12 more. The biggest savings was $1,145.16 in the cost of supplies for the trip, as many things were reused from last year. Another big savings was in lodging, with $414.36 saved, mostly by using more bed-and-breakfasts instead of hotels.


Intro June 10 June 11 June 12 June 13 June 14 June 15 June 16 June 17 June 18 June 19 June 20 June 21 June 22 June 23 June 24 June 25 June 26 Expense Report