cinerney 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:
| Fixed element per month |
Variable element per guest |
Variable element per jeep | |||||||
| Revenue | $ | 0 | $ | 101 | $ | 0 | |||
| Tour guide wages | $ | 0 | $ | 0 | $ | 120 | |||
| Vehicle expenses | $ | 4,000 | $ | 10 | $ | 63 | |||
| Administrative expenses | $ | 2,700 | $ | 3 | $ | 0 | |||
In October, the company budgeted for 327 guests and 93 jeeps. The actual activity for the month was 350 guests and 104 jeeps.
Required:
Prepare the company's flexible budget for the actual level of activity in October.
|
|||||||||||||||||||||||||
Answer:-
| Mcinerney Jeep Tours | ||
| Flexible Budget | ||
| For the month ended October 31 | ||
| Particulars | Amount | |
| $ | ||
| Actual guests | 350 | |
| Actual jeeps | 104 | |
| Revenue | $101 per guest*350 guests | 35350 |
| Less:- Expenses | ||
| Tour guide wages | $120 per jeep*104 jeeps | 12480 |
| Vechile expenses | {$4000+($10 per guest*350 guests)+($63 per jeep*104 jeeps)} | 14052 |
| Administrative expenses | {$2700+($3per guest*350 guests)} | 3750 |
| Net operating income | 5068 | |
Get Answers For Free
Most questions answered within 1 hours.