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.

Answers

Answer 1

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell E5 is =IF(D5<$B$21,D5,$B$21) * C5The Excel formula to enter in cell E5 is =IF(D5>$B$21,(D5-$B$21) * C5 * $B$22, 0)The regular pay

From the complete question, cell B21 represents base work hour

So, we start by checking if the work hour in cell D5 is less than the base work hour in cell B21

If yes, the work hour remains D5; otherwise the work hour is cell B21

The work hour is then multiplied by the rate in cell C5

Hence, the Excel formula to enter in cell E5 is =IF(D5<$B$21,D5,$B$21) *

The overtime pay

Here, we start by checking if the work hour in cell D5 is greater than the base work hour in cell B21

If yes, the overtime hour the difference between D5 and B21; otherwise the overtime hour and pay is 0

The over time hour if there is, is then multiplied by the rates in cells C5 and B22

Hence, the Excel formula to enter in cell E5 is =IF(D5>$B$21,(D5-$B$21) * C5 * $B$22, 0)

Read more about Excel formulas at:

brainly.com/question/1285762


Related Questions

the length of a quarter is .955. Round .955 to the nearest tenth of an inch

Answers

Answer:

1.0 inch

Step-by-step explanation:

Round the 9 in 0.955, this turns it into 1.0, Since you said an inch, the value will be in inches.

Answer:

1.0in is your answer!

Step-by-step explanation:

the person above me explained it good enough

Does the expression
(41+6)
also represent the
2
number of females on the team this year? Explain.

Answers

Answer:

Yes

Step-by-step explanation:

Yes; Dividing by 2 is the same as multiplying by [tex]\frac{1}{2}[/tex].

Find the length of the bolded arc if the radius is 4cm and the angle is 118 degrees.

Answers

Answer:

8.23 cm

Step-by-step explanation:

A circle is given to us and we need to find out the length of the bolded arc . The arc subtends an angle of 118° at the centre . And the radius of the circle is 4cm .As we know that , length of the arc is given by ,

[tex]\longrightarrow Length_{arc}= \dfrac{\theta}{360}\times 2\pi r [/tex]

Here ,

Angle is 118° . Radius is 4cm .

On substituting the respective values,

[tex]\longrightarrow Length_{arc}=\dfrac{118^o}{360^o}\times 2(3.14)(4cm) [/tex]

Simplify ,

[tex]\longrightarrow Length_{arc}= 0.3277 \times 25.18 \ cm [/tex]

Multiply ,

[tex]\longrightarrow \underline{\underline{Length _{arc}= 8.23 \ cm}} [/tex]

This is the required answer!

DIG DEEPER A vehicle travels 250 feet every 3 seconds. Find the value of the ratio the unit rate, and the constant of
proportionality.
The value of the ratio is ( )
The unit rate is ( )
feet per ( )
second
The constant of proportionality is ( )

Answers

Answer:

83.33 or 83.3 feet per second

Step-by-step explanation:

250 feet/3 seconds = 83.33 ft per second

$13.56 is what percent of $16.95?

Answers

Answer:

$13.56 is 80% of $16.95.

A 48°

B (6x−28)°

C (2x)°

Find the value of x. Then find the measures of angles B and C.




Enter your answers in the boxes.


x =


​m∠B=​

º


​m∠C=​

º

Answers

Answer:

x = 20, angle B = 92 and angle c = 40

Step-by-step explanation:

3 angles in a triangle adds up to 180, and since A is 48, we have B + C = 132

6x - 28 + 2x = 132
=> 8x - 28 = 132
=> 8x = 160 and x = 20

B = 6 x 20 - 28 = 92
C = 2 x 20 = 40

You ask 40 students which of three items from the cafeteria they like the best. You record the results on the piece of paper shown.

Result of a survey on a paper. First line. What is your favorite cafeteria food? Second line. Pizza: 30 percent. Third line. Pasta: 18 students. Fourth line. Salad: 10 students.

How many students answered pizza?

students answered pizza.

Skip to navigation





























































You ask 40 students which of three items from the cafeteria they like the best. You record the results on the piece of paper shown.

Result of a survey on a paper. First line. What is your favorite cafeteria food? Second line. Pizza: 30 percent. Third line. Pasta: 18 students. Fourth line. Salad: 10 students.

How many students answered pizza?

students answered pizza.

Skip to navigation























































You ask 40 students which of three items from the cafeteria they like the best. You record the results on the piece of paper shown.

Result of a survey on a paper. First line. What is your favorite cafeteria food? Second line. Pizza: 30 percent. Third line. Pasta: 18 students. Fourth line. Salad: 10 students.

How many students answered pizza?

students answered pizza.

Skip to navigation





























































You ask 40 students which of three items from the cafeteria they like the best. You record the results on the piece of paper shown.

Result of a survey on a paper. First line. What is your favorite cafeteria food? Second line. Pizza: 30 percent. Third line. Pasta: 18 students. Fourth line. Salad: 10 students.

How many students answered pizza?

students answered pizza.

Skip to navigation





























































You ask 40 students which of three items from the cafeteria they like the best. You record the results on the piece of paper shown.

Result of a survey on a paper. First line. What is your favorite cafeteria food? Second line. Pizza: 30 percent. Third line. Pasta: 18 students. Fourth line. Salad: 10 students.

How many students answered pizza?

students answered pizza.

Skip to navigation

Answers

Answer:

12

Step-by-step explanation:

30% of 40=12

Explain Direct Variation. What does “k” equal?

Answers

Answer:

In y = kx, where k is the constant of proportionality.

Answer:

k is the constant

Step-by-step explanation:

Direct variation is simply explained as when a number is directly proportional to another number. For example, when 8 is directly proportional to 4 then it will result to

=> 8= k4, where k is the constant

=> divide both sides by 4 to get k

=> k= 2

A rectangle is 10 feet long by 2 feet wide.
If 3 feet are removed from the length of t
would be the area, in square feet, of the
You can earn 1 coin

Answers

Answer:

14 ft²

Step-by-step explanation:

To find the area of a rectangle you multiply the length and width. Sense the length is 10 feet but 3 feet was removed it is now 7 feet. Now you multiply that 7 feet by the width of 2 feet to get

7×2=

Area= 14 ft²

Find the area of the rectangle below
length = 11 in
width = 17 in

Answers

Answer:187

Step-by-explanation: width multiply by height

=11 times 17

=187

Which expressions are equivalent? chose all that apply.

Answers

Answer:

7.7.7.7 and 7^4 and seven to the fourth power

Step-by-step explanation:

They all equal 2401.

They are all the same but in different forms:

(7.7.7.7- expression)

(7^4 - exponential form)

(seven to the fourth power-word form of exponent)

please help mee out hereeee

Answers

Answer:x=125

Step-by-step explanation:

180-55=125

Answer:

Step-by-step explanation:

x+55=180[Sum of linear pair]

x=180-55

x=125

Admission to the school dance is $4.00. There is a picture booth at the dance, and each picture costs $1.50. Maria has $10.00. Which inequality represents the number of pictures, p, that Maria can purchase at the dance with admission?

A. 4.00p + 1.50 ≥ 10.00

B. 4.00 + 1.50p ≤ 10.00

C. 4.00p + 1.50 ≤ 10.00

D. 4.00 + 1.50p ≥ 10.00

Answers

Answer: B) 4.00+1.50p less or equal to 10.00
The inequality that represents the number of pictures that Maria can purchase is D.


help with part b pls thank u

Answers

Answer:

See below

Step-by-step explanation:

speed = distance / timetime = distance / speed

a)

i)

Time taken at the first part:

105 / x

ii)

Time taken at the second part:

(190 - 105) / (x + 12) = 85/(x + 12)

b)

If time is 3 hours and 15 minutes = 3 1/4 hours = 13/4 hours, the equation is:

105/x + 85/(x + 12) = 13/44(x + 12)*105 + 4(85x) = 13x(x + 12)13x² - 604x - 5040 = 0

c)

Solve the equation:

13x² - 604x - 5040 = 0x = [604 ± √((-604)² + 4*13*5040) ]/26 =      [604 ± √626896]/26 =      [604 ± 791.77]/26x = (604 + 791.77)/26 = 53.68 km/h (taking positive root only)

d)

105/x = 105/53.68 h = 1.956 h = 1 h 0.956*60 min = 1 h 57 min (rounded)85/(53.68 + 12) = 85/65.68 = 1.294 h = 1 h 0.294*60 min = 1 h 18 min (rounded)

Answer:

see below

Step-by-step explanation:

Let t = time (in hours)

a) i)  First 105 km of journey

[tex]\mathsf{speed=\dfrac{distance}{time}}[/tex]

[tex]\implies x=\dfrac{105}{t_1}[/tex]

[tex]\implies t_1=\dfrac{105}{x}[/tex]

ii) Rest of journey

distance = 190 - 105 = 85 km

speed = [tex]x+12[/tex] km/h

[tex]\mathsf{speed=\dfrac{distance}{time}}[/tex]

[tex]\implies x+12=\dfrac{85}{t_2}[/tex]

[tex]\implies t_2=\dfrac{85}{x+12}[/tex]

b)  3 hours 15 minutes = 3.25 hours

[tex]\implies[/tex]  total time = [tex]t_1+t_2=3.25[/tex]

[tex]\implies \dfrac{105}{x}+\dfrac{85}{x+12} =3.25[/tex]

[tex]\implies \dfrac{105(x+12)+85x}{x(x+12)} =3.25[/tex]

[tex]\implies 105(x+12)+85x =3.25x(x+12)[/tex]

[tex]\implies 105x+1260+85x =3.25x^2 +39x[/tex]

[tex]\implies 3.25x^2-151x-1260=0[/tex]

multiply by 4:

[tex]\implies 13x^2-604x-5040=0[/tex]

c)

[tex]\textsf{quadratic formula} \ x=\dfrac{-b \pm\sqrt{b^2-4ac} }{2a}}[/tex]

[tex]\implies x=\dfrac{604 \pm\sqrt{(-604)^2-4(13)(-5040)} }{2(13)}}[/tex]

[tex]\implies x=\dfrac{604 \pm\sqrt{626896} }{26}}[/tex]

[tex]\implies x = 53.68, x=-7.22[/tex]

(to 2 decimal places)

d) time ≥ 0, therefore, x = 53.68 only

Substitute x = 53.68 into the expression for [tex]t_1[/tex] and solve for [tex]x[/tex]:

[tex]\implies t_1=\dfrac{105}{53.68}=1.955912... \textsf{hours}=\textsf{1 hr 57 min}[/tex]

PLEASE HELP!
Question:
Solve for x
(x+3)^2

Answers:
2x^2 + 3x + 2
x^2 + 6x + 9

Answers

Answer:

x² + 6x + 9

Step-by-step explanation:

(x + 3)² = (x + 3)(x + 3)

Each term in the second factor is multiplied by each term in the first factor , that is

x(x + 3) + 3(x + 3) ← distribute parenthesis

= x² + 3x + 3x + 9 ← collect like terms

= x² + 6x + 9


Lesson 8-2
In Items 15-18, identify the transformation from the
graph of f(x) = 2* to the graph of g(x).
15. g(x) = 2* – 3
16. g(x) = 2(x – 3)
17. g(x) = 2* + 4
18. g(x) = 2(x+4)

Answers

Do you ever just like munching on the pickle and a hot Tuesday comes in literally rip your face off

Use the fact that sin 38 ≈ 0.6157 to solve m.

cos m ≈ 0.6157

what is the value of m?

Answers

Answer:

52°

Step-by-step explanation:

We know that sine and cosine are equal when angles are complementary.

sin 38° = cos msin 38° = cos (90° - 38°) = cos 52°cos m = cos 52°m = 52°

sin and cos are equal when their sum is 90°

So

cosm=0.6125=sin38cos(90-38)=sin38cos52=sin38m=52°

(4 times 2 to the third power) - (64 divided by 8)

Answers

Answer:

24

Step-by-step explanation:

(4 times 2 to the third power) - (64 divided by 8) = 4*(2^3) - 64/8

= 4*8 - 8 = 32 - 8 = 24

The answer is 24

Hope this helps :)

Have a great day!

The tables show the height in
centimeters each plant grew during
a week. Assume the patterns continue.
Compare the growth in height of
each plant.

Answers

Answer:

  Plant B grows 3 times as fast as Plant A

Step-by-step explanation:

Both plants start at 0 height on Day 1 and grow the same amount each day. Plant A grows 2 cm each day; Plant B grows 6 cm each day. The growth rate of Plant B is 3 times the growth rate of Plant A.

which of the following is a rational number but not an integer
-9
0
-4.3
3

Answers

-4.3 is a rational number but not an integer.

Lily eats half a pound of cherries in 3/4 of a minute how many minutes will it take her to eat a full pound of cherries​

Answers

Answer: a minute and a half

Step-by-step explanation:

3/4 +3/4 is 6/4 which is 1 1/2 or 1 2/4

Lily eats 1/2 lbs in 3/4 min

Total pounds=1lbs

Total mins:-

2×3/43/2min1.5min

no links or files please, i just need the answers.. (Worth 25 points)

Answers

Answer:

A ,D , F

Step-by-step explanation:

A) x-3=0 , x=3

B 1+x=2 , x=2-1=1 , x=1

C 9-x=3 , x=9-3=6 , x=6

D) 6=2x , x=6/2=3 , x=3

E (1/5)x=3 , x=3*5=15 , x=15

F) x^2=9 x=√9 , x=3

Represent the area of the region determined by the intersection of the circles x
2 + y
2 = 4

and (x − 2)2 + (y − 2)2 = 4 by an integral. Do not evaluate the integral.

Answers

I think you mean the circles

x² + y² = 4

(x - 2)² + (y - 2)² = 4

Notice that both have radius 2, but the first one is centered at the origin (0, 0) while the second one is centered at (2, 2). The two circles intersect at the points (2, 0) and (0, 2), which means the bounded region between them is contained entirely in the first quadrant.

If we solve both equations above for y, we would find two solutions in each case:

x² + y² = 4   ⇒   y = ± √(4 - x²)

(x - 2)² + (y - 2)² = 4   ⇒   y = 2 ± √(4 - (x - 2)²)

The positive/negative root corresponds to the upper/lower semicircle the make up the full circle. The semicircles we're interested in are

y = + √(4 - x²)

y = 2 - √(4 - (x - 2)²)

that is, the upper half of the circle centered at the origin, and the lower half of the circle centered at (2, 2).

So, in standard Cartesian coordinates, the bounded region (call it R) is the set

[tex]R = \left\{(x, y) : 0 \le x \le 2 \text{ and } 2-\sqrt{4-(x-2)^2} \le y \le \sqrt{4-x^2} \right\}[/tex]

and the area is given by the double integral

[tex]\displaystyle \iint_R dA = \boxed{\int_0^2 \int_{2-\sqrt{4-(x-2)^2}}^{\sqrt{4-x^2}} dy \, dx}[/tex]

Leonard has $87.00 in his checking account. He writes a check to his credit card company for $95.00.


Which statement describes Leonard’s new checking account balance?



Leonard’s balance is −$182.00.



Leonard’s balance is −$8.00.



Leonard’s balance is $8.00.



Leonard’s balance is $182.00.

Answers

Answer:

Leonard’s balance is −$8.00.

Step-by-step explanation:

Explain how to find a probability of an event

Answers

Answer:

what event there is no picture or words to tell me please explain

Step-by-step explanation:

determine the y-intercept

Answers

Answer:

-21

Step-by-step explanation:

the y intercept is when x=0.

you can see that this is a linear equation where each increase in x results in  an increase of 4 onto the y value.

so if when x=1, y=-17, subtract 4 to find what y equals when x is 0.

-17 -4=-21

good luck :)

what were the most important people for mary eliza mahoney

Answers

Answer:

African American and women

Step-by-step explanation:

Mary Eliza Mahoney was eager to encourage greater equality for African Americans and women

hope this helps!

Work out the value of angle marked b

Answers

Answer:

22

Step-by-step explanation:

180-90-68=22

Answer:

180 - (90+68) = 22

B =22

Hope this helps!

Please help, I’ll mark your answer as brainliest.

Answers

the denominator is x² -9x+14≠0
factorize it
(x-7)(x-2)≠0
x≠7 and x≠2

hence domain is x ∈ (-∞,2) U (2,7) U (7, ∞)

Please help Mandy took out a $35,000 loan to buy a car. What is the principal?

Answers

The principal of a loan is the amount of money they took out as a loan.


Principal = $35,000

Other Questions
If you add bod y lot.ion on your fa ce and have bad ac ne, would it make it worse? True or false? As a result of the battle of the horse shoe Jackson allowed the native Americans to stay on the eastern coast anyone know the answer to this? Dimond has 350$ in her bank account . She wrote 4 checks for 18.45$ each and 2 checks for 51.25$ each. what will be the balance in dimonds account after the checks are cashed? Glenda and Fiero are at a restaurant eating meal that costs $30. They have a discount coupon that gets them 10% off the cost. If they pay the waiter a tip of 8% of their bill, how much are they spending on dinner including tip? (I ALREADY KNOW THE ANSWER. BUT I NEED THE WORK FOR THE ANSWER TO SHOW MY TEACHER) (the answer is $29.16)) 13. Who are the Tramecksans and Slamecksans in the novel? Whom does Swift mean to satirize and what does he want to point out? 6. The value of a car depreciates by 22.5% per year. After how many years isthe value of the car first less than 40% of its original value GIven m is parallel to n, find the value of x and y How far will an object go if it is moving at a speed of 55 km/hr, and moves for 6.3 hours? The base of a rectangle is 1 cm less than twice its height. The area is 45 cm2, find the dimensions of the rectangle. Rewrite the expression below by completing the square. 1. In which of the following forms of government does the mayor have the least executivepower?A. strong mayor-councilB. weak mayor-councilC. council-managerD. consolidated PLEASE PLEASE HELP AND PLEASE the abscissa of a point is -6 and its distance from the point (1,3) is 74. find the ordinate of the point (100 POINTS AND BRAINLIEST ASAP) Why are juries required to render a unanimous decision rather than a majority decision in most criminal cases. Anastasia Subscribe to a website for processing her digital pictures The subscription is $6.25 per month and 4-by -6 inches prints are $ 0.25 each how many prints dose Anastasia Purchase if the charge for January is $15.75 ? 5. Which of the following best describes the effect of coral bleaching on corals?A. As temperatures increase, corals lose symbiotic algae, which provide most of their habitatB. As temperatures decrease, corals lose their symbiotic algae, which provide most of their energy.C. As temperatures increase, corals lose their symbiotic algae, which provide most of their energy.D. As temperatures increase, corals gain symbiotic algae, which hinder their ability to conduct photosynthesis. Read the passage below. Once you have read the story, explain what episodes show the climax of the story. Explain your answer in one or two sentences.Laurel woke up to the sound of her banging alarm. She was startled and yet excited to start her first day of middle school. Her outfit was ready, and her lunch was packed. She even bought new pens and notebooks for the new school year.As she sat on the bus in her new clothes, she started to feel nervous. What if she didn't like her teachers? What if middle school was too hard? What if she didn't have anyone to sit with at lunch? Laurel could feel her stomach churning with fear. Then, at the next stop, her best friend, Norma, got on the bus. As Norma sat right next to her, Laurel knew everything would be okay as long as she had her best friend. I need help on question 16 PLEASE HURRY AND ANSWER What was the outcome of the War of 1812 for the United States?O A.The United States acquired islands in the Caribbean..The United States lost the land in the West.OC.The United States did not gain or lose any land.OD.The United States acquired parts of Canada.