Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer in excel and post the screenshot or file thanks Q4. (10 points) Professor Matthews teaches two sections of ADMN 2607: Management Science, which
please answer in excel and post the screenshot or file thanks
Q4. (10 points) Professor Matthews teaches two sections of ADMN 2607: Management Science, which combined will result in 130 final exams to be graded. Professor Matthews has two graduate assistants (TAs), James and Ann, who will grade the final exam. There is a three-day period between the time the exam is administered and when the final grades must be posted by the Registrar at Algoma University. During this period James has 14 hours available and Ann has 12 hours available to grade the exams. It takes James on average 8.4 minutes to grade an exam, and it takes Ann 15 minutes to grade an exam however James exams will have errors that will require Professor Matthews to ultimately regrade 12% of his exams while only 5% of Ann's exams will require regrading. Professor Matthews wants to know how many exams to assign to each TA to get all of them graded but he also wants to minimize the number of exams that he will be required to regrade. Required: a) Formulate a LP model for this problem and solve this model using Excel. b) If Professor Matthews could hire James or Ann to work one more hour, who should he choose? What would be the effect of hiring the selected TA for one additional hour 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