Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    0
    ReputationRep:
    excel model s confusinggg :confused::confused:
    Offline

    11
    ReputationRep:
    Is there any sort of question or query you have or is this just a statement ?
    Offline

    0
    ReputationRep:
    Why don't you do your own work and background research rather than posting vague comments online about it in hopes of having it done for you.
    Offline

    0
    ReputationRep:
    PLEASE help !!

    stop being MEAN !!
    Offline

    11
    ReputationRep:
    Well what do you want to know?
    Offline

    0
    ReputationRep:
    i need the formula that wud be need in the "cost of tickets "!!
    tomo is my exam help !!
    Offline

    0
    ReputationRep:
    Basically my exmas tomorrow too. the formula would be far too complex for this type of exam. therefore the way around this is to activate the solver tool in excel. file < options < Manage Add-ins - and select the solver. by selecting the solver tool you can select the field you want to maximise by changing a certain cell. in other words when solver is open, the top box where you can give a cell reference is the individual flight profit and the second box to give a cell reference is the cost of tickets. as the formula is already linked to allow the number of tickets to change due to cost of tickets and fuel per km.
    Offline

    0
    ReputationRep:
    Basically my exmas tomorrow too. the formula would be far too complex for this type of exam. therefore the way around this is to activate the solver tool in excel. file < options < Manage Add-ins - and select the solver. by selecting the solver tool you can select the field you want to maximise by changing a certain cell. in other words when solver is open, the top box where you can give a cell reference is the individual flight profit and the second box to give a cell reference is the cost of tickets. as the formula is already linked to allow the number of tickets to change due to cost of tickets and fuel per km, so it will do it all for you.
 
 
 
Poll
Do you agree with the PM's proposal to cut tuition fees for some courses?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.