Differences over the effectiveness of budgeting

Assignment Help Managerial Accounting
Reference no: EM132130849 , Length: word count:1000

Task Description

You have gained a position as vacation student at the accounting firm T&K Solutions.

In your capacity of vacation student you have been asked by the two partners of T&K Solutions to assist them with two operational issues they are debating by providing input and analysis.
Specifically;

A. The partners are undecided on whether to keep or drop their bookkeeping service. To facilitate their decision-making they have requested you recalculate last year's profit and loss statement without the bookkeeping service. The partners have asked that you then send them an email clearly stating whether you think they should keep or drop the service. Draw from your calculations as well as non-financial factors to justify your decision.

B. The partners are in disagreement about the value of budgeting for their firm. While Terry has never spent much time on budgeting, Kerry believes that by introducing a flexible budgeting process they will gain a greater level of control over their firm's revenue and expenditure. They have asked you to prepare a flexible budget for each service unit, calculate variances to actual, and present the results using the graph function in Excel.

C. The partners have also asked you to write a report to help them resolve their divided opinions with regard to budgeting. They require you to draw on your own knowledge, industry articles as well as your analysis from Task B.

The Company: T&K Solutions

T&K Solutions is a boutique accounting firm offering taxation, bookkeeping and advisory services to a broad range of clients across the Brisbane and Gold Coast area. The firm was established by Terry Thompson in 1998 as a small suburban accounting firm where he offered taxation and bookkeeping services to local businesses. Terry soon developed a reputation for his expertise in taxation and his client base grew considerably.

A few years ago Terry recognised a growing need for advisory services from his clients. Since this was not Terry's area of expertise he searched for a partner that could provide this service to his clients. In 2014 he met Kerry Chua who was working in consulting and advisory for one of the Big 4 accounting firms. Terry was impressed with Kerry's skills and enthusiasm and invited her to join him as a partner and head of the advisory service. Together, Terry and Kerry rebranded the firm to T&K Solutions. They invested heavily in advertising to promote their new advisory service and relocated the office from the suburbs to the centre of Brisbane. All of these activities added substantial fixed costs to the business but Kerry was confident their investment would pay off.

Kerry was right. Since rebranding and relocating T&K Solutions have tripled their billable hours by expanding their services to existing clients and attracting new clients. However, despite the success and growth in revenue, Terry remains concerned by the increase in their overheads. Furthermore, the most recent profit and loss statement indicates that the bookkeeping division is losing money.

Kerry is frustrated by the lack of planning and control undertaken by the firm and thinks they would benefit from a more thorough budgeting process using flexible budgeting to identify and manage variations between actual and expected outcomes. However Terry thinks budgeting is a waste of time, and often states that "it's impossible to predict the future so what's the point of trying?"

ASSIGNMENT TASKS:

In your role as vacation student, the partners of T&K Solutions have asked you to review, analyse and comment on three areas of their operations. Each task is described for you below;

TASK A:
Determine whether T&K Solutions should drop or continue the bookkeeping service

a) Refer to the ‘Data Task A' sheet in the accompanying Excel workbook.

You have been provided the most recent Profit and Loss Statement for T&K Solutions that shows the bookkeeping service is losing money.
Using the proforma in ‘Schedule 1', re-calculate the 2017 profit for T&K Solutions without the bookkeeping service. Be careful to take into account all additional information provided in the ‘Data Task A' worksheet.
Enter your results into Blackboard.

b) Write an email to Terry and Kerry stating whether you think they should continue to operate or drop the bookkeeping service. Within your email include reference to your calculations from above as well as any relevant qualitative factors that T&K should consider before deciding whether to continue or drop bookkeeping services.

Your email should be no longer than 300 words.

TASK B:

Assist T&K Solutions with flexible budgeting and variance analysis

a) Using the data provided in the ‘Data Task B' worksheet, complete the flexible budget for T&K Solutions and calculate flexible budget variances using the proforma in ‘Schedule 2'. For each variance, indicate if it is U (unfavourable), F (favourable). Enter your results into Blackboard.

b) Using the graph function in excel and the worksheet ‘Budget Graphs', create two separate graphs to visually display;

i) 2018 actual income compared to flexible budget income and prior year (2017) income for each service
ii) Variance by cost category for the firm as a whole

TASK C:

Help Terry and Kerry resolve their differences over the effectiveness of budgeting:

"Budgeting is a waste of time - our business is growing so fast that it's impossible to predict the future, so what's the point of trying?"

-Discuss whether you agree or disagree with this statement made by Terry. Refer to your analysis completed in Task B to support your arguments.

Important notes for your discussion

1. Provide evidence for your arguments by referring to at least one (and maximum three) article(s) from the literature or professional reports.

You may use the Internet and/or QUT's library database to search for relevant articles. Reports and papers from professional or scientific journals/magazines on the topic will serve this purpose well. Note that textbooks such as Horngren et al. (2014) do not qualify as an article.

2. Use the AREA critical thinking framework document on Blackboard under Lecture 2 to structure your discussion. Your discussion should be no longer than two pages (1.5 line spacing).

Attachment:- Accounting Services.rar

Reference no: EM132130849

Questions Cloud

Analyze how knowledge of the spi will help you : Analyze how knowledge of the SPI will help you as a project manager in controlling the project and ensuring that it is completed within the scheduled target.
Why state governments have data security breach notification : Relate state government data security breach notification laws to individual privacy. Why state governments have data security breach notification law.
Define at least two risks to this project : A critical factor is that your company handles secure information for its clients. All employees must pass very detailed background and security clearances.
How enterprise architecture and enterprise systems influence : Describe enterprise architecture (EA), the appropriate application of EA frameworks, and an overall ongoing EA program.
Differences over the effectiveness of budgeting : AYB225 Management Accounting - Determine whether T&K Solutions should drop or continue the bookkeeping service - Write an email to Terry and Kerry stating
Percentile of all 20 year old men heights : Suppose that the height (x), in inches of a 20 year old man is a normal random variable with a mean of 70 inches and standard deviation of 5.102 inches.
What is the shortest wait time : What is the shortest wait time that would still be in the worst 20% of wait times?
Find the probability that the diameter of a selected : Find the probability that the diameter of a selected bearing is greater than 3 inches. (Round your answer to 2 decimals) Please show your work.
What is the probability that the mean of the sample : In a random sample of 45 boards, what is the probability that the mean of the sample will be between 94.5 inches and 95.1 inches?

Reviews

len2130849

10/4/2018 4:09:03 AM

Task C Discussion Criteria 2 – Communication and Structure (PC 3.1) Writing and referencing is concise and accurate. Report is of a professional standard and highly appropriate for the intended audience. All formatting requirements have been adhered to. Writing and referencing is concise and accurate. Report is of a good standard and appropriate for the intended audience. All formatting requirements have been adhered to. Writing and referencing is mostly concise and accurate. Report is of a reasonable professional standard and somewhat appropriate for the intended audience. All formatting requirements have been adhered to. Standard of writing and referencing is fair and mostly accurate. Some attempt at writing for the intended audience. Formatting requirements have been mostly adhered to. Inappropriate standard of writing and referencing. Little or no attempt to address the intended audience. Formatting requirements may not have been adhered to. /4

len2130849

10/4/2018 4:08:57 AM

Task C Discussion Criteria 1. – Budgeting (PC 3.1) Demonstrates professionalism in the application of critical thinking framework to explore the issue and justify the recommendation. Choice of literature is highly appropriate and provides clear evidence in support of the recommendation. Solid application of critical thinking framework to explore the issue and justify the recommendation. Choice of literature is appropriate and provides some evidence in support of the recommendation. A reasonable attempt has been made to apply the critical thinking framework to explore the issue and justify the recommendation. Choice of literature is appropriate and provides some evidence in support of the recommendation. A cursory attempt has been made to apply the critical thinking framework to explore the issue and justify the recommendation. Choice of literature is adequate but the link to evidence in support of the recommendation is weak. Little or no attempt has been made to apply the critical thinking framework to the issue or recommendation. Choice of literature is inappropriate or reference is missing altogether. /8

len2130849

10/4/2018 4:08:48 AM

Task A & B - Correct Use of Excel for Schedules (KS 1.2) Accurate and complete use of formulas. Clear structure and professional presentation. Accurate and mostly complete use of formulas. Clear structure and professional presentation. Accurate but limited use of formulas and unclear structure with reasonable presentation. Excel used without formulas. Limited or no use of Excel. /4

len2130849

10/4/2018 4:08:40 AM

Task B - Correct Use of Excel Graph functions (KS 1.2) Graphs are accurate and appropriate for the data content. Graphs are presented professionally. Graphs are mostly accurate and appropriate for the data content. Graphs are presented professionally. Graphs are somewhat unclear although reasonably presentation. Graphs are unclear and/or unprofessionally presented. Graphs are incomplete or missing. /4

len2130849

10/4/2018 4:08:33 AM

Task B - Flexible budget and variance calculations (KS 1.2) All schedules are completed with total accuracy. All required working is shown throughout. All schedules are completed with only minor errors. All required working is shown throughout. All schedules are completed with varying degrees of accuracy, some significant errors are evident. Most working is shown. All schedules are completed with varying degrees of accuracy, many significant errors are evident. Not all working is shown. Schedules are incomplete or missing and have major inaccuracies. Working is not shown or lacks significant detail. /3

len2130849

10/4/2018 4:08:25 AM

Task A Decision making - Email to Management (HO 2.2) Thorough analysis of the issues related to the facts of the case, demonstrating a high level of judgement and reasoning skills Very good analysis of the issues related to the facts of the case, demonstrating very good judgement and reasoning skills Good analysis of the issues related to the facts of the case, demonstrating good judgement and problem solving skills. Rudimentary analysis of the issues related to the facts of the case, demonstrating fair judgement and problem solving skills. Unsatisfactory analysis of the issues related to the facts of the case, demonstrating limited judgement and problem solving skills. /4

len2130849

10/4/2018 4:08:18 AM

TASK A: DECISION MAKING (Worth 7%) Task A Decision making - Calculations (KS 1.2) All calculations are completed with total accuracy. All required working is shown throughout. All calculations are completed with only minor errors. All required working is shown throughout. Calculations are completed with varying degrees of accuracy, some significant errors are evident. Most working is shown. Calculations are completed with varying degrees of accuracy, many significant errors are evident. Not all working is shown. Calculations are incomplete or missing and have major inaccuracies. Working is not shown or lacks significant detail. /3

len2130849

10/4/2018 4:08:04 AM

• Figures in the schedules (1 and 2) can be entered and checked on Blackboard up to 3 times per student. It will indicate if your answer is correct or not. Zero marks will indicate that the answer is wrong. Research and referencing • Use in-text citations in your discussion in Task C. At the conclusion of your discussion and under the title “references”, give the source of the evidence, i.e. name of the author, year, title, and name of source. Please adhere to the APA or Harvard referencing style.

len2130849

10/4/2018 4:07:56 AM

In addition to the tasks the partners of T&K Solutions have asked you to complete, they have indicated that there are a few issues you are not to include: • Use all data as given, including all the fixed overhead figures without trying to fine-tune those figures in any way. • The partners have stressed that your responses to the questions should be based only on the facts with which you have been provided. Do not go outside these facts.

len2130849

10/4/2018 4:07:48 AM

• You are eligible for up to 4 additional marks for your workings in Excel. • To achieve all 4 marks you need to use formulas in your calculations. The formulas will need to refer to other cells in the worksheet that either contain the original values from the ‘Data’ worksheets or to formulas and calculations from a previous step. This means, every time the values in the data sheet are changed, the results are updated automatically. • To be clear, all worksheets are to be completed using formulas that draw values from the data provided. Cells should not contain numerical values, rather all values should obtained using an Excel formula.

len2130849

10/4/2018 4:07:33 AM

Your submission has three parts. All parts must be submitted to Blackboard by the due date and time for a complete submission of this assessment item. Refer to the instructions on Blackboard under Assessment Item 2 regarding uploading of files. 1) Uploading of Files into Blackboard The following files must be uploaded into Blackboard: a) Email to Partners from Task A b) Excel file containing the completed Schedules from Task A & Task B c) Discussion Question from Task C Make sure you check your files once uploaded to ensure it is readable. No marks will be given for submissions where the file is corrupt and unreadable.

Write a Review

Managerial Accounting Questions & Answers

  How are the large losses related to fixed costs

Expand on Johns thought. How are the large losses related to fixed costs?  Identify a way that John can turn potential fixed costs into variable costs.

  Are there any qualitative factors that might enter

Assuming that Susan would be equally happy with either the Ford Focus or the Honda Civic, should she buy the Civic or repair the Focus? Explain your answer.

  The sparklin automotive company sac has been in business

the sparklin automotive company sac has been in business since 1930. it began business in the united states supplying

  How much net operating income would increase

A study by the sales manager discloses that a 15% increase in the selling price would reduce unit sales by 10%. If her proposal is adopted, how much net operating income would increase?

  The after tax project cash flow including

The after tax project cash flow including the terminal cash flow for the project in year 3 is?

  Indicate three production costs that are likely

Indicate three production costs that are likely to increase because of the addition of a second production shift.

  Memorial hospital is considering the acquisition

Memorial Hospital is considering the acquisition of a new diagnostic scanning machine.

  Components of cost-volume-profit analysis

Describe the components of cost-volume-profit analysis. Employ cost-volume-profit analysis and break-even analysis to make business decisions.

  Which of the variances should be of concern to management

Which of the variances should be of concern to management?Explain.

  Information as to why its estimates were so substantially

Which company's estimate of useful life more closely reflects reality? Will you feel comfortable as a passenger in a 25-year old airplane? Does the fact that Airline Y subsequently went out of business provide any information as to why its estimates ..

  What was the cost of goods manufactured for the month

Last month a manufacturing company had the following operating results. What was the cost of goods manufactured for the month?

  What is the market value of a bond

What is the market value of a $1,000 bond, which has a coupon interest rate of 8% and will mature in 20 years if it is discounted at 6%? Interest is paid annually.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd