Uploaded it

Sheet1
    Particluars    Amount ($)
    Total km    50
    Selling price    600
    Variable cost                    Computation of maintaince variable cost
    Fuel    50    per trip
    Barossa    40    per customer             Maintainance cost    11000    for 5000km
    Goodie bags for 3 Customer (1 set)    120    1 set of 3 customer             Maintainance cost    5000    for 1500 km
    Pilot cost    100    per trip            Variablce cost per km    1.7142857143
    Maintainance variable cost    1.7142857143                variable maintaince cost for 1500 km    2571.4285714286
    Total Maintainance variable cost    85.7142857143    per trip            variable maintaince cost for 5000 km    8571.4285714286
    Total variable cost per trip    355.7142857143                Fixed mainatiance cost    2428.5714285714
    Contribution per trip    244.2857142857
    Fixed cost    Amount ($)
    Helicopter rental    20000    per month
    Pilot cost    5000    per month
    Insurance per month    1000    unlimited
    Maintaince cost    2428.5714285714    per month
    Total fixed cost    28428.5714285714                69824
    Breakeven point    116.3742690058
    Breakeven point in dollars    69824.5614035088    70200
    Target profit after tax     120000
    Target profit before tax     171428.571428571
    No of trips after BEP    701.7543859649
    BEP (monthly *12)    1396.4912280702
    Total yealry trips    2098.2456140351
    monthly trips     174.8538011696
    Revenue per month for targte profit    104912.280701754
4-a
    Particluars    Amount ($)
    Total km    50
    Selling price    500
    Variable cost                    Computation of maintaince variable cost
    Fuel    50    per trip
    Barossa    40    per customer             Maintainance cost    11000    for 5000km
    Goodie bags for 3 Customer (1 set)    120    1 set of 3 customer             Maintainance cost    5000    for 1500 km
    Pilot cost    100    per trip            Variablce cost per km    1.7142857143
    Maintainance variable cost    1.7142857143                variable maintaince cost for 1500 km    2571.4285714286
    Total Maintainance variable cost    85.7142857143    per trip            variable maintaince cost for 5000 km    8571.4285714286
    Total variable cost per trip    355.7142857143                Fixed...