Reference no: EM131178674
1. Compute the projected revenue level for July using a four-month moving average and the following sales data
•January $180,000
•February $220,000
•March $230,000
•April $200,000
•May $250,000
•June $280,000
A motel has an occupancy rate of 75%, with 260 rooms available per day. At an ARR of $68; forecast room revenue for the month using 30 days.
2. Compute the variable cost per unit and the fixed cost per month for the semi-variable expense based on the information provided using the high-low method
Month Volume Labor Cost
1 1500 $280
2 1280 $220
3 2500 $380
4 1750 $310
5 1250 $230
3. Use the weighted average to compute the average room rate from the following information:
Rooms Rate
Single 45 $65.00
Double 55 $85.00
Suite 15 $125.00
4. Use the following information
•Sales = $537,000
•Average Guest Check = $18.75
•Food Cost Percent = 35.0%
•IBIT = $150,000
Calculate Break-even point
5. Complete the in/off season analysis for the following information
Last Year In-Season Off-Season If Closed
(12 months) (9 months) (3 months) off-season
Sales $400,000 $300,000
VC $300,000
CM $100,000
FC $ 60,000
IBIT $ 40,000
6. Use the CVP analysis method to calculate sales revenue required to achieve an IBIT of $75,000 with the following forecast data: Sales Forecast = $373,000
Variable costs = $167,000
Fixed costs = $103,000
7. Determine sales required to achieve an IBIT objective of $75,000
8. Calculate the payback period for the following project. Use straight-line depreciation.
•Purchase of equipment $100,000
•Annual Savings $30,000
•Depreciable life of asset 5 years
•Salvage value 0
9. Use the following information to determine the cause of sales variances:
•Budget Actual Variance
•Room Sales 463,500 516,750
Information from managers budget working papers
•Rooms: 4,500
•Average room rate: $103.00
Current months statistics from the accounting department
•Rooms: 5,300
•Average room rate: $97.50
Provide a series of flexible budgets giving Sales, Variable Costs, Fixed Costs and Net Income for the year for estimated sales levels of 1000, 1500, and 2000 units; using fixed costs of $3,000 and variable costs per unit of $3.00 assuming a sales price per unit of $5.25
Unit Sales 1000 1500 2000
Sales Dollars
Variable Costs
Fixed Cost
IBIT
|
Find the sustainable and internal growth rates for a firm
: Find the sustainable growth rates for a firm and Find the internal growth rates for a firm.
|
|
Calculate a trimmed mean
: How many data points should be removed from each end of a sample of 300 values in order to calculate a 10% trimmed mean?
|
|
Identify most significant problems with the way foreign aid
: Based on the lecture and Webtext materials, address the following: Identify the most significant problems with the way foreign aid is presently dispensed by international lending institutions.
|
|
Least cost deployment of manned and unmanned assets
: You need to find the least cost deployment of manned and unmanned assets to do the job. Define the initial equations for the linear programming problem (you don't need to solve them, but if you can it will help me alot) Use x = # of helicopters, y =..
|
|
Calculate break even point
: Calculate Break-even point. - Compute the variable cost per unit and the fixed cost per month for the semi-variable expense based on the information provided using the high-low method.
|
|
Do volunteers deserve the board attention
: If organizations are smart they would use these volunteers as conduits to gain valuable insight and knowledge of the stakeholders needs. These people are volunteers that have no vested interest in an organization, so stakeholders might be more wi..
|
|
Find a recurrence relation for the tower
: Let tn be the number of ways to construct a tower of height n cm using blocks from the set. (Assume an unlimited supply of blocks of each size.) Find a recurrence relation for t1, t2, t3,....
|
|
Computing the area of triangle pqr
: The line 5y-3x+1 meets the hyperbola x2-3y2=1 at P and at Q. The tangent at P and Q meet at R. Find the coordinate of P; Q ;R. The area of triangle PQR.
|
|
Address to let all employee know about company special event
: You need to let all employees know about a company special event. You hear from a friend that a client is about to sign a contract with one of your present competitors.
|