The purpose of this financial report is to examine a low-cost hotel in Colorado and to comprehend the environment in which it functions. The goal of this financial report is to help you comprehend financial statements, cost allocations, absorbing costs, and budgeting. The project will contain numerous parts for examining the budget hotel in Colorado based on your comprehension of these topics. To begin, the author wishes to comprehend the outlook of the business climate based on the hotel’s financial numbers. To that aim, the author will examine travel trends in Colorado and attempt to comprehend the causes behind the data shown in the case study over the last three years. This task is separated into three major pieces. The first stage in this assignment is to enter data into the Excel sheet so that the author may easily examine it.
The first component of this financial report will be based on the cost allocations theory. The author begins by identifying the different types of fixed and variable expenses for the cost allocation concept. Because the hotel is low-priced, there is just one cost driver: the number of rooms booked. The cost objects are the departments that function in the hotel and have fixed and variable cost heads attached to them.
The CVP analysis, often known as the Cost,Volume, Profit analysis, is the second element of this assignment. The CVP analysis is used by businesses to analyze how changes in variable and fixed expenses may influence a company’s earnings. The second reason for conducting a CVP analysis in this report is to establish the number of break-even numbers in FY 2018 to identify the number of units required to break even on expenses.