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…

Answered: ACTIVITY # 3 Create a nested =IF…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Home Buffet is trying to make a comeback. They want to offer special prices to the seniors an children to eat at their Buffet. Create a flow chart that meets the following requirements: Read age if age is 50 or more, display: "Welcome Senior, you get 80% discount" if age is 10 or less, display: "Welcome Young adult, you eat for FREE!" if age is between 11 and 49 display: "The price for your lunch is $8" Note: Use draw.io Links to an external site.to create the flowchart
Richard employs Interior Decorating company that wants to use your services to help create an invoicegenerating system. The Decorators submit an invoice weekly. They charge $20 per hour worked. Theyalso charge tax 10%. Richard likes to see an invoice that displays all the information – number of hours,the charge per hour, the total BEFORE tax and the total AFTER tax. Since this is an invoice, we also needto display the name of the company (Decorating Xperts) at the top of the invoice. Display all of theinformation on the screen.Using Pseudocode, develop an algorithm for this problem.
Question Pap ( A) .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Create the following variables: Gender (e.g. male or female) Age (e.g. 0, 1, 2, etc.) Handedness (e.g. left, mixed, right) Average number of minutes of exercise each week (e.g. 120, 180, 0, 30, etc.). Average number of daily calories consumed (e.g. 1400, 2500, etc.) Average number of cigarettes smoked per day (e.g. 0, 20, 5, etc.) Average number of alcoholic beverages consumed each week (e.g. 2, 20, 0, etc.) Self-Esteem (measured on a scale from 0-10 - e.g. 3, 8, 2, etc.) General Life satisfaction (measured on a scale from 0-10 - e.g. 2, 10, etc.). Enter data for each of the variables. Pay attention to the information in the parentheses next to the variables listed above as this will guide you to the type of information that needs to be entered. Try to make your data varied (e.g. do not make all your participants age 20). Please make 10 of your participants male and 10 of your participants female. Part 2: Using StatCrunch calculate the descriptive statistics (e.g. measures of central…
13. Factorial Implementation What is incorrect with the following implementation of factorial: def factorial(n): return n* factorial(n-1) Pick ONE option Nothing is wrong The return value should be n+ factorial(n-1) The return value should be factorial(n-1) * factorial(n-2) ) A base case is missing Clear Selection loxitu
Inheritance and Polymorphism This assignment starts with the Account class from Labs 4 and 5. Our new and improved bank has two kinds of accounts, savings, and checking. In addition to an ID and a balance, savings accounts have an annual interest rate and a minimum balance. Checking accounts have a minimum balance and a monthly fee. Withdrawals and deposits can be made to both kinds of accounts. At the end of each month, savings accounts pay interest, but only if the account's balance is above the minimum. Also at the end of each month, a fee is deducted from each checking account, but the fee is waived if the account's balance is over the minimum. Tasks 1. Create a complete UML diagram which shows the relationships between the three classes, Account, Savings, and Checking and all of the fields and methods in each. The only modifications required to the Account class is the addition of two abstract methods called closeMonth and accountString. 2. The closeMonth function performs the…
View your last submission CHALLENGE ACTIVITY Write two statements to read in values for my_city followed by my_state. Do not provide a prompt. Assign log_entry with current_time, my_city, and my_state. Values should be separated by a space. Sample output for given program if my_city is Houston and my_state is Texas: 2014-07-26 02:12:18: Houston Texas Note: Do not write a prompt for the input values. Code writing challenge activity demo 3.1.3: Concatenating strings. 446244.3123728.qx3zqy7 UAWNH 1 current_time 2 3 4 Run = '2020-07-26 02:12:18:' Your solution goes here " 5 print(log_entry) View your last submission Feedback? 1 test passed All tests passed Feedback?
PYTHON PROGRAMMING Write a program that perform 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 b) Display a year-by-year description of the depreciation in a table setting Output Example: Enter name of item purchased: computer Emter year purchased: 2016 Enter cost of item: 2000 Enter estimated life of item <in years>: 5 Enter method of depreciation <SL or DDB>: SL Description: computer Year of purchase: 2016 cost: $2,000.00 estimated life: 5 years method of depreciation: straight-line (I did that ^ the only thing im having trouble with is the table setting) (see attached)
Phython: Create a function so that when giving you a month it tells you the season of that month, for example: if it is January it will be winter.Using the def, try and except ValueError functions.
Given two integers that represent the miles to drive forward and the miles to drive in reverse as user inputs, create a SimpleCar variable that performs the following operations:
Slappy’s Software Sales AssignmentYou have been hired by Slappy’s Software Sales to write a program to figure thetotal cost to customers that order Slappy’s software packages.Discounts are given based on the number of units sold:Number of Units Sold Discount Amount1 – 9 None10 – 19 20%20 – 49 30%50 – 99 40%100 or more 50%Create a form similar to this:The three boxes are labels. Remember to use the Auto Size and Border Styleproperties.The program should read the number of units sold and figure a base cost. Theunits cost $99 each. A discount should then be figured and subtracted from thebase cost. The subtotal, discount amount and total cost should be displayed, ascurrency, in the appropriate labels.Here are some screen shots of the running program:Set the tab order and access keys.Put comments in your program as to what each section is doing.Use constants for the discount rates and base price.
For this project, you are to complete the following assignment: Given a certain temperature in Fahrenheit and a maximum wind velocity (speed) in Miles Per Hour, calculate and display a series of wind chill factors from a wind velocity of 1 MPH to the maximum wind velocity in a table. The user is allowed to specify a maximum wind velocity of up to 50 MPH. Here are the programming instructions for this project: • You must use coding techniques from only Chapter 1 through Section 5.1 in our textbook. You may not use any other coding techniques from any other sources. • Create a project and class in BlueJ named Project2 • In main(), do the following: o Prompt the user to enter the current temperature and use a Scanner object to store it in a double variable. o Call a method named getVelocity that returns an integer and has a Scanner parameter. This method must use a either a while loop or a do-while loop to prompt the user to enter the maximum wind velocity (speed) and return it. A valid…

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS