Prepare a budget sensitivity analysis for the business

Assignment Help Accounting Basics
Reference no: EM132305453

TASK DESCRIPTION

You have gained a position as vacation student at an accounting firm; T&K Accounting Services.

T&K Accounting Services offers taxation and bookkeeping services to a broad range of clients across Brisbane. The firm was established in 2008 by Terry Thompson and Kerry Chua who met while studying at Queensland University of Technology. Recently Terry and Kerry have recognised a growing need for advisory services from their clients and they have decided to create a new business advisory department. Kerry is very optimistic about the new service and has put forward a plan to invest heavily in advertising and relocate to a larger and more prestigious office in the centre of Brisbane. Terry agreed to this plan however he remains concerned these activities will add substantial fixed costs to the business. Moreover, Terry is worried the forecast for billable hours that Kerry has provided for the new business advisory department may be over optimistic. Kerry, however, remains confident that there is strong demand for business advisory services and that their investment will pay off.

In your capacity, as vacation student, you have been asked by the two partners of T&K Services to assist them in evaluating their decision to introduce the new business advisory service by preparing the budget for the coming year (2019) along with a sensitivity analysis to illustrate how changes to the forecast demand for the business advisory department may affect profit for the coming year.

In the past the partners have paid little attention to how support costs are allocated between each department, choosing instead to adopt a simplistic approach whereby most costs are simply split evenly between the departments. However, with the addition of the business advisory department, the partners want to review this method of allocation and wonder whether an activity based costing system for allocating support costs would be more beneficial. To assist with their decision, they have asked you to prepare a comparison of allocated support costs under both methods. They have asked that you prepare a management report that weighs up the costs and benefits of each system and a recommendation on which method should be used going forward.

ASSIGNMENT TASKS:

In your role as vacation student, the partners of T&K Accounting Services have asked you to review, analyse and comment on two areas of their operations. The requirements for each task are described for you below;

TASK A:

Assist T&K with Budgeting and Sensitivity Analysis

a) Using the data provided in the ‘Data - 2018 Actuals' and ‘Data - 2019 Budget Assumptions' worksheets of the student workbook, complete a budget for T&K Accounting Services for the year ending 31 December 2019.

Complete your calculations using Schedule 1 provided in the student workbook

b) Prepare a Budget Sensitivity Analysis for the Business Advisory Department. Consider the following three scenarios related to the 2019 budgeted billable hours for the business advisory department, and calculate the change in net profit for the business advisory department under each scenario:

i) 10% reduction in budgeted billable hours
ii) 20% reduction in budgeted billable hours
iii) 40% reduction in budgeted billable hours

Complete your calculations using Schedule 2 provided in the student workbook

c) Write an email to the partners of T&K evaluating their decision to add the business advisory department. Justify your reasons using your calculations in (a) and (b) above.

Write your email using the proforma provided on blackboard. Your email should be no longer than 400 words

TASK B:

Assist T&K with their Indirect Cost Allocation Method

a) Using the data provided in the ‘Data - ABC' worksheet of the student workbook along with your own calculations in Schedule 1, prepare a comparison of the 2019 budgeted allocation of support costs under the existing method and an activity based approach.

For each of the three service departments calculate and compare;
(a) Total overhead allocated under the current method
(b) Total overhead allocated using an activity based costing method
(c) Total budget net profit using the current method
(d) Total budget net profit using an activity based costing method

Complete your calculations using Schedule 3 provided in the student workbook

d) Prepare a report advising which method of allocating support costs you recommend going forward i.e. the existing method or an ABC method.
- Justify your response by drawing from your calculations from (a) as well as your knowledge from studying AYB225.

Write your report using the proforma provided on blackboard. Your report should be no longer than 600 words

Attachment:- Management Accounting.rar

Reference no: EM132305453

Questions Cloud

What are the options available regarding treatment : What are the options available regarding treatment of an amount paid in excess of the FMV of an acquired company's net assets?
What are the issues for calfornia businesses : What are the issues for Calfornia businesses breaking into the Japanese marketplace, recommendations and an outlook on the future trade with Japan?
Impact of a laissez faire leadership style : What is the organizational impact of a laissez faire leadership style
Identify a business problem related with operations : SCM 540 - Operations and Supply Chain Management - Abu Dhabi University - identify a business problem related with operations and supply chain management
Prepare a budget sensitivity analysis for the business : AYB225 - Management Accounting - Queensland University of Technology - Prepare a Budget Sensitivity Analysis for the Business Advisory Department
How do you think this translates in the real world : • What were the main barriers you saw to creating consensus in this Simulation? How do you think this translates in the real world?
Is democracy the best form of government : What are the major criticisms of democratic rule? Explain the major challenges to democratization in the developing countries.
Compare the emergence and development of populism : Compare and contrast the emergence and development of Populism (1930s-1950s) in the two countries of your choice, if relevant.
Analyze this leader in terms of moral intelligence : Analyze this leader in terms of moral intelligence and credibility as a leader, citing evidence to support your perspectives.

Reviews

len2305453

5/14/2019 4:40:00 AM

This assignment is an individual assignment. This means you cannot collaborate with anyone in any way in the completion of the Excel schedules and the answers. Submission Requirements: 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. The following files must be uploaded into Blackboard: 1. Email to Partners from Task A 2. Management Report from Task B 3. Excel file containing the completed Schedules from Task A & Task B 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.

len2305453

5/14/2019 4:39:50 AM

Knowledge and Technological Skills (KS) 1.2 Apply technical and technological skills appropriate and effective for real world business purposes and contexts. Higher Order Thinking (HO) 2.2 Exercise independent judgment and initiative in adapting and applying knowledge and skills for effective planning, problem solving and decision making in diverse contexts. Professional Communication (PC) Use information literacy skills, and communicate effectively and professionally in written forms and using media appropriate for diverse purposes and contexts.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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