Use the above data and calculate Value of stock using FIFO and AVCO methods of inventory valuation and evaluate difference between value of stock in both the methods. Please write the calculations in EXCEL.

\begin{tabular}{|l|l|l|l|} \hline Date & Receipt/Issue & (Units) & Price per unit (OMR) \\ \hline 2nd February & Receipt & 6O & 100 \\ \hline 9th February & Receipt & 80 & 110 \\ \hline 11th February & Issue & 75 & - \\ \hline 16th February & Receipt & 90 & 135 \\ \hline 18th February & Issue & 40 & - \\ \hline 21st February & Receipt & 50 & 145 \\ \hline 23rd February & Issue & - \\ \hline \end{tabular}