Computers and Technology, 06.11.2020 18:10 madi2878

Create a spreadsheet to calculate the your company's payroll, or how much you pay each employee and the total you pay all employees. You pay your employees every two weeks, and for the last two weeks, your employees worked the following hours:

Employee 1: 78
Employee 2: 75
Employee 3: 80
Employee 4: 45
Employee 5: 50
Employee 6: 80
Employee 7: 65
Employee 8: 60
Employee 9: 78
Employee 10: 75
Your spreadsheet should calculate:

the total hours worked for each employee
the gross pay for each employee (pay rate is $12.50 per hour)
the state income tax for each employee (use 5.7%)
the Federal income tax for each employee (use 15%)
Social Security for each employee (use 3.5%)
the net pay for each employee by subtracting the income tax and Social Security from the gross pay
the total gross pay, total state income tax, total Federal income tax, total Social Security, and total net pay paid to all employees
When you finish your spreadsheet, estimate your answers to check for accuracy. Make any necessary corrections. Use formatting techniques to make your spreadsheet easy to read. Upload your spreadsheet using the Upload tool in the box below.

Answers: 3

Show answers

Answers

Answer from: Quest

You must indent the items

Answer from: Quest

The steeply sloping region of a continental margin where the sea floor descends at a rate of greater than 1 ft for every 40 feet is called. continental slope.

Answer from: Quest

Yeah they want to steal your info and sell it on the dark web. they want your credit/debit card numbers, social security numbers, google passwords, and other stuff. some people install spyware onto your device, which, as the word suggests, is built to spy on your every move, such as what you type. they then sell this information to other people secretly or use it for evil purposes themselves. or both, idk. the reason why this info costs money to learn is because its valuable info. im not saying that i condone it though! hacking sucks, and whoever is involved in it is just a horrible person.

Answer from: Quest

a social news website is an internet website that features user-posted stories. such stories are ranked based on popularity, as voted on by other users of the site or by website administrators. users typically comment online on the news posts and these comments may also be ranked in popularity. since their emergence with the birth of web 2.0, social news sites have been used to link many types of information, including news, humor, support, and discussion. all such websites allow the users to submit content and each site differs in how the content is moderated. on the slashdot and fark websites, administrators decide which articles are selected for the front page. on reddit and digg, the articles that get the most votes from the community of users will make it to the front page. many social news websites also feature an online comment system, where users discuss the issues raised in an article. some of these sites have also applied their voting system to the comments, so that the most popular comments are displayed first. some social news websites also have a social networking function, in that users can set up a user profile and follow other users' online activity on the website.

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 19:30, sandersmakaylaovq5vu

Raveena is making a professional presentation for a newly launched product of her company. she wants to incorporate the following features in her presentation. a) to add serial numbers in each slide b) to add name of her company on top of each slide. c) to add the picture of her product on the second slide(the picture of her product is stored on her computer) write the commands/features of her presentation tool using which she can perform the above operations.

Answers: 2

continue

Computers and Technology, 22.06.2019 17:30, Samsonb

Working on this program in python 3.7: a year in the modern gregorian calendar consists of 365 days. in reality, the earth takes longer to rotate around the sun. to account for the difference in time, every 4 years, a leap year takes place. a leap year is when a year has 366 days: an extra day, february 29th. the requirements for a given year to be a leap year are: 1) the year must be divisible by 42) if the year is a century year (1700, 1800, the year must be evenly divisible by 400some example leap years are 1600, 1712, and 2016.write a program that takes in a year and determines whether that year is a leap year. ex: if the input is 1712, the output is: 1712 is a leap year. ex: if the input is 1913, the output is: 1913 is not a leap year. your program must define and call the function isleapyear(useryear). the function should return true if the input year is a leap year and false otherwise.

Answers: 1

continue

Computers and Technology, 22.06.2019 19:00, sere50

Stacy works as blank. the most important soft skill she needs for this role is blank.

Answers: 3

continue

Computers and Technology, 23.06.2019 18:50, ana7496

What is transmission control protocol/internet protocol (tcp/ip)? software that prevents direct communication between a sending and receiving computer and is used to monitor packets for security reasons a standard that specifies the format of data as well as the rules to be followed during transmission a simple network protocol that allows the transfer of files between two computers on the internet a standard internet protocol that provides the technical foundation for the public internet as well as for large numbers of private networks

Answers: 2

continue

You know the right answer?

Create a spreadsheet to calculate the your company's payroll, or how much you pay each employee and...