× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
c
5
j
5
a
5
L
5
f
5
j
5
D
4
k
4
y
4
t
4
h
4
l
4
Home Q & A Board Other Fields Homework Help Business
New Topic  
emilyencar11 emilyencar11
wrote...
Posts: 374
Rep: 0 0
6 years ago
A payroll register has the employees' names in Column A, Social Security numbers in Column B, hourly wages in Column C, regular hours in Column D, and overtime hours in Column E. If overtime is paid at time-and-a-half, what formula should be entered in Column F for regular pay, Column G for overtime pay, and Column H for gross pay? Use Row 1 in all formulas.

Q. 2

LeMonte earns 239.60 each week. He lives in a state with a state income tax. If LeMonte had 9.59 taken out of his check for state tax last week, what is the state income tax rate to the nearest hundredth percent?

Q. 3

Tracy works from home entering data into the computer. She is paid 2.75 for each page she enters. In the past two weeks she has entered the following number of pages: 135, 187, 110, 213, and 161. What are her gross earnings?

Q. 4

Nigay earns a biweekly salary of 830 plus 11 commission on net sales over 5,000. His total sales in the past two weeks were 16,390 with 2,560 in returned sales. What are Nigay's gross earnings for the two-week period?
Read 50 times
2 Replies

Related Topics

Replies
wrote...
#1
6 years ago
Ans. #1

Column F: =C1D1
Column G: =1.5C1E1
Column H: =F1+G1

Ans. #2

4;
Divide the part, 9.59, by the whole, 239.60, for the rate. Multiply by 100 for the percent.

Ans. #3

2,216.50;
806  2.75 = 2,216.50

Ans. #4

1,801.30;
16,390 - 5,000 = 11,390; 11,390 - 2,560 = 8,830;
8,830  0.11 = 971.30; 830 + 971.30 = 1,801.30
emilyencar11 Author
wrote...
#2
6 years ago
White Checkmark
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  935 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 637
  
 5506
  
 368