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
icon
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.

 

 

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: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
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
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L