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]
3 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]3 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
Publisher problem: Full court press inc buts slick paper in 1525 pound rolls for textbook paper. Annual demand is 1800 rolls. Th
larisa86 [58]

Answer:

C. 2.253

Explanation:

The time between orders in WEEKS in a 52 week year can be calculated as follows

DATA

Annual Demand (D) = 1800 rolls

Cost per roll = $900

Annual holding cost (Ch) = 15% of $900 = $135

Ordering cost (Co) =$225

Solution

EOQ = \sqrt{\frac{2CoD}{Ch} }

EOQ = \sqrt{\frac{2x225x1800}{135} }

EOQ = 78 rolls

Number of orders = 1800/78

Number of orders = 23.077

The time between orders = 52/23.077

The time between orders = 2.253

5 0
3 years ago
Despite the heavy reliance on e-mail, in certain situations calling may be the most efficient channel of communication, whether
Tju [1.3M]

Answer:

Option c and e                            

Explanation:

In simple words, Proper telephone etiquette becomes vital to business success as it is typically a consumer's initial point of contact so that reflects how your management  will handle them in those other communications. Ensure sure any consumer that calls your company gets a perfect, lasting experience.

Thus, one should talk to the client politely and be professional during the talks as it makes a positive impact of personality on the client.  

4 0
3 years ago
Jed is an electrician. Jed and his wife are accrual basis taxpayers and file a joint return. Jed wired a new house for Alison an
poizon [28]

Answer:

b. $3,000

Explanation:

Jed was refused payment of $5000, the court awarded only $2000, rest $3000 is a loss for Jed. He can only deduct $3000 and not full $5000 as $2000 has been realized.

Therefore, The amount of loss may Jed deduct in the current year is $3,000.

3 0
3 years ago
Which type of graphic organizer would best organize your notes on how to start a small business?
Dimas [21]
My best guess is a timeline!
4 0
3 years ago
Which of the following accurately describes a shortage?
muminat
"Consumer demand for a certain car is greater than the number of cars that can be produced" is the one among the following that <span>accurately describes a shortage. The correct option among all the options that are given in the question is the first option or option "a". I hope the answer helps you.</span>
3 0
3 years ago
Read 2 more answers
Other questions:
  • Broadway Corporation was granted a patent on a product on January 1, 2007. To protect its patent, the corporation purchased on J
    9·1 answer
  • Which of the following statements is false with respect to bonds? a. Firms issue bonds in very large single issues. b. The denom
    12·1 answer
  • What does dyslexia affect?
    10·2 answers
  • Taggart Inc. is considering a project that has the following cash flow data. What is the projects payback? Year 0 1 2 3 Cash flo
    9·1 answer
  • Many Americans are selling their used cars and buying new​ fuel-efficient hybrids. Other things remaining the​ same, in the mark
    5·1 answer
  • Sally promotes her sunscreen product by claiming that with just one
    12·1 answer
  • The Economic Stabilization Fund, created by the state legislature in 1988 as a sort of state savings account, is often also refe
    9·1 answer
  • The time to research a potential employer is _____.
    6·2 answers
  • John Hardley recently joined as marketing director of H2O, a water sports gear company. Though in the last five years the compan
    12·1 answer
  • A shipment that is transported using two or more modes during its journey is said to be?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!