Enter the hours worked by employee 1: 2 Enter the hours worked by employee 2: 3 Enter the hours worked by employee 3:1 Enter the hours worked by employee 4: 5 Enter the hours worked by employee 5: 6 Enter the hours worked by employee 6: 4 Enter the hourly pay rate: 10 Gross pay for employee 1: $20.00 Gross pay for employee 2: $30.00 Gross pay for employee 3: $10.00 Gross pay for employee 4: $50.00 Gross pay for employee 5: $60.00 Gross pay for employee 6: $40.00 Employee 5 gets maximum payment: $60.00 Employee 3 gets minimum payment: $10.00

Enter the hours worked by employee 1: 2 Enter the hours worked by employee 2: 3 Enter the hours worked by employee 3:1 Enter the hours worked by employee 4: 5 Enter the hours worked by employee 5: 6 Enter the hours worked by employee 6: 4 Enter the hourly pay rate: 10 Gross pay for employee 1: $20.00 Gross pay for employee 2: $30.00 Gross pay for employee 3: $10.00 Gross pay for employee 4: $50.00 Gross pay for employee 5: $60.00 Gross pay for employee 6: $40.00 Employee 5 gets maximum payment: $60.00 Employee 3 gets minimum payment: $10.00

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 6RA

See similar textbooks

Similar questions

An employee has only one job code, but a job code can be held by many employees. ERD
The following table shows the rate of commission that will be paid to the salesman according to the total sales performance of the month:Total Sales Performance (RM) CommissionLess than 10000 No commission10000 – 20000 1% of the total sales20001 – 30000 2% of the total sales30001 – 40000 3% of the total salesMore than 40000 4% of the total sales Lastly, display the salesmanName, totalSalesPerformance,totalCommission and totalSalary.
Question 7 Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) 1-5,999.99 6,000–29,999.99 30,000 and over Commission 10% of sales $600 plus 13% of the sales over 6,000 $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due.
XYZ pays 5% interest on shares exceeding Sh.100,000 and 3% on shares that do not meet the target. however no interest is paid on deposits in the members bank account. Calculate and display the shares on the screen for a member Calculate and display the deposits on the screen for a member
Salary Calculation Employee ID 121 Basic Pay Bonus 1000 50 Calculate
XYZ pays 5% interest on shares exceeding Sh.100,000 and 3% on shares that do not meet the target. however no interest is paid on deposits in the members bank account. calculate and display the shares, deposits, interest and total savings on the screen for a member
Q :Draw a flow chart for Grade calculation. i :Refer to undergraduate prospectus
Use the university schema for the following questions student takes ID ID course id sec id name dept_name tot ged semester vear grade section course course id sec id department course id advisor title dept_name credits dept name s id semester Year building room number time slot id building budget time_slot time slot id day start time end time prereq instructor classroom couTse id grereg id ID building room_number name dept_name salary сараcity teaches ID course id sec id semester year Figure 2.9 Schema diagram for the university database. Use the online SQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL statement under each question and upload the document to Canvas. 1. Display the name and total institution credits taken (not tot_cred which includes transfer credits) of students that do not have an assigned advisor (across all years). a. Hint: link takes with courses and student, for students not in advisor, project the name…
Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…
g) List the number of employees managed by each manager. The output should look like in the following picture:
In repair facility problem, costs of every day repair is $300. What will be the annual repair bill? mark) 0.05 0.95 Working Broken 0.6 0.4
10. Display the names of all employees where the third letter of their name is an A. ENAME BLAKE CLARK ADAMS 11. Display the name of all employees who have two Ls in their name and are in department 30 or their manager is 7782. ENAME ALLEN MILLER