Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Simulate the following decision situation for 20 weeks, and recommend the best decision. A concessions manager at the Tech versus A&M football game must decide

Simulate the following decision situation for 20 weeks, and recommend the best decision.

A concessions manager at the Tech versus A&M football game must decide whether to have the vendors sell sun visors or umbrellas. There is a 30% chance of rain, a 15% chance of overcast skies, and a 55% chance of sunshine, according to the weather forecast in college junction, where the game is to be held. The manager estimates that the following profits will result from each decision, given each set of weather conditions:

Sun Visor or Umbrella?
P(x)CumulativeSun Visor
0.350.3-400
0.250.15-200
0.40.551500
1
P(x)CumulativeUmbrella
0.350.32100
0.250.450
0.40.1-800
1
Simulation







WeekRNSunVisor ($)RNUmbrella ($)
1$
2($800.00)
3($200.00)($800.00)
4($500.00)
5
6($400.00)$
7($800.00)
8
9($800.00)
10($800.00)
11
12($400.00)($800.00)
13($400.00)($800.00)
14($800.00)
15($800.00)
16
17
18($200.00)
19($800.00)
20*80.00)
Average

$1,155
($54.50)

Decision Weather Conditions Rain Overcast Sunshine 0.35 0.25 0.40 Sun visors $-400 $-200 S1,500 Umbrellas 2,100 -800

Step by Step Solution

3.52 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

Px Cumulative Sun Visor Probabilities in all weather conditions 035 035 400 140 025 06 200 120 04 1 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 1 attachment)

Excel file Icon
60780f0b641b7_709953.xlsx

300 KBs Excel File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these Finance questions

Question

Why are variances usually written off to cost of goods sold?

Answered: 1 week ago