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
oksian1 [2.3K]
2 years ago
5

E. In cell L16, enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects

Business
1 answer:
mrs_skeptik [129]2 years ago
8 0

The purpose of an AVERAGEIF function is to help one find the average of numbers that meet a certain criteria within a dataset.

<h3>What does an AVERAGEIF function do?</h3>

The full question is not provided so the best I can do is to provide a general overview.

An averageif function is available in spreadsheets and is used to find the average of numbers in a range of data that meet a certain criteria.

For instance, if you want to average the budget amounts for Action movie projects, a relevant formula would be:

= AVERAGEIF(Projects, "Action movie", Projects[Budgets])

Find out more on the Averagif function at brainly.com/question/19595618.

You might be interested in
Hughes Corporation is considering replacing a machine used in the manufacturing process with a new, more efficient model. The pu
pogonyaev

Answer:

50,000

Explanation:

Hughes Corporation can calculate the incremental cash outflow required to acquire the new machine by just deducting the sales proceeds from the cost of the new machine.

DATA

New machine = $150,000

Old machine = 100,000

Cash outflow per year (18,000 - 10,000) = 8,000

Salvage value = 25,000

Annuity factor = 8%

Solution

Incremental Cash outflow = Cost of new machine - Sales proceeds from old machine

Incrementa Cash outflow =  150,000 - 100,000

Incremental Cash outflow = $50,000

4 0
3 years ago
Kenny, Inc., is looking at setting up a new manufacturing plant in South Park. The company bought some land six years ago for $7
professor190 [17]

Answer:

$33,540,000

Explanation:

initial investment:

  • opportunity cost of land (resale price of land) = $10,700,000
  • building cost of the facilities = $21,900,000
  • other expenses related to the site (grading) = $940,000
  • total $33,540,000

The purchase cost of the land is considered a sunk costs, since it is not relevant now. What is relevant is the price at which the land could be sold at the moment of starting the project.

7 0
3 years ago
Troy Enterprises uses a continuous review inventory control system. The firm operates 50 weeks per year, with an annual demand o
timurjin [86]

Answer:

Safety Stock is 336.62 units

Explanation:

As per given data

Demand = D = 50,000

Ordering Cost = S = $35

Holding Cost = H = $1 per unit per year

Weekly Demand = Demand / 50 weeks = 50,000 / 50 = 1,000 units per week

Weekly Demand during Lead time of 3 weeks = 1000 x 3 = 3,000 units

Standard Deviation = 216.51 units

Desired Service level = 94%

The Z score at 94% service level is 1.55477  

Safety Stock = Zscore x standard deviation = 1.55477 x 216.51

Safety Stock = 336.62

8 0
3 years ago
An activity-based costing system ______. requires substantial resources provides benefits of improved accuracy that always outwe
Mashcka [7]

Answer:

1. Requires substantial resources.

2. produces different numbers than a traditional system.

3. Is costly to maintain.

Explanation:

Activity-based costing (ABC) system is a method of accounting assigns the total cost of activities such as manufacturing overhead costs and indirect costs necessary to produce a product or provide a service.

Basically, an activity-based costing (ABC) system is focused on the cost drivers associated with the respective activities, which are responsible for cost to be incurred. The cost drivers are activities such as direct labor, purchase order, machine use etc.

<em>Hence, an activity-based costing system requires substantial resources, produces different numbers than a traditional system and is costly to maintain.</em>

5 0
3 years ago
he annual interest on a $9000 investment exceeds the interest earned on a $1000 investment by $534. The $9000 is invested at a 0
Nadya [2.5K]

Answer:

The interest on investment of $9000 and $1000 is 5.41 % and 4.81% respectively.

Explanation:

Let i be the interest rate on $ 9000 investment, then

9000i + 1000(i -0.006) = $ 535

10,000i = 541

i = 5.41 % on investment of $ 9000.

than on  $1000 investment interest = 5.41-0.6 = 4.81 %

4 0
3 years ago
Read 2 more answers
Other questions:
  • What steps can a nation take to achieve economic growth?
    11·2 answers
  • When her salespeople bring in five new customers, marissa gives them a $1,000 payment. this is an example of a?
    6·1 answer
  • You own a big rental car company in Indianapolis and maintain a fleet of 50 SUVs. Customers make their rental car reservations u
    12·1 answer
  • Mellon Corporation The data presented below is Mellon Corporation for the year ended December 31, 2015: Sales (100% on credit) $
    9·1 answer
  • Laila created a new piece of workout gear. She's calling it the Toned Tushie. Although she couldn't initially find potential inv
    10·1 answer
  • Joy calls a mobile phone store to enquire about a new phone available in the market. The customer service operator sends him an
    12·1 answer
  • An oligopolistic market structure is distinguished by several characteristics, one of which is either homogeneous or differentia
    5·1 answer
  • The difference between indirect tax and subsidy is known as:
    6·2 answers
  • To which of the following would a
    11·1 answer
  • What is the purpose of unconscious bias training? include an example of how unconscious bias training can affect who gets to att
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!