Practical Management Science
5th Edition
ISBN: 9781305734845
Author: WINSTON
Publisher: Cengage
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
Main Challenges at TechInnovateStrategic DirectionTechInnovate's board of directors is pushing for a more aggressive expansion into emerging markets, particularly in Africaand Southeast Asia. However, there's internal disagreement about whether to focus on these new markets or consolidatetheir position in existing ones. Sarah Chen favors rapid expansion, while some senior executives advocate for a morecautious approach.Ethical ConcernsThe company's AI algorithms have come under scrutiny for potential biases, particularly in facial recognition technology.There are concerns that these biases disproportionately affect minority groups. Some employees have voiced ethicalconcerns about selling this technology to law enforcement agencies without addressing these issues.Team Leadership and DiversityTechInnovate's leadership team is predominantly male and Western, despite its global presence. There's growing pressurefrom employees and some board members to diversify the leadership team to…
Sarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting research on the attendance history for cultural events in the area over the past ten years. The following data has been collected on the number of attendees who registered for events at the cultural center.
Year
Number of Attendees
1
700
2
248
3
633
4
458
5
1410
6
1588
7
1629
8
1301
9
1455
10
1989
You have been hired as a consultant to assist in implementing a forecasting system that utilizes various forecasting techniques to predict attendance for Year 11.
a) Calculate the Three-Period Simple Moving Average
b) Calculate the Three-Period Weighted Moving Average (weights: 50%, 30%, and 20%; use 50% for the most recent period, 30% for the next most recent, and 20% for the oldest)
c) Apply Exponential Smoothing with the smoothing constant alpha = 0.2.
d) Perform a Simple Linear Regression analysis and provide the adjusted…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of
70
units and is valued at
$90
per unit. Inbound shipments from vendor 1 will average
390
units with an average lead time (including ordering delays and transit time) of
4
weeks. Inbound shipments from vendor 2 will average
490
units with an average lead time of
2
weeksweeks.
Ruby-Star operates 52 weeks per year; it carries a
4-week
supply of inventory as safety stock and no anticipation inventory.
Part 2
a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is
$enter your response here.
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 - 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
- Sam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: > Demand 75 bags/week > Order cost = $52.00/order > Annual holding cost = 20 percent of cost > Desired cycle-service level = 80 percent >Lead time = 5 weeks (30 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 75 bags is incorrect and actual demand averages only 50 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_forwardYellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 2,250 rolls. The cost per roll is $625, and the annual holding cost is 20 percent of the cost. Each order costs $75. a. How many rolls should Yellow Press order at a time? Yellow Press should order rolls at a time. (Enter your response rounded to the nearest whole number.)arrow_forwardPlease help with only the one I circled! I solved the others :)arrow_forward
- Osprey Sports stocks everything that a musky fisherman could want in the Great North Woods. A particular musky lure has been very popular with local fishermen as well as those who buy lures on the Internet from Osprey Sports. The cost to place orders with the supplier is $40/order; the demand averages 3 lures per day, with a standard deviation of 1 lure; and the inventory holding cost is $1.00/lure/year. The lead time form the supplier is 10 days, with a standard deviation of 2 days. It is important to maintain a 97 percent cycle-service level to properly balance service with inventory holding costs. Osprey Sports is open 350 days a year to allow the owners the opportunity to fish for muskies during the prime season. The owners want to use a continuous review inventory system for this item. Refer to the standard normal table for z-values. a. What order quantity should be used? lures. (Enter your response rounded to the nearest whole number.)arrow_forwardIn a P system, the lead time for a box of weed-killer is two weeks and the review period is one week. Demand during the protection interval averages 262 boxes, with a standard deviation of demand during the protection interval of 40 boxes. a. What is the cycle-service level when the target inventory is set at 350 boxes? Refer to the standard normal table as needed. The cycle-service level is ☐ %. (Enter your response rounded to two decimal places.)arrow_forwardOakwood Hospital is considering using ABC analysis to classify laboratory SKUs into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two bin system (C items). The following table shows the annual dollar usage for a sample of eight SKUs. Fill in the blanks for annual dollar usage below. (Enter your responses rounded to the mearest whole number.) Annual SKU Unit Value Demand (units) Dollar Usage 1 $1.50 200 2 $0.02 120,000 $ 3 $1.00 40,000 $ 4 $0.02 1,200 5 $4.50 700 6 $0.20 60,000 7 $0.90 350 8 $0.45 80arrow_forward
- A part is produced in lots of 1,000 units. It is assembled from 2 components worth $30 total. The value added in production (for labor and variable overhead) is $30 per unit, bringing total costs per completed unit to $60 The average lead time for the part is 7 weeks and annual demand is 3800 units, based on 50 business weeks per year. Part 2 a. How many units of the part are held, on average, in cycle inventory? enter your response here unitsarrow_forwardassume the initial inventory has no holding cost in the first period and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. What is the total cost? ENTER your response is a whole number (answer is not $17,000. That was INCORRECT)arrow_forwardRegular Period Time Overtime Supply Available puewag Subcontract Forecast 40 15 15 40 2 35 40 28 15 15 20 15 22 65 60 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit 20 units $100 $150 $200 Carrying cost per unit per month 84arrow_forward
- assume that the initial inventory has no holding cost in the first period, and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. The total cost is? (enter as whole number)arrow_forwardThe S&OP team at Kansas Furniture, led by David Angelow, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $125 per unit, inventory carrying costs of $30 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan B: Vary the workforce to produce the prior month's demand. Demand was 1,300 units in June. The cost of hiring additional workers is $35 per unit produced. The cost of layoffs is $60 per unit cut back. (Enter all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of 1,300 in July to 1300 in August requires a layoff (and related costs) of 0 units in August). Hire Month 1 July Demand 1300 Production (Units) Layoff (Units) Ending Inventory Stockouts (Units) 2 August 1150 3 September 1100 4 October 1600 5 November 1900 6 December 1900arrow_forwardThe S&OP team at Kansas Furniture, led by David Angelow, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $20 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,100 units per month and subcontract additional units at a $65 per unit premium cost. Subcontracting capacity is limited to 800 units per month. (Enter all responses as whole numbers). Ending Month Demand Production Inventory Subcontract (Units) 1 July 1300 1,100 0 2 August 1150 1,100 0 3 September 1100 1,100 0 4 October 1600 1,100 0 5 November 1900 1,100 0 6 December 1200 1,100 0arrow_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