Question: please provide step by step excel instructions!! thank you The revenue of a new product is $56 per unit. The production cost is given by

please provide step by step excel instructions!! thank you

The revenue of a new product is $56 per unit. The production cost is given by a discrete distribution that 60% the cost is about $20 per unit while 40% the cost is $35 per unit. The demand is normally distributed with mean 12000 units and standard deviation is 3500 . Given 1000 simulation, find average profit of the firm. Submit the excel file

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!

please give step by step excel instructions 10. Inkcorp Inc. is financing its new product line with issuance of 5 shares of 8 years 6% coupon bond with yield to maturity 7.5%, 60 shares of preferred...

POLARIS INDUSTRIES INC. With nearly $2 billion in sales in 2010, it was a strong player in the $10 billion power sports market alongside competitors Yamaha, Honda, Arctic Cat, Ski-Doo, and Harley...

Please explain calculations (so I can understand step by step) and attach excel document with graphs. 1.Compute and graph the total product curve (per cow) and the marginal product curve for...

The revenue of a new product is $56 per unit. The production cost is given by a discrete distribution that 60% the cost is about $20 per unit while 40% the cost is $35 per unit. The demand is...

Cost-Volume-Profit Analysis Using Excel for Cost-Volume-Profit (CVP) Analysis The Oceanside Garden Nursery buys flowering plants in four-inch pots for $1.50 each and sells them for $3.00 each....

I need help filling out the decision sheet for this business game. Help on how to complete the decision sheet COMPANY: Choose a name for your company Think of a strategy you want for your business....

In this project you are working with cost and financial information for a small computer manufacturer. The company manufacturers only two premium computers. One targets the high-end gamers market and...

A B C D E F G H Commented [G3]: W N H Metropolis Hospital Operating Budget Fiscal Period December 1 through November 30, 2012 Operating Expenses: General Supplies 1. This is the suggested format....

1. Consider the following vectors x, a, and b. -10 10 28 Can we write x as a linear combination of a and b? a) Formulate this question as a vector equation. 18 b) Give an approximate answer to the...

Make a three-dimensional drawing illustrating the magnetic anisotropy in 15, 16-dihydro-15, 16-dimethylpyrene, and explain why the methyl groups are observed at -4.2 ppm in the 1H NMR spectrum. -CH3...

Fintechs carry the disadvantage of heavy regulation. True or False

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...