Pink Tours operates jeep tours in the heart of Death Valley. 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 |
Variable element |
Variable element per jeep |
|||||||
|
Revenue |
$ |
0 |
$ |
166 |
$ |
0 |
|||
|
Tour guide wages |
$ |
0 |
$ |
0 |
$ |
133 |
|||
|
Vehicle expenses |
$ |
4,650 |
$ |
23 |
$ |
76 |
|||
|
Administrative expenses |
$ |
3,350 |
$ |
16 |
$ |
0 |
|||
In March, the company budgeted for 340 guests and 106 jeeps. The actual activity for the month was 415 guests and 156 jeeps.
Required:
Prepare the company's flexible budget for the actual level of activity in March.
| Flexible Budget | |||
| actual guests | 415 | ||
| actual jeep | 156 | ||
| Revenue (166*415) | 68890 | ||
| expenses | |||
| tour guide wages (133*156) | 20748 | ||
| vehicle expenses 4650+(23*415)+(76*156) | 26051 | ||
| administrative expenses 3350+(16*415) | 9990 | ||
| Net operating income | 12101 | ||
Pink Tours operates jeep tours in the heart of Death Valley. The company bases its budgets...
Cryan 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 $ 277 $ 0 Tour guide wages...
Otomo Jeep Tours operates jeep tours in the heart of the Colorado Rockies. The company bases its budgets on two measures of activity (le, 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 Revenue Tour guide wages Vehicle expenses Administrative expenses Variable Variable element element per guest per jeep $ 95...
Cryan Jeep Tours operates jeep tours in the heart of the Colorado Rockies. The company bases its budgets on two measures of activity fie, 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 Variable Variable element element element per month per guest per jeep Revenue $ $ 297 $ 0 Tour guide wages $...
Cryan 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: Variable Fixed element Variable element element per jeep per guest 127 per month Revenue Tour guide wages Vehicle expenses Administrative expenses $...
undn JBep Tours opcraesp turs in rt ht Colora do nockies. The Company bases its' budget 6ntwo ru o sures btat?t?, qust ond jeeps One Campan ed n one tour Count as a jeep. Each yep has one tour quide he cnpany es ths bollous n a dato in i budtnq Eid een Nariable denen Nariable bur qui de wa hice ipen 158 ?4,700 2,100 13 19 inistrahrc expen In Sepicmber, the compan oudgeed fr the yonth"appea? below quests and...
Roberds Tech is a for-profit vocational school. The school bases its budgets on two measures of activity i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element per month Variable element per course Variable element per student $ 198 $ $ 32 Revenue Faculty wages Course supplies Administrative expenses $2,900 $25,500 $ 32 In March, the school budgeted for 1710 students and 68 courses. The school's income statement showing the actual results...
Problem 5: Flexible Budgeting (20 points) Unlimited Sports Cycles operates motorcycle day tours throughout the Southern California area. The company bases its monthly budgets on two measures of activity, customers and tours. Each customer pays a tour fee and is provided a motorcycle to be used for the day. For every tour, USC supplies a tour guide to make sure: 1) the customers do not get lost; and 2) do not try something they saw in the X Games (iLe,...
RIZZIO TECH IS A FOR- PROFIT VOCATIONAL SCHOOL. THE SCHOOL BASES ITS BUDGETS ON TWO MEASURES OF ACTIVITY (I.E. COST DRIVERS), NAMELY STUDENT AND COURSE. THE SCHOOL USES THE FOLLOWING DATA IN ITS BUDGETING: FIXED ELEMENT PER MONTH VARIABLE ELEMENT PER STUDENT VARIABLE ELEMENT PER COURSE REVENUE $0 $416 $0 FACULTY WAGES $0 $0 $2,300 COURSE SUPPLIES $0 $77 $25.00 ADMINISTRATIVE EXPENSES $57,900 $16 $27 IN SEPTEMBER, THE SCHOOL BUDGETED FOR 1,820 STUDENTS AND 173 COURSES. THE ACTUAL ACTIVITY FOR...
Problem 4 Rizzio Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element Variable element Variable element per month per student per course $416 $0 $2,300 $0 $77 $25 $57,900 $16 $27 SO SO Revenue Faculty wages Course supplies Administrative expenses $0 In September, the school budgeted for 1,820 students and 173 courses. The actual activity...
Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identified two cost drivers-the number of cruises and the number of passengers-that it uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 82 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below Fixed Cost...