Mean profit and probability of loss

Assignment Help Operation Management

Reference no: EM131181697

The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $35,000. The variable cost for the product is uniformly distributed between $17 and $25 per unit. The product will sell for $51 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,400 units and a standard deviation of 400 units. Develop an Excel worksheet simulation for this problem. Use 500 simulation trials to answer the following questions:

1. What is the mean profit for the simulation? Round your answer to 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 then round your answer to the nearest whole number.

Probability of Loss =

Reference no: EM131181697

Questions Cloud

Provide the base-case-worst-case and best-case analyses : The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $28,000. The variable cost for the product is expected to be between $14 and $27 with a most li..

Change in order to address the issues of outsourcing : How organizations and IT Personnel Managers will have to change in order to address the issues of outsourcing and/or off-shoring IT personnel. Support your position by researching and utilizing at least one credible sources of professional informatio..

Describe with your own words the five staffing models : Describe with your own words the five staffing models. Staffing quantity; staffing quality person/job match; staffing quality person/organization match, staffing system component and staffing organization model.

Company is interested in changing its security procedures : Your high-tech company is interested in changing its security procedures to include biometrics verification technology. Employee's fingerprints or retina patterns (or both) would no be scanned before entering to secret areas. You must investigate at ..

Mean profit and probability of loss : The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $35,000. The variable cost for the product is uniformly distributed between $17 and $25 per uni..

Effective progress meeting with your team members : Write a one to two page essay on what you will do as the project manager to hold an effective progress meeting with your team members. Include your approach to prepare for the meeting, describe what you will do during the meeting, and the actions you..

What kind of reports-other ancillary monitoring attributes : What kind of reports or other ancillary monitoring attributes should be documented at project termination? Why? How? Why is it called lessons learned? Are there some projects that can be closed out and documented easier than others? Why? How?

Implementation of information technology in health care : Why has implementation of information technology in health care and public health been so slow in comparison to other industries? Discuss the relative importance of factors such as ?nancial incentives or disincentives, organizational culture, complex..

Is use of profit sharing plan desirable in a small business : Is the use of a profit-sharing plan desirable in a small business?- What might lessen such a plan effectiveness in motivating employees?

User Account

All Pages