0% found this document useful (0 votes)
23 views9 pages

Finals Ba

Uploaded by

athonia07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views9 pages

Finals Ba

Uploaded by

athonia07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Model Rental Fee

Yaris $1,000.00
Corolla $1,500.00
Camry $2,000.00

First Name Last Name Model Car Rental Fee No. of cars rented
Kyle France Yaris $1,000.00 4
Micheal James Camry $2,000.00 3
John Joseph Corolla $1,500.00 5
Rick Sanches Corolla $1,500.00 8
Johnny Cage Yaris $1,000.00 2
Kratos Olympus Camry $2,000.00 1
Morty Sanches Camry $2,000.00 2
Lucifer Morningstar Yaris $1,000.00 4
Clark Kent Yaris $1,000.00 1
Barry Alen Corolla $1,500.00 1
31

Average Fees Incentives Per Owner


$4,400.00 $275.00
Total Rental Fee Incentives New Rental Fee
$4,000.00 $400.00 $4,400.00
$6,000.00 $0.00 $6,000.00
$7,500.00 $750.00 $8,250.00
$12,000.00 $1,200.00 $13,200.00
$2,000.00 $0.00 $2,000.00
$2,000.00 $0.00 $2,000.00
$4,000.00 $0.00 $4,000.00
$4,000.00 $400.00 $4,400.00
$1,000.00 $0.00 $1,000.00
$1,500.00 $0.00 $1,500.00
$44,000.00
Model Rental Fee
Camry $1,000.00
Corolla $1,500.00
Yaris $2,000.00
Rental Info Sorted By Car Model
First Name Last Name Model Car Rental Fee No. of cars rented Total Rental Fee Incentives
Kyle France Camry $2,000.00 4 $8,000.00 $800.00
Micheal James Camry $2,000.00 3 $6,000.00 $0.00
John Joseph Camry $2,000.00 5 $10,000.00 $1,000.00
Rick Sanches Corolla $1,500.00 8 $12,000.00 $1,200.00
Johnny Cage Corolla $1,500.00 2 $3,000.00 $0.00
Kratos Olympus Corolla $1,500.00 1 $1,500.00 $0.00
Morty Sanches Yaris $1,000.00 2 $2,000.00 $0.00
Lucifer Morningstar Yaris $1,000.00 4 $4,000.00 $400.00
Clark Kent Yaris $1,000.00 1 $1,000.00 $0.00
Barry Alen Yaris $1,000.00 1 $1,000.00 $0.00
31 $48,500.00

Average Fees Incentives Per Owner


$4,850.00 $340.00
New Rental Fee
$8,800.00
$6,000.00
$11,000.00
$13,200.00
$3,000.00
$1,500.00
$2,000.00
$4,400.00
$1,000.00
$1,000.00
Filtered data showing owners who are renting outnmore than 3 Toyota Camry Cars

First Name Last Name Model Car Rental Fee No. of cars rented Total Rental Fee
Camry >3

First Name Last Name Model Car Rental Fee No. of cars rented Total Rental Fee
Kyle France Camry $2,000.00 4 $8,000.00
Micheal James Camry $2,000.00 3 $6,000.00
John Joseph Camry $2,000.00 5 $10,000.00
Rick Sanches Corolla $1,500.00 8 $12,000.00
Johnny Cage Corolla $1,500.00 2 $3,000.00
Kratos Olympus Corolla $1,500.00 1 $1,500.00
Morty Sanches Yaris $1,000.00 2 $2,000.00
Lucifer Morningstar Yaris $1,000.00 4 $4,000.00
Clark Kent Yaris $1,000.00 1 $1,000.00
Barry Alen Yaris $1,000.00 1 $1,000.00
31 $48,500.00
Incentives New Rental Fee

Incentives New Rental Fee


$800.00 $8,800.00
$0.00 $6,000.00
$1,000.00 $11,000.00
$1,200.00 $13,200.00
$0.00 $3,000.00
$0.00 $1,500.00
$0.00 $2,000.00
$400.00 $4,400.00
$0.00 $1,000.00
$0.00 $1,000.00
Filtered Data Showing owners who are renting out more than 3 vehicles
First Name Last Name Model Car Rental Fee No. of cars rented Total Rental Fee Incentives
New Rental Fee
Model Car Rental Fee Pivot Table
Camry $25,800.00
Corolla $17,700.00
Yaris $8,400.00
Total Result $51,900.00

Total Rental Fee By Car Model


60000

50000

40000
Total
30000

20000

10000

0
Camry Corolla Yaris Total Result

You might also like