Ch. 4 TYS Student Version HW 1

xlsx

School

Florida International University *

*We aren’t endorsed by this school

Course

6466

Subject

Business

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by mandalysha

TYS 2 Dart Industries Room Sales Worksheet Rooms sold Room rate Total revenue 50 $ 149.99 $ 7,499.50 $ 65.00 $ 3,250.00 $ 4,249.50 250 $ 139.99 $ 34,997.50 $ 65.00 $ 16,250.00 $ 18,747.50 350 $ 139.99 $ 48,996.50 $ 65.00 $ 22,750.00 $ 26,246.50 401 $ 119.99 $ 48,115.99 $ 65.00 $ 26,065.00 $ 22,050.99 Variable cost per room Total variable costs After variable costs revenue A. What would be the hotel’s room revenue if Tom booked: I. 250 rooms in a month II. 350 rooms in a month III. 401 rooms in a month B. Assume the variable cost associated with selling each room is $65.00. What would be the “after variable costs revenue” if Tom booked: I. 250 rooms in a month II. 350 rooms in a month III. 401 rooms in a month C. If you were advising Robin, what would you tell her to consider prior to agreeing to Tom's proposal? If I were Robin I would consider how many guests would be sharing rooms and which room types would be included in the discounted rates.

TYS 3 Fox Meadows Weekly Sales Recap Source Dist. Costs Comfort Suites $ 75.00 $ 69.00 $ 6.00 92.0% 20 $ 1,380 Hampton Inn $ 75.00 $ 67.00 $ 8.00 89.3% 30 $ 2,010 Hilton Garden $ 75.00 $ 65.00 $ 10.00 86.6% 30 $ 1,950 Springhill $ 75.00 $ 61.00 $ 14.00 81.3% 20 $ 1,220 Sheraton $ 75.00 $ 60.00 $ 15.00 80.0% 35 $ 2,100 Hyatt Place $ 75.00 $ 59.00 $ 16.00 78.6% 45 $ 2,655 Total $ 75.00 $ 63.50 Standard Fee Net Round Fee Net Round Yield % Rounds Sold Net Revenue A. What will be Sandy’s “Distribution costs” for each channel? __________ B. What will be Sandy’s “Net round yield %” for each channel? __________ C. What will be Sandy’s “Net revenue” for each channel? ___________ D. What will be the overall average “Net round fee” for the 180 rounds of golf Sandy received during the week from these six channels? ___________ E. Which channel(s) do you believe are Sandy’s best partners? Explain your answer. Sandy's best partners would be Confort Suites, Hampton Inn, and Hilton Garden becua there are less distribution costs for these rounds.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ase

TYS 4 “The Char-burger” 1,000 Customers Served Item # Sold Selling Price Item Cost Burger 822 $5.99 $2.05 $3.94 Fries 640 $1.99 $0.54 $1.45 Drink 972 $1.79 $0.32 $1.47 Total $9.77 $2.91 $6.86 Item Cont. Margin A. Given the data presented, what is the lowest price at which L burger, fries, and a drink combination and still equal the “per cu contribution margin she currently achieves? __$9.00_________ B. Do you think Lara could sell the bundle for more? Explain you Lara could seel the bundle for more given that the burger stand and people will pay for the convenience of having aq quick bund

$3,238.68 $928.00 $1,428.84 Total Cont. Margin Lara could sell a ustomer” served _____ ur answer. is in the airport dled price.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

TYS 5 Tripletree Hotel Sales Alternatives Rooms Sold Room Rate RevPAR GOPPAR Keith’s Plan 220 $ 179.00 $ 39,380 $ 219 180 100 $ 109.00 $ 19,620 $ 109 Total Carla’s Plan 220 $ 179.00 $ 39,380 $ 219 120 66 $ 159.00 $ 19,080 $ 159 Total Occupancy % A. What will be the hotel’s occupancy percent under each of the plans? B. What will be the hotel’s ADR under each of the plans? C. What will be the hotel’s RevPAR under each of the plans? D. What will be the hotel’s GOPPAR under each of the plans? E. If you were Leona, whose plan would you support? I would support Carla because her GOPPAR is better than Keith's. F. The Tripletree is a full-service hotel. Do you think Leona’s position would change if the hotel were a select-service property? Explain your answer. I believe if Leona were the GM of a select-service hotel property she would be solely responsible for RM as there might not be a need for a group sales manager and office manager.

Related Documents

Data Vizualization.pdf

ICE 3-3.docx

CMIS 567-73C - Exercise 2a and 2b - Vy T.docx

CYB 260 Module 5 Project 1.docx

CYB 250 Final Project Milestone David Obi.docx

Ch. 5 TYS Student Version HW.xlsx

Ch. 8 TYS Student Version Hw.xlsx

Ch. 10 TYS Student Version HW.xlsx

Midterm Exam Review Sheet 20th edition (1).docx

Week 3 Case Assignment.docx

TWO MEN AND A TRUCK.docx

Sept 26 2023 Video Conference Call (Finance 3)-2-1.pptx

Recommended textbooks for you

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

SEE MORE TEXTBOOKS

Recommended textbooks for you

Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

SEE MORE TEXTBOOKS