Final Value Integer D4 Total Clients 1 14 Integer D5 Instructors on Duty 1 4

# Final value integer d4 total clients 1 14 integer d5

This preview shows page 8 - 13 out of 13 pages.

Final Value Integer \$D\$4 Total Clients 1 14 Integer \$D\$5 Instructors on Duty 1 4 Integer Constraints Cell Name Cell Value Formula Status Slack \$D\$4 Total Clients 14 \$D\$4<=14 Binding 0 \$D\$4 Total Clients 14 \$D\$4>=7 Not Binding 7 \$D\$5 Instructors on Duty 4 \$D\$5<=4 Binding 0 \$D\$4=Integer \$D\$5=Integer
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx Red Bluff Golf Course & Pro Shop Solver for Golf Lessons Input Variables Total Clients 14 Instructors on Duty 4 Revenue Lesson Fee \$185.00 Gross Revenue \$10,360.00 Expenses Fixed Costs Utilities \$427.00 Equipment Depreciation \$1,122.00 Insurance \$328.00 Total Fixed Costs \$1,877.00 Variable Costs Instructor Commission 3% \$310.80 Supplies per Client \$9.95 \$139.30 Total Variable Costs \$450.10 Total Expenses \$2,327.10 Net Income \$8,032.90 Saved Solver Models
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx <-- Variables that solver will use to optimize net income. Find ideal number of Total Clients and Ideal number of Instructors on duty to maximize Net Income. <-- Solver to optimize Net Income by finding the best way (by determining the ideal number of Total Clients and Solver constraints (as determined by Golf course management): 1) Cannot have more than 4 Instructors on Duty (cell D5) 2) Total clients must be between 7 and 14 (D4) . This is because lessons last 45 to 90 minutes each and the course is open 11 hours a day and insturctors can give anywhere from 7 to 14 lessons a day. 3) Results in D4 and D5 for Clients and Instructos obviously must be whole numbers . Use int mathematical operand to return whole number.
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx d ideal number of Instructors on Duty)
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx Create Date By Whom Description mm/dd/yyyy Firstname Lastname Mod. Date By Whom Mod. Description Create Date Sheet Name Creator
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx Workbook Name e05ch10ExpansionAnalysis.xlsx Last Version Backup Name Purpose

#### You've reached the end of your free preview.

Want to read all 13 pages?

• Spring '14
• JohnC.Meyers
• Revenue, Lesson Fees