1.) Suppose that the distance of fly balls hit to the outfield (in baseball) is normally distributed with a mean of 250 feet and a standard deviation of 50 feet. We randomly sample 49 fly balls. Using Excel and the functions show me how you got your answer

1. If¯¯¯¯¯XX¯ = average distance in feet for 49 fly balls, then¯¯¯¯¯XX¯ ~ _______(_______,_______)
2. What is the probability that the 49 balls traveled an average of less than 240 feet? Sketch the graph. Scale the horizontal axis for¯¯¯¯¯XX¯. Shade the region corresponding to the probability. Find the probability. using excel functions
3. Find the 80^th percentile of the distribution of the average of 49 fly balls. using excel functions

2.) Suppose that a category of world-class runners are known to run a marathon (26 miles) in an average of 145 minutes with a standard deviation of 14 minutes. Consider 49 of the races. Let¯¯¯¯¯XX¯ the average of the 49 races. Using Excel and the excel functions for the following questions. Show me how you got your answer

1. ¯¯¯¯¯XX¯ ~ _____(_____,_____)
2. Find the probability that the runner will average between 142 and 146 minutes in these 49 marathons. using excel functions
3. Find the 80^th percentile for the average of these 49 marathons. using excel functions
4. Find the median of the average running times. using excel functions

Scatter Diagrams and High-Low Cost Estimation
From April 1 through October 31, Will County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations:

a. Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs.

b. Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost-estimating equation for monthly labor costs.

d. Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 7 percent increase in wages.

Because movie producers have come under pressure for teaching children incorrect science, you have been appointed to help a committee of concerned parents review a script for a new Superman movie. In the scene under consideration, Superman rushes to save Lois Lane who has been pushed from a window 300 feet above a crowded street. Superman is 0.5 miles away when he hears Lois scream and rushes to save her. He swoops down in the nick of time, arriving when Lois is just 3.0 feet above the street, and stopping her just at ground level. Lois changes her expression from one of horror at her impending doom to a smile of gratitude as she gently floats to the ground in Superman's arms. The committee wants to know if there is really enough time to express this range of emotions, even if there is a possible academy award on the line. The chairman asks you to calculate the time it takes for Superman to stop Lois's fall. To do the calculation, you assume that Superman applies a constant force to Lois in breaking her fall and that she weighs 120 lbs. While thinking about this scene you also wonder if Lois could survive the force that Superman applies to her.

Which of the following are measures of capacity in terms of outputs and inputs produced for the corresponding production system?

Select one:

A. Airline – customers checked out per hour – reservation calls handled per day

B. Supermarket – available seat miles per year – cartons unloaded per hour

C. University – graduates per year – students admitted per year

D. Automobile assembly plant – autos assembled per year –packages delivered per day

In planning the long-term capacity of an operation, one should take into account:

Select one:

A. Bottlenecks

B. Economies of scale

C. Economies of scope

D. Only B and C

When a resource is scheduled as if it had unlimited capacity to handle any and all jobs, its schedule is called

Select one:

A. Bottleneck

B. Infinite loading

C. Finite loading

D. Cycle time

The __________ plan is a preliminary, approximate schedule of an organization’s overall operations that will satisfy the demand forecast at minimum cost.

Select one:

A. Production

B. Rough-cut capacity

C. Long-term

D. Efficiency

E. Aggregate

__________ means deciding which jobs to assign to which work centers.

Select one:

A. Loading

B. Sequencing

C. MRP

D. Facility planning

E. MPS

In each of the projects that follow, you should write a program that contains an introductory docstring. This documentation should describe what the program will do (analysis) and how it will do it (design the program in the form of a pseudocode algorithm). Include suitable prompts for all inputs, and label all outputs appropri- ately. After you have coded a program, be sure to test it with a reasonable set of legitimate inputs.

5 An object’s momentum is its mass multiplied by its velocity. Write a pro- gram that accepts an object’s mass (in kilograms) and velocity (in meters per second) as inputs and then outputs its momentum.

6 The kinetic energy of a moving object is given by the formula KE=(1/2)mv2, where m is the object’s mass and v is its velocity. Modify the program you created in Project 5 so that it prints the object’s kinetic energy as well as its momentum.

Write a program that takes as input a number of kilometers and prints the corresponding number of nautical miles. Use the following approximations:

- A kilometer represents 1/10,000 of the distance between the North Pole and the equator.

- There are 90 degrees, containing 60 minutes of arc each, between the North Pole and the equator.

- A nautical mile is 1 minute of an arc.

*please use IDLE( python 3.7)

Five years ago, a company was considering the purchase of 62 new diesel trucks that were 15.23% more fuel-efficient than the ones the firm is now using. The company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If the company manages to save on fuel costs, it will save $1.875 million per year (1.5 million gallons at $1.25 per gallon). On this basis, fuel efficiency would save more money as the price of diesel fuel rises (at $1.35 per gallon, the firm would save $2.025 million in total if he buys the new trucks).

Consider two possible forecasts, each of which has an equal chance of being realized. Under assumption #1, diesel prices will stay relatively low; under assumption #2, diesel prices will rise considerably. The 62 new trucks will cost the firm $5 million. Depreciation will be 25.17% in year 1, 38.07% in year 2, and 36.4% in year 3. The firm is in a 40% income tax bracket and uses a 11% cost of capital for cash flow valuation purposes. Interest on debt is ignored. In addition, consider the following forecasts:

Forecast for assumption #1 (low fuel prices):

Required: Calculate the percentage change on the basis that an increase would take place from the NPV under assumption #1 to the probability-weighted (expected) NPV.

Further Information (solution steps):

• Step (1): Calculate the annual expected price of diesel per gallon under each assumption, based on the probabilities outlined in the inputs section.

• Step (2): Using the annual expected fuel prices calculated in step (1), determine the increase in annual savings created by the proposed efficiency for each assumption.

• Step (3): Find the increased cash flow after taxes (CFAT) for both forecasts, based on the annual increase in fuel savings determined in step (2) as the increase in earnings before depreciation and taxes (EBDT), and the starting point from which profit is calculated for each assumption. As part of this step, you must establish annual depreciation (remember: depreciation is a noncash charge).

• Step (4): Considering the increased annual CFAT produced in step (3), calculate the NPV of the truck purchases for each assumption, based on the discount rate (cost of capital) indicated in the inputs section

• Step (5): In view of the outcomes produced in step (4), estimate the combined NPV weighed by the probability of each assumption.

• Step (6): Finally, calculate the percentage difference hypothesizing that an increase took place starting from the NPV for assumption #1 to the combined NPV worked out in step (5).

Please read the following case study. Submissions should follow the Case Study Rubric (see below).

M.R., a 59-year-old man, has been seen several times complaining of tremor in his hands that eventually made it difficult for him to work as a computer programmer. A diagnosis of essential tremor was made, and he was prescribed propranolol (Inderal) 20 mg twice daily. M.R. had good effects with the drug and had no further problems until the following June, when acute respiratory distress developed while he was picnicking in a state park with his family. On the way to the emergency room, he suffered an apparent respiratory arrest. He was admitted to the hospital and placed in the respiratory intensive care unit. It was found that M.R. had a history of hay fever and allergic rhinitis during the pollen season but had never experienced such a severe reaction.

Question 1: Why did M.R. have such a severe reaction?

Question 2:  What appropriate measures should be taken to ensure that M.R. recovers fully and does not re-experience this event ?

Question 3: What might you want to teach M.R. about this drug and its potential adverse effects?

Question 4: Using layman's terms, how do you explain to M.R. what happened; and how this situation will be avoided in the future.

--

All of the following requirements must be present to potentially receive full points for the Case Studies:

Include:

• Introduction
• Statement / Summary of the Problem
• Solutions or Recommendations / Answers to the questions
• Minimum of 3 scholarly references (less than 5 years old)

- Must be a minimum of 2 pages (not including title page or reference page)

CASE STUDY: The Nepalese Himalayas, A Protected Ecosystem?

In May of 2007 some 43 expeditions totalling 470 climbers summitted Mount Everest from both the Nepalese and Tibetan sides of the mountain. At one stage over 60 climbers were on or near the summit waiting (in some cases up to 1–2 hours) in order to get their chance to stand on the highest point in the world. If those 470 climbers had been asked why they chose to climb Mt Everest, somewhere in their answers would have been sentiments expressing a desire to experience one of the wildest places on earth. Technological innovations in mountaineering equipment, such as advanced clothing, bottled oxygen and the growth in the popularity of commercialized expeditions where clients are charged between US$40,000 and US$50,000 to be guided up the mountain will continue to attract hundreds of climbers as they attempt to fulfill a desire to experience one of the wildest places on earth. Research carried out in Sagarmatha (Mt Everest) National Park indicates that ecosystems above 4000 metres have been significantly impacted by tourism in the past 30 years. Impacts include the overharvesting of fragile alpine shrubs and plants for expedition and tourist lodge fuel, overgrazing, accelerated erosion, and uncontrolled lodge building. The present Nepalese government will continue to encourage tourism, as it is the country’s highest income earner.

YOUR ARGUMENT FOR OR AGAINST: A drastic reduction in expedition numbers and call for the complete banning, for 1 year, of climbing on all peaks over 8000 metres high. This reduction is necessary in trying to mediate a compromise between the conflicting needs of access, availability and presentability of an environmental or ecological product – wilderness – with those of the local population and the regenerative capacity of the ecosystem.

SUPPORT YOUR ARGUMENT WITH FACTS.

Our firm’s “Attorney-­?Client Access Policy” specifies that unless it’s an emergency, our clients can gain access to one of our attorneys either by scheduling a telephone appointment or else by scheduling an in­?office appointment. We do not tell clients we’ll call them back “within 24 hours”. Instead we schedule telephone appointments for a date and time certain.

We define an “emergency” as being a situation where a person’s death is imminent, the police are trying to interrogate a client, or when someone is in the act of doing something that threatens the client’s safety. We tell our clients that if their physical safety is at risk they should call 911 before calling our office. Still, as you should be able to imagine if you’re the right candidate for this position, the occasional worried client does manage to bluff his or her way through and will wind up on the telephone with you.

It’s 3pm on a sunny Wednesday afternoon. The attorney is taking a much­?needed break to clear his head by fishing at the park. He is at his favorite spot and has a cell phone with him in case there is an emergency.

A client calls and winds­?up on the phone with you with the following recitation of facts:

“I’m an important client of the firm, have been for some time. I’m at the bank and have been here for over an hour trying to get them to listen to what attorney told me to do. The bank manager is here and unless he talks to the attorney he’s going to close my account. I consider this to be an emergency and I insist that you get the attorney on the phone right away or at least get him to call me back as soon as humanly possible!”

How do you handle this situation?