<jupyter_start><jupyter_text>CSC-632 Project 2Author: <NAME>\Email: <EMAIL>  Problem 1In August 2020, a car dealer is trying to determine how many 2021 cars should be ordered.  Each car ordered in August 2020 costs $10,000.  The demand for the dealer’s 2021 cars has the probability distribution shown below.|Number of Cars Demanded|Probability||:-------------:| -----:||20|0.30||25|0.15||30|0.15||35|0.20||40|0.20|The dealer can order any integer number of cars.  Each car sells for \$15,000.  If the demand for 2021 cars exceeds the number of cars ordered in August, the dealer must re-order at a cost of \$12,000 per car. Excess cars may be sold to other dealers for \$9000 per car. A. Develop a simulation model for this problem. You can use MS Excel to depict the model.B. Using the trial and error method, determine how many cars should be ordered in August.C. For your optimal order quantity in part b, provide a 95% confidence interval for the expected profit.D. The dealer would like to know if the expected profit exceeds $120,000. Conduct a statistical analysis to answer the question with 97% confidence coefficient. Clearly determine the null and alternative hypothesis.E. Repeat this analysis if the demand for cars is assumed to be normally distributed with a mean of 30 and a standard deviation of 7. (Round the demand to an integer.)<jupyter_code><jupyter_output><empty_output><jupyter_text>Problem 2Six months before its annual convention, The Computer Science Conference (CSC) must determine how many rooms to reserve.  CSC believes the number of people attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000.  (Clearly, this demand must be rounded to an integer since only whole people attend the conference.)  At this time, CSC can reserve rooms at a cost of $50 per room.  CSC can reserve up to 8000 rooms, but it must reserve rooms in blocks of 100.  CSC must pay the \$50 room cost even if the room is not occupied.  If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of \$80 per room. A. Develop a simulation model for this problem. You can use MS Excel to depict the model.B. Using the trial-and-error method, determine the number of rooms that should be reserved to minimize the expected cost.C. For your optimal order quantity in part b, provide a 95% confidence interval for the expected cost.D. CSC would like to know if the expected cost exceeds $300,000. Conduct a statistical analysis to answer the question with 93% confidence coefficient. Clearly determine the null and alternative hypothesis.<jupyter_code><jupyter_output><empty_output><jupyter_text>Problem 3A ticket from Indianapolis to Orlando on Deleast Airlines sells for $150. The plane can hold 100 people. It costs \$8000 to fly an empty plane. The airline incurs variable costs of \$30 (food and fuel) for each person on the plane. If the flight is overbooked, anyone who cannot get a seat receives \$300 in compensation. Not everyone who has a reservation shows up for the flight. The number of people with reservations who actually show up for the flight is binomial with p = 0.95. (Do the following steps by hand or using MS Excel, and run the simulation using Python and include the .py file in the submission folder).a) To maximize expected profit, how many reservations for the flight should be taken by Deleast?b) What is the associated expected profit for this number of reservations?c) Provide a Hypothesis test with alpha=0.95 for the associated expected profit (from part a).d) Deleast Airlines would like to know if the expected profit is bellow \$5000. Conduct a statistical analysis to answer the question with 97% confidence coefficient. Clearly determine the null and alternative hypothesis.<jupyter_code># Parameters
ticketPrice = 150
planeCapacity = 150
variableCost = 30
reBookingCost = 300
proabilityOfShowingUp = 0.95

# Decision Variables
NumberOfReservationTakens = 100

# Calculations<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.053201970443349754, 'fraction_numerical': 0.03916256157635468, 'mean_word_length': 4.547814207650274, 'pattern_counts': {'":': 0, '<': 15, '<?xml version=': 0, '>': 15, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '382145', 'license': 'MIT', 'n_tokens_mistral': 1137, 'n_tokens_neox': 964, 'n_words': 619, 'path': 'project2/.ipynb_checkpoints/Chiu_Project2-checkpoint.ipynb', 'repo_name': 'twyunting/CSC-632_Intro-to-Simulation-and-Modeling', 'size': '4079'}