dear all,
i need your help. pl find below one table in which i want to find automatically price for a, b and c grade sale price
explanation:
a) average selling price is $5 (all of a,b,c grade products)
b) in this a grade product % is 55, b and c 40 and 5% respectively. suppose if we produce 100 kg then a grade is 55 kg and b grade 40 kg and c grade is 5 kg
c) b grade sale price is 10% lower than a grade
d) c grade price is 20% lower than b grade
what you have to do is you have to write/find a formula in excel to find automatically price of a, b and c grade price. suppose if you put average price as $6 then grade a,b, c price should be calculated automatically in excel
regards
sarawanan
| sale price | $5 | ||
| a grade product | 55% | 5.45 | |
| b grade product | 40% | 4.91 | -10% |
| c grade product | 5% | 4.36 | -20% |
CAclubindia
