An independent mail delivery service wants to study factors that affect the daily gas usage of its delivery trucks. Using data collected from different trucks on various days, a company analyst uses a software to fit a regression model of the form =y+52.3+−8.9x14.1x2+5x30.09x4 , where =y volume of gasoline used (in gallons) =x1 weight of truck (in tons) =x2 tire pressure (in psi, pounds per square inch) =x3 weight of initial package load (in hundreds of pounds) =x4 total distance driven while delivering packages (in miles) Answer the following questions for the interpretation of the coefficient of x1 in this model. Holding the other variables fixed, what is the average change in daily fuel used for each additional ton that a truck weighs? gallon(s) Is this change an increase or a decrease? increase decrease

1) A utility airport is being planned to serve a small community. The visual runway is to be 3600 ft. long. Indicate whether or not the following objects will be considered obstructions to air navigation by the FAA. (HINT: 1 nautical mile = 6076 ft.)

a) A 220-ft radio tower that is not in the landing approach, located 3.1 miles from the airport reference point. The ground elevation at the tower is 25ft higher than the established airport elevation.

b) A planned 75-ft-high office building within the landing approach 1/2 mile from the end of the runway.

2) For the utility airport indicated above, what length of runway is required if the airport is located at 6000 ft above sea level and has a mean daily maximum temperature of 75°F? The effective gradient is 1.2 percent. The airport must accommodate small airplanes having more than 10 seats.

1. Wastewater of 30ft³/s with a biochemical oxygen demand (BOD) of 55mg/l, and dissolved oxygen (DO) of 3.3mg/l enters a river where the flow is 125ft³/s with an ultimate BOD of 7.0 mg/l, and DO of 6.8mg/l. The downstream has an average velocity of 0.8ft/s.

i           Calculate the minimum DO level and its distance in miles downstream using the oxygen sag equation. Assume k₁ = 0.046 per day and k₂ = 0.304 per day. The saturation DO = 8.5mg/l. (1 mile = 5280ft)

ii          At what distance downstream would the DO level of the river be equal to 6.10 mg/l?

iii      How much should the wastewater DO be increased to maintain a minimum DO of 4.8mg/l anywhere along the river. Assuming that the BOD of the wastewater and the river flow remains the same?

1. Based on the tables below, write SQL command to perform the following tasks for MySql:

1. Create SALESREP and CUSTOMER tables
2. Create primary and foreign keys as appropriate. The custNo should use a surrogate key as the primary key with auto-increment
3. increase the balance of the Gonzales account by $100 to a total of $450?
4. Find an average customer balance
5. Display the name of the sales representative and the name of the customer for each customer that has a balance greater than 400

SALESREP

CUSTOMER

Joe​ Henry's machine shop uses 2450 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the​ brackets:

Annual demand 2,450

Holding cost per bracket per year $ 1.25

Order cost per order $ 18.25

Lead time 2 days

Working days per year 250

a.) Given the above information, what would be the economic order quantity (EOQ)?

b.) Given the EOQ, what would be the average inventory? What would be the annual inventory holding cost?

c.) Given the EOQ, how many orders would be made each year? What would be the annual order cost?

d.) Given the EOQ, what is the total annual cost of managing the inventory?

e.) What is the time between orders?

f.) What is the reorder point (ROP)

Question 1

We wish to see if, on average, traffic is moving at the posted speed limit of 65 miles per hour along a certain stretch of Interstate 70. On each of four randomly selected days, a randomly selected car is timed and the speed of the car is recorded. The observed times were:

70                    65                    70                    75

Assuming that speeds are normally distributed with mean m, is there evidence that the mean speed is not equal to the posted speed limit?

a. Check the needed conditions for both the test statistic and confidence interval. (Do not do a stemplot.)

b. State Ho and Ha.

c. Calculate the test statistic (if applicable – state the degrees of freedom)

d. Find the p-value.

e. What is the conclusion for this problem? Do you reject Ho?

f. Calculate the 95% confidence interval.

g. Interpret the confidence interval

For each of the following, situations, indicate whether Kanban or MRP would be more effective.

1. An automobile plant producing three styles of vehicles (0.8 point)
2. A custom job shop (0.8 point)
3. A circuit board plant with 40,000 active part numbers (0.8 point)
4. A circuit board with 12 active part numbers (0.8 point)
5. A plant with one assembly line where all parts are purchased (0.8 point)

Question 2 – ALL CALCULATIONS MUST BE SHOWN

A local theme park is losing money. The current price of admission is $60 per person with an average daily attendance of 750 people. You are an independent consultant employed to recommend a pricing strategy. The demand schedule estimated by the consultant is shown in the table below.

a. Fill in the blanks in the table above. There are 7 empty cells [marked as 0.5 marks per cell correctly filled]. Use the point method (ΔQ/ΔP)*(P/Q) to calculate the own-price elasticity of demand. (3.5 marks)

b. As a consultant what would be your recommendation regarding pricing strategy? Should the theme park change the price from $60? Justify your answer based on the price elasticity of demand. .

c. From the information in the table write the equation for the daily demand for theme park tickets in price dependent form (P=a-bQ). (2.5 marks)

d. Use the midpoint method to calculate the price elasticity of demand from $85 to $90. Explain whether demand is price elastic or price inelastic and interpret the value of this elasticity.

e. Theme park customers are able to purchase a $15 photographic package. At the current ticket price of $60, 34% of customers purchase photographic packages. The theme park estimates that a $3 price increase in theme park tickets would result in a 20% reduction in photographic packages purchased. Provide the name of, and calculate the value of, this elasticity. Interpret its value. What does this elasticity value tell the theme park managers about the relationship between theme park ticket prices and photographic packages? How many customers would purchase the photographic packages if theme park tickets increased by $3?

A researcher has boiled her hypothesis test down to the following information.

H0: p=0.7, Ha: p<0.7, α=0.02 x=117, n=172

Find the p-value.