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
sp2606 [1]
3 years ago
7

A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $6

50, and $600. What function could be used to return the third largest value
Business
1 answer:
ivolga24 [154]3 years ago
7 0

Answer:We use the Large Function. the general formula is  =LARGE(first cell:last cell,3) .Please refer to the explanation section for details

Explanation:

Let us assume

A 1 = $1,250,  A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600

Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;

=LARGE(A1:A2,3)

You might be interested in
Comfy Inc. uses five yards of wool in each blanket it produces. Comfy’s production budget next year is 30,000 blankets. The anti
Kamila [148]

Answer:

wool purchased = 140,000 yards

Explanation:

given data

wool in each blanket = five yards

production budget = 30,000 blankets

beginning inventory = 30,000 yards

Ending inventory = 20,000 yards

wool costs = $10

to find out

How many yards of wool should Comfy purchase

solution

we get first production in yards that is

production in yards = 30,000 × 5

production in yards = 150,000

and

wool purchased will be

wool purchased = production - ( beginning inventory -  Ending inventory)

wool purchased = 150,000 - ( 30000 - 20000 )

wool purchased = 140,000 yards

7 0
3 years ago
A food manufacturer reports the following for two of its divisions for a recent year.
hram777 [196]

Answer:

1. 13.8% and 14.6%

2. 13.6% and 16.5%

3. 1.01 times and 0.88 times

Explanation:

The computations are shown below:

1. Return on investment = Operating Income ÷ Average invested Assets

where, average invested assets would be

= (Invested assets, beginning + Invested assets, ending) ÷ 2

For Beverage Division, it would be

= $366 ÷ {($2,696 + $2,610) ÷ 2}

= $366 ÷ $2,653

= 13.8%

For Cheese Division, it would be

= $651 ÷ {($4,489 + $4,417) ÷ 2}

= $651 ÷ $4,453

= 14.6%

2. Profit margin = (Operating income ÷ sales) × 100

For Beverage Division, it would be

= ($366 ÷ $2,698) × 100

= 13.6%

For Cheese Division, it would be

= ($651 ÷ $3,942) × 100

= 16.5%

3. Investment turnover = Sales ÷ Average Operating Assets

For Beverage Division, it would be

= $2,698 ÷ {($2,696 + $2,610) ÷ 2}

= $2,698 ÷ $2,653

= 1.01 times

For Cheese Division, it would be

= $3,942 ÷ {($4,489 + $4,417) ÷ 2}

= $3,942 ÷ $4,453

= 0.88 times

7 0
3 years ago
At January 1, 2018, Transit Developments owed First City Bank Group $600,000, under an 11% note with three years remaining to ma
VashaNatasha [74]

Answer:

interest payable   66,000

note payable      384,000

       Land                            325,000

       Gain on disposal         125,000

Explanation:

600,000 x 11% = 66,000 interest payable

the land is being used to settle the note along with the accrued interest at the time:

the accounting  of Transit developments record the land at cost: 325,000

as the market valuye is 450,000 so a gain for 125,000 will be recognize.

450,000 market value - 66,000 interest payable: 384,000 payment on the note principal

the entry will write-off the interest payable, decrease the note by that amount and recognize the land gain on disposal

4 0
3 years ago
The Smiths are purchasing a completely furnished cottage on a lake. They have obtained a deed of trust loan to cover the price o
Pachacha [2.7K]

The type of financing that includes the purchasing of furnished cottage on a lake with the full deed is called as a package deed of trust

Explanation:

Package deed of trust will involve the third party and they will serve as the trustee in between the lender and the borrower and the property will be in the hands of the trustee until the lender pay off the the loan

This will transferred with the legal property and they will hold the security loan and it will be made equitable and the title will remain with the borrower until they pay of the money

8 0
3 years ago
Which of the following bases of power emphasizes threatening or actual punishment?
gizmo_the_mogwai [7]
<h2>Hello!</h2>

The answer is C. Coercive.

<h2>Why?</h2>

According to the bases of power, coercive power means that someone can punish someone who deserves it when it's needed, punishment can be just punishment but it can also mean serious actions as demoting, restricting privileges or in the last instance, firing people.

Coercive power can be a problem if it's applied to everyone, every time, the result of coercive actions applied in an inappropriate way could result in useful people resignations. That's why coercive tools are the last resort if corrections are needed.

Have a nice day!

6 0
3 years ago
Read 2 more answers
Other questions:
  • A financial institution formed by a large organization for its members is a credit union.
    7·1 answer
  • _____ occurs when investors earn interest in the current time period on interest earned in previous time periods.
    5·1 answer
  • Malcolm faced resistance from the team most likely because he did NOT utilize which of the following influence tactics?
    9·1 answer
  • annual property taxes are $1,776. the previous year's taxes are paid. if the closing is one May 1, what is the seller's portion
    5·1 answer
  • True or False: If a firm changes its credit policy and allows customers to pay in 90 days instead of 60 days, and everything els
    13·1 answer
  • Each of the two hemispheres also begins to process information in a slightly different manner. Whereas the ___________ hemispher
    14·1 answer
  • At the beginning of the period, the Cutting Department budgeted direct labor of $52,350 and supervisor salaries of $42,150 for 3
    13·1 answer
  • Merger Co. has 10 employees, each of whom earns $1,700 per month and has been employed since January 1. FICA Social Security tax
    9·1 answer
  • Which of the following is a characteristic of a public good?
    11·1 answer
  • Drag the tiles to the correct boxes to complete the pairs.
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!