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
yaroslaw [1]
2 years ago
14

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

introduction of a new product. The fixed cost to begin the production of the product is $25,388. The variable cost for the product is uniformly distributed between $15 and $20 per unit. The product will sell for $42 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1200 units and a standard deviation of 300 units. Develop a spreadsheet simulation that uses 500 simulation trials:A. What is the mean profit for the simulation?B. What is the probability that the project will result in a loss?C. What is your recommendation concerning the introduction of the product?
Business
1 answer:
Alexxandr [17]2 years ago
6 0
<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
You might be interested in
Aaron and Donald sign a written contract in which Aaron agrees to supply raw materials to Donald’s company in return for set fee
juin [17]
Unilateral contract is the correct answer
5 0
3 years ago
For the first time in two years, Big G (the cereal division of General Mills) raised cereal prices by 4 percent. If, as a result
bearhunter [10]

Answer:

b. inelastic

c. Yes - it decreased

Explanation:

Elasticitiy of demand measures the responsiveness of quantity demanded to changes in price.

Elasticity of demand = percentage change in quantity demanded/ percentage change in price

= -2/4 = -0.5

The absolute value is 0.5

If the absolute value of the coffiecnet of elasticity of demand is less than one, demand is inelastic.

Demand is inelastic if a change in price has no effect on quantity demanded .

We can tell that the quantity demanded fell because of the negative sign in front of the percentage change in quantity demanded.

I hope my answer helps you

7 0
3 years ago
What does it mean to say that a currency appreciates? depreciates? becomes stronger? becomes weaker?
erik [133]

When a currency appreciates, it means it increased in value relative to another currency; Depreciates means depreciation or depreciation relative to other currencies. It is often said that the dollar is strong when it is bought by equal or greater value in another currency. If the purchase amount is less than the equivalent, it is weak.

An example of a currency would be the US banknotes you have on hand. It is one of the coins issued by the United States, along with pennies, nickels and quarters. Currencies are also banknotes and coins issued by governments of other countries around the world.

Currency is anything of general value as a medium of exchange that can be exchanged for goods and services. The trading system within an economy is based on a currency, usually country-specific and issued by that country's government.

Learn more about currency here:brainly.com/question/24373500

#SPJ4

6 0
1 year ago
Pets Inc. makes 2 products, dog collars and cat collars. Each passes through the cutting machine, which is the binding constrain
maks197457 [2]

Answer:

Dog Collar 10,000 units

Cat Collar 15,000 units

Explanation:

We have only constraint of 2,000 hours on the cutting machine.

First we will calculate the Contribution margin per hour

Contribution margin per hour = Contribution margin per unit / Numbers of hours required per unit

Dog Collar = $10 / (6/60)hours = 10 / 0.1 = $100 per hour

Cat Collar = $8 / (4/60) hours = $120 per hour

Pets Inc. will make Cat collar more than dog

Hours required for 15,000 unit of Cat Collar = 15000 x 4 / 60 = 1,000 hours

Hours for Dog Collars = 2,000 - 1000 = 1000 hour

Unit of Dog Collar = 1000 hours / (6/60) = 10,000 units

5 0
3 years ago
One of the benefits of a next actions list is that it
puteri [66]

Based on findings suggested by David Allen in his book titled "Getting things done, " one of the benefits of a next actions list is that it "provides clarity, peace of mind, and focus."

  • When you have a Next action list available, it implies that you know what to do next as you finish one task.

  • This is also based on the idea that finding what to do next coupled with how to do it can lead to mental stress.

Hence, in this case, it is concluded that one of the benefits of a next actions list is that it "provides clarity, peace of mind, and focus."

Learn more here: brainly.com/question/22001271

5 0
2 years ago
Other questions:
  • he following information was drawn from the accounting records of Chapin Company. On January 1, Year 1, Chapin paid $56,000 cash
    6·1 answer
  • "GDP is an imperfect measure of economic​ well-being because it fails to measure what types of​ production?"
    8·1 answer
  • According to GAAP, the disclosure of accounting policies adopted by a reporting entity is important to financial statement reade
    6·1 answer
  • Prior to investing, you should..
    8·1 answer
  • Sheet Metals has an outstanding loan that calls for equal annual payments of $12,600.47 over the life of the loan. The original
    9·1 answer
  • __________ involves defining the firm's marketing mix variables so that target customers have a clear, distinctive, and desirabl
    7·1 answer
  • MC Qu. 74 If a firm's forecasted sales are... If a firm's forecasted sales are $238,000 and its break-even sales are $184,000, t
    15·1 answer
  • Prices for airline tickets change on average about once per month. This would suggest that airline ticket prices are
    15·1 answer
  • Mr. Frohardt donated $40,000 toward future scholarships. The scholarships are to be paid according to the following schedule:
    9·1 answer
  • Mollie has $550 in a savings account that earns 3% simple interest each year. If she does not deposit or withdraw from her accou
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!