Company is planning to manufacture new lightbulb

Assignment Help Operation Management

Reference no: EM132227403

SunLight Company is planning to manufacture a new lightbulb with an estimated mean lifetime run of 36,500 hours. Management also believes that the standard deviation is 5,000 hours, and that the lifetime hours are normally distributed.

Questions

A. Use Excel to simulate the hours obtained from a sample of 500 lightbulbs, and use the COUNTIF function to determine the number of bulbs that last longer than 40,000 hours. What is your estimate of the percentage of bulbs that will exceed 40,000 hours? Hint: See Appendix A for a description of the Excel COUNTIF function.

B. Use COUNTIF to find the number of lightbulbs expected to last fewer than 32,000 hours. Then, find the number with fewer than 30,000 hours and the number with fewer than 28,000 hours.

C. If management would like to advertise a light bulb guarantee such that approximately no more than 10% of the bulbs would last long enough to qualify for the guarantee, what is your recommendation as far as the life of the lightbulbs, in hours, that should qualify for the guarantee?

USE MICROSOFT EXCEL AND SHOW FORMULAS.

Reference no: EM132227403

Questions Cloud

Disadvantages regarding the existing labor practices : Ensure that you discuss specific advantages and disadvantages regarding the existing labor practices in South Korea.

Emerging leaders onboarding learning and development program : As you continue in Emerging Leaders onboarding learning and development program for the second quarter, you have experienced a few successes and now some wins.

How does that play into performance evaluation : What is a high level of formality and how does that play into performance evaluation?

How individual work and teamwork within organization : Organizational structure, or how individual work and teamwork within an organization are coordinated, is important because:

Company is planning to manufacture new lightbulb : SunLight Company is planning to manufacture a new lightbulb with an estimated mean lifetime run of 36,500 hours.

Contrast advantages-limitations of using financial models : Compare and contrast the advantages and limitations of using financial models in project selection to using scoring models in project selection.

Think about using tools like email-twitter-instant messaging : Discuss the impact of social media on workplace communication. What do you think about using tools like email, Twitter, instant messaging and other social media

Collaborative consumption or peer economy : Wikipedia comments in its definition that this new economy is “also known as shareconomy, collaborative consumption or peer economy;

Define project scope and create project scope statement : Identify and describe the three steps that the team should follow in order to define project scope and create a project scope statement.

User Account

All Pages