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

  Discount rate being used will equal the projects irr

Explain the following statement: “When the NPV of a project = $0, the discount rate being used will equal the project’s IRR.” Use math to explain your answer. Hint: Equations 10-1 and 10-2 may help with the math.

  How much was earned in interest on interest

A savings account, which started with a balance of $500, has the following end of year balances: Year 1 = $550; Year 2 = $580; Year 3 = $660; Year 4 = $772; Year 5 = $950. No withdrawals were made over the life of the account, but there was one addit..

  Call option using the black scholes option pricing model

You are given the following information. S=50, X=59, simple annual risk free interest rate is 5%, standard deviation of monthly stock returns is 10%. What is the value of a one year European call option using the black scholes option pricing model? A..

  Personal loan officer at first national bank

Abagail Nelson, a 25-year-old personal loan officer at First National Bank- How much will she have accumulated when she turns 65 if she invests in equities and earns 8 percent on average?

  Efficient market hypothesis

Provide a description of the three forms of the Efficient Market Hypothesis using the picture below.  Do you think the markets are efficient?

  Equivalent real cash flow and real discount rate

Mr. Art Deco will be paid $100,000 one year hence. This is a nominal flow, which he discounts at an 8% nominal discount rate: PV = 100,000 = $ 92,593 1.08 The inflation rate is 4%. Calculate the PV of Mr. Deco’s payment using the equivalent real cash..

  New issue of preferred stock it calls

E-Eyes.com has a new issue of preferred stock it calls 20/20 preferred. The stock will pay a $20 dividend per year, but the first dividend will not be paid until 20 years from today. If you require a 9.25 percent return on this stock, how much should..

  What is net income for the period

If a company has cash flow from operations of $3 million, depreciation and amortization of $2 million, and its working capital accounts did not change from the previous period, what its net income for this period ?

  Net present value-pretax cost of debt-cost of equity

Granite Graphics has a pretax cost of debt of 7.68 percent and a cost of equity of 15.2 percent. The firm uses the subjective approach to determine project discount rates. The project has an initial cost of $4.3 million and produces cash inflows of $..

  Spontaneous source of financing

Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's inventory. Make the following assumptions: current year's sales are $27,800,000; current year's cost of goods sold is $17,528,00..

  About the experiencing rapid growth

Navel County Choppers Inc. is experiencing rapid growth. The company expects dividends to grow at 16 percent per year for the next 8 years before leveling off at 6 percent into perpetuity. The required return on the company’s stock is 15 percent.

  What would be the net cash flow from above activities

What would be the net cash flow from above activities? Dividend income received by a corporation. Which of the following as a business entity pays federal income tax?

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