MonthPassengersTotal Cost

January891$51,346.59

February1,192$64,651.76

March1,456$72,367.79

April1,876$81,761.01

May1,345$70,981.18

June1,567$76,652.76

July1,632$77,895.39

August1,851$80,098.55

September1,398$72,557.34

October1,478$73,447.81

November1,209$68,992.96

December1,908$88,993.08

Total17,803$879,746.22

Create scatter plot of these data and run a aggression analysis to answer the following questions.

a. is the number of passengers per month a reliable indicator of total costs? Why or why not?

b. what is top flights total cost equation?

c. determine the expected costs if top flight flies 1,400, 1,500, and 2,000 passengers during a month.

d. are these results consistent with what appears on your scatter plot?

e. if top flight sells tickets (seats) to passengers for $50 per one way trip, what is the required level of sales (in dollars and passengers) to break even?

f. if top flight sells tickets (seats) to passengers for $50 per one way trip, what is the required level of sales (in dollars and passengers) to generate $10,000 net income per month?

g. if top flight sells tickets (seats) to passengers for $50 per one-way trip, what is the required level of sales (in dollars and passengers) to generate $30,000 net income per month?

h. to triple profits from $10,000 to $30,000, does top flight need to triple the number of passengers carried per month?Why or why not?

i. are each of the activity levels that you presented in response to questions (e), (f), and (g) feasible?