Questions and Answers of Spreadsheet Modeling And Decision Analysis

Bulloch County has never allowed liquor to be sold in restaurants. However, in three months, county residents are scheduled to vote on a referendum to allow liquor to be sold by the drink. Currently,
Several hundred PCs are in use at the corporate headquarters for National Insurance Corporation. The pattern of breakdowns for these PCs follows a Poisson distribution with an average rate of 4.5
Refer to the previous question. Suppose that Road Rambler’s phone system can only keep four calls on hold at any time, the average profit margin of each call is $55, and sales reps cost the company
Podcessories manufacturers a several accessories for a popular digital music player. The company is trying to decide whether to discontinue one of the items in this product line. Discontinuing the
Hometown Insurance sells 10-year annuities to retirees who are looking for stable sources of investment income. Hometown invests the annuity funds it receives in an equity index fund with annual
Suppose a product must go through an assembly line is made up of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and
Suppose a product must go through an assembly line is made up of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Use the multiplicative seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line
Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?
Refer to the data in the file that accompanies this book named ProductionHours.xlsx containing monthly data on the average number of hours worked each week by production workers in the United States
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Use the multiplicative seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line
Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Prepare a line graph of these data. Do the data appear to be stationary or non-stationary?
Prepare a line graph of these data. Do the data appear to be stationary or non-stationary?
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Refer to the data in the file that accompanies this book named ChemicalDemand.xlsx containing monthly data on the demand for a chemical product over a 2 year period.Use the multiplicative seasonal
Refer to the data in the file that accompanies this book named ChemicalDemand.xlsx containing monthly data on the demand for a chemical product over a 2 year period.Use the additive seasonal
Prepare a line graph of these data. Do the data appear to be stationary or non-stationary?
Refer to the data in the file that accompanies this book named MortgageRates.xlsx containing average monthly 30-year mortgage rates over 82 consecutive months.Use Holt’s method to create a model
Create a Double Moving Average model (with k = 4) for the data set.a. Prepare a line graph comparing the Double Moving Average predictions against the original data.b. What are the forecasts for the
Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to estimate the optimal value of a.a. What is the optimal value of a?b. Prepare a line graph comparing the
Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE.a. What are the optimal values for the weights?b. Prepare a line graph comparing
Compute the two-period and four-period moving average predictions for the data set.a. Prepare a line graph comparing the moving average predictions against the original data.b. Compute the MSE for
Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?Refer to the data in the file that accompanies this book named MortgageRates.xlsx containing average monthly
Use regression analysis to answer the following questions.a. Fit a linear trend model to the data set. What is the estimated regression function?b. Interpret the R2 value for your model.c. Prepare a
Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Create a Double Moving Average model (with k = 4) for the data set.a. Prepare a line graph comparing the Double Moving Average predictions against the original data.b. What are the forecasts for the
Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use regression analysis to fit a quadratic trend model to the data set.a. What is the estimated regression function?b. Compare the adjusted-R2 value for this model to that of the linear trend model.
Use regression analysis to fit a linear trend model to the data set.a. What is the estimated regression function?b. Interpret the R2 value for your model.c. Prepare a line graph comparing the linear
Use regression analysis to fit an additive seasonal model with linear trend to the data set.a. What is the estimated regression function?b. Interpret the R2 value for your model.c. Interpret the
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use the multiplicative seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line
Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use regression analysis to fit a linear trend model to the data set.a. What is the estimated regression function?b. Interpret the R2 value for your model.c. Prepare a line graph comparing the linear
Refer to the data in the file that accompanies this book named COGS.xlsx representing monthly cost of goods sold data for a retail store.Use regression analysis to fit an additive seasonal model with
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values
Use Holt-Winter’s additive method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of a, b, and g.a. What are the optimal values of a,
Use the multiplicative seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line
Use the additive seasonal technique for stationary data to model the data. Use Solver to determine the optimal values of a and b.a. What are the optimal values of a and b?b. Prepare a line graph
Use regression analysis to fit a quadratic trend model to the data set.a. What is the estimated regression function?b. Compare the adjusted-R2 value for this model to that of the linear trend model.
Use regression analysis to fit a linear trend model to the data set.a. What is the estimated regression function?b. Interpret the R2 value for your model.c. Prepare a line graph comparing the linear
Nolan Banks is an auditor for the Public Service Commission for the state of Georgia.The Public Service Commission is a government agency responsible for ensuring that utility companies throughout
The 2000 U.S. presidential election was one of the most controversial in history with the final outcome ultimately being decided in a court of law rather than in the voting booth. At issue were the
Throughout our discussion of regression analysis, we used the Regression command to obtain the parameter estimates that minimize the sum of squared estimation errors. Suppose that we want to obtain
An appraiser collected the data found in the file Appraiser.xlsx describing the auction selling price, diameter (in inches), and item type of several pieces of early 20th century metal tableware
Companies are often interested in segmenting their customers to better target specific product offerings to meet specific customer needs. The file CustomerData.xlsx that accompanies this book
A small printing shop has 10 jobs it must schedule. The processing times and due dates for each job are summarized in the following table.a. Suppose the jobs are scheduled in ascending order by
A mortgage company owns the following 10 mortgages. Investors will purchase packages of mortgages worth at least $1 million. What is the maximum number of such packages that can be created from this
Suppose a gift shop in Myrtle Beach has an annual demand for 15,000 units for a souvenir kitchen magnet that it buys for $0.50 per unit. Assume it costs $10 to place an order and the inventory
A traveler was recently stranded in her car in a snowy blizzard in Wyoming. Unable to drive any farther, the stranded motorist used her cell phone to dial 911 to call for help. Because the caller was
A company manufactures three products: A, B, and C. The company currently has an order for 3 units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of these
As shown in Figure 6.1, the feasible region for an ILP consists of a relatively small, finite number of points, whereas the feasible region of its LP relaxation consists of an infinite number of
The United States is the biggest consumer of natural gas, and the second largest natural gas producer in the world. According to the U.S. Energy Information Administration (EIA), the United States
FIGURE 5.46The United States is the biggest consumer of natural gas, and the second largest natural gas producer in the world. According to the U.S. Energy Information Administration (EIA), the
Alaskan Railroad is an independent, stand-alone railroad operation not connected to any other rail service in North America. As a result, rail shipments between Alaska and the rest of North America
Sunrise Swimwear manufactures ladies swimwear in January through June of each year that is sold through retail outlets in March through August. The following table summarizes the monthly production
Refer to question 45 at the end of chapter 3 and answer the following questions.a. Create a Spider Plot to summarize what happens to the optimal total profit as the total storage capacity increases
Use Solver to create a Sensitivity Report for question 38 at the end of chapter 3 and answer the following questions.a. Is the solution degenerate?b. Is the solution unique?c. How much can the profit
Use Solver to create a Sensitivity Report for question 34 at the end of chapter 3 and answer the following questions.a. Is the solution degenerate?b. Is the solution unique?c. Use a Solver Plot to
Use Solver to create a Sensitivity Report for question 23 at the end of chapter 3 and answer the following questions:a. Is the optimal solution unique? How can you tell?b. Which location is receiving
Use Solver to create a Sensitivity Report for question 21 at the end of chapter 3 and answer the following questions:a. Which of the constraints in the problem are binding?b. If the company was going
Use Solver to create a Sensitivity Report for question 18 at the end of chapter 3 and answer the following questions:a. Is the solution degenerate?b. Would the solution change if the price of raisins
Use Solver to create a Sensitivity Report for question 17 at the end of chapter 3 and answer the following questions:a. Is the solution degenerate?b. Explain the value of the shadow price associated
Use Solver to create a Sensitivity Report for question 16 at the end of chapter 3 and answer the following questions:a. Is the solution degenerate?b. Is the solution unique?c. Explain the signs of
Use Solver to create a Sensitivity Report for question 15 at the end of chapter 3 and answer the following questions.a. Is the solution degenerate?b. Is the solution unique?c. Suppose the profit per
Use Solver to create a Sensitivity Report for question 15 at the end of chapter 3 and answer the following questions.a. Is the solution degenerate?b. Is the solution unique?c. Suppose the profit per
Use Solver to create a Sensitivity Report for question 14 at the end of chapter 3 and answer the following questions:a. If the company could get 50 more units of routing capacity, should they do it?
Use Solver to create a Sensitivity Report for question 13 at the end of chapter 3 and answer the following questions:a. How much would electric trimmers have to cost in order for the company to
Use Solver to create a Sensitivity Report for question 13 at the end of chapter 3 and answer the following questions:a. How much would electric trimmers have to cost in order for the company to
Use Solver to create Answer and Sensitivity Reports for question 25 at the end of chapter 2 and answer the following questions:a. If the profit on doors increased to $700 would the optimal solution
Use Solver to create Answer and Sensitivity Reports for question 24 at the end of chapter 2 and answer the following questions:a. How much can the price of watermelons drop before it is no longer
Use Solver to create Answer and Sensitivity Reports for question 22 at the end of chapter 2 and answer the following questions:a. If the profit on Razors decreased to $35 would the optimal solution
Use Solver to create Answer and Sensitivity Reports for question 16 at the end of chapter 2 and answer the following questions:a. How much excess wiring and testing capacity exists in the optimal
Refer to question 15 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.
WinterWearhouse operates a clothing store specializing in ski apparel. Given the seasonal nature of their business, there is often somewhat of an imbalance between when bills must be paid for
The CFO for Eagle Beach Wear and Gift Shop is in the process of planning for the company’s cash flows for the next 6 months. The following table summarizes the expected accounts receivables and
Acme Manufacturing makes a variety of household appliances at a single manufacturing facility. The expected demand for one of these appliances during the next 4 months is shown in the following table
The owner of Blue Ridge Hot Tubs, Howie Jones, has asked for your assistance analyzing how the feasible region and solution to his production problem might change in response to changes in various
Identify a consumer electronics product that you want to purchase (e.g., a TV, digital camera, tablet computer, and so on). Identify at least three models of this product that you would consider
A debate recently erupted about the optimal strategy for playing a game on the TV show called “Let’s Make a Deal.” In one of the games on this show, the contestant would be given the choice of
Road Racer Sports, Inc. is a mail-order business dedicated to the running enthusiast. The company sends out full-color catalogs several times a year to several hundred thousand people on its mailing
Of the queuing configurations shown in Figure 13.2, which would you prefer to wait in? Explain your response.Figure 13.2 Customer Arrives Customer Arrives O Waiting Line Waiting
Calls to the service center at AutoMax occur at a rate of 27 per hour and follow a Poisson distribution. A single operator answers the calls and can handle an average 25 calls per hour with service
Colleges and universities are often interested in identifying their peer institutions. The file named Colleges.xlsm that accompanies this book contains a number of (artificial) metrics for 307 higher
What is a centroid?
Goldtone Chemical Company is developing a new stain-resistant liquid product that can be applied to different types of fabric. The product can be manufactured in different ways that result in
Suppose you are interested in creating a prediction interval for Y at a particular value of X1 (denoted by X1h) using a simple linear regression model and data has not yet been collected. For a given

Showing 1 - 100 of 103