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

Metropolitan zoo gift shop weekly payroll

06/11/2020 Client: papadok01 Deadline: 24 Hours

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:

Peter O.
A+GRADE HELPER
Writer Writer Name Offer Chat
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$55 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

Greetings! I’m very much interested to work on this project. I have read the details properly. I am a Professional Writer with over 5 years of experience, therefore, I can easily do this job. I will also provide you with TURNITIN PLAGIARISM REPORT. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks!

$55 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

Connected mcgraw hill school c3p0 - Zipcar is an example of what type of market orientation - Big mama's chicken st agnes - Assignment 2 10/1/20 1 page, 3 paragraphs - Hy dairies case study analysis - Why do alkanes and alkenes have similar physical properties - Professional working proficiency meaning - R Studio Lab 5 - Pamela smith university of cumberlands - Markup is measured either as a percentage of ____ or a percentage of ____. - Australian masked owl call - Aussie rules football poems - Tennis court fencing specifications - Gym full body workout plan pdf - Thirty year treasury bond rate - Fire hydrant paint specification - Manifest destiny political cartoon - Substitute for nichrome wire - Ethical Dilemma Project: Case Selection - The world is flat business perspective - A narrow fellow in the grass questions and answers pdf - Matlab state space simulation - Describe the role of three external services during an emergency - Financial analysis - Small assignment - Create a directory called iso in your home directory - Database systems design implementation and management chapter 3 answers - Question and reply - Iq standard deviation percentile - Peter's pool service - Webassign customer service number - Pave the planet or wear shoes - The mean incubation time of fertilized eggs is - Loreal majirouge mixing ratio - Continuum of managed health care plans - Caribbean cooler cocktail recipe - Multimodal Personal Narrative - Stoke mandeville hospital ophthalmology - C229 obesity time log - Mark iv industries gmbh - Journal Assignment - Urgently Required - A + Work. Zero Plagiarism - Need the Work in 20 Hours Max - A firm that is a pure monopoly is - Internet for it governance planning - If by rudyard kipling analysis line by line pdf - Insider's guide to academic writing - Acc 561 managerial analysis green pastures - Essay about Franklin and Douglass - The strange case of anna stubblefield - Boston deep sea fishing v ansell case summary - Strategic group map restaurant industry - My virtual child paper 1 - Bsbwor502 assessment 1 - Https illuminations nctm org adjustablespinner - 3 phase transformer short circuit test - Physical asset controls in the space maritime - Ethical dilemma vs ethical issue - Michael bousis net worth - Understanding pathophysiology 1st edition - Kaplan university course catalog - Carlo carlei romeo and juliet quotes - Report - Lippits change theory - DiscussionB 6-2 - Fm 4 95 logistics operations - Market segmentation of coca cola pdf - Nursing Care Plan - Acid catalysed dehydration of an alcohol forming an alkene - A specimen of aluminum having a rectangular - How are independent and chain pharmacies alike quizlet - Absolutists derive pleasure from listening for the way - Procurement Law - Arduino write to csv - Katy perry boom boom - Statistical approach to normality - Pm international business plan pdf - NUR601 MODULE 6 DISCUSSION - Dynamic processes support operational activities - Man and superman summary sparknotes - Lord we gather today - Celta assignment focus on the learner example - Bt employer super pds - A los puertorriqueños les encanta visitar los ríos del yunque. - Active Directory Recommendations - I have to do the list activity , AON ,PERT and the budget of the project - Richard taylor restoring pride pdf - The miramar company is going to introduce - The great gatsby main idea - Dynon hdx installation manual - Are you Looking to pay someone to do my essay? - The academic writing reader saint leo university - IT project ticketing system - Uk driving licence template photoshop free - Geometry ( NEED HELP ASAP) 15 questions - Managerial economics and organizational architecture 6th edition free download - Point of view assessment - Citizens bank app error 130033 - Practice of leadership lululemon - Anatomy and physiology final project ideas - Research - Pursuit of happyness movie length