I NEED HELP WITH QUESTIONS 18-22. I don't understand How to set up the formulas. I will upvote and promote it! Problems are attached and Excel Spreadsheets show What information is needed to answer questions. THANK YOU SO MUCH!
The Activities worksheet displays a ligs of activities offered by CVRCC. Cell range J4:339 shows the average weekly castomer participation in the activities. Ibe manager of CVRCC would like to classify the sctivities as entber Extremely Popular, Very Popular, 5omenbat. Pupular or Not Pupular depending ua the value of Ave_Weekly_Particpolions. Use a VLOOKTP fimcton in cell K4 to classty the actrutty. Bctore cotering the VLOOKUT formula in oil K4, you must crcate the lookup table (i.e., the table_anay). The top left conner of the data for the table_anny nuat be in cell K33 on the Activities worksheet. Place appropriate labels for the table_antay in cells RZ and SZ of the Activities sbeet. ussigument. The tebile 15 mot set up correctiv. You must reairramge it Cogy the VLCOKUP formula in oull K4 to oell range K5:K39. The classifications (Extremely Popular, Very popular, Somewhat Popular and Not Popudar must be spelied and capatalized correctly. Place a formila in coll 04 of the Activities ahect that dieplays the Activity_ID for the activity deacription that appears in cell 03 . The formula should be able to find the Activity. W for any valid description entered in cell O3. Use the INDEX and MATCH functions to do this. Nest the fornula inside an IFERROR flencticn. If the description of an Activity that is sot on the fiomd. (Note: Orily the A in Activity should be captitalzed. Do not irclisde a penad at the and ) Cogy the formula from 04 to oell range O5.013 so that the Catogory, Type, start_Time, Nunber_of_Hours, Restrictions. Cost_pes_Adult, Cost_Pe__Chadd, Ane_Weekly_Participation and Popularity are displayed for the description in cell 03. Nose: Do NOT wa a lookug. fizction for are part of thes step, The ruamager of CVRCC would like to know what tolal Rooen. Revenue is for the DBL-Sute in bulding BMT. and tha DRL.Stite in hailding SRL. Enter a foxtulala in cell R.2 of tha Database sheet that 1199 a DATABASE function to colculnte this totsl. IJe the datn on the Rescrvation_Analysis ahoct. You must complete the criterio rango in colls A1.03 of the Database sheet before entering the formula. Format the value as currency. The mannger of CVRCC. would like to know the total mumber of transanstions imvolving n rexsards member who has a coupon and strys more than 5 rights. Enter a formula in cell R7 of the Database abset that uaes a DATABASE function to calculate this total. U3s the data on the Reservation_Analysis aheet. You must complete the criteria range in cel's A6.O7 of the Database sheet before entering the formula. The manager of CVRCC is considering adding throe daluxe tours to the activitics offered by the resort. The manager would like to know how inany castomers must go on esch tour in order to maximize total net income from the tours. Go to the Tours wodksheet. which is used to calculate revenues, expenses, and net income for each tous. Use 5olver to masimize total net mecene (cell I18). Use the number of custorners on each tour (range DS.T5) as the charigig varable cells. Enter the comstramils based ve the motornabon provided me the table below. Use GRGG Noolinear ns the golving methot to find a nglobal optimal solution. Save the Solver model in cell H21. Solve the model, kocp the Solver solution and produce an Answer Report. Ihe name of the alseet cotstaining the Answar Report nust be Answer Repont 1 . The Activities worksheet displays a ligs of activities offered by CVRCC. Cell range J4:339 shows the average weekly castomer participation in the activities. Ibe manager of CVRCC would like to classify the sctivities as entber Extremely Popular, Very Popular, 5omenbat. Pupular or Not Pupular depending ua the value of Ave_Weekly_Particpolions. Use a VLOOKTP fimcton in cell K4 to classty the actrutty. Bctore cotering the VLOOKUT formula in oil K4, you must crcate the lookup table (i.e., the table_anay). The top left conner of the data for the table_anny nuat be in cell K33 on the Activities worksheet. Place appropriate labels for the table_antay in cells RZ and SZ of the Activities sbeet. ussigument. The tebile 15 mot set up correctiv. You must reairramge it Cogy the VLCOKUP formula in oull K4 to oell range K5:K39. The classifications (Extremely Popular, Very popular, Somewhat Popular and Not Popudar must be spelied and capatalized correctly. Place a formila in coll 04 of the Activities ahect that dieplays the Activity_ID for the activity deacription that appears in cell 03 . The formula should be able to find the Activity. W for any valid description entered in cell O3. Use the INDEX and MATCH functions to do this. Nest the fornula inside an IFERROR flencticn. If the description of an Activity that is sot on the fiomd. (Note: Orily the A in Activity should be captitalzed. Do not irclisde a penad at the and ) Cogy the formula from 04 to oell range O5.013 so that the Catogory, Type, start_Time, Nunber_of_Hours, Restrictions. Cost_pes_Adult, Cost_Pe__Chadd, Ane_Weekly_Participation and Popularity are displayed for the description in cell 03. Nose: Do NOT wa a lookug. fizction for are part of thes step, The ruamager of CVRCC would like to know what tolal Rooen. Revenue is for the DBL-Sute in bulding BMT. and tha DRL.Stite in hailding SRL. Enter a foxtulala in cell R.2 of tha Database sheet that 1199 a DATABASE function to colculnte this totsl. IJe the datn on the Rescrvation_Analysis ahoct. You must complete the criterio rango in colls A1.03 of the Database sheet before entering the formula. Format the value as currency. The mannger of CVRCC. would like to know the total mumber of transanstions imvolving n rexsards member who has a coupon and strys more than 5 rights. Enter a formula in cell R7 of the Database abset that uaes a DATABASE function to calculate this total. U3s the data on the Reservation_Analysis aheet. You must complete the criteria range in cel's A6.O7 of the Database sheet before entering the formula. The manager of CVRCC is considering adding throe daluxe tours to the activitics offered by the resort. The manager would like to know how inany castomers must go on esch tour in order to maximize total net income from the tours. Go to the Tours wodksheet. which is used to calculate revenues, expenses, and net income for each tous. Use 5olver to masimize total net mecene (cell I18). Use the number of custorners on each tour (range DS.T5) as the charigig varable cells. Enter the comstramils based ve the motornabon provided me the table below. Use GRGG Noolinear ns the golving methot to find a nglobal optimal solution. Save the Solver model in cell H21. Solve the model, kocp the Solver solution and produce an Answer Report. Ihe name of the alseet cotstaining the Answar Report nust be Answer Repont 1
