ACTIVITY # 3Create a nested =IF formula to calculate the employee bonus for each employee member. Usethis to help you:• If the total number of customers >= 50 the employee gets 100.00 * no of customers• f the total number of customers >= 25 they get 50.00 * no of customersIf the number of customers was any less, show "No Bonus"Here's what the resulting worksheet should look like:ΕMPLOYEE ΝΑΜΕTOTAL CUSTOMERBONUSTom Burnett15 No BonusIf no customers >= 50 get 100.00 per customerOrion SharpMonty HahnSidra EmeryJosef HensleyKatie RowleyAmani AlmondAvaya Downs231150If no cusomers is 50-25 get 50.00 per customerIf no customers is less "no bonus"41410018900High ThresholdMed ThresholdTop Bonus7 No Bonus3551510018100.0050.00No Bonus22110019950Med BonusKatelin Felix373700Low BonusAntoinette Stout341700Lower the thresholds and the bonus percentage rates to check that your formula works.Save this as firstname_lastname_conditional_formulae

We have to write the formula for the equation. For the absolute result, we have to use the nested if…

ACTIVITY # 3 Create a nested =IF formula to calculate the employee bonus for each employee member. Use this to help you: • fi the total number of customers >= 50 the employee gets 100.00 * no of customers • fi the total number of customers >= 25 they get 50.00 * no of customers • If the number of customers was any less, show "No Bonus" Here's what the resulting worksheet should look like: EMPLOYEE NAME TOTAL CUSTOMER BONUS Tom Burnett Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond 15 No Bonus 1150 4100 900 If no customers > 50 get 100.00 per customer 23 If no cusomers is 50-25 get 50.00 per customer 41 If no customers is less "no bonus" 18 7 No Bonus 5100 High Threshold Med Threshold Top Bonus 35 51 22 18 1100 100.00 50.00 No Bonus Avaya Downs 950 3700 19 Med Bonus 37 34 Katelin Felix Low Bonus Antoinette Stout 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae

ACTIVITY # 3 Create a nested =IF formula to calculate the employee bonus for each employee member. Use this to help you: • fi the total number of customers >= 50 the employee gets 100.00 * no of customers • fi the total number of customers >= 25 they get 50.00 * no of customers • If the number of customers was any less, show "No Bonus" Here's what the resulting worksheet should look like: EMPLOYEE NAME TOTAL CUSTOMER BONUS Tom Burnett Orion Sharp Monty Hahn Sidra Emery Josef Hensley Katie Rowley Amani Almond 15 No Bonus 1150 4100 900 If no customers > 50 get 100.00 per customer 23 If no cusomers is 50-25 get 50.00 per customer 41 If no customers is less "no bonus" 18 7 No Bonus 5100 High Threshold Med Threshold Top Bonus 35 51 22 18 1100 100.00 50.00 No Bonus Avaya Downs 950 3700 19 Med Bonus 37 34 Katelin Felix Low Bonus Antoinette Stout 1700 Lower the thresholds and the bonus percentage rates to check that your formula works. Save this as firstname_lastname_conditional_formulae

C++ Programming: From Problem Analysis to Program Design

8th Edition

ISBN:9781337102087

Author:D. S. Malik

Publisher:D. S. Malik

Chapter5: Control Structures Ii (repetition)

Section: Chapter Questions

Problem 20PE: When you borrow money to buy a house, a car, or for some other purpose, you repay the loan by making...

See similar textbooks

Similar questions

Q: It is always challenging to decide when to stop testing. Testing exit criteria can be decided either formally or informally.You are required to write a minimum of 2500 words on testing exit criteria.Note: Attach plagiarism report with it and the percentage of plagiarism must be less than 15%.
When you borrow money to buy a house, a car, or for some other purpose, you repay the loan by making periodic payments over a certain period of time. Of course, the lending company will charge interest on the loan. Every periodic payment consists of the interest on the loan and the payment toward the principal amount. To be specific, suppose that you borrow $1,000 at an interest rate of 7.2% per year and the payments are monthly. Suppose that your monthly payment is $25. Now, the interest is 7.2% per year and the payments are monthly, so the interest rate per month is 7.2/12 = 0.6%. The first months interest on $1,000 is 1000 0.006 = 6. Because the payment is $25 and the interest for the first month is $6, the payment toward the principal amount is 25 6 = 19. This means after making the first payment, the loan amount is 1,000 19 = 981. For the second payment, the interest is calculated on $981. So the interest for the second month is 981 0.006 = 5.886, that is, approximately $5.89. This implies that the payment toward the principal is 25 5.89 = 19.11 and the remaining balance after the second payment is 981 19.11 = 961.89. This process is repeated until the loan is paid. Write a program that accepts as input the loan amount, the interest rate per year, and the monthly payment. (Enter the interest rate as a percentage. For example, if the interest rate is 7.2% per year, then enter 7.2.) The program then outputs the number of months it would take to repay the loan. (Note that if the monthly payment is less than the first months interest, then after each payment, the loan amount will increase. In this case, the program must warn the borrower that the monthly payment is too low, and with this monthly payment, the loan amount could not be repaid.)
Last Name Dev Hours Review Date Rating Salary Bonus Brody 6 1/5/2018 2 $ 19,840 Alex 8 4/1/2018 5 $ 26,700 Ashley 1 7/1/2018 4 $ 33,200 1. Use the logical if function to pay a bonus. You determine the rules for the bonus. List the rules and your steps. For example, you may use the employee rating to align with a specific bonus percentage such as 2% for a 2 rating, 5% for a 5 rating, etc.
Installation of a Shopee Billboard Max. score: 100 You are installing a billboard and want it to be at the maximum height. The billboard will have two steel supports, one on each side. The height of each steel bracket must be equal. You have a number of rebar rods that can be welded together. For example, if the bars are of length 1, 2, and 3, they can be welded together to form a length of 6 brackets. Return the maximum possible installation height of the billboard. Return 0 if the billboard cannot be installed.
Question 03: Write a simplified sinmulation of Ping-Pong according to the following rules: • Ranks 0 and 1 participate • Rank 0 starts with the ball • The rank with the ball sends it to the other rank Both ranks count the number of times they get the ball After counting to 1 million, the rank gives up • There are no misses or points
It's important to know how to best utilize the super keyword.
Business Rule - "no pilot can fly more than 10 hours within any 24-hour period" Draw a ERD diagram of the following Business Rule above.
assign(self, assignment:Assignment) -> AssignmentResult: """ This function is to simulate the process of the student receiving an assignment, then working on the assignment, then submitting the assignment and finally receiving grade for the assignment. This function will receive an assignment then a grade should be calculated using the following formula: grade = 1 - (Student's current energy X Assignment difficulty level). The min grade a student may receive is 0% (0) After the grade is calculated the student's energy should be decreased by percentage difficulty. Example if the student has 80% (.8) energy and the assignment is a difficultly level .2 there final energy should be 64% (.64) = .8 - (.8 * .2). The min energy a student may have is 0% (0) Finally the grade calculated should be stored internally with in this class so it can be retrieved later. Then an Assignment Result object should be created with the student's ID, the assignment…
use visual basic Depreciation to a Salvage Value of 0 . For tax purposes an item may be depreciated over a period of several years, n . With the straight-line method of depreciation , each year the item dpreciates by 1/nth of it original value. with the double-declining-balance method of depreciation, each year the item depreciate by 2/nths of its value at the beginning of that year.(In the final year it is depreciated by its value at the beginning of the year. ) Write a program that performs the following tasks:(a) Request a description of the item, the year of purchase, the cost of the item, the number of years to be depreciated (estimated life), and the method of depreciation. The method of depreciation should be chosen by clicking on one of two buttons.(b) Display a year- by-year description of the depreciation. See Fig. 6.15 .
Custodial staff needing to clean bathrooms in a building that is not closed often use some version of the following process: first, they set up a sign or marker indicating that the bathroom is closed; then, they wait for everybody using the bathroom to finish and leave; once it's empty, they clean the room; and finally they reopen it for general use. Obviously, nobody that's already in the bathroon gets kicked out, but someone arriving after the sign is up will have to go find another batbroom even if the cleaning hasn't started yet.This algorithm is a solution to a resource access-synchronisation problem: specifically, the controlled resource is the bathroom, and the problem and solution are related to the readers-writers problem. Pseudocode:We can describe this algorithm using two semaphores: a binary semaphore called "mutex" and a counting semaphore called "empty"-When the custodial staff enters the bathroom, they acquire the mutex semaphore to ensure that they have exclusive access…
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
Serendipity Booksellers has a book club that awards points to its customers based on the number of books purchased each month. The points are awareded as follows: If a customer purchases 0 books, he or she earns 0 points. If a customer purchases 1 book, he or she earns 5 points. If a customer purchases 2 books, he or she earns 15 points. If a customer purchases 3 books, he or she earns 30 points. If a customer purchases 4 or more books, he or she earns 60 points. Creat an application in C# that lets the user enter the number of books that he or she has purchased this month and displays the number of points awarded.