PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.I REPEAT, ONLY EXCEL PROBLEM 2Professor Weejohs teaches two sections of business analytics, which combined will result in 120 finalexams to be graded. Professor Weejohs has two assistants, AJ and Romel, who will grade the finalexams. There is a 3-day period between the time the exam is administered and when final grades mustbe posted. During this period AJ has 12 hours available and Romel has 10 hours available to grade theexams. It takes AJ an average of 7.2 minutes to grade an exam, and it takes Romel 12 minutes to gradean exam; however, AJ's exams will have errors that will require Professor Weejohs to ultimatelyregrade 10% of the exams, while only 6% of Romel's exams will require regrading. Professor Weejohswants to know how many exams to assign to each assistant to grade in order to minimize the numberof exams to regrade.Required:a. Solve this model by using Solver in MS Excel. Generate the (1) answer and (2) sensitivity reportsfor this model.b. If Professor Weejohs could hire AJ or Romel to work 1 additional hour, which should hechoose? What would be the effect of hiring the selected assistant for 1 additional hour?

PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS. I REPEAT, ONLY EXCEL

PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS. I REPEAT, ONLY EXCEL

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter13: Decision Making Under Uncertainty

Section13.7: The Analytic Hierarchy Process

Problem 3P

See similar textbooks

Similar questions

Question 4It has been observed by management that some faculty members at theuniversity demonstrate a lackadaisical attitude toward teaching. They seldom go to class yet at the end of each month they receive full salary. Management has decided that GHs 200, 300, 400, and 500 will be deducted from a faculty’s salary if he/she offends once, twice, third time and forth time respectively in a month. This means that if a faculty member offends once in a month GHs200 will be deducted, if a faculty member offends twice in a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty member offends three times in a month GHs 900 (i.e. 200+300+400), will be deducted and if a faculty member offends four times in a month GHs 1,400 (i.e. 200+300+400+500). Assuming all faculty members are on a flat salary rate of GHs 2000.a. Write a program to request for the names of four faculty members and number times he/she has absented him/herself from class in a month.One of them should have absented…
Question 4It has been observed by management that some faculty members at theuniversity demonstrate a lackadaisical attitude toward teaching. They seldom go to class yet at the end of each month they receive full salary. Management has decided that GHs 200, 300, 400, and 500 will be deducted from a faculty’s salary if he/she offends once, twice, third time and forth time respectively in a month. This means that if a faculty member offends once in a month GHs200 will be deducted, if a faculty member offends twice in a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty member offends three times in a month GHs 900 (i.e. 200+300+400), will be deducted and if a faculty member offends four times in a month GHs 1,400 (i.e. 200+300+400+500). Assuming all faculty members are on a flat salary rate of GHs 2000.a. Write a java program to request for the names of four faculty members and number times he/she has absented him/herself from class in a month.One of them should have absented…
Damon Davis was working on the company's spreadsheet for Drano Drain and Sewer Service. Based on his estimates, he concluded that a net income of $50,000 would result. He totaled up the amounts in the Total Balance Sheet Columns, which indicated a deficit of $400,000 and a credit of $300,000, and came up with the following: We can only speculate as to the true cause of this disparity. If this isn't the case, then how can he tell where the issue is coming from?
Question 4It has been observed by management that some faculty member at theuniversity demonstrates a lackadaisical attitude toward teaching. Theyseldom go to class yet at the end of each month they receive full salary.Management has decided that GHs 200, 300, 400, and 500 will be deductedfrom a faculty’s salary if he/she offends once, twice, third time and forthtime respectively in a month. This means that if a faculty member offendsonce in a month GHs 200 will be deducted, if a faculty member offends twicein a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty memberoffends three times in a month GHs 900 (i.e. 200+300+400), will be deductedand if a faculty member offends four times in a month GHs 1,400 (i.e.200+300+400+500). Assuming all faculty members are on a flat salary rate ofGHs 2000.a. Write a program to request for the names of four faculty members andnumber times he/she has absented him/herself from class. One ofthem should have absented him/herself once, another…
Problem 3: Consider the ICT bot in this 3*3 grid. Y X 1 2 3 1 S 2 3 * E S is the location where the robot starts.E is the end location where the robot must find * and carry to E. The robot can perform two actions: move and retrieve_star. It can move in 4 directions 1 adjacent cell at a time, from (x,y) to (x+1,y), (x-1,y),(x,y+1), and (x,y-1) as long as it remains on the 3*3 grid. Upon each grid, the robot will receive the signal from its sensor if * is in the current grid or not. If * is in the current grid, it can retrieve * using the retrieve_star command. 1) Design a classical representation for the current planning problem.
Damon Davis was preparing the spreadsheet for Drano Plumbing Company. He calculated that the net income would be $50,000. His Total Balance Sheet Columns indicated a $400,000 deficit and a $300,000 credit, which he combined and computed as follows: Who knows what the most probable cause of this disparity was. If this is not the case, how should he proceed to determine the root of the problem?
Question 3Assuming all Ghanaians who are at least 18 years can choose between going to school or learning a trade. GHC 100 is invested every month for a person who chooses to go to school by the government till the person attains age 30 years provided he/she completes university. If he/she does not complete university, the payment is stopped at the time he/she exited. If the person chooses to learn a trade, the government pays GHC 2000 as apprentice fee to the madam or master who will take the person as an apprentice, and invest GHC 70 a month till age 30 years. If the person does not complete the apprenticeship, the payment is stopped at the time he/she exited. Remember that persons who are less than 18 years or above 30 years do NOT qualify to enroll on this program.You are to write a java program for the above scenario. Your program should a) request a person’s name, age, what he/she wants to do 4(go to school or learn a trade), time of exit if any and disqualify the person if…
Question 7A. An Electrical Company has three workshops in Koforidua, Accra andKumasi. These workshops produce the following quantities of electric fan.Workshops Monthly production (units)Koforidua 130Accra 70Kumasi 100The monthly demand for these fans in three towns: Sunyani, Cape Coast and Ho is given below:Destination Weekly Demand (units)Sunyani 80Cape Coast 110Ho 60The unit transportation costs per unit (in GH¢000) from the sources to thedestinations are as shown: a) Formulate a linear programming (LP) model. B. The model in (A) was solved using Solver and part of the Solver output is shown below. Use it to answer the questions that follow. b) As a management, science student the MD of the company seeks yourexpert advice on ways in which to determine the optimal transportation rule.Write your answer in a form of a report to the MD c) Advise the MD, providing detailed explanation using the table above.Write your answer in a form of a report to the MD.
It's a Machine Learning question. Suppose we have market basket data consisting of 100 transactions and 20 items. Compute the total number of possible association rules. If the support for item A is 25%, the support for item B is 90% and the support for itemset {A,B} is 20%. Let the support and conﬁdence thresholds be 10% and 60%, respectively. Compute the conﬁdence of the association rule {A} → {B} & {B} → {A}.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee Hasan employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.
Question 1: pertains to the Cherokee School District scenario below. The school board for the Cherokee School District has made the decision to purchase 1370additional Macintosh computers for computer laboratories in all its schools. Based on the past experience, the school board has directed that these computers should be purchased from some combination of three companies Mc Comp, EduElectronics, and Macwin. In all three cases, the companies charge a discounted variable cost per computer and a fixed delivery and installation costs for these large sales to school districts. The table below shows these charges as well as the capacity (the maximum number of computers that can be sold from the limited inventory) for each of the companies.CapacityFixed cost variable costMcComp710 $45,000 $750 EduElectronics690$35,000$780 Macwin1000$50,000 $700 The school board wants to know the optimal plan for meeting its computer needs. 1.Identify the type of integer programming framework (Total Integer,…
A software company has 3 senior developers and 4 junior developers. These developers are working as 3 different teams; 2 sets of ‘1Senior+1Junior’ and 1 set of ‘1Senior+2Junior’. Productivity levels of junior developers according to their senior developer working with are given in the table. Formulate this problem as an LP model. Senior D. 1 Senior D. 2 Senior D. 3 Junior D. 1 2 10 5 Junior D. 2 6 9 8 Junior D. 3 7 5 6 Junior D. 4 10 6 10