Budgeting and Planning

Budgeting and Planning
After reading the case of Dr Roger Jones’s dental business (refer to attached word document), write a report in an essay format with 1500 words in attempt to address the 5 questions stated below. You will need to include a short introduction in the beginning and a conclusion paragraph at the end. This assignment will test your understanding in areas of “budgeting and planning” and the concept of “cash budgets”.

Q1. Prepare a monthly cash budget for Dr Jones (showing 12 months data). Hint: Expenses that are accrued (non-cash) will not be relevant for analysis (i.e. depreciation). You may make your own assumptions on the costs as long as it makes sense.

Q2. Does Dr Jones have a significant cash flow problem? How would you use the budget to show Dr Jones why he is having financial difficulties?

Q3. Using the cash budget prepared in Question 1 and the information given in the case, recommend actions to solve Dr Jones’ financial problems.

Q4. Prepare a revised cash budget that reflects these recommendations and demonstrates to Dr Jones that the problems can be corrected.

Q5. Do you think that Dr Jones will accept your recommendations? Do any of the behavioural principles on budgeting have a role in this type of setting? Explain your answer.

Assignment problem:

According to the analysis of a local consultant, the financial difficulties of Dr Roger Jones have been caused by the absence of proper planning and control. Budgetary control is sorely needed. To assist you in preparing a plan of action that will help his dental practice to regain financial stability, Dr Jones has made available the financial information describing a typical month in the following table:

Assumption: Revenue and cost data shown below are based on per month basis.
Benefits include Dr Jones’ share of social security and a health insurance premium for all employees. Although all revenues billed in a month are not collected, the cash flowing into the business is approximately equal to the month’s billing because of collections from prior months. The dental office is open Monday to Thursday from 8.30 a.m. to 4.00 p.m. and on Friday from 8.30 a.m. to 12.30 p.m. A total of 32 hours are worked each week. Additional hours could be worked, but Dr Jones is reluctant to do so because of other personal endeavours that he enjoys.

Dr Jones has noted that the two dental assistants and the receptionist are not fully utilized. He estimates that they are busy about 65-70% of the time. Dr Jones’ wife spends about five hours each week on a monthly newsletter that is sent to all patients; she also maintains a birthday list and sends cards to patients on their birthdays.
Dr Jones spends about $2,400 yearly on informational seminars. These seminars targeted especially for dentists, teach them how to increase their revenues. It is from one of these seminars that Dr Jones decided to invest in promotion and public relations (the newsletter and the birthday list).


Open chat
💬 Need help?
Hey there! 👋
Need help with this assignment?
Or any other?
PM us on WhatsApp.