Flexible Budgeting Hottle Jeep Tours operates jeep tours in the heart of the Col

ID: 2501662 • Letter: F

Question

Flexible Budgeting 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: Revenue Tour guide wages Vehicle expenses Administrative expenses Fixed cost per month SO SO $4,400 $1,600 Variable cost per guest $144 S0 S5 $2 Variable cost per jeep $0 $136 $70 S0 In February, the company budgeted for 350 guests and 140 jeeps. The actual results for the month appear below: Hottle Jeep Tours For the Month Ended February 28 Actual guests 367 Actual jeeps 149 Revenue $52,508 Tour guide wages Vehicle expenses Administrative expenses 22,477 16,855 2,734 Required: Prepare a performance report table, clearly showing the company's flexible budget, actual results, and lexible 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

Flexible budget Actual result Flexible

Budget V

Actual guest 367 367

Actual jeep 149 149

Total revenue $52,848 $52,508 340(U)

Total tour guide

wages 20,264 22,477 2213(U)

Total vechile exp 16,665 16,855 220(U)

Total adm exp 2334 2734 400(U)