When answering this, could you please show the formulas/steps please? I'm having trouble with Part E and do not understand how to solve while using Excel.

A manufacturing company's production line breaks down an average rate of 6.5 times per month (that is, lambda = 6.5 times per month).

There are five parts to this problem (a through e).

a. What is the probability the production line will break down EXACTLY three (3) times next month?

0.06881

b. What is the probability the production line will break down FOUR (4) OR MORE TIMES next month?

0.88815

c. What is the probability the production line will break down between three (3) and six (6) times (inclusive) next month?

0.48349

d. The company severely fined a worker suspected of pilfering tools and supplies from the plant.

During the month following this disciplinary action, the production line broke down 15 times.

Management confronted the union with accusations of sabotage on the line, but the union president replied ". . . it's just bad luck that the production line happened to break down so many times in the month after the worker was disciplined."

{d.i.) CALCULATE THE OF PROBABILITY OF EXPERIENCING 15 OR MORE BREAKDOWNSin a month.

{d.ii.} BRIEFLY comment on how much of a "coincidence" 15 OR MORE breakdowns in a month would appear to be.

0.00296

Since there is a probability of 0.00296 of experiencing 15 or more breakdowns in a month, this is large coincidence.

e. History suggests it costs the company $10,750 in maintenance, repairs, and lost production time each time the production line breaks down. (Answer both parts of this question in the green shaded boxes below.)

{e.i.} What is the expected downtime cost PER YEAR for this production line? (NOTE: That says "..PER YEAR..")

{e.ii.} What is the probability the company will suffer the expected downtime COST you calculated in part e.i (immediately above) OR MORE next YEAR?

e.i

e.ii