Remark: parts of this question ask for an Excel solution. Pl…

Remark: parts of this question ask for an Excel solution. Please create a single Excel file with separate tabs for each part of the question and upload it with your answers.After resigning from his former job in Hollywood, Tom C is considering opening a new pizza restaurant, named “Mission Impizzable”. In preparation for the grand opening of Mission Impizzable, Tom decides to conduct some simulation analysis.   a) Market research indicates that the check ($$ spent) for a party of dine-in customers is distributed according to the Normal distribution with a mean of 250 and a standard deviation of 100. There are 5 tables in the restaurant, and there is one party per table per night, so there are exactly five dine-in parties per night.  Use Monte-Carlo simulation with at least 500 iterations to calculate the probability that the restaurant’s total revenue per night exceeds $1200.  Include your Excel file with calculations and answer the stated question. (4pts)   b) Market research further indicates that 85% of the customers use a credit card to pay their check. The credit card fee is 4%. Use Monte-Carlo simulation to calculate the average dollar amount collected by credit card companies (i.e., total credit card fees) in one night. You can assume that the average check ($$ spent) is the same as in part a). Include your Excel file with calculations and answer the stated question. (4pts) c) The restaurant opens at 6:00 pm. Market research suggests that the time (in minutes) between the opening of the restaurant, and the arrival of the first party of customers is distributed uniformly between 0 and 10 minutes.  This means, the first party will arrive sometime between 6:00 pm and 6:10 pm. Similarly, the time (in minutes) between the arrivals of the first and the second party also follows uniform distribution between 0 and 10.  The same is true for the times between the arrivals of any two subsequent parties. Given that there are 5 tables in the restaurant, how long will it take, on average, between the time when the restaurant opens and until all tables are fully occupied? Answer this question without using simulation. You can assume that once a table is occupied it remains occupied until the restaurant closes.  (3pts) d) Given the information in c), what is the probability that all the tables are occupied in less than 30 minutes after the restaurant opens? Use Monte-Carlo simulation with at least 500 iterations to answer this question. Include your Excel file with calculations and answer the stated question. (3pts)  

A female victim in a prior prosecution brings a civil action…

A female victim in a prior prosecution brings a civil action against the defendant to recover damages for sexual assault. The counsel for the female plaintiff calls a former girlfriend of the defendant who testifies that the defendant sexually assaulted and raped her on a previous occasion. This jurisdiction follows the Federal Rules of Evidence. The defendant’s counsel objects.How should the judge rule?

In an assault case the defendant’s counsel calls a witness w…

In an assault case the defendant’s counsel calls a witness who testifies that the defendant has a reputation in the community as a peaceable person. The prosecutor on cross-examination then asks the witness if she knows the accused has been twice convicted of aggravated assault. The defense counsel objects. How is a judge likely to rule concerning the admissibility of the evidence? The objection of defense counsel will be sustained because only evidence relating to opinion or reputation is admissible to test the credibility of the witness. The objection of defense counsel will be sustained because it is inadmissible character evidence. The objection will be denied because the prosecution is permitted to ask questions relating to prior specific acts on cross examination. The objection will be denied because the prosecution’s question concerns the credibility of the witness. Select the answer from the options below: