please explain what formula you are using also use screenshots. thanks

PartA: Buckeye Company sells four products and offers quantity discounts to the customers. Buckeye Company wants you to make a worksheet that will allow the salesperson (the user) to input the item and the quantity of the item that the customer wants to purchase. The worksheet will then calculate a price quote that the salesperson can give to the customer. The four products and selling price are as follows: Enter this data in the exact order listed above. The quantity discount is based on the number of the item purchased. The discount rates are as follows: - If the customer wants 1,3 , or 3 , then there is no discount - If the customer wants 4 or 5 , then there is a 7% discount - If the customer wants 6,7,8, or 9 , then there is a 10% discount - If the customer wants 10 or more, then there is a 16% discount The sales tax rate is 10.00% and is calculated on the total price of the order after the discount. The price quote must state the item's Unit Price, total price before the discount, the discount percentage, the dollar amount of the discount, the total price of the order after the discount, the dollar amount of sales tax, and the final price quote. You MUST use VLOOKUP to determine the unit price and the discount rate for the order. You MAY use a number for the col-index-num in VLOOKUP. No data validation is required. Part B: Pioneer Company sells milkshakes. Pioneer Company wants a worksheet that will allow the user to input the flavor and size of the milkshake that they want to purchase. The worksheet will use the user inputs to determine the price of the milkshake. The following table has the price information for each flavor and size of milkshake. The data table must start in cell C8. Enter the data in the exact order shown in the tahle Required: 1. At the top of the worksheet, create user input cells that allow the user to input the flavor and size that they want. a. The input cells must use data validation with In-cell drop down lists so that the user cannot enter invalid data for the flavor or size. 2. To the right of the user input cells, determine the milkshake price based on the user's inputs. Complete each part in a separate cell. Numbers may not be used in these formulas. a. First, determine the milkshake price using INDEX and MATCH in a single formula. b. Second, determine the milkshake price using VLOOKUP and MATCH in a single formula. Note: The single formula statement means that you must determine the ticket price using only one cell. This will require you to nest some functions in the formula. Remember to follow all items in the Excel Requirements document