Introduction to Download & Install
15-day Trial of Risk Solver Platform v12.0

1. Click the following web page of Risk Solver Platform v12.0 http://www.solver.com/risk-solver-platform
And choose the “Get Your FREE 15 Day Trial” Button.

2. Fulfill the required registration information for downloading the free trial, then click “By checking this box, I indicate…” and choose “Register for Download” Button.

3. After registering your own account, web page transfers to the download page. For Windows Users, you can choose the 32-bit / 64-bit type and click “DOWNLOAD NOW” Button. For Mac Users, please visit the Mac Overview page.

4. Open the file “SolverSetup.exe”, and install the software. In addition, please check your email inbox to receive the installation password and the activation code.

5. We have successfully installed the Risk Solver Platform. Open the Excel, there is a table with “Risk Solver Platform”.

6. In order to solve the Large Scale Optimization problem, we need the additional Plug-in Solver Engines. Click the following page, http://www.solver.com/solver-engines

Choose the “Get Your Free 15 Day Trial” Button. Mark “By checking…” and Click “Proceed to Download Page” Button.

7. Here is the download page for the Plug-in Solver Engines. Choose your Windows operating type, and click “DOWNLOAD NOW”.

8. While downloading the file, there is an email about the “installation password” and “activation code” for the Solver Engines. Open the “EngineSetup” after downloading. Enter the “Installation password” while installing.

9. Choose all the Solver Engines.

10. Now you have successfully installed the Risk Solver Platform and the Plug-in for Large Scale optimization.

...Risk Solver Platform Install www.solver.com
Your request (#57566) has been deemed solved. To reopen, reply to this email or follow the link below:
http://solver.zendesk.com/requests/57566
Register as a Student using Course Code: MBAC617F14 and Textbook Code: HIMSMC5
Check for on an Install Password and an Activation Code
Download and Install Solver
Kate, Sep 08 09:25 AM:
Dear Musa,
Thank you for supplying the information about your upcoming course. We hope this course, including use of our software, will go well for you and your students. Please review carefully the information below, which has been gained through hard-won experience, with tens of thousands of students. Following these steps will greatly increase the chances that use of our software DOES go well for you and your students.
Your Course Code is MBAC617F14, for use ONLY by students in your course. Your Textbook Code is HIMSMC5, for the textbook you’re using.
We strongly recommend that you follow the student instructions below yourself, to register, download, and install our software, so you’ll know what your students will experience. Upon successfully installing the software, you’ll have a 140-day license. We’ll be happy to extend that license to a full year. To help us do this, you can start Excel, go to “our” tab on the Ribbon, choose Help – License Code, and in the dialog that appears, click the button Email Lock Code. This will open an email message to Frontline...

...Using Excel=s Solver Tool in Portfolio Theory
Excel contains a tool called the Asolver@ that lets you maximize or minimize functions subject to general constraints. We will use this tool to compute the global minimum variance portfolio and the tangency portfolio for the three-firm example (see the spreadsheet 3firm.xls). The spreadsheet for this tutorial is called solverex.xls. The data for this example are given in the following table
Stock 1 2 3 E[R] 0.229 0.138 0.052 VAR(R) 0.924 0.862 0.528 COV(I,J) 0.063 -0.582 -0.359 PAIR(I,J) (1,2) (1,3) (2,3)
For convenience, I have named the cells containing the expected returns, variances and covariances. See the 483solverex.xls spreadsheet. Using the Solver to find the global minimum variance portfolio Here we want to find the global minimum variance portfolio. That is, the portfolio of stocks 1, 2 and 3 that has the smallest variance regardless of expected return. In general, we want to solve the problem
minimize σ
x1, x 2 , x 3
2 p
2 2 2 2 = x 1σ 1 + x 2σ 2 + x 3σ 3 + 2 x 1 x 2σ 12 + 2 x 1 x 3σ 13 + 2 x 2 x 3σ 23 2 2
s. t. x 1 + x 2 + x 3 = 1
We can set up the Lagrangian for this problem and use it to solve for x1, x2, x3 and λ. This will give us four linear equations in four unknowns and we can use matrix algebra to find the solution. Alternatively, we can use the solver to compute the solution numerically (i.e. not using a formula). To use the...

...InnoCentive.com
Technology Strategy
InnoCentive
InnoCentive.com is a challenge driven innovation website that was founded in 2001 by Elli Lilly’s Venture unit. Its objective is to connect companies (the “Seekers”) to independent inventors, scientists or simply people that like challenges and to earn some money out of it (the “Solvers”). On the website, Seekers can post “R&D Challenges” to which Solvers submit their solutions. TheSolver(s) that will be deemed by the Seeker to have posted the best solution(s) will be granted with a financial reward. In this process, the InnoCentive scientific team works hand-in-hand with the Seekers in order to make sure the problem posted by the Seeker is articulated in a way to ensure that the problem is fully understood by the Solvers.
IC's Innovation Model
In our point of view IC’s model is essentially based on two key concepts: Crowdsourcing and Open Innovation. Thus, its advantages and success factors are closely related to those of the above terms.
When outsourcing a task or a problem to a “crowd” outside the company, the Seeker is able to access an enormous source of talent, ideas, and to a set of different perspectives of the same situation. If we bear in mind that InnoCentive is an Internet-based company, thus having the possibility of reaching almost everyone in the world, we are able to understand the potential of it.
On the other hand, an Open...

...environment safer from the start, rather than waiting for crime problems to develop and depending on law enforcement to handle them after the fact. By reviewing existing problem areas and applying the CPTED principles, those problems can be turned around.
The goal of using the CPTED philosophy is to design and build safer, more productive and user friendly environments, reducing costs and liability and ultimately, the improvement in the quality of life. There are no hard and fast rules in CPTED. CPTED is about sharing ideas and asking questions.
Sources:
WORTLEY, RICHARD and MAZEROLLE, LORRAINE. Environmental Criminology and Crime Analysis. Portland, OR: Willan Publishing, 2008.
CLARKE, RONALD and ECK, JOHN. Crime Analysis For Problem Solvers. Washington, D.C. U.S. Department of Justice, 2005.
"International CPTED Association". 2005. October 16 2010. ....

...Excel Tutorial Date: 25th February, 2010 by Nathan Smith
Install the Solver Add-In
1. In the Microsoft Office button, go to excel options to click Add-ins 2. In the Add-Ins box, select Solver Add-In and click Go...
Linear Programming Using Excel - 1
Install the Solver Add-In (continue)
3. In the Add-Ins available box, check the Analysis ToolPak and then OK
Linear Programming Using Excel - 2
Setting Up the Problem on the Spreadsheet
Example Min Z = 6X + 7Y s.t 2X + 6Y â‰¥ 10 5X + 3Y â‰¥ 10 X,Y â‰¥ 0
Linear Programming Using Excel - 3
(continued)
1. Enter the coefficients of the objective function Z i.e., (6, 7) in cells E5 and F5. 2. Enter the coefficients of the Constraint-1 i.e., (2,6) and RHS value 10 in cells E9, F9 and H9 respectively 3. Enter the coefficients of the Constraint-2 i.e., (5,3) and RHS value 10 in cells E10, F10 and H10 respectively
Linear Programming Using Excel - 4
(continued)
1. For the Objective function value, enter the formula for computing Z = SUMPRODUCT(E5:F5,E6:F6). This formula uses the coefficient values and also the solution values for variables X and Y, which are supposed to be solved. 2. Similarly enter the formula for LHS of the Constraints 1 & 2 i.e., SUMPRODUCT(E9:F9,$E$6:$F$6) & SUMPRODUCT(E10:F10,$E$6:$F$6) respectively
Linear Programming Using Excel - 5
Now Excel Solver will be used, in the Data tab click Solver....

...EXCEL SOLVER TUTORIAL
Many firms face the problem of how to best use multiple scarce resources. Linear programming is designed to help find the product mix that maximizes profits in the short run when multiple constraints exist. While linear programming can be solved as a mathematical problem using pencil and paper, it is much more efficient to use Excel Solver. The key to using Excel Solver is to make certain you have modeled the problem correctly and then interpreted the results appropriately. In this problem we will practice the use of Solver.
In this example suppose that you manufacture regular and premium golf carts. The selling price, variable costs and manufacturing times are as follows:
Regular
Premium
SALES PRICE
$ 8,000
$ 10,000
VARIABLE COST
5,600
6,500
CONTRIBUTION MARGIN
$ 2,400
$ 3,500
Assembly hours
20
50
Inspect and Test
5.0
2.5
Your company currently has 10,000 hours available for assembly and 1,200 hours for inspection and testing. There is also a limit to how many premium golf carts that can be sold (150 max). Given this information if you want to maximize profits what mix of regular and premium golf carts should you produce?
SOLUTION:
1. Input the above data into an Excel Spreadsheet (including constraints). Add cells for total hours used (these should be formulas). Add two additional lines...

...Linear Programming: Using the Excel Solver
Outline:
We will use Microsoft Excel Solver to solve the four LP examples discussed in last class.
1. The Product Mix Example
The Outdoor Furniture Corporation manufactures two products: benches and picnic tables for use in yards and parks. The firm has two main resources: its carpenters (labor) and a supply of redwood for use in the furniture. During the next production period, 1200 hours of manpower are available under a union agreement. The firm also has a stock of 5000 pounds of quality redwood. Each bench that Outdoor Furniture produces requires 4 labor hours and 10 pounds of redwood; each picnic table takes 7 labor hours and 35 pounds of redwood. Completed benches yield a profit of $9 each, and tables a profit of $20 each. We formulated the following linear program to solve this problem: Decision Variables:
Objective Function:
Constraints:
We will now solve this LP using the Excel Solver.
1.1
Getting Started
To begin using Excel, double-click on the Excel icon. Once Excel has loaded, enter the input data and construct relationships among data elements in a readable, easy to understand way. When building this foundation for your model, think ahead about the optimization model you will be developing. Make sure there is a cell in your spreadsheet for each of the following: • the quantity you wish to maximize or minimize • every decision variable • every quantity...

...It's hard to believe that in this current age, one of the wealthiest nations in the whole world lacks the ability to properly give all of its youth a worthwhile education. Although almost every child goes through the same grade levels, many children, especially those from run down urban areas, do not receive a quality education. America has the greatest amount of knowledge at its fingertips that it has ever seen due to technological advances, and still many children and adolescents are illiterate. Even though a child from a suburb school and one from a inner city school graduate from grade school, the child from the suburb might be up to two years ahead of the other in reading, writing, and mathematics (1). The problems with associated with inner city schools, which are usually full of minority children living in poverty, can only be solved with outside help.
Poorer residential areas in America are more likely to be located in the inner cities across the nation. Since most of the funding for schools comes from property taxes, those living in poor areas of the nation must also attend schools that lack the money and government funding that would otherwise help urban children receive an equal education as those who attend rural and suburban schools. The lack of money at these schools causes shortages on books, offered classes, extracurricular activities, and qualified teachers (2). The teachers may be new or lack the proper knowledge to teach. The teachers who are...