Prepare a variance report showing the companys revenue

Assignment Help Accounting Basics

Reference no: EM131971884

Problem

Roland's Jeep Tours operates jeep tours in the heart of the Blue Ridge Mountains. The company bases its budgets on two measures of activity (i.e., cost drivers), namely guests and jeeps. One vehicle used in one tour on one day counts as a jeep. Each jeep has one tour guide. The company uses the following data in its budgeting:

                                  Fixed element per month     Variable element per guest     Variable element per jeep
Revenue                                         $0                                   $132                                            $0
Tour guide wages                           $0                                     $0                                           $158
Vehicle expenses                       $4,700                                $13                                            $79
Admin. expenses                            $2,100                            $2                                              $0

In September, the company budgeted for 456 guests and 155 jeeps. The company's income statement showing the actual results for the month appears below:

Roland's Jeep Tours Income Statement For the Month Ended September 30

Actual guests 481 Actual jeeps 153
Revenue    $62,222
Expenses:
Tour guide wages 23,664
Vehicle expenses 22,530
Administrative expenses         3,122
Total expense       49,316
Net operating income    $12,906

Required:

• First, create a flexible budget for the month of September.

• Next, using this flexible budget and the actual results, prepare a variance report showing the company's revenue and spending variances for September.

• Finally, label each variance as favorable (F) or unfavorable (U).

Reference no: EM131971884

Questions Cloud

Examine the generally accepted components of erm : Examine the generally accepted components of ERM which are present in your company and evaluate whether these components are working, failing.

Beautiful statement by robert kennedy : Read the beautiful statement by Robert Kennedy on the important aspects that GDP does not include (available in the slides and the textbook).

Compute earnings per share before the expansion : The Lopez-Portillo Company has $10.1 million in assets, 90 percent financed by debt and 10 percent financed by common stock.

How the project can be dismantled : We are examining a new project. We expect to sell 5,900 units per year at $73 net cash flow apiece for the next 10 years.

Prepare a variance report showing the companys revenue : Next, using this flexible budget and the actual results, prepare a variance report showing the company's revenue and spending variances for September.

Discuss the three ways in which the gross domestic product : Discuss the three ways in which the gross domestic product (GDP) can be measured? Why does each of them end up with approximately the same value?

Recommend solutions to the housing shortage : Use and apply the concepts from the week's lesson to recommend solutions to the housing shortage.

What is the change in the average selling price for desktops : What is the total revenue for dell? what is the change in the average selling price for desktops pcs? why do you think this occurred?

How much is the investment product worth to you today : If the appropriate discount rate to evaluate the product is 4%, how much is the investment product worth to you today?

User Account

All Pages