The owner of a local motel told you to help him set up his budget with the following information:
Its monthly Fixed Cost amount is $120,000, while its Variable Cost is $15 per room sold.
During the slowest month, he will reduce his ADR to $30 to sell 6,000 rooms. However, the Variable Cost per room will not change. Using the information provided, complete the Pro Forma Income Statements (Operating Budget); and provide your answer to the question below.
Slowest month
(6,000 rooms to sell @ lowered ADR of $30)
Vertical Analysis (%)
Revenues: $180,000 XXXXXX
Variable Cost ($15 per room): __(25)___ __(30)___
Contribution Margin: __(26)___ __(31)___
Fixed Cost: $120,000 __(32)___
EBT: __(27)___ XXXXXX
Tax (40%) __(28)___ XXXXXX
Net Income: __(29)___ __(33)___
1. Provide your answer to the amount of (25)
2. Provide your answer to the amount of (26)
3. Provide your answer to the amount of (27).
4. Provide your answer to the amount of ( 28).
5. Provide your answer to the amount of (29).
1. Variable cost = 6,000*$15 = $90,000
2. Contribution margin = $180,000-90,000 = $90,000
3. EBT = $90,000-120,000 = -$30,000
4. Tax = -$30,000*40% = -$12,000
5. Net income = -$30,000-$12,000) = -$42,000
The owner of a local motel told you to help him set up his budget with...
The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost amount is $120,000, while its Variable Cost is $15 per room sold. During the slowest month, he will reduce his ADR to $30 to sell 6,000 rooms. However, the Variable Cost per room will not change. Using the information provided, complete the Pro Forma Income Statements (Operating Budget); and provide your answer to the question below. Slowest...
The manager of a local motel asked you to figure out his cost structure to project his future operations. According to his records, the motel recorded the total costs of $72,000 by selling 7,500 rooms during the busiest month of the past year. During the slowest month, it sold 4,500 rooms at the total costs of $48,000. Based on the given information, please answer the following questions. Find out the motel’s fixed cost amount per month Find out the motel’s...
4) SUMPRODUCT Question 16 (1 point) You own a motel with 115 rooms. Fixed daily cost for Mortgage is 1,054. Other fixed costs (including staff salaries, maintenance) amount to $771 per day. Variable cost per room is $11 per day (includes extra utility cost, room cleanup, etc). Customers pay $78 per room per day. A local company rented all the rooms of the hotel for 26 days for a workshop. What was the profit (or loss) of the hotel during...
Transfer PricingAulman Inc. has a number of divisions including a Furniture Division and a Motel Division. The Motel Division owns and operates a line of budget motels located along major highways. Each year, the Motel Division purchases furniture for the motel rooms. Currently, it purchases a basic dresser from an outside supplier for $50. The manager of the Furniture Division has approached the manager of the Motel Division about selling dressers to the Motel Division. The full product cost of...
Transfer PricingAulman Inc. has a number of divisions, including a Furniture Division and a Motel Division. The Motel Division owns and operates a line of budget motels located along major highways. Each year, the Motel Division purchases furniture for the motel rooms. Currently, it purchases a basic dresser from an outside supplier for $40. The manager of the Furniture Division has approached the manager of the Motel Division about selling dressers to the Motel Division. The full product cost of...
Ouestion 3 Rest & Fun Motel operates a 50-room motel near an amusement park. During September, Rest & Fun experienced a 65% occupancy rate from Monday evening through Thursday evening (weeknights). On Friday through Sunday evenings (weekend nights), however, occupancy increases to 90%. There were 18 weeknights and 12 weekend nights in September. All rooms are similar and Rest & Fun charges RM80 per room per night (room-night). The company recently hired Adam Haikal to manage the motel to increase...
Transfer Pricing Aulman Inc. has a number of divisions including a Furniture Division and a Motel Division. The Motel Division owns and operates a line of budget motels located along major highways. Each year, the Motel Division purchases furniture for the motel rooms. Currently, it purchases a basic dresser from an outside supplier for $50. The manager of the Furniture Division has approached the manager of the Motel Division about selling dressers to the Motel Division. The full product cost...
I'm
wondering how to figure out the two squares that are in red how old
did it come to be that figure if it's right but it still read
sometimes they don't change to white the square but if it's wrong
with the correct answer be on chapter 13 apply what you know
d13
How did it get to that percent under the 10% ADR increase because I
had seen somewhere where it was 3.9% however it still stays read...
Bluebird Entertainment Corporation manufactures and sells video games. Their master budget for the month of November was based on productiorn and sales of 150,000 games. The budget is based on the average selling price and variable cost per video game-e , video game is cost driver for all variable costs).Although they produce and sell various games, once they are designed production costs are essentially the same. The selling price per game varies between $14 and $18, with an average selling...
Using the information given below, provide the answers of the following question. High Point: Activity 8,000 customers Total (Mixed) Costs: $65,000 Low Point: Activity 6,000 customers Total (Mixed) Costs: $56,000 QDetermine Fixed Cost amount when 10,000 customers are served. (Do not put "$" or "" in your answer. If you answer is $1,000.00; then, just put 1000) Using the information given below, provide the answers of the following question High Point: Activity 8,000 customers Total (Mixed) Costs: $65,000 Low Point:...