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
Calculating and using Dual Charging Rates
11Alexandr11 [23.1K]

Answer:

1. Calculate a variable rate for the Maintenance Department. Round your answer to the nearest cent. $ per maintenance hour Calculate the allocated fixed cost for each using department based on its budgeted peak month usage in maintenance hours.

variable rate = $1.30 per maintenance hour

Department                            Peak Number              Allocated  

                                               of hours                        Fixed cost  

Assembly                          (210/2,100) x $65,400          $6,540

Fabrication                     (1,050/2,100) x $65,400        $32,700

<u>Packaging                        (840/2,100) x $65,400         $26,160</u>

Total                                        2,100/2,100                   $65,400

2. Use the two rates to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year.

Department             Fixed costs         Variable cost                  Total              

Assembly                      $6,540     3,500 x $1.30 = $4,550      $11,090

Fabricating                  $32,700     7,000 x $1.30 = $9,100      $41,800

<u>Packaging                   $26,160    10,000 x $1.30 = $13,000    $39,160</u>

Total                           $65,400            $26,650                      $92,050

3. What if the Assembly Department used 3,550 maintenance hours in the year? How much would have been charged out to the three departments?

Department             Fixed costs         Variable cost                  Total              

Assembly                      $6,540     3,550 x $1.30 = $4,615        $11,155

Fabricating                  $32,700     7,000 x $1.30 = $9,100      $41,800

<u>Packaging                   $26,160    10,000 x $1.30 = $13,000    $39,160</u>

Total                           $65,400              $26,715                       $92,115

6 0
3 years ago
OCF from Several Approaches [L01] A proposed new project has projected sales of $125,000, costs of $59,000, and depreciation of
natulia [17]

Answer:

Please see below

Explanation:

In order to calculate the operating cash flow, we will get the value of net income. The income statement is calculated as;

Sales

$125,000

Less :

Costs

($59,000)

Depreciation

($12,800)

EBIT

$53,200

Less tax 35%

($18,620)

Net income

$34,580

1. Using the tax shield method

OCF = (Sales - Costs)(1 - Tax) + Tax(Depreciation)

OCF = ($125,000 - $59,000)(1 - 35%) + 35%($12,800)

OCF = ($66,000)(0.65) + $4,480

OCF = $42,900 + $4,480

OCF = 47,380

2. Using the financial calculation

OCF = EBIT + Depreciation - Taxes

OCF = $53,200 + $12,800 - $18,620

OCF = $47,380

3. Using the top down approach

OCF = Sales - Costs - Taxes

OCF = $125,000 - $59,000 - $18,620

OCF = $47,380

4. Using the bottom up approach

OCF = Net income + Depreciation

OCF = $34,580 + $12,800

OCF = $47,380

8 0
2 years ago
The following information applies to the questions displayed below] A local Chevrolet dealership carries the following types of
myrzilka [38]

Answer:

Chevrolet Dealership

A) The total cost of the entire inventory is:

= $575,000

B) Each inventory would be reported at the LCNRV:

Inventory Items  Quantity  Reporting Cost/Value

Vans                        4              NRV

Trucks                     7              NRV

2-door sedans        3              Cost

4-door sedans        5              Cost

Sports cars              1              Cost

SUVs                       6              NRV

C) Journal Entry:

Debit Cost of goods sold $27,000

Credit Inventory $27,000

To write-down costs to net realizable values.

D) TRUE.

Explanation:

a) Data and Calculations:

Inventory Items  Quantity    Cost per unit      NRV per Unit      LCNRV

Vans                        4           27000 $108,000      25000        $100,000

Trucks                     7            18000   126,000       17000           119,000

2-door sedans        3           13000     39,000      15000            39,000

4-door sedans        5           17000     85,000     20000            85,000

Sports cars              1          37000      37,000     40000            37,000

SUVs                       6         30000    180,000     28000           168,000

Total Cost                                      $575,000                         $548,000

3 0
3 years ago
Matrice has been working as a creative head at Ace Designs for 10 years. Her growth at Ace has made her one of the industry's fi
olga_2 [115]

Answer: continuance commitment

Explanation:

The above scenario explains a continuance commitment. This occurs when a worker remains with a particular organization after he or she looks at both the benefits and costs of leaving and sees that the cost of leaving the organization outweighs the benefits.

In this case, even though Matrice has had several recruiters offering interviews for possible positions at different companies, he believes that he should stay as a result of the medical insurance benefits that he gets. This is thus referred to as continuance commitment.

5 0
3 years ago
What is the capitalism
dybincka [34]

Answer:

Capitalism is an economic system based on the private ownership of the means of production and their operation for profit. Central characteristics of capitalism include capital accumulation, competitive markets, a price system, private property and the recognition of property rights, voluntary exchange and wage labor.

Explanation:

Just a cheerful teen willing to help...

4 0
2 years ago
Other questions:
  • How do you see your housing needs and goals changing over time?<br> This is an essay question.
    8·1 answer
  • 5. When increased raw material costs increase prices for consumers, the situation is known as _______ inflation.
    9·2 answers
  • Jane and Sarah were watching the evening news when viewers were asked to weigh in on the city's proposed tax increase. Later in
    7·1 answer
  • 5.3 Fraud is gaining an unfair advantage over another person. Legally, for an act to be fraudulent there must be:
    6·1 answer
  • During the period, labor costs incurred on account amounted to $175,000, including $150,000 for production orders and $25,000 fo
    15·1 answer
  • A share of stock is now selling for $120. It will pay a dividend of $10 per share at the end of the year. Its beta is 1. What mu
    7·1 answer
  • Dennis purchased a big-screen television from ABC Electronics and financed the purchase through ABC Electronics based on an agre
    14·1 answer
  • Which is the best definition of voluntary exchange?
    13·1 answer
  • Hane Corporation uses the following activity rates from its activity-based costing to assign overhead costs to products: Activit
    8·1 answer
  • An account used in the periodic inventory system that is not used in the perpetual inventory system is?
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!