Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, please help, it's urgent. Thank you :) (this is all the information provided, literally all the details) Write the Excel formula for each cell
Hi, please help, it's urgent. Thank you :) (this is all the information provided, literally all the details)
Write the Excel formula for each cell marked with "?? in column B of figure 1, and label each formula clearly. List all the constraints in terms of the cell positions in figure 1. A construction company has been contracted by a major league football team to build a new football stadium with a car parking lot. The team's current stadium was built for both baseball and football, and it has an enclosed oval shape, with seating around the entire circumference. Football crowds can fill the stadium to full capacity, but baseball games only fill the stadium to 70% of the total capacity. Thus the new stadium will be for football games only. It is decided that the new stadium will be U-shaped, like a horseshoe. Seating would be all around the U, but there would be no seat at the open end. The construction engineers have calculated the length around the U (leaving out the open end part) as 1375 feet, and plan to build 100 rows of seats that extend back and up from the playing field. In fact, the geometry of the stadium is such that the row closest to the playing field (1st row) is shorter in length than the row farthest from the playing field (100th row). However, some of those rows are broken by equipments, exits, and concessions. Thus to simplify calculations for this study, you can assume that each of the 100 rows in the new stadium is 1375 feet in length. The construction engineers plan to install four kinds of seats: . . Box seats are the rows of seats closest to the playing field and are usually considered the most desirable and expensive. Red seats are the rows of seats in the next level up. Blue seats are the rows of seats in the level above the red seats. Yellow seats are the farthest rows up and away from the playing field, and they are the least desirable and cheapest. . The construction company needs to know the optimal number of seats for each type of seats to build in the new football stadium so that the total revenue would be maximized in the forecast plan, which is done in a Microsoft Excel spreadsheet using Excel's Solver. You are required to quantify the financial impacts of different stadium construction alternatives by writing Excel formulae and constraints to help with the calculations of this problem - see the spreadsheet (in figure 1 below). Microsoft Excel's Solver will calculate the number of seats to be built in cells B4 to B7 (changing cells) for each kind of seat. A B 1 3 CHANGING CELLS: 4 NUMBER OF BOX ROWS 5 NUMBER OF RED ROWS 6 NUMBER OF BLUE ROWS 7 NUMBER OF YELLOW ROWS 1 11 B 9 CONSTANTS: 10 NUMBER OF FEET IN A ROW 11 WIDTH PER SEAT: BOX 12 WIDTH PER SEAT: RED 13 WIDTH PER SEAT: BLUE 14 WIDTH PER SEAT: YELLOW 15 NUMBER OF ROWS 16 PRICE PER TICKET: BOX 17 PRICE PER TICKET: RED 18 PRICE PER TICKET: BLUE 19 PRICE PER TICKET: YELLOW 20 Avg. Expenditures on Souvenirs & Food per seat per game: BOX 21 Avg. Expenditures on Souvenirs & Food per seat per game: RED 22 Avg. Expenditures on Souvenirs & Food per seat per game: BLUE 23 Avg. Expenditures on Souvenirs & Food per seat per game: YELLOW 24 MIN # ROWS: BOX 25 MIN # ROWS: RED 26 MIN #ROWS: BLUE 27 MIN # ROWS: YELLOW 28 MAX # ROWS:BOX 29 MAX # ROWS:REDS 30 MAX # ROWS:BLUE 31 MAX # ROWS:YELLOW 32 NUMBER OF PEOPLE PER CAR:BOX 33 NUMBER OF PEOPLE PER CAR:RED 34 NUMBER OF PEOPLE PER CAR:BLUE 35 NUMBER OF PEOPLE PER CAR:YELLOW 36 MIN ATTENDANCE 37 MAX ATTENDANCE 38 NUMBER OF PARKING PLACES 1375 3.5 13.25 3 2.75 100 150 35 25 20 30 25 15 10 10 10 10 10 30 40 40 50 12 3 3 5 44000 46000 15000 Figure 1 B A 41 CALCULATIONS: 42 NUMBER OF SEATS PER ROW-BOX 43 NUMBER OF SEATS PER ROW-RED 44 NUMBER OF SEATS PER ROW-BLUE 45 NUMBER OF SEATS PER ROW-YELLOW 46 NUMBER OF BOX SEATS 47 NUMBER OF RED SEATS 48 NUMBER OF BLUE SEATS 49 NUMBER OF YELLOW SEATS 50 TOTAL NUMBER OF SEATS 51 NUMBER OF CARS - BOX 52 NUMBER OF CARS - RED 53 NUMBER OF CARS - BLUE 54 NUMBER OF CARS - YELLOW 55 TOTAL NUMBER OF CARS 56 TOTAL NUMBER OF ROWS 57 NUMBER OF RED + BLUE SEATS ?? (1.5 marks) ?? (1.5 marks ?? (1.5 marks) ?? (1.5 marks) |?? (1 mark] ?? (1 mark] ?? (1 mark] ?? (1 mark] ?? (1 mark] 17? (1.5 marks) ?? (1.5 marks ?? (1.5 marks) ?? (1.5 marks) ?? (1 mark] ?? (1 mark] ?? [1 mark] B 61 REVENUE: 62 TICKET SALES: BOX 63 TICKET SALES: RED 64. TICKET SALES: BLUE 65 TICKET SALES: YELLOW 66 TOTAL TICKET REVENUE 67 REVENUE FROM SOUVENIR & FOOD SALES: BOX 68 REVENUE FROM SOUVENIR & FOOD SALES: RED 69 REVENUE FROM SOUVENIR & FOOD SALES: BLUE 70 REVENUE FROM SOUVENIR & FOOD SALES:YELLOW 71 TOTAL REVENUE FROM SOUVENIR & FOOD SALES: 72 TOTAL REVENUE ?? [1 mark] ?? (1 mark ?? [1 mark) ?? [1 mark] |?? (1 mark] 22 (1.5 marks) 22 (1.5 marks) 22 (1.5 marks) ?? (1.5 marks] ?? (1 mark] 172 [1 mark] Figure 1 - continued . . The "Constants" section of the spreadsheet (see cells A9 to cells B38) contains the following data: The average length of a row of scats is 1375 feet (cell B10). The total number of rows in the stadium is 100 (cell B15). Major football league rules state that the stadium must have a minimum number of 44000 scats (cell B36). The team management has set a maximum of 46000 (cell B37) for the total number of seats. The scat types differ by more than just paint colour and their positions in the stadium. The most expensive seats will be the widest and therefore, the most comfortable. The least expensive seats will be the narrowest and therefore, the least comfortable. This means the number of seats in a Box seat row will be fewer than the number of seats in a Red seat row and so on. The width of seats and the admission ticket price for each scat type are shown in below table: . Seat Type Box scat Red seat Blue scat Yellow scat Seat Width (in feet) 3.5 (cell B11) 3.25 (cell B12) 3 (cell B13) 2.75 (cell B14) Price(s) per admission ticket 50 (cell B16) 35 (cell B17) 25 (cell B18) 20 (cell B19) People who come to watch ballgames usually buy souvenirs and food. In fact, many fans spend more money on food and souvenirs than they do on their admission tickets. The team's research department has determined that there is a correlation between where fans sit and how much they spend on souvenirs and food. The table below shows the average expenditures by cach seat type per game: Seat Type Average expenditures on souvenirs and food per seat per game 4 Box scat 30 (cell B20) Red scat 25 (cell B21) Blue seat 15 (cell B22) Yellow seat 10 (cell B23) . The new stadium will need a parking lot that can accommodate 15000 cars (cell B38). The team's researchers have studied how fans get to the stadium. They have found that the less-affluent fans are more likely to use public transportation rather than drive a car to the game. Their research reveals the following averages: For every 2 fans sitting in Box seats (cell B32), 1 car arrives at the stadium. For every 3 fans sitting in Red seats (cell B33), 1 car arrives at the stadium. For every 3 fans sitting in Blue seats (cell B34), 1 car arrives at the stadium. For every 5 fans sitting in Yellow seats (cell B35), 1 car arrives at the stadium. The team management would like a balance among the different seating types. The minimum and maximum number of rows for each kind of seat is shown in below table: Seat Type Minimum number of rows Maximum number of rows Box seat 10 (cell B24) 30 (cell B28) Red seat 10 (cell B25) 40 (cell B29) Blue seat 10 (cell B26) 40 (cell B30) Yellow seat 10 (cell B27) 50 (cell B31) The "Calculations" section of the spreadsheet (see cell A41 to cell B72) contains immediate results that will be used in the income statement of the spreadsheet, and/or will be used as constraints. Write Excel formulae for the following: Number of seats per row for each seat type - Box, Red, Blue, Yellow (cells B42 to cell B45) is a function of the length of the row and of the width of seats in each row. Since a fraction of a seat can't be built, the number of seats per row for each scat type must be a whole number, thus leaving some spare space in cach row of seats. Total number of seats in each seat type - Box, Red, Blue, Yellow (cells B46 to B49) is a function of the number of seats per row for each seat type and the number of rows for each seat type. The total number of seats for all seat types (cell B50) in the stadium. The number of cars arriving at the stadium for a match for each seat type - Box, Red. Blue. Yellow (cells B51 to B54) is the function of the number of fans per . . car for cach seat type and the number of seats for each seat type. Since a fraction of a car does not exist, the number of cars for each seat type must be a whole number, thus leaving some spare space in the parking lot. Total number of cars arriving at the stadium for a match for all seat types (cell B55). Total number of rows to be installed in the stadium (cell B56). Total number of rows to be installed for Red and Blue seats (cell B57). . . . The "Revenue" section of the spreadsheet (sec cell A6l to cell B72) contains the "total revenue" that the Solver is expected to maximize. Write Excel formulae for the following: Total ticket sales revenue for each scat type - Box, Red, Blue, Yellow (cells B62 to B65) is a function of the ticket price for each scat and the number of seats for each seat type. Total revenue from all tickets of all seat types (cell B66). Total revenue gained from selling food and souvenirs for each seat type - Box, Red, Blue, Yellow (cell B67 to B70). Total revenue gained from selling food and souvenirs for all seat types (cell B71). Total revenue from ticket sales and from selling food and souvenirs for all seat types (cell B72). . . . The team management's goal is to maximize the total revenue subject to various constraints, with the assumption that all seats' admission tickets will be sold for each match. Formulate constraints from the following statements that are made by the team's management: The total number of rows in the stadium must be 100 (cell B15). Major football league rules state that the stadium must have a minimum number of 44000 seats (cell B36). However, team management wants the stadium to appear intimate", so it is decided that the stadium should not be able to seat more than 46000 fans (cell B37). The team management does not want the new stadium to have a massive "cheap seats" area. Thus it is decided that the number of rows of Red seats plus the number of rows of Blue seats combined, must be greater than or equal to the number of rows of Yellow seats. For the car parking lot, it is decided that more space should be allocated to the seating area, and thus the car parking lot should accommodate at most 15,000 cars (cell B38). The team management would also like a balance among the different seating types. The minimum and maximum number of rows for each kind of seat are shown in below table: Seat Type Minimum number of rows Maximum number of rows 6 Box scat Red seat Blue seat Yellow seat 10 (cell B24) 10 (cell B25) 10 (cell B26) 10 (cell B27) 30 (cell B28) 40 (cell B29) 40 (cell B30) 50 (cell B31) Finally, fractional part for the number of rows for each seat type is not allowed, as this is an integer problem. CHANGING CELLS: NUMBER OF BOX ROWS NUMBER OF RED ROWS NUMBER OF BLUE ROWS NUMBER OF YELLOW ROWS 1375 3.50 3.25 3.00 2.75 100 50 CONSTANTS: NUMBER OF FEET IN A ROW WIDTH PER SEAT: BOX WIDTH PER SEAT: RED WIDTH PER SEAT: BLUE WIDTH PER SEAT: YELLOW NUMBER OF ROWS PRICE PER TICKET BOX PRICE PER TICKET: RED PRICE PER TICKET: BLUE PRICE PER TICKET: YELLOW Avg Expenditures on Souvenirs & Food per seat per game: BOX Avg. Expenditures on Souvenirs & Food per seat per game: RED Avg. Expenditures on Souvenirs & Food per seat per game: BLUE Avg. Expenditures on Souvenirs & Food per seat per game: YELLOW MIN #ROWS: BOX MIN #ROWS: RED 35 25 20 30 25 15 10 10 10 10 10 30 40 40 50 MIN #ROWS: BLUE MIN #ROWS: YELLOW MAX # ROWS:BOX MAX #ROWS:REDS MAX # ROWS:BLUE MAX # ROWS:YELLOW NUMBER OF PEOPLE PER CAR.BOX NUMBER OF PEOPLE PER CAR:RED NUMBER OF PEOPLE PER CAR:BLUE NUMBER OF PEOPLE PER CAR:YELLOW MIN ATTENDANCE MAX ATTENDANCE NUMBER OF PARKING PLACES 2 3 3 5 44000 46000 15000 CALCULATIONS: NUMBER OF SEATS PER ROW-BOX NUMBER OF SEATS PER ROW-RED NUMBER OF SEATS PER ROW-BLUE NUMBER OF SEATS PER ROW-YELLOW NUMBER OF BOX SEATS NUMBER OF RED SEATS NUMBER OF BLUE SEATS NUMBER OF YELLOW SEATS TOTAL NUMBER OF SEATS NUMBER OF CARS - BOX NUMBER OF CARS - RED NUMBER OF CARS - BLUE NUMBER OF CARS - YELLOW TOTAL NUMBER OF CARS TOTAL NUMBER OF ROWS NUMBER OF RED + BLUE SEATS REVENUE: TICKET SALES: BOX TICKET SALES: RED TICKET SALES: BLUE TICKET SALES: YELLOW TOTAL TICKET REVENUE REVENUE FROM SOUVENIR & FOOD SALES: BOX REVENUE FROM JVENIR & FOOD SALES: RED REVENUE FROM SOUVENIR & FOOD SALES: BLUE REVENUE FROM SOUVENIR & FOOD SALES:YELLOW TOTAL REVENUE FROM SOUVENIR & FOOD SALES: TOTAL REVENUE CamScanner Write the Excel formula for each cell marked with "?? in column B of figure 1, and label each formula clearly. List all the constraints in terms of the cell positions in figure 1. A construction company has been contracted by a major league football team to build a new football stadium with a car parking lot. The team's current stadium was built for both baseball and football, and it has an enclosed oval shape, with seating around the entire circumference. Football crowds can fill the stadium to full capacity, but baseball games only fill the stadium to 70% of the total capacity. Thus the new stadium will be for football games only. It is decided that the new stadium will be U-shaped, like a horseshoe. Seating would be all around the U, but there would be no seat at the open end. The construction engineers have calculated the length around the U (leaving out the open end part) as 1375 feet, and plan to build 100 rows of seats that extend back and up from the playing field. In fact, the geometry of the stadium is such that the row closest to the playing field (1st row) is shorter in length than the row farthest from the playing field (100th row). However, some of those rows are broken by equipments, exits, and concessions. Thus to simplify calculations for this study, you can assume that each of the 100 rows in the new stadium is 1375 feet in length. The construction engineers plan to install four kinds of seats: . . Box seats are the rows of seats closest to the playing field and are usually considered the most desirable and expensive. Red seats are the rows of seats in the next level up. Blue seats are the rows of seats in the level above the red seats. Yellow seats are the farthest rows up and away from the playing field, and they are the least desirable and cheapest. . The construction company needs to know the optimal number of seats for each type of seats to build in the new football stadium so that the total revenue would be maximized in the forecast plan, which is done in a Microsoft Excel spreadsheet using Excel's Solver. You are required to quantify the financial impacts of different stadium construction alternatives by writing Excel formulae and constraints to help with the calculations of this problem - see the spreadsheet (in figure 1 below). Microsoft Excel's Solver will calculate the number of seats to be built in cells B4 to B7 (changing cells) for each kind of seat. A B 1 3 CHANGING CELLS: 4 NUMBER OF BOX ROWS 5 NUMBER OF RED ROWS 6 NUMBER OF BLUE ROWS 7 NUMBER OF YELLOW ROWS 1 11 B 9 CONSTANTS: 10 NUMBER OF FEET IN A ROW 11 WIDTH PER SEAT: BOX 12 WIDTH PER SEAT: RED 13 WIDTH PER SEAT: BLUE 14 WIDTH PER SEAT: YELLOW 15 NUMBER OF ROWS 16 PRICE PER TICKET: BOX 17 PRICE PER TICKET: RED 18 PRICE PER TICKET: BLUE 19 PRICE PER TICKET: YELLOW 20 Avg. Expenditures on Souvenirs & Food per seat per game: BOX 21 Avg. Expenditures on Souvenirs & Food per seat per game: RED 22 Avg. Expenditures on Souvenirs & Food per seat per game: BLUE 23 Avg. Expenditures on Souvenirs & Food per seat per game: YELLOW 24 MIN # ROWS: BOX 25 MIN # ROWS: RED 26 MIN #ROWS: BLUE 27 MIN # ROWS: YELLOW 28 MAX # ROWS:BOX 29 MAX # ROWS:REDS 30 MAX # ROWS:BLUE 31 MAX # ROWS:YELLOW 32 NUMBER OF PEOPLE PER CAR:BOX 33 NUMBER OF PEOPLE PER CAR:RED 34 NUMBER OF PEOPLE PER CAR:BLUE 35 NUMBER OF PEOPLE PER CAR:YELLOW 36 MIN ATTENDANCE 37 MAX ATTENDANCE 38 NUMBER OF PARKING PLACES 1375 3.5 13.25 3 2.75 100 150 35 25 20 30 25 15 10 10 10 10 10 30 40 40 50 12 3 3 5 44000 46000 15000 Figure 1 B A 41 CALCULATIONS: 42 NUMBER OF SEATS PER ROW-BOX 43 NUMBER OF SEATS PER ROW-RED 44 NUMBER OF SEATS PER ROW-BLUE 45 NUMBER OF SEATS PER ROW-YELLOW 46 NUMBER OF BOX SEATS 47 NUMBER OF RED SEATS 48 NUMBER OF BLUE SEATS 49 NUMBER OF YELLOW SEATS 50 TOTAL NUMBER OF SEATS 51 NUMBER OF CARS - BOX 52 NUMBER OF CARS - RED 53 NUMBER OF CARS - BLUE 54 NUMBER OF CARS - YELLOW 55 TOTAL NUMBER OF CARS 56 TOTAL NUMBER OF ROWS 57 NUMBER OF RED + BLUE SEATS ?? (1.5 marks) ?? (1.5 marks ?? (1.5 marks) ?? (1.5 marks) |?? (1 mark] ?? (1 mark] ?? (1 mark] ?? (1 mark] ?? (1 mark] 17? (1.5 marks) ?? (1.5 marks ?? (1.5 marks) ?? (1.5 marks) ?? (1 mark] ?? (1 mark] ?? [1 mark] B 61 REVENUE: 62 TICKET SALES: BOX 63 TICKET SALES: RED 64. TICKET SALES: BLUE 65 TICKET SALES: YELLOW 66 TOTAL TICKET REVENUE 67 REVENUE FROM SOUVENIR & FOOD SALES: BOX 68 REVENUE FROM SOUVENIR & FOOD SALES: RED 69 REVENUE FROM SOUVENIR & FOOD SALES: BLUE 70 REVENUE FROM SOUVENIR & FOOD SALES:YELLOW 71 TOTAL REVENUE FROM SOUVENIR & FOOD SALES: 72 TOTAL REVENUE ?? [1 mark] ?? (1 mark ?? [1 mark) ?? [1 mark] |?? (1 mark] 22 (1.5 marks) 22 (1.5 marks) 22 (1.5 marks) ?? (1.5 marks] ?? (1 mark] 172 [1 mark] Figure 1 - continued . . The "Constants" section of the spreadsheet (see cells A9 to cells B38) contains the following data: The average length of a row of scats is 1375 feet (cell B10). The total number of rows in the stadium is 100 (cell B15). Major football league rules state that the stadium must have a minimum number of 44000 scats (cell B36). The team management has set a maximum of 46000 (cell B37) for the total number of seats. The scat types differ by more than just paint colour and their positions in the stadium. The most expensive seats will be the widest and therefore, the most comfortable. The least expensive seats will be the narrowest and therefore, the least comfortable. This means the number of seats in a Box seat row will be fewer than the number of seats in a Red seat row and so on. The width of seats and the admission ticket price for each scat type are shown in below table: . Seat Type Box scat Red seat Blue scat Yellow scat Seat Width (in feet) 3.5 (cell B11) 3.25 (cell B12) 3 (cell B13) 2.75 (cell B14) Price(s) per admission ticket 50 (cell B16) 35 (cell B17) 25 (cell B18) 20 (cell B19) People who come to watch ballgames usually buy souvenirs and food. In fact, many fans spend more money on food and souvenirs than they do on their admission tickets. The team's research department has determined that there is a correlation between where fans sit and how much they spend on souvenirs and food. The table below shows the average expenditures by cach seat type per game: Seat Type Average expenditures on souvenirs and food per seat per game 4 Box scat 30 (cell B20) Red scat 25 (cell B21) Blue seat 15 (cell B22) Yellow seat 10 (cell B23) . The new stadium will need a parking lot that can accommodate 15000 cars (cell B38). The team's researchers have studied how fans get to the stadium. They have found that the less-affluent fans are more likely to use public transportation rather than drive a car to the game. Their research reveals the following averages: For every 2 fans sitting in Box seats (cell B32), 1 car arrives at the stadium. For every 3 fans sitting in Red seats (cell B33), 1 car arrives at the stadium. For every 3 fans sitting in Blue seats (cell B34), 1 car arrives at the stadium. For every 5 fans sitting in Yellow seats (cell B35), 1 car arrives at the stadium. The team management would like a balance among the different seating types. The minimum and maximum number of rows for each kind of seat is shown in below table: Seat Type Minimum number of rows Maximum number of rows Box seat 10 (cell B24) 30 (cell B28) Red seat 10 (cell B25) 40 (cell B29) Blue seat 10 (cell B26) 40 (cell B30) Yellow seat 10 (cell B27) 50 (cell B31) The "Calculations" section of the spreadsheet (see cell A41 to cell B72) contains immediate results that will be used in the income statement of the spreadsheet, and/or will be used as constraints. Write Excel formulae for the following: Number of seats per row for each seat type - Box, Red, Blue, Yellow (cells B42 to cell B45) is a function of the length of the row and of the width of seats in each row. Since a fraction of a seat can't be built, the number of seats per row for each scat type must be a whole number, thus leaving some spare space in cach row of seats. Total number of seats in each seat type - Box, Red, Blue, Yellow (cells B46 to B49) is a function of the number of seats per row for each seat type and the number of rows for each seat type. The total number of seats for all seat types (cell B50) in the stadium. The number of cars arriving at the stadium for a match for each seat type - Box, Red. Blue. Yellow (cells B51 to B54) is the function of the number of fans per . . car for cach seat type and the number of seats for each seat type. Since a fraction of a car does not exist, the number of cars for each seat type must be a whole number, thus leaving some spare space in the parking lot. Total number of cars arriving at the stadium for a match for all seat types (cell B55). Total number of rows to be installed in the stadium (cell B56). Total number of rows to be installed for Red and Blue seats (cell B57). . . . The "Revenue" section of the spreadsheet (sec cell A6l to cell B72) contains the "total revenue" that the Solver is expected to maximize. Write Excel formulae for the following: Total ticket sales revenue for each scat type - Box, Red, Blue, Yellow (cells B62 to B65) is a function of the ticket price for each scat and the number of seats for each seat type. Total revenue from all tickets of all seat types (cell B66). Total revenue gained from selling food and souvenirs for each seat type - Box, Red, Blue, Yellow (cell B67 to B70). Total revenue gained from selling food and souvenirs for all seat types (cell B71). Total revenue from ticket sales and from selling food and souvenirs for all seat types (cell B72). . . . The team management's goal is to maximize the total revenue subject to various constraints, with the assumption that all seats' admission tickets will be sold for each match. Formulate constraints from the following statements that are made by the team's management: The total number of rows in the stadium must be 100 (cell B15). Major football league rules state that the stadium must have a minimum number of 44000 seats (cell B36). However, team management wants the stadium to appear intimate", so it is decided that the stadium should not be able to seat more than 46000 fans (cell B37). The team management does not want the new stadium to have a massive "cheap seats" area. Thus it is decided that the number of rows of Red seats plus the number of rows of Blue seats combined, must be greater than or equal to the number of rows of Yellow seats. For the car parking lot, it is decided that more space should be allocated to the seating area, and thus the car parking lot should accommodate at most 15,000 cars (cell B38). The team management would also like a balance among the different seating types. The minimum and maximum number of rows for each kind of seat are shown in below table: Seat Type Minimum number of rows Maximum number of rows 6 Box scat Red seat Blue seat Yellow seat 10 (cell B24) 10 (cell B25) 10 (cell B26) 10 (cell B27) 30 (cell B28) 40 (cell B29) 40 (cell B30) 50 (cell B31) Finally, fractional part for the number of rows for each seat type is not allowed, as this is an integer problem. CHANGING CELLS: NUMBER OF BOX ROWS NUMBER OF RED ROWS NUMBER OF BLUE ROWS NUMBER OF YELLOW ROWS 1375 3.50 3.25 3.00 2.75 100 50 CONSTANTS: NUMBER OF FEET IN A ROW WIDTH PER SEAT: BOX WIDTH PER SEAT: RED WIDTH PER SEAT: BLUE WIDTH PER SEAT: YELLOW NUMBER OF ROWS PRICE PER TICKET BOX PRICE PER TICKET: RED PRICE PER TICKET: BLUE PRICE PER TICKET: YELLOW Avg Expenditures on Souvenirs & Food per seat per game: BOX Avg. Expenditures on Souvenirs & Food per seat per game: RED Avg. Expenditures on Souvenirs & Food per seat per game: BLUE Avg. Expenditures on Souvenirs & Food per seat per game: YELLOW MIN #ROWS: BOX MIN #ROWS: RED 35 25 20 30 25 15 10 10 10 10 10 30 40 40 50 MIN #ROWS: BLUE MIN #ROWS: YELLOW MAX # ROWS:BOX MAX #ROWS:REDS MAX # ROWS:BLUE MAX # ROWS:YELLOW NUMBER OF PEOPLE PER CAR.BOX NUMBER OF PEOPLE PER CAR:RED NUMBER OF PEOPLE PER CAR:BLUE NUMBER OF PEOPLE PER CAR:YELLOW MIN ATTENDANCE MAX ATTENDANCE NUMBER OF PARKING PLACES 2 3 3 5 44000 46000 15000 CALCULATIONS: NUMBER OF SEATS PER ROW-BOX NUMBER OF SEATS PER ROW-RED NUMBER OF SEATS PER ROW-BLUE NUMBER OF SEATS PER ROW-YELLOW NUMBER OF BOX SEATS NUMBER OF RED SEATS NUMBER OF BLUE SEATS NUMBER OF YELLOW SEATS TOTAL NUMBER OF SEATS NUMBER OF CARS - BOX NUMBER OF CARS - RED NUMBER OF CARS - BLUE NUMBER OF CARS - YELLOW TOTAL NUMBER OF CARS TOTAL NUMBER OF ROWS NUMBER OF RED + BLUE SEATS REVENUE: TICKET SALES: BOX TICKET SALES: RED TICKET SALES: BLUE TICKET SALES: YELLOW TOTAL TICKET REVENUE REVENUE FROM SOUVENIR & FOOD SALES: BOX REVENUE FROM JVENIR & FOOD SALES: RED REVENUE FROM SOUVENIR & FOOD SALES: BLUE REVENUE FROM SOUVENIR & FOOD SALES:YELLOW TOTAL REVENUE FROM SOUVENIR & FOOD SALES: TOTAL REVENUE CamScannerStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started