Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 25P
a)
Summary Introduction
To determine: The values of a, b, c, d, and e.
Introduction: The variation between the present value of the
b)
Summary Introduction
To determine: The trend and seasonal aspects of the sales of the company.
Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Select the least accurate statement regarding RISKSIMTABLE.
RISKSIMTABLE is a feature that is included in Excel.
RISKSIMTABLE is helpful for automating the process of running multiple simulations with different input
values.
One difference between the RISKSIMTABLE functionality and the data table functionality is that it runs a
simulation for each input value and data table does not.
O When multiple simulation runs are specified, the RISKSIMTABLE function is used to control in the value of a
particular input cell that is used for each simulation.
O The RISKSIMTABLE function is inserted into a cell with an input value and points to a range of values that the
input value will take on.
Below shown is a logical representation of an index table built on columnA
SearchKey
Record Location
G005234
1
G098967
3
G099537
9
G136790
13
Based on the provided information, which one of the following statements is correct?
O a. There is not enough information to conclude the nature of this index
O b. It is definitely a sparse index
O c. It is definitely a dense index
O d. It is most likely a dense index, but could possibly be sparse
◇ e. It is most likely a sparse index, but could possibly be dense
Below shown is a logical representation of an index table built on columnA
SearchKey
Record Location
G005234
1
G098967
3
G099537
9
G136790
13
Based on the provided information, which one of the following statements is correct?
O a. It is most likely a clustered index, but could possibly be non-clustered
O b. There is not enough information to conclude the nature of this index
O c. It is most likely a non-clustered index, but could possibly be clustered
O d. It is definitely a clustered index
Oe. It is definitely a non-clustered index
Chapter 8 Solutions
Practical Management Science
Ch. 8.3 - Prob. 1PCh. 8.3 - Prob. 2PCh. 8.4 - Prob. 3PCh. 8.4 - Prob. 4PCh. 8.4 - Prob. 5PCh. 8.5 - Prob. 6PCh. 8.5 - Prob. 7PCh. 8.5 - In the lawn mower production problem in Example...Ch. 8.6 - Prob. 9PCh. 8.6 - Prob. 10P
Ch. 8.6 - Prob. 11PCh. 8.6 - Prob. 12PCh. 8.7 - Prob. 13PCh. 8.7 - Prob. 14PCh. 8.8 - Prob. 15PCh. 8.8 - Prob. 16PCh. 8.8 - Prob. 17PCh. 8.8 - Prob. 18PCh. 8.8 - Prob. 19PCh. 8 - Prob. 20PCh. 8 - Prob. 21PCh. 8 - Prob. 22PCh. 8 - Prob. 23PCh. 8 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Prob. 29PCh. 8 - Prob. 30PCh. 8 - Prob. 31PCh. 8 - Prob. 32PCh. 8 - Prob. 33PCh. 8 - Prob. 34PCh. 8 - Prob. 35PCh. 8 - Prob. 36PCh. 8 - Prob. 37PCh. 8 - Prob. 38PCh. 8 - Prob. 39PCh. 8 - Prob. 1CCh. 8 - Prob. 2C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?arrow_forwardThe file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?arrow_forwardThe file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year period. a. Fit an exponential trend line to these data. b. By what percentage do you estimate that the company will grow each month? c. Why cant a high rate of exponential growth continue for a long time? d. Rather than an exponential curve, what type of curve might better represent the growth of a new technology?arrow_forward
- You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)arrow_forwardYou want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).arrow_forwardAn investment manager is considering stocks X1, X2, and X3 for investment. Market research shows the following information (per stock) X1 X2 X3 cost $100 risk measure 8 price annual growth rate: 9% annual return: $14 cost $120 risk measure 10 price annual growth rate: 13% annual return: $15 cost $80 risk measure 7 price annual growth rate: 8% annual return: $20 Based on his experience, the manager has set the following priorities for the investment: (1) The total amount invested should be at least $90,000. (d1) (2) The minimum annual average growth rate in stock prices is 12%. (d2) (3) The risk factor of all stocks should not exceed a total of 5,000. (d3) (4) The total annual return should be $15,000. (d4) The constraint for the annual growth rate can be written as: 9X1 + 13X2 + 8X3 ≥ 12 [(9X1 + 13X2 + 8 X3)/(X1+ X2+ X3)] + d2- - d2+ ≥ 12 [(9X1 + 13X2 + 8X3)/(X1+ X2+ X3)] + d2- - d2+ ≤ 0 -3X1+ X2 - 4X3 + d2- - d2+ ≥ 12 -3X1 +…arrow_forward
- “Good Intentions” (GI) company produces two products, which it sells on both a cash and credit basis. Revenues from credit sales will not have been received but are included in determining profit earned during the current six-month period. Sales during the next six months can be made either from units produced during the next six months or from the beginning inventory. Relevant information about products one and two is as follows. During the next six months, at most 150 units of product type 1 can be sold on a cash basis, and at most 100 units of product 1 can be sold on a credit basis. It costs £35 to produce each unit of product type 1, and each sells for £40. A credit sale of a unit of product 1 yields £0.50 less profit than a cash sale (because of delays in receiving payment). Two hours of production time are needed to produce each unit of product 1. At the beginning of the six-month period, 60 units of product 1 are in the inventory. During the next six months, at most 175 units…arrow_forwardtypingarrow_forwardTo better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…arrow_forward
- The pucks used by the National Hockey League for ice hockey must weigh between 5.5 and 6.0 ounces. Suppose the weights of pucks produced at a factory are normally distributed with a mean of 5.75 ounces and a standard deviation of 0.13 ounces. What percentage of the pucks produced at this factory cannot be used by the National Hockey League? Round your answer to two decimal places. The percentage of pucks that cannot be used is %.arrow_forwardYou are a new salesperson at a large software manufacturing firm. It is three weeks from the end of the sales quarter and you and your sales manager have both already met your sales quotas for the quarter. In addition, you just closed another deal with a new customer for $100,000 worth of software and customer service. This order would put you way over your sales quota for the current quarter. Your manager suggests that you hold this new order so it gets recorded against next quarter. She explains that because sales during the next three months tend to slow down, salespeople frequently miss their quotas and associated sales bonuses for that quarter. Holding this large order to next quarter would help you get an excellent start and almost guarantee that you meet your quota. What would you do?arrow_forwardExplain it nowarrow_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,