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

Could you please use Solver Method in Excel to
solve this question?
 Could you please use Solver Method in Excel to solve this

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!