A practice would like to allocate its resources optimally between the orthopedic and rheumatology departments. The revenues per case generated by orthopedics and by rheumatology are $2,000 and $1,000, respectively. The resources required for each type of case and the available resources are in the following table: Orthopedics Rheumatology Available Resources MD hours per case 2 2 600 hours of MD time Radiology Procedures per case 3 1 800 procedures Solve the problem using Excel Solver I have attached a partially completed Excelsnceadsheet for your use with this problem. All you need to do is enter the appropriate information into Excel Solver. The formulas have already been entered into the Excel spreadsheet. The following Information will help you put the requested Information in the correct places on the Solver addin The Objective is $653 You are asking Solver to maxdmize your total revenue by deciding on the optimum allocation of cases between Orthopedics and Rheumatology The Objective is $G$3 (You are asking Solver to maximize your total revenue by deciding on the optimum allocation of cases between Orthopedics and Rheumatology) You want to maximize your total revenue The two cells you want Solver to change are $B$9:$C$9 (the number of orthopedic cases and the number of rheumatology cases) You have constraints that you must tell Solver about $G$4 must be less than or equal to $E$4 (you have a limited number of MD Hours) $G$5 must be less than or equal to $E$5 (you have a limited number of radiological procedures you can perform) Uncheck the "Make Unconstrained Variables Non-Negative" Use the following solving method: Simplex LP Select the "Solve" button You now have the answers to the exam questions. How many Orthopedic cases should we do? How many Rheumatology cases should we do? What is is the number for our maximium total revenues given the allocation above