Question: Inputs M. Todd J. Kress V. Johns Hours worked stright-time 40 40 40 Hours worked overtime 6 12 0 Hourly rate $24.00 $30.00 $16.50 Overtime

Inputs M. Todd J. Kress V. Johns Hours worked stright-time 40 40 40 Hours worked overtime 6 12 0 Hourly rate $24.00 $30.00 $16.50 Overtime premium 200% 150% 150% Weekly withholding $218.42 $278.32 $186.45 Earnings prior to payroll period $68,915 $71,725 $32,710 Retirement savings $60.00 $150.00 $50.00 Social security rate 6.0% Medicare rate 1.5% Outputs M. Todd J. Kress V. Johns Gross earnings for the week Deductions: Social security tax Medicare tax Federal income tax withholding Retirement savings Total deductions Net pay a. Enter in B16 the gross earnings formula b. Enter in B18 the formula for social security tax. You will need to use the $ sign in your formula for an absolute cell reference. c. Enter in B19 the formula for the Medicare tax. You will need to use the $ sign in your formula for an absolute cell reference d. Enter in B20 the cell reference for federal income tax withholding. e. Enter in cell B21 the formula for retirement savings. f. Enter in cell B22 the formula for total deductions. g. Enter in cell B23 the formula for net pay. h. Copy the formulas in cells B16:B23 into the remaining unfilled cells to complete the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Allocating Payments and Receipts to Fixed Asset Accounts The following payments and receipts are related to land, land improvements, and buildings acquired for use in a wholesale ceramic business....

Multiple Choice 10-2 Excel Spreadsheets: SA 10-1, SA 10-2, SA 10-3 Excel Tutorials: Current Liabilities and Payroll, Absolute and Relative Cell References SA 10-1: Computing employee net pay JK...

= " Sample Federal Withholdihg Tax Tables (Partial) for Single PersonsWeekly Payroll Period SINGLE PersonsWEEKLY Payroll Period {For Wages Paid Through December 20x11 If the wages are And the number...

226 Payroll Accounting Chapter 7: Comprehensive Projects --Paper Based Vers One-Month Project NOTE! Templates needed to complete these exercises, including one containing year-to-date payroll data,...

WAGE AND HOUR DIVISION UNITED STATES DEPARTMENT OF LABOR Guidance for Private Employers on Changes to the White Collar Exemptions in the Overtime Final Rule May 18, 2016 Introduction The Department...

please help! ... i need this by tomorrow at 10:30am!!! please help... please help!!! thanks Pdx Inc. is paying payroll for their employees on monthly basis. They're also on a Monthly Depositer plan...

complete the 941 for the 4th quarter. note that based on the look back period.. complete Form 941 for the 4th quarter. Note that based on the lookback period, the company is a monthly depositor....

3. At Haddon, Inc., the office workers are employed for a 40-hour workweek and are paid on either an annual, monthly, or hourly basis. All office workers are entitled to overtime pay for all hours...

Let X1, . . . , Xn be a random sample from the Poisson distribution with mean . Let Y = a. Prove that there is no unbiased estimator of 1/. (Write the equation that is equivalent to E (r(X)) = 1/....

1. What are the important brands that PepsiCo owns? Which ones did they acquire? Which ones did the company develop internally? 2. How are the beverages organized into groups? 3. How are the...

list 2 expenses that are included in the operating expense budget but are excluded from cash payments of operating expenses

The main premise of Utilitarianism is . . . Group of answer choices The ethically correct action is the one that produces the greatest amount of pleasure for the greatest number of people. The...

The redecorated offices look (good, well). Review Section 1.5 in the Handbook of Grammar, Mechanics, and Usage and then complete the following 15 items. For the following items, indicate the correct...

Could they be (happily) employed than they are now? For the following items, provide the correct form of the adverb in parentheses.

Completing: Designing for Readability; Media Skills: Blogging [LO-5] Compare the home pages of Bloomberg and MarketWatch, two websites that cover financial markets. What are your first impressions of...