Business
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.

answer
Answers: 3

Other questions on the subject: Business

image
Business, 21.06.2019 14:00, thelordoftheknowwjo4
Forty-two percent of federal revenue comes from . income taxes paid by businesses and corporations make up about of federal revenue. taxes collected for social security and medicare make up of federal revenue.
Answers: 1
image
Business, 21.06.2019 17:50, ineedhelp2285
When selecting stock, some financial experts recommend to look at the opening price go with what you know examine the day’s range, earnings per share, and p/e ratio divide the dividend by the asking price
Answers: 2
image
Business, 22.06.2019 07:50, pattydixon6
The questions of economics address which of the following ? check all that apply
Answers: 3
image
Business, 22.06.2019 07:50, kristinaholahan
Budget in this final week, you will develop a proposed budget of $150,000 for the first year of the program and complete the final concept paper for the proposed program due for senior management review. the budget should identify the program's anticipated expenses for the year ahead. budget line items should be consistent with the proposed program and staffing plan. using the readings for the week, the south university online library, and the internet, complete the following tasks: create a proposed budget of $150,000 for the first year of the proposed program including the cost for personnel, supplies, education materials, marketing costs, and so on in a microsoft excel spreadsheet. you may transfer your budget to your report. justify the cost for each item of the proposed budget in a budget narrative.
Answers: 2
Do you know the correct answer?
PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pa...

Questions in other subjects: