subject
Business, 17.12.2020 14:00 mrnotsosmart2787

PLEASEEE HEEELLLPPP MCreate 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.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 03:00
Working with a word processor requires more than just a knowledge of typing. a good word processor includes a number of tools designed to aid in formatting documents to meet the needs of the reader. in this project you will use your word-processing skills and a basic knowledge of apa style to format a research paper. the skills you will need for this project include the following: adjusting line spacing (double-spacing) breaking text into pages (page break) centering text changing the font, style, and size of the text editing text inserting page numbers inserting a table using spell check
Answers: 1
question
Business, 22.06.2019 16:50
Arestaurant that creates a new type of sandwich is using (blank) as a method of competition.
Answers: 1
question
Business, 22.06.2019 20:10
Assume that a local bank sells two services, checking accounts and atm card services. the bank’s only two customers are mr. donethat and ms. beenthere. mr. donethat is willing to pay $8 a month for the bank to service his checking account and $2 a month for unlimited use of his atm card. ms. beenthere is willing to pay only $5 for a checking account, but is willing to pay $9 for unlimited use of her atm card. assume that the bank can provide each of these services at zero marginal cost.refer to scenario 17-5. if the bank is unable to use tying, what is the profit-maximizing price to charge for a checking account
Answers: 3
question
Business, 22.06.2019 22:50
For 2016, gourmet kitchen products reported $22 million of sales and $19 million of operating costs (including depreciation). the company has $15 million of total invested capital. its after-tax cost of capital is 10%, and its federal-plus-state income tax rate was 36%. what was the firm’s economic value added (eva), that is, how much value did management add to stockholders’ wealth during 2016?
Answers: 1
You know the right answer?
PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pa...
Questions
question
Mathematics, 28.05.2020 05:01
question
Physics, 28.05.2020 05:01
question
Mathematics, 28.05.2020 05:01
Questions on the website: 13722363