ch05qz01a - e Enter formulas in Column I to calculate...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name  ______________________________ Date ______________________________ Chapter 05 - Quiz 01 MAGIC CARPET THEATER Payroll Register Hours Worked Earnings Deductions Name Allowances Worked Rate Regular Overtime Medicare 6.20% 1.45% Bates, N 0 40 6.50 $260.00 $0.00 $260.00 $14.00 $16.12 $3.77 $12.50 $46.39 $213.61 Davis, B 2 45 5.75 $230.00 $43.13 $273.13 $4.00 $16.93 $3.96 $12.50 $37.39 $235.73 Green, A 1 42 8.00 $320.00 $24.00 $344.00 $16.00 $21.33 $4.99 $12.50 $54.82 $289.18 Directions: a. Enter formulas in Column E to calculate Regular Earnings. b. Enter formulas in Column F to calculate Overtime earnings. c. Enter formulas in Column G to calculate Gross Earnings. d. Use the wage bracket method for Federal Income Tax. Assume all employees are married. Record this information in Column H.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: e. Enter formulas in Column I to calculate Social Security. f. Enter formulas in Column J to calculate Medicare. g. Enter $12.50 per week in Column K for Medical Insurance for each person. h. Enter formulas in Column L to calculate Total Deductions. i. Enter formulas in Column M to calculate Net Pay. Format all answers to Currency. Set Decimal places to 2. Set Currency symbol to None. Gross Earnings Federal Income Tax Social Security Medical Insurance Total Deducted Net Pay j. Save the file as ch05qz01a.xls. A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23...
View Full Document

This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online