Practical Management Science
6th Edition
ISBN: 9781337671989
Author: WINSTON
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 47P
If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Cariveh Co sells automotive supplies from 25 different locations in one country. Each branch has up to 30 staff working there, although most of the accounting systems are designed and implemented from the company's head office. All accounting systems, apart from petty cash, are computerised, with the internal audit department frequently advising and implementing controls within those systems. Cariveh has an internal audit department of six staff, all of whom have been employed at Cariveh for a minimum of five years and some for as long as 15 years. In the past, the chief internal auditor appoints staff within the internal audit department, although the chief executive officer (CEO) is responsible for appointing the chief internal auditor. The chief internal auditor reports directly to the finance director. The finance director also assists the chief internal auditor in deciding on the scope of work of the internal audit department. You are an audit manager in the internal audit…
Cariveh Co sells automotive supplies from 25 different locations in one country. Each branch has up to 30 staff working there, although most of the accounting systems are designed and implemented from the company's head office. All accounting systems, apart from petty cash, are computerised, with the internal audit department frequently advising and implementing controls within those systems. Cariveh has an internal audit department of six staff, all of whom have been employed at Cariveh for a minimum of five years and some for as long as 15 years. In the past, the chief internal auditor appoints staff within the internal audit department, although the chief executive officer (CEO) is responsible for appointing the chief internal auditor. The chief internal auditor reports directly to the finance director. The finance director also assists the chief internal auditor in deciding on the scope of work of the internal audit department. You are an audit manager in the internal audit…
Please show all steps and answers, thank you!
Chapter 10 Solutions
Practical Management Science
Ch. 10.2 - Use the RAND function and the Copy command to...Ch. 10.2 - Use Excels functions (not @RISK) to generate 1000...Ch. 10.2 - Use @RISK to draw a uniform distribution from 400...Ch. 10.2 - Use @RISK to draw a normal distribution with mean...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - Use @RISK to draw a binomial distribution that...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - We all hate to keep track of small change. By...Ch. 10.4 - Prob. 11PCh. 10.4 - In August of the current year, a car dealer is...
Ch. 10.4 - Prob. 13PCh. 10.4 - Prob. 14PCh. 10.4 - Prob. 15PCh. 10.5 - If you add several normally distributed random...Ch. 10.5 - In Problem 11 from the previous section, we stated...Ch. 10.5 - Continuing the previous problem, assume, as in...Ch. 10.5 - In Problem 12 of the previous section, suppose...Ch. 10.5 - Use @RISK to analyze the sweatshirt situation in...Ch. 10.5 - Although the normal distribution is a reasonable...Ch. 10.6 - When you use @RISKs correlation feature to...Ch. 10.6 - Prob. 24PCh. 10.6 - Prob. 25PCh. 10.6 - Prob. 28PCh. 10 - Six months before its annual convention, the...Ch. 10 - Prob. 30PCh. 10 - A new edition of a very popular textbook will be...Ch. 10 - Prob. 32PCh. 10 - W. L. Brown, a direct marketer of womens clothing,...Ch. 10 - Assume that all of a companys job applicants must...Ch. 10 - Lemingtons is trying to determine how many Jean...Ch. 10 - Dilberts Department Store is trying to determine...Ch. 10 - It is surprising (but true) that if 23 people are...Ch. 10 - Prob. 40PCh. 10 - At the beginning of each week, a machine is in one...Ch. 10 - Simulation can be used to illustrate a number of...Ch. 10 - Prob. 43PCh. 10 - Prob. 46PCh. 10 - If you want to replicate the results of a...Ch. 10 - Suppose you simulate a gambling situation where...Ch. 10 - Prob. 49PCh. 10 - Big Hit Video must determine how many copies of a...Ch. 10 - Prob. 51PCh. 10 - Prob. 52PCh. 10 - Why is the RISKCORRMAT function necessary? How...Ch. 10 - Consider the claim that normally distributed...Ch. 10 - Prob. 55PCh. 10 - When you use a RISKSIMTABLE function for a...Ch. 10 - Consider a situation where there is a cost that is...
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
- I am not sure if this is correct, because 8 cannot go directly to 10.arrow_forwardA practical application in real life to the Critical Path Method is the construction of a bridge with references, give a detailed essay on the stages involved in constructing a bridgearrow_forwardPlease assist in writing a complete reasearch project of the following title: Title of research: Study on the impact of Technology in the Work Place.arrow_forward
- Intuition is both an emotional experience and a nonconscious analytic process. One problem, however, is that not all emotions signaling that there is a problem or opportunity represent intuition. Please in your Personal opinion how we would know if our “gut feelings” are intuition or not, and if not intuition, suggest what might be causing them.arrow_forwardA coworker suggests that the company where you both work would be much more effective if there were no organizational politics. Please in your personal and detailed opinion, What would you say to this person in reply?arrow_forwardWhat is a bottleneck? Would you try to reduce a bottleneck? Why or why not? Please provide a referencearrow_forward
- Your firm has been the auditor of Caribild Products, a listed company, for a number of years. The engagement partner has asked you to describe the matters you would consider when planning the audit for the year ended 31January 2022. During recent visit to the company you obtained the following information: (a) The management accounts for the 10 months to 30 November 2021 show a revenue of $260 million and profit before tax of $8 million. Assume sales and profits accrue evenly throughout the year. In the year ended 31 January 2021 Caribild Products had sales of $220 million and profit before tax of $16 million. (b) The company installed a new computerised inventory control system which has operated from 1 June 2021. As the inventory control system records inventory movements and current inventory quantities, the company is proposing: (i) To use the inventory quantities on the computer to value the inventory at the year-end (ii) Not to carry out an inventory count at the year-end (c)…arrow_forwardDevelop and implement a complex and scientific project for an organisation of your choice. please include report include the following: Introduction Background research to the project The 5 basic phases in the project management process Project Initiation Project Planning Project Execution Project Monitoring and Controlling Project Closing Conclusionarrow_forwardNot use ai pleasearrow_forward
- Sam's Pet Hotel operates 51 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags: > Demand 95 bags/week > Order cost $52.00/order > Annual holding cost = 25 percent of cost > Desired cycle-service level = 80 percent >Lead time 4 weeks (24 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only 75 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $ higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forwardSam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.50 per bag. The following information is available about these bags: > Demand = 95 bags/week > Order cost = $55.00/order > Annual holding cost = 35 percent of cost > Desired cycle-service level = 80 percent > Lead time = 4 weeks (24 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only 75 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $ 10.64 higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) b. Suppose that actual demand is 75 bags but that ordering costs are cut to only $13.00 by using the internet to automate order placing. However, the buyer does…arrow_forwardBUS-660 Topic 4: Intege... W Midterm Exam - BUS-66... webassign.net b Answered: The binding c... × W Topic 4 Assignment - BU... how to get more chegg... b My Questions | bartleby + macbook screenshot - G... C Consider the following m... As discussed in Section 8.3, the Markowitz model uses the variance of the portfolio as the measure of risk. However, variance includes deviations both below and above the mean return. Semivariance includes only deviations below the mean and is considered by many to be a better measure of risk. (a) Develop a model that minimizes semivariance for the Hauck Financial data given in the file HauckData with a required return of 10%. Assume that the five planning scenarios in the Hauck Financial Services model are equally likely to occur. Hint: Modify model (8.10)-(8.19). Define a variable d for each 5 - scenario and let d≥ Ŕ – R¸ with d¸ ≥ 0. Then make the objective function: Min 1 5 Σας Let Min s.t. 15 FS = proportion of portfolio invested in the foreign…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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License