wedding budget planner

21
Samantha Smith Expected Number of Guests: Apparel Estimated Gown & Alterations Bridal Shoes Bridal Slip Lingerie Hosiery Jewelry Bride's Hair & Makeup Bridesmaids Hair Bridesmaids wraps & purses Bridal Headpiece/veil Bridal gloves Bridesmaid dresses Bridesmaid accessories Bridesmaid shoes Groom's tux Groomsmen tuxes Groom's shoes Garters Gown preservation Alterations Going-away outfit Honeymoon clothes Children's apparel Total Apparel 0 Ceremony Estimated Clergy Location fee Alter decorations Chair/pew rental Pew/chair decorations Aisle runner Valet or Parking Usher Gratuity Candles Lighting Balloons

Upload: spreadsheetzone

Post on 15-Nov-2014

96 views

Category:

Documents


3 download

DESCRIPTION

This template is prepared for planning and tracking wedding expenditures. Variable costs depending on the number of guests can easily be evaluated as well as fixed costs. 12 main expenditure categories and items belonging to these categories are proposed in this template. However, all categories and items are editable. SpreadsheetWEB version of this template allows to use and and save the planner online.

TRANSCRIPT

Page 1: Wedding Budget Planner

Samantha Smith & James Brown's WEDDING BUDGET

Expected Number of Guests:

Apparel Estimated ActualGown & AlterationsBridal ShoesBridal SlipLingerieHosieryJewelryBride's Hair & Makeup Bridesmaids HairBridesmaids wraps & pursesBridal Headpiece/veilBridal glovesBridesmaid dressesBridesmaid accessoriesBridesmaid shoesGroom's tuxGroomsmen tuxesGroom's shoesGartersGown preservationAlterationsGoing-away outfitHoneymoon clothesChildren's apparelTotal Apparel 0 0

Ceremony Estimated ActualClergyLocation feeAlter decorationsChair/pew rentalPew/chair decorationsAisle runnerValet or Parking UsherGratuityCandlesLightingBalloonsGuest book/penRing bearer pillowFlower girl basketTotal Ceremony 0 0

Page 2: Wedding Budget Planner

Children Estimated ActualChild CareTV RentalChildrens MealsTotal Children 0 0

Reception Estimated ActualLocation feeBakerWedding cakeGroom's cakeCake knifeCake decorationsDishes USDs/guestGlassware USDs/guestNapkinsGuest bookGratuitiesLimousine/CarriageTransportationRice/Rose petals/bubblesTotal Reception 0 0

Flowers Estimated ActualBridal Bouquet CorsagesBoutonnièreBridesmaids bouquetsFlowers For Bride's AttendantsFlowers For Groom's AttendantsOther florals for gueststax on flowersReception Centerpieces & DecorAltarpieceThrow away bouquetFlower girls' flowersTotal Flowers 0 0

Page 3: Wedding Budget Planner

Samantha Smith & James Brown's WEDDING BUDGET

Number of Guests Appeared:

Stationary Estimated ActualInvitations USDs/guestAnnouncementsMap/direction cardsReply cards USDs/guestCeremony cards USDs/guestSave the date cardsPostage USDs/guestCalligrapherNewspaper announcementThank you notes USDs/guestRehearsal dinner invitations USDs/guestBridesmaid luncheon invitations USDs/guestBachelor party invitations USDs/guestWedding programsAddress labelsMenu cards USDs/guestTotal Stationary 0 0

Honeymoon Estimated ActualAir fareAccommodationsRental CarEntertainmentOtherTotal Honeymoon 0 0

Rehearsal Dinner Estimated ActualCatererBartenderLiquor/Other BeveragesTables/chairs USDs/guestDecorationsSecurityCeremony MusicianReception Band/DJSound systemGuest parkingDishes USDs/guestCenterpiecesLinensFood USDs/guestServersTotal Rehearsal Dinner 0 0

Page 4: Wedding Budget Planner

Rings Estimated ActualWedding bandsEngagement ringEngravingTotal Rings 0 0

Miscellaneous Estimated ActualMarriage licenseBridesmaids BrunchHairdresserManicure/pedicureManicure/pedicure for attendantsMake-up Wedding planner/organizerConsultant/coordinatorHotel for guests USDs/guestTotal Miscellaneous 0 0

Gifts & Favors Estimated ActualAttendant giftsGift for fianceeFavorsTotal Gifts & Favors 0 0

Photography Estimated ActualBridal portraitsReceptionCeremonyPhoto albumsEngagement portraitsVideographer Total Photography 0 0

Total Estimated Cost: 0 USDsTotal Actual Cost: 0 USDs

Page 5: Wedding Budget Planner

10 0 0 0 20 0 0 0 30 0 0 0 40 0 0 0 50 0 0 0 60 0 0 0 70 0 0 0 80 0 0 0 90 0 0 0 100 0 0 0 110 0 0 0 120 0 0 0 130 0 0 0 140 0 0 0 150 0 0 0 160 0 0 0 170 0 0 180 0 Actual 190 0 0 0 200 0 0 0 210 0 0 0 220 0 0 0 230 0 0 0

0 0Actual Actual

0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 0

0 0

Page 6: Wedding Budget Planner

Actual Actual0 0 0 00 0 0 00 0 0 0

0 0Actual Actual

0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 00 0 Actual0 0 0 00 0 0 00 0 0 0

0 0Actual Actual

0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 00 00 00 00 00 0

###

Page 7: Wedding Budget Planner

Follow the steps to enable your online Wedding Budget Planner.1) Type the names of the bride and the groom:

Bride: Samantha Smith

Groom: James Brown

2) Select the monetary unit: USDs

3) In the "Categories&Items" sheet, you will see a list of cost categories and the items of these categories.

You can edit the category or item names.

Also, you will see that second column of some items are checked. This means that costs of these items will be evaluated by entering the unit

value. This value will be multiplicated with the number of guests. You can check or uncheck items corresponding to your needs.

>> Your Wedding Budget Planner is ready to use. Following steps are for online use.

4) Visit the site below:

http://www.spreadsheetweb.com/getting_started.htm

You will only need the username and password to create your online Wedding Budget Planner.

5) Visit the site below:

https://www4.spreadsheetweb.com/SpreadsheetWEB//

Login to page with your new account information.

6) Click "Add Web Application" to upload this file. Check "Single Record Application" option. This will allow you to edit and save the information

that you enter in your Wedding Budget Planner.

Your online Wedding Budget Planner will be created automatically.

You can simply use the Wedding Budget Planner from that link or place it on your website.

>> Your online Wedding Budget Planner will look like:

http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=0b7f3f05-6c2d-4a30-974c-7859fa4fbe91

>> In order to see more online applications created with PSW you can check the link below:

http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

Other

Page 8: Wedding Budget Planner

Follow the steps to enable your online Wedding Budget Planner.

Also, you will see that second column of some items are checked. This means that costs of these items will be evaluated by entering the unit USDs ###value. This value will be multiplicated with the number of guests. You can check or uncheck items corresponding to your needs. Euros

Wedding Budget

USDs

bride Samantha SmithgroomJames Brown

Click "Add Web Application" to upload this file. Check "Single Record Application" option. This will allow you to edit and save the information

http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=0b7f3f05-6c2d-4a30-974c-7859fa4fbe91

Page 9: Wedding Budget Planner

Apparel

Gown & Alterations

Bridal Shoes

Bridal Slip

Lingerie

Hosiery

Jewelry

Bride's Hair & Makeup

Bridesmaids Hair

Bridesmaids wraps & purses

Bridal Headpiece/veil

Bridal gloves

Bridesmaid dresses

Bridesmaid accessories

Bridesmaid shoes

Groom's tux

Groomsmen tuxes

Groom's shoes

Garters

Gown preservation

Alterations

Going-away outfit

Honeymoon clothes

Children's apparel

Ceremony

Clergy

Location fee

Alter decorations

Chair/pew rental

Pew/chair decorations

Aisle runner

Valet or Parking

Check items that directly depends on the number of guests

Page 10: Wedding Budget Planner

Usher

Gratuity

Candles

Lighting

Balloons

Guest book/pen

Ring bearer pillow

Flower girl basket

Flowers

Bridal Bouquet

Corsages

Boutonnière

Bridesmaids bouquets

Flowers For Bride's Attendants

Flowers For Groom's Attendants

Other florals for guests

tax on flowers

Reception Centerpieces & Decor

Altarpiece

Throw away bouquet

Flower girls' flowers

Rehearsal Dinner

Caterer

Bartender

Liquor/Other Beverages

Tables/chairs

Decorations

Security

Ceremony Musician

Reception Band/DJ

Sound system

Guest parking

Dishes

Centerpieces

Linens

Page 11: Wedding Budget Planner

Food

Servers

Children

Child Care

TV Rental

Childrens Meals

Photography

Bridal portraits

Reception

Ceremony

Photo albums

Engagement portraits

Videographer

Honeymoon

Air fare

Accommodations

Rental Car

Entertainment

Other

Stationary

Invitations

Announcements

Map/direction cards

Reply cards

Ceremony cards

Save the date cards

Postage

Calligrapher

Newspaper announcement

Thank you notes

Rehearsal dinner invitations

Bridesmaid luncheon invitations

Bachelor party invitations

Page 12: Wedding Budget Planner

Wedding programs

Address labels

Menu cards

Rings

Wedding bands

Engagement ring

Engraving

Reception

Location fee

Baker

Wedding cake

Groom's cake

Cake knife

Cake decorations

Dishes

Glassware

Napkins

Guest book

Gratuities

Limousine/Carriage

Transportation

Rice/Rose petals/bubbles

Miscellaneous

Marriage license

Bridesmaids Brunch

Hairdresser

Manicure/pedicure

Manicure/pedicure for attendants

Make-up

Wedding planner/organizer

Consultant/coordinator

Hotel for guests

Gifts & Favors

Page 13: Wedding Budget Planner

Attendant gifts

Gift for fiancee

Favors

Page 14: Wedding Budget Planner

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Page 15: Wedding Budget Planner

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

Page 16: Wedding Budget Planner

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

TRUE

TRUE

FALSE

TRUE

FALSE

FALSE

TRUE

TRUE

TRUE

TRUE

Page 17: Wedding Budget Planner

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Page 18: Wedding Budget Planner

FALSE

FALSE

FALSE