Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    Quote For Customized Gift Baskets: Customized Baskets Description of Custom Basket Bulk Discount

    Uploaded by

    hjbjflaefaifnaerf
    Excel Spreadsheet

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Quote For Customized Gift Baskets: Customized Baskets Description of Custom Basket Bulk Discount

    Uploaded by

    hjbjflaefaifnaerf
    66 views7 pages
    Excel Spreadsheet

    Original Title

    w02Demo

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Excel Spreadsheet

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    66 views7 pages

    Quote For Customized Gift Baskets: Customized Baskets Description of Custom Basket Bulk Discount

    Uploaded by

    hjbjflaefaifnaerf
    Excel Spreadsheet

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 7

    Quote for Customized Gift Baskets

    Customized Baskets Description of Custom Basket Bulk Discount


    Basket 1 Attendees' Unwind and Renew
    Basket 2 Wedding Party Pamper Yourself
    Basket 3 Parents of the Bride and Groom Stress Free

    # of Items per Basket Lavendar Candle Chamomile Body Lotion Foot Renew Cream
    Basket 1 2 1 1
    Basket 2 2 2 2
    Basket 3 3 2 2

    Item Price List Lavendar Candle Chamomile Body Lotion Foot Renew Cream
    Retail Price $ 4.99 $ 7.99 $ 5.99
    Price After Bulk Discount $ 4.49 $ 7.19 $ 5.39

    Price Per Basket Lavendar Candle Chamomile Body Lotion Foot Renew Cream
    Basket 1 $ 8.98 $ 7.19 $ 5.39
    Basket 2 $ 8.98 $ 14.38 $ 10.78
    Basket 3 $ 13.47 $ 14.38 $ 10.78

    Basket Orders Baskets Requested Basket Subtotals


    Basket 1 50 $ 1,078.20
    Basket 2 8 $ 402.62
    Basket 3 2 $ 142.00

    *To customize for a different order only modify the blue shaded boxes.
    10%

    Soothing Bath Salts Items Per Basket


    0 4
    2 8
    4 11

    Soothing Bath Salts


    $ 8.99
    $ 8.09

    Soothing Bath Salts Per Basket Price


    $ - $ 21.56
    $ 16.18 $ 50.33
    $ 32.36 $ 71.00

    Total Baskets in Order 60


    Total Billing Amount $ 1,622.83
    Prepared for: Keller - Ryan Wedding
    Most Frequent Length of Stay 4
    Average Amount Spent at Spa $ 874.70
    Median Amount Spent at Spa $ 899.77
    Number of Weddings 31
    Spa Members Scheduling Weddings 16

    Number of
    Wedding Party Name Days Spent Whole Days Spent Returned Merchandise
    Arroyo 1.52 1.00 -37.34
    Proctor 2.54 2.00 41.12
    Minor 4.32 4.00 -12.7
    Pearce 4.52 4.00 13.97
    Shea 2.50 2.00 18.53
    Galvan 4.00 4.00 11.09
    Crowe 2.31 2.00 36.64
    Meeks 2.45 2.00 47.7
    Kendrick 3.65 3.00 10.24
    Mayfield 4.45 4.00 7.88
    Kendall 3.11 3.00 21.78
    Archer 3.15 3.00 37.51
    Holley 4.19 4.00 34.36
    Boucher 4.10 4.00 5.79
    Childs 1.63 1.00 -2.47
    Rankin 4.50 4.00 -12.66
    Lozano 2.55 2.00 49.74
    Odell 4.42 4.00 -18.66
    Bland 2.72 2.00 -17.86
    Rouse 1.65 1.00 24.98
    Haas 4.40 4.00 23.12
    Swain 1.16 1.00 -7.23
    Oconnell 2.64 2.00 1.11
    Dougherty 3.50 3.00 -0.46
    Andersen 3.58 3.00 -19.03
    Wang 1.91 1.00 -3.15
    Cowan 1.28 1.00 40.74
    Elder 2.00 1.00 -16.6
    Shirley 2.59 2.00 31.05
    Hartley 3.60 3.00 25.91
    Felix 4.57 4.00 30.66
    Value of Returned Merchandise Amount Spent at Spa Spa Member
    37.34 $ 1,215.63 1
    41.12 $ 720.60 1
    12.7 $ 455.78 1
    13.97 $ 1,309.51 Null
    18.53 $ 1,345.57 1
    11.09 $ 1,046.69
    36.64 $ 1,125.53 1
    47.7 $ 1,068.90 1
    10.24 $ 604.95 Null
    7.88 $ 299.60 Null
    21.78 $ 353.74 Null
    37.51 $ 923.56 1
    34.36 $ 1,285.26 Null
    5.79 $ 1,157.07 1
    2.47 $ 206.77 1
    12.66 $ 781.30 Null
    49.74 $ 1,070.70 Null
    18.66 $ 867.45 Null
    17.86 $ 267.16 1
    24.98 $ 1,330.38 1
    23.12 $ 899.77 Null
    7.23 $ 1,479.14 Null
    1.11 $ 953.20 1
    0.46 $ 556.17 Null
    19.03 $ 644.50 Null
    3.15 $ 606.30 1
    40.74 $ 955.27 Null
    16.6 $ 760.12 1
    31.05 $ 870.85 1
    25.91 $ 1,146.79 1
    30.66 $ 807.42 Null
    Today's Date 1/18/2018
    Spa Service Requests

    Guest Name Date Of Birth Age First Name Service Requested


    Olivia Stone 2/20/1978 39 Olivia Hair Treatment
    Mia Ramos 11/11/1972 45 Mia Hair Color Treatment
    Isabella Hudson 10/19/1975 42 Isabella Makeup Service
    Rhonda Griffith 1/2/1969 49 Rhonda Women's Facial
    Steven Lucas 2/26/1970 47 Steven Golf Massage
    Elizabeth Anderson 4/14/1977 40 Elizabeth Hair Color Treatment
    Jessica Montgomery 10/6/1969 48 Jessica Women's Facial
    Ella West 5/26/1978 39 Ella Makeup Service
    Joseph Wallace 6/19/1986 31 Joseph Golf Massage
    Joshua Pierce 5/12/1969 48 Joshua Pedicure
    Ryan Jennings 6/5/1971 46 Ryan Full Massage
    Judy Brown 11/8/1967 50 Judy Manicure
    Hannah Rowe 5/8/1974 43 Hannah Hair Color Treatment
    Jill Mcdonald 6/9/1976 41 Jill Full Massage
    Glenn Barker 8/22/1974 43 Glenn Pedicure
    Mia Rivera 3/9/1985 32 Mia Pedicure
    Jane Montgomery 5/12/1986 31 Jane Makeup Service
    Susan Burgess 6/14/1964 53 Susan Pedicure
    City & State City State
    Bernalilo, NM Bernalilo NM
    Farmington, NM Farmington NM
    Benson, AZ Benson AZ
    Benson, AZ Benson AZ
    Bisbee, AZ Bisbee AZ
    Bernalilo, NM Bernalilo NM
    Santa Fe, NM Santa Fe NM
    Farmington, NM Farmington NM
    Farmington, NM Farmington NM
    Bernalilo, NM Bernalilo NM
    Bisbee, AZ Bisbee AZ
    Benson, AZ Benson AZ
    Bisbee, AZ Bisbee AZ
    Bernalilo, NM Bernalilo NM
    Santa Fe, NM Santa Fe NM
    Santa Fe, NM Santa Fe NM
    Farmington, NM Farmington NM
    Santa Fe, NM Santa Fe NM
    Financing Calculator
    Credit Score 725
    Total Cost of Event $ 37,000.00 Percent Discount
    Down payment $ 3,500.00 0 0.00%
    Rate (Annualized) 4.00% 20000 1.00%
    Term (in Years) 2 30000 5.00%
    Percentage Discount 5.00% 40000 7.50%
    Amount of Discount $ 1,850.00 50000 11.00%
    Total amount borrowed $ 31,650.00
    Monthly Payment $1,374.40 Sufficient Credit Score (725)

    Does Party Wish to Include Golf Services?


    No
    Does Party Wish to Include Hotel Services?
    Yes

    All Inclusive Discount


    $ -

    You might also like