Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
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
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 800 of the 5,000 residences for data on crime. (Respondents are guaranteed anonymity.) The 800…
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 & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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_forwardThis 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_forward
- Below 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_forwardMake a scatter plot of the data and determine which type of model best fits the data. linear quadratic exponential square rootarrow_forwardWhat 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_forward
- A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are shown in this Excel file (also shown in Problem 6 on page 243 in the textbook). Answer the following questions related to this information: What is the MSE for the two- and three-period moving average models? Compare the results. Find the best number of periods for the moving average model based on MSE.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_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_forward
- Grass MixMix RequirementsWrigleyNo more than 50% tall fescue At least 20% mustang fescuePastureAt least 30% bluegrass At least 30% mustang fescue No more that 20% tall fescueDuroTurfAt least 50% but no more than 70% tall fescue At least 10% bluegrass Ed's Feed and Seed creates three custom grass mixes it sells in their retail stores. These mixes are made from three types of seed they purchase from a supplier: tall fescue, mustang fescue, and bluegrass. Requirements for the custom mixes are in the table at the left. Ed's want to produce 1200 lbs of the Wrigley Mix,900 lbs of the Pasture Mix, and 2400 lbs of the DuroTurf Mix for the coming growing season. Ed's costs for the purchased seeds are $1.70/lb for tall fescue, $2.80/lb for mustang fescue, and $3.25 for bluegrass.Ed wants to know how many pounds of each seed type to purchase to minimize cost. Create a spreadsheet model and use Solver to determine how much seed of each type to purchase. Write a sentence to summarize the…arrow_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_forwardIn linear programming, sensitivity analysis is associated with: (I) objective function coefficient (II) right-hand side values of constraints (III) constraint coefficient A. I and II B. II and III C. I, II and III D. I and III E. none of the abovearrow_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,