Question: PROBLEM 2 Professor Smith teaches two sections of business analytics, which combined will result in 120 final exams to be graded. Professor Smith has two

PROBLEM 2 Professor Smith teaches two sections of

PROBLEM 2 Professor Smith teaches two sections of business analytics, which combined will result in 120 final exams to be graded. Professor Smith has two assistants, Brad and Sarah , who will grade the final exams. There is a 3-day period between the time the exam is administered and when final grades must be posted. During this period Brad has 12 hours available and Sarah has 10 hours available to grade the exams. It takes Brad an average of 7.2 minutes to grade an exam, and it takes Sarah 12 minutes to grade an exam; however, Brad's exams will have errors that will require Professor Smith to ultimately regrade 10% of the exams, while only 6% of Sarah's exams will require regrading. Professor Smith wants to know how many exams to assign to each assistant to grade in order to minimize the number of exams to regrade. a. Solve this model by using Solver in MS Excel. b. If Professor Smith could hire Brad or Sarah to work 1 additional hour, which should he choose? What would be the effect of hiring the selected assistant for 1 additional hour

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 General Management Questions!