Fill out T,B,I,V, &C with formulas or just the number

(2) The budget manager for Jefferson City, has requested that you assist her with the management of the city's funds. Specifically, she wants you to calculate the two scenarios listed below based on the following information. See appendix 7A. (a) The city has total cash payments of $20 million (T) for a 6-month period. Assume that the payment over this period is steady. The cost per transaction is $60 (b), the interest rate is 3 percent for the period (i), and the cost per dollar of funds transferred is .05% (V). Calculate the optimal initial cash balance and transfer size Average cash balance The number of transfers The total cost of cash management 2. #DIV/0! TE b= = V 2. Calculate the Optimal Initial Cash Balance and 3. Transfer Sice 4 5 6 7 Average Cash Balance 8 9 Total Number of Transfers 10 11 Calculate the Total Cost of Cash Management 12 #DIV/0! CE #DIV/0! 1 #DIV/0! 1