aslamalaikum sir
please me find out per unit cost of & b product , total number of lubricant develpor , cylinder required 1200000 units
product 1 | lubricant cost | lubricant yield | develpor cost | develpor yield | clinder cost | clinder yield | per unit cost (according column b g) | total units | total lubricant required 1200000 units | total develpor required 1200000 units | total clinder required 1200000 units |
a | 6000 | 22500 | 14500 | 600000 | 12500 | 150000 | ? | 1200000 | ? | ? | ? |
b | 12220 | 53300 | 0 | 0 | 14099 | 295000 | ? | 1200000 | ? | ? | ? |
we can guess how yield/units related each other...
h3: =b3/c3+d3/e3+f3/g3
j3: =i3/c3*b3
k3: =i3/e3*d3
l3: =i3/g3*f3
andreas.
Office / Excel / Windows 8 / Office 2010
Comments
Post a Comment