Excel Chapter 10 Prepare Case - Expansion Analysis Part B
abparsley
Parsley_Excel_Ch10_Prepare_ExpansionAnalysis_2of2.xlsxSalesForecast
| Red Bluff Golf Course & Pro Shop | |||||
| Forecast of Product Sales | |||||
| Inventory Items | Qty. | Price | Extended Price | Goal | |
| Stock Golf Balls | $37.00 | $0 | $27,500 | ||
| Golf Shorts | 300 | $0 | $14,000 | ||
| Large Golf Umbrella | 125 | $0 | $7,500 | ||
| High Performance Golf Polo | $75.00 | $0 | $20,100 |
&F
ProfitForecast
| Red Bluff Golf Course & Pro Shop | |||
| Profit Scenarios | |||
| Revenue | |||
| Retail Sales | $65,000.00 | ||
| Golf Lessons and Fees | $220,000.00 | ||
| Gross Revenue | |||
| Expenses | |||
| Fixed Costs | |||
| Manager Salaries | $5,135.90 | ||
| Utilities | $469.70 | ||
| Equipment Depreciation | $1,234.20 | ||
| Insurance | $360.80 | ||
| Total Fixed Costs | |||
| Variable Costs | |||
| Employee Commissions | 17% | ||
| Total Expenses | |||
| Net Income |
&F
GolfLessons
| Red Bluff Golf Course & Pro Shop | |||
| Solver for Golf Lessons | |||
| Input Variables | |||
| Total Clients | 1 | ||
| Instructors on Duty | 1 | ||
| Revenue | |||
| Lesson Fee | $190.00 | ||
| Gross Revenue | $190.00 | ||
| Expenses | |||
| Fixed Costs | |||
| Utilities | $469.70 | ||
| Equipment Depreciation | $1,234.20 | ||
| Insurance | $360.80 | ||
| Total Fixed Costs | $2,064.70 | ||
| Variable Costs | |||
| Instructor Commission | 10% | $19.00 | |
| Supplies per Client | $14.95 | $14.95 | |
| Total Variable Costs | $33.95 | ||
| Total Expenses | $2,098.65 | ||
| Net Income | -$1,908.65 | ||
| Saved Solver Models |
&F
