1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Mekhanik [1.2K]
3 years ago
12

Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one

dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format.

Business
1 answer:
mixer [17]3 years ago
3 0

Answer:

the formula in cell F5 =IF(AND(B5="FT",C5>0),0.07*(D5-E5),0.05*(D5-E5))

Explanation

Check attachment for the given data and solution data

You might be interested in
The oldest recorded effort to organize a fire fighting service dates back to the:
Zepler [3.9K]
Dates back to the Roman Republic.
7 0
2 years ago
Jessica purchased a home on January 1, 2018 for $580,000 by making a down payment of $230,000 and financing the remaining $350,0
Ann [662]

Answer:

$32,600

Explanation:

Calculation to determine her itemized deduction if she used the proceeds of the second loan to finish the basement in her home and landscape her yard

Using this formula

Itemized deduction =(Financing amount * 6 percent)+(Additional amount borrowed*interest rate of 8 percent)

Let plug in the formula

Itemized deduction=( $350,000 * 6 percent)+($145,000 *8 percent)

Itemized deduction=($21,000+$11,600)

Itemized deduction=$32,600

Therefore her itemized deduction if she used the proceeds of the second loan to finish the basement in her home and landscape her yard wi be $32,600

5 0
3 years ago
Bill currently uses his entire budget to purchase 5 cans of Pepsi and 3 hamburgers per week. The price of Pepsi is​ $1 per​ can,
FinnZ [79.3K]

Answer:

Option (B) is correct.

Explanation:

The utility maximization point for a consumer is as follows:

\frac{MU_x}{P_x}=\frac{MU_y}{P_y}

It is given that,

price of Pepsi(x) =​ $1 per can

price of a hamburger(y) =​ $2

Marginal utility from Pepsi =​ 4

Marginal utility from hamburgers = 6

Hence,

\frac{4}{1}>\frac{6}{2}

4 > 3

Therefore, it can be seen that the consumer's utility is not maximized at this point.

Law of diminishing marginal utility states that as the consumer consumes more and more quantity of goods then as a result the utility obtained from the consumption goes on diminishing.

So, there is a need to increase the quantity of Pepsi consumed and reducing the quantity of hamburgers consumed.

6 0
3 years ago
10. Uneven cash flows A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variabl
GaryK [48]

Answer:

$1,155,478

Explanation:

Present value is the sum of discounted cash flows

Present value can be found using a financial calculator

Cash flow in year 1 = $100,000

Cash flow in year 2 =  $20,000

Cash flow in year 3 = $480,000

Cash flow in year 4 = $450,000

Cash flow in year 5 = $550,000

I = 9%

Present value = $1,155,478

To find the PV using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.  

3. Press compute  

5 0
3 years ago
Which stage in project management involves team members working on the assigned tasks as described in the project plan?
vagabundo [1.1K]

Answer:

C.  execution

Explanation:

  • The execution stage is 3rd stage in project management lifecycle is usually is longest phase as during which the teams develops the product or services and presents the final end product to the clients. Here the team members work on the same set of guidelines that are assigned or designed in a project.
3 0
2 years ago
Other questions:
  • Ruth Hu recently inherited $200,000. She has invested the inherited money in real estate and government securities. Hu is using
    8·1 answer
  • How is dragonwave, inc revenues by product categroy?
    9·1 answer
  • Appropriation to retained earning is
    15·2 answers
  • Suppose that $1450 is deposited into an account paying simple interest of 8% annually. At the end of seven (7) years, the accoun
    6·1 answer
  • The emergency planning process includes the following steps: (1) Form a collaborative planning team; (2) Understand the situatio
    14·1 answer
  • A project that provides annual cash flows of $18,200 for nine years costs $88,000 today.
    12·1 answer
  • What is 1087 in Roman numerals​
    12·1 answer
  • A 13-year, 6 percent coupon bond pays interest semiannually. The bond has a face value of $1,000. What is the percentage change
    15·1 answer
  • Ways in which climate change can affect the economy of South Africa​
    11·1 answer
  • What type of pricing objective would an organization use if it were in a favorable position and desired nothing more
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!