EBK PRACTICAL MANAGEMENT SCIENCE
5th Edition
ISBN: 9780100655065
Author: ALBRIGHT
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 30P
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
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
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.
“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…
Chapter 8 Solutions
EBK 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.9 - Prob. 17PCh. 8.9 - Prob. 18PCh. 8.10 - Prob. 20PCh. 8.10 - Prob. 21PCh. 8.10 - Prob. 22PCh. 8.10 - Prob. 23PCh. 8.10 - 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. 40PCh. 8 - Prob. 41PCh. 8 - Prob. 42PCh. 8 - Prob. 43PCh. 8 - Prob. 44PCh. 8 - Prob. 46PCh. 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
- The 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_forwardSuppose 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_forwardYou 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_forward
- An 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_forwardAccepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), “E” or “e” (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where “a” and “b” need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. A survey determines that mint chocolate chip is the favorite ice cream flavor of 6% of consumers. An ice cream shop determines that of 190 customers, 15 customers stated their preference for mint chocolate chip. Find the P-value that would be used to determine if the percentage of customers who prefer mint chocolate chip ice has increased at a 5% level of significance. P-value: Round your answer to four decimal places as necessararrow_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_forward
- I am having trouble with d and earrow_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_forwardtypingarrow_forward
- E2arrow_forwardBelow is a logical representation of an index table built on columnA SearchKey Record Location G005234 4 G098967 1 G098967 3 G136790 2 Based on information shown in the index table - which one of the following statements is accurate? O a. The table containing ColumnA is not physically sorted by ColumnA O b. The table containing ColumnA is physically sorted by ColumnA O c. Without seeing the actual table, based on index alone it is not possible to determine whether or not table is sorted by columnA O d. Insufficient information to determine whether or not the table is sorted by ColumnAarrow_forward4. Explain how the logit model overcomes the problems associated with the Linera Probability Model in binary dependent variaraile model.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,