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]
4 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]4 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
Your grandparents deposit $2,000 each year on your birthday, starting the day you are born, in an account that pays 7% interest
OverLord2011 [107]

Answer:

The money you will have is $98020.

Explanation:

It is given that grandparents deposit $2,000 each year on birthday and the account pays 7% interest compounded annually also the time is 21 years.

we will use the compound interest formula  A=P (1 + \frac{r}{100})^{t}.

For the first birthday the amount after 21 yr will be:

A=2000(1+\frac{7}{100})^{21}

Similarly for the second birthday amount after 20yr will be:

A=2000(1+\frac{7}{100})^{20}

likewise, the last compound will be:

A=2000(1+\frac{7}{100})^1

The total value of such compounding would be :

\text {Total amount}=2000(1+\frac{7}{100})^{21}+2000(1+\frac{7}{100})^{20}...2000(1+\frac{7}{100})^{1}

\text {Total amount}=2000[(1+\frac{7}{100})^{21}+(1+\frac{7}{100})^{20}...(1+\frac{7}{100})^{1}]

\text{Total amount} \approx 2000(48.01)

\text{Total amount} \approx 96020

The total amount just after your grandparents make their​ deposit  is:

≈($96020+2000)

≈$98020

Hence, the money you will have is $98020.

4 0
3 years ago
Before Cheyenne Corporation engages in the following treasury stock transactions, its general ledger reflects, among others, the
strojnjashka [21]

Answer:

a) Bought 400 shares of treasury stock at $40 per share:

Dr Treasury stock                       16,000

Cr Cash                                       16,000

( to record the repurchased of 400 shares at $40 each)

b) Bought 290 shares of treasury stock at $45 per share:

Dr Treasury stock                       13,050

Cr Cash                                       13,050

( to record the repurchased of 290 shares at $45 each)

c) Sold 370 shares of treasury stock at $42 per share:

Dr Cash                                                15,540

Cr Common stock                               14,800

Cr Paid-in capital - common stock     740

( to record the sell of 370 shares repurchased at selling price of $42)

d) Sold 110 shares of treasury stock at $38 per share:

Dr Cash                                                4,180

Dr  Paid-in capital - common stock    620

Cr Common stock                               4,800

( to record the sell of 110 shares repurchased at selling price of $38)

Explanation:

a)

Following  repurchased of 400 shares at $40 each, cash account goes down (Cr) by 40 x 400 = $16,000; Treasury account will go up (Dr) by the same amount.

b)

Following  repurchased of 290 shares at $45 each, cash account goes down (Cr) by 290 * 45 = $13,050; Treasury account will go up (Dr) by the same amount.

c)

As FIFO apply, the selling of 370 repurchased stock will make the Common stock account goes up (Cr) by 40 x 370 = 14,800; Cash account goes up (Dr) by 370 x 42 = $15,540; the difference of 740 will go into (Cr) Paid-in capital - common stock.

d)

As FIFO apply, the selling of 110 repurchased stock will make the Common stock account goes up (Cr) by 30 x 40 + (110-30) * 45 = $4,800; Cash account goes up (Dr) by 110 x 38 = $4,180; the difference of 620 will go into (Dr) Paid-in capital - common stock.

7 0
3 years ago
Suppose that Italy and Sweden both produce jeans and stained glass. Italy's opportunity cost of producing a pane of stained glas
Simora [160]

Answer:

The correct answer is option C.

Explanation:

Italy and Sweden both produce jeans and stained glass.

Italy's opportunity cost of producing a pane of stained glass  

= 4 pairs of jeans  

Sweden's opportunity cost of producing a pane of stained glass  

= 10 pairs of jeans

Since Italy has a lower opportunity cost of producing glass, so we can say that it has a comparative advantage in the production of glass.  

Italy's opportunity cost of producing a pair of jeans  

= \frac{1}{4}

= 0.25

Sweden's opportunity cost of producing a pair of jeans  

= \frac{1}{10}

= 0.1

Sweden has a lower opportunity cost in the production of jeans, so it has a comparative advantage in the production of jeans.  

So, Italy will produce and export glass and Sweden will produce and export jeans.  

Both the countries will gain from trade if the trade price lies between their opportunity cost.  

So the trade price will be 8 pairs of jeans per pane of stained glass.  

7 0
3 years ago
Marys mom has 6 kids march april may june july what is her last kid name
denpristay [2]

Her last kid s name is August

8 0
3 years ago
Read 2 more answers
Shawn went to a restaurant where the beer was mediocre and the place was run-down. The restaurant was out of many of its more po
Dmitry_Shevchenko [17]

Answer:

The options for this question are the following:

a. reason for purchase

b. buyer mood or condition

c. social surroundings

d. time considerations

e. physical surroundings

The correct answer is c. social surroundings.

Explanation:

The social surroundings of a subject is formed by their living and working conditions, the studies they have completed, their level of income and the community of which they are a part. Each of these factors influences the health of the individual: therefore, globally, differences between the social environments of different countries create disparities in health.

In this way, life expectancy and disease rates vary according to the education the person has received, the type of work they do and the income they receive month by month.

Government agencies often develop various plans to improve the social environment (that is, to provide the right conditions for the full development of the subject). Among the objectives proposed by this type of initiative are the creation of jobs, the improvement of quality and safety in the workplace, the mass access to social benefits and the increase in financing to attend the poorest regions.

7 0
4 years ago
Other questions:
  • After three years Remington or $390 and simple interest from a CD into which she initially deposited $4000 what was the annual i
    8·1 answer
  • How did dr. Martin Luther King Jr and Malcolm X differ in their approaches to gain civil rights
    13·1 answer
  • If a good is normal, then an increase in income will result in a(n) a. increase in the demand for the good. b. decrease in the d
    6·1 answer
  • Hutchins Company had​ 200,000 shares of common​ stock, 50,000 shares of convertible preferred​ stock, and​ $2,000,000 of​ 10% co
    13·1 answer
  • When julie is focused on measuring performance and correcting as necessary, she is focusing on which of these managerial functio
    8·1 answer
  • Material, Labor, and Variable Overhead Variances The following summarized manufacturing data relate to Thomas Corporation’s Apri
    10·1 answer
  • The _____ doctrine allows the plaintiff to recover damages despite proof of contributory negligence as long as the defendant had
    8·1 answer
  • Which aspect of Darron's career matches his lifestyle but is also in conflict with some of his desires? busyness while at work e
    6·2 answers
  • What can be broken, but is never held?
    15·1 answer
  • Tyrell Corporation, headquartered in Indiana, and Blender Corporation, headquartered in Michigan, entered into a contract with a
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!