.
.
Last-In, First-Out (LIFO)- Assumes that the last unit making its way into inventory is sold first. The older inventory is therefore left over at the end of the accounting period.
******** ******************** ************************************************************************><center>
Microsoft Excel - inv.xls | ___Running: 11.0 : OS = Windows XP |
<tbody>
</tbody> | | | | | | | | | | | | |
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout | <form name="formCb285793"><input *******="window.clipboardData.setData("Text",document.formFb506491.sltNb910359.value);" type="button" value="Copy Formula" name="btCb963142"></form> |
<tbody>
</tbody> | | | | | | | | | | | | |
<select onchange="document.formFb506491.txbFb548867.value = document.formFb506491.sltNb910359.value" name="sltNb910359"><option value="=F7" selected="">H7</option><option value="=F7*E7">J7</option><option value="=G7*I7">K7</option><option value="=J7">L7</option><option value="=H7+F8-G8">H8</option><option value="=F8*E8">J8</option><option value="=G8*I8">K8</option><option value="=L7+J8-K8">L8</option><option value="=H8+F9-G9">H9</option><option value="=F9*E9">J9</option><option value="=G9*I9">K9</option><option value="=L8+J9-K9">L9</option><option value="=H9+F10-G10">H10</option><option value="=E9">I10</option><option value="=F10*E10">J10</option><option value="=G10*I10">K10</option><option value="=L9+J10-K10">L10</option><option value="=H10+F11-G11">H11</option><option value="=((120*E9)+(250*E8))/G11">I11</option><option value="=F11*E11">J11</option><option value="=G11*I11">K11</option><option value="=L10+J11-K11">L11</option><option value="=H11+F12-G12">H12</option><option value="=F12*E12">J12</option><option value="=G12*I12">K12</option><option value="=L11+J12-K12">L12</option><option value="=H12+F13-G13">H13</option><option value="=E12">I13</option><option value="=F13*E13">J13</option><option value="=G13*I13">K13</option><option value="=L12+J13-K13">L13</option><option value="=H13+F14-G14">H14</option><option value="=E12">I14</option><option value="=F14*E14">J14</option><option value="=G14*I14">K14</option><option value="=L13+J14-K14">L14</option><option value="=H14+F15-G15">H15</option><option value="=F15*E15">J15</option><option value="=G15*I15">K15</option><option value="=L14+J15-K15">L15</option><option value="=H15+F16-G16">H16</option><option value="=E15">I16</option><option value="=F16*E16">J16</option><option value="=G16*I16">K16</option><option value="=L15+J16-K16">L16</option></select> | = | <input size="80" value="=F7" name="txbFb548867"> |
<tbody>
<form name="formFb506491"></form>
</tbody> | | | | | | | | | | | | |
| <center>A</center> | <center>B</center> | <center>C</center> | <center>D</center> | <center>E</center> | <center>F</center> | <center>G</center> | <center>H</center> | <center>I</center> | <center>J</center> | <center>K</center> | <center>L</center> |
<center>5</center> | | | | | QUANTITY | COST | | | | | | |
<center>6</center> | Nº | DATE | DOC. | DESCRIPTION | UNIT PRICE | IN | OUT | BALANCE | UNIT COST | DEBIT | CREDIT | BALANCE |
<center>7</center> | 1 | 01/09/2005 | | BEG. BAL. | 10.00 | 100 | | 100 | | 1,000.00 |
| 1,000.00 |
<center>8</center> | 2 | 12/09/2005 | C001 | IN | 20.00 | 300 | | 400 | | 6,000.00 |
| 7,000.00 |
<center>9</center> | 3 | 12/09/2005 | C002 | IN | 25.00 | 170 | | 570 | | 4,250.00 |
| 11,250.00 |
<center>10</center> | 4 | 12/09/2005 | V001 | OUT | | | 50 | 520 | 25.00 |
| 1,250.00 | 10,000.00 |
<center>11</center> | 5 | 23/09/2005 | V002 | OUT | | | 370 | 150 | 21.62 |
| 8,000.00 | 2,000.00 |
<center>12</center> | 6 | 27/09/2005 | C003 | IN | 30.00 | 700 | | 850 | | 21,000.00 |
| 23,000.00 |
<center>13</center> | 7 | 29/09/2005 | V003 | OUT | | | 450 | 400 | 30.00 |
| 13,500.00 | 9,500.00 |
<center>14</center> | 8 | 29/09/2005 | V004 | OUT | | | 250 | 150 | 30.00 |
| 7,500.00 | 2,000.00 |
<center>15</center> | 9 | 02/10/2005 | C004 | IN | 25.00 | 320 | | 470 | | 8,000.00 |
| 10,000.00 |
<center>16</center> | 10 | 03/10/2005 | V005 | OUT | | | 50 | 420 | 25.00 |
| 1,250.00 | 8,750.00 |
| | | | | | | | | | | | |
<tbody>
</tbody>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>
.
.