Risk Analysis Pronability
You are a risk analyst at Max Inc., which operates 15 manufacturing plants in the United States. Industry experts predict that the next year will be a bad one for your industry and 70 percent of the manufacturing plants like yours in the United States will operate at a loss.
The CEO of your company has to provide an assessment of this prediction in the next monthly shareholders' meeting. To help her in this assessment, she asks you to determine the probability that 12 or more of your 15 manufacturing plants will incur losses next year.
Please see attached
© BrainMass Inc. brainmass.com June 18, 2018, 6:00 am ad1c9bdddfAttachments
Solution Preview
See the attached file. Thanks
You are a risk analyst at Max Inc., which operates 15 manufacturing plants in the United States. Industry experts predict that the next year will be a bad one for your industry and 70 percent of the manufacturing plants like yours in the United States will operate at a loss.
The CEO of your company has to provide an assessment of this prediction in the next monthly shareholders' meeting. To ...
Solution Summary
This solution shows step-by-step calculations in an Excel file to determine the probability that 12 or more of the 15 factories would lose money.