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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Related questions

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: 14. Amir also wants to compare the estimated sales of January and June of next year. Insert a chart…

A: 14. a) 1. To create an estimated sale of jan and june column chart we need the first table given. So…

Q: To vary your reporting, you decided to include graphical representation. Create a clustered column…

Q: When preparing your presentation, why not just utilise the shortcut keys?

A: What is presentation: A presentation is a method of communicating information or ideas to an…

Q: how do you use absolute value in excel?

A: The ABS function in Excel is used to return the absolute value of a number. Or we can say that the…

Q: Find the excel formula for Rate per Hour after discount and Total cost Refer to the screenshots…

A: Solution: Given question: Find the excel formula for Rate per Hour after discount and Total cost.

Q: Question - 4 For each department retrieve the department number, number of employees and their…

A: by bartleby guidelines i am able to do only first question.

Q: Considering the above table, what appropriate Excel function to use in finding the the difference,…

A: In this question we have to find the differences in days, between the closing date and the release…

Q: Based on the ERD below, display all columns in the JOB table for those job descriptions that have…

A: 2) Query to display all columns in the JOB table for those job descriptions that have both analysts…

Q: Given two vectors of integers (either positive, negative or zeros) V1 and v2 of length di and d2…

A: #include<stdio.h>#include<stdlib.h>void prodCartFilt(int *v1,int d1,int *v2,int d2){…

Q: Consider the following TM: 0/0 → B|B → 1/0 → 1/1 → start → 9 0/0- 0/0 - B|B + On input 1010110 which…

A: Please find answer to the above question below:

Q: Set up Excel Quick Tip 5-3 in Excel.

A: The volume of a cylindrical object (like a round column) is calculated using the formula: . In this…

Q: If you wish to run more than two conditions in a single Excel run, what filter will you use?

A: The correct answer is

Q: How to add negative % with parenthesis on excel?

A: To add a negative percentage with parentheses in Excel, you can use the following steps:Enter the…

Q: Create Microsoft Access queries to answer the following: Total weight shipped by each product…

A: Shipped table: Microsoft Query to get "Total weight shipped by each product type" Output:

Q: How do we decide the model to create in Microsoft Access, our chosen table builder, and why?

A: Introduction of Microsoft Access: Microsoft Access is a relational database management system…

Q: Select the best answer from the given choices: Using the company schema, when creating the…

A: Actually, database is used to stores the data.

Q: What is the syntax for reading a comma separated value (CSV) file? A pd.read_csv('filename.csv") B…

A: 1. What is the syntax for reading a comma separated value csv file? B. pd.read_csv("filename")…

Q: Using the company schema, when creating the "works_on" table, the foreign key should be specified…

A: Foreign key specified The foreign key is used for linking two tables together. It is also known as…

Q: Delete all the salesmen who make less than 200 in commission, including those who have not earned…

A: In SQL, to remove rows from a table, DELETE command is used. To determine which rows are deleted,…

Q: Given the following numbers that represent given course, find the following: 90, 85, 75, 45, 95, 66,…

Q: Suppose the management claims that the proportion of games that your team wins when scoring 80 or…

A: Answer:)

Q: • List the male staff names who have supervisors

A: We are asked to form a query to list the male staff names who have supervisors from the table above.…

Q: (b) If each stage has 4 bits, what is minimum number of bits (N) needed in order for the…

A: The answer is

Q: Create employee Intrest survey form like below model

A: The Answer is in Below Steps

Q: Write the SQL code to produce the total number of hours and charges for each of the projects…

A: SQL: SQL stands for Structured Query Language. It is used to communicate with a database. It is…

Q: Using excel functions,which employee were best at finding leads who then converted into customers

A: Since you have not provided with the full dataset. Best we will be able to help with the logic and…

Q: Create a contract which successfully accomplishes the following tasks: - Add new employees with the…

A: An Employee management system which refers to the system that provides the managers with insights…

Q: How Does the Part Value Challenge Influence TAC

A: Lets discuss the solution in the next steps

Concept explainers

Excel

Microsoft Excel is a useful as well as powerful data analysis and documentation programme. Microsoft Excel is a spreadsheet program developed by Microsoft that is available for Windows, macOS, Android, and iOS. It includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).

Question

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 2
Professor Weejohs teaches two sections of business analytics, which combined will result in 120 final
exams to be graded. Professor Weejohs has two assistants, AJ and Romel, 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 AJ has 12 hours available and Romel has 10 hours available to grade the
exams. It takes AJ an average of 7.2 minutes to grade an exam, and it takes Romel 12 minutes to grade
an exam; however, AJ's exams will have errors that will require Professor Weejohs to ultimately
regrade 10% of the exams, while only 6% of Romel'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.
Required:
a. Solve this model by using Solver in MS Excel. Generate the (1) answer and (2) sensitivity reports
for this model.
b. If Professor Weejohs could hire AJ or Romel to work 1 additional hour, which should he
choose? What would be the effect of hiring the selected assistant for 1 additional hour?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step by step

Solved in 6 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

HareFractionalBirthRate InitialHares HareBirths HareDeaths Hares Area HareDensity LynxFractionalMortalityRate Lynx LynxBirths LynxDeaths InitialLynx LynxFractionalBirthRate a. What are the 5 loops in this model? What are their polarities?
Computer Science Rewrite this brief section. Create a table that illustrates the data. INTRODUCTION: The University of Wisconsin–Stout has experienced a series of large budget cuts in recent years. The athletic department has been granted an estimated budget of $250,000 for updates of current facilities. For a new floor installation to be feasible, the total cost must not reach over $250,000. FIGURES: According to Connors Flooring, the total installation cost of a maple sports floor is $81,300 with over 38 years of life expectancy. This is based on a 10,000-square-foot floor. The Maple Floor Manufacturers Association has concluded that wood floors also require regular cleaning, sanding, lines repainted, and floor refinishing approxi- mately every three years. This is a cost of approximately $8,000.00 per three years, equaling $2,666.00 p/year. With a 38 year life expectancy, the total for cleaning, sanding, painting, etc. = 101,308. CONCLUSION: The total cost of the floor is under…
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
Draw EER diagram based on these business rules Customers can only make a reservation for themself and their invited guests. A customer may not make a reservation for other people including such as reselling rooms. A customer cannot use Park Hyatt website to reserve room related to any commercial activity. A customer need to provide the ID card or passport. A customer must check-in after 4 p.m. A customer must check-out before 12 p.m. A customer may select room before do the reservation. A customer can do online payment by credit card or pay while during check-in. A staff must check the customer ID card or passport.
Q3 Rearrange the following steps for the EA problem solving model: Repeat Allow more options for better ones Choose one or more of these, alter them to create new solutions • Discard some of the solutions Over a period, solution quality will improve Create a number of tentative solutions
Business Process Modelling A business Process model needs to be drawn based on the attached screenshot.
Computer Science THREE TABLES: 1. PROJECT WORKER_TABLE COLUMNS leavedate, worker_id, joindate, project_id, performance 2. PROJECTS TABLE COLUMNS projectid, project_name, capacity, startdate 3. WORKERS table COLUMNS worker_id, worker_name, gender, companyjoindate, birthdate, birthday, supervisory_id USE MYSQL TO ANSWER QUESTION BELOW Q: Find the ID and name of the project(s) that have a gender ratio of greater than one[Gender ratio = #of females/# of males]
Project Synopsis: ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a…
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client’s needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis’ risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3; the higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis’s client also specified that at least $300,000 be invested in the money market fund. Let S = units purchased in the stock fund…
System Analysis & Design
Procedure Coding Procedure codes are a very important part of medical billing. They are used to describe the level of service provided to the patient. The level of service must agree with the diagnostic code that was discussed. Payers link the two together to determine if they agree before proceeding with payment decisions. A lack of connection between the diagnostic code and the procedure code will result in a denial of payment or a slowdown in payment. Both are bad for a practices cashflow. Apply basic procedure coding methods. Include the following aspects in the discussion: List 3 important topics you learned about the methods of Procedure Coding. Find a secondary source that dicusses this topic and share it with peer Discuss how you will address a denial of payment due to improper diagnostic and procedure coding
Software Project Management (Part - 18) ========================== Multiple Choice Quesiton =================