Part III
JanAds
| Advertising Budget | |||
| For the Month of: | January | ||
| Type | Actual | Budget | Over/Under |
| Television | $ 4,320 | $ 5,000 | |
| Radio | $ 6,680 | $ 6,000 | |
| Newspapers | $ 2,512 | $ 2,500 | |
| Magazines | $ 3,650 | $ 3,500 | |
| Direct Mail | $ 1,050 | $ 1,000 | |
| On-Line | $ 520 | $ 600 | |
| Trade Shows | $ 750 | $ 900 | |
| Other | $ - 0 | $ 500 | |
&F
FebAds
| Advertising Budget | |||
| For the Month of: | February | ||
| Type | Actual | Budget | Over/Under |
| Television | $ 6,580 | $ 5,000 | |
| Radio | $ 5,020 | $ 6,000 | |
| Newspapers | $ 3,200 | $ 2,500 | |
| Magazines | $ 1,200 | $ 3,500 | |
| Direct Mail | $ 600 | $ 1,000 | |
| On-Line | $ 750 | $ 600 | |
| Trade Shows | $ - 0 | $ 900 | |
| Other | $ 300 | $ 500 | |
&F
MarAds
| Advertising Budget | |||
| For the Month of: | March | ||
| Type | Actual | Budget | Over/Under |
| Television | $ 4,200 | $ 5,000 | |
| Radio | $ 6,254 | $ 6,000 | |
| Newspapers | $ 3,250 | $ 2,500 | |
| Magazines | $ 3,520 | $ 3,500 | |
| Direct Mail | $ 2,670 | $ 1,000 | |
| On-Line | $ 770 | $ 600 | |
| Trade Shows | $ 1,150 | $ 900 | |
| Other | $ 250 | $ 500 | |
&F
Q1Summary
| Advertising Budget | |||
| Quarter 1 Summary | |||
| Type | Actual | Budget | Over/Under |
| Television | |||
| Radio | |||
| Newspapers | |||
| Magazines | |||
| Direct Mail | |||
| On-Line | |||
| Trade Shows | |||
| Other |
&F
Q1Averages
| Advertising Budget | |||
| Quarter 1 Averages | |||
| Type | Actual | Budget | Over/Under |
&F
AdRequest
| Advertising Request | ||
| Type of Advertisement | ||
| Start Date | ||
| End Date | ||
| Cost Per Day | ||
| No. Days | ||
| Total Cost | $ - 0 | |
| Comments: | ||
&F
AdOptions
| Type |
| Television |
| Radio |
| Newspapers |
| Magazines |
| Direct Mail |
| On-Line |
| Trade Shows |
| Other |
&F
Documentation
| Create Date | By Whom | Description | Workbook Name |
| 5/12/14 | e04ps1HotelAdvertising.xlsx | ||
| Mod. Date | By Whom | Mod. Description | Last Version Backup Name
: VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd |
| 5/8/15 | Firstname Lastname | ||
| Create Date | Sheet Name | Creator | Purpose |
&F