Estimate stahlmaere expected mean profit

Assignment Help Operation Management

Reference no: EM132194832

Stahlmaere Inc. is a start-up company that manufactures simple machines. It is interested in analyzing the profit from a new machine using Monte Carlo simulation. It wants to investigate the profit resulting from a selling price of $150 per unit. The setup and advertising costs are known to total $75,000. They assume that the demand for the product is normally distributed with a mean of 1500 units and a standard deviation of 100 units. The company estimates that the raw material cost per unit is uniformly distributed between $5 and $6. The labor cost per unit is assumed to follow a discrete uniform distribution from $12 to $16. A junior analyst has devised the following Excel spreadsheet that simulates a single scenario using the information given above: Selling price per unit = 150 Set up and advertising cost = 75000 Demand = =NORM.INV(RAND(),1500,100) Raw material cost per unit = =5+(6-5)*RAND() Labor cost per unit = =RANDBETWEEN(12,16) Profit = =(B1*B4)-B2-((B5+B6)*B4) Copy-and-paste the above information into cells A1:B8 of an Excel spreadsheet. Then use a data table to repeat the simulation 1000 times. From the simulation results, estimate Stahlmaere's expected mean profit. Understanding that simulation is random in nature and that your estimate is unlikely to match any of the answer choices exactly, choose the answer choice that is closest to the estimated mean profit. Question 14 options: $180,000 $50,000 $150,000 $90,000 $120,000.

Reference no: EM132194832

Questions Cloud

Money market so important to treasury management : Why is the money market so important to treasury management? Describe the key inputs used when developing a short-term investment policy.

Value of the objective function at the optimal solution : What is the value of the objective function at the optimal solution?

Describe what project scope management : Describe what project scope management is and why it is important in project management.

Five-week moving averages for the time series : Compute four-week and five-week moving averages for the time series.

Estimate stahlmaere expected mean profit : Then use a data table to repeat the simulation 1000 times. From the simulation results, estimate Stahlmaere's expected mean profit.

Analyze the future of utilization management approaches : Discuss basic approaches and techniques used in utilization management. Analyze the future of utilization management approaches.

Refer to the evaluating data quality learning activity : Refer to the "Evaluating Data Quality" learning activity. Imagine that you are a marketing specialist at a media company.

Compute the measures of forecast accuracy : Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy.

The influencing techniques with very high potential impact : What are reasons why a leader would not use one of the influencing techniques with a very high potential impact?

User Account

All Pages