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

  Assume gail is a wealthy widow whose husband died last year

assume gail is a wealthy widow whose husband died last year. her dependent daughter lives with her for the entire year.

  Compute the rental cost for each full month

On September 1, North Hampton Industries signed a six-month lease for office space, Compute the rental cost for each full month

  Explain an accrual based income statement

Briefly discuss some of the differences between a cash flow statement and an accrual based income statement.

  Write up in the company books the necessary ledger account

A sand and gravel company are engaged in working a sand pit. On 1st January, 1956, it entered into an agreement with the owner of the land in which the sand.

  Present value of future sales

A new ice cream machine has been added to Dairy Queen - It is expected to add $100,000 in sales in year 1 increasing by $25,000 per year thru year 10 ( 10years total) what is the present value of these future sales if interest is 8%

  How does katie need to budget for direct labor each month

Katie pays her cleaning staff $12.50/hour. If each location is cleaned once per week, how much does Katie need to budget for direct labor each month?

  Contrast the primary focus of job order costaccountingand

1. contrast the primary focus of job order costaccountingand of process cost accounting.2. what are the similarities

  In a visit to a used car dealer kim found a four year old

kim murphy purchased a 1997 lebaron convertible in 2005 for 5000. since purchasing the car she has spent the following

  Discuss the term future worth

Your company is looking at purchasing a dump truck at a cost of $65,000. The truck would have a useful life of five years.

  Refer to the statement of shareholders equity did the

refer to the balance sheet and statement of shareholders equity of the company youve selected to analyze. research and

  Examples of qualitative factors

Give three examples of qualitative factors that might affect the preliminary judgment about materiality. How do inherent risk and control risk differ from detection risk? List and define the seven types of audit evidence.

  What is the dollar effect of the year end bad debt

What is the dollar effect of the year-end bad debt adjustment on the before-tax income?

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