Ben Hogan Links is a golfing center. You have been asked by the head greens keep
ID: 2572825 • Letter: B
Question
Ben Hogan Links is a golfing center. You have been asked by the head greens keeper to help the course understand their cost structure as recently their budgeted income has differed from the realized income for the number of golfers they are receiving. They have determined that their costs are typically driven by two main drivers: Rounds Played and Golf Carts Rented. The cost structure is as such:
Fixed Cost
per Month
Cost per
Round Played
Cost per
Cart Rental
Landscaping
$
8,025
$
5.75
$
4.15
Gas for Carts
$
2.45
Depreciation on Carts
$
450
$
0.45
Utilities
$
6,450
$
1.35
Administration
$
3,650
$
0.75
Miscellaneous
$
1,105
$
1.15
$
0.15
In June, the company budgeted for 5,200 golfers at an average greens fee (selling price) of $45, 70% of whom rent carts. In reality the company found that only 4,867 golfers came through and 76% of them rented carts. Expense information for June was as follows:
Revenue
$
225,420
Landscaping
$
53,325
Gas for Carts
$
7,280
Depreciation on Carts
$
2,280
Utilities
$
15,984
Administration
$
6,409
Miscellaneous
$
7,655
Create a flexible budget which can compare the actual costs with the budgeted costs for Hogan and use conditional formatting to highlight which line item was the most beneficial and which was the most detrimental to their bottom line.
Fixed Cost
per Month
Cost per
Round Played
Cost per
Cart Rental
Landscaping
$
8,025
$
5.75
$
4.15
Gas for Carts
$
2.45
Depreciation on Carts
$
450
$
0.45
Utilities
$
6,450
$
1.35
Administration
$
3,650
$
0.75
Miscellaneous
$
1,105
$
1.15
$
0.15
Explanation / Answer
Actual No of golfers
4867
Car rented
76% of golfers
3699
Flexible Budget
Flexible budget
Actual result
Variance = Fleible-Actual
Favoravle or unfavorable
Revenue
219015
225420
-6405
U
Landscaping
8025+(4867*5.75)+(3699*4.15)
51361.1
53325
-1963.9
F
Gas for carts
3699*2.45
9062.55
7280
1782.55
U
depreciation on car
450+(3699*.45)
2114.55
2280
-165.45
F
Utilities
6450+(4867*1.35)
13020.45
15984
-2963.55
F
Administration
3650+(4867*.75)
7300.25
6409
891.25
U
Miscellaneous
1105+(4867*1.15)+(3699*.15)
7256.9
7655
-398.1
F
total of expenses
90115.8
92933
Net profit
128899.2
132487
-3587.8
U
Actual No of golfers
4867
Car rented
76% of golfers
3699
Flexible Budget
Flexible budget
Actual result
Variance = Fleible-Actual
Favoravle or unfavorable
Revenue
219015
225420
-6405
U
Landscaping
8025+(4867*5.75)+(3699*4.15)
51361.1
53325
-1963.9
F
Gas for carts
3699*2.45
9062.55
7280
1782.55
U
depreciation on car
450+(3699*.45)
2114.55
2280
-165.45
F
Utilities
6450+(4867*1.35)
13020.45
15984
-2963.55
F
Administration
3650+(4867*.75)
7300.25
6409
891.25
U
Miscellaneous
1105+(4867*1.15)+(3699*.15)
7256.9
7655
-398.1
F
total of expenses
90115.8
92933
Net profit
128899.2
132487
-3587.8
U
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.