Let S= purchased units of the armoury certificate fund M= purchased units of the bullion market fund R=risk bit R=8S+3M 50S*10%+100M*4%?60,000 5S+4M?60,000 annual income 50S+100M?1,200,000 investment fund 100M?300,000 M?3,000 S?0 whenS=4,000, M=10,000 the do good become minimum $62,000 intention stall (Min)| | | | | | carrell| heel| Original pry| final nurse| | | | $B$15| Max descend mesh| 62000| 62000| | | | | | | | | | | | | | | | | varying stalls| | | | | | cadre| number| Original protect| closing observe| whole number| | | $B$12| Producted S| 4000| 4000| Contin| | | $C$12| Producted M| ten thousand| 10000| Contin| | | | | | | | | | | | | | | | Constraints| | | | | | cell| cause| Cell Value| Formula| Status| drowsy| | $B$19| Total amplification| 60000| $B$19>=$D$19| backrest| 0| | $B$20| Total benefit| 1200000| $B$20<=$D$20| Binding| 0| | $B$21| Total Profit| 10000| $B$21>=$D$21| not Binding| 7000| | $B$22| Total Profit| 0| $B$22<=$D$22| Binding| 0| b. 5S+4M=5*4000+4*10000=$60000 c. Max 5S+4M when S=18,000 M=3000, the annual impart lead be maximum 102000 accusive Cell (Max)| | | | | | Cell| Name| Original Value| lowest Value| | | | $B$15| Max Total Profit| 102000| 102000| | | | | | | | | | | | | | | | | Variable Cells| | | | | | Cell| Name| Original Value| Final Value| Integer| | | $B$12| Producted S|...If you insufficiency to get a dear essay, order it on our website: Orderessay
If you want to get a full information about our service, visit our page: How it works.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.