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 ofthe transaction The details of the loyalty program are 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 $001 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 earns, if loyalty cash is used toward the transaction, and the remaining loyalty cash balance for the customers Notice that this information is summarized In the Customer Receipts The customer receipt is already completed for you. Customer Recelpt Quicktove. u.c 2/13/20 13:15 Sale Summary :4 of Items Purchased item Total Sales Tax Transaction Total Discouns and Credits Applied Loyalty Discount Cash Discount Loyatly (Lash Applied Payment Applied Dlscoums and Payments Loyalty Cash Remaining Thank you for shopping at auicldtove! Receipt Ready Calculatlons Sale Worksheet Number of Items Purchased Total Price of Items Loyalty Discount 96 Loyalty Discount 5 Discounted Subtotal Sales Tax Tra nsaction Total Payment Worksheet Transaction Total Loyalty Cash Applied Balance After Loyalty Cash Cash Discount Total Due from Customer Credit Worksheet Beginning Loyalty Cash Loyalty Gish Used Loyalty Cash Earned Ending Loyalty Cash Model Inputs Transaction Information Customer Information 3: items Purchased 3 Lmtly Status Silver Total Price of Items $175.25 Loyalty Cash Available $14.54 Sales Tax Rate 6.75% Use Loyalty Cash? Ves Payment Method Cash Loyalty Program Discount Rates Silver Sale Total 0 50 100 200 517523 + 100%