The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost...

Question

Question

The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost...

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)___

Provide your answer to the vertical analysis % of (30)

Provide your answer to the vertical analysis % of (31)

Provide your answer to the vertical analysis % of (32) rounded to the first decimal of the percentage

Provide your answer to the vertical analysis % of (33) rounded to the first decimal of the percentage

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Answer is given below

Vertical analysis of (30) 50% Vertical analysis of (31) 50% Vertical analysis of (32) 66.7% Vertical analysis of (33) - 11.7%

Add a comment

Answer 2

Similar Homework Help Questions

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...

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...

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...

Using the information given below, provide the answers of the following question. High Point: Activity 8,000...

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:...
help with the following pls and excel 1 Saved Help Sev Required information Chapter 5: Applying...

help with the following pls and excel 1 Saved Help Sev Required information Chapter 5: Applying Excel The Chapter 5 Form worksheet is to be used to create your own worksheet version of the Review Problem example in the text. Chapter 5: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "=85". After entering formulas in all of...
1. Cost-Volume Profit Analysis Recline Company is planning to produce and sell 12,500 units of its...

1. Cost-Volume Profit Analysis Recline Company is planning to produce and sell 12,500 units of its only product at a unit price of $100. At this sales level Recline Company will generate $400,000 in total contribution margin and incur fixed costs of $25/unit. a. Calculate Recline’s contribution margin ratio. Round answer to the nearest whole percentage (ex: 0.3456 = 35%) __________% b. Calculate the break-even point in sales dollars for Recline. Use your rounded answer from part a. above and then round...

Little Annin Flagmakers Cost of Goods Sold Budget (USD) Cost of Goods Sold (FIFO) Units Cost/unit...

Little Annin Flagmakers Cost of Goods Sold Budget (USD) Cost of Goods Sold (FIFO) Units Cost/unit Total Cost Beg. FG inventory Add: Cost of Goods Mfg'd Good Available for Sale Less: Ending FG inventory Cost of Good Sold Little Annin Flagmakers Selling and Administrative Expense Budget (USD) April May June Quarter Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Little Annin Flagmakers Cash Budget (USD) April May...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process.

SalesUnit sales for November 2019114,000Unit sales for December 2019103,000Expected unit sales for January 2020114,000Expected unit sales for February 2020111,000Expected unit sales for March 2020116,000Expected unit sales for April 2020125,000Expected unit sales for May 2020136,000Unit selling price$12Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts...
[The following information applies to the questions displayed below.] Shadee Corp. expects to sell 630 sun...

[The following information applies to the questions displayed below.] Shadee Corp. expects to sell 630 sun visors in May and 440 in June. Each visor sells for $15. Shadee's beginning and ending finished goods inventories for May are 75 and 40 units, respectively. Ending finished goods inventory for June will be 60 units. Each visor requires a total of $5.00 in direct materials that includes an adjustable closure that the company purchases from a supplier at a cost of $1.50...

Problem 1 Assume that a radiologist group practice has the following cost structure: Fixed costs $500,000...

Problem 1 Assume that a radiologist group practice has the following cost structure: Fixed costs $500,000 Variable cost per procedure $25 Charge (price) per procedure $100 Furthermore, assume that the group expects to perform 7,500 procedures in the coming year. Part A a. Construct the group’s base case projected P&L statement. (See exhibit 5-5). P & L Statement Revenue 750,000 (100 x 7500) Variable Costs -187,500 (25 x 2500) Contribution 562,500 Fixed Costs -500,000 Net income/profit 62,500 b. What is...

The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost...

Homework Answers

Add Answer to:
The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost...

Post as a guest

Earn Coins