All categories

2 years ago

which what-if analysis tool is the best option for complex calculations requiring constrained optimization?

1 answer:

8 0

The what-if analysis tool would be the most adequate choice for intricate calculations that need contrived optimization:

b). Scenario manager

'What-if analysis tool' is described as the tools that are employed to alter the values present in the cells.
It is done to observe the effect of changing the values impact the results produced by the used formula.
The what-if analysis tools have been categorized into three distinct types:
a). Scenarios.
b). Goal Seek.
c). Data Tables.
As per the question, in order to opt for complex calculations, 'Scenarios' what-if analysis would be most adequate as they examine a number of variables and set of numbers/values that affect the outcome.

Thus, <u>option b</u> is the correct answer.

Learn more about 'what-if tool' here:

brainly.com/question/14830872

You might be interested in

If 7000 dollars is invested in a bank account at an interest rate of 7 per cent per year, Find the amount in the bank after 14 y

Harlamova29_29 [7]

Answer:

1. Interest compounded annually = $18,049.74

2. Interest compounded quarterly = $18,493.77

3. Interest compounded Monthly = $18,598.16

4. Interest compounded continuously = $18,651.19

Explanation:

First let me state the formula for compound interest:

The future value of a certain amount which is compounded is the total amount (Principal + interest) on the amount of money, after compound interests have been applied, and this is shown below:

FV = PV $(1+\frac{r}{n} )^{n*t}$

where:

FV = Future value

PV = Present value = $7,000

r = interest rate in decimal = 0.07

n = number of compounding periods per year

t = compounding period in years = 14

For interests compounded continuously, the Future value is given as:

FV = PV × $e^{r*t}$

where

$e$ is a mathematical constant which is = 2.7183

Now to calculate each on the compounding periods one after the other:

1. Interest compounded annually:

here n (number of compounding periods annually) = 1

Therefore,

FV = 7,000 × $(1+\frac{0.07}{1})^{14}$

FV = 7,000 × $1.07^{14}$ = $18,049.74

2. Interest compounded quarterly:

here, n = 3 ( there are 4 quarters in a year)

FV = 7,000 × $(1+\frac{0.07}{4} )^{4*14}$

FV = 7,000 × $1.0175^{56}$ = $18,493.77

3. Interest compounded Monthly:

here n = 12 ( 12 months in a year)

FV = 7,000 × $(1+\frac{0.07}{12} )^{12*14}$

FV = 7,000 × $1.005833^{168}$ = $18,598.16

4. Interests compounded continuously:

FV = PV × $e^{0.07 * 14}$

FV = 7,000 × 2.66446 = $18,651.19

3 0

3 years ago

Suppose that the Lorenz Curve for the U.S. in 2019 lies completely below the Lorenz Curve for Switzerland in 2019. This implies

Yuki888 [10]

219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69219.100.37.69

5 0

2 years ago

The objective of a statistical process control (SPC) system is to A. provide a statistical signal when natural causes of variat

marysya [2.9K]

Answer:

D. provide a statistical signal when assignable causes of variation are present

Explanation:

The objective of a statistical process control (SPC) system is to provide a statistical signal when assignable causes of variation are present

7 0

3 years ago

Which of the following is NOT a condition for a firm to engage in price discrimination? Multiple Choice The consumers are sincer

Radda [10]

Answer:

The correct answer is The consumers are sincere in revealing their true natures.

Explanation:

This is not a condition because the company does not take into account factors of this type to determine price changes, to consider the setting of new prices for products. In order to determine these changes, you must establish real data on the behavior of demand and determine if the goods produced have the characteristic of being storable to be traded over a longer period of time.

6 0

3 years ago

If a business had a capacity of $10,000,000 of sales, actual sales of $6,000,000, break-even sales of $4,500,000, fixed costs of

FrozenT [24]

Answer:

2000000

Explanation:

because that is what is left

5 0

3 years ago