Blue Valley Resort

Profit Analysis

Spa

Executive Room

Restaurant

Business Center

Conference Rooms

Reception

Total

Sales

$70,000.00

$350,000.00

$625,850.00

$180,000.00

$190,251.00

$222,120.00

$1,638,221.00

Cost of Sales

36,715.00

106,500.00

325,600.00

14,790.00

45,125.00

8,650.00

537,380.00

Direct Expenses

14,750.00

53,890.00

252,975.00

8,435.00

22,475.00

6,940.00

359,465.00

Indirect Expenses

Administrative

$3,097.87

$15,489.36

$27,697.19

$7,965.96

$8,419.62

$9,829.99

$72,500.00

Rent

6,100.60

21,474.10

14,641.43

2,196.22

13,909.36

2,928.29

61,250.00

Electricity

1,965.55

9,827.73

17,573.39

5,054.26

5,342.10

6,236.96

46,000.00

Utility

1,245.02

4,382.47

2,988.05

448.21

2,838.65

597.61

12,500.00

Maintenance

2,589.64

9,115.54

6,215.14

932.27

5,904.38

1,243.03

26,000.00

Miscellaneous

2,232.60

11,163.02

19,961.08

5,740.98

6,067.93

7,084.37

52,250.00

Total Indirect Expenses

$17,231.28

$71,452.23

$89,076.29

$22,337.90

$42,482.05

$27,920.25

$270,500.00

Net Income

$1,303.72

$118,157.77

($41,801.29)

$134,437.10

$80,168.95

$178,609.75

$470,876.00

Square Footage

2,500

8,800

6,000

900

5,700

1,200

25,100

Planned Indirect Expenses

Administrative

$72,500.00

Depreciation

$61,250.00

Electricity

$46,000.00

Insurance

$12,500.00

Maintenance

$26,000.00

Marketing

$52,250.00

Use the data provided above to answer the folowing questions. Use the Goal Seek Tool and TYPE the answer into the blue cell.

1. In order to have the Total Net Income Equal to $500,000.00, the administrative expense must be

2. In order to have the Total Net Income Equal to $490,000.00, the electricity expense must be

3. In order to have the Total Net Income Equal to $480,000.00, the maintenance expense must be

Name: WilliamsChalisha II IIIIIII IIII

Instructions

1. Use Goal Seek function to determine the value in cells H27-H29. Please ensure once you solved for an answer, click "cancel" to return to the original data before starting another goal seek.

Blue Valley Resort
Profit Analysis
	Spa	Executive Room	Restaurant	Business Center	Conference Rooms	Reception	Total
Sales	$70,000.00	$350,000.00	$625,850.00	$180,000.00	$190,251.00	$222,120.00	$1,638,221.00
Cost of Sales	36,715.00	106,500.00	325,600.00	14,790.00	45,125.00	8,650.00	537,380.00
Direct Expenses	14,750.00	53,890.00	252,975.00	8,435.00	22,475.00	6,940.00	359,465.00
Indirect Expenses
Administrative	$3,097.87	$15,489.36	$27,697.19	$7,965.96	$8,419.62	$9,829.99	$72,500.00
Rent	6,100.60	21,474.10	14,641.43	2,196.22	13,909.36	2,928.29	61,250.00
Electricity	1,965.55	9,827.73	17,573.39	5,054.26	5,342.10	6,236.96	46,000.00
Utility	1,245.02	4,382.47	2,988.05	448.21	2,838.65	597.61	12,500.00
Maintenance	2,589.64	9,115.54	6,215.14	932.27	5,904.38	1,243.03	26,000.00
Miscellaneous	2,232.60	11,163.02	19,961.08	5,740.98	6,067.93	7,084.37	52,250.00
Total Indirect Expenses	$17,231.28	$71,452.23	$89,076.29	$22,337.90	$42,482.05	$27,920.25	$270,500.00
Net Income	$1,303.72	$118,157.77	($41,801.29)	$134,437.10	$80,168.95	$178,609.75	$470,876.00
Square Footage	2,500	8,800	6,000	900	5,700	1,200	25,100
Planned Indirect Expenses
Administrative	$72,500.00
Depreciation	$61,250.00
Electricity	$46,000.00
Insurance	$12,500.00
Maintenance	$26,000.00
Marketing	$52,250.00
Use the data provided above to answer the folowing questions. Use the Goal Seek Tool and TYPE the answer into the blue cell.
1. In order to have the Total Net Income Equal to $500,000.00, the administrative expense must be
2. In order to have the Total Net Income Equal to $490,000.00, the electricity expense must be
3. In order to have the Total Net Income Equal to $480,000.00, the maintenance expense must be
Name: WilliamsChalisha II IIIIIII IIII
Instructions
1. Use Goal Seek function to determine the value in cells H27-H29. Please ensure once you solved for an answer, click "cancel" to return to the original data before starting another goal seek.