Question: A project manager is trying to project net profit a new product to launch next year. The model include cost for labor, cost of parts,

A project manager is trying to project net profit a new product to launch next year. The model include cost for labor, cost of parts, demand for the product, selling price per unit and fixed costs. Demand is measured by the number of units to be sold and is uncertain input. Based on historical data for a similar product shows that number of units is random variable normally distributed with a mean of 80,000 and standard deviation of 10,000 units. The manager should simulate the number of units with the following formula:
Group of answer choices
=NORM.INV(RAND(),80,000,10000)
=NORM.INV(RAND(),60000,15000)
=(80000+(60000-10000)*RAND())
=Rand()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!