Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of $250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a ?

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 10, Problem 29P

Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of $250 per room.

a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100.
b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Describe how a continuous simulation model can benefit the business strategy decisions for your chosen business (Retail store)

Adele Weiss manages the campus flower shop. Flowers must be ordered three days in advance from her supplier in Mexico. Although Valentine’s Day is fast approaching, sales are almost entirely last-minute, impulse purchases. Advance sales are so small that Weiss has no way to estimate the probability of low (25 dozen), medium (60 dozen), or high (130 dozen) demand for red roses on the big day. She buys roses for $15 per dozen and sells them for $40 per dozen. Construct a payoff table. Which decision is indicated by each of the following decision criteria?a. Maximinb. Maximaxc. Laplaced. Minimax regret

M2,

Answer 2

Textbook Question

Chapter 10, Problem 29P

Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of $250 per room.

a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100.
b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 10, Problem 29P

Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of $250 per room.

a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100.
b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 10, Problem 29P

Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of $150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of $250 per room.

a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100.
b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Answer 8

a)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Answer 13

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 1

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 3

Output results:

Run simulation by placing the cursor on B15.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 4

The average cost minimized between 4500 and 4900.

Answer 14

b)

Expert Solution

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Answer 15

b)

Expert Solution

Answer 16

b)

Expert Solution

Answer 17

Expert Solution

Answer 18

Summary Introduction

To determine: The number of rooms that should be reserved to minimize the expected cost.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

Answer 19

Explanation of Solution

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 5

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 7

Output results:

Run simulation by placing the cursor on B16.

In the @RISK click start simulation to develop the following output results:

EBK PRACTICAL MANAGEMENT SCIENCE, Chapter 10, Problem 29P , additional homework tip 8

Here, the best number of rooms reserved is somewhat smaller than the numbers in part (a). The average cost is not lower than part (a).

Answer 20

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. 11P Ch. 10.4 - In August of the current year, a car dealer is...

Concept explainers

Videos

Explanation of Solution

Explanation of Solution

Want to see more full solutions like this?

Chapter 10 Solutions