Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1a. What was the lowest percent change

Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions.

Q1a. What was the lowest percent change (either increase or decrease) from 2022 to 2023 among the four regions? (Enter the answer as a positive number.) fill in the blank 1 of 1%

Q2a. What was the highest percentage of revenue in a region to total revenue in 2023 among the four regions?

Q3a. What was the higher percent change (either increase or decrease) from 2022 to 2023 between the two services? (Enter the answer as a positive number.) fill in the blank 1 of 1%

What was the percentage of that amount out of total revenue in 2023 from both services? fill in the blank 1 of 1%

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:134; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl37 {font-size:11.0pt; font-family:Calibri, sans-serif; mso-font-charset:0;} .xl39 {font-size:11.0pt; font-weight:700; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center;} .xl41 {font-size:11.0pt; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center;}

Year Region Customer Service Amount
2022 South Robert Repair 1,250
2022 South Ashton Repair 1,270
2023 West Pastor Installation 4,490
2023 West Pastor Installation 6,340
2022 West Beldon Repair 2,100
2022 North Khalid Installation 6,450
2022 South Robert Repair 1,190
2022 North Khalid Repair 1,000
2023 West Pastor Repair 2,260
2023 North Sawyer Repair 640
2022 East Master Repair 1,750
2022 West Pastor Installation 4,020
2022 East Cleary Repair 1,520
2023 West Beldon Repair 650
2022 South Robert Repair 1,610
2023 West Pastor Installation 3,870
2023 South Ashton Installation 5,720
2022 West Beldon Installation 7,070
2023 South Ashton Repair 2,260
2022 East Cleary Repair 2,160
2023 South Robert Installation 5,940
2023 South Robert Repair 720
2022 North Sawyer Installation 6,720
2023 North Khalid Repair 980
2023 East Cleary Installation 3,790
2023 North Sawyer Repair 2,420
2023 South Robert Installation 4,370
2023 North Khalid Installation 5,660
2022 South Ashton Installation 5,230
2023 North Sawyer Repair 1,350
2023 South Ashton Installation 3,830
2022 East Master Repair 1,200
2022 North Sawyer Repair 2,100
2022 North Khalid Installation 6,320
2022 East Master Installation 4,430
2022 North Khalid Repair 1,530
2022 North Khalid Repair 1,070
2022 East Master Installation 5,680
2022 North Khalid Repair 1,070
2023 South Robert Installation 4,730
2022 South Ashton Installation 3,570
2023 East Cleary Repair 1,760
2022 South Ashton Repair 820
2023 North Khalid Installation 4,680
2023 West Pastor Repair 2,330
2022 North Sawyer Installation 3,550
2023 South Robert Repair 810
2022 West Beldon Repair 1,640
2022 North Khalid Installation 3,860
2023 West Pastor Repair 2,210
2023 West Beldon Repair 1,480
2022 South Ashton Installation 4,880
2023 North Khalid Repair 2,010
2022 East Cleary Installation 7,150
2023 South Ashton Installation 4,310
2023 North Khalid Repair 1,250
2022 North Khalid Installation 3,520
2023 North Sawyer Installation 7,240
2022 North Sawyer Repair 1,450
2022 East Master Installation 6,910
2022 East Master Installation 6,770
2022 South Ashton Installation 6,530
2022 North Khalid Installation 5,110
2023 West Pastor Repair 1,930
2023 North Khalid Installation 3,990
2023 South Ashton Installation 5,340
2022 East Cleary Installation 3,790
2022 South Robert Installation 7,020
2022 South Ashton Repair 2,250
2023 South Robert Repair 2,390
2023 East Cleary Repair 1,180
2023 North Sawyer Repair 2,210
2023 South Robert Repair 1,700
2022 North Sawyer Installation 6,180
2022 North Sawyer Repair 1,980
2022 West Beldon Installation 7,310
2022 West Beldon Repair 1,990
2023 North Sawyer Installation 5,450
2023 North Sawyer Installation 6,670
2023 North Sawyer Installation 4,280
2023 West Beldon Installation 4,660
2023 North Khalid Repair 2,090
2023 North Sawyer Installation 6,300
2023 East Cleary Installation 5,990
2022 South Robert Installation 5,190
2023 South Robert Installation 5,090
2022 South Ashton Installation 7,180
2023 East Cleary Installation 7,180
2022 East Cleary Repair 1,160
2022 South Robert Installation 7,400
2023 West Beldon Repair 2,410
2022 East Master Installation 6,320
2022 South Robert Repair 2,050
2022 West Beldon Installation 4,450
2022 East Cleary Repair 990
2023 West Pastor Installation 4,650
2023 North Khalid Repair 1,490
2023 West Pastor Installation 7,070
2023 East Master Repair 630
2022 North Sawyer Installation 7,120
2023 North Sawyer Repair 2,480
2022 North Khalid Installation 4,320
2023 North Khalid Repair 1,760
2022 North Khalid Installation 4,580
2023 West Pastor Repair 2,090
2022 South Robert Repair 1,340
2022 South Robert Installation 4,010
2023 South Ashton Installation 6,660
2023 East Master Repair 1,300
2023 East Master Repair 2,100
2023 West Pastor Repair 1,690
2022 East Master Repair 2,260
2023 East Master Installation 6,230
2022 West Pastor Installation 6,100
2023 West Beldon Repair 1,310
2022 South Ashton Installation 6,250
2023 West Pastor Installation 7,220
2022 North Sawyer Installation 3,660
2022 West Pastor Installation 4,530
2022 West Pastor Installation 7,330
2023 South Ashton Repair 1,970
2022 North Sawyer Installation 7,330
2023 North Sawyer Repair 2,410
2023 South Robert Installation 7,260
2022 South Robert Installation 4,110
2022 North Khalid Installation 5,420
2022 East Cleary Installation 3,580
2022 East Master Installation 7,270
2022 West Beldon Installation 5,760
2022 North Khalid Installation 6,210
2022 East Cleary Repair 880
2022 North Sawyer Repair 1,600
2023 West Pastor Installation 7,020
2023 West Pastor Repair 2,390
2022 North Khalid Repair 1,400
2022 East Cleary Repair 2,190
2022 North Sawyer Installation 7,090
2023 South Robert Installation 4,630
2023 South Robert Installation 3,870
2022 South Ashton Installation 5,400
2022 North Khalid Installation 6,550
2023 West Beldon Repair 820
2023 East Master Installation 4,380
2023 West Beldon Installation 5,040
2022 East Cleary Installation 7,480
2023 South Ashton Repair 1,070
2023 East Master Installation 7,390
2023 East Cleary Repair 2,240
2022 South Robert Repair 1,220
2023 West Beldon Repair 1,260
2022 North Sawyer Installation 4,750
2023 East Master Repair 840
2022 South Ashton Repair 630
2023 West Beldon Repair 1,220
2022 South Ashton Repair 620
2023 West Pastor Installation 5,910
2023 South Robert Repair 1,270
2022 East Cleary Installation 4,990
2023 South Ashton Installation 4,000
2023 East Master Installation 4,590
2023 North Sawyer Installation 6,860
2022 East Master Installation 4,960
2023 West Pastor Installation 7,180
2023 North Khalid Repair 1,900
2022 West Pastor Repair 860
2022 East Master Installation 6,060
2023 South Robert Installation 4,980
2023 North Khalid Installation 4,640
2023 North Sawyer Repair 1,690
2022 West Pastor Repair 2,040
2023 West Beldon Installation 5,160
2023 East Master Repair 600
2023 South Ashton Installation 5,700
2023 East Master Installation 5,150
2022 East Master Repair 800
2023 West Beldon Repair 2,030
2023 North Sawyer Repair 730
2022 West Beldon Installation 5,920
2022 East Master Installation 4,250
2022 North Sawyer Installation 7,250
2022 North Sawyer Repair 1,580
2022 West Beldon Repair 790
2022 South Robert Repair 860
2023 West Beldon Repair 2,380
2022 West Pastor Repair 2,040
2023 North Sawyer Repair 1,490
2023 South Ashton Repair 2,400
2023 East Master Installation 4,030
2022 North Khalid Installation 5,210
2022 North Khalid Repair 800
2023 West Beldon Repair 2,490
2023 East Cleary Repair 1,490
2022 East Master Repair 1,780
2022 North Khalid Installation 4,020
2023 West Pastor Installation 3,720
2023 East Cleary Installation 6,590
2023 South Robert Installation 6,590
2022 North Sawyer Repair 1,540
2023 North Sawyer Installation 7,420
2023 South Ashton Installation 7,090
2022 South Robert Repair 1,640
2023 North Khalid Repair 730
2022 South Ashton Repair 2,300
2023 East Cleary Repair 990
2022 South Robert Repair 2,240
2023 West Beldon Installation 6,800
2022 West Beldon Repair 650
2023 East Master Installation 6,090
2023 South Robert Installation 3,760
2022 West Pastor Repair 1,500
2022 North Khalid Repair 1,560
2022 West Pastor Installation 5,780
2022 South Ashton Installation 6,510
2022 East Cleary Installation 5,840
2022 South Robert Installation 6,470
2022 West Beldon Repair 610
2023 South Robert Installation 6,620
2022 West Beldon Installation 5,450
2023 East Master Installation 7,390
2023 East Master Repair 2,030
2023 North Sawyer Repair 1,350
2022 West Pastor Repair 2,320
2023 North Khalid Repair 1,370
2023 East Master Repair 2,500
2022 South Ashton Repair 620
2022 South Robert Repair 760
2023 North Sawyer Installation 4,240
2022 East Master Installation 3,900
2023 West Beldon Installation 4,620
2022 West Pastor Installation 5,720
2023 West Beldon Installation 6,810
2022 North Sawyer Repair 1,120
2023 North Khalid Installation 6,650
2023 West Pastor Installation 5,350
2023 South Robert Repair 1,630
2023 East Cleary Repair 1,310
2022 North Khalid Repair 1,450
2022 North Khalid Installation 4,300
2022 East Master Installation 7,220
2022 South Robert Repair 1,530
2022 North Sawyer Repair 1,170
2022 North Sawyer Repair 1,260
2023 South Robert Installation 5,460
2022 North Khalid Repair 1,600
2022 South Ashton Repair 1,240
2022 East Cleary Installation 7,100
2023 East Master Repair 2,430
2023 South Ashton Installation 3,850
2022 South Robert Installation 4,920
2023 North Khalid Installation 4,190
2023 North Khalid Repair 1,240
2022 East Master Installation 6,480
2022 West Pastor Repair 760
2023 West Beldon Installation 7,200
2022 North Khalid Repair 610
2022 East Master Repair 2,050
2022 South Ashton Repair 1,920
2023 North Khalid Installation 7,480
2023 North Khalid Repair 1,510
2022 East Cleary Repair 2,450
2022 West Beldon Repair 830
2023 East Cleary Repair 2,400
2023 East Master Installation 6,280
2023 East Cleary Installation 6,020
2023 North Khalid Repair 990
2022 North Khalid Repair 750
2022 East Master Installation 5,280
2022 West Beldon Repair 2,480
2022 East Cleary Installation 6,950
2022 North Sawyer Repair 2,180
2023 East Master Installation 5,200
2022 East Master Repair 1,000
2023 East Cleary Installation 4,690
2023 South Ashton Repair 1,840
2023 North Sawyer Installation 3,500
2022 East Master Installation 5,300
2023 West Beldon Installation 5,540
2022 South Robert Repair 1,770
2023 West Pastor Repair 2,240
2022 West Pastor Repair 910
2023 East Master Repair 2,140
2022 West Beldon Installation 3,590
2023 West Pastor Installation 5,230
2023 West Pastor Installation 3,980
2023 North Sawyer Installation 6,390
2022 West Pastor Repair 1,250
2023 West Beldon Installation 4,520
2023 North Khalid Installation 3,780
2022 North Sawyer Installation 4,350
2023 West Beldon Installation 5,310
2022 South Robert Repair 1,160
2023 South Ashton Repair 1,060
2022 West Pastor Repair 1,320
2022 East Cleary Repair 1,520
2022 East Cleary Repair 2,140
2023 East Cleary Repair 1,620
2022 South Ashton Repair 760
2023 South Ashton Repair 1,840
2023 East Cleary Repair 980
2023 North Khalid Installation 5,410

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting An Introduction

Authors: Atrill Peter, Eddie McLaney

6th Edition

0273771833, 978-0273771838

More Books

Students also viewed these Accounting questions

Question

=+b) Is this a prospective or retrospective study? Explain.

Answered: 1 week ago