Life Coach Services Scheduling Plan PaulaFrankKristen Clients per Hour by Coach211 Cost per Hour for Coach$125.00$75.00$100.00 Number of Business Coaching Clients 50050 Number of Individual Coaching Clients 3020050 Number of Mentoring Clients 10010 Total Clients Served80300110 Total Hours for Coach40.0030.000.00 Materials Cost$538.10$273.60$0.00$811.70 Labor Cost5,000.002,250.00-7,250.00 Total Cost5,538.102,523.60-8,061.70 Sales Revenue17,000.005,000.00-22,000.00 Profit$11,461.90$2,476.40$0.00$13,938.30 Scheduling Constraints Total Hours for Scheduling40 Total Business Coaching Clients50 Total Individual Coaching Clients50 Total Mentoring Clients10Total Clients for Service Type ABCDE 1 2 34 5 6 789 10 1112 13 14 15 1617 1819 20 21
Microsoft Excel 16.0 Answer Report Worksheet: [Life Coach Services Analysis.xlsx]Scheduling Plan Report Created: 4/3/2023 4:21:10 PM Result: Solver found a solution.All Constraints and optimality conditi Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 7 Subproblems: 0 Solver Options Max Time Unlimited,Iterations Unlimited, Precision 0.000001, Use Automati Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1 Objective Cell (Min) CellNameOriginal Value $E$14TotalCost- Variable Cells CellNameOriginal Value $B$7PaulaBC0 $B$8PaulaIC0 $C$8FrankIC0 $C$9FrankMC0 $D$7KristenBC0 $D$8KristenIC0 $D$9KristenMC0 Constraints CellNameCell Value $B$11Total Hours for Coach Paula40.00 $C$11Total Hours for Coach Frank30.00 $D$11Total Hours for Coach Kristen0.00 $E$7TotalBC50 $E$8TotalIC50 $E$9TotalMC10 $B$7PaulaBC50 $B$8PaulaIC30 $C$8FrankIC20 $C$9FrankMC10
$D$7KristenBC0 $D$8KristenIC0 $D$9KristenMC0 $B$7:$B$8=Integer $C$8:$C$9=Integer $D$7:$D$9=Intege
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order Now
Get Online
Assignment Help Services
