Ask Homework Help/Study Tips Expert

Module 6 CT

Chapter 15 Problem 2

James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank.  The company has produced sales estimates, and these appear in the worksheet below.

Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month following the one in which these costs have been incurred.

General and administrative salaries will amount to approximately $27,000 a month; lease payments under long-term lease contracts will be $9,000 a month; depreciation charges will be $36,000 a month; miscellaneous expenses will be $2,700 a month; income tax payments of $63,000 will be due in both September and December; and a progress payment of $180,000 on a new building must be paid in October.

Cash on hand on July 1 will amount to $132,000, and a minimum cash balance of $90,000 will be maintained throughout the cash budget period. What loan will be the company require in October?






May

June

July

August

September

October

November

December

January

Collections worksheet:













Billed charges



$180,000

$180,000

$360,000

$540,000

$720,000

$360,000

$360,000

$90,000

$180,000


Collections













Within 30 days













30-60 days













60-90 days













Total collections












 

Supplies worksheet:













Amount of labor and supplies


$90,000

$90,000

$126,000

$882,000

$306,000

$234,000

$162,000

$90,000


Payments made for labor and supplies









 

Net cash gain (loss):


Total collections


Total purchases


General and administrative salaries


Lease payments


Miscellaneous expenses


Taxes


Progress payment


Total payments


Net cash gain/loss

 

Borrowing/surplus summary:


Cash at beginning with no borrowing


Cash at end with no borrowing


Target cash balance (given)


Cumulative surplus cash / loan balance

Chapter 15 Problem 5

Suppose one of the suppliers to Seattle Health System offers terms of 3/20, net 60.

a. When does the system have to pay its bills from this supplier?

b. What is the approximate percentage cost of the costly trade credit offered by this supplier?  (Assume 360 days per year.)

Chapter 15 Problem 6

Langley Clinics, Inc., buys $400,000 in medical supplies a year (at gross prices) from its major supplier, Consolidated Services, which offers Langley terms of 2.5/10, net 45. Currently, Langley is paying thesupplier the full amount due on Day 45, but it is considering taking the discount, paying on Day 10, andreplacing the trade credit with a bank loan that has a 10 percent annual cost.

a. What is the amount of free trade credit that Langley obtains from Consolidated Services? (Assume360 days per year throughout this problem.)

b. What is the amount of costly trade credit?

c. What is the approximate annual percentage cost of the costly trade credit?

d. Should Langley replace its trade credit with the bank loan? Explain your answer.

e. If the bank loan is used, how much of the trade credit should be replaced?

Chapter 15 Problem 8

Fargo Memorial Hospital has annual net patient service revenues of $14.4 million. The hospital's patientaccounts manager estimates that 10 percent of third party payers pay on Day 30, 60 percent pay on Day 60,and 30 percent pay on Day 90.

a. What is Fargo's average collection period? (Assume 360 days per year throughout this problem.)

b. What is the firm's current receivables balance?

c. What would be the firm's new receivables balance if a newly proposed electronic claims system resultedin collecting from third-party payers in 45 and 75 days, instead of in 60 and 90 days?

d. Suppose the firm's annual cost of carrying receivables was 10 percent. If the electronic claims systemcosts $30,000 a year to lease and operate, should it be adopted? (Assume that the entire receivablesbalance has to be financed.)

Chapter 15 Problem 9

Jones Surgicenter uses 90,000 bags of IV solution annually. The optimal safety stock (which is on handinitially) is 1,000 bags. Each bag costs the center $1.50, inventory carrying costs are 20 percent, andthe cost of placing an order with the supplier is $15.

a. What is the economic order quantity?

b. What is the maximum inventory of IV solution bags?

c. What is the center's average inventory of IV solution bags?

d. How often must the center order (in days)?

Attachment:- Assignment Instruction.rar

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M93038479
  • Price:- $65

Priced at Now at $65, Verified Solution

Have any Question?


Related Questions in Homework Help/Study Tips

Review the website airmail service from the smithsonian

Review the website Airmail Service from the Smithsonian National Postal Museum that is dedicated to the history of the U.S. Air Mail Service. Go to the Airmail in America link and explore the additional tabs along the le ...

Read the article frank whittle and the race for the jet

Read the article Frank Whittle and the Race for the Jet from "Historynet" describing the historical influences of Sir Frank Whittle and his early work contributions to jet engine technologies. Prepare a presentation high ...

Overviewnow that we have had an introduction to the context

Overview Now that we have had an introduction to the context of Jesus' life and an overview of the Biblical gospels, we are now ready to take a look at the earliest gospel written about Jesus - the Gospel of Mark. In thi ...

Fitness projectstudents will design and implement a six

Fitness Project Students will design and implement a six week long fitness program for a family member, friend or co-worker. The fitness program will be based on concepts discussed in class. Students will provide justifi ...

Read grand canyon collision - the greatest commercial air

Read Grand Canyon Collision - The greatest commercial air tragedy of its day! from doney, which details the circumstances surrounding one of the most prolific aircraft accidents of all time-the June 1956 mid-air collisio ...

Qestion anti-trustprior to completing the assignment

Question: Anti-Trust Prior to completing the assignment, review Chapter 4 of your course text. You are a manager with 5 years of experience and need to write a report for senior management on how your firm can avoid the ...

Question how has the patient and affordable care act of

Question: How has the Patient and Affordable Care Act of 2010 (the "Health Care Reform Act") reshaped financial arrangements between hospitals, physicians, and other providers with Medicare making a single payment for al ...

Plate tectonicsthe learning objectives for chapter 2 and

Plate Tectonics The Learning Objectives for Chapter 2 and this web quest is to learn about and become familiar with: Plate Boundary Types Plate Boundary Interactions Plate Tectonic Map of the World Past Plate Movement an ...

Question critical case for billing amp codingcomplete the

Question: Critical Case for Billing & Coding Complete the Critical Case for Billing & Coding simulation within the LearnScape platform. You will need to create a single Microsoft Word file and save it to your computer. A ...

Review the cba provided in the resources section between

Review the CBA provided in the resources section between the Trustees of Columbia University and Local 2110 International Union of Technical, Office, and Professional Workers. Describe how this is similar to a "contract" ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As