Question

In: Accounting

appy Pets is veterinary clinic operating in Auckland. RecentlyJohn Tilley, the manager of the clinic, has...

appy Pets is veterinary clinic operating in Auckland. RecentlyJohn Tilley, the manager of the clinic, has been concerned about cash flow shortages, which arose quite unexpectedly in the last three months of the past year. the clinic ban account went into overdraft and incurred interest charges. Tilley believes that the main source of cash flow difficulties is a lack of attention to outstanding client accounts and the practice of purchasing expensive veterinary supplies in large quantities at irregular intervals.

Tilley has asked you to help design a spreadsheet to help with planning for clients consultations, purchases of supplies,cash shortages and cash surluses for the next year. The following data are available:

Revenue earned for the past and budget year is as follows:

Nov $ 200,000 (actual)

Dec 225,000 (actual)

Jan 75,000 (budget)

Feb 225,000 (budget)

Mar 200,000 (budget)

During the past year, 50% of consultation revenue was collected in the month of the veterinary visit, 20% in the following month. 20% in the second month, and 10% was not recevived. In budget year, new credit policies are expected to result in collections of 60%. 20%, 10% and 10% respectively.

The cost veterinary supplies was $75,000 in Dec and is budgeted as $125,000 in Feb. Half of the suppliers' accounts are paid in the month they are incurred and half in the following month. Salaries of $100,000 per month and other costs of $75,000 are paid in the month they are incurred.

1. use Excel to create a spreadsheet to complete a cash budget for Jan to Mar of the budget year, using the format below.

Cash budget

Jan Feb Mar

Openning cash balance $(200,000)

Cash received from consultations

Two months ago

Last month

Current month

Total cash receipts

Cash payment

Supplies:

Previous month purchases

Current month purchases

Salaries

Other costs

Total Cash payments

Closing Cash balance

2. What further steps could tilley take to help ensure that the cash balance of the clinic remains positive? In your answer, consider ways in in which budgeting may assist.

Solutions

Expert Solution


2). For maintaining cash balance positive, Tilley should try to make cash payments when there is surplus cash available in excess of a particular limit. Supplies should be purchased in the month when there is excess availability of cash and should instant payment or try to buy supplies in small quantities but regularly which will decrease the cash outflow in a single payment. Further Tilley should try to recover consultation payments as soon as possbile and try to reduce the % of baddebts.


Related Solutions

Schatzie’s is a veterinary clinic. At the beginning of July, the clinic had $720 of veterinary...
Schatzie’s is a veterinary clinic. At the beginning of July, the clinic had $720 of veterinary supplies on hand. The following information is available for July 2009. Salaries for veterinary staff.............................................. $32,000 Salaries for veterinary assistants....................................... 12,000 Salary for receptionist..................................................... 2,500 Wages for office workers.............................................. 6,000 Veterinary supplies purchased in July............................ 9,600 Veterinary supplies on hand on July 31............................. 1,150 Depreciation on hospital and lab equipment........................ 8,600 Depreciation on office equipment...................................... 3,000 Building rent (60% related to treatment) .............................. 3,600...
Simone Cherniak has just completed the second year of operating her veterinary clinic. You have been...
Simone Cherniak has just completed the second year of operating her veterinary clinic. You have been retained by Cherniak for tax assistance and advice. At a recent meeting, you gathered information on her practice, which is presented below. For the year ended December 31, 2019, the clinic showed a profit of $149,700, as follows: Professional service $388,400 Gross profit from surgical instrument sales 33,900 $422,300 Administration and other expenses (276,200) 146,100 Interest income 3,600 Net income $149,700 Included in the...
Ava Miller has just completed the second year of operating her veterinary clinic. You have been...
Ava Miller has just completed the second year of operating her veterinary clinic. You have been retained by Ava for tax assistance and advice. At a recent meeting, you gathered information on her practice, which is presented below. For the year ended December 31, 2020, the clinic showed a profit of $123,700, as follows: Professional service $321,000 Gross profit from surgical instrument sales 28,000 $349,000 Administration and other expenses (228,300) 120,700 Interest income 3,000 Net income $123,700 Included in the...
A new veterinary clinic will like to set up their database. The clinic will like to...
A new veterinary clinic will like to set up their database. The clinic will like to keep record of their customers such as: pet name, pet type, pet age, pet weight, owner name, owner address, owner contact. Also the clinic will like to keep track of the veterinarian name, specialty and schedule. They will like to keep track of the customer appointment date, what the appointment is for, and how much it will cost. List all of the data that...
What are the functions or applications of bandages in a veterinary clinic?
What are the functions or applications of bandages in a veterinary clinic?
Clinic has had a privacy breach. The clinic manager has asked you to speak to the...
Clinic has had a privacy breach. The clinic manager has asked you to speak to the staff about emerging privacy threats and what administrative and physical factors can be addressed to reduce privacy risks to health information.
This table is used by Mighty Paws Veterinary Clinic. Inspect this table and answer questions below...
This table is used by Mighty Paws Veterinary Clinic. Inspect this table and answer questions below and answer the following 4 questions: PetId PetName OwnerName OwnerPhone PetType Legs CanFly Favorite food 100 Fluffy Mary Smith 614-897-5496 Cat 4 No MeowMix, FancyCatTM 101 Casper Mary Smith 614-897-5496 Cat 4 No MeowMix 102 Lori Jim Larson 740-851-0023 Parrott 2 Yes Seeds 103 Marty Kim Jones 212-505-8578 Python 0 No 104 Oscar Tim Wang 614-410-5535 Dog 4 No IAMS, Tim’s new sneakers List...
Dr. Knights, DVM, opened a veterinary clinic on May 1, current year. The business transactions for...
Dr. Knights, DVM, opened a veterinary clinic on May 1, current year. The business transactions for May are shown as follows. May 1 Dr. Knights invested $480,000 cash in the business in exchange for 6,000 shares of capital stock. May 4 Land and a building were purchased for $300,000. Of this amount, $84,000 applied to the land, and $216,000 to the building. A cash payment of $120,000 was made at the time of the purchase, and a note payable was...
During October 2016, Paws Veterinary Clinic completed the following transactions: Prepare the trial balance of Paws,...
During October 2016, Paws Veterinary Clinic completed the following transactions: Prepare the trial balance of Paws, at October 31, 2016. Oct. 1 Paws received $30,000 cash and issued common shares to shareholders 4 Purchased supplies, $1,000, and equipment, $2,600 on account 5 Performed checkup services, and received cash, $1,500 7 Paid cash to acquire land for an office site, $22,000 11 Performed a surgery on a sick cat, and billed the customer $500 16 Paid for the equipment, purchased Oct...
Practice Problem 1 On August 31, the balance sheet of La Brava Veterinary Clinic showed Cash...
Practice Problem 1 On August 31, the balance sheet of La Brava Veterinary Clinic showed Cash $11,000, Accounts Receivable $3,700, Supplies $600, Equipment $6,000, Accounts Payable $5,600, Common Stock $14,850, and Retained Earnings $850. During September, the following transactions occurred. 1. Paid $2,350 cash for accounts payable due. 2. Collected $2,000 of accounts receivable. 3. Purchased additional equipment for $3,050, paying $900 in cash and the balance on account. 4. Recognized revenue of $8,100, of which $3,500 is collected in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT