Description
I've attached two files one attachment giving you the instructions and the things that you need to get done. The other one Excel file that you should use it.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Q-1
Year 2007 has the highest revenue and the total revenue in this year was $60715831.69.
Overall Revenue is $285250872.8.
Below is the screenshot of the obtained result.
Q-2.
Revenue for E-bike in 2010 was $2024435.69. The result is shown in the screenshot below.
Q
Q-3
There is no revenue for E-bike in 2009.
Q-4
Sales quantity for airport bikes in 2007 is $1363.
Q-5.
Year 2007 had the highest sales quantity.
Q-6
Year 2009 had the lowest revenue.
Q-7
In the year 2009, the Fixed Gear Bike Plus has the lowest revenue.
Q-8
The material water bottle has the lowest overall revenue.
Q-9
The year 2007 being the year with highest net sales, the Division BI has the highest net sales.
Q-10
For
the
division
BI
the
customer
BI
Bikes
have
Q-11
In the year 2009 (year with lowest revenue) BI division has the highest sales.
highest
net
sales.
Q-12
In the division BI (with highest sales) the customer Bavaria Bikes has the highest sales revenue.
Q-13
Bavaria bikes provided highest revenue for AS in year 2009.
Q-14
In 2011 for bicycles the total revenue for top 3 consumers is $14874933.54
Q-15
Average of Revenue
Airport Bikes
Alster Cycling
Bavaria Bikes
Beantown Bikes
Big Apple Bikes
Capital Bikes
Cruiser Bikes
DC Bikes
Drahtesel
Fahrpott
Furniture
City
Bikes
Motown Bikes
Neckarrad
Northwest Bikes
Ostseerad
Peachtree Bikes
Philly Bikes
Rädlelland
Red Light Bikes
Rocky
Mountain
Bikes
Silicon Valley Bikes
SoCal Bikes
Velodrom
Windy City Bikes
9346.35965
9099.364953
21508.51578
13316.55402
8765.043765
13392.83349
9280.777667
7362.736922
7826.128025
7570.02345
4436.613581
7419.737384
10738.89025
7284.523951
5247.738115
7165.447777
7349.475389
12847.6954
10729.11583
9140.204497
16893.80798
7074.874256
6770.830681
7330.294734
Q-16
2007
Airport Bikes
Alster Cycling
Bavaria Bikes
Beantown Bikes
Big Apple Bikes
Average
Revenue
9969.758898
8970.960781
8671.084378
20717.88521
14657.85911
9304.837037
of
Capital Bikes
Cruiser Bikes
DC Bikes
Drahtesel
Fahrpott
Furniture City Bikes
Motown Bikes
Neckarrad
Northwest Bikes
Ostseerad
Peachtree Bikes
Philly Bikes
Rädlelland
Red Light Bikes
Rocky Mountain Bikes
Silicon Valley Bikes
SoCal Bikes
Velodrom
Windy City Bikes
2008
Airport Bikes
Alster Cycling
Bavaria Bikes
Beantown Bikes
Big Apple Bikes
Capital Bikes
Cruiser Bikes
DC Bikes
Drahtesel
Fahrpott
Furniture City Bikes
Motown Bikes
Neckarrad
Northwest Bikes
Ostseerad
Peachtree Bikes
Philly Bikes
Rädlelland
Red Light Bikes
Rocky Mountain Bikes
Silicon Valley Bikes
12374.95713
9238.246667
8121.176707
7844.970373
6932.869585
4883.367876
8445.927203
10303.30786
7792.141732
5338.401146
8208.488189
7930.984436
11957.52396
10341.18313
9448.352941
18106.64803
7259.387755
6405.08464
8498.676471
10036.14167
10089.86188
8655.243451
19904.47224
15113.9215
9904.430748
13876.8
9183.600405
7911.209959
7167.646198
7356.152385
4994.957039
7237.586092
10289.98943
7829.104916
4959.35585
7707.486311
8024.257888
12559.61401
10241.4426
10123.19037
17888.97837
SoCal Bikes
Velodrom
Windy City Bikes
2009
Airport Bikes
Alster Cycling
Bavaria Bikes
Beantown Bikes
Big Apple Bikes
Capital Bikes
Cruiser Bikes
DC Bikes
Drahtesel
Fahrpott
Furniture City Bikes
Motown Bikes
Neckarrad
Northwest Bikes
Ostseerad
Peachtree Bikes
Philly Bikes
Rädlelland
Red Light Bikes
Rocky Mountain Bikes
Silicon Val...