Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10.2, Problem 2P
Use Excel’s functions (not @RISK) to generate 1000 random numbers from a
- a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?
- b. What fraction of these random numbers are within k standard deviations of the mean? Answer for k = 1; for k = 2; for k = 3. Are the answers close to what they should be (about 68% for k = 1, about 95% for k = 2, and over 99% for k = 3)?
- c. Create a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
her psychological test and interview while Ms. Domingo got a good score and good psychological result. Ms. Sabado’s father is your godfather and a good friend of yours. Ms. Sabado asked you a favor to consider her daughter and if possible she will be hired. He also added that every job can be learned through training and mentoring. The situation bothers you since it’s your duty to recommend to the higher authority whom to hire.Questions:1. As a supervisor how will you diced on this situation?2. It’s time to decide, who among the two (2) will be hired? Why?
Help me solve part C.
Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the
following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)
Dollar
Item
Annual Demand Cost/Unit
Volume
% of Total Dollar
Volume
A2
10
120
B8
4000
12
48,000
5.65
C7
1500
45
67,500
7.94
D1
2000
44
E9
1000
20
20,000
2.35
F3
25
40
G2
200
1500
300,000
35.29
H2
600
20
12,000
1.41
15
1000
300
J8
2500
5
12,500
1.47
Chapter 10 Solutions
Practical Management Science, Loose-leaf Version
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 - Prob. 34PCh. 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
- Bobby Flay is responsible for assigning steel workers to a structural steel infrastructure construction task. Having taken Project Management at the University of Portland, he understands the importance of managing risk. To ensure that the task takes place as scheduled, Bobby must ensure that there are at least 8 steel workers available at the start of the task. Based on analysis of similar tasks, he estimates that steel workers will show up for the task with probability 0.9. If Bobby wants to be 97% sure that there are enough tasks to begin as scheduled, he should assign ______ steel workers to the task.arrow_forwardMarcela Valladolid needs to assign resources to a task on a new high-tech development project at Jonathon's Pool Supplies. According to her estimates, the task's work content (in hours) is 408. Marcela needs help in determining an appropriate number of resources to allocate to the task. Marcela read somewhere that, when it comes to project staffing, more is not always better. Assuming that the direct labor rate per hour is $93, the indirect and over head rate per unit time is $73.62, assigned resources are dedicated to the task full time, and that 0.02 hours of communication per coordination are required per link per hour worked, help Marcela by determining the following: What is the minimum total cost: What resource allocation minimizes the total cost: What is the minimum duration: What is the duration minimizing number of resources: If Marcela assigns 12 FTEs to the task, the task metrics would be: Total Cost: Total Duration: Note: enter durations to 1 decimal place and costs…arrow_forward1 point) Market Fresh Foods is looking to develop a new strategic plan. Guillermo Santiago has been developing a project plan and has identified the following tasks, precedence relations, normal task durations, and resource requirements. Guillermo has studied project management at the University of Portland and knows that the makespan of the project may be determined from the information in the table using the critical path method. Guillermo also learned a simple heuristic for evaluating resource sufficiency. Help Guillermo by answering the following related assuming 3 workers per week and a due date of 302.8: Project Work Content: Total Resource Capacity: Minimum due date for which 3 resources is sufficient: Minimum resource level that could make due date of 302.8 feasible:arrow_forward
- How an individual attending a university can help the development of a country?arrow_forwardWhat are the job description or role in Operations management? Please answer at your own easy words.arrow_forwardI am currently working as a Sub Assistant Manager at Advance Personal Care Limited (APCL), a concern of Pran Group. I hold a Bachelor of Pharmacy (Professional) degree. I recently came across a job posting on BD Jobs for a position in Project Management within Quality Operations. I want to apply for this role and need to update my CV accordingly. Could you please guide me on what key information, achievements, and skills I should add or highlight in my CV to align with this new role? Note that i have 8 months experience on this role. Please write at your own easy words. Please don't use Ai answering this question. I will rate you positive if you do so.arrow_forward
- I am currently working as a Sub Assistant Manager at Advance Personal Care Limited (APCL), a concern of Pran Group. I hold a Bachelor of Pharmacy (Professional) degree. I recently came across a job posting on BD Jobs for a position in Project Management within Quality Operations. I want to apply for this role and need to update my CV accordingly. Could you please guide me on what key information, achievements, and skills I should add or highlight in my CV to align with this new role? Note that i have 8 months experience on this role. Please don't use Ai answering this question. I will rate you positive if you do so.arrow_forwardWhat are the three main concepts of understanding in Operations Management?arrow_forwardNeed help please not sure where to start or how to write it.arrow_forward
- Need help please not sure where to start or how to write it.arrow_forwardSIPOC Process Supplier Machines Quality Group Leader Double Output Customers Inputs Solutions End of batch Inspection verification Scrap evaluation Sampling Verification Batch complete Evaluation Completed Quality Group Leader Samplings verified Quality Samplings verified Quality Barcode programed Mechanic Parameters registered Quality Line verified Quality Line Verified Quality Second verification Barcode Parameters Line Inspection Second Line Inspection Lot and Expiration Date Quality Quality Mechanic Mechanic Quality Machines Quality Group Leader Quality Quality Quality Batch Verification Process complete Revision Review Sampling Verification Barcode Scanner Machine Parameters Line Clearance Line Clearance Machine Remove Lot Status Verification Close floor Final MFG Review Final QA Review Close Batch Machine removed Lot verified Floor closed MFG Reviewed Process reviewed Batch closed Mechanic Group Leader Quality Quality Quality Group Leaderarrow_forwardAn assessment of gender leadership and corporate culture.Kindly provide the following, citing it using in-text referencing: • A thorough exploration of gender dynamics and concepts.• Creating a clear plan to address gender bias and promote inclusive leadership.• An examination of female leadership dynamics and their impact on performance. • Comprehensive justification behind the proposal.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