Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Ex16_xl_ch02_grader_ml1_hw metropolitan zoo gift shop weekly payroll 1.2

27/10/2021 Client: muhammad11 Deadline: 2 Day

Grader - Instructions Excel 2016 Project

EX16_XL_CH02_GRADER_ML1_HW - Metropolitan Zoo Gift Shop Weekly Payroll 1.3
Project Description:
As manager of the gift shop at the Metropolitan Zoo, you are responsible for managing the weekly payroll. Your assistant developed a partial worksheet, but you need to enter the formulas to calculate the regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay. In addition, you want to include total pay columns and calculate some basic statistics. As you construct formulas, make sure you use absolute and relative cell references correctly in formulas.

Steps to Perform:
Step

Instructions

Points Possible

1

Open the downloaded file exploring_e02_grader_h2.xlsx.

0

2

Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

20

3

Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (B24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40.

10

4

Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E25. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay.

20

5

Calculate FICA in cell J5 based on gross pay and the FICA rate (cell B23), and calculate the net pay in cell K5. Copy all formulas down their respective columns to row 16.

10

6

With the range E5:K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row 17. Note, Mac users, with the range selected, on the Home tab, in the Editing group, click AutoSum.

10

7

Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row. Apply the Comma style to the monetary values for the other employees. Underline the last employee’s monetary values and use the Format Cells dialog box to apply Top and Double Bottom border for the totals.

5

8

Insert appropriate functions to calculate the average, highest, and lowest values in the Summary Statistics area (the range I21:K23) of the worksheet. Format the # of hours calculations as General number format with one decimal and the remaining calculations with Accounting number format.

15

9

Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the worksheet.

5

10

Save and close the workbook. Submit the file as directed.

0

Total Points

95

Created On: 07/05/2019 1 EX16_XL_CH02_GRADER_ML1_HW - Metropolitan Zoo Gift Shop Weekly Payroll 1.3

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Fatimah Syeda
Online Assignment Help
Top Academic Guru
Assignment Helper
George M.
Engineering Help
Writer Writer Name Offer Chat
Fatimah Syeda

ONLINE

Fatimah Syeda

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$16 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$49 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$35 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$27 Chat With Writer
George M.

ONLINE

George M.

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$27 Chat With Writer
Engineering Help

ONLINE

Engineering Help

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Outsourcing is a logical extension of david ricardo's 1817 - Goals for risk for impaired skin integrity - English is a crazy language - Ethos pathos logos advertisement essay - Blanket at end of bed called - Challenges of maintaining information security at a remote recovery location - Citizen kane breakfast montage - Human resource management essay questions and answers - Good night and good luck and the crucible comparison - Discussion question - Algebra Talk - Foua and nao kao lee - Anzac 75th anniversary $5 coin value - Bulleh shah on love - , All Quiet on the Western Front - Community engagement acu - How to make a perspective sculpture - Accon pop up stainless steel bow light 204 m series - Api collapse pressure equations - Battery charger diode circuit - Prince charles hospital physiotherapy - Wilmington grammar sixth form - Chemical storage cabinet blackwoods - Learning Theories & applications - Weeko 15 - Calibration of energy meter - Byu independent study proctor - Design and analysis of experiments solutions - Rwi sound mat set 1 - Carl jung man and his symbols - Gap inc gallatin tn - Do fish feel pain when hooked - Free equipment hire agreement template australia - What are the main characteristics of an erp system - 1.62 m in feet - Computer parts diagram worksheet - Leadership discussion 1 - Under armour marketing strategy 2012 - My grandma told me bliss n eso - Artificial rupture of membranes nursing interventions - Csp bonded school leaver entry - ME - Main - Dis 2 - Academy of emergency dispatch - Mortgage broker license ontario - As05 salary south australia - The underground seamus heaney analysis - Reliability - International management culture strategy and behavior free pdf download - Cpu scheduling algorithms questions and answers - Iodine clock reaction lab report discussion - COMPUTER SECURITY_week7 - Pr 6 1a fifo perpetual inventory - Paper - How to prevent channel stuffing - Monica geller engagement ring replica - How are independent and chain pharmacies alike quizlet - Journal 4 - High school dropout rates essay - Class ring stone colors - Which recorder is least recommended in automation anywhere coursehero - Write a Press Release for Me! - A single shard summary - Which lightens stains better vinegar or lemon juice science project - The Ritz-Carlton Hotel Company: The Quest For Service Excellence - Aih moodle - Duty of trust and confidence cipd - The work done on a slingshot is 40.0 joules - Prepare a summary journal entry to record raw materials used - Naidoc week ideas for schools - Freud erikson piaget kohlberg chart - Caroline springs leisure centre - Summarizing a Written Rhetorical Text - Which of the following procedures can be used to prevent and detect a register disbursement scheme? - 8 hours time to complete - CSIA 300 Research Report 1 - Discussion - Ask homework questions online free - My byte pty ltd collingwood - Civilization - Mha 516 4 - The norton introduction to literature twelfth edition - Answer the follwing questions in 600 to 700 words - What is a provider sponsored organization - Are subheadings bolded in apa - Cryosurgical destruction of 10 flat warts on the hand - Discussion-4 - The marketing research department for a company that manufactures - Math 221 devry week 3 quiz - Things remembered reflections pen refill - Demographic segmentation variables for two wheeler industry - A lack of cooperation by oligopolists trying to maintain monopoly profits - Dragon's dogma vandals ring - When graphing cost volume profit data on a cvp chart - The greek marketplace where philosophy was debated was called - The hollow men setting - What happened to mildred at the end of fahrenheit 451 - What did greek theater originally celebrate - Single equation regression model - Chemical equation for water vapor - Prebles artforms 11th edition powerpoint