Question: Could you please use Solver Method in Excel to solve this question? from Web On Deta- From Table/Range 810 A SERVICE Ophthalmology Botox Scleral lenses
from Web On Deta- From Table/Range 810 A SERVICE Ophthalmology Botox Scleral lenses 10 Capacity Availabled 9 33 Capacity used Slack capacity 12 13 Total profit 4 S . 7 . 14 15 16 17 38 19 20 21 22 25 24 Realy rating Connections 6. P Quenes www Problem 7 Problem 6 Able inedite Type here to search Felish Al- Com Comen Sek 11 Comply types and 24 AR 11 S H Set B D Doctor 2 Doctor 1 0.56 Ang Profi NA of patients Glasses E 60 0 0.50 0.33 $55 NA 0.33 $165 0 1.00 NA $250 48.00 15.00 34.67 20.00 11.33 5.00 The doctor who can do optometry and ophthalmology is there for 8 hours The doctor who can do Botox and ophthalmology is there, but just for hours The doctor who does glasses can't do botos, and visa versa The doctor who can do optometry can also do scleral lenses, but not the other one. We never see more than 5 botox patients a day We always between 2-5 glasses a day Scleral lenses we sell quite rarely if we can hire a full time optometrist, it will add 8 hours to ophthalmology exam and reduce time by 20% Problem 12 D Problem Problem problem 10 problem 11 Now E A . 197 fo An M om M 14140 than from Web On Deta- From Table/Range 810 A SERVICE Ophthalmology Botox Scleral lenses 10 Capacity Availabled 9 33 Capacity used Slack capacity 12 13 Total profit 4 S . 7 . 14 15 16 17 38 19 20 21 22 25 24 Realy rating Connections 6. P Quenes www Problem 7 Problem 6 Able inedite Type here to search Felish Al- Com Comen Sek 11 Comply types and 24 AR 11 S H Set B D Doctor 2 Doctor 1 0.56 Ang Profi NA of patients Glasses E 60 0 0.50 0.33 $55 NA 0.33 $165 0 1.00 NA $250 48.00 15.00 34.67 20.00 11.33 5.00 The doctor who can do optometry and ophthalmology is there for 8 hours The doctor who can do Botox and ophthalmology is there, but just for hours The doctor who does glasses can't do botos, and visa versa The doctor who can do optometry can also do scleral lenses, but not the other one. We never see more than 5 botox patients a day We always between 2-5 glasses a day Scleral lenses we sell quite rarely if we can hire a full time optometrist, it will add 8 hours to ophthalmology exam and reduce time by 20% Problem 12 D Problem Problem problem 10 problem 11 Now E A . 197 fo An M om M 14140 than
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
