Hi,
i tried doing it but could not need expert help to solve this challenge.
Challenge description :
Restaurant Supplier wants profit. (example 1000)
Meal Order price may vary - from 8 to 5000
Meal original cost may vary too- example rs 50 for every meal order of rs 100 (50%)
we have to give discount (variable) on every order to customer
and variable commission example 1% will be paid to marketing company.
Input% Numbers
supplier profit 1000 1000
original order cost % (in put ranges between 1 to 100%) 50 ?
Discount% to be given to user 10 ?
Marketing commission% 1 ?
Note: all the fields with question marks needs to be populated using formulas in columns with ?
i tried doing it but could not need expert help to solve this challenge.
Challenge description :
Restaurant Supplier wants profit. (example 1000)
Meal Order price may vary - from 8 to 5000
Meal original cost may vary too- example rs 50 for every meal order of rs 100 (50%)
we have to give discount (variable) on every order to customer
and variable commission example 1% will be paid to marketing company.
Input% Numbers
supplier profit 1000 1000
original order cost % (in put ranges between 1 to 100%) 50 ?
Discount% to be given to user 10 ?
Marketing commission% 1 ?
Note: all the fields with question marks needs to be populated using formulas in columns with ?