You are the owner of a small business that manages the program, food, and merchandise sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games, the Excel Center hosts dozens of events a year. Your company handles all sales inside the arena. There are three major products you sell: programs, food, and merchandise. You have randomly selected sales and attendance data from a number of past events to help build your model. This data can be found on the "Past Events" worksheet. You have classified each event as a "Sporting Event," "Concert," or "Other Event." You have also classified each event by the attendance at that event as "Poor" (less than 10,000 people in attendance), "Fair" (between 10,000 and 15,000 people in attendance), "Good" (between 15,000 and 20,000 people in attendance), or "Excellent" (more than 20,000 people in attendance). Complete the tasks to build each of the PivotTables described. Make sure you create a new Pivot Table when a task asks you to construct a Pivot Table; place that Pivot Table on an appropriately named worksheet. For each question, select the answer from the drop-down list that is closest to the answer you found in your analysis. PivotTable Questions Question 1 - Which type of event ("Concert," "Sporting Event," or "Other Event") has the largest average attendance? Question 2 - For only those events with "Excellent" crowd sizes, how much total merchandise revenue was earned? Question 3 - What percent of events with "Fair" crowd sizes were sporting events? Question 4-What percent of all concerts had a crowd size of "Excellent"? Question 5 - How much more money from food sales has been generated at concerts than at other events, not including sporting events, for events in the sample? - 1 2 3 Event 4 1123 Fair 5 1125 Good 6 1214 Good 7 1217 Fair 8 1322 Good 9 1416 Fair 10 1419 Excellent 11 1621 Fair 12 1713 Good 13 1716 Good 14 1723 Good 15 1919 Good 16 2119 Fair 17 2317 Good 18 2321 Poor 19 2322 Fair 20 2416 Fair 21 2418 Poor 22 2419 Excellent 23 2523 Fair 24 2524 Excellent 25 2527 Fair 26 2615 27 2620 28 2621 29 2919 30 2921 Good 31 2924 Fair 32 3121 Good Crowd Size Excellent Excellent Poor Excellent Randomly Selected Past Events Attendance 11055 19689 16657 11383 15334 12081 20082 10643 18421 18485 17012 16884 14350 15901 8789 13629 13331 8569 21016 13281 21538 12465 20611 20145 8800 20999 15443 10848 19953 Programs Food $28,190 $76,722 $168,538 $113,409 $74,457 $239,861 $32,100 $181,217 $102,584 $70,191 $106,836 $246,808 $39,486 $139,210 $128,947 $223,078 $63,219 $187,992 $35,045 $204,484 $29,040 $128,318 $35,014 $72,181 $34,187 $221,183 $63,544 $131,659 $59,968 $211,250 $95,583 $161,172 $35,047 $106,084 $56,323 $305,362 $23,109 $113,951 $119,536 $79,153 $176,430 $58,018 $30,096 $97,645 $123,390 $67,149 $91,983 $98,598 $68,620 $129,228 $142,101 $166,125 $234,689 $87,032 $223,639 $237,822 $172,483 $265,774 Merchandise $146,037 $499,116 $351,629 $271,826 $618,267 $407,975 $561,292 $448,070 $615,814 $251,396 $137,967 $695,621 $569,552 $244,557 $103,798 $457,253 $419,527 $117,310 $774,860 $454,210 $987,087 $121,160 $581,642 $283,843 $292,336 $893,927 $177,749 $72,356 $906,265 Type Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Concert Sporting Event Sporting Event Other Event Concert Concert Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Other Event Concert 5559 33 3216 Good 34 3920 Poor 35 3922 Excellent 36 4122 Fair 37 4416 Excellent 38 4422 Fair 39 4520 Good 40 4719 Fair 41 4819 Fair 42 4820 Good 43 4919 Fair 44 5114 Good 45 5119 Fair 46 5125 Fair 47 5218 Fair 48 5223 Good 49 5317 Fair 50 5323 Excellent 51 5425 Good 52 5520 Good 53 5619 Good 54 5620 Good 55 5714 Fair 56 5720 Poor 57 5821 Fair 58 5916 Good 59 5927 Fair 60 6216 Poor 61 6423 Fair 62 6522 Fair 63 6619 Poor 64 6625 Excellent 18903 9074 20498 11573 21249 11257 19235 13275 13378 18449 13725 15710 11382 12437 14828 18468 13952 20051 19744 19205 16309 15234 14435 9173 14906 19484 10847 8675 11434 11306 8830 21934 7511550 $147,632 $34,390 $53,705 $87,608 $170,417 $99,624 $25,006 Ye $157,840 $123,769 $304,190 $63,420 $320,010 $150,394 $181,194 $96,775 $206,423 $216,407 $71,233 $217,426 $127,934 $19,382 $13,512 $44,093 $80,291 $41,946 $61,235 $18,656 $125,241 $46,856 $84,520 $71,102 $117,641 $120,406 $113,011 $120,707 $201,312 $138,405 $154,990 $129,826 $273,863 $62,953 $137,159 $116,845 $117,149 $80,980 $41,737 $71,698 $77,741 $27,551 $37,476 $48,709 $64,105 $31,347 $196,529 $200,502 $63,477 $86,008 $198,932 $82,871 $131,947 $74,321 $62,296 $87,770 $133,578 ۔۔۔۔۔ $504,710 $288,281 $565,335 $213,175 $127,919 $413,132 $483,760 $300,679 $526,424 $126,007 $199,562 $238,321 $195,087 $126,236 $661,625 $378,963 $602,308 $555,012 $560,927 $701,367 $492,043 $609,512 $467,550 $309,680 $498,606 $812,678 $285,276 $339,193 $72,949 $77,785 $175,276 $911,138 CUTTECTE Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Other Event Sporting Event Concert 65 6627 Fair 66 6712 Good 67 6722 Fair 68 6820 Poor 69 6821 Fair 70 6917 Fair 71 7120 Fair 72 7215 Good 73 7216 Good 74 7320 Fair 75 7618 Good 76 7714 Good 77 7821 Fair 78 7822 Good 79 7919 Fair 80 8213 Fair 81 8216 Good 82 8220 Good 83 8221 Poor 84 8223 Good 85 8319 Fair 86 8418 Good 87 8523 Fair 88 8524 Excellent 89 8815 Fair 90 8823 Fair 91 8914 Excellent 92 8916 Good 93 8921 Good 94 9127 Poor 95 9220 Good 96 9421 Fair 97 9423 Good 11879 19774 10582 8627 13029 13004 12217 18696 16938 13861 15925 18782 12453 19820 14174 11515 16560 16116 9469 17639 12817 17723 13497 21799 13596 11375 21663 18469 16811 8414 15448 13303 17784 $95,270 $90,874 $152,655 $137,232 $10,899 $84,339 $25,191 $99,987 $88,467 $112,571 $54,617 $207,804 $57,176 $157,721 $144,707 $288,479 $18,462 $124,325 $25,920 $188,371 $20,225 $102,398 $30,051 $247,735 $60,646 $109,213 $106,235 $121,695 $69,169 $48,593 $129,830 $100,564 $57,761 $56,092 $21,789 $60,967 $91,375 $66,051 $52,073 $43,111 $158,140 $83,665 $125,746 $53,261 $105,973 $64,520 $157.744 $215,445 $75,193 $136,289 $176,309 $114,291 $135,997 $122,787 $97,122 $70,859 $268,346 $183,002 $81,900 $197,567 $197,249 $96,495 $113,673 $189,701 $89,396 $252.355 $149,913 $817,062 $176,931 $352,499 $488,718 $81,145 $538,037 $364,198 $364,675 $426,503 $162,913 $389,727 $462,878 $696,277 $84,335 $70,357 $620,669 $488,798 $181,994 $543,458 $420,526 $97,831 $491,291 $152,811 $525,078 $282,783 $872,152 $472,437 $383,795 $162,306 $194,645 $112,942 $726.832 Other Event Concert Sporting Event Concert Concert Other Event Concert Sporting Event Sporting Event Sporting Event Other Event Sporting Event Concert Sporting Event Other Event Other Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Concert 98 9515 Good 99 9520 Good 100 9717 Poor 101 9720 Poor 102 9818 Fair 103 9922 Poor 19791 18932 9893 8276 11471 8100 $48,290 $67,587 $40,363 $23,504 $71,694 $51,516 $252,929 $286,820 $77,363 $59,835 $163,462 $123,444 $390,872 $112,077 $387,113 $279,067 $166,674 $360,774 Sporting Event Other Event Concert Sporting Event Sporting Event Concert You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games, the Excel Center hosts dozens of events a year. Your company handles all sales inside the arena. There are three major products you sell: programs, food, and merchandise. You have randomly selected sales and attendance data from a number of past events to help build your model. This data can be found on the "Past Events" worksheet. You have classified each event as a "Sporting Event," "Concert," or "Other Event." You have also classified each event by the attendance at that event as "Poor" (less than 10,000 people in attendance), "Fair" (between 10,000 and 15,000 people in attendance), "Good" (between 15,000 and 20,000 people in attendance), or "Excellent" (more than 20,000 people in attendance). Complete the tasks to build each of the PivotTables described. Make sure you create a new Pivot Table when a task asks you to construct a Pivot Table; place that Pivot Table on an appropriately named worksheet. For each question, select the answer from the drop-down list that is closest to the answer you found in your analysis. PivotTable Questions Question 1 - Which type of event ("Concert," "Sporting Event," or "Other Event") has the largest average attendance? Question 2 - For only those events with "Excellent" crowd sizes, how much total merchandise revenue was earned? Question 3 - What percent of events with "Fair" crowd sizes were sporting events? Question 4-What percent of all concerts had a crowd size of "Excellent"? Question 5 - How much more money from food sales has been generated at concerts than at other events, not including sporting events, for events in the sample? - 1 2 3 Event 4 1123 Fair 5 1125 Good 6 1214 Good 7 1217 Fair 8 1322 Good 9 1416 Fair 10 1419 Excellent 11 1621 Fair 12 1713 Good 13 1716 Good 14 1723 Good 15 1919 Good 16 2119 Fair 17 2317 Good 18 2321 Poor 19 2322 Fair 20 2416 Fair 21 2418 Poor 22 2419 Excellent 23 2523 Fair 24 2524 Excellent 25 2527 Fair 26 2615 27 2620 28 2621 29 2919 30 2921 Good 31 2924 Fair 32 3121 Good Crowd Size Excellent Excellent Poor Excellent Randomly Selected Past Events Attendance 11055 19689 16657 11383 15334 12081 20082 10643 18421 18485 17012 16884 14350 15901 8789 13629 13331 8569 21016 13281 21538 12465 20611 20145 8800 20999 15443 10848 19953 Programs Food $28,190 $76,722 $168,538 $113,409 $74,457 $239,861 $32,100 $181,217 $102,584 $70,191 $106,836 $246,808 $39,486 $139,210 $128,947 $223,078 $63,219 $187,992 $35,045 $204,484 $29,040 $128,318 $35,014 $72,181 $34,187 $221,183 $63,544 $131,659 $59,968 $211,250 $95,583 $161,172 $35,047 $106,084 $56,323 $305,362 $23,109 $113,951 $119,536 $79,153 $176,430 $58,018 $30,096 $97,645 $123,390 $67,149 $91,983 $98,598 $68,620 $129,228 $142,101 $166,125 $234,689 $87,032 $223,639 $237,822 $172,483 $265,774 Merchandise $146,037 $499,116 $351,629 $271,826 $618,267 $407,975 $561,292 $448,070 $615,814 $251,396 $137,967 $695,621 $569,552 $244,557 $103,798 $457,253 $419,527 $117,310 $774,860 $454,210 $987,087 $121,160 $581,642 $283,843 $292,336 $893,927 $177,749 $72,356 $906,265 Type Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Concert Sporting Event Sporting Event Other Event Concert Concert Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Other Event Concert 5559 33 3216 Good 34 3920 Poor 35 3922 Excellent 36 4122 Fair 37 4416 Excellent 38 4422 Fair 39 4520 Good 40 4719 Fair 41 4819 Fair 42 4820 Good 43 4919 Fair 44 5114 Good 45 5119 Fair 46 5125 Fair 47 5218 Fair 48 5223 Good 49 5317 Fair 50 5323 Excellent 51 5425 Good 52 5520 Good 53 5619 Good 54 5620 Good 55 5714 Fair 56 5720 Poor 57 5821 Fair 58 5916 Good 59 5927 Fair 60 6216 Poor 61 6423 Fair 62 6522 Fair 63 6619 Poor 64 6625 Excellent 18903 9074 20498 11573 21249 11257 19235 13275 13378 18449 13725 15710 11382 12437 14828 18468 13952 20051 19744 19205 16309 15234 14435 9173 14906 19484 10847 8675 11434 11306 8830 21934 7511550 $147,632 $34,390 $53,705 $87,608 $170,417 $99,624 $25,006 Ye $157,840 $123,769 $304,190 $63,420 $320,010 $150,394 $181,194 $96,775 $206,423 $216,407 $71,233 $217,426 $127,934 $19,382 $13,512 $44,093 $80,291 $41,946 $61,235 $18,656 $125,241 $46,856 $84,520 $71,102 $117,641 $120,406 $113,011 $120,707 $201,312 $138,405 $154,990 $129,826 $273,863 $62,953 $137,159 $116,845 $117,149 $80,980 $41,737 $71,698 $77,741 $27,551 $37,476 $48,709 $64,105 $31,347 $196,529 $200,502 $63,477 $86,008 $198,932 $82,871 $131,947 $74,321 $62,296 $87,770 $133,578 ۔۔۔۔۔ $504,710 $288,281 $565,335 $213,175 $127,919 $413,132 $483,760 $300,679 $526,424 $126,007 $199,562 $238,321 $195,087 $126,236 $661,625 $378,963 $602,308 $555,012 $560,927 $701,367 $492,043 $609,512 $467,550 $309,680 $498,606 $812,678 $285,276 $339,193 $72,949 $77,785 $175,276 $911,138 CUTTECTE Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Other Event Sporting Event Concert 65 6627 Fair 66 6712 Good 67 6722 Fair 68 6820 Poor 69 6821 Fair 70 6917 Fair 71 7120 Fair 72 7215 Good 73 7216 Good 74 7320 Fair 75 7618 Good 76 7714 Good 77 7821 Fair 78 7822 Good 79 7919 Fair 80 8213 Fair 81 8216 Good 82 8220 Good 83 8221 Poor 84 8223 Good 85 8319 Fair 86 8418 Good 87 8523 Fair 88 8524 Excellent 89 8815 Fair 90 8823 Fair 91 8914 Excellent 92 8916 Good 93 8921 Good 94 9127 Poor 95 9220 Good 96 9421 Fair 97 9423 Good 11879 19774 10582 8627 13029 13004 12217 18696 16938 13861 15925 18782 12453 19820 14174 11515 16560 16116 9469 17639 12817 17723 13497 21799 13596 11375 21663 18469 16811 8414 15448 13303 17784 $95,270 $90,874 $152,655 $137,232 $10,899 $84,339 $25,191 $99,987 $88,467 $112,571 $54,617 $207,804 $57,176 $157,721 $144,707 $288,479 $18,462 $124,325 $25,920 $188,371 $20,225 $102,398 $30,051 $247,735 $60,646 $109,213 $106,235 $121,695 $69,169 $48,593 $129,830 $100,564 $57,761 $56,092 $21,789 $60,967 $91,375 $66,051 $52,073 $43,111 $158,140 $83,665 $125,746 $53,261 $105,973 $64,520 $157.744 $215,445 $75,193 $136,289 $176,309 $114,291 $135,997 $122,787 $97,122 $70,859 $268,346 $183,002 $81,900 $197,567 $197,249 $96,495 $113,673 $189,701 $89,396 $252.355 $149,913 $817,062 $176,931 $352,499 $488,718 $81,145 $538,037 $364,198 $364,675 $426,503 $162,913 $389,727 $462,878 $696,277 $84,335 $70,357 $620,669 $488,798 $181,994 $543,458 $420,526 $97,831 $491,291 $152,811 $525,078 $282,783 $872,152 $472,437 $383,795 $162,306 $194,645 $112,942 $726.832 Other Event Concert Sporting Event Concert Concert Other Event Concert Sporting Event Sporting Event Sporting Event Other Event Sporting Event Concert Sporting Event Other Event Other Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Concert 98 9515 Good 99 9520 Good 100 9717 Poor 101 9720 Poor 102 9818 Fair 103 9922 Poor 19791 18932 9893 8276 11471 8100 $48,290 $67,587 $40,363 $23,504 $71,694 $51,516 $252,929 $286,820 $77,363 $59,835 $163,462 $123,444 $390,872 $112,077 $387,113 $279,067 $166,674 $360,774 Sporting Event Other Event Concert Sporting Event Sporting Event Concert
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Assume that five months from today you plan to make the first of several quarterly deposits into an account that pays an APR of 5.5% with monthly compounding. Your first deposit will equal $500, each...
-
You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games,...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Ratio Computation and Analysis; Liquidity) as loan analyst for Madison Bank, you have been presented the following information. Each of these companies has requested a loan of $50,000 for 6 months...
-
The company had 100,000 shares of common stock outstanding on January 1. In addition, as of January 1, the company had issued stock options that allowed employees to purchase 40,000 shares of common...
-
A fan is powered by a 0.5-hp motor and delivers air at a rate of 85 m3/min determine the highest value for the average velocity of air mobilized by the fan. Take the density of air to be 1.18 kg/m3.
-
Suppose there is a stock and a bond governed by the equations It is desired to construct a portfolio of these two securities that gives the maximum expected \(\log\) of return. However, although...
-
Morrison Company owns 80 percent of Bloom Corporations stock, acquired when Blooms fair value as a whole was equal to its book value. The companies frequently engage in intercompany inventory...
-
Identify and discuss either the security features or return policy attached to the buying process on the website of THE BAY company. Please only speak to one of these. Is this clearly outlined during...
-
December 1: , a new investor, made an investment in Byte by purchasing 2,700 shares of its common stock paying $72,900.00 in cash. The par value of the common stock was $19.00 per share. December 3:...
-
In Figure, the three reservoirs A, B, and C are connected by pipes to a common junction. J. Pipe Al is 1000m long and 30 cm in diameter, pipe Bj is 4000m long and 50cm in diameter, and pipe CJ 2000m...
-
Mall Inc. issued a bond for $1,852,480 on October 1, Year 1. The face value of the bond is $2,000,000 and pays annual interest of 4.5%. The bond matures in six years. Mall reports under ASPE and has...
-
Peony Company's maintenance costs are shown below: Total Cost Total Units April $40,000 40,000 May 55,000 60,000 What type of cost is this?
-
Ali put $127.50 each month in a long-term investment account that earned 5.97% for 324 years. How much total interest did he earn?
-
Eliecer is about to begin repairing a mining equipment engine, the task must be done between two specialists, his co-worker went to the bathroom, but he needs to deliver the equipment and they are...
-
What are the costs of supporting e-commerce for a business? Provide high-level categories with cost estimates as high, medium, and low and cost type as variable or fixed.
-
The Babylonians used a system similar to our decimal system to express fractions, except they used base 60, so they would have a sixtieths place instead of a tenths place. This is called a...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
Repeat the analysis in Problem 7 for a private firm that has provided you with the following estimates of operating income for the 10 years, for which you have the macroeconomic data: Operating...
-
You have a project that does not require an initial investment but has its expenses spread over the life of the project. Can the IRR be estimated for this project? Why or why not?
-
Now assume that Gemco Jewelers has $10 million in cash and nonoperating assets and that the firm has $15 million in outstanding debt. a. Estimate the value of equity in the firm. b. If the firm has 5...
-
Show that if two given networks are described by \(Y_{i}=\sum_{j=1}^{M} T_{i j} X_{j}\) and \(Y_{i}^{\prime}=\) \(\sum_{j=1}^{M} T_{i j}^{\prime} X_{j}^{\prime}\), then these networks are...
-
Some FIR filters present a rational transfer function: (a) Show that the transfer function \[H(z)=\frac{\left(r^{-1} z ight)^{-(M+1)}-1}{r e^{\mathrm{j} 2 \pi /(M+1)} z^{-1}-1}\] corresponds to an...
-
Plot the pole-zero constellation as well as the magnitude response of the transfer function of Exercise 4.20 for \(M=6,7,8\) and comment on the results. Exercise 4.20 Some FIR filters present a...
Study smarter with the SolutionInn App