Archives
978-0078096600 Chapter 1 Exel
1 2 3 4 5 6 7 A B C D E Data Results Unit Revenue $35 Total Revenue $875,000 Fixed Cost $500,000 Total Fixed Cost $500,000 Marginal Cost $15 Total Variable Cost $375,000 Sales Forecast 25,000 Profit (Loss) $0 […]
978-0078096600 Chapter 1 Solution Manual
Chapter 01 – Introduction 1-1 Chapter 1 Introduction Review Questions 1.1-1 The rapid development of the discipline began in the 1940’s and 1950’s. 1.1-2 The traditional name given to the discipline is operations research. 1.1-3 A management science study provides […]
978-0078096600 Chapter 10 Exel Part 1
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 28 #N/A 29 #N/A […]
978-0078096600 Chapter 10 Exel Part 2
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 A B C D E […]
978-0078096600 Chapter 10 Exel Part 3
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 A B C D E […]
978-0078096600 Chapter 10 Solution Manual Part 1
10-1 Chapter 10 Forecasting Review Questions 10.1-1 The last-value forecasting method says simply to use the last period’s value as the forecast for the next period. It would be reasonable when conditions tend to change so quickly that values before […]
978-0078096600 Chapter 10 Solution Manual Part 2
10–21 e) Exponential-smoothing method with seasonality forecast = 22. 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 B C […]
978-0078096600 Chapter 10 Solution Manual Part 3
10–33 d) e) y = -3.38 + (0.093)(150) = 11 f) y = -3.38 + (0.093)(200) = 15 10.41 Joe should use the linear regression line y = –9.95 + 0.10x to develop a forecast for jobs (y) in terms […]
978-0078096600 Chapter 10S Exel
1 2 3 4 5 6 7 8 9 10 11 12 13 A B C D Time True Period Value 151 248 352 449 553 649 748 Best a 851 0.1128 950 10 49 11 50 1 2 3 […]
978-0078096600 Chapter 10S Solution Manual
CD10s-1 CD Supplement to Chapter 10 – Time-Series Forecasting with CB Predictor CD Supplement to Chapter 10 Time-Series Forecasting with CB Predictor Review Questions 10s-1 CB Predictor uses the raw data to provide the best fit for all these inputs […]
978-0078096600 Chapter 11 Exel Part 1
1 2 3 4 5 6 7 8 9 10 13 14 15 16 17 10.1875 Time2 C12 20.140625 WG7 30.10546875 Wq G8 40.07910156 0.3 11 12 Prob(Wq > t) = 3.4E-05 Rho G10 when t = 1 n PnsC6 […]
978-0078096600 Chapter 11 Exel Part 2
1 2 3 4 5 6 7 8 9 10 13 00.25 Time1 C9 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 10.1875 Time2 C12 20.140625 WG7 […]
978-0078096600 Chapter 11 Exel Part 3
35 36 37 38 A B C D E G H I J K 22 0.00071801 23 0.00053851 24 0.00040388 25 0.00030291 Number of Customers in System 1 2 3 4 5 6 7 8 9 10 13 00.04664723 0.04664723 […]
978-0078096600 Chapter 11 Exel Part 4
35 36 37 38 A B C D E G H I J K 22 5.3463E-05 23 3.5642E-05 24 2.3761E-05 25 1.5841E-05 1 2 3 4 5 6 7 8 9 10 13 18 19 00.33333333 Time1 C9 50.04389575 60.02926383 […]
978-0078096600 Chapter 11 Exel Part 5
1 2 3 4 5 6 7 8 9 10 11 12 r = 0.8 Lq G5 Prob(Wq > t) = 0.72387 Mu C5 when t = 0.05 n Pnn F13:F38 13 14 15 16 17 18 19 20 21 […]
978-0078096600 Chapter 11 Solution Manual Part 1
Chapter 11 – Queueing Models 11-1 Chapter 11 Queueing Models Review Questions 11.1-1 Customers might be vehicles, machines, or other items. 11.1-4 0 Time 11.1-5 The mean equals the standard deviation of the exponential distribution. 11.1-6 Having random arrivals means […]
978-0078096600 Chapter 11 Solution Manual Part 2
Chapter 11 – Queueing Models 11–21 c) The new proposal shows that they will be slightly worse off if they switch to the new queueing system. 11.23 a) M/M/s model: 3 4 5 6 7 8 9 10 11 12 […]
978-0078096600 Chapter 11S Exel Part 1
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 r = 0.75 n Pn […]
978-0078096600 Chapter 11S Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 r = 0.66666667 l-bar = 0.2535497 0n Pn 0.4 0.5 0.6 14 15 16 17 18 19 20 21 22 23 320.14604462 430.03245436 54 0 65 0 […]
978-0078096600 Chapter 11S Exel Part 3
1 2 3 4 5 6 7 8 9 10 13 00.5 Time1 C9 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 10.25 Time2 C12 20.125 WG7 […]
978-0078096600 Chapter 11S Solution Manual
CD Supplement to Chapter 11 – Additional Queuing Models CD11s-1 CD Supplement to Chapter 11 Additional Queuing Models Review Questions 11s-1 When the system is full with K customers, any new arriving customers leave without entering the system. 11s-2 PK […]
978-0078096600 Chapter 12 Exel Part 1
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 1008 1009 1010 1011 1012 1013 A B C D E F […]
978-0078096600 Chapter 12 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 107 108 109 A B C D E F G H Mean Interarrival Time = 0.25 days Mean Service Time = 0.2 days Average Time in […]
978-0078096600 Chapter 12 Solution Manual Part 1
12-1 Chapter 12 Computer Simulation: Basic Concepts Review Questions 12.1-1 Computer simulation imitates the operation of a stochastic system by using the corresponding probability distributions to randomly generate the various events that occur in the system. 12.1-2 Computer simulation typically […]
978-0078096600 Chapter 12 Solution Manual Part 2
12–18 12.16 a) Two tellers: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A B C D E F G H Template for Queueing Simulation Data Results […]
978-0078096600 Chapter 12S Solution Manual
CD Supplement to Chapter 12 – The Inverse Transformation Method for Generating Random Observations CD12s-1 CD Supplement to Chapter 12 The Inverse Transformation Method for Generating Random Observations Review Questions 12s-1 The inverse transformation method is a method for generating […]
978-0078096600 Chapter 13 Solution Manual Part 1
13-1 Chapter 13 Computer Simulation with Crystal Ball Review Questions 13.1-1 Freddie needs to determine how many copies of the Financial Journal to order per day from the distributor. 13.1-2 An assumption cell is a random input cell. 13.1-3 The […]
978-0078096600 Chapter 13 Solution Manual Part 2
13–21 b) An order quantity of 275 maximizes the mean profit. An order quantity of 300 is also very close to maximizing the mean profit. The order quantity that actually maximizes mean profit is probably somewhere between these two quantities. […]
978-0078096600 Chapter 13 Solution Manual Part 3
13–38 c) They should accept approximately 67 discount reservations and up to approximately 125 total in order to maximize mean profit, as found by OptQuest. 13.23 1 2 3 4 5 6 7 8 9 10 11 12 13 14 […]
978-0078096600 Chapter 14 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 A B C D E F Activity 1 Activity 2 Unit Profit $30 $20 Used Available Resource A 1 0 3 <= 5 Resource B 0 1 3 <= […]
978-0078096600 Chapter 14 Exel Part 2
1 2 3 4 5 6 7 8 9 A B C D E F Activity 1 Activity 2 Unit Profit -1 1 Used Available Resource A 2 -1 0<= 20 Resource B 1 -2 0<= 20 Activity 1 Activity […]
978-0078096600 Chapter 14 Solution Manual Part 1
CD14-1 CD Chapter 14 Solution Concepts for Linear Programming Review Questions 14.1-1 A corner point is a point that lies at a corner of the feasible region. 14.1-2 The corner point with the best value of the objective function is […]
978-0078096600 Chapter 14 Solution Manual Part 2
CD14-21 e) 1 2 3 4 5 6 7 8 9 A B C D E F Activity 1 Activity 2 Unit Profit 1 -1 Used Available Resource A -1 3 0 <= 30 Resource B -3 1 0 <= […]
978-0078096600 Chapter 14 Solution Manual Part 3
CD Chapter 14 – Solution Concepts for Linear Programming CD14-38 14.32 Getting Started: Select (0, 0) as the initial corner point. Checking for Optimality: Both (0, 3) and (3, 0) have better objective function values (Z = 6 and 9, […]
978-0078096600 Chapter 15 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 A B C D E F G H Unit Cost Destination 1 2 3 1$9 $6 $8 Source 2 $7 $12 $10 3$6 $7 $6 […]
978-0078096600 Chapter 15 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 A B C D E F G H Unit Cost Distribution Center 1 2 3 Plant A $800 $700 $400 B$600 $800 $500 Shipments Distribution Center 1 […]
978-0078096600 Chapter 15 Solution Manual Part 1
CD15-1 CD Chapter 15 Transportation and Assignment Problems Review Questions 15.1-1 The CEO is concerned about escalating costs, in particular the shipping costs for peas. 15.1-2 Kim Baker is being asked to look at the current shipping plan and see […]
978-0078096600 Chapter 15 Solution Manual Part 2
CD Chapter 15 – Transportation and Assignment Problems CD15-13 15.16 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 A […]
978-0078096600 Chapter 16 Exel
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D E F G H I J K L M N Template for PERT Three-Estimate Approach Time Estimates On […]
978-0078096600 Chapter 16 Solution Manual Part 1
CD16-1 CD Chapter 16 Pert/CPM Models for Project Management Review Questions 16.1-1 The bid is for $5.4 million with a penalty of $300,000 if the deadline of 47 weeks is not met. In addition, a bonus of $150,000 will be […]
978-0078096600 Chapter 16 Solution Manual Part 2
CD Chapter 16 – Pert/CPM Models for Project Management b) Start → A → C → J → Finish Length = 85.7 weeks Start → B → F → J → Finish Length =99.1 weeks *critical path CD16-21 Start → […]
978-0078096600 Chapter 16 Solution Manual Part 3
CD16-36 The initial public offering process is 27.5 weeks long. The critical path is: b) We explore each change independently. i) Negotiating the commitment (step C) is performed parallel to negotiating the spread (step D). In part (a) above, negotiating […]
978-0078096600 Chapter 17 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 A B C D E F G H I J K L M N Market Share per $million Ad Ad Ad Level Amount Amount Balance Camp. 1 Camp. 2 […]
978-0078096600 Chapter 17 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D E F G H I J K L M N O P Level Amount Amount Balance Property Sales […]
978-0078096600 Chapter 17 Solution Manual
CD Chapter 17 – Goal Programming CD17-1 CD Chapter 17 Goal Programming Review Questions 17.1-1 The management science team has been asked to analyze what the new product mix should be for the three new products. 17.1-2 1. Achieve a […]
978-0078096600 Chapter 18 Exel Part 1
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 A B C D E F G H I J Basic EOQ […]
978-0078096600 Chapter 18 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 A B C D E F G H I J Basic EOQ Model Data Results Range Name Cell D = 600 (demand/year) Reorder Point 10 AnnualHoldingCost G7 […]
978-0078096600 Chapter 18 Solution Manual Part 1
CD18-1 CD Chapter 18 Inventory Management with Known Demand Review Questions 18.1-1 Administrative costs, such as labor charges to place an order, can cause the cost to exceed the purchase price. 18.1-2 Capital tied up in inventory will not be […]
978-0078096600 Chapter 18 Solution Manual Part 2
CD18-16 18.10 a) p = $15 1 2 3 4 5 6 7 8 9 10 11 A B C D E F G EOQ Model with Planned Shortages (Analytical Version) Data Results D = 6,000 (demand/year) Max Inventory Level […]
978-0078096600 Chapter 19 Exel
1 2 3 4 5 6 7 8 9 10 11 12 A B C D E F G H Purchase Cost $1.50 Selling Price $2.50 Refund for Unsold $0.50 Profit Table Expected 15 16 17 18 Profit 15 $15 […]
978-0078096600 Chapter 19 Solution Manual Part 1
CD Chapter 19 – Inventory Management with Uncertain Demand CD19-1 CD Chapter 19 Inventory Management with Uncertain Demand Review Questions 19.1-1 Freddie should consider the trade-off between too much inventory and too little inventory. 19.1-2 Based on Freddie’s data, 9, […]
978-0078096600 Chapter 19 Solution Manual Part 2
CD19-13 c) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 A B C D E F G Template for the Stable Products Model Data Results D = 8000 (average demand/unit time) Q = 25,675 […]
978-0078096600 Chapter 2 Exel Part 1
1 2 3 4 5 6 7 8 9 10 A B C D E F Doors Windows Unit Profit $600 $300 Hours Hours Used Available Plant 1 1 0 4 <= 4 Plant 2 0 2 6 <= 12 […]
978-0078096600 Chapter 2 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 A B C D E F X1X2 Unit Profit 2 1 Resource Resource Used Available Resource 1 0 1 5 <= 10 Resource 2 2 5 51 <= 60 […]
978-0078096600 Chapter 2 Solution Manual Part 1
2-1 Chapter 2 Linear Programming: Basic Concepts Review Questions 2.1-1 1) Should the company launch the two new products? 2) What should be the product mix for the two new products? 2.1-2 The group was asked to analyze product mix. […]
978-0078096600 Chapter 2 Solution Manual Part 2
2-21 b) Calories: 800 (lb. Type A) + 1000 (lb. Type B) ≥ 8000 Vitamins: 140 (lb. Type A) + 70 (lb. Type B) ≥ 700 Type A maximum: (lb. Type A) ≤ 0.333((lb. Type A) + (lb. Type B)) […]
978-0078096600 Chapter 2 Solution Manual Part 3
2-34 Taste Constraint Edson requires that the casserole contain at least a six to five ratio in the weight of potatoes to green beans. We have: poun ds of green beans 6 5 5 (pounds of potatoes) ≥ 6 (pounds […]
978-0078096600 Chapter 2S Solution Manual
CD2s-1 CD Supplement to Chapter 2 More About the Graphical Method for Linear Programming Problems 2s.1 Optimal Solution = (A, B) = (x1, x2) = (0.667, 0.667). P = $3333.33. 2s.2 Optimal Solution: (x1, x2) = (3, 2) and Z […]
978-0078096600 Chapter 3 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 12 13 A B C D E F G H TV Spots Magazine Ads Radio Ads SS Ads Exposures per Ad 1300 600 900 500 (thousands) Budget Budget Cost […]
978-0078096600 Chapter 3 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 A B C D E F G H I J K Large Medium Small Unit Profit $420 $360 $300 Space Required 20 15 12 […]
978-0078096600 Chapter 3 Solution Manual Part 1
Chapter 03 – Linear Programming: Formulation and Applications 3-1 Chapter 3 Linear Programming: Formulation and Applications Review Questions 3.1-1 Determine which levels should be chosen of different advertising media to obtain the most effective advertising mix for the new cereal. […]
978-0078096600 Chapter 3 Solution Manual Part 2
Chapter 03 – Linear Programming: Formulation and Applications 3-21 3.26 While growing continuously as a global company, Procter & Gamble faced the need to restructure for enhanced effectiveness. The goal was to optimize work processes and to minimize expenses while […]
978-0078096600 Chapter 3 Solution Manual Part 3
3-36 b) The linear programming spreadsheet model for this problem is shown below. 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 […]
978-0078096600 Chapter 4 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A B C D E F G H I J K L M N O P LT Rate 7% ST […]
978-0078096600 Chapter 4 Exel Part 2
Craftsman Wage per month Apprentice Wage per month Hiring Cost Severance Pay Labor Hours/Craftsman/Month Starting Trained Craftsmen Maximum Layoffs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Apprentices Hired Craftsmen Fired <= <= <= <= <= […]
978-0078096600 Chapter 4 Solution Manual
4-1 Chapter 4 The Art of Modeling with Spreadsheets Review Questions 4.1-1 The long-term loan has a lower interest rate. 4.1-2 The short-term loan is more flexible. They can borrow the money only in the years they need it. 4.1-3 […]
978-0078096600 Chapter 5 Exel Part 1
1 2 3 4 5 6 7 8 9 A B C D E F Toys Subassemblies Unit Profit $3.00 -$2.50 Used Available Subassembly A 2 -1 3,000 <= 3,000 Subassembly B 1 -1 1,000 <= 1,000 Toys Subassemblies Total […]
978-0078096600 Chapter 5 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A B C D E F G H I J K L M Union Airways Personnel Scheduling Problem 6am-2pm […]
978-0078096600 Chapter 5 Exel Part 3
53 54 55 56 A B C D E F $290 3.33 3.33 $1,967 $310 06.67 $2,067 $330 06.67 $2,200 $350 06.67 $2,333 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 […]
978-0078096600 Chapter 5 Exel Part 4
1 2 3 4 5 6 7 8 9 A B C D E F Activity 1 Activity 2 Unit Profit $1 $2 Used Available Resource 1 1 3 8 <= 8 Resource 2 1 1 4 <= 4 Activity […]
978-0078096600 Chapter 5 Solution Manual Part 1
5-1 Chapter 5 What-If Analysis for Linear Programming Review Questions 5.1-1 The parameters of a linear programming model are the constants (coefficients or right-hand sides) in the functional constraints and the objective function. 5.1-2 Many of the parameters of a […]
978-0078096600 Chapter 5 Solution Manual Part 2
Chapter 05 – What-If Analysis for Linear Programming 5-21 f) 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 A B C D E F G H Total Profit […]
978-0078096600 Chapter 5 Solution Manual Part 3
5-41 a) The following shifts can be increased by the indicated amounts with increasing total cost: Serve 10–12 am 14 Serve 12–2 pm 31 Serve 2–4 pm 6 Serve 4–6 pm 9 Serve 10–12 pm 6 b) For each of […]
978-0078096600 Chapter 5 Solution Manual Part 4
5-56 Variable Cells Final Reduced Objective Allo w able Allo w able Cell Name Valu e Cost Coefficient Increase Decrease $B$7 Acres Planted Soybeans 450 0 70 1E+ 30 8. 4 $C$7 Acres Planted Corn 30 060 8. 4 1E+ […]
978-0078096600 Chapter 6 Exel
1 2 3 4 5 6 7 8 9 A B C D E F G H I J From To Ship Unit Cost Nodes Net Flow Supply/Demand Source 1 Destination 1 0 $6 Source 1 40 =40 Source 1 […]
978-0078096600 Chapter 6 Solution Manual Part 1
Chapter 06 – Network Optimization Problems 6-1 Chapter 6 Network Optimization Problems Review Questions 6.1-1 A supply node is a node where the net amount of flow generated is a fixed positive number. A demand node is a node where […]
978-0078096600 Chapter 6 Solution Manual Part 2
Chapter 06 – Network Optimization Problems 6-19 Jacksonville to Moscow: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D E F G H I J K From […]
978-0078096600 Chapter 6S Solution Manual
CD Supplement to Chapter 6 – Minimum Spanning Tree Problems CD6s-1 CD Supplement to Chapter 6 Minimum Spanning Tree Problems Review Questions 6s-1 The nodes are given, but the links need to be designed. 6s-2 A state-of-the-art fiber-optic network is […]
978-0078096600 Chapter 7 Exel
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A B C D E F G H I J K California Manufacturing Co. Facility Location Problem NPV ($millions) Los […]
978-0078096600 Chapter 7 Solution Manual Part 1
7-1 Chapter 7 Using Binary Integer Programming to Deal with Yes-or-No Decisions Review Questions 7.1-1 The decisions are 1) whether to build a factory in Los Angeles, 2) whether to build a factory in San Francisco, 3) whether to build […]
978-0078096600 Chapter 7 Solution Manual Part 2
7-16 6. Finally, Ash wants at most one piece from Ziggy Lite displayed. We can therefore include no more than one of “My Namesake” and “Narcissism” (R36 ≤ R38). Constraints Imposed by Celeste 1. Celeste wants to include at least […]
978-0078096600 Chapter 7S Exel
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A B C D E F G H I J Product 1 Product 2 Product 3 Product 4 Start-up Cost $50,000 […]
978-0078096600 Chapter 7S Solution Manual
CD Supplement to Chapter 7 – Advanced Formulation Techniques for Binary Integer Programming CD7s-1 CD Supplement to Chapter 7 Advanced Formulation Techniques for Binary Integer Programming Review Questions 7s-1 A binary decision variable is a binary variable that represents a […]
978-0078096600 Chapter 8 Exel Part 1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A B C D Production Rate Profit 0$0 200 $9,500 500 $22,500 800 $34,000 1,000 $40,000 $0 $5,000 […]
978-0078096600 Chapter 8 Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 A B C D E F Stock 1 Stock 2 Expected Profit (on $50,000) $12,500 $20,000 Risk (Stand. Dev. for $50,000) $5,000 $30,000 Stock […]
978-0078096600 Chapter 8 Exel Part 3
1 2 3 4 5 6 7 8 9 A B C D E F 0 Starting <= Point x* Profit* x = 3.537 3.537 6.801 <= 0 0.405 10.735 5 1 0.405 10.735 2 3.537 6.801 Profit = x5 […]
978-0078096600 Chapter 8 Solution Manual Part 1
8-1 Chapter 8 Nonlinear Programming Review Questions 8.1-1 In both cases, decisions need to be made regarding the levels of a number of activities, where these activity levels can have any value that satisfies a number of constraints. The decisions […]
978-0078096600 Chapter 8 Solution Manual Part 2
8-21 b & c) The profit graph for product 1 is shown below. Product i on of product 1 Profit ($mi ll ions) 5 1 2 3 4 5 4 3 1 -1 2 The profit graph for product 2 […]
978-0078096600 Chapter 8 Solution Manual Part 3
8-35 Ads in Sunday Supplements (Logarithmic Form) y = 1.6331Ln(x) + 0.0343 0 0.5 1 1.5 2 2.5 3 3.5 4 0 2 4 6 8 10 Ads in Sunday Supplements Sales (millions) In all three cases, the quadratic form […]
978-0078096600 Chapter 9 Exel
1 2 3 4 5 6 7 8 9 10 11 12 Alternative 10 11 12 13 Payoff Buy 10 $50 $50 $50 $50 $50.00 Buy 11 $47 $55 $55 $55 $53.40 Buy 12 $44 $52 $60 $60 $53.60 Buy […]
978-0078096600 Chapter 9 Solution Manual Part 1
Chapter 09 – Decision Analysis Chapter 9 Decision Analysis Review Questions 9.1-1 The decision alternatives are to drill for oil or to sell the land. 9.1-2 The consulting geologist believes that there is 1 chance in 4 of oil on […]
978-0078096600 Chapter 9 Solution Manual Part 2
9-21 c) Alternative 1 4 4 4 0.2 State 1 Alternative 2 1 0 0 4 0 0 Alternative 3 3 3 3 Alternative 1 0 0 0 0.5 State 2 Alternative 2 2 2 2.1 0 2 2 2 […]
978-0078096600 Chapter 9 Solution Manual Part 3
9-41 product will be successful. The expected payoff is $520,000. 0.8421 Successful 1.4 Develop Product 1.5 1.4 0 0.8789 0.1579 0.63333 Unsuccessful Predict Success -1.9 1 -1.8 –1.9 0 0.8789474 Don‘t Develop -0.1 0 -0.1 Conduct Survey 0.3636 -0.1 0.52 […]
978-0078096600 Chapter 9 Solution Manual Part 4
9-61 0.96 Satisfactory 200 Buy 200 200 0 152 0.04 0.75 Unsatisfactory Excellent –1000 1 -1000 –1000 0 152 Reject 0 0 0 Sample 0.72 0 114 Satisfactory 200 Buy 200 200 0 -136 0.28 0.25 Unsatisfactory Not Excellent -1000 […]
978-0078096600 Chapter 9 Solution Manual Part 5
9-81 When the prior probability of oil is 20%, the optimal policy is to do the survey and drill if favorable or sell if unfavorable, with an expected utility of 90.86. Chapter 09 – Decision Analysis 9-82 When the prior […]
978-0078096600 Chapter 9 Solution Manual Part 6
9-93 b) The most likely state depends upon the price. As calculated in the spreadsheet below, if the price is set high ($50), the most likely outcome is low sales (20,000), with $1 million in revenue. If the price is […]
978-0078096600 Chapter 9S Exel Part 1
1 2 3 4 5 6 7 8 9 A B C D E F G H I Template for Maximax Criterion State of Nature Maximum Alternative S1 S2 in Row A1 1 7 7 Maximax A2 6 3 6 […]
978-0078096600 Chapter 9S Exel Part 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A B C D E F G H I Template for Minimax Regret Criterion Payoff Table State of Nature […]
978-0078096600 Chapter 9S Solution Manual
CD Supplement to Chapter 9 – Decision Criteria CD9s-1 CD Supplement to Chapter 9 Decision Criteria Review Questions 9s-1 It might be desirable to use a decision criterion that doesn’t rely on the prior probabilities if these probabilities are not […]
978-0078096600 Solution Manual Chapter 7S2
CD Supplement to Chapter 7 – Some Perspectives on Solving Binary Integer Programming Problems CD7s-1 CD Supplement to Chapter 7 Some Perspectives on Solving Binary Integer Programming Problems Review Questions 7s-1 Push the objective function line in the direction of […]
978-0078096600 Test Bank Chapter 1
Chapter 01 – Introduction 1-1 True / False Questions 1. Managers need to know the mathematical theory behind the techniques of management science so that they can lead management science teams. 2. Spreadsheets allow many managers to conduct their own […]
978-0078096600 Test Bank Chapter 10
Chapter 10 – Forecasting 10-1 True / False Questions 1. Forecasts are rarely perfect. 2. Once accepted by managers, forecasts should not be overridden. FALSE 3. Statistical models to forecast economic trends are called econometric models. TRUE 4. The difference […]
978-0078096600 Test Bank Chapter 11
Chapter 11 – Queueing Models True / False Questions 1. The goal of queuing analysis is to minimize customer waiting lines. FALSE 2. Queueing models enable finding an appropriate balance between the cost of service and the amount of waiting. […]
978-0078096600 Test Bank Chapter 11S
Chapter 11 CD Supplement – Additional Queueing Models True / False Questions 1. Given the same utilization factor, waiting time in the queue will be less for a finite queue than the corresponding value for the M/M/s model. TRUE 2. […]
978-0078096600 Test Bank Chapter 12
Chapter 12 – Computer Simulation: Basic Concepts True / False Questions 1. Managers can use simulation to obtain optimal answers for a wide range of problems. FALSE 2. Computers can simulate years of operation in seconds. TRUE 3. Simulation is […]
978-0078096600 Test Bank Chapter 12S
Chapter 12 CD Supplement – The Inverse Transformation Method for Generating Random Observations True / False Questions 1. The inverse transformation method can be used to generate random observations from a probability distribution. TRUE 2. Excel’s RAND() function is designed […]
978-0078096600 Test Bank Chapter 13
Chapter 13 – Computer Simulation with Crystal Ball 13-1 True / False Questions 1. A forecast cell refers to a random input cell. 2. The number of trials is one of the options to be set in the Run Preferences […]
978-0078096600 Test Bank Chapter 14
Chapter 14 CD – Solution Concepts for Linear Programming True / False Questions 1. The simplex method can only solve problems with up to 100 functional constraints. FALSE 2. The simplex method is an algorithm that can be used for […]
978-0078096600 Test Bank Chapter 15
Chapter 15 CD – Transportation and Assignment Problems 15-1 1. Transportation problems are concerned with distributing commodities from sources to destinations in such a way as to minimize the total distribution cost. TRUE 2. Transportation problems always involve shipping goods […]
978-0078096600 Test Bank Chapter 16 Part 1
Chapter 16 CD – PERT/CPM Models for Project Management True / False Questions 1. Projects involve routine activities that are performed repeatedly. FALSE 2. Project managers must often function in an environment that is beset with uncertainties. TRUE 3. Although […]
978-0078096600 Test Bank Chapter 16 Part 2
Chapter 16 CD – PERT/CPM Models for Project Management 16–12 61. The critical path for the network shown is: 62. The slack for path A-D-H-I is: A. 0. B. 3. C. 4. D. 7. E. 8. Given this network: A. […]
978-0078096600 Test Bank Chapter 17
Chapter 17 CD – Goal Programming 17-1 True / False Questions 1. Goal programming provides a way to identify the most important goal and achieve it. 2. Goal programming provides a way of striving toward several objectives simultaneously. TRUE 3. […]
978-0078096600 Test Bank Chapter 18
Chapter 18 CD – Inventory Management with Known Demand True / False Questions 1. Administrative costs provide a strong incentive to place larger orders. TRUE 2. Setup costs can occur through purchasing or manufacturing products. TRUE 3. The objective of […]
978-0078096600 Test Bank Chapter 19
Chapter 19 CD – Inventory Management with Uncertain Demand True / False Questions 1. One consequence of uncertain demand is the risk of incurring shortages. TRUE 2. The objective of inventory management is to maximize customer service levels. FALSE 3. […]
978-0078096600 Test Bank Chapter 2
Chapter 02 – Linear programming: basic concepts True / False Questions 1. Linear programming problems may have multiple goals or objectives specified. FALSE 2. Linear programming allows a manager to find the best mix of activities to pursue and at […]
978-0078096600 Test Bank Chapter 3
Chapter 03 – Linear Programming: Formulation and Applications 3-1 True / False Questions 1. When formulating a linear programming model on a spreadsheet, the decisions to be made are located in the data cells. 2. When formulating a linear programming […]
978-0078096600 Test Bank Chapter 4
Chapter 04 – The Art of Modeling with Spreadsheets 4-1 1. If two managers are given the same business problem to analyze with a spreadsheet, their spreadsheet models will likely be almost identical. FALSE 2. There is a systematic procedure […]
978-0078096600 Test Bank Chapter 5
Chapter 05 – What-If Analysis for Linear Programming True / False Questions 1. An optimal solution is only optimal with respect to a particular mathematical model that provides only a representation of the actual problem. TRUE 2. The purpose of […]
978-0078096600 Test Bank Chapter 6
Chapter 06 – Network Optimization Problems 6-1 1. Network representations can be used for financial planning. TRUE 2. A network representation is a very specific conceptual aid and is only used in special cases. FALSE 3. All network optimization problems […]
978-0078096600 Test Bank Chapter 7
Chapter 07 – Using Binary Integer Programming to Deal with Yes-or-No Decisions True / False Questions 1. Binary integer programming problems are those where all the decision variables restricted to integer values are further restricted to be binary variables. TRUE […]
978-0078096600 Test Bank Chapter 8
Chapter 08 – Nonlinear Programming True / False Questions 1. Linear programming assumes that the profit from each activity is proportional to the level of that activity. TRUE 2. If the slope of a graph never increases but sometimes decreases […]
978-0078096600 Test Bank Chapter 9
Chapter 09 – Decision Analysis 9-1 True / False Questions 1. States of nature are alternatives available to a decision maker. 2. In decision analysis, states of nature refer to possible future conditions. TRUE 3. Prior probabilities refer to the […]
978-0078096600 Test Bank Chapter 9S
Chapter 09 CD Supplement – Decision Analysis True / False Questions 1. The maximax approach is an optimistic strategy. TRUE 2. An example of maximax decision making is a person buying lottery tickets in hopes of a very big payoff. […]