Aging Closing Stock (Units) with FIFO

[sajad570]

How to Age closing stock using FIFO movement when yearwise sales/purchase and opening stock is given.

<table border="0" cellpadding="0" cellspacing="0" width="1280"><colgroup><col style="width:48pt" span="20" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:48pt" height="20" width="64">
</td> <td class="xl65" style="width:48pt" width="64">
</td> <td colspan="4" class="xl70" style="width:192pt" width="256">Sales</td> <td class="xl65" style="width:48pt" width="64">
</td> <td colspan="4" class="xl70" style="width:192pt" width="256">Purchase</td> <td class="xl65" style="width:48pt" width="64">
</td> <td class="xl65" style="width:48pt" width="64">
</td> <td class="xl65" style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td colspan="4" class="xl71" style="width:192pt" width="256">Aging of Closing Stock</td> <td class="xl65" style="width:48pt" width="64">
</td> </tr> <tr style="height:30.0pt" height="40"> <td class="xl66" style="height:30.0pt;width:48pt" height="40" width="64">Opening Stock</td> <td class="xl66" style="width:48pt" width="64">
</td> <td class="xl67">2008</td> <td class="xl67">2009</td> <td class="xl67">2010</td> <td class="xl67">2011</td> <td class="xl68">
</td> <td class="xl67">2008</td> <td class="xl67">2009</td> <td class="xl67">2010</td> <td class="xl67">2011</td> <td class="xl67">
</td> <td class="xl66" style="width:48pt" width="64">Closing Stock</td> <td class="xl67">
</td> <td class="xl67">2007</td> <td class="xl67">2008</td> <td class="xl67">2009</td> <td class="xl67">2010</td> <td class="xl67">2011</td> <td class="xl67">Total</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt" height="20"> 10 </td> <td class="xl69"> Item A </td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69">
</td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69"> - </td> <td class="xl69">
</td> <td class="xl72"> 10 </td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69" style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:red;mso-pattern:black none"> - </td> </tr> </tbody></table>

 

[energman58]

Aged stock for 2007

= Max(Opening stock - Sum(sales from 2008 - 2011),0)

Aged Stock for 2008

= Max(Opening Stock + Purchases in 2008 - Sum(sales from 2008 - 2011) - Aged Stock for 2007,0)

Aged Stock for 2009

= Max(Opening Stock + sum(Purchases in 2008 - 2009) - Sum(sales from 2008 - 2011) - sum(Aged Stock for 2007 - 2008),0)

And so on

 

[sajad570]

energman58.....................you ROCK.

 

[energman58]

Welcome