Tammo Jeep Tours operates jeep tours in the heart of the Colorado Rockies. 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: In June, the company budgeted for 430 guests and 172 jeeps. The actual activity for the month was 440 guests and 171 jeeps. Required: Prepare the company's planning budget for June.

Revenue Tour guide wages Vehicle expenses. Administrative expenses.... Variable Fixed element element per per month guest $0 $137 $0 $14 $3,700 $1,300 $2 Variable element per jeep $0 $147 $72 $0