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
iVinArrow [24]
3 years ago
13

In cell g5, construct a formula to calculate the percent of total by dividing the annual total for salaries and benefits by the

annual total for totals by quarter. use absolute cell references as necessary, format the result in percent style, and then center. fill the formula down through cell g9
Business
1 answer:
bearhunter [10]3 years ago
7 0

Answer & Explanation:

Formula for Annual total for salaries and benefit is given by

=sum(B5:E5) this can be duplicated vertically by copying it down

Formula for totals by Quarter 1 is given by

= sum(B5:B9) this also can be duplicated horizontally in adjacent cells by copying it to the right

Formula for percent totals is done as follows

=F5/$F$10

input the above,copy it down vertically then go to home tab and under number and click the percent tab

done

attached below is a copy of the finished work excel

Download xlsx
You might be interested in
What is an advantage of using a comparsion method of assesment ?
stepan [7]
B (sorry if its wrong!!)
5 0
2 years ago
The IRS assessed a large tax and penalty against Karl. Karl retained Roger, the CPA who prepared the tax returns, to challenge t
soldi70 [24.7K]

Answer:

d.economic duress

Explanation:

The economic duress in simple terms means a party who is entering into a contract frightens or threatens of cancelling the contract or does not act according to the terms of the contract unless the other party in the contract agrees to their demands.

In the context, the conduct of Roger against Karl is probably can be called as the 'economic duress' as Roger informs Karl before the deadline of filing the response that he will not represent himself against IRS unless Karl enters into a deal of an expensive retainer agreement. Thus it is an economic duress that Roger is showing and forcing Karl to agree on his demands.

7 0
3 years ago
An employee earns $24 per hour and 1.5 times that rate for all hours in excess of 40 hours per week. If the employee worked 50 h
Anettt [7]

Answer:

a. Gross pay = $1,320

b. Net pay = $917

Explanation:

a. Determine the gross pay for the week. $ If applicable, round your final answer to two decimal places.

Pay for 40 hours = 40 * $24 = $960

Pay for excess of 50 hours = (50 - 40) * $24 * 1.5 = $360

Gross pay = $960 + $360 = $1,320

b. Determine the net pay for the week.

Net pay = $1,320 - ($1,320 * 6.0%) - ($1,320 * 1.5%) - $304 = $917.

3 0
3 years ago
A process has low fixed costs and high variable costs. It is currently capacity-constrained. Will the impact of an efficiency im
Lubov Fominskaja [6]

Answer:

Small

Explanation:

Fixed costs are the costs that do not change when output level changes, while variable costs are costs that change as output quantity changes.

When a production process is capacity constrained, it implies that there is a factor that does not allow it to produce more output. Examples of such factors are minor bottlenecks, constrained designs and resources, and others.

A process is said to be efficient when it can avoid waste of resources in producing desired output.

Efficiency improvement therefore occurs when more output can be produced with less resources.

In the question, given that the process is currently capacity-constrained, efficiency improvement will result in producing more output at higher costs because of high variable costs despite that the process has low fixed costs.

As a result, the impact of an efficiency improvement will be small because producing more output will result in incurring higher cost due to high variable costs that change as quantity of output changes. That is, the impact of efficiency improvement will be small because high variable costs with low fixed cost will result in higher production cost.

3 0
3 years ago
Identify whether each statement in the following table best illustrates the concept of consumers’ surplus, producers’ surplus, o
Blizzard [7]

Answer:

1. Neither ; 2. Consumer Surplus ; 3. Producer Surplus

Explanation:

Consumer Surplus is the difference between a good's price paid by consumer, & maximum price the consumer is willing to pay for the good.

Producer Surplus is the difference between a good's price received by a seller, & minimum price at which the seller is willing to sell the good.

1. Willing to pay $209 for watch, buyer willing to sell at $196, no trade as price ceiling at $190 : It illustrates neither concept as transaction has not actually occurred, so no price established.

2. Willing to pay $39 for sweater, purchased it for $32 : It illustrates 'Consumer Surplus' case = $7 , as it shows difference between maximum willingness to pay by buyer ($39) & the actual buy price ($32)

3. Willing to sell laptop at $190, sold it at $199 : It illustrates 'Producer Surplus' case = $9 , as it shows difference between minimum willingness to sell price ($190) &  actual sale price ($199)

5 0
3 years ago
Other questions:
  • Garcia Industries has sales of $167,500 and accounts receivable of $18,500, and it gives its customers 25 days to pay. The indus
    10·1 answer
  • Importance of completing client records correctly
    6·1 answer
  • Group price discrimination has ________ consumer surplus than under ________.
    14·1 answer
  • Bonita Corporation’s December 31, 2018 balance sheet showed the following:
    12·1 answer
  • According to this doctrine, an agency relationship which is created after the fact when the principal agrees to be bound by the
    8·1 answer
  • Which of the marks of good leadership do you feel is the most important? (Take your time)
    5·1 answer
  • Dante worked 10 hours per week at a grocery store last school year, earning minimum wage. His parents claim him as a dependent o
    10·1 answer
  • A positive consequence of organizational distress may take the form of: a. functional turnover. b. absenteeism. c. employee work
    6·1 answer
  • Stephen bought 85 shares of United Rotators at $6. 34 each, 110 shares of Dowc Beverage Co. At $13. 13 apiece, and 133 shares of
    15·1 answer
  • Across mass marketing, niche marketing, and one-to-one marketing, the underlying method of dealing with heterogeneity is the sam
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!