- signup
Login

Login to Your Account
Remember Password

Solution Posted by

- Requests: 0
- Solutions: 251

Solution Detail

Price: $10.00

- From: Business, Management
- Posted on: Wed 22 Apr, 2015
- Request id: None
- Purchased: 0 time(s)
- Average Rating: No rating

Request Description

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
2. 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.
3. 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
4. If menu prices increase by 5% next year and volume increases by 8% beginning January 1st, forecast sales for the first 6 months
Month?Sales?Price Increase?Volume increase = Budget
January?35,000
February?38,000
March?44,500
April?32,500
May?48,000
June?46,000
5. 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
6. Use the following information
Sales = $537,000
Average Guest Check = $18.75
Food Cost Percent = 35.0%
IBIT = $150,000
Calculate Break-even point
7. 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
8. 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
Determine sales required to achieve an IBIT objective of $75,000
9. 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
10. Use the following information to determine the cause of sales variances: (10 points)
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
11. 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
12. Calculate the first monthâ€™s ending cash balance for the following:
Beginning cash balance of $15,000
$200,000 Sales, with 40% paid in cash. Half of the sales on account is paid equally in the month of sale and the next month.
Expenses were $120,000 all on credit. 20% paid in the month of purchase and the balance paid the second month.
Solution Description

Copyright © 2015 Tutor Homework Help Online, Tutoring Online - StudentLance, Inc. All rights reserved.