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

On what basis are misdemeanors and felonies distinguished - Difference between ethical dilemma and ethical issue - Jpeg ls compression algorithm - Magnet falls through copper pipe - Toby's trucking company determined that the distance traveled - Pictures of camp green lake - Bloomberg bmc questions and answers - Sociology - When you were processing the USB drive belonging to a Triton Corporation employee for potential child pornography, you recieved a phone call from the Grantham Police Department advising you that they have an active criminal investiagation on the employee. - End of probation review sample - A rush to judgement case study answers - Business law - Evan company reports net income of - Ms project mobile app - Guided reading group lesson plan - What is the sum of 9260 and 3240 - Decidimos venir a este restaurante porque mi jefe - On course study skills plus 2nd edition pdf - Area coloring activity - Smith and liehr middle range theory - Unit 6 - Harley mission statement - Entrapment defense case briefs - Chapter 7 review what is the adjusted hospital autopsy rate - Aqua dragons fully grown - Hltaap001 - What is 70kg in pounds - Pump start stop logic diagram - Netezza select into table - Map of sydney olympic park - Kenneth w graves 87 tcm 1409 tc memo 2004 140 - Question - Which of the following best describes a virus - Motivation letter for master's in information technology - Overcoming the monster story examples ks2 - Quotes on the waterfront - General hydroponics ph up ingredients - Weekly Summary 4 - Disaster managment - Network cable color code - Ethical issues in psychological assessment ppt - Window on humanity 7th edition pdf - The following details have been extracted from the budget of a merchandising company. - Factorial of negative number - What plants live in the central valley region of california - Morrisons distribution centre swan valley - Second step program research - Bd order of draw - Sarah palin is a cunt - Gross death rate - Let the carnival begin every pleasure every sin - Volclay waterstop rx 102 - Transistor as an amplifier animation - Polesworth school term dates - Questions - 5.1 kg in pounds - Two Separate Assignment - Henri claude cosmetics case study - Logan products computes its predetermined overhead rate - The lady of shalott part 3 summary - Simple 5 paragraph essay - When does macduff kill macbeth - Principles of Industrial and Organizational Psychology - Beis yaakov high school - Mark twain how to tell a story answers - Abc company income statement - Sonja is being treated by her psychiatrist - Figurative language in literature examples - 02.01 revolutionary ideas: assessment - Discussion - His 200 snhu - 123 queen street melbourne pte - Hw - Jeff nippard training program - Prior service cost journal entry - What are the components of a healing hospital - Grid for learning herts - Best interest duty checklist - Electricity consumer safety regulation 2006 - Health Data Ownership - North south east west compass - 1560 billion in scientific notation - Reply to this discussion- Nikeria - Foreign Trade Versus Foreign Investment - Layers of the earth worksheet pdf - Microsoft publisher vs indesign - Levett jones clinical reasoning cycle - Keurig green mountain castroville ca - Current event summary - Histogram polygon bar graph - Cbt nuggets icnd1 labs - Annual report of cadbury 2016 17 - Competitive priorities in operations management pdf - Erau accident reports - Which of the following best describes vizio's supply chain - Webi reports best practices - Don't have employment separation certificate - Mackay hose catalogue pdf - Chapter 3 checkpoint questions introduction to java - Lloyd's titan mech kmart