Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and standard deviation summarized as follows (in $1,000s): Monday TuesdayWednesday Thursday FridaySaturdaySunday Mean S175 $120 $90 S60 $120 $140 $65 Std Dev $ 26 S 18 $13 $ 18 $ 21 $9 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. Keeping excessive cash reserves would guard against this situation. However, cash is a noninterest earning asset, so there is an opportunity cost for holding excess cash reserves. a. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $825,000. Create a spreadsheet model to track the daily cash balance throughout the week. b. What is the probability that the bank will run out of money at some point during the week? c. What amount of money is needed at the start each week to ensure there is at most a 0.10% chance of running out of money? Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and standard deviation summarized as follows (in $1,000s): Monday TuesdayWednesday Thursday FridaySaturdaySunday Mean S175 $120 $90 S60 $120 $140 $65 Std Dev $ 26 S 18 $13 $ 18 $ 21 $9 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. Keeping excessive cash reserves would guard against this situation. However, cash is a noninterest earning asset, so there is an opportunity cost for holding excess cash reserves. a. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $825,000. Create a spreadsheet model to track the daily cash balance throughout the week. b. What is the probability that the bank will run out of money at some point during the week? c. What amount of money is needed at the start each week to ensure there is at most a 0.10% chance of running out of money?
Expert Answer:
Related Book For
Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics
ISBN: 978-1305947412
8th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these mathematics questions
-
Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and...
-
The daily demand for pizzas is Qd = 750 - 25P, where P is the price of a pizza. The daily costs for a pizza company initially include $50 in fixed costs (which are avoidable in the long run but sunk...
-
The daily demand for pizzas is Qd = 750 - 25P, where P is the price of a pizza. The daily costs for a pizza company initially include $50 in fixed costs (which are avoidable in the long run but sunk...
-
From the following facts, calculate the correct cost of inventory for Sue Company. Cost of inventory on shelf, $4,500, which includes $280 of goods received on consignment. Goods in transit en...
-
Multiple-Choice Questions 1. In which case is a plaintiff most likely to sue based on strict liability? (a) Defamation. (b) Injury caused on the job. (c) Injury caused by a tiger that escapes from a...
-
8. A CFO is proposing that her company goes to the debt market to issue a new bond, because current interest rates are low. In particular, the CFO can use the proceeds of the bond issuance to...
-
What are common-size financial statements and how are they used?
-
Wendy Dwyer established Outlaw Computer Services on January 1, 2011. The effect of each transaction and the balances after each transaction for January are shown below in the integrated financial...
-
SCM Case Analysis: Forecasting and Planning you will research a selected company and develop a case study analysis. All operational activities begin with an estimate of what customer demands will be....
-
A firm is analyzing their pricing and operations for next year based on the following anticipated cost structure, the given level of production and sales, and their target operating income margin of...
-
Explain Mean, Median, Mode, Variance & Standard Deviation in brief.
-
At January 1, 2024, Caf Med leased restaurant equipment from Crescent Corporation under a nine-year lease agreement. The lease agreement specifies annual payments of $31,000 beginning January 1,...
-
On July 1 of Year 1, West Company purchased for cash, eight $10,000 bonds of North Corporation to yield 10%. The bonds pay 9% interest, payable on a semiannual basis each July 1 and January 1, and...
-
An elevator is accelerating in the y direction (i.e. j) at 2.27 m/s^2. A 35 kg block is attached to a spring scale that is attached to the ceiling of the elevator. What is the reading on the scale in...
-
Prater Incorporated enters into an exchange in which it gives up its warehouse on 10 acres of land and receives a tract of land. A summary of the exchange is as follows: Transferred Warehouse Land...
-
K(s-2) (s-3) Find the jw-crossing for the negative unity feedback system where G(s) = s(s+2) (s+3) Fill in the a value:
-
Which one of the following statements is true? Question 10 options: As the number of facilities decrease, the fixed costs increase and the outbound freight costs decrease. As the number of facilities...
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
Sanderson Manufacturing produces ornate, decorative wood frame doors and windows. Each item produced goes through 3 manufacturing processes: cutting, sanding, and finishing. Each door produced...
-
Use Solver to create a Sensitivity Report for question 15 at the end of chapter 3 and answer the following questions. a. Is the solution degenerate? b. Is the solution unique? c. Suppose the profit...
-
In the CRT Technologies project selection example in this chapter, the problem indicates that surplus funds in any year are reappropriated and cannot be carried over to the next year. Suppose that...
-
Barium sulfide is produced by reacting barium sulfate ore with coal. The result is barium black ash, which is \(\mathrm{BaS}\) plus insoluble solids. Since \(\mathrm{BaS}\) is soluble in water, it...
-
Batch leaching is similar to batch extraction, and the equations developed in Section 13.6 can be adapted when the solution is dilute or there is an insoluble solid matrix. We have \(12.5...
-
Repeat Problem 14.D14 except the feed has \(4.5 \mathrm{~kg}\) liquid \(/ \mathrm{kg}\) solids. Problem 14.D14 Barium sulfide is produced by reacting barium sulfate ore with coal. The result is...
Study smarter with the SolutionInn App