Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 3QP
Summary Introduction
To determine: The sensitivity report using solver.
a)
Summary Introduction
To determine: The range of values for X1.
b)
Summary Introduction
To determine: Whether the optimal solution is unique.
c)
Summary Introduction
To determine: The increase in variable X2.
d)
Summary Introduction
To determine: The optimal objective function value for given condition.
e)
Summary Introduction
To determine: The optimal objective function value for given condition.
f)
Summary Introduction
To determine: Whether the solution will still be optimal after the given condition.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Famous psychic, television personality Sylvia Browne is invited to Oprah Winfrey
show to demonstrate her gift in a live TV broadcast. The process entails asking Sylvia
a series of 20 independent questions with yes/no answers. The questions would be
of the nature that she could not have any way of knowing the answer from prior
knowledge. Suppose that Sylvia correctly answered 15 of the 20 questions, which of
the following would be a viable conclusion to reach?
If she were guessing, 15 is within one standard deviation of the mean and
therefore she must not have any special psychic abilities.
Because the probability of getting 15 or more correct is 0.0207, it is likely that
she is just guessing at the questions.
Because the probability of guessing exactly 15 correct is 0.0148, she must just
be guessing.
Because the probability of guessing 15 or more correctly is 0.0207, it is unlikely
that she is guessing at the questions and may, in fact, have some special ability.
A manufacturing engineer is studying the dimensional variability of a particular component that is
produced on three machines. Each machine has two spindles, and four components are randomly
selected from each spindle. The results follow. Analyze the data, assuming that machines and spindles
are fixed factors.
Machine 1
Machine 2
Machine 3
Spindle
1
1
1
12
8
14
12
14
16
9
9
15
10
10
15
11
10
13
11
12
15
12
8
14
13
11
14
Calculate the Determination Coefficient (as percentage) for the Model obtained. Use 2 decimal Digits
Respuesta:
2.
Some citizens complained to city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this equal protection should be interpreted as indicating that high-crime areas should have more police protection than low-crime areas. Therefore, police patrols and other methods for preventing crime (such as street lighting or cleaning up abandoned areas and buildings) should be used proportionately to crime occurrence.
The city has been broken down into 20 geographic areas, each containing 5,000 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 1,000 of the 5,000 residences for data on crime. (Respondents are guaranteed anonymity.) The 1,000…
Chapter 4 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.arrow_forwardSuppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.arrow_forwardSome citizens complained to city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this equal protection should be interpreted as indicating that high-crime areas should have more police protection than low-crime areas. Therefore, police patrols and other methods for preventing crime (such as street lighting or cleaning up abandoned areas and buildings) should be used proportionately to crime occurrence. The city has been broken down into 20 geographic areas, each containing 5,000 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 800 of the 5,000 residences for data on crime. (Respondents are guaranteed anonymity.) The 800…arrow_forward
- This question has multiple correct answers. Pick all the correct answers. If you had to present quantitative data, select all the ones you can use to do so. Group of answer choices position shape different colors size color intensity lengtharrow_forwardBelow is a table that shows the Freshmen Enrollment of the New Texas Elementary School during the 1a Semesters of the past ten (10) Academic Years (AY), AY 2013-2014 2014-2015 2015-2016 2016-02017 2017-2018 Freshmen Enrollees AY 200 220 235 270 315 4. For the Weighted Moving Averages model, use: a weight of 0.40 for the most recent data; a weight of 0.35 for the second most recent data; and a weight of 0.25 for the third most recent data. You are the Principal of New Texas Elementary School. You are interested to know the forecast of freshmen enrolment for the next academic year (AY2023-2024), in order to plan ahead the necessary resources: faculty, classroom, library holdings, physical facilities, student services, furniture and fixtures, etc.). These are the requirements: AT 2013-2014 1. Calculate the forecast using 5 forecasting techniques/methodologies/models namely: Naïve Model, Unweighted and Weighted Moving Averages, Exponential Smoothing, and Time-Series Regression. Follow and…arrow_forwardThe manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75arrow_forward
- What combination of x and y will yield the optimum for this problem? Maximize Z = $3x + $15y Subject to: Multiple Choice x= 0, y=4 x= 0, y=3 x= 0, y=0 x= 2y=0 O x=1,y=25 2x + 4y ≤ 12 5x + 2y ≤ 10arrow_forwardPicturearrow_forwardCity government has collected the following data on annual sales tax collections and new car registrations: Annual Sales Tax Collections (in millions) 1.0 1.4 1.9 2.0 1.8 2.1 2.3 2.5 New Car Registrations (in millions) 10 12 15 16 14 17 20 22 Determine the following: Plot these data and decide if a linear model is reasonable. Using the results of part a., find the estimated sales tax collections if new car registrations total 25,000,000.arrow_forward
- Givens about the mechanism shown in the figure are: L₁ = 80 mm, L2 = 20 mm, L3 = 66 mm, L4 = 56 mm, e = 33 mm, Theta (e) = 30 degrees, Theta 2 (82) = 60 degrees. Calculate the coordinates of the point E for this position. .. 4 a. Ex = 36,48 mm Ey = 38,64 mm Ob. Ex = 37,46 mm Ey-35,63 mm Oc. Ex = 35,26 mm Ey = 37,73 mm Od. Ex = 39,46 mm Ey=38,63 mm Darrow_forwardMike Thatcher is a sales manager for an automobile dealership in Alberta. Mike earns a bonus each year based on revenue generated by the number of vehicles sold in the year less related warranty expenses. The quality of automobiles sold each year seems to vary since the warranty experience related to vehicles sold is highly variable. The actual warranty expenses have varied over the past 10 years from a low of 3% of an automobile’s selling price to a high of 10%. In the past, Mike has tended toward estimating warranty expenses on the high end just to be prudent. It is the end of the year and once again he must work with the dealership’s accountant in arriving at the warranty expense accrual for the cars sold this year. Required 1. Does the warranty accrual decision present any kind of ethical dilemma for Mike Thatcher? 2. Since the warranty experience is not constant, what percent do you think Mike should choose for this year? Justify your response.arrow_forwardplease solve within 30 minutes.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,