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
- Revenue, Lesson Fees