Wrangler Jeep Tours takes people on jeep tours deep into the Colorado Rockies. When budgeting, the company uses two measures of activity (i.e., cost drivers): number of guests and number of 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 $ 191 Variable element per jeep $ 0 $ 138 $ 81 Revenue Tour guide wages Vehicle expenses Administrative expenses $ 4,900 $ 3,600 $ $ 28 21 When the hot summer subsides, October is high season for Wranger. This year they budgeted for 345 guests and 111 jeeps. Due to the weather, the actual activity for the month was 440 guests and 176 jeeps. Required: Prepare a flexible budget for October so Wrangler can assess their actual performance against their planned budget. 440 176 Mcinerney Jeep Tours Flexible Budget For the Month Ended October 31 Actual guests Actual jeeps Revenue Expenses: Tour guide wages Vehicle expenses Administrative expenses Total expense Net operating income