only excel expert

profileahabuloshi
Albalushi_e02ch04_grader_hw_Advertising.xlsx

AdvertisingCosts

Advertising Expenses
Monthly Data
Amenities January February March April May June
Spa $ 3,200 $ 3,500 $ 3,000 $ 3,200 $ 2,700 $ 2,100
Exercise Facility $ 2,000 $ 2,500 $ 2,000 $ 1,800 $ 1,500 $ 2,000
Golf $ 4,500 $ 5,000 $ 5,000 $ 4,800 $ 5,200 $ 3,000
Banquet Facilities $ 7,000 $ 8,000 $ 7,000 $ 7,250 $ 8,500 $ 8,700
Technology Facilities $ 4,000 $ 3,000 $ 4,000 $ 4,500 $ 4,800 $ 3,500
Community Events $ 3,000 $ 5,000 $ 4,000 $ 3,700 $ 4,200 $ 3,600
Family Events $ 2,700 $ 2,650 $ 2,000 $ 3,500 $ 2,750 $ 4,200
Total $ 26,400 $ 29,650 $ 27,000 $ 28,750 $ 29,650 $ 27,100
Semi-Annual Summary
Amenities Total
Spa $ 17,700
Exercise Facility $ 11,800
Golf $ 27,500
Banquet Facilities $ 46,450
Technology Facilities $ 23,800
Community Events $ 23,500
Family Events $ 17,800
Total $ 168,550