excel with instruction
zx794040688
zhang_e05ch10_grader_pc_ExpansionAnalysis_1of2.xlsxBreak-Even Analysis
| Red Bluff Golf Course & Pro Shop | |||||||||
| Break-even Analysis for Golf Lessons | |||||||||
| Revenue | Expenses | Revenue | Net Income | ||||||
| Total Clients | |||||||||
| Golf Lesson Fee | $125.00 | Client Demand | 10 | ||||||
| Gross Revenue | 20 | ||||||||
| Expenses | 30 | ||||||||
| Fixed Costs | 40 | ||||||||
| Manager Salaries | $4,669.00 | 50 | |||||||
| Utilities | $427.00 | 60 | |||||||
| Equipment Depreciation | $1,122.00 | 70 | |||||||
| Insurance | $328.00 | 80 | |||||||
| Total Fixed Costs | 90 | ||||||||
| Variable Costs | 100 | ||||||||
| Instructor Commission | 10% | ||||||||
| Supplies per Client | $9.95 | ||||||||
| Total Variable Costs | |||||||||
| Total Expenses | |||||||||
| Net Income |
&F
LoanConditions
| Red Bluff Loan Conditions | One-Variable Data Table | ||
| Loan Amount | $200,000 | ||
| Term (Years) | 10 | ||
| Interest Rate | 6.00% | ||
| Down Payment | $25,000 | ||
| Monthly Payment | $1,942.86 | ||
&F
FeesAndDemand
| Golf Lesson Pricing | Two-Variable Data Table | ||||||||||
| Total Clients | 75 | Lesson Fees | |||||||||
| Lesson Fee | $150.00 | 120 | 125 | 130 | 135 | 140 | 145 | 150 | |||
| Gross Revenue | $11,250.00 | Client Demand | 45 | ||||||||
| Fixed Costs | $9,554.10 | 50 | |||||||||
| Variable Costs | $856.78 | 55 | |||||||||
| Net Income | $839.12 | 60 | |||||||||
| 65 | |||||||||||
| 70 | |||||||||||
| 75 | |||||||||||
| 80 | |||||||||||
| 85 | |||||||||||
| 90 | |||||||||||
| 95 | |||||||||||
| 100 | |||||||||||
| 105 |
&F
