Section B (40 marks) 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. HEC is an entertainment company that just purchased a hotel, which has a large first-floor area (50,000 square feet in cell B38) that will be devoted to a casino, dining and stage shows. Hotels with casinos attract a variety of guests: Machine players These gamblers play slot machines and poker machines. Game-of-chance players - These gamblers enjoy playing blackjack, roulette, and craps. High rollers - These gamblers play different kinds of card games and bet very large sums of money on each hand. Entertainment-oriented guests These showtime" guests go to the casinos to have dinner, watch a stage show and watch other gamblers gamble! Each type of guest spends money and must be catered for differently. The income generated and the expenses incurred vary by different types of guests. HEC marketing's task is to fill the hotel each day with a mix of guests that will maximize net income. Thus the current problem is to decide the best casino first-floor layout plan so as to maximize the first-floor net profit, which is its goal. This decision problem is tackled in Microsoft Excel spreadsheet using Excel's Solver, and you are required to write Excel formulas and constraints to help with the calculations of this problem - see figure 1. Microsoft Excel's Solver will then calculate the number machine players in cell B3, the number of game-of-chance players in cell B4, the number of high rollers in cell B6, and the number of entertainment-oriented guests in cell B5. File Home Insert Design Layout References Mailings Review View Help Share Comments Each type of gambling guest loses a certain average amount of money per day, and their losses are revenue to the hotel, and the hotel managers call this the base revenue per day. The estimated average base revenue per day of a guest is summarized below: Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Base revenue per day for a guest $200 (cell B24) $300 (cell B25) $100 (cell B26) $5000 (cell B27) 6 | Each type of gambling guest generates a different amount of food and drink revenue. Machine players do not eat very often or very much. Game-of-chance players usually enjoy taking a break to have meals. Entertainment-oriented guests generate the most food and drink revenue because they order expensive wines and entrees. High rollers generate no food and drink revenue because the hotel provides complimentary meals and drinks to entice these big spenders to come to the casino. The estimated average food and drink revenues per day of a guest are summarized below: Type of Guest Machine players Game-of-chance players Food and drink revenue per day for a guest $25 (cell B29) $100 (cell B30) Page 8 of 14 3022 words D Focus DO 1009 File Home Insert Design Layout References Mailings Review View Help Share Comments Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Food and drink revenue per day for a guest $25 (cell B29) $100 (cell B30) $125 (cell B31) $0 (cell B32) Each type of guest generates different kinds of expenses. Some machine players are untidy and extra janitorial staff must be hired to sweep around these guests, but the cost is quite low. Hosting game-of-chance players cost more because usually 5 or 6 game-of-chance players sit a gambling table and a dealer is required to deal, and waiters are required to bring drinks and snacks. Entertainment-oriented guests require a waiter, bus boys and so on. The costs of high rollers are the most because extra security officers must patrol the high-roller area to ensure the safety of these guests. The estimated average expenses per day for a guest are summarized below: Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Expense per day for a guest $1 (cell B34) $40 (cell B35) $10 (cell B36) $500 (cell B37) Each type of guest requires a certain amount of casino floor space. For a machine player, there must be space for the machine and for the player to stand in front of it. A game-of-chance player requires room for a chair and a portion of the areas taken by the table and the dealer's space. An entertainment-oriented guest needs room for a chair and part of a table for eating. High rollers require the most personal space for themselves, their dealer and their privacy. Square footage of a guest per type guest is estimated as below: Type of Guest Square footage needed for a guest Page 8 of 14 3022 words C Focus DO . 100% File Home Insert Design Layout References Mailings Review View Help Share Comments Type of Guest Square footage needed for a guest 6 Machine players Game-of-chance players Entertainment-oriented guests High rollers 15 (cell B9) 30 (cell B10) 10 (cell B11) 100 (cell B12) Different types of guests are stimulated by some types of guests and repulsed by others. This affects a guests propensity to gamble and spend. HEC psychologists have quantified these effects quite precisely. Their observations and rules governing adjustments to revenue by impact of other players are summarized below: Type of Guest Impact of other guests on propensity to spend Machine players Not affected by any other type of guest. They just play! Game-of-chance 1st impact: For each 25 machine players, each game-of-chance player will spend players $5 less on pro rata basis, and 2nd impact: for each 10 high rollers, each game-of-chance player will spend $5 less on pro rata basis. Entertainment-or Dinner guests are distracted by machine players. For each 25 machine players, each entertainment-oriented guest will spend $2 less on dinner on pro rata basis. High rollers 1st impact: These gamblers consider machine players to be amateurs. For each 25 machine players, each high roller will spend $5 less on pro rata basis, and 2nd impact: Some high rollers are energized by game-of-chance players, each high roller spend $10 more for each 25 game-of-chance players on pro rata basis. iented guests 20word rocur BO File Home Insert Design Layout References Mailings Review View Help Share Comments Note: meaning of pro-rata is, if there are 45 machine players, each game-of-chance player will spend (45/25)*$5 = $9 less. The Calculations section of the spreadsheet (see cells A43 to B71) contains intermediate results that will be used in the income statement of the spreadsheet, and/or will be used as constraints. Write Excel formula for the following: The total floor space used for all guests for each type of guest in cells B46 to B49. The total floor space used for all guests of all types in cell B50. The total base revenue earned per day for all guests for each type of guest in cells B52 to B55. The total food and drink revenue per day for all guests for each type of guest in cells B57 to B60. The total expense per day for all guests for each type of guest in cells B62 to B65. The total revenue adjustment for all guests for each type of guest in cells B67 to B70. The total number of guests of all types in cell B71. 6 The "Income Statement" section of the spreadsheet (see cells A73 to B79) contains the net income that the Solver is expected to maximize. Write Excel formula for the following: The total base revenue earned per day for all guests in cell B74. The total food and drink, ravanuo nor day for all muasto in call 075 Page 9 of 14 3022 words D Focus DE . 1009 The "Income Statement section of the spreadsheet (see cells A73 to B79) contains the net income that the Solver is expected to maximize. Write Excel formula for the following: The total base revenue earned per day for all guests in cell B74. The total food and drink revenue per day for all guests in cell B75. The total revenue adjustment for all guests in cell B76. The total revenue in cell B77. The total expense per day for all guests in cell B78. Income earned in cell B79. Constraints section: List all constraints in terms of cell reference positions in Fig. 1. . 1 - Formulate constraints from the following statements made by the city's Fire Marshal: The city's Fire Marshal says that no more than 1850 people (cell B41) can occupy the casino at any one same time. Thus the number of hotel occupants in the casino and those who come in from the street cannot exceed 1850. The hotel can accommodate minimum 1080 guests (cell B42). 2 - Formulate constraints from the following statements made by hotel managers on the use of floor space: Not all first-floor area (that is 50,000 square feet in cell B38) will be devoted to gambling. At one end of the floor, 5000 square feet will be allocated to a buffet dining area (cell B40). At the other end of the floor, 5000 square feet (cell B39) would be devoted to a stage and a sit-down fine-dining area. 3 - Formulate constraints from the following statements made by hotel managers on the number of guests: Hotel management estimates the minimum and maximum number of guests for each tvne of guests ner dav summarized as follows: File Home Home Insert Design Layout References Mailings Review View Help Share Comments 3 - Formulate constraints from the following statements made by hotel managers on the number of guests: Hotel management estimates the minimum and maximum number of guests for each type of guests per day, summarized as follows: Type of Guest Minimum each day Maximum each day Machine players 600 (cell B14) 800 (cell B19) Game-of-chance players 400 (cell B15) 800 (cell B20) Entertainment-oriented guests 300 (cell B16) 800 (cell B21) High rollers 20 (cell B17) 60 (cell B22) Also, a decimal or fractional part of a player of any type is not desired. 6 B 1 Figure 1: A 3 NUMBER OF MACHINE PLAYERS 4 NUMBER OF GAME OF CHANCE PLAYERS 5 NUMBER OF SHOWTIME GUESTS 6 NUMBER OF HIGH ROLLERS 7 CONSTANTS 8 FLOOR SPACE NEEDED: 9 MACHINE PLAYER 10 GAME OF CHANCE PLAYER 11 SHOWTIME GUEST 12 HIGH ROLLER 13 MINIMUM NUMBER OF PLAYERS: 14 MACHINE PLAYER 15 GAME OF CHANCE PLAYER 16 SHOWTIME GUEST 15 30 10 100 600 400 3001 20 File Home Insert Design Layout References Mailings Review View Help Share Comme B 15 30 10 100 600 400 300 20 Figure 1: A 3 NUMBER OF MACHINE PLAYERS 4 NUMBER OF GAME OF CHANCE PLAYERS 5 NUMBER OF SHOWTIME GUESTS 6 NUMBER OF HIGH ROLLERS 7 CONSTANTS 8 FLOOR SPACE NEEDED: 9 MACHINE PLAYER 10 GAME OF CHANCE PLAYER 11 SHOWTIME GUEST 12 HIGH ROLLER 13 MINIMUM NUMBER OF PLAYERS: 14 MACHINE PLAYER 15 GAME OF CHANCE PLAYER 16 SHOWTIME GUEST 17 HIGH ROLLER 18 MAXIMUM NUMBER OF PLAYERS: 19 MACHINE PLAYER 20 GAME OF CHANCE PLAYER 21 SHOWTIME GUEST 22 HIGH ROLLER 23 BASE REVENUE PER DAY 24 MACHINE PLAYER 25 GAME OF CHANCE PLAYER 26 SHOWTIME GUEST 27 HIGH ROLLER 28 FOOD REVENUE PER DAY: 29 MACHINE PLAYER 30 GAME OF CHANCE PLAYER 31 SHOWTIME GUEST 32 HIGH ROLLER 33 DIRECT EXPENSES PER DAY 34 MACHINE PLAYER 35 GAME OF CHANCE PLAYER 36 SHOWTIME GUEST 37 HIGH ROLLER 38 TOTAL 1ST FLOOR SQUARE FOOTAGE 39 STAGE SQUARE FOOTAGE 40 DINING ARE A SQUARE FOOTAGE 41 FIRE MARSHALL LIMIT 42 HOTEL OCCUPANCY 800 800 800 60 200 300 100 5000 25 100 125 0 1 40 10 500 50000 5000 5000 1850 1080 File Home Home Insert Design Layout References Mailings Review View Help Share Comments Figure 1 - continued: B ?? [1 mark ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] A 43 CALCULATIONS 44 SPACE AVAILABLE FOR GUESTS 45 FLOOR SPACE USED: 46 MACHINE PLAYERS 47 GAME OF CHANCE PLAYERS 48 SHOWTIME GUESTS 49 HIGH ROLLERS 50 TOTAL FLOOR SPACE USED FOR GUESTS 51 BASE REVENUE EARNED PER DAY: 52 MACHINE PLAYERS 53 GAME OF CHANCE PLAYERS 54 SHOWTIME GUESTS 55 HIGH ROLLERS 56 FOOD REVENUE EARNED PER DAY: 57 MACHINE PLAYERS 58 GAME OF CHANCE PLAYERS 59 SHOWTIME GUESTS 60 HIGH ROLLERS 61 DIRECT EXPENSES INCURRED PER DAY 62 MACHINE PLAYERS 63 GAME OF CHANCE PLAYERS 64 SHOWTIME GUESTS 65 HIGH ROLLERS 66 REVENUE ADJUSTMENTS: 67 MACHINE PLAYERS 68 GAME OF CHANCE PLAYERS 69 SHOWTIME GUESTS 70 HIGH ROLLERS 71 TOTAL NUMBER OF GUESTS 72 73 INCOME STATEMENT 74 TOTAL BASE REVENUE 75 FOOD REVENUE 76 REVENUE ADJUSTMENTS 77 TOTAL REVENUE 78 DIRECT EXPENSES 79 INCOME EARNED ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [3 marks] ?? [3 marks] ?? [3 marks] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] Section B (40 marks) 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. HEC is an entertainment company that just purchased a hotel, which has a large first-floor area (50,000 square feet in cell B38) that will be devoted to a casino, dining and stage shows. Hotels with casinos attract a variety of guests: Machine players These gamblers play slot machines and poker machines. Game-of-chance players - These gamblers enjoy playing blackjack, roulette, and craps. High rollers - These gamblers play different kinds of card games and bet very large sums of money on each hand. Entertainment-oriented guests These showtime" guests go to the casinos to have dinner, watch a stage show and watch other gamblers gamble! Each type of guest spends money and must be catered for differently. The income generated and the expenses incurred vary by different types of guests. HEC marketing's task is to fill the hotel each day with a mix of guests that will maximize net income. Thus the current problem is to decide the best casino first-floor layout plan so as to maximize the first-floor net profit, which is its goal. This decision problem is tackled in Microsoft Excel spreadsheet using Excel's Solver, and you are required to write Excel formulas and constraints to help with the calculations of this problem - see figure 1. Microsoft Excel's Solver will then calculate the number machine players in cell B3, the number of game-of-chance players in cell B4, the number of high rollers in cell B6, and the number of entertainment-oriented guests in cell B5. File Home Insert Design Layout References Mailings Review View Help Share Comments Each type of gambling guest loses a certain average amount of money per day, and their losses are revenue to the hotel, and the hotel managers call this the base revenue per day. The estimated average base revenue per day of a guest is summarized below: Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Base revenue per day for a guest $200 (cell B24) $300 (cell B25) $100 (cell B26) $5000 (cell B27) 6 | Each type of gambling guest generates a different amount of food and drink revenue. Machine players do not eat very often or very much. Game-of-chance players usually enjoy taking a break to have meals. Entertainment-oriented guests generate the most food and drink revenue because they order expensive wines and entrees. High rollers generate no food and drink revenue because the hotel provides complimentary meals and drinks to entice these big spenders to come to the casino. The estimated average food and drink revenues per day of a guest are summarized below: Type of Guest Machine players Game-of-chance players Food and drink revenue per day for a guest $25 (cell B29) $100 (cell B30) Page 8 of 14 3022 words D Focus DO 1009 File Home Insert Design Layout References Mailings Review View Help Share Comments Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Food and drink revenue per day for a guest $25 (cell B29) $100 (cell B30) $125 (cell B31) $0 (cell B32) Each type of guest generates different kinds of expenses. Some machine players are untidy and extra janitorial staff must be hired to sweep around these guests, but the cost is quite low. Hosting game-of-chance players cost more because usually 5 or 6 game-of-chance players sit a gambling table and a dealer is required to deal, and waiters are required to bring drinks and snacks. Entertainment-oriented guests require a waiter, bus boys and so on. The costs of high rollers are the most because extra security officers must patrol the high-roller area to ensure the safety of these guests. The estimated average expenses per day for a guest are summarized below: Type of Guest Machine players Game-of-chance players Entertainment-oriented guests High rollers Expense per day for a guest $1 (cell B34) $40 (cell B35) $10 (cell B36) $500 (cell B37) Each type of guest requires a certain amount of casino floor space. For a machine player, there must be space for the machine and for the player to stand in front of it. A game-of-chance player requires room for a chair and a portion of the areas taken by the table and the dealer's space. An entertainment-oriented guest needs room for a chair and part of a table for eating. High rollers require the most personal space for themselves, their dealer and their privacy. Square footage of a guest per type guest is estimated as below: Type of Guest Square footage needed for a guest Page 8 of 14 3022 words C Focus DO . 100% File Home Insert Design Layout References Mailings Review View Help Share Comments Type of Guest Square footage needed for a guest 6 Machine players Game-of-chance players Entertainment-oriented guests High rollers 15 (cell B9) 30 (cell B10) 10 (cell B11) 100 (cell B12) Different types of guests are stimulated by some types of guests and repulsed by others. This affects a guests propensity to gamble and spend. HEC psychologists have quantified these effects quite precisely. Their observations and rules governing adjustments to revenue by impact of other players are summarized below: Type of Guest Impact of other guests on propensity to spend Machine players Not affected by any other type of guest. They just play! Game-of-chance 1st impact: For each 25 machine players, each game-of-chance player will spend players $5 less on pro rata basis, and 2nd impact: for each 10 high rollers, each game-of-chance player will spend $5 less on pro rata basis. Entertainment-or Dinner guests are distracted by machine players. For each 25 machine players, each entertainment-oriented guest will spend $2 less on dinner on pro rata basis. High rollers 1st impact: These gamblers consider machine players to be amateurs. For each 25 machine players, each high roller will spend $5 less on pro rata basis, and 2nd impact: Some high rollers are energized by game-of-chance players, each high roller spend $10 more for each 25 game-of-chance players on pro rata basis. iented guests 20word rocur BO File Home Insert Design Layout References Mailings Review View Help Share Comments Note: meaning of pro-rata is, if there are 45 machine players, each game-of-chance player will spend (45/25)*$5 = $9 less. The Calculations section of the spreadsheet (see cells A43 to B71) contains intermediate results that will be used in the income statement of the spreadsheet, and/or will be used as constraints. Write Excel formula for the following: The total floor space used for all guests for each type of guest in cells B46 to B49. The total floor space used for all guests of all types in cell B50. The total base revenue earned per day for all guests for each type of guest in cells B52 to B55. The total food and drink revenue per day for all guests for each type of guest in cells B57 to B60. The total expense per day for all guests for each type of guest in cells B62 to B65. The total revenue adjustment for all guests for each type of guest in cells B67 to B70. The total number of guests of all types in cell B71. 6 The "Income Statement" section of the spreadsheet (see cells A73 to B79) contains the net income that the Solver is expected to maximize. Write Excel formula for the following: The total base revenue earned per day for all guests in cell B74. The total food and drink, ravanuo nor day for all muasto in call 075 Page 9 of 14 3022 words D Focus DE . 1009 The "Income Statement section of the spreadsheet (see cells A73 to B79) contains the net income that the Solver is expected to maximize. Write Excel formula for the following: The total base revenue earned per day for all guests in cell B74. The total food and drink revenue per day for all guests in cell B75. The total revenue adjustment for all guests in cell B76. The total revenue in cell B77. The total expense per day for all guests in cell B78. Income earned in cell B79. Constraints section: List all constraints in terms of cell reference positions in Fig. 1. . 1 - Formulate constraints from the following statements made by the city's Fire Marshal: The city's Fire Marshal says that no more than 1850 people (cell B41) can occupy the casino at any one same time. Thus the number of hotel occupants in the casino and those who come in from the street cannot exceed 1850. The hotel can accommodate minimum 1080 guests (cell B42). 2 - Formulate constraints from the following statements made by hotel managers on the use of floor space: Not all first-floor area (that is 50,000 square feet in cell B38) will be devoted to gambling. At one end of the floor, 5000 square feet will be allocated to a buffet dining area (cell B40). At the other end of the floor, 5000 square feet (cell B39) would be devoted to a stage and a sit-down fine-dining area. 3 - Formulate constraints from the following statements made by hotel managers on the number of guests: Hotel management estimates the minimum and maximum number of guests for each tvne of guests ner dav summarized as follows: File Home Home Insert Design Layout References Mailings Review View Help Share Comments 3 - Formulate constraints from the following statements made by hotel managers on the number of guests: Hotel management estimates the minimum and maximum number of guests for each type of guests per day, summarized as follows: Type of Guest Minimum each day Maximum each day Machine players 600 (cell B14) 800 (cell B19) Game-of-chance players 400 (cell B15) 800 (cell B20) Entertainment-oriented guests 300 (cell B16) 800 (cell B21) High rollers 20 (cell B17) 60 (cell B22) Also, a decimal or fractional part of a player of any type is not desired. 6 B 1 Figure 1: A 3 NUMBER OF MACHINE PLAYERS 4 NUMBER OF GAME OF CHANCE PLAYERS 5 NUMBER OF SHOWTIME GUESTS 6 NUMBER OF HIGH ROLLERS 7 CONSTANTS 8 FLOOR SPACE NEEDED: 9 MACHINE PLAYER 10 GAME OF CHANCE PLAYER 11 SHOWTIME GUEST 12 HIGH ROLLER 13 MINIMUM NUMBER OF PLAYERS: 14 MACHINE PLAYER 15 GAME OF CHANCE PLAYER 16 SHOWTIME GUEST 15 30 10 100 600 400 3001 20 File Home Insert Design Layout References Mailings Review View Help Share Comme B 15 30 10 100 600 400 300 20 Figure 1: A 3 NUMBER OF MACHINE PLAYERS 4 NUMBER OF GAME OF CHANCE PLAYERS 5 NUMBER OF SHOWTIME GUESTS 6 NUMBER OF HIGH ROLLERS 7 CONSTANTS 8 FLOOR SPACE NEEDED: 9 MACHINE PLAYER 10 GAME OF CHANCE PLAYER 11 SHOWTIME GUEST 12 HIGH ROLLER 13 MINIMUM NUMBER OF PLAYERS: 14 MACHINE PLAYER 15 GAME OF CHANCE PLAYER 16 SHOWTIME GUEST 17 HIGH ROLLER 18 MAXIMUM NUMBER OF PLAYERS: 19 MACHINE PLAYER 20 GAME OF CHANCE PLAYER 21 SHOWTIME GUEST 22 HIGH ROLLER 23 BASE REVENUE PER DAY 24 MACHINE PLAYER 25 GAME OF CHANCE PLAYER 26 SHOWTIME GUEST 27 HIGH ROLLER 28 FOOD REVENUE PER DAY: 29 MACHINE PLAYER 30 GAME OF CHANCE PLAYER 31 SHOWTIME GUEST 32 HIGH ROLLER 33 DIRECT EXPENSES PER DAY 34 MACHINE PLAYER 35 GAME OF CHANCE PLAYER 36 SHOWTIME GUEST 37 HIGH ROLLER 38 TOTAL 1ST FLOOR SQUARE FOOTAGE 39 STAGE SQUARE FOOTAGE 40 DINING ARE A SQUARE FOOTAGE 41 FIRE MARSHALL LIMIT 42 HOTEL OCCUPANCY 800 800 800 60 200 300 100 5000 25 100 125 0 1 40 10 500 50000 5000 5000 1850 1080 File Home Home Insert Design Layout References Mailings Review View Help Share Comments Figure 1 - continued: B ?? [1 mark ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] A 43 CALCULATIONS 44 SPACE AVAILABLE FOR GUESTS 45 FLOOR SPACE USED: 46 MACHINE PLAYERS 47 GAME OF CHANCE PLAYERS 48 SHOWTIME GUESTS 49 HIGH ROLLERS 50 TOTAL FLOOR SPACE USED FOR GUESTS 51 BASE REVENUE EARNED PER DAY: 52 MACHINE PLAYERS 53 GAME OF CHANCE PLAYERS 54 SHOWTIME GUESTS 55 HIGH ROLLERS 56 FOOD REVENUE EARNED PER DAY: 57 MACHINE PLAYERS 58 GAME OF CHANCE PLAYERS 59 SHOWTIME GUESTS 60 HIGH ROLLERS 61 DIRECT EXPENSES INCURRED PER DAY 62 MACHINE PLAYERS 63 GAME OF CHANCE PLAYERS 64 SHOWTIME GUESTS 65 HIGH ROLLERS 66 REVENUE ADJUSTMENTS: 67 MACHINE PLAYERS 68 GAME OF CHANCE PLAYERS 69 SHOWTIME GUESTS 70 HIGH ROLLERS 71 TOTAL NUMBER OF GUESTS 72 73 INCOME STATEMENT 74 TOTAL BASE REVENUE 75 FOOD REVENUE 76 REVENUE ADJUSTMENTS 77 TOTAL REVENUE 78 DIRECT EXPENSES 79 INCOME EARNED ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [3 marks] ?? [3 marks] ?? [3 marks] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark] ?? [1 mark]