Question

Please fill in the multiple blanks in both spreadsheets and answer the following questions.

The following information is from Bluff Run Golf Courses. The company runs three courses and the July income statement for each course is as follows:

BLUFF RUN GOLF COURSES
Income Statement
Month Ending July 31, 2018
	Blue Course		Black Course		Gold Course
Revenues
Greens fees revenue	$62,500		$89,000		$42,700
Outings revenue	?		6,000		29,000
Total revenue	$72,800		$95,000		$71,700
Expenses
Landscaping	$7,800		$14,200		$6,300
Wages	43,900		?		32,700
Repairs and maintenance	5,600		2,600		4,500
Fuel	3,100		3,000		1,970
Utilities	1,800		3,000		1,650
Total expenses	$62,200		$79,300		$47,120
Operating income	$10,600		$15,700		?

A. Calculate the operating income percentage for each of the courses. Round your percentages to one decimal place.

Course Blue	fill in the blank %
Course Black	fill in the blank e%
Course Gold	fill in the blank %

B.

1. Perform a vertical analysis for each course. Round your percentages to one decimal place.

Bluff Run Golf Courses Income Statement
Month Ending July 31, 2018
	Course Blue		Course Black		Course Gold
Revenues
Greens fees revenue	$62,500		$89,000		$42,700
Outings revenue	fill in the blank		6,000		29,000
Total revenue	$72,800		$95,000		$71,700
Expenses
Landscaping	$7,800	fill in the blank %	$14,200	fill in the blank %	$6,300	fill in the blank %
Wages	43,900	fill in the blank %	fill in the blank 2	fill in the blank %	32,700	fill in the blank %
Repairs and maintenance	5,600	fill in the blank %	2,600	fill in the blank %	4,500	fill in the blank %
Fuel	3,100	fill in the blank %	3,000	fill in the blank %	1,970	fill in the blank %
Utilities	1,800	fill in the blank 2%	3,000	fill in the blank %	1,650	fill in the blank %
Total expenses	$62200		$79300		$47120
Operating income	$10,600		$15,700		$fill in the blank
Operating income %	fill in the blank %		fill in the blank %		fill in the blank %

2. Based on a vertical analysis of each course, which accounts would you want to investigate further?

C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Why?

Answer 1