Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

E9.27 Cash budgeting: veterinary clinic Happy Pets is a veterinary clinic operating in Auckland, Recently John Tilley, the manager of the clinic, has LO9.7 been

image text in transcribed
E9.27 Cash budgeting: veterinary clinic Happy Pets is a veterinary clinic operating in Auckland, Recently John Tilley, the manager of the clinic, has LO9.7 been concerned about cash flow shortages that arose quite unexpectedly in the last three months of the past year. The clinic's bank account went into overdraft and Incurred Interest charges, Tilley believes that the main source of the cash flow difficulties is a lock of attention to outstanding client accounts and the practice of purchasing expensive veterinary supplies in large quantities at irregular intervals. 456 PART THREE INFORMATION FOR MANAGING RESOURCES Tilley has asked you to help design a spreadsheet to help with planning for client consultations, purchases of supplies, cash shortages and cash surpluses for next year. The following data are available: Revenue is as follows: November $200 090 (actual) December 225 000 (actual) January 75 000 (budget) February 225 000 (budget March 200 000 (budget) During the past year, 50 per cent of consultation revenue was collected in the month of the veterinary visit, 20 per cent in the following month, 20 per cent in the second month, and 10 per cent was not received. In the budget year, new credit policies are expected to result in collections of 60 per cent, 20 per cent, 10 per cent and 10 per cent, respectively. The cost of veterinary supplies was $75 000 in December and is budgeted as $125 000 in February. 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. Required: 1:Use Excel to create a spreadsheet to complete a cash budget for January to March of the budget year, using the format below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel Applications For Accounting Principles

Authors: Gaylord SmithBruce Walz

4th Edition

1133388027, 9781133388029

More Books

Students also viewed these Accounting questions

Question

6.57 Find a zo such that a. P(zzo) 0.9750 b. P(zzo) 0.3594

Answered: 1 week ago

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago