A manufacturer of a smartphone battery estimates that monthly demand follows a normal distribution with a mean

Question:

A manufacturer of a smartphone battery estimates that monthly demand follows a normal distribution with a mean of 400 units and standard deviation of 26. Material cost is uniformly distributed between $7.00 and $8.50. Fixed costs are $2,700 per month, regardless of the production rate. The selling price is $15 per unit. 

a. Use Analysis ToolPak or R, both with a seed of 1, to simulate 1,000 trials to estimate the expected monthly profit and standard deviation. Demand values need to be rounded to integers, and use two decimal places for the material cost. 

b. What are the best and worst profit scenarios for the company?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Communicating With Numbers

ISBN: 9781260785005

1st Edition

Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen

Question Posted: