thermal separation course , please do the solution depends on group 18 parameters , and please if you can do it in excel sheet .

Q1. Ponchon Savarit Method 100kmole/h of a binary mixture ( A and B) of saturated vapour feed is processed in a distillation column. The mole fractions of the light boiling component (A) in the feed and in the distillate are shown in the attached table. The mole fraction of component in the bottom product is 0.05 . The amount of the heat qD (kcal/kmole) (which has to be dissipated in the condenser) is listed on the attached table. The following HXY diagram represents the Enthalpy on ( Y-axis) versus mole or weight fraction ( X or Y ) of component A on ( X-axis). Enthalpies are measured in kcal/kmole. Note: 1kcal=4.1868kJ Please a) construct the auxiliary line from (isotherms). (4 points) b) calculate the bottom-product and distillate stream. (5 points) c) determine the number of theoretical stages for the specified separation. (6 points) d) determine the minimum number of stages. (4 points) e) calculate the reboiler heat duty QB in Kw. (4points) f) what is the reflux ratio of this system. (2points) \begin{tabular}{|l|r|r|} \hline Xd & 0.95 & 0.95 \\ \hline Xf & 0.45 & 0.5 \\ \hlineqD & -24100 & -24100 \\ \hline Group & 17 & 18 \\ \hline \end{tabular}