Please solve using excel sheet cell formulas. Thank you.

Input the number of items purchased in cell F13 by referencing the appropriate cell in the model inputs. Input the total price of items purchased in cell F14 by referencing the appropriate cell in the model inputs. Calculate the Loyalty Discount % in cell F16. Notice that the discount rates depend both on the loyalty status of the customer (gold or silver) and the total price of the items purchased (cell F14). Construct your formula so that it will correctly calculate the loyalty percentage regardless of the Loyalty Status and Total Price of Items in the Model Inputs. Calculate the Loyalty Discount $ in cell F17. The loyalty discount $ is the total price of the items purchased (cell F14) times the loyalty discount percent (cell F16). Calculate the Discounted Subtotal in cell F19. The discounted subtotal is the difference between the total price of the items purchased (cell F14) and the loyalty discount $ (cell F17). Calculate the Sales Tax for the transaction in cell F20. The sales tax is the discounted subtotal (cell F19) times the sales tax rate in the model inputs. Calculate the Transaction Total in cell F21. The transaction total is the sum of the discounted subtotal (cell F19) and the sales tax (cell F20). Howard has implemented a customer loyalty program to increase sales. This program has two elements. First, a customer is entitled to a discount for each transaction. The discount amount depends on their loyalty status (silver or gold) and the amount of the transaction. The details of the loyalty programare included in the inputs section of the Receipt worksheet Second, a customer earns loyalty cash that can be applied toward a purchase. A customer earns So 01 for every dollar they spend. The customer loyalty program has made calculating the amount of money owed for a given transaction difficult to calculate Complete the Calculations section of the worksheet to determine the transaction totals, any discounts the customer carns, if loyalty cash is used toward the transaction, and the remaining loyalty cash balance for the customer. Notice that this information is summarized in the Customer Receipt. The customer receipt is already completed for you Calculations Customer Receipt Quicktove, uc 2/16/2022 19:15 Model Inputs Transaction Information Items Purchased Total Price of items $175.23 Sales Tax Rate 6.75% Customer information Loyatly Status Silver Loyalty Cash Available $16.54 Use Loyalty Cash? Yes Payment Method Cashi $17523 Sale Summary of items Purchased Item Total Sales Tax Transaction Total 3 517523 $0.00 $175.23 Sale Worksheet Number of Items Purchased Total Price of Items Loyalty Discount Loyalty Discounts Discounted Subtotal Sales Tax Transaction Total Discounts and Credits Applied Loyalty Discount 50.00 Cash Discount $0.00 Loyatly Cash Applied $0.00 Payment Applied $0.00 Discounts and Payments $0.00 Loyalty Program Discount Rates Silver Gold Sale Total Discount Sale Total O 2x 0 50 3% 25 100 4X 50 200 SX 100 200 Discount 2% 3% 4% 5% 10% Payment Worksheet Transaction Total $175.23 Loyalty Cash Applied Balance After Loyalty Cash Cash Discount Total Due from Customer Loyalty Car Remaining 50.00 Thank you for shoging of Quick Stave! Credit Worksheet Beginning Loyalty Cash Loyalty Cash Used Loyalty Cath Earned Ending Loyalty Cash $0.00 A D Calculations Customer Receipt Quicktove, LLC 2/16/2022 19:15 H Model Inputs Transaction Information w Items Purchased Total Price of Items 517523 Sales Tax Rate 6.75% 3 $175.23 Customer Information Loyatly Status Silver Loyalty Cash Available 514.54 Use Loyalty Cash Yes Payment Method Cash Sale Summary it of items Purchased Item Total Sales Tax Transaction Total 3 $175.23 $0.00 $175.23 10 11 17 1 14 15 16 17 18 12 20 21 22 23 24 25 26 27 20 29 30 11 Sale Worksheet Number of items Purchased Total Price of Items Loyalty Discount Loyalty Discounts Discounted Subtotal Sales Tax Transaction Total Discounts and Credits Applied Loyalty Discount 50.00 Cash Discount S0.00 Loyatly Cash Applied $0.00 Payment Applied $0.00 Discounts and Payments 50.00 Loyalty Program Discount Rates Silver Gold Sale Total Discount Sale Total 0 2% 0 50 3% 25 100 4% SO 200 5% 100 200 Discount 2% 3% 49 5 10% Payment Worksheet Transaction Total $175.23 Loyalty Cash Applied Balance Alter Loyalty Cash Cash Discount Loyalty Cash Remaining 50.00 Thank you for shopping at Quick Stovel Total Due from Customer Credit Worksheet Beginning Loyalty Cash Loyalty Cash Used Loyalty Cash Earned Ending Loyalty Cash 33 34 35 S0.00