You will need to login to www.statcrunch.com The username an…
You will need to login to www.statcrunch.com The username and password is the same as your MyStatLab account where your homework is located. (If you can’t click on the yellow “Open StatCrunch” button, try using the https://www.statcrunch.com/app/index.php ) If you were successful in getting StatCrunch open, please select YES below.
Read DetailsAs a new GM, you want to set a goal to achieve a 3.1% increa…
As a new GM, you want to set a goal to achieve a 3.1% increase in hotel’s Total Revenues for the upcoming accounting period. Other goals set to control expenses based on the sales estimate are shown below. Complete budgeting on the table below by filling out cells highlighted in yellow with MS Excel formulas. HFT4464 Spring2024 Online Makeup Exam2 Upload.xlsx
Read DetailsThe 160-room hotel, at 1001 Southwest Second Avenue, is owne…
The 160-room hotel, at 1001 Southwest Second Avenue, is owned by the entity Mary Brickell Village Hotel LLC, which is managed by Villar, president of Miami-based Sunview Companies. Completed in 2013, the hotel has assets totaling $34 million including Land and Building values of $12 and $15 million respectively. The remaining was Current Assets including $75,000 worth of Inventories. There was $16 million in Long-Term Liabilities in addition to $2 million in Account Payable. At the end of accounting period as the Balance Sheet was prepared, the hotel obtained a $153,000 EBITDA. Based on the statement above, build a simple balance sheet on a MS Excel spreadsheet and perform ratio analyses. Liquidity Ratios Current Ratio Quick Ratio Working Capital Solvency Ratios Debt to Equity Ratio Debt to EBITDA Ratio
Read DetailsThe table below is the results of rooms department operation…
The table below is the results of rooms department operations for the past year. Management wants to measure the costs so as to identify ways to reduce. Calculate the following cost per room sold. Show your work of calculations.
Read DetailsAs of November, your hotel is going through a typical low se…
As of November, your hotel is going through a typical low season. Thus, GM is considering to drive room night demand by lowering current ADR and asking you to perform a Price Elasticity of Demand analysis so that he/she can make an informed decision. Build a spreadsheet that shows the results of Price Elasticity of Demand based on the information provided below. To better assist with the GM to make an optimal decision for projected higher bottom line, Expected GOP should be determined along with Estimated Rooms Revenue and Total Direct Expenses. Assume that your Direct Expenses Per Occupied Room is $19. 23. Based on the results, draft a short passage highlighting the results. *** *** Your work of calculations on the spreadsheet should be made with MS Excel formulas and corresponding cells. Any changes made in prediction should be reflected on the results. Please be noted that simply typing numbers as text won’t be awarded any points. Current ADR Demand New ADR Being Considered Historical Demand $123 190 $96 234
Read DetailsYour are a Assistant Restaurant Manager and have been recent…
Your are a Assistant Restaurant Manager and have been recently hired to assist GM to run the restaurant more efficiently. As shown below, you are setting goals to bring 3.1% more Total Sales. Also, you set the goals to have Beverage Sales to contribute 27% of Total Sales. Other goals that you set were 34, 29.5, 43, and 19.30% respectively. Complete the budget spreadsheet below by filling out yellow-highlighted cells. Your work of calculations on the spreadsheet should be made with MS Excel formulas and corresponding cells. Any changes made in prediction should be reflected on the results. Please be noted that simply typing numbers as text won’t be awarded any points. Download the file below and complete budgeting by Horizontal and Vertical Analysis technique. Financial Analysis Budgetring.xlsx
Read Details