Question

Daniel​ Glaser, chairman of the College of San​ Antonio's business​ department, needs to assign professors to courses next semester. As a criterion for judging who should teach each​ course, Professor Glaser reviews the past 2​ years' teaching evaluations​ (which were filled out by​ students). Since each of the four professors taught each of the four courses at one time or another during the​ 2-year period, Glaser is able to record a course rating for each instructor. These ratings are shown in the following table.

siness department. needs to assign professors to courses next semestar. As a criterion for judging who should teach each cou

0 0
Add a comment Improve this question Transcribed image text
Answer #1

We can solve the question by using excel solver -

Below is the screenshot of the LP table -

File Home Insert Page Layout Formulas Data ReviewView Help Tell m Connections Clear Reapply Advanced Show Queries From Table

Below is the screenshot of the formula applied -

Abhishek Rai Ei Book1 Excel Review View Help Tell me what you want to do File Home Insert Page Layout Formulas B Consolidate

Below is the screenshot of the solver -

日勺. Solver Parameters View Help Tell File Home Insert Page Layout Formulas Set Objective: EShow Queries Get Externa New Conne

Below is the screenshot of the result as required -

Book1 File Home Insert Page Layout Formulas Data ReviewView Help Tell me what y Connections Show Queries Clear Z A From Table

Overall Teaching Rating = 315

Add a comment
Know the answer?
Add Answer to:
Daniel​ Glaser, chairman of the College of San​ Antonio's business​ department, needs to assign p...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Save Score: 0 of 3 pts HW Score: 16.67 %, 3 of 18 pts 2 of 6 (2 complete)v Problem 15.9 21 Daniel Glaser, chairman...

    Save Score: 0 of 3 pts HW Score: 16.67 %, 3 of 18 pts 2 of 6 (2 complete)v Problem 15.9 21 Daniel Glaser, chairman of the Colege of San Antonio's business department, needs to assign professors to courses next semester. As a criterion for judging who d should teach each course, Professor Glaser reviews the past 2 years' teaching evaluations (which were filled out by students). Since each of the four professors taught each of the four courses at...

  • College Department. A college department has the problem of providing teachers for all courses of...

    College Department. A college department has the problem of providing teachers for all courses offered by the department at the highest possible level of educational quality. There are two professors, two associate professors, one assistant professor, and one teaching assistant (TA). Six courses must be offered, and after appropriate introspection and evaluation, the following relative ratings (100 best rating) regarding the ability of each instructor to teach each of the six courses are assigned. Professor Course 1 Course 2 Course...

  • please answer question A and B of Problem 4 showing all revelant working to arrive at...

    please answer question A and B of Problem 4 showing all revelant working to arrive at the answers. Problem 4 Kelly Spaugh, course scheduler of a technical college's business department, needs to assign instructors to courses next semester. As a criterion for judging who should teach each course, Kelly reviews the student evaluations for teaching for the past two years. These ratings are shown in the table below. Professor Statistics Management Finance Economics Management Science Strausbaugh 85 Kelley 80 75...

  • The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four c...

    The quantitative methods department head at a major midwestern university will be sched- uling faculty to teach courses during the coming autumn term. Four core courses need to be covered. The four courses are at the undergraduate (UG), master of business admin- istration (MBA), master of science (MS), and doctor of philosophy (Ph.D.) levels. Four professors will be assigned to the courses, with each professor receiving one of the courses. Student evaluations of professors are available from previous terms. Based...

  • Case Study 1: Should a Computer Grade Your Essays? Would you like your college essays graded...

    Case Study 1: Should a Computer Grade Your Essays? Would you like your college essays graded by a computer? Well, you just might find that happening in your next course. In April 2013, EdX, a Harvard/MIT joint venture to develop massively open online courses (MOOCs), launched an essay-scoring program. Using arti ficial intelligence technology, essays and short answers are immediately scored and feedback tendered, allowing students to revise, resubmit, and improve their grade as many times as necessary. The non-profit...

  • DATA DATA: ( You will have to paste it to a text editor and format it to be entered into statcru...

    DATA DATA: ( You will have to paste it to a text editor and format it to be entered into statcrunch - sorry for inconvenience but I could not find another way to post the data) Strategy Code Score C 1 45 C 1 53 C 1 72 C 1 55 C 1 67 C 1 53 C 1 66 C 1 54 C 1 53 C 1 67 C 1 60 C 1 64 C 1 69 C 1...

  • DATA: ( You will have to paste it to a text editor and format it to be entered into statcrunch - ...

    DATA: ( You will have to paste it to a text editor and format it to be entered into statcrunch - sorry for inconvenience but I could not find another way to post the data) Strategy Code Score C 1 45 C 1 53 C 1 72 C 1 55 C 1 67 C 1 53 C 1 66 C 1 54 C 1 53 C 1 67 C 1 60 C 1 64 C 1 69 C 1 52...

  • Q1 Which of the following are included and which are excluded in calculating this year's GDP....

    Q1 Which of the following are included and which are excluded in calculating this year's GDP. Explain in each instance. a. A monthly scholarship cheque received by an economics student b. The purchase of an almost new tractor by farmer Kojo C. The cashing in of a savings bond d. An increase in business inventories e. Tim Horton's purchases a corner grocery store f. Fearless Qweenie Kong, a stuntwoman, purchases a life insurance policy for a billion dollars ($) g....

  • How can we assess whether a project is a success or a failure? This case presents...

    How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT