Wage Cost Percentage.

This measure compares wage cost in dollars to revenue produced in dollars. It measures the dollar cost in wages incurred with respect to revenue level resulting from rooms sold or meals served. Wage cost percentages include;

Front office wage cost. Total front office wage cost in dollars divided by total room revenue in dollars. Washington Hilton has 20 employees working at the front office. Expected room revenue per day is $60,000. Total front office wages are 20*8*10=1600. Percentage equals; (1600/60,000) %= 26.67%. This is within the acceptable level as the hotel’s guidelines stipulate that this percentage should not exceed 30%

Wage cost per occupied room. The formula entails two steps. First, labor hours used is multiplied by hourly wage rate to give the wage cost in dollars. Second, the amount calculated is divided by the rooms occupied. In the case of Washington Hilton, labor hours used are 1,600 (200*8), the hourly wage rate is $10. The rooms occupied are 600. The wage cost per occupied room will therefore be $26.67.

Housekeeping wage cost. Calculated by dividing total housekeeping wages cost by total rooms revenue. Washington Hilton wages are $6,400 while the revenue is $60,000. (6400/60,000)=10.67%

Restaurant wage cost. Calculated by dividing total restaurant wage cost in dollars by total restaurant revenue in dollars. Washington Hilton has 100 employees working at the restaurant. Their total wage cost is $8,000(100*8*10), while the restaurant revenue is $20,000(400*50).

The percentage equals (8,000/20,000) is 40%. Thought the percentage appears high, it is within acceptable limits as most of the meals are sold to customers, who are staying in the hotel. The cost of food for such customers is subsidized to ensure they utilize the hotel’s restaurant.

Labor productivities are best measured with the above probabilities as they just measure labor input with labor output. They indicate how well labor wages are managed.

Weekly Internal Management Reports.

Information from these reports reviews and criticizes previous week’s performance. They are also used to forecast for the following week. Operations in hotels are planned for on weekly basis and therefore these reports are the primary documents of control by managers in the various departments.

Weekly Revenue Forecast-It is a detailed day by day forecast for the upcoming week expected revenue.

Weekly Wage and Cost Scheduling- Expected revenue determines the labor force required. Washington Hilton determines the labor requirement for the coming week on all Wednesdays. By correctly using the ratios above, management is able to accurately plan for the labor requirements in future.

Profitability forecasting- Profit are calculated by subtracting total expenditure from total revenue. Forecasted profits are calculated by subtracting forecasted expenses from forecasted income.

Monthly Internal Management Reports.

Having collected daily and weekly reports, the information content is enough to prepare monthly profit and loss statements.

Monthly P&L Statement-It’s a useful management tool since it shows the financial results of the operational performance for the month. The P&L attracts the greatest scrutiny among all financial statements. Management must therefore take great care to ensure that they report acceptable, fair and accurate P&Ls. The monthly consolidated P&L provides a detailed summary of every department’s revenues and expenses. The P&L presents the big picture of the hotel’s performance. P&Ls are required to enable the user to compare the present period with the past. As accountants prepare the statement, they have to include past period performance. The P&L also identifies departments that are performing and those underperforming. This is an important indicator to top level management as it identifies managers who are effective and efficient.

Sample Departmental P&L for Washington Hilton.

Washington Hilton,

Monthly Profit and Loss Statement,

For the Month of December 2013.

The forecasted revenue for the Rooms Department was $1,860,000.Expected departmental profits were at $978,000. The forecasted profit percentage is 52.58%, which means that 0.526 cents out of every revenue dollar will be profit. Actual Room Revenue was $1,900,000 which is $40,000 more than the forecasted revenue. The percentage increase of the $40,000 incremental revenue is 2.15% ($40,000/$1,860,000). In other words, revenues were 2.15% higher than forecast.

P&L Statement; up to November 30^th 2013.

In the month of December 2013, Washington Hilton recorded an average of 600clients daily who spent the night at their rooms. The charge per night is $100. The restaurant registered a daily average sale of 400 meals. Each meal was sold at $50. During the month, the number of employee/casuals was 200, each working 8 hours a day at a rate of $10 per hour. The consolidated monthly profit and loss statement was as follows;

General and administrative expenses include system maintenance costs, commissions and travel allowances of top-level managers. They actual cost and the budgeted cost are the same as Washington Hilton has adopted a policy to check on the variance of these costs.

Heat, Light &Power- The actual cost was higher than the budgeted cost owing to increased room and restaurant revenue. This cost is determined by the government as it provides electricity which powers Washington Hilton. The December bill was determined by the power supplier.

Repairs and maintenance. The cost is determined by past trends. In the month of December the cost was slightly higher than the budget. As from June 2013, Washington Hilton adopted outsourcing of repair and maintenance services to enhance efficiency. The company has seen great improvements since Smart Repairs undertook the responsibility of repairs and maintenance in the hotel. The actual amount indicated is the bill received from Smart Repairs.

Accident Expense. Minor accidents are common in hotels; however, the hotel loses money if the accidents are rampant. In the month of December, accidents reported, treated and billed to Hilton cost the hotel $2,500. Individuals who are involved in accidents in the hotel are treated at Washington Hospital, which is a five-minute drive from the hotel. The hospital sends a monthly bill for payment by 15^th of the following month.

Training Expense. Hotel business depends highly on economic conditions. Washington Hilton therefore hires and dismisses casuals depending on the number of clients visiting the hotel. This attracts training costs, which must be incurred every time the hotel hires new employees. The hotel employed an additional 50 employees in anticipation of the Christmas period. The cost of training these new personnel was $3,000. This was $200 more than management expected.

Sales and Marketing. To ensure that the hotel remains competitive, management sets aside some amount for promotion. In the month of December, the hotel paid $2,000 for a TV advert on CNN. The $1,000 was spent on online marketing.

General Ledger Transactions for the above Revenues and Expenses.

1. To record Room Revenue Earned in Dec;

DR Bank A/c 1,900,000

CR Room revenue Income A/c 1,900,000

2. To record Restaurant Revenue Earned in Dec;

DR Bank A/c 650,000

CR Restaurant Revenue Income A/c 650,000

3. To record General and Admin Expenses in Dec.

DR General&Admin Expenses A/c 150,000

CR Bank A/c 150,000

4. To record Heat Light & Power Expense incurred in Dec.

DR Heat, Light & Power 8,000

CR Bank A/c 8,000.

5. To record Repairs & Maintenance Expense incurred in Dec

DR Repairs & Maintenance A/c 5,000

CR Bank A/c 5,000

6. To record Accident Expense incurred in Dec

DR Accident A/c 2,500

CR Bank A/c 2,500

7. To record Training Expense incurred in Dec

DR Training A/c 3,000

CR Bank A/c 3,000

8. To record sales & marketing Expense incurred in Dec

DR Sales & Marketing A/c 3,000

CR Bank 3,000

9. To record National sales &marketing Expense in Dec

DR National Sales & Marketing A/c 1,500

CR Bank 1,500

Date: 2015-01-12; view: 2170