2 Excell worksheets (Marketing)
amassagardi001
ch_4__5_.xlsxChapter 4
| Chapter 4 Apply What You Know-Student Worksheet | ||||||
| 4.2 | ||||||
| Part A | ||||||
| Rooms Purchased | ADR | Total Revenue | ||||
| I. 250 | $139.99 | |||||
| II. 350 | $139.99 | |||||
| III. 401 | $119.99 | |||||
| Part B | ||||||
| Rooms Purchased | Total Revenue | Variable Costs @ $65.00 per room | After Variable Costs Revenue | |||
| I. 250 | ||||||
| II. 350 | ||||||
| III. 401 | ||||||
| 4.3 | ||||||
| Fox Meadows Weekly Sales Recap: | ||||||
| Source | Standard Fee | Net Round Fee | Distribution Costs | Net Round Yield | Rounds Sold | Net Revenue |
| Comfort Suites | $ 75.00 | $ 69.00 | $ - 0 | % | 40 | $ - |
| Hampton Inn | $ 75.00 | $ 67.00 | 30 | |||
| Hilton Garden | $ 75.00 | $ 65.00 | 30 | |||
| Springhill | $ 75.00 | $ 61.00 | 20 | |||
| Sheraton | $ 75.00 | $ 60.00 | 40 | |||
| Hyatt Place | $ 75.00 | $ 59.00 | 20 | |||
| Total | $ 75.00 | $ - 0 | 180 | $ - 0 | ||
| 4.4 | ||||||
| “The Char-burger” 1,000 Customers Served | ||||||
| Item | # Sold | Selling Price | Item Cost | Item Cont. Margin | Total Cont. Margin | |
| Burger | 822 | $2.99 | $1.45 | $1.54 | ||
| Fries | 640 | $1.49 | $0.44 | $1.05 | ||
| Drink | 972 | $1.19 | $0.22 | $0.97 | ||
| Total | ||||||
| 4.5 | ||||||
| Keith’s Plan | Rooms Sold | ADR | RevPAR | GOPPAR | ||
| 220 | $ 179.00 | |||||
| 180 | $ 109.00 | |||||
| Total | $ - 0 | |||||
| Carla’s Plan | Rooms Sold | ADR | RevPAR | GOPPAR | ||
| 220 | $ 179.00 | |||||
| 120 | $ 159.00 | |||||
| Total |
Chapter 5
| Chapter 5 Apply What You Know-Student Worksheet | |||||
| 5.2 | |||||
| Rooms Sold | ADR | Total Revenue | Total Variable Cost @ $55.00/ room | Net Revenue | |
| Without Group | |||||
| With Group | |||||
| Total | |||||
| 5.3 | |||||
| Total Revenue | $225,000.00 | ||||
| Less Product Cost @ (31.5%) | $70,875.000 | ||||
| Less Other Variable Costs (48.5%) | $109,125.000 | ||||
| Revenue less Product and Variable costs (20%) | $45,000.000 | ||||
| Average per event (with 25 events) | $1,800.000 | ||||
| 5.4 | |||||
| Unit Number | Additional Revenue | Variable Costs | Contribution to Fixed Costs | ||
| 1 | $850 | ||||
| 2 | $700 | ||||
| 3 | $650 | ||||
| 4 | $750 | ||||
| 5 | $900 | ||||
| Total | |||||
| 5.5 | |||||
| Pub Staffing | 4 servers | 5servers | 6 servers | 7 servers | 8 servers |
| Revenue @ $ 600 per server | |||||
| Wages @ $ 96.00 per server | |||||
| Bev Cost @ 25% | |||||
| Revenue Remaining After Product and Labor Cost |
