40 Points PossibleQuantity0<--enter an integerPrice0<--enter a currencyExtended Price (Quantity x Price)$0.00 <--calculate in your VBA codeMembership Gold<--Select from this dropdowncashback %0%<--Your code should fill this inCashback amount$0.00 <--calculate this in VBATotal after cashback$0.00 <--calculate this in VBASetup SectionMembership LevelCashback%Gold1%Platinum2%Black3%None0%Minimum purchase for cashback$ 5.00 Encouragement Threshold$ 10.00 Save before running!
!RequirementsCreate a Sub, run by the button at the bottom of the page, that calculates the cashback for any purchase. This business gives cashback based on a customers membership level, which is calculated as follows:cashback amount = extended price * cashback% The cashback% is listed in the setup section for each of the three membership levels. The user will enter the quantity, price, and select the membership level from the dropdown that is already built for you in cell B7. The code will determine, calculate, and fill in the highlighted cells. Cashback is earned only if the extended price meets or exceeds the minimum purchase for cashback. If the cashback amount meets or exceeds the encouragement threshold, display a message box encouraging the customer to make the purchase. Assume the values in the setup section can change (i.e., don't hard code numbers that could change). Assign the macro to the button. Comment your code so that it is easy for a grader to follow. Points may be deducted if there are no comments.
85 Points PossibleSummary Statistics TableTotalAverageTotalName of DateLisaLocationQuantityRatingRevenueLocationProvoOremQuantity3ProvoRevenue$972 SpringvilleRating0Grand Totals^ Sum ^^ Ave ^^ Sum ^Name of DateRodLocationpRovo<-- Make sure to handle this miscapitalizationQuantity5in your code without changing the text.Revenue$2,160 Rating4There are three possible misspelled citiesProvo, Orem, and Springville.Name of DateMaggieLocationProvi<-- They meant Provo here; but don't changeQuantity6the spelling. Make your code handle it.Revenue$2,160 Rating1<-- Notice the several blank rows here. Use code to account for multiple blank rows.Name of DateCarlLocationOremQuantity5Revenue$2,700 Rating4Name of DateHomerLocationProvoQuantity4Revenue$1,728 Rating1Name of DateOttoLocationOremQuantity3RequirementsCreate a sub ('Bikes"), run by the button, that generates a sentence outpuaverages in the table to the right of the data. Don't forget to handle the cat least the left three characters are spelled correctly. Also assume there removed at the bottom, and assume there may be more than one blank rare formatted exactly as shown in the examples (including a period), andsummary sentences need to be are shown to the right of where your outso that a grader can follow it. Points may be deducted if there are no comHINT: If you can't finish you will have a better shot at partial credit if you code (pseudo code) as well.
Revenue$1,404 Rating5Name of DateHomerLocationProvoQuantity7Revenue$3,528 Rating1