****PLEASE SOLVE IN EXCEL SPREAD SHEET AND SHOW EXCEL FORMULA AND STEPS ON HOW TO DO THEM****

File Home Insert Page Layout Formulas Data Review View Help 5. X Cut 12 A A - EE ===. Normal e Paste Arial BIU- 5 HICH EP3 Conditional Format as Good Formatting Table- [ Copy- Format Painter Clipboard & A. Undo Font F B D E F G H 1 J K L 1 Q4 2 A garage band wants to hold a concert. The expected crowd size is 2,000 people. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 85% of the ticket revenue, plus all of the concession sales revenue, minus a fixed cost of $18,000. The model below was used to find the band's expected profit. 3 4 5 6 Crowd Size 2,000 7 Average Concessions Expenditu S 8 Fixed Cost $ 30 18,000 25 85% 9 Ticket Price $ 10 Profit Percentage 11 12 Ticket Revenue $ 50,000 13 Concession Revenue $ 60,000 14 15 Profit $ 84,500 16 17 Now suppose that the crowd size is normally distributed with a mean of 3,000 and a standard deviation of 200. 18 The average concession expenditure has a triangular distribution with minimum = $20, maximum = $35, and a most likely value of $30. 19 Conduct a Monte Carlo simulation with 500 Trials to find the histogram and the minimum, maximum, average, and standard deviation of the profit. 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 T29 Power Pivot H Alignment Wrap Text Merge & Center - G General $ Number 1 Styles Bad Neutral M S DE IIX Insert Delete Format Cells N 0 AutoSum AYO Fill Sort & Find & Clear Filter Select Editing P Q R Comments [0] IS Analyze Sensitivity Data Analysis Sensitivity 5 T U Share V File Home Insert Page Layout Formulas Data Review View Help 5. X Cut 12 A A - EE ===. Normal e Paste Arial BIU- 5 HICH EP3 Conditional Format as Good Formatting Table- [ Copy- Format Painter Clipboard & A. Undo Font F B D E F G H 1 J K L 1 Q4 2 A garage band wants to hold a concert. The expected crowd size is 2,000 people. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 85% of the ticket revenue, plus all of the concession sales revenue, minus a fixed cost of $18,000. The model below was used to find the band's expected profit. 3 4 5 6 Crowd Size 2,000 7 Average Concessions Expenditu S 8 Fixed Cost $ 30 18,000 25 85% 9 Ticket Price $ 10 Profit Percentage 11 12 Ticket Revenue $ 50,000 13 Concession Revenue $ 60,000 14 15 Profit $ 84,500 16 17 Now suppose that the crowd size is normally distributed with a mean of 3,000 and a standard deviation of 200. 18 The average concession expenditure has a triangular distribution with minimum = $20, maximum = $35, and a most likely value of $30. 19 Conduct a Monte Carlo simulation with 500 Trials to find the histogram and the minimum, maximum, average, and standard deviation of the profit. 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 T29 Power Pivot H Alignment Wrap Text Merge & Center - G General $ Number 1 Styles Bad Neutral M S DE IIX Insert Delete Format Cells N 0 AutoSum AYO Fill Sort & Find & Clear Filter Select Editing P Q R Comments [0] IS Analyze Sensitivity Data Analysis Sensitivity 5 T U Share V