Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Interactive Learning Approach

Authors: Mark S Beasley, Frank A. Buckless, Steven M. Glover, Douglas F Prawitt

7th Edition

0134421825, 9780134421827

More Books

Students also viewed these Accounting questions