Ytytutuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

Develop an Excel worksheet simulation for the following problem. The management of Paragon Household Products is considering the

Alexxandr [17]

<h2><u>Disclamer:</u></h2>

As it ask to run simulations the values calculates will difer even if you follow the same step as I did.

Answer:

Mean Profit: $ 4,295

Probability of loss: 29.80%

As the product has a mean profit it will on average generate gains

but:

as the standard deviation of the simulation was $ 7,778.40

<u>we should not invest on the product as it is to variable</u>

<u>Explanation</u>:

We are going to use the =RAND() function of excel

which, generates a random number between 0 and 1

This will be done 1,000 times 500 for the variable cost

and 500 for the demand.

Then we copy and paste this numbers to get them fixed.

Then, we convert them into actual cost and demand in units considering their distribution

using excel dist.norm.inv

Now, with this values we solve for profit on each one.

<u></u>

FOr the complexity I attached the excel file as the plataform interface cannot handle large tables.

Download xlsx

6 0

3 years ago

A rise in the domestic real interest rate would cause a ________ in net exports and a ________ in the exchange rate.

Kisachek [45]

A rise in the domestic real interest rate would cause a fall in net exports and a RISE in the exchange rate.

In general, businesses and consumers spend less when interest rates are high. This is because borrowing money costs more when interest rates are high. As a result, companies frequently turn to the stock market to raise money, which can cause stock values to decline.

An increase in interest rates causes the local currency to appreciate. In comparison to domestic goods and services, import prices decline. Exports see a decline in profitability and competition. Exports decline while imports rise, reducing the net export portion of total demand and spending.

To learn more interest rate would cause a fall in net exports and a RISE about:

brainly.com/question/28475254

#SPJ4

5 0

1 year ago

Baxter company produces children's wiffle ball sets using a three-step sequential process that includes molding, coloring, and f

Nikitich [7]

<span>when the sets are completely finished, the cost should be transferred to: </span>W<span>IP inventory-Finishing
WIP stands for work in progress, which is an account to placed all the amount of manufactured product that still not ready to be sold to the market.
Since the manufacter process is in finishing stage (coloring/packing), the appropriate account should be </span>WIP inventory-Finishing

3 0

3 years ago

Lisa's opportunity cost rate is 10 percent compounded annually. How much must she deposit in an account today if she wants to re

Goryan [66]

Answer:

Present value = $21,804 (approx)

Explanation:

Given:

Periodic payment = $3,200

Number of period = 12

Interest rate = 10% = 10/100 = 0.1

Present value = ?

Computation of Present value:

$Present\ value = PMT[\frac{1-(1+r)^{-n}}{r} ]\\\\Present\ value = 3,200[\frac{1-(1+0.1)^{-12}}{0.1} ]\\\\Present\ value = 3,200[\frac{1-(1.1)^{-12}}{0.1} ]\\\\Present\ value = 3,200[\frac{1-0.318630818}{0.1} ]\\\\Present\ value = 3,200[\frac{0.681369182}{0.1} ]\\\\Present\ value = 21,803.6188$

Present value = $21,804 (approx)

8 0

3 years ago

Are you a successful entrepreneur essay in economics year 12

fgiga [73]

Answer:

Entrepreneurship is the name given to the factor of production which performs the functions of Enterprise. In economics, Land, Labour, Capital, Organisation and Enterprise are the five factors which are thought to be the basis of all the production activities. Entrepreneurship in a broader sense can be considered as a process of action undertaken by an entrepreneur (Person) to establish his enterprise. It is a creative and innovative response to the environment. Entrepreneurship can be described as a creative and innovative response to the environment. Such responses may take place in any field of social endeavour may be business, agriculture, social work and education etc.

<h2>Please mark me as brainliest</h2>

3 0

3 years ago