Hottle Jeep Tours operates jeep tours in the heart of the colorado Rockies. The
ID: 2500718 • Letter: H
Question
Hottle Jeep Tours operates jeep tours in the heart of the colorado Rockies. The company bases its budgets on two measures of activity or 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: In February, the company budgeted for 350 guests and 140 jeeps. The actual results for the month appear below: Required: Prepare a performance report table, clearly showing the company's flexible budget, actual results, and flexible budget variances for February for the revenue line and each of the three expense lines as shown above. Label each variance as favorable (F) or unfavorable (U). Offer brief comments on the company's operating performance for February.Explanation / Answer
Performance Report:
Flexible
Actual
Variance
Revenue
$ 52,848
$ 52,508
$ 340
U
(367 *144)
Expenses:
Tour Guide Wages
$ 20,264
$ 22,477
$ 2,213
U
(149*136)
Vehicle Expenses
$ 16,665
$ 16,855
$ 190
U
4400+(367*5)+(149*70)
Administrative Expenses
$ 2,334
$ 2,734
$ 400
U
1600+(367*2)
Performance Report:
Flexible
Actual
Variance
Revenue
$ 52,848
$ 52,508
$ 340
U
(367 *144)
Expenses:
Tour Guide Wages
$ 20,264
$ 22,477
$ 2,213
U
(149*136)
Vehicle Expenses
$ 16,665
$ 16,855
$ 190
U
4400+(367*5)+(149*70)
Administrative Expenses
$ 2,334
$ 2,734
$ 400
U
1600+(367*2)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.