Question
Professor Weejohs teaches two sections of business analytics, which combined will result in 120 final exams to be graded. Professor Weejohs has two assistants, Ralph
Professor Weejohs teaches two sections of business analytics, which combined will result in 120 final exams to be graded. Professor Weejohs has two assistants, Ralph and Melanie, 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 Ralph has 12 hours available and Melanie has 10 hours available to grade the exams. It takes Ralph an average of 7.2 minutes to grade an exam, and it takes Melanie 12 minutes to grade an exam; however, Ralph's exams will have errors that will require Professor Weejohs to ultimately regrade 10% of the exams, while only 6% of Melanie's exams will require regrading. Professor Weejohs 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started