Practical Management Science
5th Edition
ISBN: 9781305250901
Author: Wayne L. Winston, S. Christian Albright
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10.2, Problem 1P
Use the RAND function and the Copy command to generate 100 random numbers.
- a. What fraction of the random numbers are smaller than 0.5?
- b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5?
- c. What fraction of the random numbers are larger than 0.8?
- d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Menu Item Sales and Cost Data
Taco Salad: Number Sold: 127; Item Cost: $0.71; Selling Price: $3.25
Lasagna: Number Sold: 48; Item Cost: $0.92; Selling Price: $4.67
Chicken: Number Sold: 31; Item Cost: $1.20; Selling Price: $3.00
Green Beans: Number Sold: 14; Item Cost: $0.20; Selling Price: $1.00
Corn: Number Sold: 13; Item Cost: $0.24; Selling Price: $1.00
Rice: Number Sold: 9;Item Cost: $0.13; Selling Price: $1.00
Menu Item Classification:
Low contribution margin, low menu mix % DOG
High contribution margin, low menu mix % PUZZLE
Low contribution margin, high menu mix % PLOWHORSE
High contribution margin, high menu mix o/o STAR
QUESTION 1
Complete the menu analyses worksheet below. Calculations will be done using the information above.
Restaurant:
Date:
MealPeriod:
(A)
☐
(B) (C)
(D) (E) (F)
(G)
(H)
(1)
(J)
Menu
Mix
Popularity
%
Item Item
Sold/(Menu
Mix
Menu Menu
Item
Food
Menu
Contribution Contribution
Contribution
Category
Item
Mix %): (B/K) Cost
Selling
Margin
Price Margin (E-D)…
1) Around the Clock Production of Fire Nozzles
View the videos Around the Clock Production of Fire Nozzles 1 https://media.gaspar.mheducation.com/GASPARPlayer/play.html?id=132KoZwS0yMEgsToDUsZjJe (9.44 minutes, Ctrl+Click on the link) and Around the Clock Production of Fire Nozzles 2 https://media.gaspar.mheducation.com/GASPARPlayer/play.html?id=44JM0cKtFLqHP5bad6KOHAm (7.43 minutes, Ctrl+Click on the link); what are your key takeaways (tie to one or more of the topics discussed in Chapters 12 and/or 13) after watching these videos.
Note: As a rough guideline, please try to keep the written submission to one or two paragraphs.
2) Cyberdyne Systems stocks and sells Cyberdyne glucose meters. The firm gathered the following information from its South Pasadena office:
Demand = 19,500 units per year
Ordering cost = $25 per order
Holding cost = $4 per unit per year
The firm’s operations manager wants to calculate the:
a) EOQ for the glucose meters.
b) Annual holding costs for the…
In the following problems assume, unless otherwise stated, that S = $40, σ = 30%, r =8%,and δ =0.
13.1 Suppose you sell a 45-strike call with 91 days to expiration. What is delta? If the option is on 100 shares, what investment is required for a delta-hedged portfolio? What is your overnight profit if the stock tomorrow is $39? What if the stock price is $40.50?
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
- Question 1 M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 4 165 5 180 6 200 7 195 8 210 9 225 10 240 11 255 12 270 Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] b. If the company applies an exponential smoothing method with a smoothing constant (a) = 02, and assumes an initial forecast of 120 units for Month 1, calculate the forecast for month 13. [6 marks] c. Calculate the Mean Absolute Deviation (MAD) for the exponential smoothing method and weighted moving average method using the actual sales data for Months 4 to 12 and determine which method is more accurate. [8 marks] d. Compute the values of a (intercept) and b (slope) using the least squares method. [7 marks] e. Use the…arrow_forwardQuestion 4 MGM12026 Production and Operations Management semester il 2024 A company operates a manufacturing plant that produces two products, A and B. The plant has the following capacity data: . . Design Capacity: 15,000 machine hours per month Effective Capacity: 12,000 machine hours per month Actual Output (Utilized Capacity): 10,000 machine hours per month Additionally, the plant produces Product A and Product B, with the following production data: Product Demand (Units) Processing Time Contribution Margin ($ (hours per unit) per unit) A 3,000 2.5 40 B 4,000 1.5 30 a. Calculate the plant's i. Capacity Utilization [3 marks] ii. Effective Capacity Utilization [3 marks] iii. Efficiency. Interpret the results. [3 marks] b. Compute the total machine hours required to meet full demand for both products. [5 marks] c. Determine whether the plant has sufficient capacity to meet full demand. If not, calculate the shortfall in machine hours. [3 marks] d. Using the contribution margin per…arrow_forwardQuestion 3 i. Using the Center of Gravity method, determine the optimal location (X, Y) for the new distribution center. [7 marks] [TOTAL 25 MARKS] Time (sec.) Power steering assembly firm wants to set up an assembly line which must have an output of 60 units per hour. The work elements, task times and their precedence relationships are shown in Table 2: Table 1 Work Element Immediate Predecessor(s) A 30 NONE B 26 A C 50 A D 44 B E 10 с F 20 с G 15 D.E H 30 E,G,F Required: a. Draw the precedence diagram showing the task precedence and their times b. Determine the cycle time associated with the rate of output required. [3 marks] c. What is the theoretical number of work stations required to satisfy this output rate? [3 marks] [4 marks] d. Allocate the tasks to work stations taking into consideration the precedence requirements and using the LOT rule to break ties between feasible tasks. e. Calculate the total idle time [8 marks] [3 marks] f. What is the efficiency of the line and the…arrow_forward
- Question 2 MGMT2026 Production and Operations Management Semester II 2024-2025 a. Aman ltd. desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 (worst) to 10 (best) on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows in the Table 2 below: Table 2 Factor Score Evaluation by Location Criterion Weights A B с D Wages 25 4 5 3 4 Government Policies 30 8 7 6 5 Unionisation Weather 15 6 4 3 2 30 3 4 6 5 i. Based on weighted scores, where should Acme locate its new facility? [6 marks] b. An operations manager has narrowed down the search for a new factory to three locations. The fixed and variable costs associated with each location is given in the table below. i. Table 3 Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 с $200,000 $5…arrow_forwardThe University of the West Indies GLOBAL CAMPUS MGMT 2026 Production and Operations Management - Problem Sheet Assignment Semester II 2024/2025 Note: Although this assignment is being currently assessed out of 100 marks it would be prorated to Contribute a maximum of 40% towards your final course marks. M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 165 5 180 200 7 195 8 210 225 10 240 11 255 12 270 This Assignment is comprised of four (4) Questions - All questions must be attempted Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] Screens 5-7 of 7arrow_forwardGas sales across type: 80% of gas sales tend to be regular. 15% midgrade, 5% tend to be premium. $0.10 increase in price per gallon tends to decrease gallons sold by 1 to 3%. Jan-0.87, Feb-0.95, Mar-1.00, Apr-1.05, May-1.08, Jun1.15, Jul-1.13, Aug-1.07, Sep-1.02, Oct-0.94, Nov-0.89, Dec-0.85. You want the MAPE to be below 20%, if ypu can get it to or below 10% they'll throw in extra $10k. Wont get bonus if it is above 11% or 20%. It cannot be over 20%.arrow_forward
- help me choose the correct path please. There are other optionsarrow_forwardNegotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible. agree with the postarrow_forwardNegotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible. disagree with this post or add on to the postarrow_forward
- The strategy of Multiple Equivalent Simultaneous Offers involves presenting several equally valuable options to the other party during negotiations. This approach benefits negotiators by creating flexibility and increasing the chances of finding a mutually agreeable solution. By offering multiple options, negotiators show that they are open to compromise, which can build trust and make the negotiation process smoother. It also helps avoid getting stuck on one issue, as the other party can choose from several alternatives that meet their needs. In my experience, using MESOs in a work negotiation helped both parties reach an agreement more quickly because each option was carefully thought out to address different needs, and this made it easier for us to settle on one that worked for both sides. This strategy can also reveal what is most important to the other party, helping negotiators understand their priorities better. agree or disagree with the postarrow_forwardExamine the conflicts between improving customer service levels and controlling costs in sales. Strategies to Balance Both customer service levels and controlling costs in sales 1.Outsourcing and workforce optimization 2. AI-driven customer supportarrow_forwardhow can you gain trust in a negotiation setting?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