solve it using excel

solve it using excel

solve it using excel

solve it using excel

solve it using excel

solve it using excel

Salemach Corporation is a start-up company that manufactures simple machines. It is interested in analyzing the profit from a new machine. It estimates that the selling price will be $150 per unit and the setup and advertsing costs wil total $250,000. The company estimates that the that the per unit raw material cost is uniformly distributed between $50 and $80 and are equally likely. The demand is normally distributed with a mean of 12,000 units and a standard deviation of 3,000 units. The probability distribution fora range of labor cost per unit is elven below. Labor Cost $52 Probability 0.05 0.25 $53 $54 0.4 $55 0.25 $56 0.05 a. Obtain estimates for the mean profit, maximum profit, minimum profit, and standard deviation of profit. o. What is your estimate of the probability of a loss? Salemach Parameters Selling price per un Setup and Advertising Cost Labor Cost per unit Raw Materil and Cost Per Unit Demand Probability Raw Materil Cast Labor Cost 52 53 54 0.05 0.25 Demand 55 0.4 0.25 0.05 56 Madel Profit Mean Profit Maximum Profit Minimum Profit