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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

問題2 Production system design involves determining the arrangement of workstations and the... O allocation of resources to workstations design of the process O production schedule all of the above

Elaborate on the need for and the benefits of an effective supply chain management (SCM) system in the context of a globalized and networked economy. In your answer, explain how organizations like Dell and Hewlett-Packard leverage supply chain networks to maintain competitiveness, and analyse the impact of globalization, technological advancements, and business environment changes on supply chain structures. Additionally, evaluate the key components of SCM, including distribution network configuration, inventory management, and cash-flow management, and discuss how these components contribute to creating an effective and integrated supply chain. (15) 3.2. Critically evaluate the requirements for effective inventory management within an organization. In your answer, discuss the importance of inventory accounting systems, the role of cost information (holding, ordering, and shortage costs), and the significance of classification systems like ABC analysis. Additionally, analyse how…

Assess the role of EDI in ensuring supply chain security and data integrity. How does EDI contribute to reducing vulnerabilities in supply chain operations, and what best practices should organizations adopt to maintain a secure and reliable EDI system? (10) 1.3. Examine how the adoption of modern EDI systems influences the strategic decision-making process in supply chain management. How does EDI provide supply chain managers with actionable insights, and what are the implications of these insights for long-term supply chain planning? (10) 1.4. Evaluate the potential challenges and risks associated with the modernization of EDI systems in supply chain management. How can organizations effectively manage these challenges to ensure successful EDI implementation and ongoing optimization? (10)

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 1

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 2

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 5

Practical Management Science, Chapter 10, Problem 29P , additional homework tip 6

Formulae to determine the above table:

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:

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