Multiple Choice 10-2 Excel Spreadsheets: SA 10-1, SA 10-2, SA 10-3 Excel Tutoria
ID: 2600387 • Letter: M
Question
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 Flowers Corporation has a single employee, S. Singh. Singh worked for 47 hours during the week, of which seven hours were overtime. Singh is paid $19.40 per hour. Overtime hours are paid at a rate of 150% of straight time. Additional information for Singh is as follows:
The social security tax rate is assumed to be 6% on all employee earnings. The Medicare rate is assumed to be 1.5% on all employee earnings.
Open the Excel file SA10-1.
Prepare a spreadsheet to compute the weekly gross pay, deductions, and net pay for S. Singh.
When you have completed the pay calculations, perform a “save as,” replacing the entire file name with the following:
SA10-1_[your first name initial]_[your last name]
SA 10-2: Computing employee net pay, multiple employees
The Myatt Companies prepared the following weekly schedule for its three employees:
The social security rate is assumed to be 6% on all employee annual earnings. The Medicare rate is assumed to be 1.5%.
Open the Excel file SA10-2.
Prepare a spreadsheet to compute the weekly gross pay, deductions, and net pay for each employee.
When you have completed the pay calculations, perform a “save as,” replacing the entire file name with the following:
SA10-2_[your first name initial]_[your last name]
SA 10-3: Computing employee net pay, multiple time periods
Repair-It-for-U has a single employee, Josh Reed, who has the following weekly payroll information for four weeks:
Reed had a pay rate of $16 per hour and an overtime premium of 150%. The social security tax rate is assumed to be 6% of employee earnings. The Medicare tax rate is assumed to be 1.5% of employee earnings.
Open the Excel file SA10-3.
Prepare a spreadsheet to compute the weekly gross pay, deductions, and net pay for each week.
When you have completed the pay calculations, perform a “save as,” replacing the entire file name with the following:
SA10-3_[your first name initial]_[your last name]
When calculating Gross Earnings, what values are necessary?
a.Total hours worked times hourly rate plus overtime hours worked times hourly rate times overtime premium
b.Hours worked (straight time) plus overtime hours worked times hourly rate times overtime premium
c.Total hours worked times hourly rate times overtime premium times overtime hours
d.(Hours worked (straight time) times hourly rate) plus (overtime hours worked times hourly rate times overtime premium)
Federal income tax (weekly withholding) $201.30 Retirement savings (weekly) 75.00 Earnings prior to payroll period 27,950Explanation / Answer
When calculating Gross Earnings, (Hours worked (straight time) times hourly rate) plus (overtime hours worked times hourly rate times overtime premium) Option D is correct
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.