Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Audits Are Fun Journal Notes Checklists Questions Observations Evidence Log

Authors: Just Visualize It, The Quality Guy

1st Edition

1726628981, 978-1726628983

More Books

Students also viewed these Accounting questions