7. Lockbox analysis

Walking down the hallway to the executive conference room, Akiko Burke, the chief financial officer of Spices Sugar Producers Inc. (SSPI), is talking with Eli Robinson, her administrative assistant and protege.

Read their dialogue and correctly fill in the missing information.

CFO: Im a little anxious about your presentation to the Finance Committee on Thursday, so Id like you to run through your comments and presentation slides with me. Because three board members, including the chair and the president, will be attending, I want you to make a very favorable impression. It could mean a great deal to your career with SSPI. An upgrade in our receivables collection system could have a significant effect on both SSPIs (customer-bank or company bank) relationship and income stream.

ELI: Yes, I have my notes and the flash drive with my presentation right here. Let me get things organized and Ill begin.

After a slight delay, Eli begins his presentation:

Good morning. I would like to present to you the findings of our recent evaluation of the system currently used to collect receivables payments from our customers east of the Mississippi River. With our corporate headquarters in Oklahoma City, Oklahoma, we currently have broken down the country into two regions: the portion east of the Mississippi River and the portion west of the river. We have also conducted an evaluation of a proposed lockbox system that would break down our customer base into six geographic subregions, with each being served by a lockbox collection center. These collection centers would then transfer the funds to our main concentration account here in Oklahoma City.

Slide 1 shows you the key attributes of our current system.

	Slide #1: Key Attributes of SSPIs Current Collection System (Eastern Region, Last Years Data)
1.	Our eastern region customers, stores that sell our colored sugar chips and granulated and powered products, remit 5,500 checks per month to our office in Oklahoma City.
2.	Annual collections for the region were $45,625,000.
3.	The average delay due to float was 15 days (8 days mail float, 4 days processing float, and 3 days clearing float).
4.	Our Oklahoma City bank currently charges $24,000 per year in service charges and fees of $0.25 per payment to process these payments.
5.	SSPI maintains a marketable securities portfolio that earns an average return of 3.5.

CFO: Okay, lets stop here for a second. I have a question. How much does our current system cost us?

ELI: Maam, youre getting ahead of me a little; that information is detailed on slide 2. Let me show you.

	Slide #2: Costs of SSPIs Current Collection System (Eastern Region, Last Years Data)
	Annual service charges = $24,000
	Annual per-payment processing fees = (23,100, 16,500, 9,900)
	Cost of the current system = (47,100, 40,500, 33,900)

CFO: Good. Whats next?

ELI: In contrast to the existing system, our Oklahoma City bank has offered to create a lockbox system that would involve customers sending their payments directly to (the company's branch office, a designated post office box, a designated bank account) in their region. The banks will process the deposits and then wire the funds to our bank in Oklahoma City. The specifics of the proposal are detailed in slide 3.

	Slide #3: Costs of SSPIs Proposed Lockbox System
1.	The average delay due to float will be reduced to 3 days (2 days mail float; no processing float; 1 day clearing float, including the wire transfer delay).
2.	The bank will eliminate its current service charges and fees but will impose a compensating balance of $40,000 on our Oklahoma City account. Similar balances will not be required in the other six banks.
3.	Funds released by the lockbox system will be invested in marketable securities and will earn an average return of 3.5.

CFO: So, should we switch from our current (centralized or decentralized) collection system to the lockbox system?

ELI: Yes, I think we should. The benefit to the lockbox system is that it saves us (15 days, 12 days, 6 days) of float. Wait, let me show you slide 4.

	Slide #4: Evaluation of SSPIs Proposed Lockbox System
	Average collections =$125,000
	Released funds = (1,500,000, 1,875,000, 3,750,000)
	Income earned from the released funds = (1,596,875, 52,500, 5,250,000)
	Cost of lockbox system = (32,000, 40,000, 80,500)
	Net earnings on the lockbox system = (1,564,875, 12,500, 5,169,500)
	Net value of the lockbox system over the current system = (1,524,375, 53,000, 5,129,000)

CFO: So, now I have three questions. First, based on these values, how does the Finance Committee know whether to recommend accepting the lockbox proposal? That is, how should we interpret these values? Second, should we give up our current system and switch to the lockbox system? And finally, are there any other methods that SSPI could use instead of a lockbox system to return customer funds to the Oklahoma City bank account?

ELI: First, the general rule that determines whether to implement the lockbox system is this: If the net benefits are (greater than or equal to zero) , then accept the proposal.

Therefore, based on this criterion, (no, we should not switch or yes, we should switch) to the lockbox system.

And last, as far as alternative methods are concerned, several choices are available, including (wire transfers for customers to the Oklahoma City bank, a courier who would hand carry checks from customers to the bank, or preauthorized checks drawn on the company's account) .

CFO: Overall, Eli, youve done a very good job! Now, take it easy this evening and get some rest so that youre ready for tomorrows presentation. Ill see you about an hour before the meeting.

Please answer all the bolded areas which are provided with the options. I'm a stressed out college student, I really don't want to see "I can answer only 2 questions." Please answer all, and if you are only willing to do 2 answers, please don't waste my post, let someone that will complete it all do it, please. I really need help with this, thank you.