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

Celf-5 index score descriptions - Nutrition - Legacy of racism reflection essay - Scs 100 theme 1 comparison template - Discussion - Batten spacing for tiles - How to write a concert report sample - DISCUSSION QUESTIONS 1 & 2 - Homogeneous oligopoly exists where a small number of firms are - Bis 155 week 6 ilab - Business management vcaa study design - 7 steps ethical decision making process - Frito lay operations management in manufacturing - Set m application form - Quick write - Trailing vs forward pe - Family resources definition - Psychologyy - Ipers asset allocation calculator - Postmodern frame in art - Hebel cost per m2 - Quantim ahima org - Cwv ethical dilemma essay abortion comparison - What are the 4 p's of marketing - Guide to federal pharmacy law 9th edition ebook - Icd 10 code bacterial vaginitis - Complaints officer job description - Individual & Dual Movement 2 - Project management simulation scope resources and schedule solution - Leadership Theories in Practice - Mother wit - Scholastic active english coursebook 7 answers - Gcse art and design themes - Acara work samples year 3 writing - Chlorsig 1 eye ointment - Fighter sponsorship proposal template - Indian education sherman alexie answers - Non elastic impression materials - Correlating rock layers using index fossils worksheet answers - Filipino tattoos ancient to modern - Frequency histogram and polygon - 1776 massachusetts liberty and virtue coin - Rolled or raked mortar - 23 south wharf promenade south wharf vic 3006 - Royal children's hospital graduate program - Compensatory stage of shock - She dwelt among the untrodden ways analysis sparknotes - Different assessment tools in nursing - In painting and drawing artists often use the technique of - Calculate the absolute value of the test statistic for b1 - Blue skinned race in avatar crossword clue - The gangster we are all looking for chapter 4 summary - Calculate patient acuity - How to write a soap note for nurse practitioners - Hy dairies case study solution - CEER - Discussion Questions - Potter and perry fundamentals of nursing 9th edition apa citation - I need 6 responses to class mates discussion questions. 150 word min with references if needed - Lesson 1.2 displaying categorical data answer key - 3.2 material certification requirements - Google docs to slides - Cauchy euler differential equation problems - Comprehensive problem 2 palisade creek co answers - Discussion - 235 85r16 trailer tires walmart - Assignment: Application of Attachment Theory to a Case Study - Stubhub failed to load shipping label - Movie recommendation system report - Domain and Parent/Caregiver Interview - Reflected light sheen crossword - The task of stitching together a strategy - Concise australian commercial law 6ed - Beyond stress strategies for blissful living pdf - The History of Corrections in America. - Strategic job analysis and competency modeling - Radioactive dating game phet answers - Case study - Pig dissection circulatory system - Musculoskeletal - Economists assume that monopolists behave as - Optimizing Your Walmart FBA Listings for Maximum Visibility - Support activities and primary activities - Bakra beverage negotiation - Module b essay questions - There are two factories located at p and q - Iolp level 3 example - Prepare income statements for each year using absorption costing - The prior probabilities for events a1 and a2 are - Lamar swimwear comprehensive problem - Argumentative essay about food - Leasa brand black eyed peas - Gedling access road map - Apply: World Economies Comparison Presentation - Assignment - The breadwinner novel study - Raritan valley community college programs - Hays addressing framework - Econ 304 psu - When was the quadruple aim introduced