FIFOLIFO $-$ Unprotected.xls

Worksheet

Chart

FIFOLIFO

st Flow Assumptions

$\backslash$table$[[$Data Section$],[,,,,$Specific,FIFO,LIFO$],[$Purchase$,$Unit,Unit,Total,Units,Units,Units$],[$Date$,$Quantity,Cost,Cost,Sold,Sold,Sold$],[\backslash$table$[[$Beginning Balance$]],200,$$$400,$$$80,000,200,,],[$Mar $7,100,$$$440,$$$44,000,50,,],[$May $13,50,480,24,000,,,],[$Aug $28,200,520,104,000,200,,],[$Nov $20,150,560,84,000,50||,,],[$Total purchased,$500,,256,000,,,],[$Total available,$700,,$$$336,000,,,],[$Sales$,500,,,500,0,0],[$Ending balance,$200,,$these totals must agree,$],[,,$with cell B$17,,],[,,,,,,],[$Calculations$],[,,,$Specific ID$,$FIFO,LIFO,Average$],[$Cost of goods sold,,FORM$1,$FORM$2,$FORM$3,$FORM$4],[$Ending inventory cost,,FORM$5,$FORM$6,$FORM$7,$FORM$8],[$Total goods available,,$$0,$$$0,$$$0,$$$0$