answer.
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]
2 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]2 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
Kolar Manufacturing is approached by a European customer to fulfill a one-time-only special order for a product similar to one o
Alona [7]

Answer:

$ 140,000

Explanation:

Data:

Variable cost for the product:

Direct material = $ 80

Direct labor cost = $ 40

Manufacturing support =$ 70

Marketing cost = $ 30

Thus, the total variable cost = $ 80 + $ 40 + $ 70 + $ 30 = $ 220

Fixed costs for the product:

Manufacturing support = $ 90

Marketing costs = $30

Total costs = $ 340

Targeted selling price = $ 510

Accepted price for a unit by Kolar, i.e the selling price = $ 360

Now,

the change in operating profit will be from the variable costs only as the fixed costs cannot be altered.

Thus,

the contribution margin for the single unit = Selling price -  Total variable cost

or

the contribution margin for the single unit = $ 360 - $ 220 = $ 140

Therefore,

the change in operating profits for the 1,000 units

= contribution margin per unit × 1000

or

the change in operating profits for the 1,000 units  = $ 140 × 1000

or

the change in operating profits for the 1,000 units = $ 140,000

4 0
2 years ago
Kate is a busy student. She likes to run to stay healthy and fit. She doesn't shop all the brands because she knows what shoe is
Yanka [14]
The correct answer is D
4 0
2 years ago
Improving business processes by reengineering them, benchmarking specific activities against industry leaders, encouraging emplo
V125BC [204]

Answer: (C) Piecemeal productivity improvements

Explanation:

The piecemeal productivity improvement is one of the type of business strategy that is used by various types of successful organization for the purpose of improving the productivity of an employees, the business process and also managing all bench-marking activities in an organization.

 According to the given question, the given  activities in an organization are the example of Piecemeal productivity improvements that helps in expanding the product scope in the market. Therefore, Option (C) is correct answer.  

  Therefore, Option (C) is correct answer.

4 0
2 years ago
Which of the following are useful for conducting market research? A. Focus groups B. Cost-benefit analysis C. Budget spreadsheet
rewona [7]
A- Focus Groups. You gotta know how the customers feel
7 0
2 years ago
Read 2 more answers
Azure Inc. assigns $4,000,000 of its accounts receivables as collateral for a $3 million loan with a bank. The bank assesses a 3
Vlad1618 [11]

Answer with its Explanation:

Step 1:

First of all record a loan of $3 million loan:

Dr Bank $3,000,000

Cr Loan      $3,000,000

Step 2:

Finance charge will be 3% on this loan amount:

Dr Finance Charge $3million *3% = $90,000

Cr                   Bank                                       $90,000

Step 3:

The interest on the note is 7% which is $70,000. So the journal entry would be:

Dr Interest Expense $70,000

Cr Interest payable                  $70,0000

8 0
2 years ago
Other questions:
  • A manager that primarily focuses on the shareholders of the corporation rather than all of the vested parties in the businesses
    13·2 answers
  • The Tolar Corporation has 500 obsolete desk calculators that are carried in inventory at a total cost of $720,000. If these calc
    15·1 answer
  • Alice is trying to save money, so she decides she’ll only buy renters insurance if and when something bad happens at her apartme
    13·1 answer
  • Abby, Bobbi, and Deborah each buy ice cream and paperback novels to enjoy on hot summer days. Ice cream costs $5 per gallon, and
    14·1 answer
  • Order the paragraph correctly.A. But the colonists had a favorable balance of trade with Spanish America—selling more than they
    6·1 answer
  • Balance sheet and income statement data indicate the following: Bonds payable, 10% $1,000,000 Preferred 5% stock, $100 par (no c
    10·1 answer
  • Fasheh Corporation's relevant range of activity is 7,000 units to 11,000 units. When it produces and sells 9,000 units, its aver
    15·1 answer
  • Although it was not explicitly noted in the employee handbook, Jennie was told at the start of her internship that employees are
    6·1 answer
  • Lion Management Services is considering an investment of $75,000. Data related to the investment are as follows:
    11·1 answer
  • a major coffee retailer is looking to implement an enterprise platform. in particular, the company is looking to improve its sup
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!