Archives: Solution Manual
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 […]
SHER WOOD HOCKEY STICKS GLOBAL SOURCING
SHER-WOOD HOCKEY STICKS: GLOBAL SOURCING SYNOPSIS The Sher-Wood Hockey Sticks case examines from a global sourcing perspective how an iconic Canadian TEACHING OBJECTIVES The case can be used in advanced undergraduate or MBA courses in international business or strategic management. […]