Analyze room revenue for price and sales volume

Assignment Help Financial Management
Reference no: EM131339650

An 80-room motel forecasts its average room rate to be $68.00 for next year at 75% occupancy. The rooms department has a fixed wage cost of $186,000. Variable wage cost for housekeeping is $9.00 an hour; it takes one-half hour to clean a room. Fringe benefits are 18% of total wages. Linen, laundry, supplies, and other direct costs are $2.75 per occupied room per day. The motel also has a 50-seat, limited-menu snack bar. Breakfast revenue is derived solely from customers staying overnight in the motel. On average, 40% of occupied rooms are occupied by two persons and, on average, 80% of overnight guests will eat breakfast. Average breakfast check is $6.50. Lunch seat turnover is 1.5, with an average check of $8.95. The average dinner check is $10.95 and there are 2.0 seat turns for dinner. The snack bar is open 365 days a year for all three meals. Direct costs for the snack bar are 78% of total snack bar revenue. Indirect costs for the motel are estimated at $580,800 for next year. a. Calculate the budgeted contributory income statement for each department and a consolidated total motel departmental income statement to determine operating income. b. Assume that at the end of next year, actual revenue was on 21,700 rooms occupied at an average rate of $68.40; actual housekeeping wages (before employee fringe benefits) were $108,208. Analyze room revenue for price and sales volume variances and housekeeping wages for cost, quantity, and sales volume variances; assume it took 32 minutes to clean each room actually occupied (sold).

Reference no: EM131339650

Questions Cloud

What is the real risk-free rate of return on apple bonds : You are considering an investment in 30-year bonds issued by Apple. One-year T-bills are currently earning 2.2% and inflation has been 1.5%. Bloomberg Finance shows the current information for Apple bonds: What is the real risk-free rate of return on..
How much money will be in account after you made payment : You plan to buy a house in 8 years. You want to save money for a down payment on the new house. You are able to place $183 every month at the end of the month into a savings account at an annual rate of 9.39 percent, compounded monthly. How much mone..
What is bond nominal yield to call : Vidal Corporation has a bond outstanding with 15 years to maturity, an 8.25% nominal coupon, semiannual payments, and a $1,000 par value. The bond has a 6.50% nominal yield to maturity, but it can be called in 6 years at a price of $1, 120. What is t..
Company stock has required rate of return : Ramos Company's stock has a required rate of return of 11.50%, and it sells for $25.00 per share. Goode's dividend is expected to grow at a constant rate of 7.00%. What was the last dividend, D_0?
Analyze room revenue for price and sales volume : An 80-room motel forecasts its average room rate to be $68.00 for next year at 75% occupancy. The rooms department has a fixed wage cost of $186,000. Variable wage cost for housekeeping is $9.00 an hour; it takes one-half hour to clean a room. Analyz..
How much should you pay to purchase the bond : If you knew a bond would pay you $50 every year for 10 years and, at the end of the 10 years, you’d also receive a $1,000 payment, how much should you pay to purchase the bond? If an investor planned to put aside $30 per month for the next 20 years, ..
Firm cash flow statement for the year just ended : Statement of Cash Flows You have just been hired as a financial analyst for Basel Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's..
Investors expect the dividend-what is current price of stock : Phillips, Inc. just paid a dividend of $3.25 per share on its common stock (that is, D0 = 3.25). Investors expect the dividend to grow at 50% in years 1 and 2, they expect the dividend to grow at 20% in year 3 and they expect that all future dividend..
Stock market value is about to drop : If you knew a bond would pay you $50 every year for 10 years and, at the end of the 10 years, you’d also receive a $1,000 payment, how much should you pay to purchase the bond? Assume similar bonds yield 8 percent, and select the value closest to the..

Reviews

Write a Review

Financial Management Questions & Answers

  Willing to pay as a lump sum today to buy this annuity

The Good Life Insurance Co. wants to sell you an annuity which will pay you $770 per quarter for 25 years. You want to earn a minimum rate of return of 6.2 percent. What is the most you are willing to pay as a lump sum today to buy this annuity?

  Banking system and the federal reserve system

Create a diagram of the U.S. banking system and the Federal Reserve System. Include special financial services of the banking system in your diagram. Be creative in this activity. Pretend you have been asked to teach the structure and interrelationsh..

  Different’ target group

Which celebrity would you use to endorse Diet Pepsi in attempts to reach a ‘different’ target group? Who might you use for regular Pepsi? Diet Coke? Coke Classic? Sprite? Explain and justify your choice for each.

  What is the present value

What is the present value of $3,525 per year, at a discount rate of 10 percent, if the first payment is received 7 years from now and the last payment is received 25 years from now?

  How many years until the bond matures

Beam inc bonds are trading today at $470.01. the bond pays annual coupons with a coupon rate of 2.5% and the next coupon is due in 1 year. the bond has a yield to maturity of 7.83%. how many years until the bond matures?? round to nearest whole numbe..

  What is the accounting operating profit break-even point

Mexmagnet is introducing a new game system that promises to never become outdated. Mexmagnet will sell the systems for $225, and it will accrue $150 in variable costs to produce. If cash fixed expenses are $30 million per year and the depreciation an..

  What is the net profit and loss of the options

What is the net profit/loss of the following options? A call option written on FB has an exercise price of $60 with a premium of $5. Currently FB is trading at $70 per share. A call option written on BAC has an exercise price of $20 with a premium of..

  Calculate the next payment each party makes

Consider a currency swap for $10 million and SF15 million.- The current period has 181 days. Calculate the next payment each party makes.

  What is the best estimate of the price

What is the best estimate of the price (in CHF) you can recommend that management charge if it wants to just cover its costs and profit objectives?

  Trading activities performed by financial institutions

A U.S. bank has made £50 million in Britain and has £40 in deposits. The bank's currency trading desk has also contracted to buy £20 million and has short positions of £15 million. What is the bank's net exposure? If the bank has exposures in euros a..

  What is the expected percentage growth rate in copper prices

The market price of risk for copper is 0.5, the volatility of copper prices is 20% per annum, the spot price is 80 cents per pound, and the 6-month futures price is 75 cents per pound. What is the expected percentage growth rate in copper prices o..

  Standard deviation-create your optimal complete portfolio

Stock A has a standard deviation equal to 20% and an expected return of 11%. Stock B has a standard deviation equal to 25% and an expected return of 14%. The correlation coefficient of the returns on Stock A and Stock B is 50%. How much must you inve..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd