I need help with tasks 10-14. The equations needed

4. 3 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). 5 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). 6 3 7 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). Calculate Loyalty Cash Applied in cell F25. If the customer wishes to use loyalty cash (cell L14 of the model inputs), loyalty cash applied is equal to the total loyalty cash available if the transaction total exceeds the loyalty cash available. If the loyalty cash available exceeds the transaction total, then the loyalty cash applied is equal to the transaction total. Loyalty cash applied is zero if the customer does not wish to use the loyalty cash. For this task, reference the transaction total in cell F24 rather than the value you calculated in cell F21. 8 8 9 3 10 4 Calculate the Balance After Loyalty Cash in cell F26. The balance after loyalty case is the difference between the transaction total (Cell F24) and any loyalty cash applied (cell F25). Calculate the Cash Discount in cell F27. A customer carns a 2% discount if their payment method is cash. Calculate the Total Due from Customer in cell F29. The total due from customer is the balance after loyalty cash (cell F26) minus any cash discount cell 11 3 F27). 12 N. 13 2 Input the Beginning Loyalty Cash in cell F32 by referencing the loyalty cash available in the model inputs. Calculate the Loyalty Cash Earned in cell F34. Loyalty cash earned is equal to 1% of the balance after loyalty cash (cell F26). Calculate the Ending Loyalty Cash in cell F35. The ending loyalty cash balance is equal to the beginning loyalty cash balance minus any loyalty cash used on the transaction (cell F33) plus any loyalty cash earned (cell F34) on the transaction. Notice that the value in cell F33 is calculated for you by referencing your earlier calculation in cell F25. 14 4 Total: 50 Pricing Howard would like to systematically analyze the marketing of the most popular combination kit that QuickStove sells for $30. He has conducted some market research and believes that the current demand for the kit is.5000 units per wear OuickStove has a.comnetitor that MacBook Pro