Problem 12-14 (Algorithmic) The management of Madeira Manufacturing Company is considering the introduction of a new product....

70.2K

Verified Solution

Question

Basic Math

Problem 12-14 (Algorithmic)

The management of Madeira Manufacturing Company is consideringthe introduction of a new product. The fixed cost to begin theproduction of the product is $36,000. The variable cost for theproduct is uniformly distributed between $20 and $28 per unit. Theproduct will sell for $56 per unit. Demand for the product is bestdescribed by a normal probability distribution with a mean of 1,200units and a standard deviation of 100 units. Develop an Excelworksheet simulation for this problem. Use 500 simulation trials toanswer the following questions:

  1. What is the mean profit for the simulation? Round your answerto the nearest dollar.

    Mean profit = $ ___
  2. What is the probability that the project will result in a loss?Recalculate the numerical value of probability in percent and thenround your answer to the nearest whole number.

    Probability of Loss =____ %

Answer & Explanation Solved by verified expert
3.6 Ratings (624 Votes)
To simulate the variable cost from uniform distribution we use20 2820RANDTo    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students