Unit 4 computer class

profilewilz08
UnitIV_HomeworkTemplate.xlsx
Home>Computer Science homework help>Unit 4 computer class

Sheet1

Revenue Source Annual Total Monthly Average Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Online Reservations $ 45,208 $ 40,000 $ 15,000 $ 65,000 $ 25,000 $ 39,000 $ 85,000 $ 85,000 $ 74,000 $ 34,000 $ 14,500 $ 26,000
Telephone Reservations $ 6,717 $ 2,200 $ 20,000 $ 4,900 $ 3,100 $ 1,500 $ 12,100 $ 6,100 $ 3,000 $ 2,300 $ 10,600 $ 7,600
Sales calls $ 7,271 $ 5,600 $ 7,500 $ 5,800 $ 4,000 $ 1,800 $ 2,300 $ 8,800 $ 6,200 $ 4,850 $ 26,000 $ 4,900
Activity companies $ 80,449 $ 10,500 $ 65,000 $ 49,000 $ 55,000 $ 155,000 $ 105,889 $ 100,000 $ 69,000 $ 63,000 $ 68,000 $ 163,000
Grand total:

Sheet2

Revenue Source Jan
Online Reservations $ 45,208
Telephone Reservations $ 6,717
Sales calls $ 7,271
Activity companies $ 80,449

Sheet3

Description Date Paid Category Amount
Nassau Store 11/8/14 Retail $ 4,974.53
Atlantis Resort 11/5/14 Hotels $ 78.34
Atlantis Resort 11/8/14 Hotels $ 35.99
Atlantis Resort 12/20/14 Hotels $ 25.12
Bahama Activities 10/31/14 Activities $ 451.15
Tiamo Resort 11/5/14 Hotels $ 11.68
Tiamo Resort 11/16/14 Hotels $ 160.00
Tiamo Resort 12/7/14 Hotels $ 46.00
Tiamo Resort 12/10/14 Hotels $ 15.00
Fun in the Sun Tours 11/5/14 Activities $ 99.75
Bahama Adventure Tours 10/22/14 Activities $ 2,200.00
Bahama Water Park 10/26/14 Activities $ 13,300.00
Island Seas Resort 11/5/14 Hotels $ 9,133.00
Island Seas Resort 12/21/14 Hotels $ 52.75
Nassau Ocean Adventures 11/27/14 Activities $ 230.00
Coco Cay Store 12/8/14 Retail $ 445.33
Lucaya Store 12/9/14 Retail $ 175.00
Ocean Tours Bahama 12/2/14 Activities $ 590.00
Nassau Adventures 12/3/14 Activities $ 130.00
Musha Cay Resort 12/10/14 Hotels $ 45.97
Paradise Fun Company 11/29/14 Activities $ 750.25
Alice Town Store 12/30/14 Retail $ 1,452.67
Nassau Fun Activities 10/26/14 Activities $ 884.75
Bay Street Store 12/30/14 Retail $ 396.88