Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with my accounting excel homework; I am stuck The top left excel screen shot if where you start in the first worksheet

I need help with my accounting excel homework; I am stuck
The top left excel screen shot if where you start in the first worksheet called Hotel Operating Costs tab
Prompt:
Welcome to the case study of our newly opened upscale hotel. This luxurious property boasts state-of-the-art amenities, elegant design, and a prime location. As part of understanding the financial aspects of hotel management, you are provided with a table listing various costs associated with the operation of this hotel.
Instructions:
1. Determine the Cost's Behavior: For each cost listed in the table, use the dropdown menu to identify whether it is a fixed, variable, or mixed cost based on its nature and how it is expected to behave relative to hotel occupancy levels.
2. Enter the Dollar Value: Input the estimated dollar value for each cost.
3. Identify the Cost Frequency: Use the drop down menu to determine whether each cost is incurred per month or per room.
4. Formatting for Financial Analysis: Format the Dollar Amount column in a way that is easy to read and suitable for financial analysis. This could include aligning all figures to the right, ensuring consistent decimal places, and using commas for thousands
The bottome left is the second worksheet called Maintenance & Repairs Detail Tab
1 Use the min and max formulas to find the high and low levels of activity in th table.
Note: you have to determine whether to search the cost ($) column or the rooms serviced column.
______ Low Point
_____High Point
2 Highlight the 2 rows that have the high and low data point in the table.
3 Use the high-low method to separate the variable and fixed costs:
Step 1: Find variable cost per unit ______ per room serviced
Step 2: Find average fixed costs per month
Using the high point: ______ FC per month
Using the low point: ______ FC per month
4"Go back to the Hotel Operating Costs tab and fill in the VC per unit and FC per month for Maintenance and repairs.
You will need to use the final line on the table. One row for fixed costs. The other row for variable costs."
The bottom right excel worksheet which is the last step is call Breakeven Analysis
Asks you to calculate your findings from the previous tabs
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Routledge Handbook Of Environmental Accounting

Authors: Jan Bebbington, Carlos Larrinaga, Brendan O'Dwyer, Ian Thomson

1st Edition

0367724901, 9780367724900

More Books

Students also viewed these Accounting questions