Excel

Corvo Cycles (Pvt) Ltd.

Cost Statement

Model:-

'TR5' group by HS_Code"; $sql1="Select *,sum(percentage) as itemsum from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' AND percentage > '0' group by HS_Code"; //$sql1="Select * from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' "; $row=mysqli_query($conn,$sql1); while($record=mysqli_fetch_array($row)) { //$sql2="Select Sum(percentage) as itemsum from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' group by HS_Code"; //$row2=mysqli_query($conn,$sql2); //$record22=mysqli_fetch_array($row2); $hscode=$record['HS_Code']; $pricesum=number_format($record['itemsum'],2); //$pricesum=number_format($record['percentage'],2); //$itemnames=$record['Name']; $sql15="Select * from PC_Pricenew where Pc_No='$scno' AND Seq_No='$seqno' "; $row15=mysqli_query($conn,$sql15); $record15=mysqli_fetch_array($row15); $fobbdprice=$record15['Fob_BD']; $ch11=$record15['chk1']; $ch21=$record15['chk2']; if($ch11 == "on") { $price2=$record15['ibwsop1']; } if($ch21 == "on") { $price2=$record15['ibwsop2']; } //$pecentage=($price2/$fobbdprice)*100; $price1=$price2*$pricesum/100; $pecentage=$price1/$fobbdprice*100; $itemper=""; $sql2="Select * from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND HS_Code='$hscode' AND Name <> 'Freewheel' order by HS_Code "; $row2=mysqli_query($conn,$sql2); while($record2=mysqli_fetch_array($row2)) { $itemnames=$record2['Name']; $itemper=$itemper.",".$itemnames; //$Cntr=$Cntr.",".$data['CNTR_No']; } //$xx=$itemper."-".$pricesum; //echo $xx; //echo "
"; ?>
SC- Seq-
H.S CODE
PARTICULARS
China
Others
USD
Factory
0.00    
0.00
0.00  
0.00
3208.90.90 Paint 0.00  
0.00
Local Row Materials 0.00  
0.00
Material Cost
 0.00 0.00   0.00
Manufacturing Cost (welding, Rim manufacturiung, painting, assembly)
 0.00 0.00
Imp Exp and Operational costs
 0.00 0.00
0.00 0.00
Total Material Cost    
$0.00
Import
0.00%
  
Local
0.00%
  
Export Price    
$
Import
0.00
0.00%
 
Local + manufacturing cost
0.00%