Reference no: EM132524094
Month Passengers Total Cost
January 891 $51,346.59
February 1,192 $64,651.76
March 1,456 $72,367.79
April 1,876 $81,761.01
May 1,345 $70,981.18
June 1,567 $76,652.76
July 1,632 $77,895.39
August 1,851 $80,098.55
September 1,398 $72,557.34
October 1,478 $73,447.81
November 1,209 $68,992.96
December 1,908 $88,993.08
Total 17,803 $879,746.22
Create scatter plot of these data and run a aggression analysis to answer the following questions.
Question a. is the number of passengers per month a reliable indicator of total costs? Why or why not?
Question b. what is top flights total cost equation?
Question c. determine the expected costs if top flight flies 1,400, 1,500, and 2,000 passengers during a month.
Question d. are these results consistent with what appears on your scatter plot?
Question 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?
Question 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?
Question 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?
Question 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?
Question i. are each of the activity levels that you presented in response to questions (e), (f), and (g) feasible?
|
Prepare Bramble December stockholders equity section
: Bramble Corporation has the following account balances at December 31, 2017. Prepare Bramble's December 31, 2017, stockholders' equity section
|
|
Find what is prime costs total
: Find What is prime costs total? Craigmont Company's direct materials costs are $4,100,000, its direct labor costs total $7,990,000
|
|
What is the present value of the sales price
: You can buy property today for $3.3 million and sell it in 5 years for $4.3 million. (You earn no rental income on the property.)
|
|
Prepare cullumbers journal entries for the purchase
: Prepare Cullumber's journal entries for (a) the purchase of the investment, (b) the interest received, and (c) the fair value adjustment
|
|
What is the required level of sales
: 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?
|
|
Prepare Flints journal entries for the purchase
: Prepare Flint's journal entries for (a) the purchase of the investment, and (b) the receipt of semiannual interest and premium amortization
|
|
Calculate Rodeos total cost of goods available for sale
: Calculate Rodeo's total cost of goods available for sale for the month of June 2010. Explain which accounting principle requires that a portion of total cost
|
|
Australian-based investment bank
: During the global financial crisis, at least one Australian-based investment bank collapsed, while others, including the subsidiaries of US and European firms
|
|
Conclusion for a manager making financial decisions
: Outline the significance of this conclusion for a manager making financial decisions.
|