Reference no: EM131115033
The following data were recently collected by the cash manager at RAYCO Department stores, Inc.
Day Dolar Deposits
Monday $1,500
Tuesday $2,000
Wednesday $1,000
Thursday $10,000
Friday $25,000
Saturday $35,000
Sunday $10,000
These daily deposits are typical of RAYCO's ten regional stores. RAYCO is headquartered in Oklahoma city and concentrates cash from the ten local deposit banks to its concentration bank in Oklahoma city. You may assume that RAYCO's opportunity investment rate is 10 percent, the ECR is 8 percent and the reserve requirement is 12 percent. Further assume that RAYCO uses EDT's to concentrate the cash balances and that the EDT's is initiated on the day of deposit and clears the next day. Deposits are made before the daily ledger cut off time. Also half of each deposit is cash and half is in checks with one day availability. Finally assume that no bank clearing activity is conducted on the weekends and the beginning ledger and collected balance for the first week are equal to zero.
Create or write the formulas in the spreadsheet and show your work at arriving at your solutions
a) Assuming that the deposit schedule is typical of each week, create two weeks of deposits and transfer clearing activity .
b) Calculate the average collected balance at the typical deposit bank.
c) Assuming that each EDT costs $1.00, calculate the dollar amount of collected balances required to compensate the deposit bank
d) What is the total cost of the cash concentration system for one bank for one week?
e) Can you suggest any improvements in RAYCO's cash concentration system?
|
Identify any issue that may occur if manager lacks integrity
: Please provide a 1-page reflection paper on why you feel integrity is an important value for a manager to have. Give an example of how a manager with integrity can help a team. Identify any issues that may occur if a manager lacks integrity.
|
|
What allowed the fraud to happen
: Your ethical interpretation of the case parameters is in accordance with the rules of accounting will meet the core value of Integrity - What allowed the fraud to happen.
|
|
What is the service mix and what is the payer mix
: What is the service mix? What is the payer mix? If a low percentage of a facility's cases are paid by DRG, the coding manager may want to establish different productivity standards for different payers
|
|
Calculate the speed of the motor when the armature current
: The armature-circuit resistance is 0.25 Ω and the series-field resistance is 0.25 ?4. Calculate the speed of the motor
|
|
Calculate average collected balance at typical deposit bank
: These daily deposits are typical of RAYCO's ten regional stores. RAYCO is headquartered in Oklahoma city and concentrates cash from the ten local deposit banks to its concentration bank in Oklahoma city. Calculate the average collected balance at the..
|
|
Carry out a chi-square test
: Carry out a Chi-Square test to decide whether it is reasonable to believe that these are really random
|
|
Maximize the enclosed area
: A farmer wants to enclose a rectangular field along a river on three sides. If 1,200 feet of fencing is to be used, what dimensions will maximize the enclosed area?
|
|
Perpendicular to the line with equation
: Write the equation of the line which passes through (2, -1) and is perpendicular to the line with equation 5y - x = 1.
|
|
Equation to determine the length of time
: When they clean the work station independently, it takes James 10 minutes longer than Nicki. Write and solve an equation to determine the length of time that it takes each of them to the work station on their own.
|