Problem 5: Sort the data by portfolio, then by revenue. Then write a fuction in the Blue cell that returns the total revenues in portfolio B.
Problem 5: Sort the data by portfolio, then by revenue. Then write a fuction in the Blue cell that returns the total revenues in portfolio B.
Chapter6: Investing And Financing Activities
Section: Chapter Questions
Problem 2.4C
Related questions
Question
![84
85 Problem 5: Sort the data by portfolio, then by revenue. Then write a fuction in
86 the Blue cell that returns the total revenues in portfolio B.
87
88
Hotel
89
Hotel Aston
90
ORW Hotel
91
92
93
94
Great Value Hotel
Ski Lodge at Buffington
Blair Hotel and Suites
Portfolio
A
AAB
Revenues
1,345,678
1,387,943
1,983,476
1,623,619
760,000
A
Independent Hotel 1
B
1,211,775
95
Independent Hotel 2
96
97
Hampton Inn Shawnigan
Hilton 1111
98
Crofton Hotel and Suites
99
IGA Hotel
100
101
Four Seasons Chattanooga
Four Seasons Kamloops
102
103
Briartown Suites
LFA Hotel
104
Fairfield Inn West
105
Fairfield Inn East
BBABCCBDEDD
2,157,208
2,261,040
3,900,876
2,513,450
1,300,983
2,600,422
1,232,965
2,463,800
1,204,261
1,903,225
1,524,219
106
Fairfield Inn South
B
1,260,856
107
Independent Hotel 3
A
108
Independent Hotel 4
A
246,782
1,345,000
109
Square Hotel
110
Heights Hotel
111
Calabasas Hotel
112
Ontario Hotel
113
114
115
116
Independent Hotel 5
Sum of Revenues for Displayed Hotels
BDABA
1,822,802
1,916,599
3,456,098
2,074,795
4,567,432
++
117
118 Probler](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0b8af5fd-bfea-4af7-a02f-325e8dad237c%2F94c5b95b-b187-4810-b394-6776475d9460%2Fc89d2u_processed.jpeg&w=3840&q=75)
Transcribed Image Text:84
85 Problem 5: Sort the data by portfolio, then by revenue. Then write a fuction in
86 the Blue cell that returns the total revenues in portfolio B.
87
88
Hotel
89
Hotel Aston
90
ORW Hotel
91
92
93
94
Great Value Hotel
Ski Lodge at Buffington
Blair Hotel and Suites
Portfolio
A
AAB
Revenues
1,345,678
1,387,943
1,983,476
1,623,619
760,000
A
Independent Hotel 1
B
1,211,775
95
Independent Hotel 2
96
97
Hampton Inn Shawnigan
Hilton 1111
98
Crofton Hotel and Suites
99
IGA Hotel
100
101
Four Seasons Chattanooga
Four Seasons Kamloops
102
103
Briartown Suites
LFA Hotel
104
Fairfield Inn West
105
Fairfield Inn East
BBABCCBDEDD
2,157,208
2,261,040
3,900,876
2,513,450
1,300,983
2,600,422
1,232,965
2,463,800
1,204,261
1,903,225
1,524,219
106
Fairfield Inn South
B
1,260,856
107
Independent Hotel 3
A
108
Independent Hotel 4
A
246,782
1,345,000
109
Square Hotel
110
Heights Hotel
111
Calabasas Hotel
112
Ontario Hotel
113
114
115
116
Independent Hotel 5
Sum of Revenues for Displayed Hotels
BDABA
1,822,802
1,916,599
3,456,098
2,074,795
4,567,432
++
117
118 Probler
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you