Question: Please tell me how to solve the problems below using Excel Please tell me all the formulas please 25. Simulate the profit per unit by

Please tell me how to solve the problems below

Please tell me how to solve the problems below using Excel

Please tell me all the formulas please

25. Simulate the profit per unit by performing 20 random trials for each individual cost.

26. On the basis of your simulation in part 25,

a. In new lines entered below this part, state to the nearest penny the mean profit per unit.

b. In new lines entered below this part, state to the nearest penny the profit variability per unit as measured by the standard deviation.

c. In new lines entered below this part, state to the nearest penny the lower limit of the 95% confidence interval for mean profit.

d. In new lines entered below this part, state to the nearest penny the upper limit of the 95% confidence interval for mean profit.

. The management at XYZ Corporation needs to know the profit per unit sold of a new product. The new product is priced to sell for $45 per unit. The costs incurred in bringing this new product to market are for production, labor, and transportation (shipping). Empirical probability distributions for the purchase cost, labor cost, and transportation cost (all on a per unit basis) are as follows: Note: Profit = Selling Price Purchase Cost Labor Cost Transportation Cost

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!