Calculate a budgeted contributory income statement

Assignment Help Engineering Mathematics

Reference no: EM131507650

Question: 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 turnovers 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 sales revenue. Indirect costs for the motel are estimated at $580,800 for next year.

a. Calculate a 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 sales revenue was based on 21,700 rooms occupied at an average room rate of $68.40. Actual housekeeping wages (before employee fringe benefits) were $108,208. Analyze rooms sales 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 occupied (sold).

Reference no: EM131507650

Questions Cloud

Write narratives to develop real or imagined experiences : Write narratives to develop real or imagined experiences or events using effective technique, well-chose details, and well-structured event sequences.

Two types of consumers : Consider a monopolist that has two types of consumers. The first, students have a demand curve given by the following: QA=120-2P.

Calculate the budgeted payroll cost for the given function : Budgeted liquor sales revenue at a banquet were 1,500 drinks at $5.00 each. Actual sales were 1,550 drinks at $4.80 each. Determine the price and sales volume.

The process of litigation particular to hypothetical case : Provide an assessment of the strengths and weaknesses of the client's case.Describe the process of litigation particular to the hypothetical case.

Calculate a budgeted contributory income statement : 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.

Internal and external drivers of change in organizations : Discuss internal and external drivers of change in organizations today. How can HRMs and practitioners help organizations navigate.

How the ninth circuit defines the tort : How the Ninth Circuit defines the tort?What elements must be proven to state a case?What defenses are available to the employer?

What additional activities you would add to the project : Assignment: Greendale Project ReDux- What additional activities you would add to this project to make it more complete, from a project management viewpoint?

Calculate the budgeted dining room revenue : A resort hotel has a dining room that has no business from street trade; it is dependent solely on the occupancy of its rooms for its sales revenue.

User Account

All Pages