Homework answers / question archive / New Perspectives Excel 2019 Module 5: SAM Project 1a Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS Author: Justin Gross New Perspectives Excel 2019 | Module 5: SAM Project 1a Note: Do not edit this sheet

New Perspectives Excel 2019 Module 5: SAM Project 1a Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS Author: Justin Gross New Perspectives Excel 2019 | Module 5: SAM Project 1a Note: Do not edit this sheet

MS Excel

Share With

---

New Perspectives Excel 2019 Module 5: SAM Project 1a

Narbonne Suites

GENERATING REPORTS FROM MULTIPLE WORKBOOKS

Author:

Justin Gross

New Perspectives Excel 2019

| Module 5: SAM Project 1a

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of

the file from the SAM website.

 

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of

 

Narbonne Suites

State

Statewide Manager

Location

Email

Idaho

Lenard Zimmerman

Nampa, ID

Montana

Doretta Burnam

Oregon

Thomasena Bustamante

Gresham, OR

Washington

Frederic Brickley

Tacoma, WA

idahomgr@example.com

Bozeman, MT

montanamgr@example.com

oregonmgr@example.com

http://www.narbonnesuites.cengage.com/

 

Narbonne Suites

Idaho

2021 Sales

Q1

Q2

Q3

Q4

Total

In Person

$ 103,021.00

$ 138,048.00

$ 207,072.00

$ 109,202.00

$ 557,343.00

Online

$ 88,980.00

$ 148,597.00

$ 239,241.00

$ 79,192.00

$ 556,010.00

AAA

$ 201,042.00

$ 281,459.00

$ 425,003.00

$ 215,115.00

$ 1,122,619.00

Other

$ 23,522.00

$ 31,519.00

$ 46,648.00

$ 16,936.00

$ 118,625.00

Total

$ -

 

Narbonne Suites

Montana

2021 Sales

Q1

Q2

Q3

Q4

Total

In Person

$185,437.80

$248,486.40

$372,729.60

$196,563.60

$1,003,217.40

Online

$96,988.20

$161,970.73

$260,772.69

$86,319.28

$606,050.90

AAA

$349,813.08

$489,738.66

$739,505.22

$374,300.10

$1,953,357.06

Other

$37,870.42

$50,745.59

$75,103.28

$27,266.96

$190,986.25

Total

$0.00

 

Narbonne Suites

Oregon

2021 Sales

Q1

Q2

Q3

Q4

Total

In Person

$537,770

$720,611

$1,080,916

$570,034

$2,909,330

Online

$242,471

$404,927

$651,932

$215,798

$1,515,127

AAA

$1,248,833

$1,748,367

$2,640,034

$1,336,251

$6,973,485

Other

$102,250

$137,013

$202,779

$73,621

$515,663

Total

$0

 

Narbonne Suites

Consolidated

2021 Sales

Q1

Q2

Q3

Q4

Total

2020 Total

$0

$0

$0

$0

Total

$0

$0

$0

$0

$0