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. [4 points]

The following cost data pertain to the operations of montgomery department stores, inc., for the month of july. corporate legal office salaries $ 75,300apparel department cost of sales"evendale store $ 97,200corporate headquarters building lease $ 50,300store manager's salary"evendale store $ 12,900apparel department sales commission"evendale store $ 11,550store utilities"evendale store $ 12,800apparel department manager's salary"evendale store $ 10,450central warehouse lease cost $ 18,600janitorial costs"evendale store $ 11,800 the evendale store is just one of many stores owned and operated by the company. the apparel department is one of many departments at the evendale store. the central warehouse serves all of the company's stores. required: 1. what is the total amount of the costs listed above that are direct costs of the apparel department? 2. what is the total amount of the costs listed above that are direct costs of the evendale store? 3. what is the total amount of the apparel department's direct costs that are also variable costs with respect to total departmental sales?