investment using optimmization
DESCRIPTION
This sheet is used to find optimal no. of stocks to invest to maximize the profit.TRANSCRIPT
Sheet1INVESTMENT MANAGEMENT UNDER TAXATION
Stock Data
NumberStockNumber of SharesPrice Purchased Last YearCurrent PriceNext Year Price EstimateGain this yearCurrent value1Yahoo!15015.6831.829.516.1210777.40281394562General Electric15022.124.2826.312.18invested amt3Microsoft15030.3932.534.552.118545.30686125854Bank of America1508.9314.1615.235.235JPMorgan Chase15040.5550.9962.4310.446Cisco Systems, Inc15018.5824.1726.685.597Intel15022.5423.6723.851.138Pfizer15024.8428.7731.663.931154.715Decisions:no.of.shares holdsoldObjective15010026507.525353162450100275757575375757575415001500515001500615001500775757575895.649884812554.35011518759654Constraintsno.of shares=0Cash amt10000=10000
Sheet2rawSGRGDFCrude sumGasoline sumConIronoutputQConIronC12400800.00000036388004000.00000036383000120.5SG>=300003000