208 Chapter Seven Chapter 7 Homework Exercises Directions: Please read all of the questions as well as the accompanying materi- als prior to answering the prior to answering the questions. Answer question 1 and 3 in Excel. Question 2 and 4 can be answered in a word processing program. 1. Jordan Moore, the budget manager for the City of Henderson, has requested that you assist him with the management of the cities' funds. Specifically, he wants you to calculate the two scenarios listed below based on the following information. This problem can be completed in a spreadsheet or in a word pro- cessing package. See Appendix 7B. a. The city has total cash payments of $15 million (T) for a 6- month period. Assume that the payment over this period is steady. The cost per transaction is $65 (b), the interest rate is nd the cost per dollar of fund ferred 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 b. The city has total cash payments of $13 million (T) for a 6- month period. Assume that the payment over this period is steady. The cost per transaction is $55 (b), the interest rate is 5% for the period (i), and the cost per dollar of funds trans- ferred is .04% (v). Calculate the optimal initial cash balance and transfer size Average cash balance The number of transfers The total cost of cash management e a life-cycle cost analysis for the procurement of a front end loader for f Henderson based on data from three companies. Also, the city is the old front-end loader. Note that the Trade in and Resale Value pe subtracted from the amount of the life-cycle cost. All calculations be rounded to the nearest dollar amount. Solve for the energy cost prior alculating the life-cycle cost. When you finish your calculations, indicate nich of the bids should be accepted. Briefly explain your response. See Ap- pendix 7C for a copy of the spreadsheet 208 Chapter Seven Chapter 7 Homework Exercises Directions: Please read all of the questions as well as the accompanying materi- als prior to answering the prior to answering the questions. Answer question 1 and 3 in Excel. Question 2 and 4 can be answered in a word processing program. 1. Jordan Moore, the budget manager for the City of Henderson, has requested that you assist him with the management of the cities' funds. Specifically, he wants you to calculate the two scenarios listed below based on the following information. This problem can be completed in a spreadsheet or in a word pro- cessing package. See Appendix 7B. a. The city has total cash payments of $15 million (T) for a 6- month period. Assume that the payment over this period is steady. The cost per transaction is $65 (b), the interest rate is nd the cost per dollar of fund ferred 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 b. The city has total cash payments of $13 million (T) for a 6- month period. Assume that the payment over this period is steady. The cost per transaction is $55 (b), the interest rate is 5% for the period (i), and the cost per dollar of funds trans- ferred is .04% (v). Calculate the optimal initial cash balance and transfer size Average cash balance The number of transfers The total cost of cash management e a life-cycle cost analysis for the procurement of a front end loader for f Henderson based on data from three companies. Also, the city is the old front-end loader. Note that the Trade in and Resale Value pe subtracted from the amount of the life-cycle cost. All calculations be rounded to the nearest dollar amount. Solve for the energy cost prior alculating the life-cycle cost. When you finish your calculations, indicate nich of the bids should be accepted. Briefly explain your response. See Ap- pendix 7C for a copy of the spreadsheet