4 Pages

SIS-Worms

Course: BEN-ISRAEL 711, Fall 2008
School: Rutgers
Rating:
 
 
 
 
 

Word Count: 2467

Document Preview

Optimization Cost in SIS Model of Worm Infection Jonghyun Kim, Sridhar Radhakrishnan, and Jongsoo Jang ABSTRACTRecently, there has been a constant barrage of worms over the Internet. Besides threatening network security, these worms create an enormous economic burden in terms of loss of productivity not only for the victim hosts, but also for other hosts, as these worms create unnecessary network traffic....

Register Now

Unformatted Document Excerpt

Coursehero >> New Jersey >> Rutgers >> BEN-ISRAEL 711

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Optimization Cost in SIS Model of Worm Infection Jonghyun Kim, Sridhar Radhakrishnan, and Jongsoo Jang ABSTRACTRecently, there has been a constant barrage of worms over the Internet. Besides threatening network security, these worms create an enormous economic burden in terms of loss of productivity not only for the victim hosts, but also for other hosts, as these worms create unnecessary network traffic. Further, measures taken to filter these worms at the router level incur additional network delays because of the extra burden placed on the routers. To develop appropriate tools for thwarting the quick spread of worms, researchers are trying to understand the behavior of worm propagation with the aid of epidemiological models. In this study, we present an optimization model that takes into account infection and treatment costs. Using this model we can determine the level of treatment to be applied for a given rate of infection spread. for the study of computer worms/viruses has been investigated in [4]-[6]. An analytical model is presented in [5] and [6] that captures the impact of the underlying topology on worm propagation. However, controlling the spread of worms in computer networks has recently become one of the most important issues. In this letter, we investigate the effect of controlling the spread of computer worms on network delays. A model is presented that can be used to determine the adequate level of control on the total network delay the delay caused by worms and the delay caused by controlling worm propagation. In addition, we present the optimal control problem of minimizing the total cost of infection which can be interpreted KeywordsOptimal control, treatment cost, epidemic model, as the network delay incurred by both infection and treatment. Pontryagins maximum principle. This letter focuses on the application of optimal control theory to minimizing the value of treatment costs. We derive the necessary conditions for our cost optimization problem which I. Introduction is solved numerically. Internet worms have recently become a major problem for the The rest of the letter is organized as follows. Section II security of Internet networks, causing a considerable amount of presents some of the important issues in computer networks. resources and time to be wasted on the prevention and treatment Section III gives a brief review of the classical epidemic of virulent attacks. In general, worms, defined as self- models and a modification of the susceptible-infectiouspropagating codes, have become much more sophisticated since susceptible (SIS) model with treatment to control Internet the Morris worm appeared in 1988 [1]. The task of detection and worm propagation. The analysis of optimization problems is prevention of worms has become more difficult with our existing given in section IV. Our numerical solution of the optimal computing infrastructure. The convenience of the Internet makes control problem is also introduced in this section. We conclude it more vulnerable to malicious Internet exploits. In the area of the letter with an outline of our future work in section V. virus and worm modeling, many studies have employed simple epidemiological models to understand the general characteristics of worm propagation. Epidemiological propagation models have II. Statement of Problems traditionally been used to understand and model the spread of 1. Infection Cost vs. Treatment Cost biological infectious diseases [2], [3]. The use of these models Manuscript received Feb. 20, 2006; revised Aug. 17, 2006. Jonghyun Kim (phone: +82 42 860 3843, email: jhk@etri.re.kr) and Jongsoo Jang (email: jsjang@etri.re.kr) are with Information Security Research Division, ETRI, Daejeon, Korea. Sridhar Radhakrishnan (email: sridhar@ou.edu) is with the Department of Computer Science, University of Oklahoma, Norman, USA. This letter considers the optimal control problem of minimizing the value of two costs: first is the infection cost which could impose a constant per period network cost (say, in link bandwidth, network delay, and excessive consumption of 692 Jonghyun Kim et al. ETRI Journal, Volume 28, Number 5, October 2006 resources) caused by infection; the second is the treatment cost also referred to as network delay incurred by a certain level of filtering countermeasures. In other words, both the infection cost and the treatment cost are considered to be variations of the nodal network delay. Our optimal control approach is proposed, which enables tradeoffs between the infection cost of compromised systems and the treatment cost of defensive countermeasures, with respect to time. Table 1. Notations of SIS infection model. Notation N S(t) I(t) Q(t) Definition Size of total vulnerable population Number of susceptible nodes at time t Number of infectious nodes at time t Number of treated infectious nodes at time t Infection rate Curing rate of an infectious node Treatment rate of an infectious node Infection cost A function of treatment cost Adjoint variable Epidemic threshold CI C(Q(t)) 2. Choosing the Number of Nodes to Filter We present a notion of an optimal number of nodes to receive filtering treatment at a certain infection rate, providing both a mathematical model of the control factors affecting how many nodes to filter, and the numerical solution of our analytical model. For the worm propagation model, we apply the classical SIS model [2], [3]. With this model, the assumptions are a) that during each period the infected nodes can receive treatment that will increase their rate of recovery, and b) they have no preventive properties upon recovery. The treatment will also be assumed to exist in discrete time. dI (t ) = I (t )[ N I (t )] I (t ). dt (1) We assume that at the beginning, t = 0, one host is infectious and the other (N 1) nodes are all susceptible. Let S(t) = N I(t) denote the number of susceptible nodes at time t. Replace I(t) in (1) by N S(t) and we get III. SIS Infection Model Two classical deterministic epidemic models are the basis of our experimental design. In classical epidemic models, a node is defined as an infectious node at time t if it has been infected by a worm before t. A node that is vulnerable to a worm is called a susceptible node. dS (t ) = S (t )[ N S (t )] + [ N S (t )]. dt The solution to (1) is I (t ) = I 0 ( N ) . I 0 + ( N I 0 )e ( N )t (2) (3) 1. Infection without Treatment The most common mechanism of infection is through contact with an infected node, and the mechanism of recovery is either deterministic or purely stochastic with a certain typical time of recovery. In the classical SIS model [2], [3], a recovered node immediately becomes susceptible again, while in a more complicated susceptible-infectious-removed (SIR) model [7], cured nodes become immune and effectively excluded from further dynamics. In the SIS model, each node stays in one of two states: susceptible or infectious. Each susceptible node becomes an infectious one at a certain rate. At the same time, infectious nodes are cured and become again susceptible at a different rate. In this model, having the infection and being cured, does not confer immunity. Infectious nodes have a constant probability of recovery in each period with treatment. There is no permanent immunity to the infection, so a cured node becomes susceptible again upon recovery. Using the terms defined in Table 1, the differential equation for the SIS model without treatment is We conclude that, as t , I = N , (4) where = / and I0 is the initial number of infectious nodes. Therefore, not absolutely all of the population gets infected. This shows that each infectious node infects others with an average value of per unit time. 2. Infection with Treatment Our optimization model, presented here, takes into account infection and treatment costs. Assuming that filtering treatment is available, infectious can nodes use a level of filtering during each period, which will increase the probability of recovery. The higher the level of filtering, the higher the number of packets which will be processed for treatment and hence the higher the treatment cost. Using (1) and (2), this can be expressed as dI (t ) = I (t ) S (t ) ( I (t ) Q(t )) Q(t ) , dt (5) ETRI Journal, Volume 28, Number 5, October 2006 Jonghyun Kim et al. 693 where > > 0, and I(t) Q(t) 0. Let U(t) denote the number of untreated infectious nodes at time t. Then (5) can be defined by dI (t ) = I (t ) S (t ) U (t ) Q(t ) , dt (6) Pontryagins maximum principle [8], [9]. In order to derive the necessary conditions, we introduce the adjoint variable and the Hamiltonian equation, H. This principle converts (8) and (9) into a problem of minimizing a Hamiltonian, H, for the optimization problem: H = C I I + C (Q) + [ ( N I ) ( I Q) Q] . where U(t) = I(t) Q(t). If Q(t) = I(t) in each period, then every node which is infected obtains treatment for infection and (6) becomes dI (t ) = I (t ) S (t ) Q(t ) . dt (10) Furthermore, there exists an adjoint function, (t), such that (t ) H = = C I ( N 2 I ) , t I (7) (11) Note that if the treatment is very effective, then it may be the case that I = Q, and the infection no longer is epidemic with full treatment, which is called the equilibrium state. The equilibrium of the model with full treatment is the same as that of the model without treatment if the recovery from infection is also very effective. where the state problem has initial values I(0) = I0 and the adjoint problem has final values (T) = 0. We then have to minimize H over 0 Q I, that is, H = C (Q) + ( ) = 0 . Q (12) IV. Analysis of Optimization Problems In this section we consider (time dependent) optimal control strategies associated with infection and treatment cost based on the classical SIS model. To determine the appropriate number of nodes to filter, we need to develop a mathematical model of the potential costs involved in infection and treatment at a given time. We will develop cost functions that system administrators can use to help determine an appropriate level of treatment. Our problem is to minimize the total cost of infection and treatment over the finite time period. Our objective function to be minimized is We denote the marginal cost of treatment as C(Q), then say C(Q) = Q where is equal to the marginal value of an additional unit of the treatment. Suppose Q* is an optimal control for the above problem and I* is the corresponding trajectory so that from (12) the solution for the optimal control is Q*(t) = ( ) *(t), 0 t T . (13) Substituting (13) into (9) gives ( ) & I* = I ( N I ) I 2 *, I*(0) = I0 (14) (15) [C I (t ) + C (Q(t ))]dt , T 0 I (8) & * = * (2 I N + ) C I , *(T) = 0. where the control function, Q(t), represents the fraction of total infected nodes consuming treatment (to reduce the number of nodes that may be infectious), subject to the infection equation: I (t ) = I ( N I ) ( I Q) Q , I(0) = I0 , t (9) The optimal control is determined by (13)-(15), that is, we must solve (14) and (15) for optimum trajectory and an adjoint variable. Next, we discuss the numerical solutions of the optimality system and the corresponding optimal control pairs, the parameter choices, and the interpretations. where , , and are known positive constants and I0 is the known initial infected node. 2. Numerical Results In this section, we study numerically an optimal treatment strategy for minimizing the total cost of infection since the full dynamic solution of the control problem is usually very difficult and an explicit function-formula does not exist except for very special cases [8], [9]. The optimal treatment strategy is obtained by solving the optimality system, consisting of two differential equations from the state and adjoint equations 1. Necessary Conditions for Optimization Our objective function balances the effect of minimizing the number of cases implementing the filtering treatments and minimizing the total cost of infection. The necessary conditions that an optimal control variable must satisfy come from 694 Jonghyun Kim et al. ETRI Journal, Volume 28, Number 5, October 2006 500 400 Q *(t) I *(t) 300 200 100 0 0 20 40 60 80 100 300 250 200 150 100 50 0 0 20 40 60 80 100 effective quarantine techniques, applying our knowledge of cost optimization problems to combating worm infections. References [1] E.H. Spafford, The Internet Worm Incident, ESEC89 2nd European Software Engineering Conf., Coventry, UK, 1989. [2] J.O. Kephart and S.R. White, Directed-Graph Epidemiological Models of Computer Viruses, Proc. IEEE Symposium on Security and Privacy, 1991, pp. 343361. [3] F. Cohen, Computer Viruses: Theory and Practice, Computers & Security, vol. 6, Feb. 1987, pp. 2235. [4] C.C. Zou, W. Gong, and D. Towsley, Code Red Worm Propagation Modeling and Analysis, Proc. 9th ACM Conf. on Computer and Communications Security, Nov. 2002, pp. 138 147. [5] C. Wang, J.C. Knight, and M.C. Elder, On Computer Viral Infection and the Effect of Immunization, Proc. 16th Annual Computer Security Applications Conf., 2000, pp. 246256. [6] J. Kim, S. Radhakrishnan, and S.K. Dhall, Measurement and Analysis of Worm Propagation on Internet Network Topology, Proc. 13th Intl Conf. Computer Communications and Networks (IEEE ICCCN2004), Oct. 2004, pp. 495-500. [7] J.C. Frauenthal, Mathematical Modeling in Epidemiology, Springer-Verlag, New York, 1980. [8] G. Knowles, An Introduction to Applied Optimal Control, Academic Press, New York, 1981. [9] M.D. Intriligator, Mathematical Optimization and Economic Theory, Prentice-Hall, Englewood Cliffs, N.J., 1971. Time t (a) Time t (b) Fig. 1. Optimal control strategy as a function of time. presented in previous section. Figure 1(a) shows that the average number of infected nodes is plotted as a function of time. The graph contains 1000 nodes; the infection, cure, and treated rates are = 1.0, = 0.2, and = 0.8, respectively. In Fig. 1, we assume that the cost weight factor, CI, associated with the number of infected nodes I(t) is less or equal to the marginal cost of treatment, , which is associated with a control Q(t). In Fig. 1, the set of the cost weight factors, CI = 200 and = 500, is chosen to illustrate the optimal treatment strategy. Note that, with treatment, the number of infected nodes eventually reaches almost 50% of the total population, and the infection growth slows down after that. However, without treatment, the number of infected nodes reaches almost 80% of the total population [2], [6]. Figure 1(b) shows that for the optimal treatment strategy, the control Q*(t) is plotted as a function of time with the same parameters as those in Fig. 1(a). This is an expected result because the number of infected nodes consuming a filtering treatment, Q(t), is decreased as the number of infected nodes, I(t), is reduced. In conclusion, the control Q(t) that follows this optimal strategy can effectively reduce the spread of infection and minimize the total cost of infection consisting of both infection and treatment costs. V. Conclusion In this letter, we have presented the optimal control problem of minimizing the total cost of Internet worm infection which can be interpreted as the network delay incurred by both infection and treatment. We focus on the application of optimal control theory to minimizing the value of two costs. We have derived the necessary conditions for our optimal control problem which is solved numerically. We have determined that by applying this optimal control strategy, one can very effectively reduce the spread of infection and minimize the total cost of infection. We are also currently working on the development of ETRI Journal, Volume 28, Number 5, October 2006 Jonghyun Kim et al. 695
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Rutgers - BEN-ISRAEL - 711
Controlling Pandemic Flu: The Value of International Air Travel RestrictionsJoshua M. Epstein1*, D. Michael Goedecke2, Feng Yu2, Robert J. Morris2, Diane K. Wagener3, Georgiy V. Bobashev2 1 Economic Studies Program, The Brookings Institution, Washin
Rutgers - BEN-ISRAEL - 711
New Strategies for the Elimination of Polio from India Nicholas C. Grassly, et al. Science 314, 1150 (2006); DOI: 10.1126/science.1130388 The following resources related to this article are available online at www.sciencemag.org (this information is
Rutgers - BEN-ISRAEL - 711
J. R. Soc. Interface (2005) 2, 295307 doi:10.1098/rsif.2005.0051 Published online 20 June 2005REVIEWNetworks and epidemic modelsMatt J. Keeling1, and Ken T. D. Eames2Department of Biological Sciences & Mathematics Institute, University of Warwi
Rutgers - BEN-ISRAEL - 711
Vaccination and the theory of gamesChris T. Bauch and David J. D. EarnDepartmentof Mathematics and Statistics, University of Guelph, Guelph, ON, Canada N1G 2W1; and Department of Mathematics and Statistics, McMaster University, Hamilton, ON, Cana
Rutgers - BEN-ISRAEL - 711
[Preprint of chapter 2 of Epidemic Models: their Structure and Relation to Data, ed. Denis Mollison, Cambridge UP 1995.]The Structure of Epidemic ModelsDenis Mollison SummaryThis paper reviews the basic components of epidemic models, and discusse
Rutgers - BEN-ISRAEL - 711
Supply Chain Coordination and Inuenza Vaccination Stephen E. Chick Hamed Mamani March 13, 2006 David Simchi-LeviAbstract Billions of dollars are being allocated for inuenza pandemic preparedness, and vaccination is a primary weapon for ghting inuen
Rutgers - BEN-ISRAEL - 711
The Optimal Composition of Influenza Vaccines Subject to Random Production YieldsSoo-Haeng Cho1UCLA Anderson School of Management, 110 Westwood Plaza, Los Angeles, CA 90095-1481 scho@anderson.ucla.edu December 30, 2007AbstractThe Vaccine and Rel
Rutgers - BEN-ISRAEL - 711
The Epidemics of Donations: Logistic Growth and PowerLawsFrank Schweitzer*, Robert Mach Chair of Systems Design, ETH Zurich, Zurich, SwitzerlandThis paper demonstrates that collective social dynamics resulting from individual donations can be well
Rutgers - BEN-ISRAEL - 711
Benjamin Peirce and the Howland Will Paul Meier; Sandy Zabell Journal of the American Statistical Association, Vol. 75, No. 371. (Sep., 1980), pp. 497-506.Stable URL: http:/links.jstor.org/sici?sici=0162-1459%28198009%2975%3A371%3C497%3ABPATHW%3E2.0
Rutgers - BEN-ISRAEL - 711
Published: October 6, 1866 Copyright The New York Times
Rutgers - BEN-ISRAEL - 711
Sally ClarkPage 102/10/2007Using Statistical Evidence in Courts: A Case Study Or What Went Wrong in the Case of Sally Clark?1 IntroductionThe debate about the usage of statistical evidence in criminal courts has a long history.1 Whilst the ca
Rutgers - BEN-ISRAEL - 711
Airline Yield Management with Overbooking, Cancellations, and No-ShowsJANAKIRAM SUBRAMANIANIntegral Development Corporation, 301 University Avenue, Suite 200, Palo Alto, California 94301SHALER STIDHAM JR.Department of Operations Research, CB 318
Rutgers - BEN-ISRAEL - 711
Dynamic Pricing in Airline Seat Management for Flights with Multiple Flight LegsPENG-SHENG YOUDepartment of Business Administration, Chang Jung University, 396, Section 1, Chang Jung Road, Town of Kway Jen, Tainan 711, TaiwanConsider a multiple b
Rutgers - BEN-ISRAEL - 386
Operations Management (33:623:386:03 & 10), Spring 2008Schedule (tentative)Class # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 -16 17 18 19 20 21 22 23 24 25 26 27 28 Date Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed Mon Wed
Rutgers - BEN-ISRAEL - 386
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69BCDEFGHLOOKUP, VLOOKUP and HLOOKUP
Rutgers - BEN-ISRAEL - 386
Example of errors in computingThe numbers in Cells Ci are called Ci Let: C2 := 2*C1 - 1*C1 C3 := 3*C2 - 2*C1 C4 := 4*C3 - 3*C1, etc. All these should be equal to C1 This happens if C1 is an integer See what happens if: Example 1: C1 = 0.001 Example
Rutgers - BEN-ISRAEL - 386
CONTRACTORS3 contractors can do a job. The job has to be done in The relevant data is as follows: Contractor Can do the job in Charges 1 20 100 2 10 200 3 18 days 90 $/day 12 daysDetermine a plan to do the job in minimal cost. Contractors can be h
Rutgers - BEN-ISRAEL - 386
The Bags Problem: The problem data Time Required Hours/Unit Regular Deluxe Cutting 0.70 1.00 Sewing 0.50 0.83 Finishing 1.00 0.67 Inspection 0.10 0.25 Profit 10.00 9.00 Hours Available 630 600 708 135The Bags Problem: Data and variables Time Requir
Rutgers - BEN-ISRAEL - 386
SHELLEquipment Bag Problem - First Example LP Regular 0.7 0.5 1 0.1 $10.00 Regular 500 Deluxe vailable A 1 630 0.833 600 0.667 708 0.25 135 $9.00 Deluxe 300Cut/Dye Sew Finish Inspect/Pack ProfitVariable x1 Objective FunctionVariable x2Make
Rutgers - BEN-ISRAEL - 386
1100 1050 1000 950 900 850 800 750 700 650 600 550 500 450 400 350 300 250 200 150 100 50 0 -50 -100 -150 -200 Row 11100 1050 1000 950 900 850 800 750 700 650 600 550 500 450 400 350 300 250 200 150 100 50 0 -50 -100 -150 -200 Row 11100 1050 1000
Rutgers - BEN-ISRAEL - 386
11666531.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16BCDEFGDiet Problem Corn 10 50 30 900 $0.60 0.00 Provided 46.54 243.65 100.00 4500.00 Soy 9 45 90 1200 $0.30 0.71 Oats 11 58 10 1000 $0.35 3.65 Cost $1.49 Fish Min Max 8 40 50 120 5 2
Rutgers - BEN-ISRAEL - 386
The Bike Wheels Problem: The dataSpokes Rims Wheels Machine time 0.04 0.6 Labor time 0.01 0.5 1.2 Cost 0.05 4 11 Selling price 0.1 10 50 Available 378 267Spokes Rims Wheels1 1-72 -1 1The Bike Wheels Problem: VariablesSpokes Rims Wheels Mach
Rutgers - BEN-ISRAEL - 386
11666619.xls1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22A B C D Bicycle Wheel Production Problem - "Grid" Version Activities Make Rims 0.6 0.5 0 1 0 $4.00 150EFMachine Time Labor Spokes Rims Wheels Direct Unit Cost Amount of Act
Rutgers - BEN-ISRAEL - 386
The Perfume Problem: The DataProcess Raw Material 1 1 3 0 4 0 $3.00 Activities Refine Brute 0 3 -1 1 0 0 $4.00 Refine Chanelle 0 2 0 0 -1 1 $4.00Raw Material Lab Time Regular Brute Luxury Brute Regular Chanelle Luxury Chanelle Direct Unit CostLi
Rutgers - BEN-ISRAEL - 386
11666542.xls1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25A B Perfume Problem - "Grid" VersionCDEFRaw Material Lab Time Regular Brute Luxury Brute Regular Chanelle Luxury Chanelle Direct Unit Cost Amount of Activity
Rutgers - BEN-ISRAEL - 386
PIGSKIN.XLSA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20BCDEFMultiperiod Production Problem Start inventory 50 1 Demand Prod. cost/unit Holding cost/unit 100 $12.50 $0.625 2 150 $12.55 $0.628 Month 3 4 300 350 $12.70 $12.80 $0.63
Rutgers - BEN-ISRAEL - 386
11666599.xlsA 1 2 3 4 5 6 7 8BCDEFGHIndustrial Gases Transportation Problem Unit shipping costs to Customer Total 1 2 3 4 5 Available Plant 1 $8 $6 $7 $10 $9 45 FromPlant 2 $9 $12 $5 $13 $7 60 Plant 3 $14 $9 $12 $16 $5 55 Total requ
Rutgers - BEN-ISRAEL - 386
11666564.xlsA 1 2 3 4 5 6 7 8 9 10 11 12BCDGroovy Juice Mixers, Inc. Minimum % Tropical Breeze Guava Jive Maximum % Tropical Breeze Guava Jive Grape Guava Papaya 0% 20% 20% 0% 40% 0% Grape Guava Papaya 100% 25% 25% 100% 50% 5% Grape Guava P
Rutgers - BEN-ISRAEL - 386
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Profit summary 28 29 30 31 Total profitBCDEFChandler Blending Problem Monetary inputsQuality level per barrel of crudesRequired quality level per barrel of prod
Rutgers - BEN-ISRAEL - 386
11666649.xlsA 1 2 3 4 5 6 7 8BCDPickles - Separate Advertising Min demand 5000 4000 30% 60% Adv Rate 3 5 Prod Cost $0.60 $0.85 Budget $16,000Sweet Dill Min Sweet Max SweetDATA11666649.xlsE 1 2 3 4 5 6 7 8FSelling $1.45 $1.75Co
Rutgers - BEN-ISRAEL - 386
INVEST.XLSA 1 2 3 4 5 6 7 8 9BCDEFGInvestment Problem Investment Min % Max% A 0% 30% B 25% 100% C 0% 40% Initial Cash Interest Rate Now $(1.00) $(1.00) Year 1 $0.20 $0.10 $(1.00) Year 2 $1.40 $1.60 Year 3 $1.25$1,000 8.00%DATAIN
Rutgers - BEN-ISRAEL - 386
INVEST.XLSA 1 2 3 4 5 6 7 8 9 10BCDInvestment Problem: Data Interest Rate Investment A B C Funds 8% Now $1.00 $1.00 $0.00 $1,000.00 8% Year 1 -$0.20 -$0.10 $1.00 $0.00 8% Year 2 $0.00 -$1.40 $0.00 $0.00DATAINVEST.XLSE 1 2 3 4 5 6 7 8
Rutgers - BEN-ISRAEL - 386
conmine1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28A B Consolidated MiningCDEFGFrom Mine Blue Mesa Dry PassShipping Cost To Boise West TX Capacity $4.50 $3.00 800 $3.50 $6.00 1000 Boise West TX $17.00 $
Rutgers - BEN-ISRAEL - 386
11666586.xls1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41A B C National Vehicular Seating, Inc. Production Data Assembly Hours Sewing Hours Weight Cost, Plant 1 Cost, Plant 2 Reg
Rutgers - BEN-ISRAEL - 386
11666663.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23BCDEFWidgetCo Project Scheduling (AON) Requires C -1 -C -26 -26Code A B C D E F G Code A B C D E F GActivity Train Workers Purchase RM Make SA 1 Make SA 2 Insp
Rutgers - BEN-ISRAEL - 386
11666670.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22BCDEWidgetCo Project Scheduling (AON)-SIMPLE vRequiresCode A B C D E F G Code A B C D E F GActivity Train Workers Purchase RM Make SA 1 Make SA 2 Inspect SA 2 Asse
Rutgers - BEN-ISRAEL - 386
Rutgers - BEN-ISRAEL - 386
11527167.xls1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22A B C D WidgetCo Project with Crashing (AON)E F Deadline 25GHIJKCode A B C D E FActivity Train Workers Purchase RM Make SA 1 Make SA 2 Inspect SA 2 AssembleDura
Rutgers - BEN-ISRAEL - 386
11666606.xlsABCDEFG1 WidgetCo Project with Crashing Deadline 2 3 Cost/Day Max Days 4 Code Activity Duration to Crash Crash 5 A Train Workers 6 $10.00 5 6 B Purchase RM 9 $20.00 5 7 C Make SA 1 8 $3.00 5 8 D Make SA 2 7 $30.00 5 9 E In
Rutgers - BEN-ISRAEL - 386
11666540.xlsA 1 2 3 4 5 6 7 8 9 10 11BCDEFGStockco Capital Budgeting Problem1 1 $19,000 $7,000 $50,000 Investment 2 1 $21,000 $9,000 3 0 4 1 $10,000 Total cost $5,000 $21,000 <=Investment level Total Net Return Investment cost Tota
Rutgers - BEN-ISRAEL - 386
ValuesA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21BCDEPlane Loading Problem Item Weight 1 4,000 2 800 3 2,000 4 1,500 Capacity 30,000 Cost/Unit $0.05 Item 1 2 3 4 Take 3 10 1 5 Weight 29,500 Weight $1,475Alternative Ship Volu
Rutgers - BEN-ISRAEL - 386
11527132.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22BCDEFGHIMachinco Assignment of Jobs to Machines Problem Costs to perform jobs on various machines Job 1 2 3 4 Machine 1 14 5 8 7 2 2 12 6 5 3 7 8 3 9 4 2 4 6 10
Rutgers - BEN-ISRAEL - 386
11666672.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28BCDEFGHIJKLMAn assignment problem with 8 persons and 8 jobs Costs of assinging persons to jobs 1 2 1 6 2 11 6 3 12 2 1 4 10 7 12 1 3 1
Rutgers - BEN-ISRAEL - 386
milkemA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24BCDEFGProblem 5.4 - "Boris Milkem" Data on selling prices of assets (in $millions) Asset 1 Asset 2 Asset 3 Asset 4 Asset 5 Asset 6 Sold in year 1 15 16 22 10 17 19
Rutgers - BEN-ISRAEL - 386
11527124.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17BCDEFGHIJKLMNWestern Airlines Set Covering ProblemCities Potential hub Covered AT BO CH DE HO LA NO NY AT 1 0 1 0 1 0 1 1 BO 0 1 0 0 0 0 0 1 CH 1 0 1 0 0 0 1 1 DE 0
Rutgers - BEN-ISRAEL - 386
A B C D E 1 Crew Assignment Problem: SmallTime Airlines 2 3 Duty Plan Cost 101 102 103 4 5 6 7 8 9 10 11 12 13 14 15 16 Covered: 17 18 Total Cost 19FGHIJKLMNOP201Flights Covered 202 203 401 402403501502503Use?A B
Rutgers - BEN-ISRAEL - 386
11666654.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16BCDEProblem 5.5 Data on pitchers Righty? (1 if yes, 0 if not) Cost (in $millions) Victories added Pitchers to sign (1 if signed, 0 if not) RS 1 Budget constraint (in $millions) Spent $11
Rutgers - BEN-ISRAEL - 386
ValuesA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31BCDGandy Fixed Charge Clothing ProblemInput data Shirts 3 4 40 $12 $6 $200 Product Shorts 2 3 53.33 $8 $4 $150 Pants 6 4 25 $15 $8 $100Labor hours
Rutgers - BEN-ISRAEL - 386
11666537.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25BCDPower Plant Problem (5.17) Boiler Min Steam 1 500 2 300 3 400 Turbine Min Steam 1 300 2 500 3 600 Run Boiler? 1 2 3 Total: Run Turbine? 1 2 3 0 1 1 0 1 1 Max
Rutgers - BEN-ISRAEL - 386
11666659.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26BCDEFGHIJKLMNOHiring Students Min Shifts Initials CM FI GR HS JD JE SR TR Availability Mon Tue Wed Thu Fri Profit/Shift AM PM AM PM AM P
Rutgers - BEN-ISRAEL - 386
ValuesA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46BCDEFGHIJKHuntco Plant/Warehouse Location Problem Plant to warehouse unit production, ship
Rutgers - BEN-ISRAEL - 386
LOGICAL CONSTRAINTS AND BINARY VARIABLESADI BEN-ISRAELLet A, B, C, denote some actions, and let A , B , C , be the corresponding decisions, i.e., X = 1, if action X is taken; 0, otherwise.We express logical conditions on the actions by con
Rutgers - BEN-ISRAEL - 386
Buying widgetsThe XYZ Corp. has a budget of $500,000, which it intends to use for buying widgets. There are three vendors, each with unlimited supply, who offered the following terms. Vendor 1 stipulates that an order must be no less than 4,000 widg
Rutgers - BEN-ISRAEL - 386
Tossing a CoinA coin shows "1" and "0" with probabilities p, 1-pp 0.4 Value Probability 0 0.6 1 0.4Simulated value #Rolling a dieA die shows "1", , "6" with given probabilitiesValue Probability 1 0.166667 2 0.166667 3 0.166667 4 0.166667 5 0
Rutgers - BEN-ISRAEL - 386
A Guessing GameThrow two dice and guess a number from 2 to 12 Your opponent always chooses the number in cell C10 If your number is closer to to the sum of the dice you win 1 point. If your opponent is closer you w There are 11 scenarios. Find the
Rutgers - BEN-ISRAEL - 386
11666634.xlsTranslator Hiring Problem Chance of Overtime Availability Fixed Cost per Translator Regular Order Cost Overtime Order Cost Revenue per Filled Order Translators Hired Actual Demand Overtime Translators Available Regular Orders Filled Ove
Rutgers - BEN-ISRAEL - 386
11666639.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25BCDETranslator Hiring Problem Chance of Overtime Availability Fixed Cost per Translator Regular Order Cost Overtime Order Cost Revenue per Filled Order Transla
Rutgers - BEN-ISRAEL - 386
0.25 0.24 0.23 0.22 0.21 0.2 0.19 0.18 0.17 0.16 0.15 0.14 0.13 0.12 0.11 0.1 0.09 0.08 0.07 0.06 0.05 0.04 0.03 0.02 0.01 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20200.25 0.24 0.23 0.22 0.21 0.2 0.19 0.18 0.17 0.16 0.15 0.14 0.13 0.1
Rutgers - BEN-ISRAEL - 386
11666627.xlsA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19BCDEOverbooking ModelTicket Price Penalty Seats Expected Demand Probability of Coming Overbooking Demand Tickets Sold Passengers Arrived Passengers Seated Passengers Not Seated
Rutgers - BEN-ISRAEL - 386
An illustration of the Central Limit TheoremWe generate 100 independent RV's in D17:D116, simulate their sum in D118, and compare its distribution with the "corresponding" normal distribution. Each RV is uniformly distributed on [0,a] where the a's
Rutgers - BEN-ISRAEL - 386
11666600.xls1 2 3 4 5 6 7 8 9 10 11 12 13 14 15A Classic 3-Door "Paradox" Door with car Door we pick at first Door Has car Is the door we picked Is a door Monty can show Random value Shown by Monty Door we would switch to Get car if don't switch