aviation management break-even graph, management assignment help

Below are some costs for having a flying club that operates a single Cessna 152.
Fuel per hour:                  $30
Oil per hour:                   $2
Maintenance :  Annual inspection            $1,200
      100 hours of operation periodic inspections:      $800
Tie-down spot:                 $150 per month
Aircraft monthly purchase payments:            $700/mo.
Reserve fund for new engine:              $10/hour
Telephone scheduling & billing services:          $150/mo.
Hull and Liability insurance:              $350/mo.
Miscellaneous:                 $100/mo.

Question:  How many flight hours would your plane need to fly, given these expenses and costs, before it would Break-Even?

Use a rental rate of $100/hour.  (assume that both the Hobbs meter and Tachometer hours are the identical, for this problem).  You hope to average 60 hours of flight time per month.  Some months will be better, some worse.

Show all of your work (good and bad) in solving this problem.

Prepare a Break-Even chart or graph to complete the assignment.  Show VC, FC and Revenue lines.  Keep the dollars on the vertical axis, and the flight hours on the horizontal axis.

   Take the original FC and VC information from the first BE problem you submitted on Sept 26
.
   Fixed Costs (FC) were a total of $18,600 for the year (or $1,550 per month).  Variable Costs (VC) were $50 per hour flown 

   Add these to your computations
1.   You will charge dues of $10/month per club member.
2.   Your goal is to add 5 new members per month, but your starting out with no members.
3.   Your instructors will charge $35/hour, of which you will retain $10/hour as the owner.
4.   50% of all of the flight hours on the plane will be with flight instructors on board giving instruction.
5.   Non-members are charged $110/hour for the airplane, members are charged $100/hour.
6.   You conclude that in the first year, 50% of all of the flight hours will be flown by non-members.  50% of those hours will be with an Instructor.

QUESTIONS: (a)     At what point in time during the year will you Break-Even ?
                      (b)   How many  Flight Hours will it take to do so, and 
      (c)    How long will that take if your aircraft flies the following # hours per month. (see below)
      (d)    Prepare a new computer generated color B-E graph for this last problem (c).

  This a team/group assignment.  Turn in only one paper per group to be submitted by your designated team representative.

MONTH   HRS 
January   10 
Feb      30   
March    40   
April      60   
May      80   
June      100 
July      120 
August    110 
Sept        90   
October    80   
Nov        60   
Dec      40     
Year      820