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
Answer is given below
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...
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...
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 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...
Can you please help with
section D? Thank you!
Delsing Canning Company is considering an expansion of its facilities. Its current income statement is as follows: $ 6,800,000 3,400,000 1,980,000 $ 1,420,000 Sales Variable costs (50% of sales) Fixed costs Earnings before interest and taxes (EBIT) Interest (10% cost) Earnings before taxes (EBT) Tax (30%) 560,000 860,000 258,000 Earnings after taxes (EAT) 24 602,000 Shares of common stock 380,000 24 Earnings per share 1.58 The company is currently financed with...
Use the following information to answer question 17 through 19: 17. Doherty & Puthoff, Inc. produces quality BGSU hats for fashion-conscious students. During the year, its highest and lowest production levels occurred in April and October, respectively. In April, it produced 6,000 units at a total cost of $120,000. In October, it produced 2,000 units at a total cost of $80,000. Using the high/low method of estimating costs, the average variable cost of producing a hat would be: a. $10.00...
SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corp. expects to sell 620 sun visors in May and 300 in June. Each visor sells for $20. Shadee's beginning and ending finished goods inventories for May are 80 and 45 units, respectively. Ending finished goods inventory for June will be 55 units. References Section Break SB Exercise E8-5 to E8-10 1.50 points Required information E8-5 Calculating Sales and Production Budgets (LO 8-3a, b] Required:...
2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: А B с 1 Chapter 2: Applying Excel Cost summary for Job 408 2 3 4 5 Machine-hours Direct labor hours Direct materials cost Direct labor cost Department Milling Assembly 70 2 5 40 880$ 440 95 $ 640...
Blooper’s analysts have come up with the following revised
estimates for its magnoosium mine:
Range
Pessimistic
Optimistic
Initial investment
+
30
%
–
25
%
Revenues
–
25
%
+
20
%
Variable costs
+
25
%
–
15
%
Fixed cost
+
50
%
–
50
%
Working capital
+
30
%
–
45
%
Conduct a sensitivity analysis for each variable and range and
compute the NPV for each. Use Spreadsheet 10.1 and accompanying
data as a starting...