80.2K

Verified Solution

Link Copied!

Create a Sales and Marketing budget for each of the following scenarios: 1. One for a 68 room, limited service hotel located on a freeway that does 1.12 million annually with 63% occupancy. 2. One for a 120 room select service hotel with a recognizable brand that is located in a college town in a mid-size city runs 80% occupancy and does about 4 million a year in room sales and 300k in Food and beverage Sales. 3. One for a 250 room convention hotel in Seattle, runs 80% occupancy, and does 11.2 million in room sales, and an additional 2 million in food and beverage sales. It is a popular national chain. For the purposes of this assignment use 6% of total revenues as your basis for the sales department expenses. If you choose to do more or less than this amount, justify your reasons. Iwould recommend doing these budgets in an excel spreadsheet so that you do not have to write the same information down for each hotel. Thave added a spreadsheet for you to use as a template but remember to explain each line item. For example, if you have 2000 in the month of June for Print Media, break it down in your explanation. You might say 500 for an ad in a local HS football program, 1000 for college back to school brochure.... do not just put in an arbitrary number with no back up In addition, you will see a section titled "Franchise Related Costs" which would only need to be filled out in the event that it is a branded hotel, but does not need to be filled out for this assignment. This number should not be included in your 6% Company Name: Anywhere Hotel Year 2014 FRANCHISE COSTS Jul Aug Jan Feb pr Jun Sept Oct Nov Dec Total OPERATING EXPENSES 820045 FRANCHISE ROYALTY FEE 820145 FRANCHISE MARKETING FFE 820545 FRANCHISE LOYALTY FEES & OTHER TOTAL FRANCHISE RELATED TOTAL FRANCHISE RELATED Total SALES & MARKETING Apr Jul Jan Feb Mar May Jun Aug Sept Oct Nov Dec PAYROLL EXPENSE 655150 SALES DIRECTOR. SALES MANAGER 655250 655350 SALES STAFF OTHER TOTAL SALARY WAGES 675050 PAYROLL TAX EXPENSE-SALES 685050 EMPLOYEE BENEFITS-SALES TOTAL PAYDOU EXPENSE OPERATING EXPENSES 821050 ADVERTISING, BILLBOARDS 821550 ADVERTISING, MEDIA. 822050 ADVERTISING, PRINT 822550 ADVERTISING, OTHER BROCHURES & PHOTOGRAPHY 823050 823550 CLIENT GIFTS PROMOTIONAL ITEMS 824050 COLLATERAL MATERIALS 824550 CONFERENCES, SEMINARS & TRAINING 825050 DUES & SUBSCRIPTIONS 825550 MEALS& ENTERTAINMENT 826050 MISCELLANEOUS SALES 826550 OPERATING SUPPLIES 827050 OUTSIDE CONTRACT SERVICES ICATIONS 828050 TRADE SHOWS 828550 TRANSPORTATION & LODGING TOTAL EYRENSES TAL OPERATING TOTAL SALES & MARKETING Create a Sales and Marketing budget for each of the following scenarios: 1. One for a 68 room, limited service hotel located on a freeway that does 1.12 million annually with 63% occupancy. 2. One for a 120 room select service hotel with a recognizable brand that is located in a college town in a mid-size city runs 80% occupancy and does about 4 million a year in room sales and 300k in Food and beverage Sales. 3. One for a 250 room convention hotel in Seattle, runs 80% occupancy, and does 11.2 million in room sales, and an additional 2 million in food and beverage sales. It is a popular national chain. For the purposes of this assignment use 6% of total revenues as your basis for the sales department expenses. If you choose to do more or less than this amount, justify your reasons. Iwould recommend doing these budgets in an excel spreadsheet so that you do not have to write the same information down for each hotel. Thave added a spreadsheet for you to use as a template but remember to explain each line item. For example, if you have 2000 in the month of June for Print Media, break it down in your explanation. You might say 500 for an ad in a local HS football program, 1000 for college back to school brochure.... do not just put in an arbitrary number with no back up In addition, you will see a section titled "Franchise Related Costs" which would only need to be filled out in the event that it is a branded hotel, but does not need to be filled out for this assignment. This number should not be included in your 6% Company Name: Anywhere Hotel Year 2014 FRANCHISE COSTS Jul Aug Jan Feb pr Jun Sept Oct Nov Dec Total OPERATING EXPENSES 820045 FRANCHISE ROYALTY FEE 820145 FRANCHISE MARKETING FFE 820545 FRANCHISE LOYALTY FEES & OTHER TOTAL FRANCHISE RELATED TOTAL FRANCHISE RELATED Total SALES & MARKETING Apr Jul Jan Feb Mar May Jun Aug Sept Oct Nov Dec PAYROLL EXPENSE 655150 SALES DIRECTOR. SALES MANAGER 655250 655350 SALES STAFF OTHER TOTAL SALARY WAGES 675050 PAYROLL TAX EXPENSE-SALES 685050 EMPLOYEE BENEFITS-SALES TOTAL PAYDOU EXPENSE OPERATING EXPENSES 821050 ADVERTISING, BILLBOARDS 821550 ADVERTISING, MEDIA. 822050 ADVERTISING, PRINT 822550 ADVERTISING, OTHER BROCHURES & PHOTOGRAPHY 823050 823550 CLIENT GIFTS PROMOTIONAL ITEMS 824050 COLLATERAL MATERIALS 824550 CONFERENCES, SEMINARS & TRAINING 825050 DUES & SUBSCRIPTIONS 825550 MEALS& ENTERTAINMENT 826050 MISCELLANEOUS SALES 826550 OPERATING SUPPLIES 827050 OUTSIDE CONTRACT SERVICES ICATIONS 828050 TRADE SHOWS 828550 TRANSPORTATION & LODGING TOTAL EYRENSES TAL OPERATING TOTAL SALES & MARKETING

Answer & Explanation Solved by verified expert

See Answer