Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago The company has the contract for 108 buildings When a box malfunctions, Phantom installs a new one and rebuilds the failed unit in its repair facility in Gary, Indiana The date for failed boxes over the last 2 years is shown in the following table Number of Failed Boxes per Month Probability 0 0 10 1 0 14 2 0 26 3 0 20 4 0 18 5 0 12 Simulate 2 years (24 months) of operation for Phantom and determine the average number of failed boxes per month from the simulation Was it common to have fewer than 7 failures over 3 months of operation (Start your simulation at the top of the 10th column of Table F 4 on page 795, RN 37, and go down in the table ) PLEASE COMPLETE ALL WORK ON EXCEL AND PROVIDE ALL WORK WITH EXPLANATIONS DO NOT COPY OTHER ANSWERS OR I WILL DISLIKE PLEASE COMPLETE ON EXCEL WITH PROPER FUNCTIONS AND ANSWERS

The Answer is in the image, click to view ...

Question: Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for 108 buildings.

Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for 108 buildings. When a box malfunctions, Phantom installs a new one and rebuilds the failed unit in its repair facility in Gary, Indiana. The date for failed boxes over the last 2 years is shown in the following table:

Number of Failed Boxes per Month	Probability
0	0.10
1	0.14
2	0.26
3	0.20
4	0.18
5	0.12

Simulate 2 years (24 months) of operation for Phantom and determine the average number of failed boxes per month from the simulation. Was it common to have fewer than 7 failures over 3 months of operation? (Start your simulation at the top of the 10th column of Table F.4 on page 795, RN = 37, and go down in the table.)

PLEASE COMPLETE ALL WORK ON EXCEL AND PROVIDE ALL WORK WITH EXPLANATIONS. DO NOT COPY OTHER ANSWERS OR I WILL DISLIKE. PLEASE COMPLETE ON EXCEL WITH PROPER FUNCTIONS AND ANSWERS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question type: Monte Carlo Simulation Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for...

Bus309: Excel 8. Rienzi Farms grows sugar cane and soybeans on its 500 acres of land. An acre of soybeans brings a $1000 contribution to overhead and profit; an acre of sugar cane has a contribution...

Bus309: Excel 10. Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has a contract for 108 buildings. When a...

BUS309: Excel AutoSave OFF O . .. Individual Course Project SP2023 (1) ~ Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Tell me Comments Share Calibri (Body) 11 A A...

Phantom Controls monitors and repairs control circuit boxes on elevators installed in multistory buildings in downtown Chicago. The company has the contract for 108 buildings. When a box...

A regional manager at Acme Markets would like to develop a model to predict the weekly sales of pet food based on the shelf space allotted to the food. The following table shows the results of data...

If striving to meet schedule or budget isnt top priority, what is?

Which of the following statements about aging accounts receivable is true? Multiple choice question. An existing balance in the Allowance for Doubtful Accounts account is ignored when when...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...