Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Resolved Project 5

    Uploaded by

    lethihabinh

    Copyright:

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

    Resolved Project 5

    Uploaded by

    lethihabinh
    4 views5 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Resolved Project 5

    Uploaded by

    lethihabinh

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Kasacherlan Car Rentals

    Item Type Description Inventory Daily Weekly


    1 Sports Ford G190 5 300 1000
    2 Family Family Minivan 324 4 25 600
    3 Hatchback Hyundai Sudan 6 45 700
    4 Family Family Minivan 324 10 25 600
    5 Convertible Toyota FJ 8 57 800
    6 Convertible BMW 12 57 800
    Kascherlan Car Rentals
    Outstanding Invoices
    Invoice Client # Date Amount Tax Amount Due
    1230 10-778 6/2/2015 $450.00 8.5% $488.25
    1438 11-279 6/4/2015 $1,075.00 8.8% $1,169.60 First Wee
    1129 11-279 6/5/2015 $225.00 0.0% $225.00 $1,200.00
    1326 04-325 6/8/2015 $750.00 8.5% $813.75 $1,000.00
    1355 11-279 6/8/2015 $350.00 0.0% $350.00
    1198 11-325 6/20/2015 $875.00 8.5% $949.38 $800.00
    1320 04-325 6/12/2015 $750.00 8.5% $813.75 $600.00
    1270 04-789 6/13/2015 $560.00 8.8% $609.28
    1345 05-335 6/16/2015 $400.00 0.0% $400.00 $400.00

    1233 10-455 6/19/2015 $600.00 8.5% $651.00 $200.00


    1199 03-288 6/20/2015 $95.00 0.0% $95.00
    1302 10-226 6/23/2015 $2,250.00 8.5% $2,441.25 $0.00
    6/2/2015 6/3/2015 6/4/201
    1277 11-005 6/23/2015 $225.00 8.8% $244.80
    1144 05-335 6/25/2015 $140.00 0.0% $140.00

    Sum of Amount Due


    $3,000.00

    $2,500.00

    $2,000.00

    $1,500.00

    $1,000.00

    $500.00

    $0.00
    10- 11- 11- 04- 11- 11- 04- 04- 05- 10- 03- 10- 11- 05-
    778 279 279 325 279 325 325 789 335 455 288 226 005 335
    First Week Invoices
    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00
    6/2/2015 6/3/2015 6/4/2015 6/5/2015 6/6/2015 6/7/2015 6/8/2015
    Month Sports Family Hatchback Luxury Total
    Jan $15,000 $8,930 $1,200 $38,485 $63,615
    Feb $17,888 $4,950 $3,405 $50,000 $76,243
    Mar $39,588 $18,940 $4,506 $49,566 $112,600 $160,000
    Apr $25,999 $29,304 $4,555 $49,643 $109,501 $140,000
    May $39,000 $39,440 $6,043 $49,530 $134,013
    $120,000
    Jun $34,904 $13,949 $19,334 $34,500 $102,687
    $100,000
    Total $598,659
    $80,000
    $60,000
    $40,000
    $20,000
    $0
    Sports
    Sales by month
    $160,000
    $140,000
    $120,000
    $100,000
    $80,000
    $60,000
    $40,000
    $20,000
    $0
    Sports Family Hatchback Luxury Total

    Jan Feb Mar Apr May Jun

    You might also like