Requirements 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 calculat…
Requirements
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. Total after cashback = total – cashback amount 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 will be deducted if it is poorly commented.Image transcription text40 Points Possible Quantity Price Extended Price (Quantity x Price) Membership cashback % Cashback amount| Total after
cashback Setup Section Membership Level Gold Platinum ) Black None Minimum purchase for cashback Encouragement
Threshold CalcTotal Cashback% 1% 2% 3% 0% 5.00 10.00 <--enter an integer <--enter a currency <--calc... Show more... Show more
OR