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

Crainer crazy craft 2.0 ep 15 - Dampers in series and parallel - How many children did gwen harwood have - Obtain vo for each of the op amp circuits - English - Opposite of hyperbole in literature - Introduction to search and rescue - Time Bomb Case - Mi casa su casa meaning - Chartered banker mba cost - Equifax data breach 2017 case study - Vcaa data booklet chemistry - In praise of the f word argumentative essay - Discussion - Conscious capitalism - Cloud Computing challenges and solution Need in 3 hours - Discussion response - Case Study Potential Actions - Accounting information systems controls and processes 3rd edition test bank - Presidential agendas discussion - Infant observation report example - Aldehydes and ketones are - Purnell's cultural domain communication includes - Questionnaire on cashless society - Bicsi manual free download - How is elasticity related to logarithms - Sales revenue may be recorded before cash is collected - Totusoft lan speed test review - Assignment 2 social control and criminal deviance bullying - Kidney shortage inspires a radical idea organ sales - The other side is not dumb summary - Pattern design software free - 52 foch street mowbray - Indesign publish online page transitions - Post its notes on a marriage summary - Pearson schools and colleges - Rp2_dsdba - Conversion chart miles to kilometers - GLOB (U3_RPL) - 106a pulsford road prospect - Star reading test results - Draw the marginal cost curve - Cost of racq vehicle inspection - My last duchess poetry foundation - Hairy bikers eve's pudding - 12 1 6 as a fraction - How to calculate training man hours per employee - Request for Reconsideration - Literature review for the below topic - Grade 7 math philippines - Loreto grammar school staff list - Castles for sale in belarus - Henry's daughters - Tc beirne school of law - 4 methylcyclohexanol to 4 methylcyclohexene - Atom economy practice questions - BSWP Week 2 - Business law essay questions and answers - The crucible film analysis worksheet answers - Basildon council collection of large items - Psychology vce study design - Https www sfu ca palys miner 1956 bodyritualamongthenacirema pdf - Nsw health internal vacancies - Pangea cut out activity - Create a brochure for parents and community members that illustrates the main points of Sheltered English Immersion - Jb hi-fi mobile plan $65 - Ness ncl ac uk - One Paragraph Discussion - Urgent - What's driving porsche case study - Inner beacon moreton bay - Conch republic electronics case - Cys6paper - Beulah ecton woodard - Environmental Science - HOMEWORK2 - Dr phil amanda jim justine full episode - How do you use a dial caliper - Amazon sales profits during Covid-19 - Microeconomics - Saving the bees persuasive speech - What is marketing? What is strategic planning? - Ruined temple diablo 2 - Cattle reproductive system ppt - Zinc plus oxygen balanced equation - Week 6 Final - Need help writing classification essay - Sas 180 air sampler manual - Anu finance economics and statistics - Cite your sources using apa format week 5 assignment - Guru gobind singh ji 52 hukam in hindi - 1000 micrograms to mg - Hau lee supply chain uncertainty framework - Excel work- Exp19_Excel_Ch05_Cap_Apartments - 1000 words 10 hrs - Clinical Field Experience B: Phonics and Word Recognition: I Do, We Do, You Do - Hot coffee movie summary - Essay Writing - What is the greatest common factor of 12a and 9a2 - What are the major sources of error