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
Image of page 8
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
Image of page 9
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.
Image of page 10
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx d ideal number of Instructors on Duty)
Image of page 11
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx Create Date By Whom Description mm/dd/yyyy Firstname Lastname Mod. Date By Whom Mod. Description Create Date Sheet Name Creator
Image of page 12
b7f39f2d95e5759bf1d26b006de5b57252d533cf.xlsx Workbook Name e05ch10ExpansionAnalysis.xlsx Last Version Backup Name Purpose
Image of page 13

You've reached the end of your free preview.

Want to read all 13 pages?

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes