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