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

The Answer is in the image, click to view ...

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

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:

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

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?

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock