Question

In: Finance

A resort hotel annual sales revenue of $1,000,000, Variable costs of $350,000, and a fixed costs...

A resort hotel annual sales revenue of $1,000,000, Variable costs of $350,000, and a fixed costs of $570,000. The fixed costs include $80,000 a year for land rental lease.

a) Calculate the hotel's breakeven point.

b) If the owners had an equity investment in the hotel of $1,200,000. What level of sales revenue is required for an operating income (BT) representing a 15% return on their investment?

c). In a renegotiation of the land lease, the landowner has offered management an alternative to the fixed lease currently being paid. The alternative in the lease currently being paid. The alternative is 10% of the resort's contribution margin.

i. If management accepts this proposal, what would be the resort hotel's new breakeven point?

ii. Calculate the indifference point.

iii. Explain whether management should accept this proposal. if next year's total sales revenue is expected to be $1,200,000?

iv. Should management accept this proposal if next's total sales revenue is expected to be $1,400,000

.:PS. I need all the C ( this includes " i " ; " ii " ; " iii " & " iv "

Solutions

Expert Solution

(a)

Breakeven point = Fixed Cost / Gross margin

= $570,000 / 65%

= $876,923.08

Calculation of Gross margin =Gross Margin / Sales (Gross Margin = Sales Revenue - Variable Cost)

= ($1,000,000 - $350,000) / $1,000,000

= $650,000 / $1,000,000

= 65%

(b)

Sales Revenue require to earn 15% = (Fixed cost + Require Income) / Gross Margin

= ($570,000 + $180,000) / 65%

= $750,000 / 65%

= $1,153,846.15

Require Income = $1,200,000 x 15% = $180,000

To earn 15%, Sales revenue required will be $1,153,846.15

(c)

(i) Breakeven point If management accept offer

Breakeven point = Fixed Cost / Gross margin

= $490,000 / 58.5%

= $837,606.84

Fixed cost = $570,000 - Fixed Lease rent = $570,000 - $80,000 = $490,000

Gross Margin = 65% - New lease rent % (10% of gross margin) = 65% - (65% x 10%) = 65% - 6.5% = 58.5%

Break even sales revenue = $837,606.84

(ii) Indiffence point

Indiffernce point is ,when new rent and old rent payment are same i.e. $80,000

Let assume sales revenue is A so rent is 0.065 A ( A x 10% of margin = A x (65% x 10%) = A x 6.5% = 0.065A)

Means new rent = 6.5% of sales revenue

So,

Indifferance point, Old rent = Sales revenue x 6.5%

$80,000 = Sales Revune x 6.5%

Sales Revenue = $80,000 / 6.5%

Sales Revenue = $1,230,769.23

or $80,000 = 0.065A so A= $1,230,769.23

Indifferance point will be $1,230,769.23 sales.

(iii)

If expected sales revenue $1,200,000

Particular Amount
Sales Revenue $        1,200,000
Gross Margin @ 65% $            780,000
Lease rent 10% of Gross Margin $              78,000

If management expcted total sale revenue for next year to be $1,200,000 then advisable to accept the proposal as it decrease the lease rent outflow by $2,000. ($80,000(old) - $78,000(new))

(iv)

If expected sales revenue $1,400,000

Particular Amount
Sales Revenue $        1,400,000
Gross Margin @ 65% $            910,000
Lease rent 10% of Gross Margin $              91,000

If management expcted total sale revenue for next year to be $1,400,000 then advisable to not accept the proposal as it increase the lease rent outflow by $11,000. ($91,000(new) - $80,000(old))

If any help require then comment i will help you.


Related Solutions

Total sales revenue is $1000, total variable costs are $600 and total fixed costs are $1000....
Total sales revenue is $1000, total variable costs are $600 and total fixed costs are $1000. The price is $10 per unit. Compute the break-even volume in units (assume that the break-even point is in the relevant range). A) 166.7 units B) 250 units C) 280 units D) 2500 units Beta company allocates fixed overhead costs based on direct labor dollars, with an allocation rate of $5 per DL$. Beta sells 1000 units of product X per month at a...
Estimated annual sales: $540,000 Annual variable costs: $144,000 Estimated life: 3 years Annual fixed costs: $60,000...
Estimated annual sales: $540,000 Annual variable costs: $144,000 Estimated life: 3 years Annual fixed costs: $60,000 Initial equipment cost (100% depreciated over 3-year life): $144,000 Initial investment in NWC (to be re-covered in year 3): $30,000 Tax rate: 25% What is the firm’s annual Operating Cash Flow (OCF) for this project ($)? What is the CFFA in year 3 ($)?Using the CFFA figures that you calculated, what is the NPV for this project if the required return is 11% ($)?
HASF Corporation has fixed costs of 1,000,000 variable costs of50 per units and a contribution...
HASF Corporation has fixed costs of 1,000,000 variable costs of 50 per units and a contribution margin ratio of 40% and no of units sold 20,000 Required: Compute the following                                                                                   Units sales price and unit’s contribution margin for the above...
You are the revenue manager of a 200-room hotel in Memphis. The management controllable costs (variable...
You are the revenue manager of a 200-room hotel in Memphis. The management controllable costs (variable room costs) incurred when selling 1 room are $50. You are interested in evaluating hotel performance for two scenarios: fixed pricing and differential pricing. Scenario one is that you used a fixed pricing strategy: at a selling pricing $200 per night your hotel would sell 150 rooms on a given day. Scenario two is that you implement a three-price strategy: low rate $150 per...
Food sales $                 950,000 Other revenue 5% of total revenue Expenses: Fixed Variable* Labor $         
Food sales $                 950,000 Other revenue 5% of total revenue Expenses: Fixed Variable* Labor $                 100,000 10% Cost of sales $                            - 35% Supplies $                            - 5% Energy $                   12,000 3% Marketing $                     5,000 4% Maintenance $                   12,000 2% Property taxes $                     4,000 Depreciation $                   15,000 Property insurance $                     5,000 Rent $                     3,500 * As a percentage of food sales. The Robinson Diner, managed by Ina Fay, needs your assistance in preparing its 20X8 operating budget. Since the diner is a sole proprietorship, it will not pay income taxes. Information is...
A project currently generates sales of $9million, variable costs equal 40% of sales, and fixed costs...
A project currently generates sales of $9million, variable costs equal 40% of sales, and fixed costs are $1.8 million. The firm’s tax rate is 30%. Assume all sales and expenses are cash items. a. What are the effects on cash flow if sales increase from $9million to $9.9m? (Input the amount as positive value. Enter answer in dollars not millions) b. What are the effects on cash flow if variable costs increase to 55% of sales? (Input amount as a...
The selling price, variable costs, annual fixed costs, annual depreciation charges, and marginal tax rate for...
The selling price, variable costs, annual fixed costs, annual depreciation charges, and marginal tax rate for the project are shown below.  If sales are equal to 14,000 units, what is the after-tax profit? Sales Price $3.00 Variable Costs $1.40 Fixed Costs $15,000.00 Depreciation $6,000.00 Tax Rate 35% A mesquite farmer wants you to invest in his mesquite harvesting business.  He sells mesquite wood to several "Texas-style" steakhouses that serve authentic "Mesquite-smoked" steaks.  He promises to give you all profits for 5 years after...
AD Company estimates that variable costs will be 70% of sales and fixed costs will total...
AD Company estimates that variable costs will be 70% of sales and fixed costs will total $1,800,000. The selling price of the product is $10, and 700,000 units will be sold. Instructions: Using the mathematical equation (a) Compute the break-even point in units and dollars.               (b) Compute the margin of safety in dollars and as a ratio.         (c) Compute net income.                                                             
Hamood Plumbing Co. estimates that variable costs will be 70% of sales and fixed costs will...
Hamood Plumbing Co. estimates that variable costs will be 70% of sales and fixed costs will total OMR 2,160,000. The selling price of the product is OMR 10, and 750,000 units will be sold. Instructions Using the mathematical equation, (a) Compute the break-even point in units and Omani Riyals. (b) Compute the margin of safety in Riyals and as a ratio. (c) Compute net income. Problem 2 Ibri, Inc. owns a machine that produces baskets for the gift packages the...
Glacial Company estimates that variable costs will be 63.2% of sales, and fixed costs will total...
Glacial Company estimates that variable costs will be 63.2% of sales, and fixed costs will total $655,000. The selling price of the product is $3.90. Compute the break-even point in (1) units and (2) dollars. a. Break even sales __ units b. Break even sales __ $$ Assuming actual sales are $2,115,000, compute the margin of safety in (1) dollars and (2) as a ratio. a. Margin of safety __ $$ b. Margin of safety ratio (as percentage)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT