A B C D E F 1 Satisfaction Levels Distribution 2 Satisfaction Level 5 3 Satisfaction Level 4 4 Satisfaction Level 3 5 Satisfaction Level 2 6 Satisfaction Level 1 7 8 9 10 Financial Aggregated Data 11 12 13 Smallest Revenue 14 Largest Revenues 15 Lowest Expenses 16 Average Expenses 17 # of Expense components 18 # of Revenue components 19 20 21 2023 2024 (Ctrl) $140,000.00 $120,000.00 $100,000.00 $80,000.00 $60,000.00 $40,000.00 $20,000.00 Revenue and Gains $140,000.00 Expenses and Loses $120,000.00 $100,000.00 $64,350.00 $54,450.00 $80,000.00 $60,000.00 $38,115.00 $40,000.00 $65,000.00 $23,166.00 $- $55,000.00 *Sales revenue *Interest revenue *Investment Income *Other revenue $20,000.00 $38,500.00 $14,850.00 ■2023 2024 $123,450.00 $126,536.25 $65,000.00 $15,550.00 $66,625.00 $15,938.75 $110,330.00 $113,088.25 $23,400.00 $15,000.00 $ 2023 2024 **Cost of goods sold **Selling and admin administrative ***Computer (operating) **Depreciation **Interest expense ■2023 2024
A B C D E F 1 Satisfaction Levels Distribution 2 Satisfaction Level 5 3 Satisfaction Level 4 4 Satisfaction Level 3 5 Satisfaction Level 2 6 Satisfaction Level 1 7 8 9 10 Financial Aggregated Data 11 12 13 Smallest Revenue 14 Largest Revenues 15 Lowest Expenses 16 Average Expenses 17 # of Expense components 18 # of Revenue components 19 20 21 2023 2024 (Ctrl) $140,000.00 $120,000.00 $100,000.00 $80,000.00 $60,000.00 $40,000.00 $20,000.00 Revenue and Gains $140,000.00 Expenses and Loses $120,000.00 $100,000.00 $64,350.00 $54,450.00 $80,000.00 $60,000.00 $38,115.00 $40,000.00 $65,000.00 $23,166.00 $- $55,000.00 *Sales revenue *Interest revenue *Investment Income *Other revenue $20,000.00 $38,500.00 $14,850.00 ■2023 2024 $123,450.00 $126,536.25 $65,000.00 $15,550.00 $66,625.00 $15,938.75 $110,330.00 $113,088.25 $23,400.00 $15,000.00 $ 2023 2024 **Cost of goods sold **Selling and admin administrative ***Computer (operating) **Depreciation **Interest expense ■2023 2024
Contemporary Marketing
18th Edition
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Louis E. Boone, David L. Kurtz
Chapter10: Marketing Research
Section10.5: Technology In Marketing Research
Problem 1LO
Related questions
Question
Please use screenshots to answer question
Give a brief analysis of the data found in the pie chart as well as those
found in the two column charts created (in your MS Excel assignment),
considering the recent move to conducting government transactions
online.

Transcribed Image Text:A
B
C
D
E
F
1 Satisfaction Levels
Distribution
2 Satisfaction Level 5
3 Satisfaction Level 4
4 Satisfaction Level 3
5 Satisfaction Level 2
6 Satisfaction Level 1
7
8
9
10 Financial Aggregated Data
11
12
13 Smallest Revenue
14 Largest Revenues
15 Lowest Expenses
16 Average Expenses
17 # of Expense components
18 # of Revenue components
19
20
21
2023
2024
(Ctrl)

Transcribed Image Text:$140,000.00
$120,000.00
$100,000.00
$80,000.00
$60,000.00
$40,000.00
$20,000.00
Revenue and Gains
$140,000.00
Expenses and Loses
$120,000.00
$100,000.00
$64,350.00
$54,450.00
$80,000.00
$60,000.00
$38,115.00
$40,000.00
$65,000.00
$23,166.00
$-
$55,000.00
*Sales revenue
*Interest revenue
*Investment Income
*Other revenue
$20,000.00
$38,500.00
$14,850.00
■2023
2024
$123,450.00
$126,536.25
$65,000.00
$15,550.00
$66,625.00
$15,938.75
$110,330.00
$113,088.25
$23,400.00
$15,000.00
$
2023 2024
**Cost of goods
sold
**Selling and admin
administrative
***Computer
(operating)
**Depreciation
**Interest expense
■2023 2024
Expert Solution

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 2 steps with 3 images

Recommended textbooks for you

Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing

Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing