Which function will give the average of values in the second column of a database named “Earnings” that meets the criteria listed in cells A2 through C4?
A. =DAVERAGE(2,Earnings,A2:C4)
B. =DAVERAGE(A2:C4,Earnings,2)
C. =DAVERAGE(A2:C4,2,Earnings)
D. =DAVERAGE(Earnings,2,A2:C4)

Answers

Answer 1

Answer:

DDDD. =DAVERAGE(Earnings,2,A2:C4)

Explanation:

Took the test


Related Questions

The following information was taken from last year's income statement segmented by division:

East Division West Division
Sales $3,700,000 $2,300,000
Contribution margin $1,650,000 $1,000,000
Divisional segment margin $1,100,000 $350,000

Net operating income last year for SegR-3748 Corporation was $600,000. In last year's income statement segmented by division, what were SegR-4212's total common fixed expenses?

Answers

Answer:

$850,000

Explanation:

Divisional Segment Margin = $1,100,000 + $350,000

Divisional Segment Margin = $1,450,000

Net Operating Income = $600,000

Common fixed expenses = Divisional Segment Margin - Net Operating Income

Common fixed expenses = $1,450,000 - $600,000

Common fixed expenses = $850,000

So, SegR-4212's total common fixed expenses will be $850,000.

Nash Company sold 10,800 Super-Spreaders on December 31, 2020, at a total price of $1,015,200, with a warranty guarantee that the product was free of any defects. The cost of the spreaders sold is $561,600. The assurance warranties extend for a 2-year period and are estimated to cost $43,400. Nash also sold extended warranties (service-type warranties) related to 2,100 spreaders for 2 years beyond the 2-year period for $12,600. Given this information, determine the amounts to report for the following at December 31, 2020: sales revenue, warranty expense, unearned warranty revenue, warranty liability, and cash.

Answers

Answer:

     Amount reported in Income

Particulars                           Amount

Sales revenue                   $1,015,200

Warranty expenses           $43,400

 Amount reported on balance sheet

Particulars                                 Amount

Unearned service revenue      $12,600

Cash ($1,015,200 + $12,600)   $1,016,460

Warranty liability                       $43,400

22. At the end of each year for the next 18 years, you receive cash flows of $3700. The initial investment is $25,200 today. What rate of return are you expecting from this investment? Answer as a whole percentage 13.07%

Answers

Answer:

29.37%

Explanation:

Rate of return = Average annual income/Average initial investment

Average annual income = $3,700

Average initial investment = (I+s)/2

Average initial investment = (25,200+0)/2

Average initial investment = $12,600

Rate of return = $3,700/$12,600

Rate of return = 0.2936508

Rate of return = 29.37%

Determine whether each of the following statements is an example of a price ceiling or a price floor and whether it is binding or nonbinding.

a. The government prohibits fast-food restaurants from selling hamburgers for more than $8 each.
b. Due to new regulations, fast-food restaurants that would like to pay better wages in order to hire more workers are prohibited from doing so.
c. The government has instituted a legal minimum price of $5 each for hamburgers.

Answers

Answer:

price ceiling non binding

price ceiling binding

price floor non-binding

Explanation:

A price floor is when the government or an agency of the government sets the minimum price of a product. A price floor is binding if it is set above equilibrium price.

the minimum price for hamburgers is $5. this is an example of a price floor

Price ceiling is when the government or an agency of the government sets the maximum price for a product. It is binding when it is set below equilibrium price.

The government sets the maximum price for hamburgers. this is an example of a price ceiling

Restaurants are prevented from hiring more workers and paying them a better wage. this is an example of a binding price ceiling

Effects of a price ceiling

1. It leads to shortages

2. it leads to the development of black markets

3. it prevents producers from raising price beyond a certain price

4. It lowers the price consumers pay for a product. This increases consumer surplus

On October 6, 2021, Ronan Corp. sold land to Bane Co., its wholly owned subsidiary. The land cost $72,400 and was sold to Bane for $96,000. For consolidated financial statement reporting purposes, when must the gain on the sale of the land be recognized?a. No gain may be recognized.b. As Bane uses the land.c. When Bane Co. sells the land to a third party.d. Proportionately over a designated period of years.e. When Bane Co. begins using the land productively.

Answers

Answer:

c. When Bane Co. sells the land to a third party

Explanation:

As in the case of the consolidated financial statement no gain or loss should be recognized when there is an intercompany transactions also it would be removed at the time of consolidation

So the gain that should be recognized at the time of sale of the land would occur when the company sold the land to the third party

Therefore the option c is correct

A light car is purchased on January 1 at a cost of $25,700. It is expected to serve for eight years and have a salvage value of $3,000. It is expected to be used for 96,000 miles over its eight-year useful life. Using the units-of-production method, calculate the depreciation expense for the first and third years of use if the car is driven 20,000 miles in year 1 and 18,000 miles in year 3. Round interim calculations to two decimal places.

Answers

Answer:

$4729.17

$4256.25

Explanation:

Activity method based on output = (miles driven that year / total miles that can be driven) x (Cost of asset - Salvage value)

Year 1

(20,000 / 96,000) x ($25,700 - $3,000) = $4729.17

Year 3

(18,000 / 96,000) x ($25,700 - $3,000) = $4256.25

A price searcher
a. faces a horizontal demand curve.
b. is a seller that searches for good employees and pays them a low wage.
c. seller that searches for the best price at which to buy its nonlabor inputs.
d. is a seller that has the ability to control, to some degree, the price of the product it sells.
e. a and c

Answers

Answer:

d. is a seller that has the ability to control, to some degree, the price of the product it sells

Explanation:

A price searcher is a person who sold the products and services and impact the price of the same goods & services via number of units sold

So as per the given situation, the option d is correct as it derives that it is the seller that has the capability to control for some degree for the price of that product it sold

So, the other options would be incorrect

Briefly explain the various environmental factors that a manager should consider in an organization.​

Answers

Answer:

pp iehrjdjs9gsiebfievdjr

An important difference between tariffs and quotas is that tariffs raise the price of the good in the country imposing the tariff. always generate tax revenue for the government. reduce imports. help domestic producers. g

Answers

Answer:

The correct answer is the second option: Tarrifs always generate tax revenue.

Explanation:

On the one hand, tariffs are taxes imposed by the government exclusively to imports and exports with the primary purpose of increase the revenue of the nation. Although it also looks for the protection of certains goods being a type of regulation regarding the international trade that goes around the world.

On the other hand, a quota is basically a limit imposed by the government with the only purpose of puting a maximum quantity to the number of imports that can entry in the country and therefore to protect the local industries and the domestic producers with it.

Explain the statement “The entrepreneur is the pivot of development.”

Answers

Answer:

Entrepreneurship is a continuous phase of development and movement while being focused on goal

Explanation:

An entrepreneur has an undeniable trait of being flexible along with being focused and pivoted to move in the right direction at the right time. If the circumstances require, he/she can also pivot in the other direction while being flexible at the same time.

Thus, entrepreneurship is a continuous phase of development and movement while being focused on goal.

During 2021, Blossom Co. incurred the following costs: Testing in search for process alternatives $390000 Costs of marketing research for new product 260000 Modification of the formulation of a process 570000 Research and development services performed by Crane Corp. for Blossom 485000 In Blossom's 2021 income statement, research and development expense should be

Answers

Answer:

See below

Explanation:

Given the above information, our concern when calculating amount of research and development costs charged to Blossom corp. for 2021 should be the period cost. This means costs that are incurred in the period under review. I.e 2021.

= Testing in search for process alternative + Cost of marketing research + Modification of formulation of a process + Consulting fees

= $390,000 + $260,000 + $570,000 + $485,000

= $1,705,000

Therefore, Blossom's 2021 income statement , research and development expense should be $1,705,000.

You want to invest $25,000 and are looking for safe investment options. Your bank is offering you a certificate of deposit that pays a nominal rate of 4% that is compounded bimonthly (every two months). What is the effective rate of return that you will earn from this investment

Answers

If you want to invest $25,000 and are looking for safe investment options. The effective rate of return that you will earn from this investment is  4.08%.

How to find the Effective rate of return?

Given data:

Investment = $25,000

Rate = r = 8%

Number of months = 12 × 2 = 24 months (Bimonthly)

Now let find the Effective rate of return

Effective rate of return = (1  + 0.04/24)^24 -1

Effective rate of return = 4.08%

Therefore we can conclude that the Effective rate of return is 4.08%.

Learn more about Effective rate of return here:https://brainly.com/question/28361279

#SPJ1

Jill starts at a salary of $30,000 per year and receives benefits that cost the company 50% of her salary. She gets 12 weeks of training, 2 weeks of vacation, and 10 paid holidays. Using 52 weeks per year, 40 hours per week, 8 hours per day, and not counting the trainer's cost, how much does it cost the company for every DAY in the first year that she is available to help a customer

Answers

Answer:

$250 per day

Explanation:

Calculation to determine how much does it cost the company for every DAY in the first year that she is available to help a customer

Cost =(30,000 + 15,000)*[(52 weeks- 2 weeks - 12 weeks)x 5 days- 10 day holidays]

Cost = $45,000 per year*(38 weeks×5 days- 10 day holidays)

Cost = $45,000 per year*180 days

Cost = $250 per day

Therefore how much does it cost the company for every DAY in the first year that she is available to help a customer is $250 per day

difference between partial equilibrium and general equilibrium in the simplest form​

Answers

Answer:

In a partial equilibrium model, you are ignoring feedback that may result from related markets. ... Normally, in a general equilibrium model, the equilibrium quantities and prices in all markets are endogenous.

Suppose that a decrease in the demand for goods and services pushes the economy into recession. What happens to the price level? If the government does nothing, what ensures that the economy still eventually gets back to the natural rate of output?

Answers

A decrease in aggregate demand causes the price level to fall. If the government takes no action to
counter this, then the actual price level will be below the price level that people expected.
Individuals will eventually correct their expectations of the price level. As they do so, prices and
wages will adjust accordingly, shifting the aggregate supply curve to the right (down). For example
if wages are sticky, in light of the lower price level, firms and workers will eventually make bargains
for lower nominal wages. The reduction in wages lowers costs of production, so firms are willing to

g This year, Nilo Inc. granted nonqualified stock options to 230 employees. For financial statement purposes, Nilo recorded a $179,200 expense for the estimated value of the options. As a result of this transaction, Nilo has a:

Answers

Answer:

temporary unfavorable book/tax difference

Explanation:

Given that

There is an unqualified stock options for 230 employees

And, the expenses are recorded at $179,200

So based on the above information the nike have temporary also adverse book or tax difference

as this given transaction does not represent the permanent one so it should be considered as temporary

Heritage, Inc., had a cost of goods sold of $44,721. At the end of the year, the accounts payable balance was $8,253. How long on average did it take the company to pay off its suppliers during the year

Answers

Answer:

Account payable days = 67.36 days

Explanation:

The payable days is the average length of time it takes a business to settle its account payable. It is calculated as thus;

Account payable days = Average account payable / Cost of goods sold × 365

Account payable = $8,253/44,721 × 365

Account payable = 67.36

Therefore, it will take Heritage about 67.36 days to settle its account payable

Which of the following items is an implicit transaction? Recognizing a gain on the sale of equipment Recording payment of monthly interest on loan Recognizing impairment on an intangible asset Recognizing deferred revenue through delivery of goods

Answers

Answer:

The correct answer is the second option: Recording payment of monthly interest on loan.

Explanation:

To begin with, the term known as "implicit transaction" in the field of business management and accounting refers specifically to the situation where the "transaction" was not intended in the first place as a directly situation to get, therefore that it is said to be an opportunity cost that happens when the company uses another resources in order to do another activities. For example the situation where the monthly interest on the loan is paid back to the company.

The management of Milque Corp. is considering the effects of various inventory-costing methods on its financial statements and its income tax expense. Assuming that the price the company pays for inventory is increasing, which method will: (a) provide the highest net income

Answers

Answer:

Milque Corp.

FIFO will provide the highest net income when the price of inventory is increasing.

Explanation:

The Generally Accepted Accounting Principles recognize four main methods to compute Cost of Goods Sold and Ending Inventory for a period.  They are:

First In, First Out (FIFO): This is based on the assumption that companies sell first the inventory that they bought first.

Last In, First Out (LIFO):  This method assumes that companies sell first the inventory that they bought last.

Weighted Average Cost (WAC): This inventory method assumes that companies average the costs of inventory and how much they sell over the period by dividing the cost of goods available for sale by the total physical inventory units.

Specific Identification: This method does not make any assumptions.  It directly identifies the product being sold and prepares costing calculations based on the specific inventory items.

The Andrews company currently has the following balances in their equity accounts: Common Stock $59,934 Retained earnings $32,340 Suppose next year the Andrews company generates $46,300 in Net Profit, and declares and pays $16,000 in Dividends. What will Andrews ending balance in Retained Earnings be next year

Answers

Answer:

the ending balance of the retained earnings is $62,640

Explanation:

The computation of the ending balance of the retained earnings is shown below:

= Opening retained earning + net profit - dividends paid

= $32,340 + $46,300 - $16,000

= $62,640

hence, the ending balance of the retained earnings is $62,640

The above formula should be used

Indicate for each of the following costs whether it is a product cost or a period cost.

1. Wages of aircraft mechanics employed by an airline.
2. Wages of drill-press operators in a manufacturing plant.
3. Cost of food in a microwavable dinner.
4. Cost incurred by a department store chain to transport merchandise to its stores.
5. Cost of grapes purchased by a winery.
6. Depreciation on pizza ovens in a pizza restaurant.
7. Cost of plant manager in a computer production facility.
8. Wages of security personnel in a department store.
9. Cost of utilities in a manufacturing facility.

Answers

Answer and Explanation:

The classification of the following cost i.e. either product cost or period cost is

1. Period cost as it deals with the operating expense

2 Product cost as it directly linked with the product

3  Product cost as it directly linked with the product

4  Product cost as it directly linked with the product

5  Product cost as it directly linked with the product

6  Product cost as it directly linked with the product

7  Product cost as it directly linked with the product

8 period cost as it does not directly linked with the product

9  Product cost as it directly linked with the product

BMW and United Airlines cannot be considered in the same industry analysis because they compete in different industries.

a. True
b. False

Answers

Answer: False

Explanation:

The statement that "BMW and United Airlines cannot be considered in the same industry analysis because they compete in different industries" is wrong.

It should be noted that both of them are in the mobility industry. The mobility industry refers to the industry which covers the broad range of the organisations which provide products and services thar are used to support domestic and international relocations and assignments.

Matilda, an employee, received an e-mail from an angry client about a certain product. Although it was not Matilda's fault, she hesitated to report it to her manager because she knew that he had a tendency to unfairly blame people for things. In this case, which of the following is true of Matilda's company?
a. Reviews are not held periodically
b. The firm's expectations are not established in writing
c. Employees are unclear about what needs to be achieved
d. "Shoot the messenger" management exists, implying a lack of control
e. Key data are not measured and reported in a timely manner

Answers

Answer:

d. "Shoot the messenger" management exists, implying a lack of control

Explanation:

The approach of "shoot the messenger" implies that the management of a company tend to blame the bearer of bad news as if they are responsible for the bad occurrence.

This approach causes tension and lack of communication in the workplace as employees are afraid of communicating when something bad happens.

Management is supposed to look objectively at the situation, identify the party that is responsible for the failure, and work towards rectifying it.

This is the situation in the scenario where Matilda received an e-mail from an angry client about a certain product and she hesitated to report it to her manager because she knew that he had a tendency to unfairly blame people for things

On February 1, 2020, Sheffield Corporation factored receivables with a carrying amount of $740000 to Ivanhoe Company. Ivanhoe Company assesses a finance charge of 4% of the receivables and retains 6% of the receivables. Relative to this transaction, you are to determine the amount of loss on sale to be reported in the income statement of Sheffield Corporation for February. Assume that Sheffield factors the receivables on a with recourse basis. The recourse obligation has a fair value of $3500. The loss to be reported is

Answers

Answer:

$33,100

Explanation:

Calculation to determine what The loss to be reported is

Using this formula

Loss=(Factored receivables*finance charge)+Fair value

Let plug in the formula

Loss=($740,000 × .04)+ $3,500

Loss= $29,600+$3,500

Loss=$33,100

Therefore The loss to be reported is $33,100

Bruno's Lunch Counter is expanding and expects operating cash flows of $26,100 a year for 4 years as a result. This expansion requires $62,000 in new fixed assets. These assets will be worthless at the end of the project. In addition, the project requires $3,600 of net working capital throughout the life of the project. What is the net present value of this expansion project at a required rate of return of 12 percent

Answers

Answer:

Year  Cash-flow   DF at 12%   Discounted cash flow

0       -$65,600         1.00           -$65,500

1          $26,100         0.8929       $23,303.57

2         $26,100         0.7972       $20,806.76

3         $26,100         0.7118         $18,577.46

4         $26,100         0.6355       $18,874.89

Net present value                       $15,962.68

Danny's workplace just started casual Fridays. What can Danny now wear to work on Fridays?

A black suit and tie
Jeans and a t-shirt
Shorts and a tank top
A swimsuit and flip flops

Answers

A black suit and tie

Flow Company has provided the following information for the year ended December 31, 2019: Cash paid for interest, $22,500 Cash paid for dividends, $6,500 Cash dividends received, $4,500 Cash proceeds from bank loan, $34,000 Cash purchase of treasury stock, $13,500 Cash paid for equipment purchase, $29,500 Cash received from issuance of common stock, $39,500 Cash received from sale of land with a $34,500 book value, $27,000 Acquisition of land costing $53,500 in exchange for preferred stock issuance. Payment of $125,000 note payable by exchanging used machinery with a $79,500 book value and $125,000 fair value How much was Flow's net cash flow from investing activities

Answers

Answer:

$2,500

Explanation:

  Net Cash flow from investing activities

Particulars                                                 Amount

Cash proceeds from sale of Land           $27,000

Cash Paid for Equipment Purchase       -$29,500

Net Outflow from investing activities  ($2,500)

When actions by individuals in a organization are directed toward the goal of furthering their own self-interests, it is termed as

Answers

Answer:

Organizational politics.

Explanation:

An interest group can be defined as a group of people sharing common aims, ideas and concerns, which seeks to influence government or a public policy.

This ultimately implies that, the interest groups consists of individuals who are only concerned about influencing public policy of the government on the basis of a particular common aim and interest.

Similarly, when actions by individuals in a organization are directed toward the goal of furthering their own self-interests such as being promoted, traveling to get estacodes, training, courses, etc., it is generally termed as organizational politics. Thus, you will see such employees (individuals) getting closer to top the executive management and patronizing them, in order to be in their good books.

An example of a type II error in quality control would be:counting a student s True/False response as incorrect when it is actually correct.throwing away a perfectly good fruit.eating food that you were unaware was spoiled.using clean bed sheet for every new guest in a hotel.

Answers

Answer:

the answer is a i just took the test got 100

Explanation:

The answer is True I think

For each separate case below, follow the three-step process for adjusting the accrued revenue account at December 31. Step 1: Determine what the current account balance equals. Step 2: Determine what the current account balance should equal. Step 3: Record the December 31 adjusting entry to get from step 1 to step 2. Assume no other adjusting entries are made during the year.

a. Accounts Receivable. At year-end, the L. Cole Company has completed services of $19,000 for a client, but the client has not yet been billed for those services.
b. Interest Receivable. At year-end, the company has earned, but not yet recorded, $390 of interest earned from its investments in government bonds.
c. Accounts Receivable. A painting company bills customers when jobs are complete. The work for one job is now complete. The customer has not yet been billed for the $1,300 of work.

Answers

Answer:

Dr Accounts receivable $19,000

Cr Earned service revenues $19,000

Dr Interest receivable $390)

Cr Interest revenue $390

Dr Accounts receivable $1,300

Cr Earned service revenue $1,300

Explanation:

Preparation to Record the December 31 adjusting entry

Dr Accounts receivable $19,000

Cr Earned service revenues $19,000

Dr Interest receivable $390)

Cr Interest revenue $390

Dr Accounts receivable $1,300

Cr Earned service revenue $1,300

Other Questions
How much of a 0.74mg sample of uranium-235 will remain after 2.8x10^9 Help help help I will give brainliest Which of the following best describes the relationship between reasons and evidence A. Reasons support the evidence B. Evidence support the reasonsC. Reasons and Evidence Are The Smallest Parts Of An ArgumentD. Reasons support the counterclaim and evidence does not TYPE THE QUESTION WORD. DO NOT FORGET THE ACCENT. CAPITALIZE BUT DO NOT USE PUCTUATION.How manywhowherehow muchwhywhen Which rule describes the translation PQR P'Q'R' ? what is chemical bonding?and types of chemical bonding there are? Can someone tell me how to give the brainliest award out. You will get it if you answer first The 500 cubic centimeter of 0.250 M Na2SO4 solution,added to an aqueous solution of 15.00 grams of bariumchloride, resulted in the formation of a white precipitate ofbarium sulfate. How many moles and how many grams ofbarium sulfate are formed, respectively? Classify the quadrilateral, and then find the value of the variable for each figure: What is the relationship between place and literature and Edgar Allan Poes the fall of the House of Usher Aprs avoir vu la scne, laquelle de ces deux phrases est la plus vraie ?Sandy comprend mieux sa relation avec Morgan.Morgan aime faire des btises. Which of these words with a medical context most likely has a Latin root meaning to bind or to compress?A.injected, meaning "inserted into the body"B.restricted, meaning "limited, as in diet or mobility"C.ascending, meaning "passing in an upward direction, as an aorta"D.germicide, meaning "substance that kills harmful microorganisms" When you hear the word "terrorism," what events come to mind? Whatabout these events fall into the category of terrorism, in your opinion? How do you awnser a question HELP! ILL MARK YOU BRAINLY OR WHATEVER ITS CALLED alytic Geometry_S2_2020InstructionActiveUsing Similarity Transformations to Determine SimilarityyWhat steps would you take to determine if these figuresare similar? Check all that apply.A"B"4Use a scale factor of 2.Multiply the vertices of polygon ABCD by 12D'CHx44Translate the intermediate image 4 units down.Perform two different dilations.Reflect the intermediate image.DBctivity I am doing my homework and am completely stumped on this one... help please?Describe the symmetry of the figure. Identify lines of symmetry, if any. Find the angle and the order of any rotational symmetry. What is the scope of hazard review in a worksite analysis calculate the moles of electrons obtained from 250c of electricity Who played the role of idealist at the Paris Peace Conference?A. David Lloyd GeorgeB. Woodrow WilsonC. George ClemenceauD. Vittorio Orlando